Query time 0.00479
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "429.21"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "74.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": 74,
"rows_produced_per_join": 74,
"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 ('3028','3162','3163','3164','3165','3033','3139','3140','3141','3142','3038','3167','3168','3169','3170','3043','3102','3104','3105','3106','3093','3098','3108','3067','3175','3176','3177','3178','3071','3172','3173','2942','3088','3090','3091','2946','3130','3131','3132','3133','2951','3135','3136','3137','2955','4667','4668','4669','2959','5806','5807','5808','2963','5986','5987','5988','5989','5990','2972','5999','6000','6001','2976','6007','6008','6009','2980','6003','6004','6005','2984','6011','6012','6013')))",
"cost_info": {
"read_cost": "162.81",
"eval_cost": "14.80",
"prefix_cost": "177.61",
"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": 74,
"filtered": "100.00",
"cost_info": {
"read_cost": "74.00",
"eval_cost": "14.80",
"prefix_cost": "266.41",
"data_read_per_join": "56K"
},
"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": 74,
"filtered": "100.00",
"cost_info": {
"read_cost": "74.00",
"eval_cost": "14.80",
"prefix_cost": "355.21",
"data_read_per_join": "43K"
},
"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 |
0918-blue1.jpg |
900 |
1200 |
N |
6382 |
2942 |
product |
8347 |
M |
0 |
|
8347 |
0 |
9068-1.jpg |
900 |
1200 |
N |
6394 |
2946 |
product |
8359 |
M |
0 |
|
8359 |
0 |
8833221698_2061676148_pnlf-hc.jpg |
800 |
800 |
N |
6928 |
3071 |
product |
8893 |
M |
0 |
|
8893 |
0 |
10366172194_778880422_1wu3-3k.jpg |
1001 |
1001 |
N |
7302 |
3093 |
product |
9267 |
M |
0 |
|
9267 |
0 |
7405267236_712867067_cgbf-4g.jpg |
800 |
800 |
N |
7318 |
3098 |
product |
9283 |
M |
0 |
|
9283 |
0 |
10340041207_778880422.jpg |
1001 |
1001 |
N |
7331 |
3102 |
product |
9296 |
M |
0 |
|
9296 |
0 |
10340041207_778880422_0cgh-az.jpg |
1001 |
1001 |
N |
7337 |
3104 |
product |
9302 |
M |
0 |
|
9302 |
0 |
10340041207_778880422_4zfb-rk.jpg |
1001 |
1001 |
N |
7340 |
3105 |
product |
9305 |
M |
0 |
|
9305 |
0 |
10340041207_778880422_hlpg-js.jpg |
1001 |
1001 |
N |
7343 |
3106 |
product |
9308 |
M |
0 |
|
9308 |
0 |
10366178160_778880422_x1h8-cp.jpg |
1001 |
1001 |
N |
7361 |
3108 |
product |
9326 |
M |
0 |
|
9326 |
0 |
item_XXL_36109944_142266382_ynxa-1o.jpg |
1000 |
1000 |
N |
7425 |
3175 |
product |
9390 |
M |
0 |
|
9390 |
0 |
item_XXL_36109944_142266382_nygx-lt.jpg |
1000 |
1000 |
N |
7431 |
3176 |
product |
9396 |
M |
0 |
|
9396 |
0 |
item_XXL_36109944_142266382_nrpb-x6.jpg |
1000 |
1000 |
N |
7436 |
3177 |
product |
9401 |
M |
0 |
|
9401 |
0 |
9214953824_1705777042.jpg |
800 |
800 |
N |
7441 |
3178 |
product |
9406 |
M |
0 |
|
9406 |
0 |
7708-1.JPG |
800 |
1200 |
N |
7773 |
2951 |
product |
9738 |
M |
0 |
|
9738 |
0 |
7703-1.JPG |
800 |
1200 |
N |
7781 |
2955 |
product |
9746 |
M |
0 |
|
9746 |
0 |
7702-1.JPG |
800 |
1200 |
N |
7813 |
2959 |
product |
9778 |
M |
0 |
|
9778 |
0 |
7149-1.JPG |
800 |
1200 |
N |
7925 |
2972 |
product |
9890 |
M |
0 |
|
9890 |
0 |
7146-1.JPG |
800 |
1200 |
N |
7957 |
2976 |
product |
9922 |
M |
0 |
|
9922 |
0 |
7143-1.JPG |
800 |
1200 |
N |
7989 |
2980 |
product |
9954 |
M |
0 |
|
9954 |
0 |
7142-1.JPG |
800 |
1200 |
N |
8029 |
2984 |
product |
9994 |
M |
0 |
|
9994 |
0 |
7525-2.JPG |
800 |
1200 |
N |
11407 |
5990 |
product |
13369 |
M |
0 |
|
13369 |
0 |
7525-2_iugl-i1.JPG |
800 |
1200 |
N |
11424 |
5989 |
product |
13386 |
M |
0 |
|
13386 |
0 |
7150-1_shnz-mc.JPG |
800 |
1200 |
N |
11434 |
5986 |
product |
13396 |
M |
0 |
|
13396 |
0 |
7150-1_kr5a-70.JPG |
800 |
1200 |
N |
11439 |
5987 |
product |
13401 |
M |
0 |
|
13401 |
0 |
7150-1_u641-ht.JPG |
800 |
1200 |
N |
11444 |
5988 |
product |
13406 |
M |
0 |
|
13406 |
0 |
7149-1.JPG |
800 |
1200 |
N |
81735 |
6009 |
product |
83678 |
M |
0 |
|
83678 |
0 |
7143-1.JPG |
800 |
1200 |
N |
81736 |
6007 |
product |
83679 |
M |
0 |
|
83679 |
0 |
7143-1_zrrt-xd.JPG |
800 |
1200 |
N |
81737 |
6007 |
product |
83680 |
M |
0 |
|
83680 |
0 |
item_XXL_36429628_143041063_ione-03.jpg |
888 |
1200 |
N |
81739 |
3162 |
product |
83682 |
M |
0 |
|
83682 |
0 |
0918-blue1.jpg |
900 |
1200 |
N |
83638 |
3088 |
product |
8347 |
M |
0 |
|
8347 |
0 |
0918-blue1.jpg |
900 |
1200 |
N |
83640 |
3090 |
product |
8347 |
M |
0 |
|
8347 |
0 |
0918-blue1.jpg |
900 |
1200 |
N |
83641 |
3091 |
product |
8347 |
M |
0 |
|
8347 |
0 |
10340041207_778880422_f6x4-dr.jpg |
1001 |
1001 |
N |
83644 |
3043 |
product |
9299 |
M |
0 |
|
9299 |
0 |
9068-1.jpg |
900 |
1200 |
N |
83681 |
3130 |
product |
8359 |
M |
0 |
|
8359 |
0 |
9068-1.jpg |
900 |
1200 |
N |
83682 |
3131 |
product |
8359 |
M |
0 |
|
8359 |
0 |
9068-1.jpg |
900 |
1200 |
N |
83683 |
3132 |
product |
8359 |
M |
0 |
|
8359 |
0 |
9068-1.jpg |
900 |
1200 |
N |
83684 |
3133 |
product |
8359 |
M |
0 |
|
8359 |
0 |
7708-1.JPG |
800 |
1200 |
N |
83714 |
3135 |
product |
9738 |
M |
0 |
|
9738 |
0 |
7708-1.JPG |
800 |
1200 |
N |
83715 |
3136 |
product |
9738 |
M |
0 |
|
9738 |
0 |
7708-1.JPG |
800 |
1200 |
N |
83716 |
3137 |
product |
9738 |
M |
0 |
|
9738 |
0 |
100319-apricot-1.jpg |
900 |
1200 |
N |
83737 |
3139 |
product |
8565 |
M |
0 |
|
8565 |
0 |
100319-apricot-1.jpg |
900 |
1200 |
N |
83738 |
3140 |
product |
8565 |
M |
0 |
|
8565 |
0 |
100319-apricot-1.jpg |
900 |
1200 |
N |
83739 |
3141 |
product |
8565 |
M |
0 |
|
8565 |
0 |
100319-apricot-1.jpg |
900 |
1200 |
N |
83740 |
3142 |
product |
8565 |
M |
0 |
|
8565 |
0 |
item_L_35874488_139511657_pze9-md.jpg |
214 |
300 |
N |
83741 |
3033 |
product |
83541 |
M |
0 |
|
83541 |
0 |
item_XXL_36429628_143041062.jpg |
900 |
1200 |
N |
83767 |
3163 |
product |
8540 |
M |
0 |
|
8540 |
0 |
item_XXL_36429628_143041062.jpg |
900 |
1200 |
N |
83768 |
3164 |
product |
8540 |
M |
0 |
|
8540 |
0 |
item_XXL_36429628_143041062.jpg |
900 |
1200 |
N |
83769 |
3165 |
product |
8540 |
M |
0 |
|
8540 |
0 |
item_XXL_36429628_143041063.jpg |
888 |
1200 |
N |
83770 |
3028 |
product |
83681 |
M |
0 |
|
83681 |
0 |
8833221698_2061676148_pnlf-hc.jpg |
800 |
800 |
N |
83799 |
3172 |
product |
8893 |
M |
0 |
|
8893 |
0 |
8833221698_2061676148_pnlf-hc.jpg |
800 |
800 |
N |
83800 |
3173 |
product |
8893 |
M |
0 |
|
8893 |
0 |
item_XXL_36109944_142266382.jpg |
1000 |
1000 |
N |
83806 |
3067 |
product |
9384 |
M |
0 |
|
9384 |
0 |
7703-1.JPG |
800 |
1200 |
N |
83896 |
4667 |
product |
9746 |
M |
0 |
|
9746 |
0 |
7703-1.JPG |
800 |
1200 |
N |
83897 |
4668 |
product |
9746 |
M |
0 |
|
9746 |
0 |
7703-1.JPG |
800 |
1200 |
N |
83898 |
4669 |
product |
9746 |
M |
0 |
|
9746 |
0 |
7702-1.JPG |
800 |
1200 |
N |
83928 |
5806 |
product |
9778 |
M |
0 |
|
9778 |
0 |
7702-1.JPG |
800 |
1200 |
N |
83929 |
5807 |
product |
9778 |
M |
0 |
|
9778 |
0 |
7702-1.JPG |
800 |
1200 |
N |
83930 |
5808 |
product |
9778 |
M |
0 |
|
9778 |
0 |
7150-1.JPG |
800 |
1200 |
N |
83966 |
2963 |
product |
13391 |
M |
0 |
|
13391 |
0 |
7149-1.JPG |
800 |
1200 |
N |
83998 |
5999 |
product |
9890 |
M |
0 |
|
9890 |
0 |
7149-1.JPG |
800 |
1200 |
N |
83999 |
6000 |
product |
9890 |
M |
0 |
|
9890 |
0 |
7149-1.JPG |
800 |
1200 |
N |
84000 |
6001 |
product |
9890 |
M |
0 |
|
9890 |
0 |
7143-1.JPG |
800 |
1200 |
N |
84030 |
6003 |
product |
9954 |
M |
0 |
|
9954 |
0 |
7143-1.JPG |
800 |
1200 |
N |
84031 |
6004 |
product |
9954 |
M |
0 |
|
9954 |
0 |
7143-1.JPG |
800 |
1200 |
N |
84032 |
6005 |
product |
9954 |
M |
0 |
|
9954 |
0 |
7146-1.JPG |
800 |
1200 |
N |
84048 |
6008 |
product |
9922 |
M |
0 |
|
9922 |
0 |
7142-1.JPG |
800 |
1200 |
N |
84078 |
6011 |
product |
9994 |
M |
0 |
|
9994 |
0 |
7142-1.JPG |
800 |
1200 |
N |
84079 |
6012 |
product |
9994 |
M |
0 |
|
9994 |
0 |
7142-1.JPG |
800 |
1200 |
N |
84080 |
6013 |
product |
9994 |
M |
0 |
|
9994 |
0 |
10445613899_822367466.jpg |
683 |
1024 |
N |
7151 |
3038 |
product |
9116 |
M |
1 |
|
9116 |
0 |
10445613899_822367466.jpg |
683 |
1024 |
N |
83782 |
3167 |
product |
9116 |
M |
1 |
|
9116 |
0 |
10445613899_822367466.jpg |
683 |
1024 |
N |
83783 |
3168 |
product |
9116 |
M |
1 |
|
9116 |
0 |
10445613899_822367466.jpg |
683 |
1024 |
N |
83784 |
3169 |
product |
9116 |
M |
1 |
|
9116 |
0 |
10445613899_822367466.jpg |
683 |
1024 |
N |
83785 |
3170 |
product |
9116 |
M |
1 |
|
9116 |