Query time 0.00402
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "417.61"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "72.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": 72,
"rows_produced_per_join": 72,
"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 ('2394','2518','2399','2514','2515','2516','2403','2509','2510','2511','2512','2020','2091','2093','2095','2098','2101','2032','2241','2243','2244','2245','2247','2042','2275','2277','2278','2268','2272','2280','2058','2263','2264','2265','2266','1848','2004','2006','2007','2009','2013','2017','1856','2079','2081','2082','2084','2088','1868','2105','2106','2107','2108','2109','1878','2115','2116','2117','2118','1886','2162','2164','2165','2166','2123','2128','2133','2138','2143','2148','2153','2157')))",
"cost_info": {
"read_cost": "158.41",
"eval_cost": "14.40",
"prefix_cost": "172.81",
"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": 72,
"filtered": "100.00",
"cost_info": {
"read_cost": "72.00",
"eval_cost": "14.40",
"prefix_cost": "259.21",
"data_read_per_join": "55K"
},
"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": 72,
"filtered": "100.00",
"cost_info": {
"read_cost": "72.00",
"eval_cost": "14.40",
"prefix_cost": "345.61",
"data_read_per_join": "42K"
},
"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 |
1218-blue2_421c-me.jpg |
850 |
1200 |
N |
4718 |
2007 |
product |
6692 |
M |
0 |
|
6692 |
0 |
007-1.jpg |
800 |
800 |
N |
4854 |
2058 |
product |
6828 |
M |
0 |
|
6828 |
0 |
1218-blue2_fd8e-o7.jpg |
850 |
1200 |
N |
4884 |
2006 |
product |
6858 |
M |
0 |
|
6858 |
0 |
1218-blue2_kz2e-t8.jpg |
850 |
1200 |
N |
4892 |
2004 |
product |
6866 |
M |
0 |
|
6866 |
0 |
1218-black_jhi1-c2.jpg |
800 |
800 |
N |
4899 |
2009 |
product |
6873 |
M |
0 |
|
6873 |
0 |
1218-white_4t8d-p6.jpg |
800 |
800 |
N |
4903 |
2013 |
product |
6877 |
M |
0 |
|
6877 |
0 |
1218-yellow_geqz-3i.jpg |
625 |
800 |
N |
4907 |
2017 |
product |
6881 |
M |
0 |
|
6881 |
0 |
1361-green_gmyo-bt.jpg |
800 |
800 |
N |
4914 |
2084 |
product |
6888 |
M |
0 |
|
6888 |
0 |
1361-pink_ayxg-ty.jpg |
625 |
800 |
N |
4919 |
2088 |
product |
6893 |
M |
0 |
|
6893 |
0 |
1361-white1_11wm-iv.jpg |
625 |
800 |
N |
4921 |
2082 |
product |
6895 |
M |
0 |
|
6895 |
0 |
1361-white1_pylb-fz.jpg |
625 |
800 |
N |
4922 |
2081 |
product |
6896 |
M |
0 |
|
6896 |
0 |
1361-white1_2epv-zp.jpg |
625 |
800 |
N |
4930 |
2079 |
product |
6904 |
M |
0 |
|
6904 |
0 |
1362-blue_o71l-sl.jpg |
900 |
1200 |
N |
4933 |
2093 |
product |
6907 |
M |
0 |
|
6907 |
0 |
1362-blue_qr9y-wn.jpg |
900 |
1200 |
N |
4935 |
2091 |
product |
6909 |
M |
0 |
|
6909 |
0 |
1362-yellow_cnax-p3.jpg |
900 |
1200 |
N |
4936 |
2095 |
product |
6910 |
M |
0 |
|
6910 |
0 |
1362-orange_row0-i1.jpg |
900 |
1200 |
N |
4940 |
2101 |
product |
6914 |
M |
0 |
|
6914 |
0 |
1362-pink_9mmh-20.jpg |
900 |
1200 |
N |
4943 |
2098 |
product |
6917 |
M |
0 |
|
6917 |
0 |
1260-black1_qmeu-4d.jpg |
832 |
1200 |
N |
4949 |
2107 |
product |
6923 |
M |
0 |
|
6923 |
0 |
1260-black1_kx0j-hq.jpg |
832 |
1200 |
N |
4954 |
2108 |
product |
6928 |
M |
0 |
|
6928 |
0 |
1260-black1_opu0-8p.jpg |
832 |
1200 |
N |
4959 |
2106 |
product |
6933 |
M |
0 |
|
6933 |
0 |
1260-black1_shrc-gv.jpg |
832 |
1200 |
N |
4964 |
2105 |
product |
6938 |
M |
0 |
|
6938 |
0 |
1260-white2_up7e-ed.jpg |
685 |
1200 |
N |
4982 |
2109 |
product |
6956 |
M |
0 |
|
6956 |
0 |
1222-blue2_wgcl-kf.jpg |
800 |
800 |
N |
4985 |
2117 |
product |
6959 |
M |
0 |
|
6959 |
0 |
1222-blue2_dtkk-3l.jpg |
800 |
800 |
N |
4989 |
2116 |
product |
6963 |
M |
0 |
|
6963 |
0 |
1222-blue2_gfzq-yf.jpg |
800 |
800 |
N |
4993 |
2115 |
product |
6967 |
M |
0 |
|
6967 |
0 |
1222-red_9ont-do.jpg |
582 |
585 |
N |
5003 |
2118 |
product |
6977 |
M |
0 |
|
6977 |
0 |
1026-black1_avi1-bn.jpg |
868 |
1200 |
N |
5014 |
2123 |
product |
6988 |
M |
0 |
|
6988 |
0 |
1026-blue_ahg8-80.jpg |
870 |
1200 |
N |
5021 |
2128 |
product |
6995 |
M |
0 |
|
6995 |
0 |
1026-yellow.jpg |
870 |
1200 |
N |
5026 |
2133 |
product |
7000 |
M |
0 |
|
7000 |
0 |
1026-red_ouen-hd_yj5t-1w.jpg |
546 |
770 |
N |
5031 |
2138 |
product |
7005 |
M |
0 |
|
7005 |
0 |
1026-green1_7bwu-yr_uabq-6l.jpg |
870 |
1200 |
N |
5039 |
2143 |
product |
7013 |
M |
0 |
|
7013 |
0 |
1026-pink_e66l-nv_04kl-s2.jpg |
562 |
786 |
N |
5047 |
2148 |
product |
7021 |
M |
0 |
|
7021 |
0 |
1026-deepgreen1_4uww-gm_5k7k-tg.jpg |
870 |
1200 |
N |
5059 |
2153 |
product |
7033 |
M |
0 |
|
7033 |
0 |
1026-offwhite_j7ip-0d.jpg |
865 |
1200 |
N |
5064 |
2157 |
product |
7038 |
M |
0 |
|
7038 |
0 |
1026-white1.jpg |
514 |
800 |
N |
5066 |
2166 |
product |
7040 |
M |
0 |
|
7040 |
0 |
1026-white1_n23a-ji.jpg |
514 |
800 |
N |
5070 |
2165 |
product |
7044 |
M |
0 |
|
7044 |
0 |
1026-white1_7sby-6o.jpg |
514 |
800 |
N |
5074 |
2164 |
product |
7048 |
M |
0 |
|
7048 |
0 |
1026-white1_3s1d-s4.jpg |
514 |
800 |
N |
5082 |
2162 |
product |
7056 |
M |
0 |
|
7056 |
0 |
1215-green2_te1c-bo.jpg |
900 |
1200 |
N |
5238 |
2247 |
product |
7212 |
M |
0 |
|
7212 |
0 |
1215-red2.jpg |
900 |
1200 |
N |
5261 |
2241 |
product |
7235 |
M |
0 |
|
7235 |
0 |
1215-red2_2ko1-49.jpg |
900 |
1200 |
N |
5273 |
2243 |
product |
7247 |
M |
0 |
|
7247 |
0 |
1215-red2_hhrr-gm.jpg |
900 |
1200 |
N |
5279 |
2244 |
product |
7253 |
M |
0 |
|
7253 |
0 |
1215-red2_j36h-h8.jpg |
900 |
1200 |
N |
5285 |
2245 |
product |
7259 |
M |
0 |
|
7259 |
0 |
1214-blue1_sxeg-xm.jpg |
900 |
1200 |
N |
5296 |
2268 |
product |
7270 |
M |
0 |
|
7270 |
0 |
1214-yellow1_x0ay-8z.jpg |
700 |
1050 |
N |
5319 |
2272 |
product |
7293 |
M |
0 |
|
7293 |
0 |
1214-red1.jpg |
900 |
1200 |
N |
5335 |
2275 |
product |
7309 |
M |
0 |
|
7309 |
0 |
1214-red1_qdki-su.jpg |
900 |
1200 |
N |
5343 |
2277 |
product |
7317 |
M |
0 |
|
7317 |
0 |
1214-red1_r7nn-qj.jpg |
900 |
1200 |
N |
5347 |
2278 |
product |
7321 |
M |
0 |
|
7321 |
0 |
1214-green1_h7f1-9v.jpg |
900 |
1200 |
N |
5357 |
2280 |
product |
7331 |
M |
0 |
|
7331 |
0 |
100500-1.jpg |
824 |
1200 |
N |
5626 |
2399 |
product |
7597 |
M |
0 |
|
7597 |
0 |
100318.jpg |
900 |
1200 |
N |
5642 |
2403 |
product |
7613 |
M |
0 |
|
7613 |
0 |
item_XL_36645473_143591638.jpg |
400 |
600 |
N |
81565 |
2516 |
product |
83508 |
M |
0 |
|
83508 |
0 |
item_L_35874488_139511657.jpg |
214 |
300 |
N |
81597 |
2510 |
product |
83540 |
M |
0 |
|
83540 |
0 |
1218-blue2_c6dh-oz.jpg |
850 |
1200 |
N |
83446 |
1848 |
product |
6862 |
M |
0 |
|
6862 |
0 |
ladies_shirt_web.jpg |
640 |
626 |
N |
83450 |
1856 |
product |
39647 |
M |
0 |
|
39647 |
0 |
1362-blue_muh8-4c.jpg |
900 |
1200 |
N |
83451 |
2020 |
product |
6908 |
M |
0 |
|
6908 |
0 |
1260-black1_evk9-2d.jpg |
832 |
1200 |
N |
83456 |
1868 |
product |
6943 |
M |
0 |
|
6943 |
0 |
1222-blue2_xror-2n.jpg |
800 |
800 |
N |
83460 |
1878 |
product |
6971 |
M |
0 |
|
6971 |
0 |
1026-white1_4zuk-sg.jpg |
514 |
800 |
N |
83464 |
1886 |
product |
7052 |
M |
0 |
|
7052 |
0 |
1215-red2_2lns-op.jpg |
900 |
1200 |
N |
83520 |
2032 |
product |
7241 |
M |
0 |
|
7241 |
0 |
007-1.jpg |
800 |
800 |
N |
83547 |
2263 |
product |
6828 |
M |
0 |
|
6828 |
0 |
007-1.jpg |
800 |
800 |
N |
83548 |
2264 |
product |
6828 |
M |
0 |
|
6828 |
0 |
007-1.jpg |
800 |
800 |
N |
83549 |
2265 |
product |
6828 |
M |
0 |
|
6828 |
0 |
007-1.jpg |
800 |
800 |
N |
83550 |
2266 |
product |
6828 |
M |
0 |
|
6828 |
0 |
1214-red1_3v43-e9.jpg |
900 |
1200 |
N |
83554 |
2042 |
product |
7313 |
M |
0 |
|
7313 |
0 |
100318.jpg |
900 |
1200 |
N |
83568 |
2509 |
product |
7613 |
M |
0 |
|
7613 |
0 |
100318.jpg |
900 |
1200 |
N |
83569 |
2511 |
product |
7613 |
M |
0 |
|
7613 |
0 |
100318.jpg |
900 |
1200 |
N |
83570 |
2512 |
product |
7613 |
M |
0 |
|
7613 |
0 |
100500-1.jpg |
824 |
1200 |
N |
83584 |
2514 |
product |
7597 |
M |
0 |
|
7597 |
0 |
100500-1.jpg |
824 |
1200 |
N |
83585 |
2515 |
product |
7597 |
M |
0 |
|
7597 |
0 |
dress0119-1.jpg |
600 |
600 |
N |
83586 |
2518 |
product |
7589 |
M |
0 |
|
7589 |
0 |
41Sl0LykiWL._AC_.jpg |
235 |
500 |
N |
83587 |
2394 |
product |
83509 |
M |
0 |
|
83509 |