Query time 0.00189
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "174.01"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "30.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": 30,
"rows_produced_per_join": 30,
"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 ('8764','8765','8766','8767','8768','8769','8770','8771','8772','8773','8774','8776','8788','8825','8826','8827','8828','8829','8830','8831','8832','8833','8834','8835','8841','8843','8844','8845','8846','8847')))",
"cost_info": {
"read_cost": "66.01",
"eval_cost": "6.00",
"prefix_cost": "72.01",
"data_read_per_join": "2K"
},
"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": 30,
"filtered": "100.00",
"cost_info": {
"read_cost": "30.00",
"eval_cost": "6.00",
"prefix_cost": "108.01",
"data_read_per_join": "22K"
},
"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": 30,
"filtered": "100.00",
"cost_info": {
"read_cost": "30.00",
"eval_cost": "6.00",
"prefix_cost": "144.01",
"data_read_per_join": "17K"
},
"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 |
|
|
|
|
18920 |
8764 |
product |
20882 |
M |
0 |
|
|
0 |
|
|
|
|
18931 |
8765 |
product |
20893 |
M |
0 |
|
|
0 |
|
|
|
|
18939 |
8767 |
product |
20901 |
M |
0 |
|
|
0 |
|
|
|
|
18963 |
8771 |
product |
20925 |
M |
0 |
|
|
0 |
|
|
|
|
18967 |
8772 |
product |
20929 |
M |
0 |
|
|
0 |
|
|
|
|
18971 |
8773 |
product |
20933 |
M |
0 |
|
|
0 |
|
|
|
|
18975 |
8774 |
product |
20937 |
M |
0 |
|
|
0 |
|
|
|
|
19025 |
8776 |
product |
20987 |
M |
0 |
|
|
0 |
|
|
|
|
19065 |
8788 |
product |
21027 |
M |
0 |
|
|
0 |
|
|
|
|
19332 |
8825 |
product |
21294 |
M |
0 |
|
|
0 |
|
|
|
|
19349 |
8828 |
product |
21311 |
M |
0 |
|
|
0 |
|
|
|
|
19358 |
8827 |
product |
21320 |
M |
0 |
|
|
0 |
|
|
|
|
19367 |
8828 |
product |
21329 |
M |
0 |
|
|
0 |
|
|
|
|
19376 |
8826 |
product |
21338 |
M |
0 |
|
|
0 |
|
|
|
|
19479 |
8829 |
product |
21441 |
M |
0 |
|
|
0 |
|
|
|
|
19488 |
8830 |
product |
21450 |
M |
0 |
|
|
0 |
|
|
|
|
19497 |
8831 |
product |
21459 |
M |
0 |
|
|
0 |
|
|
|
|
19504 |
8832 |
product |
21466 |
M |
0 |
|
|
0 |
|
|
|
|
19511 |
8833 |
product |
21473 |
M |
0 |
|
|
0 |
|
|
|
|
19520 |
8834 |
product |
21482 |
M |
0 |
|
|
0 |
|
|
|
|
19534 |
8835 |
product |
21496 |
M |
0 |
|
|
0 |
|
|
|
|
19573 |
8841 |
product |
21535 |
M |
0 |
|
|
0 |
|
|
|
|
19594 |
8843 |
product |
21556 |
M |
0 |
|
|
0 |
|
|
|
|
19597 |
8844 |
product |
21559 |
M |
0 |
|
|
0 |
|
|
|
|
19600 |
8845 |
product |
21562 |
M |
0 |
|
|
0 |
|
|
|
|
19602 |
8846 |
product |
21564 |
M |
0 |
|
|
0 |
|
|
|
|
19605 |
8847 |
product |
21567 |
M |
0 |
|
|
0 |
|
|
|
|
77935 |
8766 |
product |
79878 |
M |
0 |
|
|
0 |
|
|
|
|
82096 |
8768 |
product |
84039 |
M |
0 |
|
|
0 |
|
|
|
|
82814 |
8770 |
product |
84757 |
M |
0 |
|
|
0 |
|
|
|
|
83053 |
8769 |
product |
84996 |
M |
0 |
|
|