{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "38.41"
},
"table": {
"table_name": "q_seo_names",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"rows_examined_per_scan": 16,
"rows_produced_per_join": 16,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (37422,37423,37424,37425,37426,37427,37428,37429,37430,37431,37432,37433,37434,37435,37436,37437)) and (`portal`.`q_seo_names`.`type` = 'p') and (`portal`.`q_seo_names`.`dispatch` = '') and (`portal`.`q_seo_names`.`lang_code` = 'en'))",
"cost_info": {
"read_cost": "35.21",
"eval_cost": "3.20",
"prefix_cost": "38.41",
"data_read_per_join": "27K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
37422 | valentino-uomo-edition-feutre-m-edt-100ml | 2/3/5 |
37423 | valentino-uomo-noir-absolu-edp-100ml | 2/3/39 |
37424 | valentino-valenitina-poudre-w-edp-50ml | 2/3/4 |
37425 | valentino-valenitina-poudre-w-edp-80ml | 2/3/4 |
37426 | valentino-valentina-w-edp-80ml | 2/3/4 |
37427 | valentino-valentina-blush-edp-80ml | 2/3/39 |
37428 | valentino-valentina-oud-assoluto-w-edp-80ml | 2/3/4 |
37429 | valentino-valentina-pink-w-edp-80ml | 2/3/4 |
37430 | valentino-valentina-rosa-assoluto-w-edp-80ml | 2/3/4 |
37431 | van-cleef-and-arpels-first-edt-100ml | 2/3/39 |
37432 | van-cleef-and-arpels-reve-dylang-edp-125ml | 2/3/39 |
37433 | van-girls-tendenza-edt-125ml | 2/3/39 |
37434 | venitienne-w-edp-100nl | 2/3/4 |
37435 | vera-wang-glam-princess-w-edt-100ml | 2/3/4 |
37436 | vera-wang-love-struck-edp-100ml | 2/3/39 |
37437 | vera-wang-princess-w-edt-100ml | 2/3/4 |