Query time 0.00234
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "228.81"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "41.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": 41,
"rows_produced_per_join": 41,
"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 ('8501','8503','8504','8506','8507','8508','8509','8510','8511','8512','8514','8515','8516','8517','8518','8519','8521','8477','8476','8474','8377','8376','8375','8374','8368','8367','8272','8271','8270','8269','8268','8267')))",
"cost_info": {
"read_cost": "81.21",
"eval_cost": "8.20",
"prefix_cost": "89.41",
"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": 41,
"filtered": "100.00",
"cost_info": {
"read_cost": "41.00",
"eval_cost": "8.20",
"prefix_cost": "138.61",
"data_read_per_join": "31K"
},
"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": 41,
"filtered": "100.00",
"cost_info": {
"read_cost": "41.00",
"eval_cost": "8.20",
"prefix_cost": "187.81",
"data_read_per_join": "24K"
},
"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 |
e5f7272efeae4eb5a0b62810aadbdfbf.jpg |
750 |
750 |
N |
17241 |
8269 |
product |
19203 |
A |
1 |
|
19203 |
0 |
6ffb809175ea4640b9022f305bfcc508.jpg |
1000 |
1000 |
N |
17246 |
8271 |
product |
19208 |
A |
1 |
|
19208 |
0 |
41VUM72gk1L.jpg |
500 |
500 |
N |
17252 |
8272 |
product |
19214 |
A |
1 |
|
19214 |
0 |
31hIHS_10FL.jpg |
169 |
500 |
N |
17496 |
8367 |
product |
19458 |
A |
1 |
|
19458 |
0 |
d39817d619574139b7a27eb370ac76fb.jpg |
750 |
750 |
N |
17499 |
8368 |
product |
19461 |
A |
1 |
|
19461 |
0 |
e0aab917fe204bb8946cc94f2ec83b94.jpg |
900 |
900 |
N |
17516 |
8374 |
product |
19478 |
A |
1 |
|
19478 |
0 |
d2409b5edb5d4107a2e06b61942eda33.jpg |
1200 |
1200 |
N |
17518 |
8375 |
product |
19480 |
A |
1 |
|
19480 |
0 |
52ee58b04d3e425689b77362a60d853e.jpg |
1200 |
1200 |
N |
17520 |
8376 |
product |
19482 |
A |
1 |
|
19482 |
0 |
96e5776febdc4c7aa8f1dabe6b67bb78.jpg |
900 |
900 |
N |
17545 |
8377 |
product |
19507 |
A |
1 |
|
19507 |
0 |
31igUXulTcL.jpg |
500 |
500 |
N |
17941 |
8476 |
product |
19903 |
A |
1 |
|
19903 |
0 |
61ndmiFT6JL._SL1000_.jpg |
1000 |
1000 |
N |
18290 |
8514 |
product |
20252 |
A |
1 |
|
20252 |
0 |
71TPl0RKQ-L._SL1500_.jpg |
1500 |
1500 |
N |
18298 |
8521 |
product |
20260 |
A |
1 |
|
20260 |
0 |
919asFm2vvL._SL1500_.jpg |
1500 |
1500 |
N |
18325 |
8504 |
product |
20287 |
A |
1 |
|
20287 |
0 |
51hCNiViHeL._SL1200_.jpg |
1200 |
1200 |
N |
18328 |
8510 |
product |
20290 |
A |
1 |
|
20290 |
0 |
31-jDh5_J8L.jpg |
500 |
375 |
N |
18330 |
8511 |
product |
20292 |
A |
1 |
|
20292 |
0 |
51nJZOJpMaL._SL1000_.jpg |
1000 |
348 |
N |
18332 |
8507 |
product |
20294 |
A |
1 |
|
20294 |
0 |
41WPjS5QW6L.jpg |
480 |
360 |
N |
18334 |
8515 |
product |
20296 |
A |
1 |
|
20296 |
0 |
618NJU2VoTL._SL1000_.jpg |
1000 |
1000 |
N |
18337 |
8508 |
product |
20299 |
A |
1 |
|
20299 |
0 |
41zNoGGeZFL.jpg |
500 |
230 |
N |
18344 |
8512 |
product |
20306 |
A |
1 |
|
20306 |
0 |
71Hs-7uyr2L._SL1500_.jpg |
1500 |
978 |
N |
18346 |
8517 |
product |
20308 |
A |
1 |
|
20308 |
0 |
41JbMkPkNUL.jpg |
500 |
500 |
N |
18348 |
8518 |
product |
20310 |
A |
1 |
|
20310 |
0 |
8b6e98a946d44c96bd55c3087681a42d.jpg |
1000 |
1000 |
N |
18750 |
8270 |
product |
20712 |
A |
1 |
|
20712 |
0 |
61kdJ-R7ArL._SX522_.jpg |
522 |
522 |
N |
19342 |
8477 |
product |
21304 |
A |
1 |
|
21304 |
0 |
71GeaaBNcfL._SX679_.jpg |
679 |
238 |
N |
19581 |
8509 |
product |
21543 |
A |
1 |
|
21543 |
0 |
4817379aecd1454ebb19e4ce38e7193e.jpg |
900 |
900 |
N |
17244 |
8270 |
product |
19206 |
A |
2 |
|
19206 |
0 |
99a718b43dba45f28ab29ed02299df48.jpg |
1000 |
1000 |
N |
17247 |
8271 |
product |
19209 |
A |
2 |
|
19209 |
0 |
542ea7b29bfa4cbd93f23451ec08b425.jpg |
900 |
900 |
N |
17521 |
8376 |
product |
19483 |
A |
2 |
|
19483 |
0 |
81l4xAYx1EL._SL1500_.jpg |
1500 |
837 |
N |
18291 |
8514 |
product |
20253 |
A |
2 |
|
20253 |
0 |
81QuQvdGnqL._SL1500_.jpg |
1500 |
1500 |
N |
18299 |
8521 |
product |
20261 |
A |
2 |
|
20261 |
0 |
81eXf64xSYL._SL1500_.jpg |
1500 |
844 |
N |
18326 |
8504 |
product |
20288 |
A |
2 |
|
20288 |
0 |
51sVFg7w3gL._SL1200_.jpg |
433 |
1200 |
N |
18331 |
8507 |
product |
20293 |
A |
2 |
|
20293 |
0 |
61O3nlkSznL._SL1000_.jpg |
1000 |
1000 |
N |
18338 |
8508 |
product |
20300 |
A |
2 |
|
20300 |
0 |
71rs1SIhB0L._SL1500_.jpg |
1000 |
1500 |
N |
18349 |
8518 |
product |
20311 |
A |
2 |
|
20311 |
0 |
81a4CzBPkIL._SX355_.jpg |
355 |
239 |
N |
19582 |
8509 |
product |
21544 |
A |
2 |
|
21544 |
0 |
Screen_Shot_2019-05-21_at_3.29.43_PM.png |
530 |
501 |
N |
19584 |
8519 |
product |
21546 |
A |
2 |
|
21546 |
0 |
0b6bbcb79b084673a1c29a455c291ec3.jpg |
1000 |
1000 |
N |
17248 |
8271 |
product |
19210 |
A |
3 |
|
19210 |
0 |
4817379aecd1454ebb19e4ce38e7193e.jpg |
900 |
900 |
N |
18751 |
8270 |
product |
20713 |
A |
3 |
|
20713 |
0 |
61649Aa1T-L._SX522_.jpg |
522 |
522 |
N |
19343 |
8477 |
product |
21305 |
A |
3 |
|
21305 |
0 |
Screen_Shot_2019-05-21_at_3.29.58_PM.png |
483 |
575 |
N |
19585 |
8519 |
product |
21547 |
A |
3 |
|
21547 |
0 |
6b505693af864e18a7ab10eff7d437ed.jpg |
1000 |
1000 |
N |
17249 |
8271 |
product |
19211 |
A |
4 |
|
19211 |
0 |
71HjszvW01L._SX522_.jpg |
522 |
522 |
N |
19344 |
8477 |
product |
21306 |
A |
4 |
|
21306 |
0 |
214b63b35e094708ae1d7cc60ce232ba.jpg |
1000 |
1000 |
N |
17250 |
8271 |
product |
19212 |
A |
5 |
|
19212 |