Query time 0.00170
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "222.01"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "40.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": 40,
"rows_produced_per_join": 40,
"filtered": "100.00",
"index_condition": "((`portal`.`q_images_links`.`object_type` = 'product') and (`portal`.`q_images_links`.`type` = 'M') and (`portal`.`q_images_links`.`object_id` in ('2423','2424','1257','1258','1259','1260','1261','1262','1263','1264','1228','1236','1252','1253','1254','1209','1169','1170','1171','1172','1173','1174','1175','1176','1177','1178','1179','1180','1181','1182')))",
"cost_info": {
"read_cost": "78.01",
"eval_cost": "8.00",
"prefix_cost": "86.01",
"data_read_per_join": "3K"
},
"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": 40,
"filtered": "100.00",
"cost_info": {
"read_cost": "40.00",
"eval_cost": "8.00",
"prefix_cost": "134.01",
"data_read_per_join": "30K"
},
"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": 40,
"filtered": "100.00",
"cost_info": {
"read_cost": "40.00",
"eval_cost": "8.00",
"prefix_cost": "182.01",
"data_read_per_join": "23K"
},
"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 |
item_M_48099176_f40e826789501.jpg |
49 |
140 |
N |
2611 |
1169 |
product |
4587 |
M |
0 |
|
4587 |
0 |
item_M_48098021_1a280470d2388.jpg |
51 |
140 |
N |
2612 |
1170 |
product |
4588 |
M |
0 |
|
4588 |
0 |
item_M_48096777_4bd731c09b5c9.jpg |
51 |
140 |
N |
2613 |
1171 |
product |
4589 |
M |
0 |
|
4589 |
0 |
item_M_46219311_15ca8d3c48d9f.jpg |
140 |
140 |
N |
2614 |
1172 |
product |
4590 |
M |
0 |
|
4590 |
0 |
item_M_47654846_a5e655813538b.jpg |
51 |
140 |
N |
2616 |
1174 |
product |
4592 |
M |
0 |
|
4592 |
0 |
item_M_22490382_31710443.jpg |
140 |
140 |
N |
2617 |
1175 |
product |
4593 |
M |
0 |
|
4593 |
0 |
item_M_22490385_65016579.jpg |
96 |
140 |
N |
2618 |
1176 |
product |
4594 |
M |
0 |
|
4594 |
0 |
item_M_22490380_65016571.jpg |
96 |
140 |
N |
2619 |
1177 |
product |
4595 |
M |
0 |
|
4595 |
0 |
item_M_12053443_147583267.jpg |
92 |
140 |
N |
2620 |
1178 |
product |
4596 |
M |
0 |
|
4596 |
0 |
item_M_30478192_136265621.jpg |
54 |
140 |
N |
2621 |
1179 |
product |
4597 |
M |
0 |
|
4597 |
0 |
item_M_30478148_136264390.jpg |
88 |
140 |
N |
2622 |
1180 |
product |
4598 |
M |
0 |
|
4598 |
0 |
item_M_7652038_147583302.jpg |
52 |
140 |
N |
2623 |
1181 |
product |
4599 |
M |
0 |
|
4599 |
0 |
item_M_7652034_8d5710aedbca2.jpg |
54 |
140 |
N |
2624 |
1182 |
product |
4600 |
M |
0 |
|
4600 |
0 |
item_M_45753311_5508d027e50b7.jpg |
78 |
140 |
N |
2687 |
1209 |
product |
4663 |
M |
0 |
|
4663 |
0 |
item_M_42081982_c01d7058c6e6b.jpg |
140 |
53 |
N |
2706 |
1228 |
product |
4682 |
M |
0 |
|
4682 |
0 |
item_M_42034219_89409c30db04c.jpg |
40 |
140 |
N |
2714 |
1236 |
product |
4690 |
M |
0 |
|
4690 |
0 |
item_M_36134913_142322379.jpg |
77 |
140 |
N |
2730 |
1252 |
product |
4706 |
M |
0 |
|
4706 |
0 |
item_M_36034150_150489973.jpg |
78 |
140 |
N |
2731 |
1253 |
product |
4707 |
M |
0 |
|
4707 |
0 |
item_M_36034115_150489786.jpg |
76 |
140 |
N |
2732 |
1254 |
product |
4708 |
M |
0 |
|
4708 |
0 |
item_XL_46485276_cd788e05af29f.jpg |
600 |
529 |
N |
2736 |
1258 |
product |
4712 |
M |
0 |
|
4712 |
0 |
item_XL_46485193_b1e0f8dd01f94.jpg |
600 |
494 |
N |
2737 |
1259 |
product |
4713 |
M |
0 |
|
4713 |
0 |
item_XL_46485075_2b3f4f14df87b.jpg |
185 |
600 |
N |
2738 |
1260 |
product |
4714 |
M |
0 |
|
4714 |
0 |
item_XL_46484894_a3784842230a7.jpg |
242 |
600 |
N |
2739 |
1261 |
product |
4715 |
M |
0 |
|
4715 |
0 |
item_XL_46370198_c456b2b37b7b2.jpg |
161 |
600 |
N |
2740 |
1262 |
product |
4716 |
M |
0 |
|
4716 |
0 |
item_XL_46370124_4b199cfae1c48.jpg |
161 |
600 |
N |
2741 |
1263 |
product |
4717 |
M |
0 |
|
4717 |
0 |
item_XL_44496167_f3b3ee553201f.jpg |
169 |
600 |
N |
2742 |
1264 |
product |
4718 |
M |
0 |
|
4718 |
0 |
item_XL_36887185_144309044.jpg |
500 |
500 |
N |
5701 |
2423 |
product |
7672 |
M |
0 |
|
7672 |
0 |
item_XL_36887047_144308761.jpg |
312 |
482 |
N |
5702 |
2424 |
product |
7673 |
M |
0 |
|
7673 |
0 |
lorel_web.jpg |
640 |
626 |
N |
37686 |
1173 |
product |
39648 |
M |
0 |
|
39648 |
0 |
olay.jpg |
640 |
626 |
N |
41860 |
1257 |
product |
43822 |
M |
0 |
|
43822 |