Query time 0.00506
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "500.41"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "98.00"
},
"nested_loop": [
{
"table": {
"table_name": "q_images_links",
"access_type": "range",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type",
"type"
],
"key_length": "81",
"rows_examined_per_scan": 98,
"rows_produced_per_join": 98,
"filtered": "100.00",
"index_condition": "((`portal`.`q_images_links`.`object_type` = 'product') and (`portal`.`q_images_links`.`type` = 'A') and (`portal`.`q_images_links`.`object_id` in ('790','789','788','787','786','785','784','783','782','781','780','779','778','777','776','775','774','773','772','771','770','769','768','767','766','765','764','763','762','761')))",
"cost_info": {
"read_cost": "147.61",
"eval_cost": "19.60",
"prefix_cost": "167.21",
"data_read_per_join": "9K"
},
"used_columns": [
"pair_id",
"object_id",
"object_type",
"image_id",
"detailed_id",
"type",
"position"
]
}
},
{
"table": {
"table_name": "q_images",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"image_id"
],
"key_length": "4",
"ref": [
"portal.q_images_links.detailed_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 98,
"filtered": "100.00",
"cost_info": {
"read_cost": "98.00",
"eval_cost": "19.60",
"prefix_cost": "284.81",
"data_read_per_join": "75K"
},
"used_columns": [
"image_id",
"image_path",
"image_x",
"image_y",
"is_high_res"
],
"attached_condition": "<if>(is_not_null_compl(q_images), (`portal`.`q_images_links`.`detailed_id` = `portal`.`q_images`.`image_id`), true)"
}
},
{
"table": {
"table_name": "q_common_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"lang_code",
"object_holder"
],
"key_length": "107",
"ref": [
"portal.q_images.image_id",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 98,
"filtered": "100.00",
"cost_info": {
"read_cost": "98.00",
"eval_cost": "19.60",
"prefix_cost": "402.41",
"data_read_per_join": "58K"
},
"used_columns": [
"object_id",
"description",
"lang_code",
"object_holder"
],
"attached_condition": "<if>(is_not_null_compl(q_common_descriptions), (`portal`.`q_common_descriptions`.`object_id` = `portal`.`q_images`.`image_id`), true)"
}
}
]
}
}
}
Result
image_id |
image_path |
image_x |
image_y |
is_high_res |
pair_id |
object_id |
object_type |
detailed_id |
type |
position |
alt |
images_image_id |
0 |
IMG_7009.JPG |
1000 |
1000 |
N |
1789 |
761 |
product |
3765 |
A |
1 |
|
3765 |
0 |
IMG_6241.JPG |
6240 |
4160 |
N |
1794 |
762 |
product |
3770 |
A |
1 |
|
3770 |
0 |
IMG_6256.JPG |
1000 |
1000 |
N |
1800 |
763 |
product |
3776 |
A |
1 |
|
3776 |
0 |
IMG_6264.JPG |
1000 |
1000 |
N |
1805 |
764 |
product |
3781 |
A |
1 |
|
3781 |
0 |
IMG_6273.JPG |
1000 |
1000 |
N |
1810 |
765 |
product |
3786 |
A |
1 |
|
3786 |
0 |
IMG_6280.JPG |
1000 |
1000 |
N |
1814 |
766 |
product |
3790 |
A |
1 |
|
3790 |
0 |
IMG_6287_ty4e-gd.JPG |
1000 |
1000 |
N |
1820 |
767 |
product |
3796 |
A |
1 |
|
3796 |
0 |
IMG_6287_7fgh-w7.JPG |
1000 |
1000 |
N |
1825 |
768 |
product |
3801 |
A |
1 |
|
3801 |
0 |
IMG_6303_p9x5-qf.JPG |
1000 |
1000 |
N |
1830 |
769 |
product |
3806 |
A |
1 |
|
3806 |
0 |
IMG_6311.JPG |
1000 |
1000 |
N |
1836 |
770 |
product |
3812 |
A |
1 |
|
3812 |
0 |
IMG_6319.JPG |
1000 |
1000 |
N |
1841 |
771 |
product |
3817 |
A |
1 |
|
3817 |
0 |
IMG_6328.JPG |
1000 |
1000 |
N |
1847 |
772 |
product |
3823 |
A |
1 |
|
3823 |
0 |
IMG_6334.JPG |
1000 |
1000 |
N |
1851 |
773 |
product |
3827 |
A |
1 |
|
3827 |
0 |
IMG_6348.JPG |
1000 |
1000 |
N |
1861 |
775 |
product |
3837 |
A |
1 |
|
3837 |
0 |
IMG_6363.JPG |
1000 |
1000 |
N |
1865 |
776 |
product |
3841 |
A |
1 |
|
3841 |
0 |
IMG_6370.JPG |
1000 |
1000 |
N |
1870 |
777 |
product |
3846 |
A |
1 |
|
3846 |
0 |
IMG_6372_m5s0-r4.JPG |
1000 |
1000 |
N |
1875 |
778 |
product |
3851 |
A |
1 |
|
3851 |
0 |
IMG_6391.JPG |
1000 |
1000 |
N |
1879 |
779 |
product |
3855 |
A |
1 |
|
3855 |
0 |
IMG_6400.JPG |
1000 |
1000 |
N |
1883 |
780 |
product |
3859 |
A |
1 |
|
3859 |
0 |
IMG_6409.JPG |
1000 |
1000 |
N |
1887 |
781 |
product |
3863 |
A |
1 |
|
3863 |
0 |
IMG_6420.JPG |
1000 |
1000 |
N |
1891 |
782 |
product |
3867 |
A |
1 |
|
3867 |
0 |
IMG_6430.JPG |
1000 |
1000 |
N |
1897 |
783 |
product |
3873 |
A |
1 |
|
3873 |
0 |
IMG_6441.JPG |
1000 |
1000 |
N |
1902 |
784 |
product |
3878 |
A |
1 |
|
3878 |
0 |
IMG_6450.JPG |
1000 |
1000 |
N |
1907 |
785 |
product |
3883 |
A |
1 |
|
3883 |
0 |
IMG_6459.JPG |
1000 |
1000 |
N |
1913 |
786 |
product |
3889 |
A |
1 |
|
3889 |
0 |
IMG_6470.JPG |
1000 |
1000 |
N |
1919 |
787 |
product |
3895 |
A |
1 |
|
3895 |
0 |
IMG_6478E.jpg |
1000 |
1000 |
N |
1923 |
788 |
product |
3899 |
A |
1 |
|
3899 |
0 |
IMG_6487E.jpg |
1000 |
1000 |
N |
1928 |
789 |
product |
3904 |
A |
1 |
|
3904 |
0 |
IMG_6496E.jpg |
1000 |
1000 |
N |
1933 |
790 |
product |
3909 |
A |
1 |
|
3909 |
0 |
IMG_7013.JPG |
1000 |
1000 |
N |
1790 |
761 |
product |
3766 |
A |
2 |
|
3766 |
0 |
IMG_6244.JPG |
1000 |
1000 |
N |
1795 |
762 |
product |
3771 |
A |
2 |
|
3771 |
0 |
IMG_6257.JPG |
1000 |
1000 |
N |
1801 |
763 |
product |
3777 |
A |
2 |
|
3777 |
0 |
IMG_6265.JPG |
1000 |
1000 |
N |
1806 |
764 |
product |
3782 |
A |
2 |
|
3782 |
0 |
IMG_6274.JPG |
1000 |
1000 |
N |
1811 |
765 |
product |
3787 |
A |
2 |
|
3787 |
0 |
IMG_6281.JPG |
1000 |
1000 |
N |
1815 |
766 |
product |
3791 |
A |
2 |
|
3791 |
0 |
IMG_6288_rzxk-dq.JPG |
1000 |
1000 |
N |
1821 |
767 |
product |
3797 |
A |
2 |
|
3797 |
0 |
IMG_6288_m4hq-jj.JPG |
1000 |
1000 |
N |
1826 |
768 |
product |
3802 |
A |
2 |
|
3802 |
0 |
IMG_6304_vg33-vi.JPG |
1000 |
1000 |
N |
1831 |
769 |
product |
3807 |
A |
2 |
|
3807 |
0 |
IMG_6312.JPG |
1000 |
1000 |
N |
1837 |
770 |
product |
3813 |
A |
2 |
|
3813 |
0 |
IMG_6320.JPG |
1000 |
1000 |
N |
1842 |
771 |
product |
3818 |
A |
2 |
|
3818 |
0 |
IMG_6329.JPG |
1000 |
1000 |
N |
1848 |
772 |
product |
3824 |
A |
2 |
|
3824 |
0 |
IMG_6335.JPG |
1000 |
1000 |
N |
1852 |
773 |
product |
3828 |
A |
2 |
|
3828 |
0 |
IMG_6350.JPG |
1000 |
1000 |
N |
1862 |
775 |
product |
3838 |
A |
2 |
|
3838 |
0 |
IMG_6364.JPG |
1000 |
1000 |
N |
1866 |
776 |
product |
3842 |
A |
2 |
|
3842 |
0 |
IMG_6371.JPG |
1000 |
1000 |
N |
1871 |
777 |
product |
3847 |
A |
2 |
|
3847 |
0 |
IMG_6376.JPG |
1000 |
1000 |
N |
1876 |
778 |
product |
3852 |
A |
2 |
|
3852 |
0 |
IMG_6393.JPG |
1000 |
1000 |
N |
1880 |
779 |
product |
3856 |
A |
2 |
|
3856 |
0 |
IMG_6403.JPG |
1000 |
1000 |
N |
1884 |
780 |
product |
3860 |
A |
2 |
|
3860 |
0 |
IMG_6413.JPG |
1000 |
1000 |
N |
1888 |
781 |
product |
3864 |
A |
2 |
|
3864 |
0 |
IMG_6422.JPG |
1000 |
1000 |
N |
1892 |
782 |
product |
3868 |
A |
2 |
|
3868 |
0 |
IMG_6431.JPG |
1000 |
1000 |
N |
1898 |
783 |
product |
3874 |
A |
2 |
|
3874 |
0 |
IMG_6443.JPG |
1000 |
1000 |
N |
1903 |
784 |
product |
3879 |
A |
2 |
|
3879 |
0 |
IMG_6451.JPG |
1000 |
1000 |
N |
1908 |
785 |
product |
3884 |
A |
2 |
|
3884 |
0 |
IMG_6462.JPG |
1000 |
1000 |
N |
1914 |
786 |
product |
3890 |
A |
2 |
|
3890 |
0 |
IMG_6471.JPG |
1000 |
1000 |
N |
1920 |
787 |
product |
3896 |
A |
2 |
|
3896 |
0 |
IMG_6479E.jpg |
1000 |
1000 |
N |
1924 |
788 |
product |
3900 |
A |
2 |
|
3900 |
0 |
IMG_6488E.jpg |
1000 |
1000 |
N |
1929 |
789 |
product |
3905 |
A |
2 |
|
3905 |
0 |
IMG_6497E.jpg |
1000 |
1000 |
N |
1934 |
790 |
product |
3910 |
A |
2 |
|
3910 |
0 |
IMG_7016.JPG |
1000 |
1000 |
N |
1791 |
761 |
product |
3767 |
A |
3 |
|
3767 |
0 |
IMG_6245.JPG |
1000 |
1000 |
N |
1796 |
762 |
product |
3772 |
A |
3 |
|
3772 |
0 |
IMG_6260.JPG |
1000 |
1000 |
N |
1802 |
763 |
product |
3778 |
A |
3 |
|
3778 |
0 |
IMG_6266.JPG |
1000 |
1000 |
N |
1807 |
764 |
product |
3783 |
A |
3 |
|
3783 |
0 |
IMG_6284.JPG |
1000 |
1000 |
N |
1812 |
765 |
product |
3788 |
A |
3 |
|
3788 |
0 |
IMG_6283.JPG |
1000 |
1000 |
N |
1816 |
766 |
product |
3792 |
A |
3 |
|
3792 |
0 |
IMG_6291_d6d6-zb.JPG |
1000 |
1000 |
N |
1822 |
767 |
product |
3798 |
A |
3 |
|
3798 |
0 |
IMG_6291_n3fn-no.JPG |
1000 |
1000 |
N |
1827 |
768 |
product |
3803 |
A |
3 |
|
3803 |
0 |
IMG_6305_jzj5-ha.JPG |
1000 |
1000 |
N |
1832 |
769 |
product |
3808 |
A |
3 |
|
3808 |
0 |
IMG_6314.JPG |
1000 |
1000 |
N |
1838 |
770 |
product |
3814 |
A |
3 |
|
3814 |
0 |
IMG_6323.JPG |
1000 |
1000 |
N |
1843 |
771 |
product |
3819 |
A |
3 |
|
3819 |
0 |
IMG_6331.JPG |
1000 |
1000 |
N |
1849 |
772 |
product |
3825 |
A |
3 |
|
3825 |
0 |
IMG_6336.JPG |
1000 |
1000 |
N |
1853 |
773 |
product |
3829 |
A |
3 |
|
3829 |
0 |
IMG_6355.JPG |
1000 |
1000 |
N |
1863 |
775 |
product |
3839 |
A |
3 |
|
3839 |
0 |
IMG_6365.JPG |
1000 |
1000 |
N |
1867 |
776 |
product |
3843 |
A |
3 |
|
3843 |
0 |
IMG_6372.JPG |
1000 |
1000 |
N |
1872 |
777 |
product |
3848 |
A |
3 |
|
3848 |
0 |
IMG_6388.JPG |
1000 |
1000 |
N |
1877 |
778 |
product |
3853 |
A |
3 |
|
3853 |
0 |
IMG_6395.JPG |
1000 |
1000 |
N |
1881 |
779 |
product |
3857 |
A |
3 |
|
3857 |
0 |
IMG_6405.JPG |
1000 |
1000 |
N |
1885 |
780 |
product |
3861 |
A |
3 |
|
3861 |
0 |
IMG_6415.JPG |
1000 |
1000 |
N |
1889 |
781 |
product |
3865 |
A |
3 |
|
3865 |
0 |
IMG_6423.JPG |
1000 |
1000 |
N |
1893 |
782 |
product |
3869 |
A |
3 |
|
3869 |
0 |
IMG_6434.JPG |
1000 |
1000 |
N |
1899 |
783 |
product |
3875 |
A |
3 |
|
3875 |
0 |
IMG_6444.JPG |
1000 |
1000 |
N |
1904 |
784 |
product |
3880 |
A |
3 |
|
3880 |
0 |
IMG_6452.JPG |
1000 |
1000 |
N |
1909 |
785 |
product |
3885 |
A |
3 |
|
3885 |
0 |
IMG_6463.JPG |
1000 |
1000 |
N |
1915 |
786 |
product |
3891 |
A |
3 |
|
3891 |
0 |
IMG_6472.JPG |
1000 |
1000 |
N |
1921 |
787 |
product |
3897 |
A |
3 |
|
3897 |
0 |
IMG_6480E.jpg |
1000 |
1000 |
N |
1925 |
788 |
product |
3901 |
A |
3 |
|
3901 |
0 |
IMG_6489E.jpg |
1000 |
1000 |
N |
1930 |
789 |
product |
3906 |
A |
3 |
|
3906 |
0 |
IMG_6501E.jpg |
1000 |
1000 |
N |
1935 |
790 |
product |
3911 |
A |
3 |
|
3911 |
0 |
IMG_7020.JPG |
1000 |
1000 |
N |
1792 |
761 |
product |
3768 |
A |
4 |
|
3768 |
0 |
IMG_6248.JPG |
1000 |
1000 |
N |
1797 |
762 |
product |
3773 |
A |
4 |
|
3773 |
0 |
IMG_6262.JPG |
1000 |
1000 |
N |
1803 |
763 |
product |
3779 |
A |
4 |
|
3779 |
0 |
IMG_6270.JPG |
1000 |
1000 |
N |
1808 |
764 |
product |
3784 |
A |
4 |
|
3784 |
0 |
IMG_6292_jk6f-pl.JPG |
1000 |
1000 |
N |
1823 |
767 |
product |
3799 |
A |
4 |
|
3799 |
0 |
IMG_6292_w6d7-z5.JPG |
1000 |
1000 |
N |
1828 |
768 |
product |
3804 |
A |
4 |
|
3804 |
0 |
IMG_6307_nqak-5i.JPG |
1000 |
1000 |
N |
1833 |
769 |
product |
3809 |
A |
4 |
|
3809 |
0 |
IMG_6316.JPG |
1000 |
1000 |
N |
1839 |
770 |
product |
3815 |
A |
4 |
|
3815 |
0 |
IMG_6324.JPG |
1000 |
1000 |
N |
1844 |
771 |
product |
3820 |
A |
4 |
|
3820 |
0 |
IMG_6339.JPG |
1000 |
1000 |
N |
1854 |
773 |
product |
3830 |
A |
4 |
|
3830 |
0 |
IMG_6368.JPG |
1000 |
1000 |
N |
1868 |
776 |
product |
3844 |
A |
4 |
|
3844 |
0 |
IMG_6375.JPG |
1000 |
1000 |
N |
1873 |
777 |
product |
3849 |
A |
4 |
|
3849 |
0 |
IMG_6418.JPG |
1000 |
1000 |
N |
1890 |
781 |
product |
3866 |
A |
4 |
|
3866 |
0 |
IMG_6424.JPG |
1000 |
1000 |
N |
1894 |
782 |
product |
3870 |
A |
4 |
|
3870 |
0 |
IMG_6435.JPG |
1000 |
1000 |
N |
1900 |
783 |
product |
3876 |
A |
4 |
|
3876 |
0 |
IMG_6445.JPG |
1000 |
1000 |
N |
1905 |
784 |
product |
3881 |
A |
4 |
|
3881 |
0 |
IMG_6453.JPG |
1000 |
1000 |
N |
1910 |
785 |
product |
3886 |
A |
4 |
|
3886 |
0 |
IMG_6465.JPG |
1000 |
1000 |
N |
1916 |
786 |
product |
3892 |
A |
4 |
|
3892 |
0 |
IMG_6481E.jpg |
1000 |
1000 |
N |
1926 |
788 |
product |
3902 |
A |
4 |
|
3902 |
0 |
IMG_6493E.jpg |
1000 |
1000 |
N |
1931 |
789 |
product |
3907 |
A |
4 |
|
3907 |
0 |
IMG_6252.JPG |
1000 |
1000 |
N |
1798 |
762 |
product |
3774 |
A |
5 |
|
3774 |
0 |
IMG_6308_w9ru-8k.JPG |
1000 |
1000 |
N |
1834 |
769 |
product |
3810 |
A |
5 |
|
3810 |
0 |
IMG_6325.JPG |
1000 |
1000 |
N |
1845 |
771 |
product |
3821 |
A |
5 |
|
3821 |
0 |
IMG_6426.JPG |
1000 |
1000 |
N |
1895 |
782 |
product |
3871 |
A |
5 |
|
3871 |
0 |
IMG_6456.JPG |
1000 |
1000 |
N |
1911 |
785 |
product |
3887 |
A |
5 |
|
3887 |
0 |
IMG_6467.JPG |
1000 |
1000 |
N |
1917 |
786 |
product |
3893 |
A |
5 |
|
3893 |
0 |
IMG_6342.JPG |
1000 |
1000 |
N |
1856 |
774 |
product |
3832 |
A |
6 |
|
3832 |
0 |
IMG_6343.JPG |
1000 |
1000 |
N |
1857 |
774 |
product |
3833 |
A |
7 |
|
3833 |
0 |
IMG_6344.JPG |
1000 |
1000 |
N |
1858 |
774 |
product |
3834 |
A |
8 |
|
3834 |
0 |
IMG_6345.JPG |
1000 |
1000 |
N |
1859 |
774 |
product |
3835 |
A |
9 |
|
3835 |