Query time 0.00282
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "401.61"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "77.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": 77,
"rows_produced_per_join": 77,
"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 ('32689','32690','32691','32692','32693','32694','32695','32696','32697','32698','32699','32700','32701','32702','32703','32704','32705','32706','32707','32708','32709','32710','32711','32712','32713','32714','32715','32716','32717','32718','32719','32720')))",
"cost_info": {
"read_cost": "124.41",
"eval_cost": "15.40",
"prefix_cost": "139.81",
"data_read_per_join": "7K"
},
"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": 77,
"filtered": "100.00",
"cost_info": {
"read_cost": "77.00",
"eval_cost": "15.40",
"prefix_cost": "232.21",
"data_read_per_join": "58K"
},
"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": 77,
"filtered": "100.00",
"cost_info": {
"read_cost": "77.00",
"eval_cost": "15.40",
"prefix_cost": "324.61",
"data_read_per_join": "45K"
},
"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 |
|
|
|
|
43260 |
32689 |
product |
45222 |
A |
10 |
|
|
0 |
|
|
|
|
43264 |
32690 |
product |
45226 |
A |
10 |
|
|
0 |
|
|
|
|
43268 |
32691 |
product |
45230 |
A |
10 |
|
|
0 |
|
|
|
|
43272 |
32692 |
product |
45234 |
A |
10 |
|
|
0 |
|
|
|
|
43276 |
32693 |
product |
45238 |
A |
10 |
|
|
0 |
|
|
|
|
43280 |
32694 |
product |
45242 |
A |
10 |
|
|
0 |
|
|
|
|
43284 |
32695 |
product |
45246 |
A |
10 |
|
|
0 |
|
|
|
|
43288 |
32696 |
product |
45250 |
A |
10 |
|
|
0 |
|
|
|
|
43292 |
32697 |
product |
45254 |
A |
10 |
|
|
0 |
|
|
|
|
43296 |
32698 |
product |
45258 |
A |
10 |
|
|
0 |
|
|
|
|
43300 |
32699 |
product |
45262 |
A |
10 |
|
|
0 |
|
|
|
|
43304 |
32700 |
product |
45266 |
A |
10 |
|
|
0 |
|
|
|
|
43308 |
32701 |
product |
45270 |
A |
10 |
|
|
0 |
|
|
|
|
43312 |
32702 |
product |
45274 |
A |
10 |
|
|
0 |
|
|
|
|
43316 |
32703 |
product |
45278 |
A |
10 |
|
|
0 |
|
|
|
|
43320 |
32704 |
product |
45282 |
A |
10 |
|
|
0 |
|
|
|
|
43324 |
32705 |
product |
45286 |
A |
10 |
|
|
0 |
|
|
|
|
43327 |
32706 |
product |
45289 |
A |
10 |
|
|
0 |
|
|
|
|
43331 |
32707 |
product |
45293 |
A |
10 |
|
|
0 |
|
|
|
|
43335 |
32708 |
product |
45297 |
A |
10 |
|
|
0 |
|
|
|
|
43366 |
32716 |
product |
45328 |
A |
10 |
|
|
0 |
|
|
|
|
43370 |
32717 |
product |
45332 |
A |
10 |
|
|
0 |
|
|
|
|
43374 |
32718 |
product |
45336 |
A |
10 |
|
|
0 |
|
|
|
|
43378 |
32719 |
product |
45340 |
A |
10 |
|
|
0 |
|
|
|
|
43382 |
32720 |
product |
45344 |
A |
10 |
|
|
0 |
|
|
|
|
44827 |
32689 |
product |
46789 |
A |
10 |
|
|
0 |
|
|
|
|
44832 |
32690 |
product |
46794 |
A |
10 |
|
|
0 |
|
|
|
|
44835 |
32691 |
product |
46797 |
A |
10 |
|
|
0 |
|
|
|
|
44838 |
32692 |
product |
46800 |
A |
10 |
|
|
0 |
|
|
|
|
44842 |
32693 |
product |
46804 |
A |
10 |
|
|
0 |
|
|
|
|
44845 |
32694 |
product |
46807 |
A |
10 |
|
|
0 |
|
|
|
|
44850 |
32695 |
product |
46812 |
A |
10 |
|
|
0 |
|
|
|
|
44853 |
32696 |
product |
46815 |
A |
10 |
|
|
0 |
|
|
|
|
44856 |
32697 |
product |
46818 |
A |
10 |
|
|
0 |
|
|
|
|
44861 |
32698 |
product |
46823 |
A |
10 |
|
|
0 |
|
|
|
|
44865 |
32699 |
product |
46827 |
A |
10 |
|
|
0 |
|
|
|
|
44869 |
32700 |
product |
46831 |
A |
10 |
|
|
0 |
|
|
|
|
44873 |
32701 |
product |
46835 |
A |
10 |
|
|
0 |
|
|
|
|
44876 |
32702 |
product |
46838 |
A |
10 |
|
|
0 |
|
|
|
|
44880 |
32703 |
product |
46842 |
A |
10 |
|
|
0 |
|
|
|
|
44883 |
32704 |
product |
46845 |
A |
10 |
|
|
0 |
|
|
|
|
44886 |
32705 |
product |
46848 |
A |
10 |
|
|
0 |
|
|
|
|
44888 |
32706 |
product |
46850 |
A |
10 |
|
|
0 |
|
|
|
|
44892 |
32707 |
product |
46854 |
A |
10 |
|
|
0 |
|
|
|
|
44895 |
32708 |
product |
46857 |
A |
10 |
|
|
0 |
|
|
|
|
44917 |
32715 |
product |
46879 |
A |
10 |
|
|
0 |
|
|
|
|
44921 |
32716 |
product |
46883 |
A |
10 |
|
|
0 |
|
|
|
|
44925 |
32717 |
product |
46887 |
A |
10 |
|
|
0 |
|
|
|
|
44930 |
32718 |
product |
46892 |
A |
10 |
|
|
0 |
|
|
|
|
44934 |
32719 |
product |
46896 |
A |
10 |
|
|
0 |
|
|
|
|
44938 |
32720 |
product |
46900 |
A |
10 |
|
|
0 |
|
|
|
|
43261 |
32689 |
product |
45223 |
A |
20 |
|
|
0 |
|
|
|
|
43265 |
32690 |
product |
45227 |
A |
20 |
|
|
0 |
|
|
|
|
43269 |
32691 |
product |
45231 |
A |
20 |
|
|
0 |
|
|
|
|
43273 |
32692 |
product |
45235 |
A |
20 |
|
|
0 |
|
|
|
|
43277 |
32693 |
product |
45239 |
A |
20 |
|
|
0 |
|
|
|
|
43281 |
32694 |
product |
45243 |
A |
20 |
|
|
0 |
|
|
|
|
43285 |
32695 |
product |
45247 |
A |
20 |
|
|
0 |
|
|
|
|
43289 |
32696 |
product |
45251 |
A |
20 |
|
|
0 |
|
|
|
|
43293 |
32697 |
product |
45255 |
A |
20 |
|
|
0 |
|
|
|
|
43297 |
32698 |
product |
45259 |
A |
20 |
|
|
0 |
|
|
|
|
43301 |
32699 |
product |
45263 |
A |
20 |
|
|
0 |
|
|
|
|
43305 |
32700 |
product |
45267 |
A |
20 |
|
|
0 |
|
|
|
|
43309 |
32701 |
product |
45271 |
A |
20 |
|
|
0 |
|
|
|
|
43313 |
32702 |
product |
45275 |
A |
20 |
|
|
0 |
|
|
|
|
43317 |
32703 |
product |
45279 |
A |
20 |
|
|
0 |
|
|
|
|
43321 |
32704 |
product |
45283 |
A |
20 |
|
|
0 |
|
|
|
|
43328 |
32706 |
product |
45290 |
A |
20 |
|
|
0 |
|
|
|
|
43332 |
32707 |
product |
45294 |
A |
20 |
|
|
0 |
|
|
|
|
43336 |
32708 |
product |
45298 |
A |
20 |
|
|
0 |
|
|
|
|
43367 |
32716 |
product |
45329 |
A |
20 |
|
|
0 |
|
|
|
|
43371 |
32717 |
product |
45333 |
A |
20 |
|
|
0 |
|
|
|
|
43375 |
32718 |
product |
45337 |
A |
20 |
|
|
0 |
|
|
|
|
43379 |
32719 |
product |
45341 |
A |
20 |
|
|
0 |
|
|
|
|
43383 |
32720 |
product |
45345 |
A |
20 |
|
|
0 |
|
|
|
|
44828 |
32689 |
product |
46790 |
A |
20 |
|
|
0 |
|
|
|
|
44833 |
32690 |
product |
46795 |
A |
20 |
|
|
0 |
|
|
|
|
44836 |
32691 |
product |
46798 |
A |
20 |
|
|
0 |
|
|
|
|
44839 |
32692 |
product |
46801 |
A |
20 |
|
|
0 |
|
|
|
|
44843 |
32693 |
product |
46805 |
A |
20 |
|
|
0 |
|
|
|
|
44847 |
32694 |
product |
46809 |
A |
20 |
|
|
0 |
|
|
|
|
44851 |
32695 |
product |
46813 |
A |
20 |
|
|
0 |
|
|
|
|
44854 |
32696 |
product |
46816 |
A |
20 |
|
|
0 |
|
|
|
|
44858 |
32697 |
product |
46820 |
A |
20 |
|
|
0 |
|
|
|
|
44862 |
32698 |
product |
46824 |
A |
20 |
|
|
0 |
|
|
|
|
44867 |
32699 |
product |
46829 |
A |
20 |
|
|
0 |
|
|
|
|
44870 |
32700 |
product |
46832 |
A |
20 |
|
|
0 |
|
|
|
|
44874 |
32701 |
product |
46836 |
A |
20 |
|
|
0 |
|
|
|
|
44877 |
32702 |
product |
46839 |
A |
20 |
|
|
0 |
|
|
|
|
44881 |
32703 |
product |
46843 |
A |
20 |
|
|
0 |
|
|
|
|
44884 |
32704 |
product |
46846 |
A |
20 |
|
|
0 |
|
|
|
|
44889 |
32706 |
product |
46851 |
A |
20 |
|
|
0 |
|
|
|
|
44893 |
32707 |
product |
46855 |
A |
20 |
|
|
0 |
|
|
|
|
44896 |
32708 |
product |
46858 |
A |
20 |
|
|
0 |
|
|
|
|
44903 |
32710 |
product |
46865 |
A |
20 |
|
|
0 |
|
|
|
|
44907 |
32711 |
product |
46869 |
A |
20 |
|
|
0 |
|
|
|
|
44910 |
32712 |
product |
46872 |
A |
20 |
|
|
0 |
|
|
|
|
44922 |
32716 |
product |
46884 |
A |
20 |
|
|
0 |
|
|
|
|
44926 |
32717 |
product |
46888 |
A |
20 |
|
|
0 |
|
|
|
|
44932 |
32718 |
product |
46894 |
A |
20 |
|
|
0 |
|
|
|
|
44935 |
32719 |
product |
46897 |
A |
20 |
|
|
0 |
|
|
|
|
44940 |
32720 |
product |
46902 |
A |
20 |
|
|
0 |
|
|
|
|
43262 |
32689 |
product |
45224 |
A |
30 |
|
|
0 |
|
|
|
|
43266 |
32690 |
product |
45228 |
A |
30 |
|
|
0 |
|
|
|
|
43270 |
32691 |
product |
45232 |
A |
30 |
|
|
0 |
|
|
|
|
43274 |
32692 |
product |
45236 |
A |
30 |
|
|
0 |
|
|
|
|
43278 |
32693 |
product |
45240 |
A |
30 |
|
|
0 |
|
|
|
|
43282 |
32694 |
product |
45244 |
A |
30 |
|
|
0 |
|
|
|
|
43286 |
32695 |
product |
45248 |
A |
30 |
|
|
0 |
|
|
|
|
43290 |
32696 |
product |
45252 |
A |
30 |
|
|
0 |
|
|
|
|
43294 |
32697 |
product |
45256 |
A |
30 |
|
|
0 |
|
|
|
|
43298 |
32698 |
product |
45260 |
A |
30 |
|
|
0 |
|
|
|
|
43302 |
32699 |
product |
45264 |
A |
30 |
|
|
0 |
|
|
|
|
43306 |
32700 |
product |
45268 |
A |
30 |
|
|
0 |
|
|
|
|
43310 |
32701 |
product |
45272 |
A |
30 |
|
|
0 |
|
|
|
|
43314 |
32702 |
product |
45276 |
A |
30 |
|
|
0 |
|
|
|
|
43318 |
32703 |
product |
45280 |
A |
30 |
|
|
0 |
|
|
|
|
43322 |
32704 |
product |
45284 |
A |
30 |
|
|
0 |
|
|
|
|
43325 |
32705 |
product |
45287 |
A |
30 |
|
|
0 |
|
|
|
|
43329 |
32706 |
product |
45291 |
A |
30 |
|
|
0 |
|
|
|
|
43333 |
32707 |
product |
45295 |
A |
30 |
|
|
0 |
|
|
|
|
43337 |
32708 |
product |
45299 |
A |
30 |
|
|
0 |
|
|
|
|
43341 |
32709 |
product |
45303 |
A |
30 |
|
|
0 |
|
|
|
|
43349 |
32711 |
product |
45311 |
A |
30 |
|
|
0 |
|
|
|
|
43368 |
32716 |
product |
45330 |
A |
30 |
|
|
0 |
|
|
|
|
43372 |
32717 |
product |
45334 |
A |
30 |
|
|
0 |
|
|
|
|
43376 |
32718 |
product |
45338 |
A |
30 |
|
|
0 |
|
|
|
|
43380 |
32719 |
product |
45342 |
A |
30 |
|
|
0 |
|
|
|
|
43384 |
32720 |
product |
45346 |
A |
30 |
|
|
0 |
|
|
|
|
44829 |
32689 |
product |
46791 |
A |
30 |
|
|
0 |
|
|
|
|
44834 |
32690 |
product |
46796 |
A |
30 |
|
|
0 |
|
|
|
|
44837 |
32691 |
product |
46799 |
A |
30 |
|
|
0 |
|
|
|
|
44840 |
32692 |
product |
46802 |
A |
30 |
|
|
0 |
|
|
|
|
44844 |
32693 |
product |
46806 |
A |
30 |
|
|
0 |
|
|
|
|
44848 |
32694 |
product |
46810 |
A |
30 |
|
|
0 |
|
|
|
|
44852 |
32695 |
product |
46814 |
A |
30 |
|
|
0 |
|
|
|
|
44855 |
32696 |
product |
46817 |
A |
30 |
|
|
0 |
|
|
|
|
44860 |
32697 |
product |
46822 |
A |
30 |
|
|
0 |
|
|
|
|
44863 |
32698 |
product |
46825 |
A |
30 |
|
|
0 |
|
|
|
|
44868 |
32699 |
product |
46830 |
A |
30 |
|
|
0 |
|
|
|
|
44871 |
32700 |
product |
46833 |
A |
30 |
|
|
0 |
|
|
|
|
44875 |
32701 |
product |
46837 |
A |
30 |
|
|
0 |
|
|
|
|
44879 |
32702 |
product |
46841 |
A |
30 |
|
|
0 |
|
|
|
|
44882 |
32703 |
product |
46844 |
A |
30 |
|
|
0 |
|
|
|
|
44885 |
32704 |
product |
46847 |
A |
30 |
|
|
0 |
|
|
|
|
44887 |
32705 |
product |
46849 |
A |
30 |
|
|
0 |
|
|
|
|
44890 |
32706 |
product |
46852 |
A |
30 |
|
|
0 |
|
|
|
|
44894 |
32707 |
product |
46856 |
A |
30 |
|
|
0 |
|
|
|
|
44898 |
32708 |
product |
46860 |
A |
30 |
|
|
0 |
|
|
|
|
44923 |
32716 |
product |
46885 |
A |
30 |
|
|
0 |
|
|
|
|
44927 |
32717 |
product |
46889 |
A |
30 |
|
|
0 |
|
|
|
|
44933 |
32718 |
product |
46895 |
A |
30 |
|
|
0 |
|
|
|
|
44936 |
32719 |
product |
46898 |
A |
30 |
|
|
0 |
|
|
|
|
44941 |
32720 |
product |
46903 |
A |
30 |
|
|