Query time 0.00329
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "702.41"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "133.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": 133,
"rows_produced_per_join": 133,
"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 ('30281','30282','30283','30284','30285','30286','30287','30288','30289','30290','30291','30292','30293','30294','30295','30296','30297','30298','30299','30300','30301','30302','30303','30304','30305','30306','30307','30309','30310','30311','30312','30313','30314','30315','30316','30317','30318','30320','30321','30322','30323','30324','30325','30326','30327','30330','30331','30333','30334','30336','30337','30345','30348','30350','30351','30352','30353','30383','30405','30408','30659','30665','30696','30697')))",
"cost_info": {
"read_cost": "223.61",
"eval_cost": "26.60",
"prefix_cost": "250.21",
"data_read_per_join": "12K"
},
"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": 133,
"filtered": "100.00",
"cost_info": {
"read_cost": "133.00",
"eval_cost": "26.60",
"prefix_cost": "409.81",
"data_read_per_join": "101K"
},
"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": 133,
"filtered": "100.00",
"cost_info": {
"read_cost": "133.00",
"eval_cost": "26.60",
"prefix_cost": "569.41",
"data_read_per_join": "78K"
},
"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 |
51ZJq7iDXwL.jpg |
440 |
500 |
N |
48418 |
30665 |
product |
50379 |
M |
0 |
|
50379 |
0 |
41_oyKpUMFL._SX466_.jpg |
466 |
486 |
N |
48425 |
30659 |
product |
50386 |
M |
0 |
|
50386 |
0 |
61W3QsvAA7L._AC_UL436_.jpg |
141 |
436 |
N |
48555 |
30353 |
product |
50516 |
M |
0 |
|
50516 |
0 |
61NgWn1O7cL._AC_UL436_.jpg |
297 |
436 |
N |
48556 |
30352 |
product |
50517 |
M |
0 |
|
50517 |
0 |
download__1__unkh-k1.jpg |
296 |
445 |
N |
48557 |
30351 |
product |
50518 |
M |
0 |
|
50518 |
0 |
download__2__3b7h-20.jpg |
334 |
445 |
N |
48558 |
30350 |
product |
50519 |
M |
0 |
|
50519 |
0 |
71b_PICd0AL._AC_UL436_.jpg |
316 |
436 |
N |
48560 |
30348 |
product |
50521 |
M |
0 |
|
50521 |
0 |
51DVdbQ99uL._AC_UL436_.jpg |
314 |
436 |
N |
48562 |
30345 |
product |
50523 |
M |
0 |
|
50523 |
0 |
41zF6Z-JXWL._AC_UL320_.jpg |
320 |
320 |
N |
48569 |
30337 |
product |
50530 |
M |
0 |
|
50530 |
0 |
61DsJBL2n7L._AC_UL320_.jpg |
221 |
320 |
N |
48570 |
30336 |
product |
50531 |
M |
0 |
|
50531 |
0 |
41Z4Pqn1fBL._AC_UL320_.jpg |
320 |
320 |
N |
48571 |
30334 |
product |
50532 |
M |
0 |
|
50532 |
0 |
81VrAnft63L._AC_UL320_.jpg |
213 |
320 |
N |
48572 |
30333 |
product |
50533 |
M |
0 |
|
50533 |
0 |
61_0nnnEs7L._AC_UL320_.jpg |
223 |
320 |
N |
48579 |
30330 |
product |
50540 |
M |
0 |
|
50540 |
0 |
61ZBOgHxQdL._AC_UL320_.jpg |
223 |
320 |
N |
48582 |
30287 |
product |
50543 |
M |
0 |
|
50543 |
0 |
815SJScmpAL._AC_UL320_.jpg |
213 |
320 |
N |
48593 |
30289 |
product |
50554 |
M |
0 |
|
50554 |
0 |
81Iv8ukAyoL._AC_UL320_.jpg |
213 |
320 |
N |
48596 |
30290 |
product |
50557 |
M |
0 |
|
50557 |
0 |
612O89JNtqL._AC_UL320_.jpg |
223 |
320 |
N |
48598 |
30291 |
product |
50559 |
M |
0 |
|
50559 |
0 |
61QFhnDkxjL._AC_UL320_.jpg |
240 |
320 |
N |
48602 |
30292 |
product |
50563 |
M |
0 |
|
50563 |
0 |
61QFhnDkxjL._AC_UL320__mo76-xj.jpg |
240 |
320 |
N |
48604 |
30293 |
product |
50565 |
M |
0 |
|
50565 |
0 |
61_0nnnEs7L._AC_UL320__ezoc-wn.jpg |
223 |
320 |
N |
48605 |
30294 |
product |
50566 |
M |
0 |
|
50566 |
0 |
61hjJOjlY0L._AC_UL320_.jpg |
223 |
320 |
N |
48608 |
30295 |
product |
50569 |
M |
0 |
|
50569 |
0 |
61uqonDWjiL._AC_UL320_.jpg |
121 |
320 |
N |
48623 |
30327 |
product |
50584 |
M |
0 |
|
50584 |
0 |
61zB7uVxU1L._AC_UL320_.jpg |
145 |
320 |
N |
48625 |
30326 |
product |
50586 |
M |
0 |
|
50586 |
0 |
616k1Fz_vJL._AC_UL320_.jpg |
217 |
320 |
N |
48627 |
30325 |
product |
50588 |
M |
0 |
|
50588 |
0 |
61vr4HrsObL._AC_UL320_.jpg |
221 |
320 |
N |
48633 |
30323 |
product |
50594 |
M |
0 |
|
50594 |
0 |
41GAb0hxi4L._AC_UL320_.jpg |
320 |
320 |
N |
48636 |
30322 |
product |
50597 |
M |
0 |
|
50597 |
0 |
41R04IbjLYL._AC_UL320_.jpg |
320 |
320 |
N |
48654 |
30296 |
product |
50615 |
M |
0 |
|
50615 |
0 |
51bRAKoPx5L._AC_UL320_.jpg |
240 |
320 |
N |
48661 |
30297 |
product |
50622 |
M |
0 |
|
50622 |
0 |
download__1__fmnj-xe.jpg |
296 |
445 |
N |
48662 |
30298 |
product |
50623 |
M |
0 |
|
50623 |
0 |
download__2__0r3m-ye.jpg |
334 |
445 |
N |
48663 |
30299 |
product |
50624 |
M |
0 |
|
50624 |
0 |
download__3__ydpg-tw.jpg |
342 |
342 |
N |
48664 |
30300 |
product |
50625 |
M |
0 |
|
50625 |
0 |
download__4__bucd-1b.jpg |
296 |
445 |
N |
48668 |
30307 |
product |
50629 |
M |
0 |
|
50629 |
0 |
download__5__ujyp-6o.jpg |
334 |
445 |
N |
48677 |
30309 |
product |
50638 |
M |
0 |
|
50638 |
0 |
download__6__laho-q0.jpg |
342 |
342 |
N |
48679 |
30310 |
product |
50640 |
M |
0 |
|
50640 |
0 |
71pTcNivZYL._AC_UL320_.jpg |
126 |
320 |
N |
48681 |
30311 |
product |
50642 |
M |
0 |
|
50642 |
0 |
61hdjCe65TL._AC_UL320_.jpg |
218 |
320 |
N |
48689 |
30312 |
product |
50650 |
M |
0 |
|
50650 |
0 |
71tf7v5sqeL._AC_UL320_.jpg |
121 |
320 |
N |
48690 |
30313 |
product |
50651 |
M |
0 |
|
50651 |
0 |
download__7__zac6-wj.jpg |
296 |
445 |
N |
48693 |
30314 |
product |
50654 |
M |
0 |
|
50654 |
0 |
61mIWgmf6EL._AC_UL320_.jpg |
223 |
320 |
N |
48694 |
30315 |
product |
50655 |
M |
0 |
|
50655 |
0 |
download__8__egg7-bx.jpg |
334 |
445 |
N |
48696 |
30316 |
product |
50657 |
M |
0 |
|
50657 |
0 |
61vr4HrsObL._AC_UL320__yx3l-qf.jpg |
221 |
320 |
N |
48713 |
30317 |
product |
50674 |
M |
0 |
|
50674 |
0 |
download__10__n4re-66.jpg |
342 |
342 |
N |
48715 |
30318 |
product |
50676 |
M |
0 |
|
50676 |
0 |
download__11_.jpg |
342 |
342 |
N |
48719 |
30320 |
product |
50680 |
M |
0 |
|
50680 |
0 |
41IC0X5GTmL._SX425_.jpg |
425 |
425 |
N |
48723 |
30321 |
product |
50684 |
M |
0 |
|
50684 |
0 |
61eD46Go1FL._SY445__0nxl-h7.jpg |
334 |
445 |
N |
49005 |
30306 |
product |
50966 |
M |
0 |
|
50966 |
0 |
61zB7uVxU1L._SX385_.jpg |
385 |
385 |
N |
49007 |
30305 |
product |
50968 |
M |
0 |
|
50968 |
0 |
61hjJOjlY0L._SY445_.jpg |
334 |
445 |
N |
49009 |
30304 |
product |
50970 |
M |
0 |
|
50970 |
0 |
81zGXnvxkpL._SY445__zsky-7x.jpg |
297 |
445 |
N |
49010 |
30303 |
product |
50971 |
M |
0 |
|
50971 |
0 |
416cPvDBj-L._SX342_.jpg |
342 |
342 |
N |
49011 |
30302 |
product |
50972 |
M |
0 |
|
50972 |
0 |
51bRAKoPx5L._SY445_.jpg |
334 |
445 |
N |
49015 |
30286 |
product |
50976 |
M |
0 |
|
50976 |
0 |
614exjXWuBL._SY445_.jpg |
334 |
445 |
N |
49016 |
30285 |
product |
50977 |
M |
0 |
|
50977 |
0 |
71srusStg7L._SX385_.jpg |
385 |
385 |
N |
49018 |
30284 |
product |
50979 |
M |
0 |
|
50979 |
0 |
61OamiT2TqL._SY445_.jpg |
334 |
445 |
N |
49020 |
30283 |
product |
50981 |
M |
0 |
|
50981 |
0 |
61ZBOgHxQdL._SY445_.jpg |
334 |
445 |
N |
49022 |
30282 |
product |
50983 |
M |
0 |
|
50983 |
0 |
71Llx1LymkL._SX385_.jpg |
385 |
385 |
N |
49024 |
30281 |
product |
50985 |
M |
0 |
|
50985 |
0 |
41kFeb1Ki9L.jpg |
500 |
494 |
N |
49187 |
30383 |
product |
51148 |
M |
0 |
|
51148 |
0 |
41eTJkkULnL.jpg |
500 |
389 |
N |
49315 |
30408 |
product |
51276 |
M |
0 |
|
51276 |
0 |
31aDz1wf_ZL.jpg |
500 |
394 |
N |
49320 |
30405 |
product |
51281 |
M |
0 |
|
51281 |
0 |
41FK8xd-XzL.jpg |
500 |
439 |
N |
49382 |
30697 |
product |
51343 |
M |
0 |
|
51343 |
0 |
61uSk-ZlUbL._SX385_.jpg |
385 |
385 |
N |
49384 |
30696 |
product |
51345 |
M |
0 |
|
51345 |
0 |
shirt.jpg |
640 |
626 |
N |
51305 |
30331 |
product |
53266 |
M |
0 |
|
53266 |
0 |
top_web.jpg |
640 |
626 |
N |
53822 |
30288 |
product |
55783 |
M |
0 |
|
55783 |
0 |
51bZch7ihiL._SX466_.jpg |
466 |
466 |
N |
65492 |
30324 |
product |
67443 |
M |
0 |
|
67443 |
0 |
61W3QsvAA7L._SX385__2ha8-wv.jpg |
385 |
385 |
N |
49013 |
30301 |
product |
50974 |
M |
1 |
|
50974 |