Query time 0.00472
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "929.61"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "167.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": 167,
"rows_produced_per_join": 167,
"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 ('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": "328.41",
"eval_cost": "33.40",
"prefix_cost": "361.81",
"data_read_per_join": "15K"
},
"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": 167,
"filtered": "100.00",
"cost_info": {
"read_cost": "167.00",
"eval_cost": "33.40",
"prefix_cost": "562.21",
"data_read_per_join": "127K"
},
"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": 167,
"filtered": "100.00",
"cost_info": {
"read_cost": "167.00",
"eval_cost": "33.40",
"prefix_cost": "762.61",
"data_read_per_join": "99K"
},
"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 |
|
|
|
|
73171 |
45784 |
product |
75122 |
A |
1 |
|
|
0 |
|
|
|
|
73177 |
45785 |
product |
75128 |
A |
1 |
|
|
0 |
|
|
|
|
75196 |
45788 |
product |
77139 |
A |
1 |
|
|
0 |
|
|
|
|
75198 |
45789 |
product |
77141 |
A |
1 |
|
|
0 |
|
|
|
|
75204 |
45790 |
product |
77147 |
A |
1 |
|
|
0 |
|
|
|
|
75208 |
45787 |
product |
77151 |
A |
1 |
|
|
0 |
|
|
|
|
75213 |
45791 |
product |
77156 |
A |
1 |
|
|
0 |
|
|
|
|
75217 |
45792 |
product |
77160 |
A |
1 |
|
|
0 |
|
|
|
|
75220 |
45793 |
product |
77163 |
A |
1 |
|
|
0 |
|
|
|
|
75225 |
45794 |
product |
77168 |
A |
1 |
|
|
0 |
|
|
|
|
75245 |
45802 |
product |
77188 |
A |
1 |
|
|
0 |
|
|
|
|
75249 |
45803 |
product |
77192 |
A |
1 |
|
|
0 |
|
|
|
|
75256 |
45804 |
product |
77199 |
A |
1 |
|
|
0 |
|
|
|
|
75261 |
45805 |
product |
77204 |
A |
1 |
|
|
0 |
|
|
|
|
75263 |
45806 |
product |
77206 |
A |
1 |
|
|
0 |
|
|
|
|
75272 |
45807 |
product |
77215 |
A |
1 |
|
|
0 |
|
|
|
|
75280 |
45809 |
product |
77223 |
A |
1 |
|
|
0 |
|
|
|
|
75282 |
45810 |
product |
77225 |
A |
1 |
|
|
0 |
|
|
|
|
75285 |
45810 |
product |
77228 |
A |
1 |
|
|
0 |
|
|
|
|
75299 |
45815 |
product |
77242 |
A |
1 |
|
|
0 |
|
|
|
|
75306 |
45818 |
product |
77249 |
A |
1 |
|
|
0 |
|
|
|
|
75312 |
45819 |
product |
77255 |
A |
1 |
|
|
0 |
|
|
|
|
75313 |
45820 |
product |
77256 |
A |
1 |
|
|
0 |
|
|
|
|
75319 |
45821 |
product |
77262 |
A |
1 |
|
|
0 |
|
|
|
|
75323 |
45822 |
product |
77266 |
A |
1 |
|
|
0 |
|
|
|
|
75329 |
45823 |
product |
77272 |
A |
1 |
|
|
0 |
|
|
|
|
75332 |
45825 |
product |
77275 |
A |
1 |
|
|
0 |
|
|
|
|
75336 |
45827 |
product |
77279 |
A |
1 |
|
|
0 |
|
|
|
|
75340 |
45828 |
product |
77283 |
A |
1 |
|
|
0 |
|
|
|
|
75345 |
45829 |
product |
77288 |
A |
1 |
|
|
0 |
|
|
|
|
75381 |
45800 |
product |
77324 |
A |
1 |
|
|
0 |
|
|
|
|
75484 |
45826 |
product |
77427 |
A |
1 |
|
|
0 |
|
|
|
|
75496 |
45812 |
product |
77439 |
A |
1 |
|
|
0 |
|
|
|
|
78183 |
45814 |
product |
80126 |
A |
1 |
|
|
0 |
|
|
|
|
78667 |
47690 |
product |
80610 |
A |
1 |
|
|
0 |
|
|
|
|
79094 |
47746 |
product |
81037 |
A |
1 |
|
|
0 |
|
|
|
|
79098 |
47750 |
product |
81041 |
A |
1 |
|
|
0 |
|
|
|
|
79100 |
47751 |
product |
81043 |
A |
1 |
|
|
0 |
|
|
|
|
79102 |
47752 |
product |
81045 |
A |
1 |
|
|
0 |
|
|
|
|
79104 |
47753 |
product |
81047 |
A |
1 |
|
|
0 |
|
|
|
|
79180 |
47768 |
product |
81123 |
A |
1 |
|
|
0 |
|
|
|
|
79182 |
47769 |
product |
81125 |
A |
1 |
|
|
0 |
|
|
|
|
73172 |
45784 |
product |
75123 |
A |
2 |
|
|
0 |
|
|
|
|
75199 |
45789 |
product |
77142 |
A |
2 |
|
|
0 |
|
|
|
|
75205 |
45790 |
product |
77148 |
A |
2 |
|
|
0 |
|
|
|
|
75209 |
45787 |
product |
77152 |
A |
2 |
|
|
0 |
|
|
|
|
75214 |
45791 |
product |
77157 |
A |
2 |
|
|
0 |
|
|
|
|
75221 |
45793 |
product |
77164 |
A |
2 |
|
|
0 |
|
|
|
|
75226 |
45794 |
product |
77169 |
A |
2 |
|
|
0 |
|
|
|
|
75242 |
45801 |
product |
77185 |
A |
2 |
|
|
0 |
|
|
|
|
75246 |
45802 |
product |
77189 |
A |
2 |
|
|
0 |
|
|
|
|
75250 |
45803 |
product |
77193 |
A |
2 |
|
|
0 |
|
|
|
|
75257 |
45804 |
product |
77200 |
A |
2 |
|
|
0 |
|
|
|
|
75264 |
45806 |
product |
77207 |
A |
2 |
|
|
0 |
|
|
|
|
75283 |
45810 |
product |
77226 |
A |
2 |
|
|
0 |
|
|
|
|
75286 |
45810 |
product |
77229 |
A |
2 |
|
|
0 |
|
|
|
|
75289 |
45813 |
product |
77232 |
A |
2 |
|
|
0 |
|
|
|
|
75303 |
45816 |
product |
77246 |
A |
2 |
|
|
0 |
|
|
|
|
75307 |
45818 |
product |
77250 |
A |
2 |
|
|
0 |
|
|
|
|
75315 |
45820 |
product |
77258 |
A |
2 |
|
|
0 |
|
|
|
|
75324 |
45822 |
product |
77267 |
A |
2 |
|
|
0 |
|
|
|
|
75333 |
45825 |
product |
77276 |
A |
2 |
|
|
0 |
|
|
|
|
75337 |
45827 |
product |
77280 |
A |
2 |
|
|
0 |
|
|
|
|
75382 |
45800 |
product |
77325 |
A |
2 |
|
|
0 |
|
|
|
|
75485 |
45826 |
product |
77428 |
A |
2 |
|
|
0 |
|
|
|
|
73173 |
45784 |
product |
75124 |
A |
3 |
|
|
0 |
|
|
|
|
75200 |
45789 |
product |
77143 |
A |
3 |
|
|
0 |
|
|
|
|
75210 |
45787 |
product |
77153 |
A |
3 |
|
|
0 |
|
|
|
|
75269 |
45807 |
product |
77212 |
A |
3 |
|
|
0 |
|
|
|
|
75290 |
45813 |
product |
77233 |
A |
3 |
|
|
0 |
|
|
|
|
75316 |
45820 |
product |
77259 |
A |
3 |
|
|
0 |
|
|
|
|
75334 |
45825 |
product |
77277 |
A |
3 |
|
|
0 |
|
|
|
|
75383 |
45800 |
product |
77326 |
A |
3 |
|
|
0 |
|
|
|
|
75486 |
45826 |
product |
77429 |
A |
3 |
|
|
0 |
|
|
|
|
73174 |
45784 |
product |
75125 |
A |
4 |
|
|
0 |
|
|
|
|
75211 |
45787 |
product |
77154 |
A |
4 |
|
|
0 |
|
|
|
|
75296 |
45813 |
product |
77239 |
A |
4 |
|
|
0 |
|
|
|
|
75384 |
45800 |
product |
77327 |
A |
4 |
|
|
0 |
|
|
|
|
75487 |
45826 |
product |
77430 |
A |
4 |
|
|
0 |
|
|
|
|
73175 |
45784 |
product |
75126 |
A |
5 |
|
|
0 |
|
|
|
|
75488 |
45826 |
product |
77431 |
A |
5 |
|
|
0 |
|
|
|
|
75274 |
45807 |
product |
77217 |
A |
6 |
|
|
0 |
|
|
|
|
75489 |
45826 |
product |
77432 |
A |
6 |
|
|
0 |
|
|
|
|
75271 |
45807 |
product |
77214 |
A |
7 |
|
|
0 |
|
|
|
|
75503 |
45811 |
product |
77446 |
A |
7 |
|
|
0 |
|
|
|
|
75504 |
45811 |
product |
77447 |
A |
8 |
|
|