Query time 0.00254
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.image_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"
]
}
},
{
"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 |
|
|
|
|
82646 |
32599 |
product |
84589 |
A |
0 |
|
|
0 |
|
|
|
|
42919 |
32598 |
product |
44881 |
A |
1 |
|
|
0 |
|
|
|
|
42981 |
32614 |
product |
44943 |
A |
1 |
|
|
0 |
|
|
|
|
54008 |
32620 |
product |
55969 |
A |
1 |
|
|
0 |
|
|
|
|
42982 |
32614 |
product |
44944 |
A |
2 |
|
|
0 |
|
|
|
|
44529 |
32598 |
product |
46491 |
A |
2 |
|
|
0 |
|
|
|
|
42921 |
32598 |
product |
44883 |
A |
3 |
|
|
0 |
|
|
|
|
44556 |
32606 |
product |
46518 |
A |
3 |
|
|
0 |
|
|
|
|
44583 |
32614 |
product |
46545 |
A |
3 |
|
|
0 |
|
|
|
|
44601 |
32619 |
product |
46563 |
A |
3 |
|
|
0 |
|
|
|
|
44531 |
32598 |
product |
46493 |
A |
4 |
|
|
0 |
|
|
|
|
46969 |
32614 |
product |
48931 |
A |
4 |
|
|
0 |
|
|
|
|
42983 |
32614 |
product |
44945 |
A |
5 |
|
|
0 |
|
|
|
|
43002 |
32619 |
product |
44964 |
A |
5 |
|
|
0 |
|
|
|
|
82666 |
32598 |
product |
84609 |
A |
5 |
|
|
0 |
|
|
|
|
44557 |
32606 |
product |
46519 |
A |
6 |
|
|
0 |
|
|
|
|
44584 |
32614 |
product |
46546 |
A |
6 |
|
|
0 |
|
|
|
|
54009 |
32620 |
product |
55970 |
A |
6 |
|
|
0 |
|
|
|
|
82667 |
32598 |
product |
84610 |
A |
6 |
|
|
0 |
|
|
|
|
46971 |
32614 |
product |
48933 |
A |
7 |
|
|
0 |
|
|
|
|
54010 |
32620 |
product |
55971 |
A |
7 |
|
|
0 |
|
|
|
|
42984 |
32614 |
product |
44946 |
A |
8 |
|
|
0 |
|
|
|
|
54011 |
32620 |
product |
55972 |
A |
8 |
|
|
0 |
|
|
|
|
44586 |
32614 |
product |
46548 |
A |
9 |
|
|
0 |
|
|
|
|
42939 |
32603 |
product |
44901 |
A |
10 |
|
|
0 |
|
|
|
|
42943 |
32604 |
product |
44905 |
A |
10 |
|
|
0 |
|
|
|
|
42947 |
32605 |
product |
44909 |
A |
10 |
|
|
0 |
|
|
|
|
42994 |
32617 |
product |
44956 |
A |
10 |
|
|
0 |
|
|
|
|
42997 |
32618 |
product |
44959 |
A |
10 |
|
|
0 |
|
|
|
|
44546 |
32603 |
product |
46508 |
A |
10 |
|
|
0 |
|
|
|
|
44549 |
32604 |
product |
46511 |
A |
10 |
|
|
0 |
|
|
|
|
44552 |
32605 |
product |
46514 |
A |
10 |
|
|
0 |
|
|
|
|
44587 |
32615 |
product |
46549 |
A |
10 |
|
|
0 |
|
|
|
|
44596 |
32617 |
product |
46558 |
A |
10 |
|
|
0 |
|
|
|
|
44598 |
32618 |
product |
46560 |
A |
10 |
|
|
0 |
|
|
|
|
46823 |
32593 |
product |
48785 |
A |
10 |
|
|
0 |
|
|
|
|
46895 |
32603 |
product |
48857 |
A |
10 |
|
|
0 |
|
|
|
|
46908 |
32605 |
product |
48870 |
A |
10 |
|
|
0 |
|
|
|
|
46962 |
32613 |
product |
48924 |
A |
10 |
|
|
0 |
|
|
|
|
46973 |
32614 |
product |
48935 |
A |
10 |
|
|
0 |
|
|
|
|
46989 |
32617 |
product |
48951 |
A |
10 |
|
|
0 |
|
|
|
|
46995 |
32618 |
product |
48957 |
A |
10 |
|
|
0 |
|
|
|
|
42888 |
32590 |
product |
44850 |
A |
20 |
|
|
0 |
|
|
|
|
42892 |
32591 |
product |
44854 |
A |
20 |
|
|
0 |
|
|
|
|
42900 |
32593 |
product |
44862 |
A |
20 |
|
|
0 |
|
|
|
|
42940 |
32603 |
product |
44902 |
A |
20 |
|
|
0 |
|
|
|
|
42944 |
32604 |
product |
44906 |
A |
20 |
|
|
0 |
|
|
|
|
42948 |
32605 |
product |
44910 |
A |
20 |
|
|
0 |
|
|
|
|
42960 |
32608 |
product |
44922 |
A |
20 |
|
|
0 |
|
|
|
|
42964 |
32609 |
product |
44926 |
A |
20 |
|
|
0 |
|
|
|
|
42987 |
32615 |
product |
44949 |
A |
20 |
|
|
0 |
|
|
|
|
42995 |
32617 |
product |
44957 |
A |
20 |
|
|
0 |
|
|
|
|
42998 |
32618 |
product |
44960 |
A |
20 |
|
|
0 |
|
|
|
|
44506 |
32592 |
product |
46468 |
A |
20 |
|
|
0 |
|
|
|
|
44514 |
32594 |
product |
46476 |
A |
20 |
|
|
0 |
|
|
|
|
44517 |
32595 |
product |
46479 |
A |
20 |
|
|
0 |
|
|
|
|
44521 |
32596 |
product |
46483 |
A |
20 |
|
|
0 |
|
|
|
|
44526 |
32597 |
product |
46488 |
A |
20 |
|
|
0 |
|
|
|
|
44547 |
32603 |
product |
46509 |
A |
20 |
|
|
0 |
|
|
|
|
44550 |
32604 |
product |
46512 |
A |
20 |
|
|
0 |
|
|
|
|
44553 |
32605 |
product |
46515 |
A |
20 |
|
|
0 |
|
|
|
|
44561 |
32607 |
product |
46523 |
A |
20 |
|
|
0 |
|
|
|
|
44573 |
32611 |
product |
46535 |
A |
20 |
|
|
0 |
|
|
|
|
44577 |
32612 |
product |
46539 |
A |
20 |
|
|
0 |
|
|
|
|
44581 |
32613 |
product |
46543 |
A |
20 |
|
|
0 |
|
|
|
|
44597 |
32617 |
product |
46559 |
A |
20 |
|
|
0 |
|
|
|
|
44599 |
32618 |
product |
46561 |
A |
20 |
|
|
0 |
|
|
|
|
46817 |
32592 |
product |
48779 |
A |
20 |
|
|
0 |
|
|
|
|
46825 |
32593 |
product |
48787 |
A |
20 |
|
|
0 |
|
|
|
|
46830 |
32594 |
product |
48792 |
A |
20 |
|
|
0 |
|
|
|
|
46838 |
32595 |
product |
48800 |
A |
20 |
|
|
0 |
|
|
|
|
46897 |
32603 |
product |
48859 |
A |
20 |
|
|
0 |
|
|
|
|
46903 |
32604 |
product |
48865 |
A |
20 |
|
|
0 |
|
|
|
|
46910 |
32605 |
product |
48872 |
A |
20 |
|
|
0 |
|
|
|
|
46984 |
32616 |
product |
48946 |
A |
20 |
|
|
0 |
|
|
|
|
46992 |
32617 |
product |
48954 |
A |
20 |
|
|
0 |
|
|
|
|
46997 |
32618 |
product |
48959 |
A |
20 |
|
|
0 |
|
|
|
|
42909 |
32595 |
product |
44871 |
A |
30 |
|
|
0 |
|
|
|
|
42917 |
32597 |
product |
44879 |
A |
30 |
|
|
0 |
|
|
|
|
42941 |
32603 |
product |
44903 |
A |
30 |
|
|
0 |
|
|
|
|
42945 |
32604 |
product |
44907 |
A |
30 |
|
|
0 |
|
|
|
|
42949 |
32605 |
product |
44911 |
A |
30 |
|
|
0 |
|
|
|
|
42957 |
32607 |
product |
44919 |
A |
30 |
|
|
0 |
|
|
|
|
42961 |
32608 |
product |
44923 |
A |
30 |
|
|
0 |
|
|
|
|
42965 |
32609 |
product |
44927 |
A |
30 |
|
|
0 |
|
|
|
|
42968 |
32610 |
product |
44930 |
A |
30 |
|
|
0 |
|
|
|
|
42972 |
32611 |
product |
44934 |
A |
30 |
|
|
0 |
|
|
|
|
42980 |
32613 |
product |
44942 |
A |
30 |
|
|
0 |
|
|
|
|
42988 |
32615 |
product |
44950 |
A |
30 |
|
|
0 |
|
|
|
|
42999 |
32618 |
product |
44961 |
A |
30 |
|
|
0 |
|
|
|
|
44496 |
32590 |
product |
46458 |
A |
30 |
|
|
0 |
|
|
|
|
44500 |
32591 |
product |
46462 |
A |
30 |
|
|
0 |
|
|
|
|
44507 |
32592 |
product |
46469 |
A |
30 |
|
|
0 |
|
|
|
|
44511 |
32593 |
product |
46473 |
A |
30 |
|
|
0 |
|
|
|
|
44515 |
32594 |
product |
46477 |
A |
30 |
|
|
0 |
|
|
|
|
44523 |
32596 |
product |
46485 |
A |
30 |
|
|
0 |
|
|
|
|
44548 |
32603 |
product |
46510 |
A |
30 |
|
|
0 |
|
|
|
|
44551 |
32604 |
product |
46513 |
A |
30 |
|
|
0 |
|
|
|
|
44554 |
32605 |
product |
46516 |
A |
30 |
|
|
0 |
|
|
|
|
44562 |
32607 |
product |
46524 |
A |
30 |
|
|
0 |
|
|
|
|
44578 |
32612 |
product |
46540 |
A |
30 |
|
|
0 |
|
|
|
|
44582 |
32613 |
product |
46544 |
A |
30 |
|
|
0 |
|
|
|
|
44591 |
32615 |
product |
46553 |
A |
30 |
|
|
0 |
|
|
|
|
44594 |
32616 |
product |
46556 |
A |
30 |
|
|
0 |
|
|
|
|
44600 |
32618 |
product |
46562 |
A |
30 |
|
|
0 |
|
|
|
|
44608 |
32621 |
product |
46570 |
A |
30 |
|
|
0 |
|
|
|
|
46828 |
32593 |
product |
48790 |
A |
30 |
|
|
0 |
|
|
|
|
46833 |
32594 |
product |
48795 |
A |
30 |
|
|
0 |
|
|
|
|
46840 |
32595 |
product |
48802 |
A |
30 |
|
|
0 |
|
|
|
|
46899 |
32603 |
product |
48861 |
A |
30 |
|
|
0 |
|
|
|
|
46905 |
32604 |
product |
48867 |
A |
30 |
|
|
0 |
|
|
|
|
46912 |
32605 |
product |
48874 |
A |
30 |
|
|
0 |
|
|
|
|
46986 |
32616 |
product |
48948 |
A |
30 |
|
|
0 |
|
|
|
|
46999 |
32618 |
product |
48961 |
A |
30 |
|
|
0 |
|
|
|
|
82655 |
32590 |
product |
84598 |
A |
31 |
|
|
0 |
|
|
|
|
82657 |
32591 |
product |
84600 |
A |
31 |
|
|
0 |
|
|
|
|
82658 |
32592 |
product |
84601 |
A |
31 |
|
|
0 |
|
|
|
|
82661 |
32593 |
product |
84604 |
A |
31 |
|
|
0 |
|
|
|
|
82662 |
32594 |
product |
84605 |
A |
31 |
|
|
0 |
|
|
|
|
82663 |
32595 |
product |
84606 |
A |
31 |
|
|
0 |
|
|
|
|
82664 |
32596 |
product |
84607 |
A |
31 |
|
|
0 |
|
|
|
|
82665 |
32597 |
product |
84608 |
A |
31 |
|
|
0 |
|
|
|
|
82656 |
32590 |
product |
84599 |
A |
32 |
|
|
0 |
|
|
|
|
82659 |
32592 |
product |
84602 |
A |
32 |
|
|
0 |
|
|
|
|
82660 |
32592 |
product |
84603 |
A |
33 |
|
|