Query time 0.00141
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.image_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"
]
}
},
{
"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 |
|
|
|
|
2611 |
1169 |
product |
4587 |
M |
0 |
|
|
0 |
|
|
|
|
2612 |
1170 |
product |
4588 |
M |
0 |
|
|
0 |
|
|
|
|
2613 |
1171 |
product |
4589 |
M |
0 |
|
|
0 |
|
|
|
|
2614 |
1172 |
product |
4590 |
M |
0 |
|
|
0 |
|
|
|
|
2616 |
1174 |
product |
4592 |
M |
0 |
|
|
0 |
|
|
|
|
2617 |
1175 |
product |
4593 |
M |
0 |
|
|
0 |
|
|
|
|
2618 |
1176 |
product |
4594 |
M |
0 |
|
|
0 |
|
|
|
|
2619 |
1177 |
product |
4595 |
M |
0 |
|
|
0 |
|
|
|
|
2620 |
1178 |
product |
4596 |
M |
0 |
|
|
0 |
|
|
|
|
2621 |
1179 |
product |
4597 |
M |
0 |
|
|
0 |
|
|
|
|
2622 |
1180 |
product |
4598 |
M |
0 |
|
|
0 |
|
|
|
|
2623 |
1181 |
product |
4599 |
M |
0 |
|
|
0 |
|
|
|
|
2624 |
1182 |
product |
4600 |
M |
0 |
|
|
0 |
|
|
|
|
2687 |
1209 |
product |
4663 |
M |
0 |
|
|
0 |
|
|
|
|
2706 |
1228 |
product |
4682 |
M |
0 |
|
|
0 |
|
|
|
|
2714 |
1236 |
product |
4690 |
M |
0 |
|
|
0 |
|
|
|
|
2730 |
1252 |
product |
4706 |
M |
0 |
|
|
0 |
|
|
|
|
2731 |
1253 |
product |
4707 |
M |
0 |
|
|
0 |
|
|
|
|
2732 |
1254 |
product |
4708 |
M |
0 |
|
|
0 |
|
|
|
|
2736 |
1258 |
product |
4712 |
M |
0 |
|
|
0 |
|
|
|
|
2737 |
1259 |
product |
4713 |
M |
0 |
|
|
0 |
|
|
|
|
2738 |
1260 |
product |
4714 |
M |
0 |
|
|
0 |
|
|
|
|
2739 |
1261 |
product |
4715 |
M |
0 |
|
|
0 |
|
|
|
|
2740 |
1262 |
product |
4716 |
M |
0 |
|
|
0 |
|
|
|
|
2741 |
1263 |
product |
4717 |
M |
0 |
|
|
0 |
|
|
|
|
2742 |
1264 |
product |
4718 |
M |
0 |
|
|
0 |
|
|
|
|
5701 |
2423 |
product |
7672 |
M |
0 |
|
|
0 |
|
|
|
|
5702 |
2424 |
product |
7673 |
M |
0 |
|
|
0 |
|
|
|
|
37686 |
1173 |
product |
39648 |
M |
0 |
|
|
0 |
|
|
|
|
41860 |
1257 |
product |
43822 |
M |
0 |
|
|