Query time 0.00310
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "307.41"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "53.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": 53,
"rows_produced_per_join": 53,
"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 ('1931','2167','2169','2170','2171','2173','1941','2178','2179','2180','2181','2182','1951','2187','2189','2190','1955','2201','2203','2204','2205','2192','2197','1970','2206','2208','2209','2210','2212','2217','1985','2223','2224','2225','2226','2227','2232','2000','2238','2239','2240','1737','1747','1748','1749','1745','1751','1752','1753','1754','1388','8679','8680')))",
"cost_info": {
"read_cost": "116.61",
"eval_cost": "10.60",
"prefix_cost": "127.21",
"data_read_per_join": "4K"
},
"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": 53,
"filtered": "100.00",
"cost_info": {
"read_cost": "53.00",
"eval_cost": "10.60",
"prefix_cost": "190.81",
"data_read_per_join": "40K"
},
"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": 53,
"filtered": "100.00",
"cost_info": {
"read_cost": "53.00",
"eval_cost": "10.60",
"prefix_cost": "254.41",
"data_read_per_join": "31K"
},
"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 |
1224-black1.jpg |
800 |
1200 |
N |
5088 |
2171 |
product |
7062 |
M |
0 |
|
7062 |
0 |
1224-black1_26h7-0e.jpg |
800 |
1200 |
N |
5090 |
2170 |
product |
7064 |
M |
0 |
|
7064 |
0 |
1224-black1_5yvd-na.jpg |
800 |
1200 |
N |
5092 |
2169 |
product |
7066 |
M |
0 |
|
7066 |
0 |
1224-black1_6tg7-si.jpg |
800 |
1200 |
N |
5096 |
2167 |
product |
7070 |
M |
0 |
|
7070 |
0 |
1224-white1_n43x-3k.jpg |
762 |
941 |
N |
5104 |
2173 |
product |
7078 |
M |
0 |
|
7078 |
0 |
1202-black2.jpg |
800 |
1200 |
N |
5108 |
2181 |
product |
7082 |
M |
0 |
|
7082 |
0 |
1202-black2_i28n-at.jpg |
800 |
1200 |
N |
5113 |
2180 |
product |
7087 |
M |
0 |
|
7087 |
0 |
1202-black2_xqkj-us.jpg |
800 |
1200 |
N |
5118 |
2179 |
product |
7092 |
M |
0 |
|
7092 |
0 |
1202-black2_ziv4-7h.jpg |
800 |
1200 |
N |
5128 |
2178 |
product |
7102 |
M |
0 |
|
7102 |
0 |
1202-white_9gxz-44.jpg |
368 |
601 |
N |
5137 |
2182 |
product |
7111 |
M |
0 |
|
7111 |
0 |
1121-green3.jpg |
801 |
1200 |
N |
5142 |
2205 |
product |
7116 |
M |
0 |
|
7116 |
0 |
1121-green3_ahk2-9t.jpg |
801 |
1200 |
N |
5146 |
2204 |
product |
7120 |
M |
0 |
|
7120 |
0 |
1121-green3_yuwu-l5.jpg |
801 |
1200 |
N |
5150 |
2203 |
product |
7124 |
M |
0 |
|
7124 |
0 |
1121-green3_77cq-07.jpg |
801 |
1200 |
N |
5158 |
2201 |
product |
7132 |
M |
0 |
|
7132 |
0 |
1121-brown_ta7f-d6.jpg |
385 |
633 |
N |
5163 |
2192 |
product |
7137 |
M |
0 |
|
7137 |
0 |
1121-yellow_uql8-54.jpg |
386 |
658 |
N |
5168 |
2197 |
product |
7142 |
M |
0 |
|
7142 |
0 |
1002-black2.jpg |
800 |
1200 |
N |
5170 |
2210 |
product |
7144 |
M |
0 |
|
7144 |
0 |
1002-black2_l1ez-l0.jpg |
800 |
1200 |
N |
5175 |
2209 |
product |
7149 |
M |
0 |
|
7149 |
0 |
1002-black2_ze1j-ta.jpg |
800 |
1200 |
N |
5180 |
2208 |
product |
7154 |
M |
0 |
|
7154 |
0 |
1002-black2_v5yg-tg.jpg |
800 |
1200 |
N |
5190 |
2206 |
product |
7164 |
M |
0 |
|
7164 |
0 |
1002-white2_mr4d-i2.jpg |
592 |
529 |
N |
5208 |
2212 |
product |
7182 |
M |
0 |
|
7182 |
0 |
1002-pink_rpx0-8g_p6y2-7r.jpg |
594 |
530 |
N |
5215 |
2217 |
product |
7189 |
M |
0 |
|
7189 |
0 |
0920-black_jwde-u2.jpg |
867 |
1200 |
N |
5218 |
2223 |
product |
7192 |
M |
0 |
|
7192 |
0 |
0920-black_kz4t-eh.jpg |
867 |
1200 |
N |
5219 |
2224 |
product |
7193 |
M |
0 |
|
7193 |
0 |
0920-black_uqbr-ee.jpg |
867 |
1200 |
N |
5220 |
2225 |
product |
7194 |
M |
0 |
|
7194 |
0 |
0920-black_qt54-ha.jpg |
867 |
1200 |
N |
5221 |
2226 |
product |
7195 |
M |
0 |
|
7195 |
0 |
0920-green.jpg |
867 |
1200 |
N |
5222 |
2227 |
product |
7196 |
M |
0 |
|
7196 |
0 |
0920-white.jpg |
880 |
1200 |
N |
5227 |
2232 |
product |
7201 |
M |
0 |
|
7201 |
0 |
Huawei-Honor-Band-4-Blue.jpg |
700 |
400 |
N |
18179 |
8679 |
product |
20141 |
M |
0 |
|
20141 |
0 |
HUAWEI-Honor-Band-4-Smart-Bracelet-Pink-723661-.jpg |
1000 |
1000 |
N |
18180 |
8680 |
product |
20142 |
M |
0 |
|
20142 |
0 |
414PF5AiCeL._AC__btww-8w.jpg |
351 |
500 |
N |
81681 |
1747 |
product |
83624 |
M |
0 |
|
83624 |
0 |
414PF5AiCeL._AC__d7bu-34.jpg |
351 |
500 |
N |
81682 |
1747 |
product |
83625 |
M |
0 |
|
83625 |
0 |
item_XXL_38874815_151533443.jpg |
553 |
800 |
N |
83435 |
1748 |
product |
6007 |
M |
0 |
|
6007 |
0 |
item_XXL_38874815_151533443.jpg |
553 |
800 |
N |
83436 |
1749 |
product |
6007 |
M |
0 |
|
6007 |
0 |
414PF5AiCeL._AC_.jpg |
351 |
500 |
N |
83437 |
1737 |
product |
83487 |
M |
0 |
|
83487 |
0 |
item_XXL_43764948_e1d7c659b2a5a.jpg |
752 |
968 |
N |
83438 |
1751 |
product |
6011 |
M |
0 |
|
6011 |
0 |
item_XXL_43764948_e1d7c659b2a5a.jpg |
752 |
968 |
N |
83439 |
1752 |
product |
6011 |
M |
0 |
|
6011 |
0 |
item_XXL_43764948_e1d7c659b2a5a.jpg |
752 |
968 |
N |
83440 |
1753 |
product |
6011 |
M |
0 |
|
6011 |
0 |
item_XXL_43764948_e1d7c659b2a5a.jpg |
752 |
968 |
N |
83441 |
1754 |
product |
6011 |
M |
0 |
|
6011 |
0 |
item_XXL_43764948_e1d7c659b2a5a.jpg |
752 |
968 |
N |
83442 |
1745 |
product |
83623 |
M |
0 |
|
83623 |
0 |
1224-black1_qtaa-yj.jpg |
800 |
1200 |
N |
83466 |
1931 |
product |
7068 |
M |
0 |
|
7068 |
0 |
1202-black2_6hwx-27.jpg |
800 |
1200 |
N |
83471 |
1941 |
product |
7097 |
M |
0 |
|
7097 |
0 |
1200-3.jpg |
834 |
1200 |
N |
83484 |
2187 |
product |
6366 |
M |
0 |
|
6366 |
0 |
1200-3.jpg |
834 |
1200 |
N |
83485 |
2189 |
product |
6366 |
M |
0 |
|
6366 |
0 |
1200-3.jpg |
834 |
1200 |
N |
83486 |
2190 |
product |
6366 |
M |
0 |
|
6366 |
0 |
blouse.jpg |
640 |
626 |
N |
83487 |
1951 |
product |
51258 |
M |
0 |
|
51258 |
0 |
1121-green3_wy3t-eu.jpg |
801 |
1200 |
N |
83491 |
1955 |
product |
7128 |
M |
0 |
|
7128 |
0 |
1002-black2_p794-mj.jpg |
800 |
1200 |
N |
83496 |
1970 |
product |
7159 |
M |
0 |
|
7159 |
0 |
2_9cje-a1.jpg |
640 |
626 |
N |
83498 |
1985 |
product |
85248 |
M |
0 |
|
85248 |
0 |
1364-blue1.jpg |
800 |
800 |
N |
83511 |
2238 |
product |
6474 |
M |
0 |
|
6474 |
0 |
1364-blue1.jpg |
800 |
800 |
N |
83512 |
2239 |
product |
6474 |
M |
0 |
|
6474 |
0 |
1364-blue1.jpg |
800 |
800 |
N |
83513 |
2240 |
product |
6474 |
M |
0 |
|
6474 |
0 |
416cPvDBj-L._AC_.jpg |
500 |
500 |
N |
83514 |
2000 |
product |
83488 |
M |
0 |
|
83488 |
0 |
68619408_B_V1.jpg |
1000 |
1000 |
N |
85010 |
1388 |
product |
40473 |
M |
0 |
|
40473 |