{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "73.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": 31,
"rows_produced_per_join": 31,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (294,295,296,297,298,299,300,301,302,303,304,305,306,307,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261)) 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": "67.21",
"eval_cost": "6.20",
"prefix_cost": "73.41",
"data_read_per_join": "52K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
246 | elie-saab-girl-of-now-edp-50ml | 2/3/4 |
247 | elie-saab-girl-of-now-forever-edp-50ml | 2/3/4 |
248 | elie-saab-girl-of-now-shine-edp-50ml | 2/3/4 |
249 | elie-saab-girl-of-now-shine-edp-90ml | 2/3/4 |
250 | elie-saab-intense-le-perfume-for-women-edp-30ml | 2/3/4 |
251 | elie-saab-intense-le-perfume-for-women-edp-50ml | 2/3/4 |
252 | elie-saab-le-parfum-in-white-for-women-edp-30ml | 2/3/4 |
253 | elie-saab-le-parfum-in-white-for-women-edp-90ml | 2/3/4 |
254 | elie-saab-le-parfum-resort-collection-edt-50ml | 2/3/4 |
255 | elie-saab-le-parfum-rose-couture-edt-50ml | 2/3/4 |
256 | elie-saab-le-parfum-rose-couture-edt-90ml | 2/3/4 |
257 | elie-saab-le-perfume-for-women-edp-50ml | 2/3/4 |
258 | elie-saab-le-perfume-for-women-edt-30ml | 2/3/4 |
259 | elie-saab-le-perfume-leau-couture-for-women-edt-50ml | 2/3/4 |
260 | elie-saab-le-perfume-resort-collection-for-women-edt-50ml | 2/3/4 |
261 | elie-saab-le-perfume-resort-collection-2017-for-women-edt-90ml | 2/3/4 |
294 | calvin-klein-eternity-for-men-edt-50ml | 2/3/5 |
295 | calvin-klein-eternity-for-women-edp-100ml | 2/3/4 |
296 | calvin-klein-eternity-aqua-for-men-edt-20ml-travel-spray | 2/3/5 |
297 | calvin-klein-eternity-intense-for-men-edt-100ml | 2/3/5 |
298 | calvin-klein-eternity-intense-for-women-edp-100ml | 2/3/4 |
299 | calvin-klein-eternity-now-for-men-edt-100ml | 2/3/5 |
300 | calvin-klein-eternity-now-for-men-edt-50ml | 2/3/5 |
301 | calvin-klein-eternity-now-for-women-edp-50ml | 2/3/4 |
302 | calvin-klein-euphoria-for-men-edt-50ml | 2/3/5 |
303 | calvin-klein-euphoria-for-women-edp-100ml | 2/3/4 |
304 | calvin-klein-euphoria-blossom-for-women-edt-30ml | 2/3/4 |
305 | calvin-klein-euphoria-deep-for-women-edp-100ml | 2/3/4 |
306 | calvin-klein-euphoria-deep-for-women-edp-50ml | 2/3/4 |
307 | calvin-klein-euphoria-forbidden-for-women-edp-100ml | 2/3/4 |