{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "16.57"
},
"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": 13,
"rows_produced_per_join": 13,
"filtered": "100.00",
"index_condition": "(`dev2`.`PI`.`product_id` in (32402,33006,14737,14739,25261))",
"cost_info": {
"read_cost": "5.81",
"eval_cost": "1.30",
"prefix_cost": "7.11",
"data_read_per_join": "416"
},
"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": 13,
"filtered": "100.00",
"cost_info": {
"read_cost": "8.16",
"eval_cost": "1.30",
"prefix_cost": "16.57",
"data_read_per_join": "48K"
},
"used_columns": [
"id",
"path"
]
}
}
]
}
}
path | product_id | alt |
---|---|---|
https://s3.timeweb.cloud/482029f9-prod/products__images/14737_3d3778bfb338_22148-95305_h3wh-m9_9nvr-dv.webp | 14737 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/14739_a008f0a9404a_22146-96196_ncs9-r9_u496-f4.webp | 14739 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/14739_c1e5e21d9a59_22146-96194_2fiq-wd_h529-e9.webp | 14739 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/14739_ee422e954946_22146-96193_qq23-fn_yfmi-bk.webp | 14739 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_fdd16d637513_IMG-20240730-WA0032_2re7-99_wq5p-24.webp | 25261 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_f6ac12f4b3c1_IMG-20240730-WA0028_5er0-bs_ggu2-ij.webp | 25261 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_ee52d4fbbf81_IMG-20240730-WA0029_cw65-se_trym-j0.webp | 25261 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_9c79d34e8ef8_IMG-20240730-WA0030_m1bq-i6_pvc7-62.webp | 25261 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_ea1c58afee5c_IMG-20240730-WA0033_fw1g-0q_812t-z1.webp | 25261 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_62d74536e8e1_IMG-20240730-WA0034_a4bq-yq_b8q9-un.webp | 25261 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/25261_fdaa21a18a0b_IMG-20240730-WA0035_zrri-3x_x8zl-e0.webp | 25261 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/32402_90a220766ce8_32431_83519cbecaf1_%25D0%25A1%25D0%25BC%25D0%25BE%25D1%2582%25D1%2580%25D0%25B5%25D1%2582%25D1%258C%2520%25D0%25BD%25D0%25B5%25D0%25B4%25D0%25B0%25D0%25B2%25D0%25BD%25D0%25B8%25D0%25B5%2520%25D1%2584%25D0%25BE%25D1%2582%25D0%25BE%25281%2529.webp | 32402 | |
https://s3.timeweb.cloud/482029f9-prod/products__images/33006_a22cbc0cfb22_33011_e0c102b5b715_0_3375730d270b_Krone-SDP27webpwebp | 33006 |