{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "14.21"
},
"nested_loop": [
{
"table": {
"table_name": "PI",
"access_type": "range",
"possible_keys": [
"product_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"rows_examined_per_scan": 11,
"rows_produced_per_join": 11,
"filtered": "100.00",
"index_condition": "(`dev2`.`PI`.`product_id` in (28608,28612,32915,8862,14430))",
"cost_info": {
"read_cost": "5.11",
"eval_cost": "1.10",
"prefix_cost": "6.21",
"data_read_per_join": "352"
},
"used_columns": [
"product_id",
"watermark_small_file_id",
"alt"
]
}
},
{
"table": {
"table_name": "F",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"id"
],
"key_length": "4",
"ref": [
"dev2.PI.watermark_small_file_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 11,
"filtered": "100.00",
"cost_info": {
"read_cost": "6.90",
"eval_cost": "1.10",
"prefix_cost": "14.21",
"data_read_per_join": "40K"
},
"used_columns": [
"id",
"path"
]
}
}
]
}
}
path | product_id | alt |
---|---|---|
https://s3.timeweb.cloud/482029f9-prod/products__images/8862_614695edc7a3_%D0%91%D0%BE%D1%80%D1%82%D0%BE%D0%B2%D0%BE%D0%B9_JAC_90_%D1%81_%D0%9A%D0%9C%D0%A3__1_.webp | 8862 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/14430_e0fafde55d71_1_zyih-ap_t289-ti_s2g0-53.webp | 14430 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/28608_67e478cfe2f0_28770_d49344c096f0_28608_e199bc0d8aab_28609_2592f84522b1_Dayun%25252520HKTC%252525205014.webp | 28608 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/28612_c31ba573549d_32296_df5f0fb04fa5_28612_7eed05562e23_28768_efc05b60f87c_28612_79ef3cc3d74c_28686_97862b6ee760_28612_a09c221f400c_28613_c3298377c2a6_0_b0e96978d57e_Dayun%252525252525252520XCMG%252525252525252520125-4.webp | 28612 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/28612_89a1e6ebf29c_32296_6a80cc7de21b_28612_3c7042ad9bd8_Dayun%252520XCMG%252520125-4-1.webp | 28612 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/32915_78371ae0a57e_33326_e9358ee90b01_32915_25933e72faa8_32916_81542b7d10e6_0_f985ff4b44d2_WhatsApp252520Image252520202 | 32915 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/32915_b6e690957c3d_33326_ecc342971696_32915_ab9bd3137f2b_32916_22a1cedce9a9_0_201407a9d3df_WhatsApp252520Image252520202 | 32915 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/32915_41a55d2b9a75_33326_415c1db09f94_32915_12d072d04f61_32916_af5717153a9a_0_3e6878e1eabd_WhatsApp252520Image252520202 | 32915 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/32915_0ac14a425472_33326_14540e8eb565_32915_45be20cbf373_32916_263dae995bf2_0_6d959686f3c7_WhatsApp252520Image252520202 | 32915 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/32915_aa66c1ade04b_33326_d75174559ebf_32915_d7230b638226_32916_75545d888414_0_8a68dcec0950_WhatsApp252520Image252520202 | 32915 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/32915_8b1664a89230_33326_664b9811db25_32915_60aca029dee5_32916_6492f861ccd2_0_65bfeb8b49a7_WhatsApp252520Image252520202 | 32915 |