Query time 0.01547
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "968.01"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "175.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": 175,
"rows_produced_per_join": 175,
"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 ('47678','47679','47680','47681','47682','47683','47684','47685','47686','47688','47690','47691','47692','47693','47694','47695','47696','47697','47698','47699','47700','47701','47702','47703','47705','47706','47707','47708','47709','47710','47711','47712','47714','47719','47720','47721','47722','47725','47730','47731','47732','47733','47734','47735','47736','47737','47738','47739','47740','47741','47742','47743','47744','47745','47746','47747','47748','47749','47750','47751','47752','47753','47754','47755','47756','47757','47758','47760','47761','47762','47763','47764','47765','47766','47767','47768','47769','47770','47771','47772','47773','47774','45784','45785','45786','45787','45788','45789','45790','45791','45792','45793','45794','45795','45796','45797','45798','45799','45800','45801','45802','45803','45804','45805','45806','45807','45808','45809','45810','45811','45812','45813','45814','45815','45816','45817','45818','45819','45820','45821','45822','45823','45824','45825','45826','45827','45828','45829')))",
"cost_info": {
"read_cost": "338.01",
"eval_cost": "35.00",
"prefix_cost": "373.01",
"data_read_per_join": "16K"
},
"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": 175,
"filtered": "100.00",
"cost_info": {
"read_cost": "175.00",
"eval_cost": "35.00",
"prefix_cost": "583.01",
"data_read_per_join": "133K"
},
"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": 175,
"filtered": "100.00",
"cost_info": {
"read_cost": "175.00",
"eval_cost": "35.00",
"prefix_cost": "793.01",
"data_read_per_join": "103K"
},
"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 |
|
|
|
|
73176 |
45784 |
product |
75127 |
M |
0 |
|
|
0 |
|
|
|
|
73178 |
45785 |
product |
75129 |
M |
0 |
|
|
0 |
|
|
|
|
75195 |
45788 |
product |
77138 |
M |
0 |
|
|
0 |
|
|
|
|
75203 |
45790 |
product |
77146 |
M |
0 |
|
|
0 |
|
|
|
|
75212 |
45791 |
product |
77155 |
M |
0 |
|
|
0 |
|
|
|
|
75216 |
45792 |
product |
77159 |
M |
0 |
|
|
0 |
|
|
|
|
75219 |
45793 |
product |
77162 |
M |
0 |
|
|
0 |
|
|
|
|
75224 |
45794 |
product |
77167 |
M |
0 |
|
|
0 |
|
|
|
|
75229 |
45795 |
product |
77172 |
M |
0 |
|
|
0 |
|
|
|
|
75232 |
45796 |
product |
77175 |
M |
0 |
|
|
0 |
|
|
|
|
75235 |
45797 |
product |
77178 |
M |
0 |
|
|
0 |
|
|
|
|
75237 |
45798 |
product |
77180 |
M |
0 |
|
|
0 |
|
|
|
|
75239 |
45799 |
product |
77182 |
M |
0 |
|
|
0 |
|
|
|
|
75244 |
45802 |
product |
77187 |
M |
0 |
|
|
0 |
|
|
|
|
75248 |
45803 |
product |
77191 |
M |
0 |
|
|
0 |
|
|
|
|
75255 |
45804 |
product |
77198 |
M |
0 |
|
|
0 |
|
|
|
|
75260 |
45805 |
product |
77203 |
M |
0 |
|
|
0 |
|
|
|
|
75262 |
45806 |
product |
77205 |
M |
0 |
|
|
0 |
|
|
|
|
75277 |
45808 |
product |
77220 |
M |
0 |
|
|
0 |
|
|
|
|
75279 |
45809 |
product |
77222 |
M |
0 |
|
|
0 |
|
|
|
|
75281 |
45810 |
product |
77224 |
M |
0 |
|
|
0 |
|
|
|
|
75284 |
45810 |
product |
77227 |
M |
0 |
|
|
0 |
|
|
|
|
75298 |
45815 |
product |
77241 |
M |
0 |
|
|
0 |
|
|
|
|
75302 |
45816 |
product |
77245 |
M |
0 |
|
|
0 |
|
|
|
|
75304 |
45817 |
product |
77247 |
M |
0 |
|
|
0 |
|
|
|
|
75305 |
45818 |
product |
77248 |
M |
0 |
|
|
0 |
|
|
|
|
75311 |
45819 |
product |
77254 |
M |
0 |
|
|
0 |
|
|
|
|
75318 |
45821 |
product |
77261 |
M |
0 |
|
|
0 |
|
|
|
|
75322 |
45822 |
product |
77265 |
M |
0 |
|
|
0 |
|
|
|
|
75328 |
45823 |
product |
77271 |
M |
0 |
|
|
0 |
|
|
|
|
75330 |
45824 |
product |
77273 |
M |
0 |
|
|
0 |
|
|
|
|
75331 |
45825 |
product |
77274 |
M |
0 |
|
|
0 |
|
|
|
|
75335 |
45827 |
product |
77278 |
M |
0 |
|
|
0 |
|
|
|
|
75339 |
45828 |
product |
77282 |
M |
0 |
|
|
0 |
|
|
|
|
75344 |
45829 |
product |
77287 |
M |
0 |
|
|
0 |
|
|
|
|
75483 |
45826 |
product |
77426 |
M |
0 |
|
|
0 |
|
|
|
|
75501 |
45812 |
product |
77444 |
M |
0 |
|
|
0 |
|
|
|
|
75502 |
45811 |
product |
77445 |
M |
0 |
|
|
0 |
|
|
|
|
77249 |
45787 |
product |
79192 |
M |
0 |
|
|
0 |
|
|
|
|
78182 |
45786 |
product |
80125 |
M |
0 |
|
|
0 |
|
|
|
|
78643 |
47679 |
product |
80586 |
M |
0 |
|
|
0 |
|
|
|
|
78644 |
47680 |
product |
80587 |
M |
0 |
|
|
0 |
|
|
|
|
78645 |
47680 |
product |
80588 |
M |
0 |
|
|
0 |
|
|
|
|
78646 |
47681 |
product |
80589 |
M |
0 |
|
|
0 |
|
|
|
|
78647 |
47682 |
product |
80590 |
M |
0 |
|
|
0 |
|
|
|
|
78648 |
47683 |
product |
80591 |
M |
0 |
|
|
0 |
|
|
|
|
78649 |
47684 |
product |
80592 |
M |
0 |
|
|
0 |
|
|
|
|
78654 |
47685 |
product |
80597 |
M |
0 |
|
|
0 |
|
|
|
|
78658 |
47686 |
product |
80601 |
M |
0 |
|
|
0 |
|
|
|
|
78662 |
47688 |
product |
80605 |
M |
0 |
|
|
0 |
|
|
|
|
78663 |
47688 |
product |
80606 |
M |
0 |
|
|
0 |
|
|
|
|
78668 |
47691 |
product |
80611 |
M |
0 |
|
|
0 |
|
|
|
|
78669 |
47692 |
product |
80612 |
M |
0 |
|
|
0 |
|
|
|
|
78670 |
47693 |
product |
80613 |
M |
0 |
|
|
0 |
|
|
|
|
78671 |
47694 |
product |
80614 |
M |
0 |
|
|
0 |
|
|
|
|
78672 |
47695 |
product |
80615 |
M |
0 |
|
|
0 |
|
|
|
|
78673 |
47696 |
product |
80616 |
M |
0 |
|
|
0 |
|
|
|
|
78674 |
47697 |
product |
80617 |
M |
0 |
|
|
0 |
|
|
|
|
78675 |
47698 |
product |
80618 |
M |
0 |
|
|
0 |
|
|
|
|
78676 |
47699 |
product |
80619 |
M |
0 |
|
|
0 |
|
|
|
|
78677 |
47699 |
product |
80620 |
M |
0 |
|
|
0 |
|
|
|
|
78678 |
47700 |
product |
80621 |
M |
0 |
|
|
0 |
|
|
|
|
78679 |
47701 |
product |
80622 |
M |
0 |
|
|
0 |
|
|
|
|
78680 |
47702 |
product |
80623 |
M |
0 |
|
|
0 |
|
|
|
|
78681 |
47703 |
product |
80624 |
M |
0 |
|
|
0 |
|
|
|
|
78682 |
47705 |
product |
80625 |
M |
0 |
|
|
0 |
|
|
|
|
78683 |
47705 |
product |
80626 |
M |
0 |
|
|
0 |
|
|
|
|
78684 |
47706 |
product |
80627 |
M |
0 |
|
|
0 |
|
|
|
|
78685 |
47706 |
product |
80628 |
M |
0 |
|
|
0 |
|
|
|
|
78686 |
47707 |
product |
80629 |
M |
0 |
|
|
0 |
|
|
|
|
78687 |
47708 |
product |
80630 |
M |
0 |
|
|
0 |
|
|
|
|
78688 |
47708 |
product |
80631 |
M |
0 |
|
|
0 |
|
|
|
|
78689 |
47709 |
product |
80632 |
M |
0 |
|
|
0 |
|
|
|
|
78690 |
47709 |
product |
80633 |
M |
0 |
|
|
0 |
|
|
|
|
78691 |
47710 |
product |
80634 |
M |
0 |
|
|
0 |
|
|
|
|
78692 |
47711 |
product |
80635 |
M |
0 |
|
|
0 |
|
|
|
|
78717 |
47678 |
product |
80660 |
M |
0 |
|
|
0 |
|
|
|
|
78897 |
47741 |
product |
80840 |
M |
0 |
|
|
0 |
|
|
|
|
78898 |
47742 |
product |
80841 |
M |
0 |
|
|
0 |
|
|
|
|
78899 |
47719 |
product |
80842 |
M |
0 |
|
|
0 |
|
|
|
|
78900 |
47720 |
product |
80843 |
M |
0 |
|
|
0 |
|
|
|
|
78901 |
47721 |
product |
80844 |
M |
0 |
|
|
0 |
|
|
|
|
78902 |
47722 |
product |
80845 |
M |
0 |
|
|
0 |
|
|
|
|
78903 |
47725 |
product |
80846 |
M |
0 |
|
|
0 |
|
|
|
|
78904 |
47740 |
product |
80847 |
M |
0 |
|
|
0 |
|
|
|
|
78905 |
47739 |
product |
80848 |
M |
0 |
|
|
0 |
|
|
|
|
78906 |
47738 |
product |
80849 |
M |
0 |
|
|
0 |
|
|
|
|
78907 |
47737 |
product |
80850 |
M |
0 |
|
|
0 |
|
|
|
|
78908 |
47736 |
product |
80851 |
M |
0 |
|
|
0 |
|
|
|
|
78909 |
47736 |
product |
80852 |
M |
0 |
|
|
0 |
|
|
|
|
78917 |
47714 |
product |
80860 |
M |
0 |
|
|
0 |
|
|
|
|
78926 |
47732 |
product |
80869 |
M |
0 |
|
|
0 |
|
|
|
|
78927 |
47732 |
product |
80870 |
M |
0 |
|
|
0 |
|
|
|
|
78928 |
47732 |
product |
80871 |
M |
0 |
|
|
0 |
|
|
|
|
78929 |
47733 |
product |
80872 |
M |
0 |
|
|
0 |
|
|
|
|
78930 |
47734 |
product |
80873 |
M |
0 |
|
|
0 |
|
|
|
|
78931 |
47735 |
product |
80874 |
M |
0 |
|
|
0 |
|
|
|
|
78936 |
47730 |
product |
80879 |
M |
0 |
|
|
0 |
|
|
|
|
78937 |
47712 |
product |
80880 |
M |
0 |
|
|
0 |
|
|
|
|
78938 |
47731 |
product |
80881 |
M |
0 |
|
|
0 |
|
|
|
|
79092 |
47745 |
product |
81035 |
M |
0 |
|
|
0 |
|
|
|
|
79093 |
47746 |
product |
81036 |
M |
0 |
|
|
0 |
|
|
|
|
79095 |
47747 |
product |
81038 |
M |
0 |
|
|
0 |
|
|
|
|
79096 |
47748 |
product |
81039 |
M |
0 |
|
|
0 |
|
|
|
|
79097 |
47750 |
product |
81040 |
M |
0 |
|
|
0 |
|
|
|
|
79099 |
47751 |
product |
81042 |
M |
0 |
|
|
0 |
|
|
|
|
79101 |
47752 |
product |
81044 |
M |
0 |
|
|
0 |
|
|
|
|
79103 |
47753 |
product |
81046 |
M |
0 |
|
|
0 |
|
|
|
|
79105 |
47754 |
product |
81048 |
M |
0 |
|
|
0 |
|
|
|
|
79106 |
47755 |
product |
81049 |
M |
0 |
|
|
0 |
|
|
|
|
79160 |
47744 |
product |
81103 |
M |
0 |
|
|
0 |
|
|
|
|
79161 |
47749 |
product |
81104 |
M |
0 |
|
|
0 |
|
|
|
|
79162 |
47757 |
product |
81105 |
M |
0 |
|
|
0 |
|
|
|
|
79163 |
47758 |
product |
81106 |
M |
0 |
|
|
0 |
|
|
|
|
79164 |
47758 |
product |
81107 |
M |
0 |
|
|
0 |
|
|
|
|
79167 |
47760 |
product |
81110 |
M |
0 |
|
|
0 |
|
|
|
|
79168 |
47761 |
product |
81111 |
M |
0 |
|
|
0 |
|
|
|
|
79170 |
47762 |
product |
81113 |
M |
0 |
|
|
0 |
|
|
|
|
79171 |
47763 |
product |
81114 |
M |
0 |
|
|
0 |
|
|
|
|
79173 |
47764 |
product |
81116 |
M |
0 |
|
|
0 |
|
|
|
|
79175 |
47765 |
product |
81118 |
M |
0 |
|
|
0 |
|
|
|
|
79177 |
47767 |
product |
81120 |
M |
0 |
|
|
0 |
|
|
|
|
79179 |
47768 |
product |
81122 |
M |
0 |
|
|
0 |
|
|
|
|
79181 |
47769 |
product |
81124 |
M |
0 |
|
|
0 |
|
|
|
|
79186 |
47766 |
product |
81129 |
M |
0 |
|
|
0 |
|
|
|
|
79206 |
47770 |
product |
81149 |
M |
0 |
|
|
0 |
|
|
|
|
79208 |
47771 |
product |
81151 |
M |
0 |
|
|
0 |
|
|
|
|
79209 |
47772 |
product |
81152 |
M |
0 |
|
|
0 |
|
|
|
|
79211 |
47773 |
product |
81154 |
M |
0 |
|
|
0 |
|
|
|
|
81478 |
45814 |
product |
83421 |
M |
0 |
|
|
0 |
|
|
|
|
81517 |
45813 |
product |
83460 |
M |
0 |
|
|
0 |
|
|
|
|
81518 |
45813 |
product |
83461 |
M |
0 |
|
|
0 |
|
|
|
|
81527 |
47690 |
product |
83470 |
M |
0 |
|
|
0 |
|
|
|
|
81804 |
45820 |
product |
83747 |
M |
0 |
|
|
0 |
|
|
|
|
82011 |
45789 |
product |
83954 |
M |
0 |
|
|
0 |
|
|
|
|
82312 |
45807 |
product |
84255 |
M |
0 |
|
|
0 |
|
|
|
|
82313 |
45807 |
product |
84256 |
M |
0 |
|
|
0 |
|
|
|
|
82549 |
45800 |
product |
84492 |
M |
0 |
|
|
0 |
|
|
|
|
83169 |
47756 |
product |
85112 |
M |
0 |
|
|
0 |
|
|
|
|
75241 |
45801 |
product |
77184 |
M |
1 |
|
|
0 |
|
|
|
|
79112 |
47743 |
product |
81055 |
M |
1 |
|
|