Query time 0.00598
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.image_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"
]
}
},
{
"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 |
|
|
|
|
48418 |
30665 |
product |
50379 |
M |
0 |
|
|
0 |
|
|
|
|
48425 |
30659 |
product |
50386 |
M |
0 |
|
|
0 |
|
|
|
|
48555 |
30353 |
product |
50516 |
M |
0 |
|
|
0 |
|
|
|
|
48556 |
30352 |
product |
50517 |
M |
0 |
|
|
0 |
|
|
|
|
48557 |
30351 |
product |
50518 |
M |
0 |
|
|
0 |
|
|
|
|
48558 |
30350 |
product |
50519 |
M |
0 |
|
|
0 |
|
|
|
|
48560 |
30348 |
product |
50521 |
M |
0 |
|
|
0 |
|
|
|
|
48562 |
30345 |
product |
50523 |
M |
0 |
|
|
0 |
|
|
|
|
48569 |
30337 |
product |
50530 |
M |
0 |
|
|
0 |
|
|
|
|
48570 |
30336 |
product |
50531 |
M |
0 |
|
|
0 |
|
|
|
|
48571 |
30334 |
product |
50532 |
M |
0 |
|
|
0 |
|
|
|
|
48572 |
30333 |
product |
50533 |
M |
0 |
|
|
0 |
|
|
|
|
48579 |
30330 |
product |
50540 |
M |
0 |
|
|
0 |
|
|
|
|
48582 |
30287 |
product |
50543 |
M |
0 |
|
|
0 |
|
|
|
|
48593 |
30289 |
product |
50554 |
M |
0 |
|
|
0 |
|
|
|
|
48596 |
30290 |
product |
50557 |
M |
0 |
|
|
0 |
|
|
|
|
48598 |
30291 |
product |
50559 |
M |
0 |
|
|
0 |
|
|
|
|
48602 |
30292 |
product |
50563 |
M |
0 |
|
|
0 |
|
|
|
|
48604 |
30293 |
product |
50565 |
M |
0 |
|
|
0 |
|
|
|
|
48605 |
30294 |
product |
50566 |
M |
0 |
|
|
0 |
|
|
|
|
48608 |
30295 |
product |
50569 |
M |
0 |
|
|
0 |
|
|
|
|
48623 |
30327 |
product |
50584 |
M |
0 |
|
|
0 |
|
|
|
|
48625 |
30326 |
product |
50586 |
M |
0 |
|
|
0 |
|
|
|
|
48627 |
30325 |
product |
50588 |
M |
0 |
|
|
0 |
|
|
|
|
48633 |
30323 |
product |
50594 |
M |
0 |
|
|
0 |
|
|
|
|
48636 |
30322 |
product |
50597 |
M |
0 |
|
|
0 |
|
|
|
|
48654 |
30296 |
product |
50615 |
M |
0 |
|
|
0 |
|
|
|
|
48661 |
30297 |
product |
50622 |
M |
0 |
|
|
0 |
|
|
|
|
48662 |
30298 |
product |
50623 |
M |
0 |
|
|
0 |
|
|
|
|
48663 |
30299 |
product |
50624 |
M |
0 |
|
|
0 |
|
|
|
|
48664 |
30300 |
product |
50625 |
M |
0 |
|
|
0 |
|
|
|
|
48668 |
30307 |
product |
50629 |
M |
0 |
|
|
0 |
|
|
|
|
48677 |
30309 |
product |
50638 |
M |
0 |
|
|
0 |
|
|
|
|
48679 |
30310 |
product |
50640 |
M |
0 |
|
|
0 |
|
|
|
|
48681 |
30311 |
product |
50642 |
M |
0 |
|
|
0 |
|
|
|
|
48689 |
30312 |
product |
50650 |
M |
0 |
|
|
0 |
|
|
|
|
48690 |
30313 |
product |
50651 |
M |
0 |
|
|
0 |
|
|
|
|
48693 |
30314 |
product |
50654 |
M |
0 |
|
|
0 |
|
|
|
|
48694 |
30315 |
product |
50655 |
M |
0 |
|
|
0 |
|
|
|
|
48696 |
30316 |
product |
50657 |
M |
0 |
|
|
0 |
|
|
|
|
48713 |
30317 |
product |
50674 |
M |
0 |
|
|
0 |
|
|
|
|
48715 |
30318 |
product |
50676 |
M |
0 |
|
|
0 |
|
|
|
|
48719 |
30320 |
product |
50680 |
M |
0 |
|
|
0 |
|
|
|
|
48723 |
30321 |
product |
50684 |
M |
0 |
|
|
0 |
|
|
|
|
49005 |
30306 |
product |
50966 |
M |
0 |
|
|
0 |
|
|
|
|
49007 |
30305 |
product |
50968 |
M |
0 |
|
|
0 |
|
|
|
|
49009 |
30304 |
product |
50970 |
M |
0 |
|
|
0 |
|
|
|
|
49010 |
30303 |
product |
50971 |
M |
0 |
|
|
0 |
|
|
|
|
49011 |
30302 |
product |
50972 |
M |
0 |
|
|
0 |
|
|
|
|
49015 |
30286 |
product |
50976 |
M |
0 |
|
|
0 |
|
|
|
|
49016 |
30285 |
product |
50977 |
M |
0 |
|
|
0 |
|
|
|
|
49018 |
30284 |
product |
50979 |
M |
0 |
|
|
0 |
|
|
|
|
49020 |
30283 |
product |
50981 |
M |
0 |
|
|
0 |
|
|
|
|
49022 |
30282 |
product |
50983 |
M |
0 |
|
|
0 |
|
|
|
|
49024 |
30281 |
product |
50985 |
M |
0 |
|
|
0 |
|
|
|
|
49187 |
30383 |
product |
51148 |
M |
0 |
|
|
0 |
|
|
|
|
49315 |
30408 |
product |
51276 |
M |
0 |
|
|
0 |
|
|
|
|
49320 |
30405 |
product |
51281 |
M |
0 |
|
|
0 |
|
|
|
|
49382 |
30697 |
product |
51343 |
M |
0 |
|
|
0 |
|
|
|
|
49384 |
30696 |
product |
51345 |
M |
0 |
|
|
0 |
|
|
|
|
51305 |
30331 |
product |
53266 |
M |
0 |
|
|
0 |
|
|
|
|
53822 |
30288 |
product |
55783 |
M |
0 |
|
|
0 |
|
|
|
|
65492 |
30324 |
product |
67443 |
M |
0 |
|
|
0 |
|
|
|
|
49013 |
30301 |
product |
50974 |
M |
1 |
|
|