Query time 0.00417
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "493.01"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "85.00"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_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": 85,
"rows_produced_per_join": 85,
"filtered": "100.00",
"index_condition": "((`webmarco`.`cscart_images_links`.`object_type` = 'product') and (`webmarco`.`cscart_images_links`.`type` = 'M') and (`webmarco`.`cscart_images_links`.`object_id` in (366827,366828,366829,366830,366831,366832,366833,366834,366835,366836,366837,366838,366771,366772,366773,366774,366775,366776,366815,366816,366817,366818,366819,366820,366690,366691,366692,366693,366765,366766,366767,366768,366760,366761,366762,366821,366857,366858,366859,366860,366861,366862,366796,366797,366798,366791,366792,366793,366794,366809,366810,366811,366812,366813,366814,366875,366876,366877,366878,366879,366880,366881,366882,366883,366884,366885,366886,366888,366889,366890,366891,366851,366852,366853,366854,366754,366755,366841,366842,366843,366844,366688,366689,366729,366730)))",
"cost_info": {
"read_cost": "187.01",
"eval_cost": "17.00",
"prefix_cost": "204.01",
"data_read_per_join": "7K"
},
"used_columns": [
"pair_id",
"object_id",
"object_type",
"image_id",
"detailed_id",
"type",
"position"
]
}
},
{
"table": {
"table_name": "cscart_images",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"image_id"
],
"key_length": "4",
"ref": [
"webmarco.cscart_images_links.detailed_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 85,
"filtered": "100.00",
"cost_info": {
"read_cost": "85.00",
"eval_cost": "17.00",
"prefix_cost": "306.01",
"data_read_per_join": "65K"
},
"used_columns": [
"image_id",
"image_path",
"image_x",
"image_y",
"is_high_res"
]
}
},
{
"table": {
"table_name": "cscart_common_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"lang_code",
"object_holder"
],
"key_length": "108",
"ref": [
"webmarco.cscart_images.image_id",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 85,
"filtered": "100.00",
"cost_info": {
"read_cost": "85.00",
"eval_cost": "17.00",
"prefix_cost": "408.01",
"data_read_per_join": "50K"
},
"used_columns": [
"object_id",
"description",
"lang_code",
"object_holder"
]
}
}
]
}
}
}
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 |
produts_img_600__13__6cre-jt.png |
600 |
600 |
N |
3016691 |
366688 |
product |
963080 |
M |
0 |
|
963080 |
0 |
produts_img_600__16_.png |
600 |
600 |
N |
3016695 |
366689 |
product |
963077 |
M |
0 |
|
963077 |
0 |
produts_img_600__19_.png |
600 |
600 |
N |
3016696 |
366690 |
product |
963081 |
M |
0 |
|
963081 |
0 |
produts_img_600__19_.png |
600 |
600 |
N |
3016718 |
366691 |
product |
963081 |
M |
0 |
|
963081 |
0 |
produts_img_600__19_.png |
600 |
600 |
N |
3016719 |
366692 |
product |
963081 |
M |
0 |
|
963081 |
0 |
produts_img_600__19_.png |
600 |
600 |
N |
3016720 |
366693 |
product |
963081 |
M |
0 |
|
963081 |
0 |
produts_img_600__77_.png |
600 |
600 |
N |
3016878 |
366729 |
product |
963155 |
M |
0 |
|
963155 |
0 |
produts_img_600__68_.png |
600 |
600 |
N |
3016898 |
366730 |
product |
963165 |
M |
0 |
|
963165 |
0 |
produts_img_600_-_2022-11-30T094037.837.png |
600 |
600 |
N |
3018698 |
366754 |
product |
964849 |
M |
0 |
|
964849 |
0 |
produts_img_600_-_2022-11-30T094037.837.png |
600 |
600 |
N |
3018699 |
366755 |
product |
964849 |
M |
0 |
|
964849 |
0 |
produts_img_600_-_2022-11-30T094927.396.png |
600 |
600 |
N |
3018722 |
366760 |
product |
964853 |
M |
0 |
|
964853 |
0 |
produts_img_600_-_2022-11-30T094927.396.png |
600 |
600 |
N |
3018723 |
366761 |
product |
964853 |
M |
0 |
|
964853 |
0 |
produts_img_600_-_2022-11-30T094927.396.png |
600 |
600 |
N |
3018724 |
366762 |
product |
964853 |
M |
0 |
|
964853 |
0 |
produts_img_600_-_2022-11-30T095648.865.png |
600 |
600 |
N |
3018727 |
366765 |
product |
964857 |
M |
0 |
|
964857 |
0 |
produts_img_600_-_2022-11-30T095648.865.png |
600 |
600 |
N |
3018746 |
366766 |
product |
964857 |
M |
0 |
|
964857 |
0 |
produts_img_600_-_2022-11-30T095648.865.png |
600 |
600 |
N |
3018747 |
366767 |
product |
964857 |
M |
0 |
|
964857 |
0 |
produts_img_600_-_2022-11-30T095648.865.png |
600 |
600 |
N |
3018748 |
366768 |
product |
964857 |
M |
0 |
|
964857 |
0 |
produts_img_600_-_2022-11-30T100344.846.png |
600 |
600 |
N |
3018751 |
366771 |
product |
964861 |
M |
0 |
|
964861 |
0 |
produts_img_600_-_2022-11-30T100344.846.png |
600 |
600 |
N |
3018770 |
366772 |
product |
964861 |
M |
0 |
|
964861 |
0 |
produts_img_600_-_2022-11-30T100344.846.png |
600 |
600 |
N |
3018771 |
366773 |
product |
964861 |
M |
0 |
|
964861 |
0 |
produts_img_600_-_2022-11-30T100344.846.png |
600 |
600 |
N |
3018772 |
366774 |
product |
964861 |
M |
0 |
|
964861 |
0 |
produts_img_600_-_2022-11-30T100344.846.png |
600 |
600 |
N |
3018773 |
366775 |
product |
964861 |
M |
0 |
|
964861 |
0 |
produts_img_600_-_2022-11-30T100344.846.png |
600 |
600 |
N |
3018774 |
366776 |
product |
964861 |
M |
0 |
|
964861 |
0 |
produts_img_600_-_2022-11-30T105316.657_7dpr-ph.png |
600 |
600 |
N |
3018839 |
366791 |
product |
964901 |
M |
0 |
|
964901 |
0 |
produts_img_600_-_2022-11-30T105952.887_dncp-m7.png |
600 |
600 |
N |
3018875 |
366792 |
product |
964909 |
M |
0 |
|
964909 |
0 |
produts_img_600_-_2022-11-30T112706.620.png |
600 |
600 |
N |
3018883 |
366794 |
product |
964911 |
M |
0 |
|
964911 |
0 |
produts_img_600_-_2022-11-30T112817.379.png |
600 |
600 |
N |
3018894 |
366793 |
product |
964915 |
M |
0 |
|
964915 |
0 |
produts_img_600_-_2022-11-30T114535.144.png |
600 |
600 |
N |
3018904 |
366796 |
product |
964921 |
M |
0 |
|
964921 |
0 |
produts_img_600_-_2022-11-30T114535.144.png |
600 |
600 |
N |
3018923 |
366797 |
product |
964921 |
M |
0 |
|
964921 |
0 |
produts_img_600_-_2022-11-30T114535.144.png |
600 |
600 |
N |
3018924 |
366798 |
product |
964921 |
M |
0 |
|
964921 |
0 |
produts_img_600_-_2022-11-30T121144.778.png |
600 |
600 |
N |
3018949 |
366809 |
product |
964931 |
M |
0 |
|
964931 |
0 |
produts_img_600_-_2022-11-30T121144.778.png |
600 |
600 |
N |
3018962 |
366810 |
product |
964931 |
M |
0 |
|
964931 |
0 |
produts_img_600_-_2022-11-30T121144.778.png |
600 |
600 |
N |
3018963 |
366811 |
product |
964931 |
M |
0 |
|
964931 |
0 |
produts_img_600_-_2022-11-30T121144.778.png |
600 |
600 |
N |
3018964 |
366812 |
product |
964931 |
M |
0 |
|
964931 |
0 |
produts_img_600_-_2022-11-30T121144.778.png |
600 |
600 |
N |
3018965 |
366813 |
product |
964931 |
M |
0 |
|
964931 |
0 |
produts_img_600_-_2022-11-30T121144.778.png |
600 |
600 |
N |
3018966 |
366814 |
product |
964931 |
M |
0 |
|
964931 |
0 |
produts_img_600_-_2022-11-30T122111.150.png |
600 |
600 |
N |
3018967 |
366815 |
product |
964934 |
M |
0 |
|
964934 |
0 |
produts_img_600_-_2022-11-30T122111.150.png |
600 |
600 |
N |
3018986 |
366816 |
product |
964934 |
M |
0 |
|
964934 |
0 |
produts_img_600_-_2022-11-30T122111.150.png |
600 |
600 |
N |
3018987 |
366817 |
product |
964934 |
M |
0 |
|
964934 |
0 |
produts_img_600_-_2022-11-30T122111.150.png |
600 |
600 |
N |
3018988 |
366818 |
product |
964934 |
M |
0 |
|
964934 |
0 |
produts_img_600_-_2022-11-30T122111.150.png |
600 |
600 |
N |
3018989 |
366819 |
product |
964934 |
M |
0 |
|
964934 |
0 |
produts_img_600_-_2022-11-30T122111.150.png |
600 |
600 |
N |
3018990 |
366820 |
product |
964934 |
M |
0 |
|
964934 |
0 |
produts_img_600_-_2022-11-30T123027.853.png |
600 |
600 |
N |
3018991 |
366821 |
product |
964938 |
M |
0 |
|
964938 |
0 |
produts_img_600_-_2022-11-30T124217.975.png |
600 |
600 |
N |
3019015 |
366827 |
product |
964942 |
M |
0 |
|
964942 |
0 |
produts_img_600_-_2022-11-30T124217.975.png |
600 |
600 |
N |
3019040 |
366828 |
product |
964942 |
M |
0 |
|
964942 |
0 |
produts_img_600_-_2022-11-30T124217.975.png |
600 |
600 |
N |
3019041 |
366829 |
product |
964942 |
M |
0 |
|
964942 |
0 |
produts_img_600_-_2022-11-30T124217.975.png |
600 |
600 |
N |
3019042 |
366830 |
product |
964942 |
M |
0 |
|
964942 |
0 |
produts_img_600_-_2022-11-30T124217.975.png |
600 |
600 |
N |
3019043 |
366831 |
product |
964942 |
M |
0 |
|
964942 |
0 |
produts_img_600_-_2022-11-30T124217.975.png |
600 |
600 |
N |
3019044 |
366832 |
product |
964942 |
M |
0 |
|
964942 |
0 |
produts_img_600_-_2022-11-30T124915.827.png |
600 |
600 |
N |
3019045 |
366833 |
product |
964947 |
M |
0 |
|
964947 |
0 |
produts_img_600_-_2022-11-30T124915.827.png |
600 |
600 |
N |
3019070 |
366834 |
product |
964947 |
M |
0 |
|
964947 |
0 |
produts_img_600_-_2022-11-30T124915.827.png |
600 |
600 |
N |
3019071 |
366835 |
product |
964947 |
M |
0 |
|
964947 |
0 |
produts_img_600_-_2022-11-30T124915.827.png |
600 |
600 |
N |
3019072 |
366836 |
product |
964947 |
M |
0 |
|
964947 |
0 |
produts_img_600_-_2022-11-30T124915.827.png |
600 |
600 |
N |
3019073 |
366837 |
product |
964947 |
M |
0 |
|
964947 |
0 |
produts_img_600_-_2022-11-30T124915.827.png |
600 |
600 |
N |
3019074 |
366838 |
product |
964947 |
M |
0 |
|
964947 |
0 |
produts_img_600_-_2022-11-30T125607.028.png |
600 |
600 |
N |
3019101 |
366841 |
product |
964952 |
M |
0 |
|
964952 |
0 |
produts_img_600_-_2022-11-30T125607.028.png |
600 |
600 |
N |
3019102 |
366842 |
product |
964952 |
M |
0 |
|
964952 |
0 |
produts_img_600_-_2022-11-30T125607.028.png |
600 |
600 |
N |
3019103 |
366843 |
product |
964952 |
M |
0 |
|
964952 |
0 |
produts_img_600_-_2022-11-30T125607.028.png |
600 |
600 |
N |
3019104 |
366844 |
product |
964952 |
M |
0 |
|
964952 |
0 |
produts_img_600_-_2022-11-30T140928.324.png |
600 |
600 |
N |
3019135 |
366851 |
product |
964962 |
M |
0 |
|
964962 |
0 |
produts_img_600_-_2022-11-30T140928.324.png |
600 |
600 |
N |
3019160 |
366852 |
product |
964962 |
M |
0 |
|
964962 |
0 |
produts_img_600_-_2022-11-30T140928.324.png |
600 |
600 |
N |
3019161 |
366853 |
product |
964962 |
M |
0 |
|
964962 |
0 |
produts_img_600_-_2022-11-30T140928.324.png |
600 |
600 |
N |
3019162 |
366854 |
product |
964962 |
M |
0 |
|
964962 |
0 |
produts_img_600_-_2022-11-30T141648.403.png |
600 |
600 |
N |
3019165 |
366857 |
product |
964967 |
M |
0 |
|
964967 |
0 |
produts_img_600_-_2022-11-30T141648.403.png |
600 |
600 |
N |
3019190 |
366858 |
product |
964967 |
M |
0 |
|
964967 |
0 |
produts_img_600_-_2022-11-30T141648.403.png |
600 |
600 |
N |
3019191 |
366859 |
product |
964967 |
M |
0 |
|
964967 |
0 |
produts_img_600_-_2022-11-30T141648.403.png |
600 |
600 |
N |
3019192 |
366860 |
product |
964967 |
M |
0 |
|
964967 |
0 |
produts_img_600_-_2022-11-30T141648.403.png |
600 |
600 |
N |
3019193 |
366861 |
product |
964967 |
M |
0 |
|
964967 |
0 |
produts_img_600_-_2022-11-30T141648.403.png |
600 |
600 |
N |
3019194 |
366862 |
product |
964967 |
M |
0 |
|
964967 |
0 |
produts_img_600_-_2022-11-30T143715.419.png |
600 |
600 |
N |
3019243 |
366875 |
product |
964980 |
M |
0 |
|
964980 |
0 |
produts_img_600_-_2022-11-30T143715.419.png |
600 |
600 |
N |
3019262 |
366876 |
product |
964980 |
M |
0 |
|
964980 |
0 |
produts_img_600_-_2022-11-30T143715.419.png |
600 |
600 |
N |
3019263 |
366877 |
product |
964980 |
M |
0 |
|
964980 |
0 |
produts_img_600_-_2022-11-30T143715.419.png |
600 |
600 |
N |
3019264 |
366878 |
product |
964980 |
M |
0 |
|
964980 |
0 |
produts_img_600_-_2022-11-30T143715.419.png |
600 |
600 |
N |
3019265 |
366879 |
product |
964980 |
M |
0 |
|
964980 |
0 |
produts_img_600_-_2022-11-30T143715.419.png |
600 |
600 |
N |
3019266 |
366880 |
product |
964980 |
M |
0 |
|
964980 |
0 |
produts_img_600_-_2022-11-30T144244.455.png |
600 |
600 |
N |
3019267 |
366881 |
product |
964984 |
M |
0 |
|
964984 |
0 |
produts_img_600_-_2022-11-30T144244.455.png |
600 |
600 |
N |
3019268 |
366882 |
product |
964984 |
M |
0 |
|
964984 |
0 |
produts_img_600_-_2022-11-30T144244.455.png |
600 |
600 |
N |
3019269 |
366883 |
product |
964984 |
M |
0 |
|
964984 |
0 |
produts_img_600_-_2022-11-30T144244.455.png |
600 |
600 |
N |
3019270 |
366884 |
product |
964984 |
M |
0 |
|
964984 |
0 |
produts_img_600_-_2022-11-30T144244.455.png |
600 |
600 |
N |
3019271 |
366885 |
product |
964984 |
M |
0 |
|
964984 |
0 |
produts_img_600_-_2022-11-30T144244.455.png |
600 |
600 |
N |
3019272 |
366886 |
product |
964984 |
M |
0 |
|
964984 |
0 |
Screenshot_2022-11-30_171427.jpg |
593 |
595 |
N |
3020813 |
366888 |
product |
966525 |
M |
0 |
|
966525 |
0 |
Screenshot_2022-11-30_171427.jpg |
593 |
595 |
N |
3020844 |
366889 |
product |
966525 |
M |
0 |
|
966525 |
0 |
Screenshot_2022-11-30_171427.jpg |
593 |
595 |
N |
3020845 |
366890 |
product |
966525 |
M |
0 |
|
966525 |
0 |
Screenshot_2022-11-30_171427.jpg |
593 |
595 |
N |
3020846 |
366891 |
product |
966525 |
M |
0 |
|
966525 |