{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "15.34"
},
"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": 12,
"rows_produced_per_join": 12,
"filtered": "100.00",
"index_condition": "(`dev2`.`PI`.`product_id` in (27289,33018,14430,14655,28608))",
"cost_info": {
"read_cost": "5.46",
"eval_cost": "1.20",
"prefix_cost": "6.66",
"data_read_per_join": "384"
},
"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": 12,
"filtered": "100.00",
"cost_info": {
"read_cost": "7.48",
"eval_cost": "1.20",
"prefix_cost": "15.34",
"data_read_per_join": "44K"
},
"used_columns": [
"id",
"path"
]
}
}
]
}
}
path | product_id | alt |
---|---|---|
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/14655_fba9116374f3_20190920_084848_gm6s-mt_i0bp-5e.webp | 14655 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/27289_09daabbd7013_385ef3a0-bacc-4178-a52f-0713df507061_s0lz-bi_f4iq-w0_c3ed-ab_gxii-qc.webp | 27289 | |
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/33018_62f64a34a01f_33021_f5b055b3fb3f_0_deae0d8a40eb_IMG-20241010-WA0023jpgwebp | 33018 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/33018_4f3f06f581e0_33021_e6105945e46b_0_58b171faa5b5_IMG-20241010-WA0022jpgwebp | 33018 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/33018_67440dda5985_33021_d429381181da_0_d21763fcd4a4_IMG-20241010-WA0024jpgwebp | 33018 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/33018_86950a9fee14_33021_edd1aaca6be0_0_58b171faa5b5_IMG-20241010-WA0021jpgwebp | 33018 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/33018_27848a00bad3_33021_c4eec3c703ab_0_10e224fd0656_IMG-20241010-WA0025jpgwebp | 33018 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/33018_4bcefa2498d1_33021_2da385b38a01_0_10e224fd0656_IMG-20241010-WA0005jpgwebp | 33018 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/33018_6c90cd4b01b5_33021_04782d61d7f7_0_ec52aaed44f4_izobraghenie-WhatsApp-2025-01-29-v-122707_aec771e3jpgwebp | 33018 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/33018_e806b26ddb84_33021_363707b994d6_0_3fe347f7d976_izobraghenie-WhatsApp-2025-01-29-v-122707_f0692a21jpgwebp | 33018 |