Query time 0.00167
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "209.61"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "37.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": 37,
"rows_produced_per_join": 37,
"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 ('8982','8983','8986','8987','8991','8992','8993','8994','8995','8996','8997','8998','8999','9000','9001','9002','9003','9004','9005','9006','9007','9008','9009','9010','9011','9012','9013','9014','9015','9016','9017','9018')))",
"cost_info": {
"read_cost": "76.41",
"eval_cost": "7.40",
"prefix_cost": "83.81",
"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": 37,
"filtered": "100.00",
"cost_info": {
"read_cost": "37.00",
"eval_cost": "7.40",
"prefix_cost": "128.21",
"data_read_per_join": "28K"
},
"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": 37,
"filtered": "100.00",
"cost_info": {
"read_cost": "37.00",
"eval_cost": "7.40",
"prefix_cost": "172.61",
"data_read_per_join": "21K"
},
"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 |
815okEydlmL._AC_SL1500_.jpg |
631 |
1500 |
N |
80739 |
9017 |
product |
82682 |
A |
0 |
|
82682 |
0 |
815okEydlmL._AC_SL1500__f4i1-2m.jpg |
631 |
1500 |
N |
80742 |
9017 |
product |
82685 |
A |
0 |
|
82685 |
0 |
MSHI-H-101512.jpg |
1000 |
1000 |
N |
19821 |
8998 |
product |
21783 |
A |
1 |
|
21783 |
0 |
61sscVPGTrL._AC_SL1500_.jpg |
1500 |
634 |
N |
80726 |
9000 |
product |
82669 |
A |
1 |
|
82669 |
0 |
04.jpg |
1600 |
1600 |
N |
80729 |
9010 |
product |
82672 |
A |
1 |
|
82672 |
0 |
71yEMZOE-AL._AC_SL1500_.jpg |
1500 |
1500 |
N |
80734 |
9014 |
product |
82677 |
A |
1 |
|
82677 |
0 |
51Cq5qje7nL._AC_SL1500_.jpg |
533 |
1331 |
N |
80736 |
9016 |
product |
82679 |
A |
1 |
|
82679 |
0 |
513A3tABIcL._AC_SL1000_.jpg |
532 |
782 |
N |
80725 |
8998 |
product |
82668 |
A |
2 |
|
82668 |
0 |
03.jpg |
1600 |
1600 |
N |
80728 |
9009 |
product |
82671 |
A |
2 |
|
82671 |
0 |
01.jpg |
1600 |
1600 |
N |
80730 |
9010 |
product |
82673 |
A |
2 |
|
82673 |
0 |
03_hris-fy.jpg |
1600 |
1600 |
N |
80732 |
9013 |
product |
82675 |
A |
2 |
|
82675 |
0 |
61FwsuEAMNL._AC_SL1500_.jpg |
1408 |
1500 |
N |
80735 |
9014 |
product |
82678 |
A |
2 |
|
82678 |
0 |
51L4zSsP5BL._AC_SL1200_.jpg |
1200 |
800 |
N |
80737 |
9016 |
product |
82680 |
A |
2 |
|
82680 |
0 |
61IoKWyjWpL._AC_SL1500_.jpg |
1058 |
1500 |
N |
80740 |
9017 |
product |
82683 |
A |
2 |
|
82683 |
0 |
61IoKWyjWpL._AC_SL1500__djvo-ra.jpg |
1058 |
1500 |
N |
80743 |
9017 |
product |
82686 |
A |
2 |
|
82686 |
0 |
04_7qzj-pu.jpg |
1600 |
1600 |
N |
80733 |
9013 |
product |
82676 |
A |
3 |
|
82676 |
0 |
51kmvViQRkL._AC_SL1500_.jpg |
1314 |
564 |
N |
80738 |
9016 |
product |
82681 |
A |
3 |
|
82681 |
0 |
51XrZnTQp6L._AC_SL1000_.jpg |
1000 |
1000 |
N |
80741 |
9017 |
product |
82684 |
A |
3 |
|
82684 |
0 |
51XrZnTQp6L._AC_SL1000__hya2-6i.jpg |
1000 |
1000 |
N |
80744 |
9017 |
product |
82687 |
A |
3 |
|
82687 |