{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "83.21"
},
"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": 38,
"rows_produced_per_join": 38,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (37553,37554,37555,37557,37558,37559,37560,37561,37562,37563,37820,37821,37822,37823,37824,37825,37826,37827,37832,37833,37850,37858,37862,37864,37867,37868,37869,37872,37873,37874)) 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": "75.61",
"eval_cost": "7.60",
"prefix_cost": "83.21",
"data_read_per_join": "64K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
37553 | bvlgari-goldea-the-roman-night-edp-75ml75ml-bl75ml-sgpouch-set | 2/3/39 |
37554 | bvlgari-man-black-cologne-edt-100ml75ml-asb75ml-sgpouch-set | 2/3/39 |
37555 | bvlgari-man-extreme-edt-15mlbvlgari-in-black-edp-15mlbvlgari-man-edt-15ml-mini-set | 2/3/39 |
37557 | bvlgari-man-in-black-edp-100ml75ml-deo-stick-set | 2/3/39 |
37558 | bvlgari-man-in-black-edp-15mlman-extreme-15mlman-black-cologne-15ml-mni-set | 2/3/5 |
37559 | bvlgari-man-in-black-edp-60ml40ml-asb40ml-sg-set | 2/3/39 |
37560 | bvlgari-omnia-amethyste-w-edt-65ml15ml-mini-set | 2/3/4 |
37561 | bvlgari-omnia-amethyste-w-edt-65ml75ml-bl75ml-blpouch-set | 2/3/4 |
37562 | bvlgari-omnia-coral-w-edt-65ml15ml-pouch-set | 2/3/4 |
37563 | bvlgari-omnia-paraiba-w-edt-65ml15ml-mini-set | 2/3/4 |
37820 | guess-1981-m-body-spray-226ml | 2/3/5 |
37821 | guess-dare-m-body-spray-226ml | 2/3/5 |
37822 | guess-girl-250ml-body-mist | 2/3/4 |
37823 | guess-girl-belle-250ml-body-mist | 2/3/4 |
37824 | guess-pink-w-250ml-body-mist | 2/3/4 |
37825 | guess-seductive-m-body-spray-226ml | 2/3/5 |
37826 | guess-seductive-w-250ml-body-mist | 2/3/4 |
37827 | guess-seductive-blue-m-body-spray-226ml | 2/3/5 |
37832 | heros-250-ml-deo. | 2/3/39 |
37833 | hind-maroon-petite-3-ml-concentrated-oil | 2/3/4 |
37850 | lalique-amethyst-w-body-cream-200ml | 2/3/4 |
37858 | lucky-brand-lucky-you-w-236ml-body-mist | 2/3 |
37862 | mont-blanc-legend-m-after-shave-100ml | 2/3/5 |
37864 | mont-blanc-legend-m-shower-gel-100ml | 2/3/5 |
37867 | montale-paris-powder-flowers-100ml-hair-mist | 2/3/39 |
37868 | montale-paris-roses-elixir-100ml-hair-mist | 2/3/39 |
37869 | montale-paris-white-musk-100ml-hair-mist | 2/3/39 |
37872 | narciso-rodriguez-w-30-ml-hair-mist | 2/3/4 |
37873 | nina-ricci-apple-150ml-deodorant-spray | 2/3/4 |
37874 | nina-ricci-lextase-rose-absolue-30ml-hair-mist | 2/3/39 |