{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "69.61"
},
"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": 29,
"rows_produced_per_join": 29,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,2,3,4,5,6,7,8,9,11,12,13)) 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": "63.81",
"eval_cost": "5.80",
"prefix_cost": "69.61",
"data_read_per_join": "49K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
2 | acqua-di-parma-colonia-ambra-eau-de-cologne-180ml | 2/3/5 |
3 | acqua-di-parma-colonia-club-edc-100ml | 2/3/5 |
4 | acqua-di-parma-colonia-ebano-edc-concentree-100ml | 2/3/5 |
5 | acqua-di-parma-colonia-essenza-edc-100ml | 2/3/5 |
6 | acqua-di-parma-colonia-essenza-edc-180ml | 2/3/5 |
7 | acqua-di-parma-colonia-intensa-edc-100ml | 2/3/5 |
8 | acqua-di-parma-colonia-leather-edc-concentree-100ml | 2/3/5 |
9 | acqua-di-parma-colonia-leather-edc-concentree-180ml | 2/3/5 |
11 | acqua-di-parma-colonia-oud-edc-concentree-100ml | 2/3/5 |
12 | acqua-di-parma-colonia-oud-edc-concentree-180ml | 2/3/5 |
13 | acqua-di-parma-colonia-pura-edc-100ml | 2/3/5 |
44 | burberry-mr-burberry-indigo-edt-100ml | 2/3/5 |
45 | burberry-mr-burberry-indigo-edt-150ml | 2/3/5 |
46 | burberry-mr-burberry-indigo-edt-50ml | 2/3/5 |
47 | burberry-my-burberry-for-women-edp-90ml | 2/3/4 |
48 | burberry-my-burberry-black-for-women-edp-50ml | 2/3/4 |
49 | burberry-sport-for-men-edt-50ml | 2/3/5 |
50 | burberry-sport-for-women-edt-50ml | 2/3/4 |
51 | burberry-the-beat-for-men-edt-100ml | 2/3/5 |
52 | burberry-the-beat-for-women-edp-75ml | 2/3/4 |
53 | burberry-touch-for-women-edp-100ml | 2/3/4 |
54 | burberry-touch-for-women-edp-50ml | 2/3/4 |
55 | burberry-weekend-for-women-edp-100ml | 2/3/4 |
56 | burberry-weekend-for-women-edp-50ml | 2/3/4 |
57 | burberry-brit-rhythm-for-men-5mlbrit-splash-5mltouch-for-men-5mlclassic-for-men-4.5ml | 2/3/5 |
58 | burberry-brit-splash-for-men-edt-100ml75ml-deo-stick-travel-set | 2/3/5 |
59 | burberry-london-fabric-for-men-edt-50ml75ml-deo-stick-set | 2/3/5 |
60 | burberry-weekend-for-women-edp-50ml7.5ml-mini-set | 2/3/4 |
61 | burberry-body-for-women-body-oil-35ml | 2/3/4 |