Query time 0.00409
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "444.81"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "86.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": 86,
"rows_produced_per_join": 86,
"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 ('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": "135.21",
"eval_cost": "17.20",
"prefix_cost": "152.41",
"data_read_per_join": "8K"
},
"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": 86,
"filtered": "100.00",
"cost_info": {
"read_cost": "86.00",
"eval_cost": "17.20",
"prefix_cost": "255.61",
"data_read_per_join": "65K"
},
"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": 86,
"filtered": "100.00",
"cost_info": {
"read_cost": "86.00",
"eval_cost": "17.20",
"prefix_cost": "358.81",
"data_read_per_join": "51K"
},
"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 |
82646 |
32599 |
product |
84589 |
A |
0 |
|
84589 |
0 |
23071M-3-2.jpg |
4029 |
4000 |
N |
42919 |
32598 |
product |
44881 |
A |
1 |
|
44881 |
0 |
25130M-3-1.jpg |
4625 |
3840 |
N |
42981 |
32614 |
product |
44943 |
A |
1 |
|
44943 |
0 |
Screen_Shot_2019-08-19_at_1.34.51_PM.png |
400 |
697 |
N |
54008 |
32620 |
product |
55969 |
A |
1 |
|
55969 |
0 |
25130M-3-2.jpg |
4233 |
4000 |
N |
42982 |
32614 |
product |
44944 |
A |
2 |
|
44944 |
0 |
23071M-3-2.jpg |
4029 |
4000 |
N |
44529 |
32598 |
product |
46491 |
A |
2 |
|
46491 |
0 |
23071M-3-4.jpg |
6000 |
4000 |
N |
42921 |
32598 |
product |
44883 |
A |
3 |
|
44883 |
0 |
25116M-1-2.jpg |
4827 |
4000 |
N |
44556 |
32606 |
product |
46518 |
A |
3 |
|
46518 |
0 |
25130M-3-2.jpg |
4233 |
4000 |
N |
44583 |
32614 |
product |
46545 |
A |
3 |
|
46545 |
0 |
25140L-2-2.jpg |
4007 |
4000 |
N |
44601 |
32619 |
product |
46563 |
A |
3 |
|
46563 |
0 |
23071M-3-4.jpg |
6000 |
4000 |
N |
44531 |
32598 |
product |
46493 |
A |
4 |
|
46493 |
0 |
25130M-3-2.jpg |
4233 |
4000 |
N |
46969 |
32614 |
product |
48931 |
A |
4 |
|
48931 |
0 |
25130M-3-3.jpg |
6000 |
4000 |
N |
42983 |
32614 |
product |
44945 |
A |
5 |
|
44945 |
0 |
25140L-2-3.jpg |
6000 |
4000 |
N |
43002 |
32619 |
product |
44964 |
A |
5 |
|
44964 |
0 |
23071M-3-2.jpg |
4029 |
4000 |
N |
82666 |
32598 |
product |
84609 |
A |
5 |
|
84609 |
0 |
25116M-1-3.jpg |
4663 |
4000 |
N |
44557 |
32606 |
product |
46519 |
A |
6 |
|
46519 |
0 |
25130M-3-3.jpg |
6000 |
4000 |
N |
44584 |
32614 |
product |
46546 |
A |
6 |
|
46546 |
0 |
Screen_Shot_2019-08-19_at_12.10.38_PM_kkk2-ec.png |
645 |
673 |
N |
54009 |
32620 |
product |
55970 |
A |
6 |
|
55970 |
0 |
23071M-3-3.jpg |
4617 |
3834 |
N |
82667 |
32598 |
product |
84610 |
A |
6 |
|
84610 |
0 |
25130M-3-3.jpg |
6000 |
4000 |
N |
46971 |
32614 |
product |
48933 |
A |
7 |
|
48933 |
0 |
Screen_Shot_2019-08-19_at_1.37.02_PM.png |
623 |
670 |
N |
54010 |
32620 |
product |
55971 |
A |
7 |
|
55971 |
0 |
25130M-3-4.jpg |
6000 |
4000 |
N |
42984 |
32614 |
product |
44946 |
A |
8 |
|
44946 |
0 |
Screen_Shot_2019-08-19_at_1.36.32_PM.png |
482 |
724 |
N |
54011 |
32620 |
product |
55972 |
A |
8 |
|
55972 |
0 |
25130M-3-4.jpg |
6000 |
4000 |
N |
44586 |
32614 |
product |
46548 |
A |
9 |
|
46548 |
0 |
25110L-1-2.jpg |
6000 |
4000 |
N |
42939 |
32603 |
product |
44901 |
A |
10 |
|
44901 |
0 |
25110L-2-2.jpg |
6000 |
4000 |
N |
42943 |
32604 |
product |
44905 |
A |
10 |
|
44905 |
0 |
25110L-3-2.jpg |
6000 |
4000 |
N |
42947 |
32605 |
product |
44909 |
A |
10 |
|
44909 |
0 |
25140L-1-2.jpg |
3839 |
4000 |
N |
42994 |
32617 |
product |
44956 |
A |
10 |
|
44956 |
0 |
25140L-1P-2.jpg |
4058 |
4000 |
N |
42997 |
32618 |
product |
44959 |
A |
10 |
|
44959 |
0 |
25110L-1-2.jpg |
6000 |
4000 |
N |
44546 |
32603 |
product |
46508 |
A |
10 |
|
46508 |
0 |
25110L-2-2.jpg |
6000 |
4000 |
N |
44549 |
32604 |
product |
46511 |
A |
10 |
|
46511 |
0 |
25110L-3-2.jpg |
6000 |
4000 |
N |
44552 |
32605 |
product |
46514 |
A |
10 |
|
46514 |
0 |
25130M-4-2.jpg |
4826 |
4000 |
N |
44587 |
32615 |
product |
46549 |
A |
10 |
|
46549 |
0 |
25140L-1-2.jpg |
3839 |
4000 |
N |
44596 |
32617 |
product |
46558 |
A |
10 |
|
46558 |
0 |
25140L-1P-2.jpg |
4058 |
4000 |
N |
44598 |
32618 |
product |
46560 |
A |
10 |
|
46560 |
0 |
23044M-1-2.jpg |
6000 |
4000 |
N |
46823 |
32593 |
product |
48785 |
A |
10 |
|
48785 |
0 |
25110L-1-2.jpg |
6000 |
4000 |
N |
46895 |
32603 |
product |
48857 |
A |
10 |
|
48857 |
0 |
25110L-3-2.jpg |
6000 |
4000 |
N |
46908 |
32605 |
product |
48870 |
A |
10 |
|
48870 |
0 |
25130M-2-2.jpg |
6000 |
4000 |
N |
46962 |
32613 |
product |
48924 |
A |
10 |
|
48924 |
0 |
25130M-3-4.jpg |
6000 |
4000 |
N |
46973 |
32614 |
product |
48935 |
A |
10 |
|
48935 |
0 |
25140L-1-2.jpg |
3839 |
4000 |
N |
46989 |
32617 |
product |
48951 |
A |
10 |
|
48951 |
0 |
25140L-1P-2.jpg |
4058 |
4000 |
N |
46995 |
32618 |
product |
48957 |
A |
10 |
|
48957 |
0 |
23026M-1-3.jpg |
6000 |
4000 |
N |
42888 |
32590 |
product |
44850 |
A |
20 |
|
44850 |
0 |
23026M-2-3.jpg |
6000 |
4000 |
N |
42892 |
32591 |
product |
44854 |
A |
20 |
|
44854 |
0 |
23044M-1-3.jpg |
4090 |
3785 |
N |
42900 |
32593 |
product |
44862 |
A |
20 |
|
44862 |
0 |
25110L-1-3.jpg |
6000 |
4000 |
N |
42940 |
32603 |
product |
44902 |
A |
20 |
|
44902 |
0 |
25110L-2-3.jpg |
6000 |
4000 |
N |
42944 |
32604 |
product |
44906 |
A |
20 |
|
44906 |
0 |
25110L-3-3.jpg |
6000 |
4000 |
N |
42948 |
32605 |
product |
44910 |
A |
20 |
|
44910 |
0 |
25116M-3-3.jpg |
6000 |
4000 |
N |
42960 |
32608 |
product |
44922 |
A |
20 |
|
44922 |
0 |
25119M-1-3.jpg |
6000 |
4000 |
N |
42964 |
32609 |
product |
44926 |
A |
20 |
|
44926 |
0 |
25130M-4-3.jpg |
6000 |
4000 |
N |
42987 |
32615 |
product |
44949 |
A |
20 |
|
44949 |
0 |
25140L-1-3.jpg |
6000 |
4000 |
N |
42995 |
32617 |
product |
44957 |
A |
20 |
|
44957 |
0 |
25140L-1P-3.jpg |
3839 |
4000 |
N |
42998 |
32618 |
product |
44960 |
A |
20 |
|
44960 |
0 |
23026M-3-3.jpg |
6000 |
4000 |
N |
44506 |
32592 |
product |
46468 |
A |
20 |
|
46468 |
0 |
23044M-2-3.jpg |
6000 |
4000 |
N |
44514 |
32594 |
product |
46476 |
A |
20 |
|
46476 |
0 |
23044M-3-3.jpg |
6000 |
4000 |
N |
44517 |
32595 |
product |
46479 |
A |
20 |
|
46479 |
0 |
23071M-1-3.jpg |
6000 |
4000 |
N |
44521 |
32596 |
product |
46483 |
A |
20 |
|
46483 |
0 |
23071M-2-3.jpg |
5191 |
3826 |
N |
44526 |
32597 |
product |
46488 |
A |
20 |
|
46488 |
0 |
25110L-1-3.jpg |
6000 |
4000 |
N |
44547 |
32603 |
product |
46509 |
A |
20 |
|
46509 |
0 |
25110L-2-3.jpg |
6000 |
4000 |
N |
44550 |
32604 |
product |
46512 |
A |
20 |
|
46512 |
0 |
25110L-3-3.jpg |
6000 |
4000 |
N |
44553 |
32605 |
product |
46515 |
A |
20 |
|
46515 |
0 |
25116M-2-3.jpg |
6000 |
4000 |
N |
44561 |
32607 |
product |
46523 |
A |
20 |
|
46523 |
0 |
25119M-3-3.jpg |
6000 |
4000 |
N |
44573 |
32611 |
product |
46535 |
A |
20 |
|
46535 |
0 |
25130M-1-3.jpg |
6000 |
4000 |
N |
44577 |
32612 |
product |
46539 |
A |
20 |
|
46539 |
0 |
25130M-2-3.jpg |
6000 |
4000 |
N |
44581 |
32613 |
product |
46543 |
A |
20 |
|
46543 |
0 |
25140L-1-3.jpg |
6000 |
4000 |
N |
44597 |
32617 |
product |
46559 |
A |
20 |
|
46559 |
0 |
25140L-1P-3.jpg |
3839 |
4000 |
N |
44599 |
32618 |
product |
46561 |
A |
20 |
|
46561 |
0 |
23026M-3-3.jpg |
6000 |
4000 |
N |
46817 |
32592 |
product |
48779 |
A |
20 |
|
48779 |
0 |
23044M-1-3.jpg |
4090 |
3785 |
N |
46825 |
32593 |
product |
48787 |
A |
20 |
|
48787 |
0 |
23044M-2-3.jpg |
6000 |
4000 |
N |
46830 |
32594 |
product |
48792 |
A |
20 |
|
48792 |
0 |
23044M-3-3.jpg |
6000 |
4000 |
N |
46838 |
32595 |
product |
48800 |
A |
20 |
|
48800 |
0 |
25110L-1-3.jpg |
6000 |
4000 |
N |
46897 |
32603 |
product |
48859 |
A |
20 |
|
48859 |
0 |
25110L-2-3.jpg |
6000 |
4000 |
N |
46903 |
32604 |
product |
48865 |
A |
20 |
|
48865 |
0 |
25110L-3-3.jpg |
6000 |
4000 |
N |
46910 |
32605 |
product |
48872 |
A |
20 |
|
48872 |
0 |
25130M-5-3.jpg |
6000 |
4000 |
N |
46984 |
32616 |
product |
48946 |
A |
20 |
|
48946 |
0 |
25140L-1-3.jpg |
6000 |
4000 |
N |
46992 |
32617 |
product |
48954 |
A |
20 |
|
48954 |
0 |
25140L-1P-3.jpg |
3839 |
4000 |
N |
46997 |
32618 |
product |
48959 |
A |
20 |
|
48959 |
0 |
23044M-3-4.jpg |
6000 |
4000 |
N |
42909 |
32595 |
product |
44871 |
A |
30 |
|
44871 |
0 |
23071M-2-4.jpg |
6000 |
4000 |
N |
42917 |
32597 |
product |
44879 |
A |
30 |
|
44879 |
0 |
25110L-1-4.jpg |
6000 |
4000 |
N |
42941 |
32603 |
product |
44903 |
A |
30 |
|
44903 |
0 |
25110L-2-4.jpg |
6000 |
4000 |
N |
42945 |
32604 |
product |
44907 |
A |
30 |
|
44907 |
0 |
25110L-3-4.jpg |
3805 |
5635 |
N |
42949 |
32605 |
product |
44911 |
A |
30 |
|
44911 |
0 |
25116M-2-4.jpg |
6000 |
4000 |
N |
42957 |
32607 |
product |
44919 |
A |
30 |
|
44919 |
0 |
25116M-3-4.jpg |
6000 |
4000 |
N |
42961 |
32608 |
product |
44923 |
A |
30 |
|
44923 |
0 |
25119M-1-4.jpg |
6000 |
4000 |
N |
42965 |
32609 |
product |
44927 |
A |
30 |
|
44927 |
0 |
25119M-2-4.jpg |
6000 |
4000 |
N |
42968 |
32610 |
product |
44930 |
A |
30 |
|
44930 |
0 |
25119M-3-4.jpg |
6000 |
4000 |
N |
42972 |
32611 |
product |
44934 |
A |
30 |
|
44934 |
0 |
25130M-2-4.jpg |
6000 |
4000 |
N |
42980 |
32613 |
product |
44942 |
A |
30 |
|
44942 |
0 |
25130M-4-4.jpg |
6000 |
4000 |
N |
42988 |
32615 |
product |
44950 |
A |
30 |
|
44950 |
0 |
25140L-1P-4.jpg |
6000 |
4000 |
N |
42999 |
32618 |
product |
44961 |
A |
30 |
|
44961 |
0 |
23026M-1-4.jpg |
6000 |
4000 |
N |
44496 |
32590 |
product |
46458 |
A |
30 |
|
46458 |
0 |
23026M-2-4-1.jpg |
6000 |
4000 |
N |
44500 |
32591 |
product |
46462 |
A |
30 |
|
46462 |
0 |
23026M-3-4.jpg |
6000 |
4000 |
N |
44507 |
32592 |
product |
46469 |
A |
30 |
|
46469 |
0 |
23044M-1-4.jpg |
6000 |
4000 |
N |
44511 |
32593 |
product |
46473 |
A |
30 |
|
46473 |
0 |
23044M-2-4.jpg |
6000 |
4000 |
N |
44515 |
32594 |
product |
46477 |
A |
30 |
|
46477 |
0 |
23071M-1-4.jpg |
6000 |
4000 |
N |
44523 |
32596 |
product |
46485 |
A |
30 |
|
46485 |
0 |
25110L-1-4.jpg |
6000 |
4000 |
N |
44548 |
32603 |
product |
46510 |
A |
30 |
|
46510 |
0 |
25110L-2-4.jpg |
6000 |
4000 |
N |
44551 |
32604 |
product |
46513 |
A |
30 |
|
46513 |
0 |
25110L-3-4.jpg |
3805 |
5635 |
N |
44554 |
32605 |
product |
46516 |
A |
30 |
|
46516 |
0 |
25116M-2-4.jpg |
6000 |
4000 |
N |
44562 |
32607 |
product |
46524 |
A |
30 |
|
46524 |
0 |
25130M-1-4.jpg |
6000 |
4000 |
N |
44578 |
32612 |
product |
46540 |
A |
30 |
|
46540 |
0 |
25130M-2-4.jpg |
6000 |
4000 |
N |
44582 |
32613 |
product |
46544 |
A |
30 |
|
46544 |
0 |
25130M-4-4.jpg |
6000 |
4000 |
N |
44591 |
32615 |
product |
46553 |
A |
30 |
|
46553 |
0 |
25130M-5-4.jpg |
6000 |
4000 |
N |
44594 |
32616 |
product |
46556 |
A |
30 |
|
46556 |
0 |
25140L-1P-4.jpg |
6000 |
4000 |
N |
44600 |
32618 |
product |
46562 |
A |
30 |
|
46562 |
0 |
25140M-1-4-1.jpg |
6000 |
4000 |
N |
44608 |
32621 |
product |
46570 |
A |
30 |
|
46570 |
0 |
23044M-1-4.jpg |
6000 |
4000 |
N |
46828 |
32593 |
product |
48790 |
A |
30 |
|
48790 |
0 |
23044M-2-4.jpg |
6000 |
4000 |
N |
46833 |
32594 |
product |
48795 |
A |
30 |
|
48795 |
0 |
23044M-3-4.jpg |
6000 |
4000 |
N |
46840 |
32595 |
product |
48802 |
A |
30 |
|
48802 |
0 |
25110L-1-4.jpg |
6000 |
4000 |
N |
46899 |
32603 |
product |
48861 |
A |
30 |
|
48861 |
0 |
25110L-2-4.jpg |
6000 |
4000 |
N |
46905 |
32604 |
product |
48867 |
A |
30 |
|
48867 |
0 |
25110L-3-4.jpg |
3805 |
5635 |
N |
46912 |
32605 |
product |
48874 |
A |
30 |
|
48874 |
0 |
25130M-5-4.jpg |
6000 |
4000 |
N |
46986 |
32616 |
product |
48948 |
A |
30 |
|
48948 |
0 |
25140L-1P-4.jpg |
6000 |
4000 |
N |
46999 |
32618 |
product |
48961 |
A |
30 |
|
48961 |
0 |
23026M-1-2.jpg |
6000 |
4000 |
N |
82655 |
32590 |
product |
84598 |
A |
31 |
|
84598 |
0 |
23026M-2-3.jpg |
6000 |
4000 |
N |
82657 |
32591 |
product |
84600 |
A |
31 |
|
84600 |
0 |
23026M-3-2.jpg |
6000 |
4000 |
N |
82658 |
32592 |
product |
84601 |
A |
31 |
|
84601 |
0 |
23044M-1-2.jpg |
6000 |
4000 |
N |
82661 |
32593 |
product |
84604 |
A |
31 |
|
84604 |
0 |
23044M-2-3.jpg |
6000 |
4000 |
N |
82662 |
32594 |
product |
84605 |
A |
31 |
|
84605 |
0 |
23044M-3-3.jpg |
6000 |
4000 |
N |
82663 |
32595 |
product |
84606 |
A |
31 |
|
84606 |
0 |
23071M-1-3.jpg |
6000 |
4000 |
N |
82664 |
32596 |
product |
84607 |
A |
31 |
|
84607 |
0 |
23071M-2-3.jpg |
5191 |
3826 |
N |
82665 |
32597 |
product |
84608 |
A |
31 |
|
84608 |
0 |
23026M-1-3.jpg |
6000 |
4000 |
N |
82656 |
32590 |
product |
84599 |
A |
32 |
|
84599 |
0 |
23026M-3-3.jpg |
6000 |
4000 |
N |
82659 |
32592 |
product |
84602 |
A |
32 |
|
84602 |
0 |
23026M-3-4.jpg |
6000 |
4000 |
N |
82660 |
32592 |
product |
84603 |
A |
33 |
|
84603 |