{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "44.01"
},
"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": 20,
"rows_produced_per_join": 20,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (38210,38212,38213,38214,38215,38216,38217,38218,38219,38220,38221,38222,38223,38224,38225,35122)) 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": "40.01",
"eval_cost": "4.00",
"prefix_cost": "44.01",
"data_read_per_join": "33K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
35122 | chloe-absolu-de-perfume-75-ml | 2/3 |
38210 | mini-crystal-1080-edp-25-ml-hugo-boss-red-women | 2/3/4 |
38212 | mini-crystal-1092-edp-25-ml-ga-acqua-di-gio-profumo-m | 2/3/39 |
38213 | mini-crystal-1093-edp-25-ml-mont-blanc-legend-m | 2/3/39 |
38214 | mini-crystal-1094-edp-25-ml-mont-blanc-legend-spirit-m | 2/3/39 |
38215 | mini-crystal-1107-edp-25-ml-hugo-boss-the-scent-w | 2/3/4 |
38216 | mini-crystal-1114-edp-25-ml-dunhill-icon-absolute-m | 2/3/5 |
38217 | mini-crystal-1125-edp-25-ml-lalique-amethyst-w | 2/3/5 |
38218 | mini-crystal-1127-edp-25-ml-nasomatto-black-afgano | 2/3/5 |
38219 | bvlgari-man-in-black-edp-3-x-15ml-miniture | 2/3/5 |
38220 | carrera-m-edt-100mlasb-150mlsg-150ml-set | 2/3/5 |
38221 | gucci-bloom-w-edp-100ml100ml-bl7.4ml-roller-ball-set | 2/3/4 |
38222 | gucci-guilty-m-50ml-all-over-shampoo50ml-abs-set | 2/3/5 |
38223 | guerlain-mon-w-edp-100ml5ml-mini75ml-blpouch-set | 2/3/4 |
38224 | hermes-eau-dorange-verte-edc-100ml7.5ml-mini40ml-sg40ml-bl-set | 2/3/39 |
38225 | pink-ice-edp-80-ml-deo-200-ml-set | 2/3/4 |