Query time 0.00261
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "185.61"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "32.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": 32,
"rows_produced_per_join": 32,
"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 ('32590','32591','32592','32593','32594','32595','32596','32597','32598','32599','32600','32601','32602','32603','32604','32605','32606','32607','32608','32609','32610','32611','32612','32613','32614','32615','32616','32617','32618','32619','32620','32621')))",
"cost_info": {
"read_cost": "70.41",
"eval_cost": "6.40",
"prefix_cost": "76.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": 32,
"filtered": "100.00",
"cost_info": {
"read_cost": "32.00",
"eval_cost": "6.40",
"prefix_cost": "115.21",
"data_read_per_join": "24K"
},
"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": 32,
"filtered": "100.00",
"cost_info": {
"read_cost": "32.00",
"eval_cost": "6.40",
"prefix_cost": "153.61",
"data_read_per_join": "19K"
},
"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 |
25104M-1-2.jpg |
4218 |
4000 |
N |
42923 |
32599 |
product |
44885 |
M |
0 |
|
44885 |
0 |
25110L-1-1.jpg |
6000 |
4000 |
N |
42938 |
32603 |
product |
44900 |
M |
0 |
|
44900 |
0 |
25110L-2-1.jpg |
6000 |
4000 |
N |
42942 |
32604 |
product |
44904 |
M |
0 |
|
44904 |
0 |
25110L-3-1.jpg |
5828 |
3865 |
N |
42946 |
32605 |
product |
44908 |
M |
0 |
|
44908 |
0 |
25116M-1-4.jpg |
6000 |
4000 |
N |
42953 |
32606 |
product |
44915 |
M |
0 |
|
44915 |
0 |
25130M-5-1.jpg |
4348 |
4000 |
N |
42989 |
32616 |
product |
44951 |
M |
0 |
|
44951 |
0 |
25140L-1-1.jpg |
4058 |
4000 |
N |
42993 |
32617 |
product |
44955 |
M |
0 |
|
44955 |
0 |
25140L-1P-1.jpg |
5560 |
4000 |
N |
42996 |
32618 |
product |
44958 |
M |
0 |
|
44958 |
0 |
25140M-1-1-1.jpg |
4211 |
4000 |
N |
43007 |
32621 |
product |
44969 |
M |
0 |
|
44969 |
0 |
23071M-3-3.jpg |
4617 |
3834 |
N |
44530 |
32598 |
product |
46492 |
M |
0 |
|
46492 |
0 |
watch2.jpg |
640 |
626 |
N |
48303 |
32614 |
product |
50264 |
M |
0 |
|
50264 |
0 |
Screen_Shot_2019-08-19_at_12.10.38_PM.png |
645 |
673 |
N |
53848 |
32619 |
product |
55809 |
M |
0 |
|
55809 |
0 |
Screen_Shot_2019-08-19_at_1.31.05_PM.png |
850 |
710 |
N |
53994 |
32620 |
product |
55955 |
M |
0 |
|
55955 |
0 |
23071M-2-2.jpg |
6000 |
4000 |
N |
42915 |
32597 |
product |
44877 |
M |
10 |
|
44877 |
0 |
25116M-2-2.jpg |
5399 |
3788 |
N |
42955 |
32607 |
product |
44917 |
M |
10 |
|
44917 |
0 |
25116M-3-2.jpg |
4382 |
4000 |
N |
42959 |
32608 |
product |
44921 |
M |
10 |
|
44921 |
0 |
25119M-1-2.jpg |
4393 |
4000 |
N |
42963 |
32609 |
product |
44925 |
M |
10 |
|
44925 |
0 |
25119M-2-2.jpg |
5399 |
3788 |
N |
42967 |
32610 |
product |
44929 |
M |
10 |
|
44929 |
0 |
25119M-3-2.jpg |
4452 |
4000 |
N |
42970 |
32611 |
product |
44932 |
M |
10 |
|
44932 |
0 |
25130M-2-2.jpg |
6000 |
4000 |
N |
42978 |
32613 |
product |
44940 |
M |
10 |
|
44940 |
0 |
25130M-4-2.jpg |
4826 |
4000 |
N |
42986 |
32615 |
product |
44948 |
M |
10 |
|
44948 |
0 |
23026M-1-2.jpg |
6000 |
4000 |
N |
44494 |
32590 |
product |
46456 |
M |
10 |
|
46456 |
0 |
23026M-2-2.jpg |
6000 |
4000 |
N |
44497 |
32591 |
product |
46459 |
M |
10 |
|
46459 |
0 |
23026M-3-2.jpg |
6000 |
4000 |
N |
44505 |
32592 |
product |
46467 |
M |
10 |
|
46467 |
0 |
23044M-1-2.jpg |
6000 |
4000 |
N |
44508 |
32593 |
product |
46470 |
M |
10 |
|
46470 |
0 |
23044M-2-2.jpg |
6000 |
4000 |
N |
44512 |
32594 |
product |
46474 |
M |
10 |
|
46474 |
0 |
23044M-3-2.jpg |
6000 |
4000 |
N |
44516 |
32595 |
product |
46478 |
M |
10 |
|
46478 |
0 |
23071M-1-2.jpg |
4207 |
3936 |
N |
44520 |
32596 |
product |
46482 |
M |
10 |
|
46482 |
0 |
25104M-2-2.jpg |
3890 |
3878 |
N |
44536 |
32600 |
product |
46498 |
M |
10 |
|
46498 |
0 |
25130M-1-2.jpg |
6000 |
4000 |
N |
44576 |
32612 |
product |
46538 |
M |
10 |
|
46538 |