Query time 0.00475
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "225.01"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "95.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": 95,
"rows_produced_per_join": 95,
"filtered": "100.00",
"index_condition": "((`cscartdb`.`cscart_images_links`.`object_type` = 'product') and (`cscartdb`.`cscart_images_links`.`type` = 'M') and (`cscartdb`.`cscart_images_links`.`object_id` in (20775,63686,63687,63688,63689,63690,20824,63691,63692,63693,63694,63695,20773,63706,63707,63708,63709,63710,20809,63696,63697,63698,63699,63700,20789,63701,63702,63703,63704,63705,14214,15896,17064,20633,20634,20635,20778,63711,63712,63713,63714,63715,14262,15902,14194,15892,20735,63726,63727,63728,63729,63730,14216,15897,14177,15887,20731,63736,63737,63738,63739,63740,20793,63741,63742,63743,63744,63745,14164,15659,14172,15888,35144,35148,35147,35146,35145,35143,17322,26851,26850,26849,16038)))",
"cost_info": {
"read_cost": "54.01",
"eval_cost": "9.50",
"prefix_cost": "63.51",
"data_read_per_join": "9K"
},
"used_columns": [
"pair_id",
"object_id",
"object_type",
"image_id",
"detailed_id",
"type",
"position",
"nipple"
]
}
},
{
"table": {
"table_name": "cscart_images",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"image_id"
],
"key_length": "4",
"ref": [
"cscartdb.cscart_images_links.detailed_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 95,
"filtered": "100.00",
"cost_info": {
"read_cost": "23.75",
"eval_cost": "9.50",
"prefix_cost": "96.76",
"data_read_per_join": "73K"
},
"used_columns": [
"image_id",
"image_path",
"image_x",
"image_y",
"duplicated"
]
}
},
{
"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": [
"cscartdb.cscart_images.image_id",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 95,
"filtered": "100.00",
"cost_info": {
"read_cost": "23.75",
"eval_cost": "9.50",
"prefix_cost": "130.01",
"data_read_per_join": "56K"
},
"used_columns": [
"object_id",
"description",
"lang_code",
"object_holder"
]
}
}
]
}
}
}
Result
image_id |
image_path |
image_x |
image_y |
duplicated |
pair_id |
object_id |
object_type |
detailed_id |
type |
position |
nipple |
alt |
images_image_id |
0 |
il_fullxfull.2085310073_3tja.jpg |
1069 |
1500 |
|
122180 |
14164 |
product |
89099 |
M |
0 |
|
|
89099 |
0 |
il_fullxfull.2037617110_2fwl.jpg |
1204 |
948 |
|
122217 |
14172 |
product |
89136 |
M |
0 |
|
|
89136 |
0 |
il_fullxfull.2085051701_ood2.jpg |
969 |
1500 |
|
122230 |
14177 |
product |
89149 |
M |
0 |
|
|
89149 |
0 |
il_fullxfull.972371938_robw.jpg |
1016 |
1500 |
|
122274 |
14194 |
product |
89193 |
M |
0 |
|
|
89193 |
0 |
il_fullxfull.2085196255_l3qp.jpg |
1316 |
1140 |
|
122321 |
14214 |
product |
89240 |
M |
0 |
|
|
89240 |
0 |
il_fullxfull.2086112591_hhvn.jpg |
1228 |
972 |
|
122327 |
14216 |
product |
89246 |
M |
0 |
|
|
89246 |
0 |
il_fullxfull.2038504000_sjok.jpg |
958 |
1500 |
|
122455 |
14262 |
product |
89374 |
M |
0 |
|
|
89374 |
0 |
il_fullxfull.2085310073_3tja.jpg |
1069 |
1500 |
|
139262 |
15659 |
product |
89099 |
M |
0 |
|
|
89099 |
0 |
il_fullxfull.2085051701_ood2.jpg |
969 |
1500 |
|
141490 |
15887 |
product |
89149 |
M |
0 |
|
|
89149 |
0 |
il_fullxfull.2037617110_2fwl.jpg |
1204 |
948 |
|
141494 |
15888 |
product |
89136 |
M |
0 |
|
|
89136 |
0 |
il_fullxfull.972371938_robw.jpg |
1016 |
1500 |
|
141508 |
15892 |
product |
89193 |
M |
0 |
|
|
89193 |
0 |
il_fullxfull.2085196255_l3qp.jpg |
1316 |
1140 |
|
141520 |
15896 |
product |
89240 |
M |
0 |
|
|
89240 |
0 |
il_fullxfull.2086112591_hhvn.jpg |
1228 |
972 |
|
141524 |
15897 |
product |
89246 |
M |
0 |
|
|
89246 |
0 |
il_fullxfull.2038504000_sjok.jpg |
958 |
1500 |
|
141534 |
15902 |
product |
89374 |
M |
0 |
|
|
89374 |
0 |
il_fullxfull.4544760087_fcia.jpg |
1124 |
1401 |
|
142836 |
16038 |
product |
108600 |
M |
0 |
|
|
108600 |
0 |
66623fc9a2f80_1717714876jpg.jpg |
3000 |
2999 |
|
149036 |
17064 |
product |
113453 |
M |
0 |
|
|
113453 |
0 |
66635f8df25ed_1717788500jpg.jpg |
1872 |
1872 |
|
150663 |
17322 |
product |
115030 |
M |
0 |
|
|
115030 |
0 |
66623fc9a2f80_1717714876jpg.jpg |
3000 |
2999 |
|
174479 |
20633 |
product |
113453 |
M |
0 |
|
|
113453 |
0 |
66623fc9a2f80_1717714876jpg.jpg |
3000 |
2999 |
|
174480 |
20634 |
product |
113453 |
M |
0 |
|
|
113453 |
0 |
66623fc9a2f80_1717714876jpg.jpg |
3000 |
2999 |
|
174481 |
20635 |
product |
113453 |
M |
0 |
|
|
113453 |
0 |
il_fullxfull.6044375638_hix6.jpg |
2250 |
3000 |
|
175250 |
20731 |
product |
127684 |
M |
0 |
|
|
127684 |
0 |
il_fullxfull.3961285919_ee2m.jpg |
1564 |
1564 |
|
175269 |
20735 |
product |
127703 |
M |
0 |
|
|
127703 |
0 |
il_fullxfull.4045058710_nnyg.jpg |
1564 |
1564 |
|
175486 |
20773 |
product |
127920 |
M |
0 |
|
|
127920 |
0 |
il_fullxfull.5352210679_jywg.jpg |
1438 |
1438 |
|
175498 |
20775 |
product |
127932 |
M |
0 |
|
|
127932 |
0 |
il_fullxfull.3696298672_g2w0.jpg |
1564 |
1564 |
|
175515 |
20778 |
product |
127949 |
M |
0 |
|
|
127949 |
0 |
il_fullxfull.5858154334_h1ib.jpg |
1080 |
1350 |
|
175578 |
20789 |
product |
128012 |
M |
0 |
|
|
128012 |
0 |
il_fullxfull.4572154110_ekgh.jpg |
867 |
1156 |
|
175602 |
20793 |
product |
128036 |
M |
0 |
|
|
128036 |
0 |
il_fullxfull.5795323426_8sks.jpg |
1080 |
1350 |
|
175696 |
20809 |
product |
128130 |
M |
0 |
|
|
128130 |
0 |
il_fullxfull.5801597824_8ny4.jpg |
2805 |
3000 |
|
175782 |
20824 |
product |
128216 |
M |
0 |
|
|
128216 |
0 |
il_fullxfull.4544760087_fcia.jpg |
1124 |
1401 |
|
203136 |
26849 |
product |
108600 |
M |
0 |
|
|
108600 |
0 |
il_fullxfull.4544760087_fcia.jpg |
1124 |
1401 |
|
203137 |
26850 |
product |
108600 |
M |
0 |
|
|
108600 |
0 |
il_fullxfull.4544760087_fcia.jpg |
1124 |
1401 |
|
203138 |
26851 |
product |
108600 |
M |
0 |
|
|
108600 |
0 |
66635f8df25ed_1717788500jpg.jpg |
1872 |
1872 |
|
257254 |
35143 |
product |
115030 |
M |
0 |
|
|
115030 |
0 |
66635f8df25ed_1717788500jpg.jpg |
1872 |
1872 |
|
257255 |
35144 |
product |
115030 |
M |
0 |
|
|
115030 |
0 |
66635f8df25ed_1717788500jpg.jpg |
1872 |
1872 |
|
257256 |
35145 |
product |
115030 |
M |
0 |
|
|
115030 |
0 |
66635f8df25ed_1717788500jpg.jpg |
1872 |
1872 |
|
257257 |
35146 |
product |
115030 |
M |
0 |
|
|
115030 |
0 |
66635f8df25ed_1717788500jpg.jpg |
1872 |
1872 |
|
257258 |
35147 |
product |
115030 |
M |
0 |
|
|
115030 |
0 |
66635f8df25ed_1717788500jpg.jpg |
1872 |
1872 |
|
257259 |
35148 |
product |
115030 |
M |
0 |
|
|
115030 |
0 |
il_fullxfull.5352210679_jywg.jpg |
1438 |
1438 |
|
360479 |
63686 |
product |
127932 |
M |
0 |
|
|
127932 |
0 |
il_fullxfull.5352210679_jywg.jpg |
1438 |
1438 |
|
360480 |
63687 |
product |
127932 |
M |
0 |
|
|
127932 |
0 |
il_fullxfull.5352210679_jywg.jpg |
1438 |
1438 |
|
360481 |
63688 |
product |
127932 |
M |
0 |
|
|
127932 |
0 |
il_fullxfull.5352210679_jywg.jpg |
1438 |
1438 |
|
360482 |
63689 |
product |
127932 |
M |
0 |
|
|
127932 |
0 |
il_fullxfull.5352210679_jywg.jpg |
1438 |
1438 |
|
360483 |
63690 |
product |
127932 |
M |
0 |
|
|
127932 |
0 |
il_fullxfull.5801597824_8ny4.jpg |
2805 |
3000 |
|
360509 |
63691 |
product |
128216 |
M |
0 |
|
|
128216 |
0 |
il_fullxfull.5801597824_8ny4.jpg |
2805 |
3000 |
|
360510 |
63692 |
product |
128216 |
M |
0 |
|
|
128216 |
0 |
il_fullxfull.5801597824_8ny4.jpg |
2805 |
3000 |
|
360511 |
63693 |
product |
128216 |
M |
0 |
|
|
128216 |
0 |
il_fullxfull.5801597824_8ny4.jpg |
2805 |
3000 |
|
360512 |
63694 |
product |
128216 |
M |
0 |
|
|
128216 |
0 |
il_fullxfull.5801597824_8ny4.jpg |
2805 |
3000 |
|
360513 |
63695 |
product |
128216 |
M |
0 |
|
|
128216 |
0 |
il_fullxfull.5795323426_8sks.jpg |
1080 |
1350 |
|
360539 |
63696 |
product |
128130 |
M |
0 |
|
|
128130 |
0 |
il_fullxfull.5795323426_8sks.jpg |
1080 |
1350 |
|
360540 |
63697 |
product |
128130 |
M |
0 |
|
|
128130 |
0 |
il_fullxfull.5795323426_8sks.jpg |
1080 |
1350 |
|
360541 |
63698 |
product |
128130 |
M |
0 |
|
|
128130 |
0 |
il_fullxfull.5795323426_8sks.jpg |
1080 |
1350 |
|
360542 |
63699 |
product |
128130 |
M |
0 |
|
|
128130 |
0 |
il_fullxfull.5795323426_8sks.jpg |
1080 |
1350 |
|
360543 |
63700 |
product |
128130 |
M |
0 |
|
|
128130 |
0 |
il_fullxfull.5858154334_h1ib.jpg |
1080 |
1350 |
|
360569 |
63701 |
product |
128012 |
M |
0 |
|
|
128012 |
0 |
il_fullxfull.5858154334_h1ib.jpg |
1080 |
1350 |
|
360570 |
63702 |
product |
128012 |
M |
0 |
|
|
128012 |
0 |
il_fullxfull.5858154334_h1ib.jpg |
1080 |
1350 |
|
360571 |
63703 |
product |
128012 |
M |
0 |
|
|
128012 |
0 |
il_fullxfull.5858154334_h1ib.jpg |
1080 |
1350 |
|
360572 |
63704 |
product |
128012 |
M |
0 |
|
|
128012 |
0 |
il_fullxfull.5858154334_h1ib.jpg |
1080 |
1350 |
|
360573 |
63705 |
product |
128012 |
M |
0 |
|
|
128012 |
0 |
il_fullxfull.4045058710_nnyg.jpg |
1564 |
1564 |
|
360599 |
63706 |
product |
127920 |
M |
0 |
|
|
127920 |
0 |
il_fullxfull.4045058710_nnyg.jpg |
1564 |
1564 |
|
360600 |
63707 |
product |
127920 |
M |
0 |
|
|
127920 |
0 |
il_fullxfull.4045058710_nnyg.jpg |
1564 |
1564 |
|
360601 |
63708 |
product |
127920 |
M |
0 |
|
|
127920 |
0 |
il_fullxfull.4045058710_nnyg.jpg |
1564 |
1564 |
|
360602 |
63709 |
product |
127920 |
M |
0 |
|
|
127920 |
0 |
il_fullxfull.4045058710_nnyg.jpg |
1564 |
1564 |
|
360603 |
63710 |
product |
127920 |
M |
0 |
|
|
127920 |
0 |
il_fullxfull.3696298672_g2w0.jpg |
1564 |
1564 |
|
360629 |
63711 |
product |
127949 |
M |
0 |
|
|
127949 |
0 |
il_fullxfull.3696298672_g2w0.jpg |
1564 |
1564 |
|
360630 |
63712 |
product |
127949 |
M |
0 |
|
|
127949 |
0 |
il_fullxfull.3696298672_g2w0.jpg |
1564 |
1564 |
|
360631 |
63713 |
product |
127949 |
M |
0 |
|
|
127949 |
0 |
il_fullxfull.3696298672_g2w0.jpg |
1564 |
1564 |
|
360632 |
63714 |
product |
127949 |
M |
0 |
|
|
127949 |
0 |
il_fullxfull.3696298672_g2w0.jpg |
1564 |
1564 |
|
360633 |
63715 |
product |
127949 |
M |
0 |
|
|
127949 |
0 |
il_fullxfull.3961285919_ee2m.jpg |
1564 |
1564 |
|
360719 |
63726 |
product |
127703 |
M |
0 |
|
|
127703 |
0 |
il_fullxfull.3961285919_ee2m.jpg |
1564 |
1564 |
|
360720 |
63727 |
product |
127703 |
M |
0 |
|
|
127703 |
0 |
il_fullxfull.3961285919_ee2m.jpg |
1564 |
1564 |
|
360721 |
63728 |
product |
127703 |
M |
0 |
|
|
127703 |
0 |
il_fullxfull.3961285919_ee2m.jpg |
1564 |
1564 |
|
360722 |
63729 |
product |
127703 |
M |
0 |
|
|
127703 |
0 |
il_fullxfull.3961285919_ee2m.jpg |
1564 |
1564 |
|
360723 |
63730 |
product |
127703 |
M |
0 |
|
|
127703 |
0 |
il_fullxfull.6044375638_hix6.jpg |
2250 |
3000 |
|
360764 |
63736 |
product |
127684 |
M |
0 |
|
|
127684 |
0 |
il_fullxfull.6044375638_hix6.jpg |
2250 |
3000 |
|
360765 |
63737 |
product |
127684 |
M |
0 |
|
|
127684 |
0 |
il_fullxfull.6044375638_hix6.jpg |
2250 |
3000 |
|
360766 |
63738 |
product |
127684 |
M |
0 |
|
|
127684 |
0 |
il_fullxfull.6044375638_hix6.jpg |
2250 |
3000 |
|
360767 |
63739 |
product |
127684 |
M |
0 |
|
|
127684 |
0 |
il_fullxfull.6044375638_hix6.jpg |
2250 |
3000 |
|
360768 |
63740 |
product |
127684 |
M |
0 |
|
|
127684 |
0 |
il_fullxfull.4572154110_ekgh.jpg |
867 |
1156 |
|
360794 |
63741 |
product |
128036 |
M |
0 |
|
|
128036 |
0 |
il_fullxfull.4572154110_ekgh.jpg |
867 |
1156 |
|
360795 |
63742 |
product |
128036 |
M |
0 |
|
|
128036 |
0 |
il_fullxfull.4572154110_ekgh.jpg |
867 |
1156 |
|
360796 |
63743 |
product |
128036 |
M |
0 |
|
|
128036 |
0 |
il_fullxfull.4572154110_ekgh.jpg |
867 |
1156 |
|
360797 |
63744 |
product |
128036 |
M |
0 |
|
|
128036 |
0 |
il_fullxfull.4572154110_ekgh.jpg |
867 |
1156 |
|
360798 |
63745 |
product |
128036 |
M |
0 |
|
|
128036 |