Query time 0.00689
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "358.41"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "68.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": 68,
"rows_produced_per_join": 68,
"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 ('32785','32786','32787','32788','32789','32790','32791','32792','32793','32794','32795','32796','32797','32798','32799','32800','32801','32802','32803','32804','32805','32806','32807','32808','32809','32810','32811','32812','32813','32814','32815','32816')))",
"cost_info": {
"read_cost": "113.61",
"eval_cost": "13.60",
"prefix_cost": "127.21",
"data_read_per_join": "6K"
},
"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": 68,
"filtered": "100.00",
"cost_info": {
"read_cost": "68.00",
"eval_cost": "13.60",
"prefix_cost": "208.81",
"data_read_per_join": "52K"
},
"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": 68,
"filtered": "100.00",
"cost_info": {
"read_cost": "68.00",
"eval_cost": "13.60",
"prefix_cost": "290.41",
"data_read_per_join": "40K"
},
"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 |
12483L-4-2.jpg |
3116 |
4000 |
N |
43630 |
32785 |
product |
45592 |
A |
10 |
|
45592 |
0 |
12514M-3-2.jpg |
6000 |
4000 |
N |
43698 |
32802 |
product |
45660 |
A |
10 |
|
45660 |
0 |
12514M-4-2.jpg |
5092 |
4000 |
N |
43702 |
32803 |
product |
45664 |
A |
10 |
|
45664 |
0 |
12514M-5-2.jpg |
6000 |
4000 |
N |
43706 |
32804 |
product |
45668 |
A |
10 |
|
45668 |
0 |
12516M-1-2.jpg |
6000 |
4000 |
N |
43710 |
32805 |
product |
45672 |
A |
10 |
|
45672 |
0 |
12516M-2-2.jpg |
6000 |
4000 |
N |
43714 |
32806 |
product |
45676 |
A |
10 |
|
45676 |
0 |
12516M-3-2.jpg |
6000 |
4000 |
N |
43718 |
32807 |
product |
45680 |
A |
10 |
|
45680 |
0 |
12516M-4-2.jpg |
6000 |
4000 |
N |
43722 |
32808 |
product |
45684 |
A |
10 |
|
45684 |
0 |
12516M-5-2.jpg |
6000 |
4000 |
N |
43726 |
32809 |
product |
45688 |
A |
10 |
|
45688 |
0 |
12516M-6-2.jpg |
6000 |
4000 |
N |
43730 |
32810 |
product |
45692 |
A |
10 |
|
45692 |
0 |
12519M-1-2.jpg |
4091 |
3935 |
N |
43734 |
32811 |
product |
45696 |
A |
10 |
|
45696 |
0 |
12519M-2-2.jpg |
4072 |
3880 |
N |
43738 |
32812 |
product |
45700 |
A |
10 |
|
45700 |
0 |
12519M-3-2.jpg |
4185 |
3751 |
N |
43742 |
32813 |
product |
45704 |
A |
10 |
|
45704 |
0 |
12519M-4-2.jpg |
4185 |
3751 |
N |
43746 |
32814 |
product |
45708 |
A |
10 |
|
45708 |
0 |
12535L-1-2-1.jpg |
4012 |
4000 |
N |
43750 |
32815 |
product |
45712 |
A |
10 |
|
45712 |
0 |
12535L-2-2-1.jpg |
4294 |
3601 |
N |
43754 |
32816 |
product |
45716 |
A |
10 |
|
45716 |
0 |
12483L-4-2.jpg |
3116 |
4000 |
N |
45171 |
32785 |
product |
47133 |
A |
10 |
|
47133 |
0 |
12502M-2-2.jpg |
4056 |
4000 |
N |
45204 |
32795 |
product |
47166 |
A |
10 |
|
47166 |
0 |
12514M-3-2.jpg |
6000 |
4000 |
N |
45229 |
32802 |
product |
47191 |
A |
10 |
|
47191 |
0 |
12514M-4-2.jpg |
5092 |
4000 |
N |
45233 |
32803 |
product |
47195 |
A |
10 |
|
47195 |
0 |
12514M-5-2.jpg |
6000 |
4000 |
N |
45237 |
32804 |
product |
47199 |
A |
10 |
|
47199 |
0 |
12516M-1-2.jpg |
6000 |
4000 |
N |
45241 |
32805 |
product |
47203 |
A |
10 |
|
47203 |
0 |
12516M-2-2.jpg |
6000 |
4000 |
N |
45245 |
32806 |
product |
47207 |
A |
10 |
|
47207 |
0 |
12516M-3-2.jpg |
6000 |
4000 |
N |
45248 |
32807 |
product |
47210 |
A |
10 |
|
47210 |
0 |
12516M-4-2.jpg |
6000 |
4000 |
N |
45252 |
32808 |
product |
47214 |
A |
10 |
|
47214 |
0 |
12516M-5-2.jpg |
6000 |
4000 |
N |
45256 |
32809 |
product |
47218 |
A |
10 |
|
47218 |
0 |
12516M-6-2.jpg |
6000 |
4000 |
N |
45260 |
32810 |
product |
47222 |
A |
10 |
|
47222 |
0 |
12519M-1-2.jpg |
4091 |
3935 |
N |
45264 |
32811 |
product |
47226 |
A |
10 |
|
47226 |
0 |
12519M-2-2.jpg |
4072 |
3880 |
N |
45268 |
32812 |
product |
47230 |
A |
10 |
|
47230 |
0 |
12519M-3-2.jpg |
4185 |
3751 |
N |
45272 |
32813 |
product |
47234 |
A |
10 |
|
47234 |
0 |
12519M-4-2.jpg |
4185 |
3751 |
N |
45275 |
32814 |
product |
47237 |
A |
10 |
|
47237 |
0 |
12535L-1-2-1.jpg |
4012 |
4000 |
N |
45279 |
32815 |
product |
47241 |
A |
10 |
|
47241 |
0 |
12535L-2-2-1.jpg |
4294 |
3601 |
N |
45284 |
32816 |
product |
47246 |
A |
10 |
|
47246 |
0 |
12483L-4-3.jpg |
6000 |
4000 |
N |
43631 |
32785 |
product |
45593 |
A |
20 |
|
45593 |
0 |
12497M-1-3.jpg |
6000 |
4000 |
N |
43635 |
32786 |
product |
45597 |
A |
20 |
|
45597 |
0 |
12500M-5-3.jpg |
6000 |
4000 |
N |
43663 |
32793 |
product |
45625 |
A |
20 |
|
45625 |
0 |
12511M-3-3.jpg |
6000 |
4000 |
N |
43687 |
32799 |
product |
45649 |
A |
20 |
|
45649 |
0 |
12514M-3-3.jpg |
6000 |
4000 |
N |
43699 |
32802 |
product |
45661 |
A |
20 |
|
45661 |
0 |
12514M-4-3.jpg |
6000 |
4000 |
N |
43703 |
32803 |
product |
45665 |
A |
20 |
|
45665 |
0 |
12514M-5-3.jpg |
6000 |
4000 |
N |
43707 |
32804 |
product |
45669 |
A |
20 |
|
45669 |
0 |
12516M-1-3.jpg |
6000 |
4000 |
N |
43711 |
32805 |
product |
45673 |
A |
20 |
|
45673 |
0 |
12516M-2-3.jpg |
6000 |
4000 |
N |
43715 |
32806 |
product |
45677 |
A |
20 |
|
45677 |
0 |
12516M-3-3.jpg |
6000 |
4000 |
N |
43719 |
32807 |
product |
45681 |
A |
20 |
|
45681 |
0 |
12516M-4-3.jpg |
6000 |
4000 |
N |
43723 |
32808 |
product |
45685 |
A |
20 |
|
45685 |
0 |
12516M-5-3.jpg |
6000 |
4000 |
N |
43727 |
32809 |
product |
45689 |
A |
20 |
|
45689 |
0 |
12516M-6-3.jpg |
6000 |
4000 |
N |
43731 |
32810 |
product |
45693 |
A |
20 |
|
45693 |
0 |
12519M-1-3.jpg |
6000 |
4000 |
N |
43735 |
32811 |
product |
45697 |
A |
20 |
|
45697 |
0 |
12519M-2-3.jpg |
6000 |
4000 |
N |
43739 |
32812 |
product |
45701 |
A |
20 |
|
45701 |
0 |
12519M-3-3.jpg |
4248 |
3805 |
N |
43743 |
32813 |
product |
45705 |
A |
20 |
|
45705 |
0 |
12519M-4-3.jpg |
5031 |
3799 |
N |
43747 |
32814 |
product |
45709 |
A |
20 |
|
45709 |
0 |
12535L-1-3-1.jpg |
5501 |
4000 |
N |
43751 |
32815 |
product |
45713 |
A |
20 |
|
45713 |
0 |
12535L-2-3-1.jpg |
6000 |
4000 |
N |
43755 |
32816 |
product |
45717 |
A |
20 |
|
45717 |
0 |
12483L-4-3.jpg |
6000 |
4000 |
N |
45173 |
32785 |
product |
47135 |
A |
20 |
|
47135 |
0 |
12497M-2-3.jpg |
6000 |
4000 |
N |
45180 |
32787 |
product |
47142 |
A |
20 |
|
47142 |
0 |
12497M-3-3.jpg |
6000 |
4000 |
N |
45183 |
32788 |
product |
47145 |
A |
20 |
|
47145 |
0 |
12500M-1-3.jpg |
6000 |
4000 |
N |
45186 |
32789 |
product |
47148 |
A |
20 |
|
47148 |
0 |
12500M-2-3.jpg |
6000 |
4000 |
N |
45189 |
32790 |
product |
47151 |
A |
20 |
|
47151 |
0 |
12500M-3-3.jpg |
6000 |
4000 |
N |
45192 |
32791 |
product |
47154 |
A |
20 |
|
47154 |
0 |
12500M-4-3.jpg |
6000 |
4000 |
N |
45196 |
32792 |
product |
47158 |
A |
20 |
|
47158 |
0 |
12502M-1-3.jpg |
6000 |
4000 |
N |
45202 |
32794 |
product |
47164 |
A |
20 |
|
47164 |
0 |
12502M-2-3.jpg |
4872 |
3824 |
N |
45205 |
32795 |
product |
47167 |
A |
20 |
|
47167 |
0 |
12502M-3-3.jpg |
4558 |
4000 |
N |
45209 |
32796 |
product |
47171 |
A |
20 |
|
47171 |
0 |
12511M-2-3.jpg |
6000 |
4000 |
N |
45215 |
32798 |
product |
47177 |
A |
20 |
|
47177 |
0 |
12514M-1-3.jpg |
6000 |
4000 |
N |
45221 |
32800 |
product |
47183 |
A |
20 |
|
47183 |
0 |
12514M-2-3.jpg |
6000 |
4000 |
N |
45226 |
32801 |
product |
47188 |
A |
20 |
|
47188 |
0 |
12514M-3-3.jpg |
6000 |
4000 |
N |
45230 |
32802 |
product |
47192 |
A |
20 |
|
47192 |
0 |
12514M-4-3.jpg |
6000 |
4000 |
N |
45235 |
32803 |
product |
47197 |
A |
20 |
|
47197 |
0 |
12514M-5-3.jpg |
6000 |
4000 |
N |
45238 |
32804 |
product |
47200 |
A |
20 |
|
47200 |
0 |
12516M-1-3.jpg |
6000 |
4000 |
N |
45242 |
32805 |
product |
47204 |
A |
20 |
|
47204 |
0 |
12516M-2-3.jpg |
6000 |
4000 |
N |
45246 |
32806 |
product |
47208 |
A |
20 |
|
47208 |
0 |
12516M-3-3.jpg |
6000 |
4000 |
N |
45250 |
32807 |
product |
47212 |
A |
20 |
|
47212 |
0 |
12516M-4-3.jpg |
6000 |
4000 |
N |
45253 |
32808 |
product |
47215 |
A |
20 |
|
47215 |
0 |
12516M-5-3.jpg |
6000 |
4000 |
N |
45258 |
32809 |
product |
47220 |
A |
20 |
|
47220 |
0 |
12516M-6-3.jpg |
6000 |
4000 |
N |
45261 |
32810 |
product |
47223 |
A |
20 |
|
47223 |
0 |
12519M-1-3.jpg |
6000 |
4000 |
N |
45266 |
32811 |
product |
47228 |
A |
20 |
|
47228 |
0 |
12519M-2-3.jpg |
6000 |
4000 |
N |
45269 |
32812 |
product |
47231 |
A |
20 |
|
47231 |
0 |
12519M-3-3.jpg |
4248 |
3805 |
N |
45273 |
32813 |
product |
47235 |
A |
20 |
|
47235 |
0 |
12519M-4-3.jpg |
5031 |
3799 |
N |
45276 |
32814 |
product |
47238 |
A |
20 |
|
47238 |
0 |
12535L-1-3-1.jpg |
5501 |
4000 |
N |
45281 |
32815 |
product |
47243 |
A |
20 |
|
47243 |
0 |
12535L-2-3-1.jpg |
6000 |
4000 |
N |
45285 |
32816 |
product |
47247 |
A |
20 |
|
47247 |
0 |
12483L-4-4.jpg |
6000 |
4000 |
N |
43632 |
32785 |
product |
45594 |
A |
30 |
|
45594 |
0 |
12514M-3-4.jpg |
6000 |
4000 |
N |
43700 |
32802 |
product |
45662 |
A |
30 |
|
45662 |
0 |
12514M-4-4.jpg |
6000 |
4000 |
N |
43704 |
32803 |
product |
45666 |
A |
30 |
|
45666 |
0 |
12514M-5-4.jpg |
6000 |
4000 |
N |
43708 |
32804 |
product |
45670 |
A |
30 |
|
45670 |
0 |
12516M-1-4.jpg |
6000 |
4000 |
N |
43712 |
32805 |
product |
45674 |
A |
30 |
|
45674 |
0 |
12516M-2-4.jpg |
6000 |
4000 |
N |
43716 |
32806 |
product |
45678 |
A |
30 |
|
45678 |
0 |
12516M-3-4.jpg |
6000 |
4000 |
N |
43720 |
32807 |
product |
45682 |
A |
30 |
|
45682 |
0 |
12516M-4-4.jpg |
6000 |
4000 |
N |
43724 |
32808 |
product |
45686 |
A |
30 |
|
45686 |
0 |
12516M-5-4.jpg |
6000 |
4000 |
N |
43728 |
32809 |
product |
45690 |
A |
30 |
|
45690 |
0 |
12516M-6-4.jpg |
6000 |
4000 |
N |
43732 |
32810 |
product |
45694 |
A |
30 |
|
45694 |
0 |
12519M-1-4.jpg |
3169 |
5675 |
N |
43736 |
32811 |
product |
45698 |
A |
30 |
|
45698 |
0 |
12519M-2-4.jpg |
6000 |
4000 |
N |
43740 |
32812 |
product |
45702 |
A |
30 |
|
45702 |
0 |
12519M-3-4.jpg |
6000 |
4000 |
N |
43744 |
32813 |
product |
45706 |
A |
30 |
|
45706 |
0 |
12519M-4-4.jpg |
4000 |
5784 |
N |
43748 |
32814 |
product |
45710 |
A |
30 |
|
45710 |
0 |
12535L-1-4-1.jpg |
6000 |
4000 |
N |
43752 |
32815 |
product |
45714 |
A |
30 |
|
45714 |
0 |
12535L-2-4-1.jpg |
4000 |
6000 |
N |
43756 |
32816 |
product |
45718 |
A |
30 |
|
45718 |
0 |
12483L-4-4.jpg |
6000 |
4000 |
N |
45174 |
32785 |
product |
47136 |
A |
30 |
|
47136 |
0 |
12514M-1-4.jpg |
6000 |
4000 |
N |
45222 |
32800 |
product |
47184 |
A |
30 |
|
47184 |
0 |
12514M-3-4.jpg |
6000 |
4000 |
N |
45231 |
32802 |
product |
47193 |
A |
30 |
|
47193 |
0 |
12514M-4-4.jpg |
6000 |
4000 |
N |
45236 |
32803 |
product |
47198 |
A |
30 |
|
47198 |
0 |
12514M-5-4.jpg |
6000 |
4000 |
N |
45239 |
32804 |
product |
47201 |
A |
30 |
|
47201 |
0 |
12516M-1-4.jpg |
6000 |
4000 |
N |
45243 |
32805 |
product |
47205 |
A |
30 |
|
47205 |
0 |
12516M-2-4.jpg |
6000 |
4000 |
N |
45247 |
32806 |
product |
47209 |
A |
30 |
|
47209 |
0 |
12516M-3-4.jpg |
6000 |
4000 |
N |
45251 |
32807 |
product |
47213 |
A |
30 |
|
47213 |
0 |
12516M-4-4.jpg |
6000 |
4000 |
N |
45254 |
32808 |
product |
47216 |
A |
30 |
|
47216 |
0 |
12516M-5-4.jpg |
6000 |
4000 |
N |
45259 |
32809 |
product |
47221 |
A |
30 |
|
47221 |
0 |
12516M-6-4.jpg |
6000 |
4000 |
N |
45262 |
32810 |
product |
47224 |
A |
30 |
|
47224 |
0 |
12519M-1-4.jpg |
3169 |
5675 |
N |
45267 |
32811 |
product |
47229 |
A |
30 |
|
47229 |
0 |
12519M-2-4.jpg |
6000 |
4000 |
N |
45271 |
32812 |
product |
47233 |
A |
30 |
|
47233 |
0 |
12519M-3-4.jpg |
6000 |
4000 |
N |
45274 |
32813 |
product |
47236 |
A |
30 |
|
47236 |
0 |
12519M-4-4.jpg |
4000 |
5784 |
N |
45278 |
32814 |
product |
47240 |
A |
30 |
|
47240 |
0 |
12535L-1-4-1.jpg |
6000 |
4000 |
N |
45282 |
32815 |
product |
47244 |
A |
30 |
|
47244 |
0 |
12535L-2-4-1.jpg |
4000 |
6000 |
N |
45286 |
32816 |
product |
47248 |
A |
30 |
|
47248 |