{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "76.81"
},
"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": 32,
"rows_produced_per_join": 32,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (35664,35665,35666,35667,35668,35669,35670,35671,35672,35673,35674,35675,35676,35677,35678,35679,35680,35681,35682,35683,35684,35685,35686,35687,35688,35689,35690,35691,35692,35693,35694,35695)) 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": "70.41",
"eval_cost": "6.40",
"prefix_cost": "76.81",
"data_read_per_join": "54K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
35664 | nasomatto-absinth-edp-30ml | 2/3/39 |
35665 | nasomatto-black-afgano-edp-30ml | 2/3/39 |
35666 | nasomatto-blamage-edp-30ml | 2/3/39 |
35667 | nasomatto-china-white-edp-30ml | 2/3/39 |
35668 | nasomatto-duro-edp-30ml | 2/3/39 |
35669 | nasomatto-narcotic-v-edp-30ml | 2/3/39 |
35670 | nasomatto-nudiflourum-edp-30ml | 2/3/39 |
35671 | nasomatto-silver-musk-edp-30ml | 2/3/39 |
35672 | nicolai-amber-oud-edp-100ml | 2/3/39 |
35673 | nicolai-cuir-cuba-intense-edp-100ml | 2/3/39 |
35674 | nicolai-eau-d-ete-100ml | 2/3/39 |
35675 | nicolai-incense-oud-edp-100ml | 2/3/39 |
35676 | nicolai-kiss-me-intense-edp-100ml | 2/3/39 |
35677 | nicolai-musc-intense-edp-100ml | 2/3/39 |
35678 | nicolai-oud-sublime-edp-35ml | 2/3/39 |
35679 | nicolai-patchouli-intense-edp-250ml15ml-mini | 2/3/39 |
35680 | nicolai-rose-pivoine-edt-100ml | 2/3/39 |
35681 | nicolai-rose-royale-edt-100ml | 2/3/39 |
35682 | nisane-pachuli-kozha-edp-50ml | 2/3/39 |
35683 | nishane-afrika-olifant-edp-50ml | 2/3/39 |
35684 | nishane-b-612-edp-50ml | 2/3/39 |
35685 | nishane-boszporusz-edp-50ml | 2/3/39 |
35686 | nishane-colognise-u-edc-100ml | 2/3/39 |
35687 | nishane-duftbluten-edp-50ml | 2/3/39 |
35688 | nishane-hundred-silent-ways-edp-50ml | 2/3/39 |
35689 | nishane-karagoz-edp-55ml | 2/3/39 |
35690 | nishane-munegu-edp-50ml | 2/3/39 |
35691 | nishane-musiqa-oud-edp-50ml | 2/3/39 |
35692 | nishane-pasion-choco-edp-50ml | 2/3/39 |
35693 | nishane-seude-et-safran-edp-50ml | 2/3/39 |
35694 | nishane-sultan-vetiver-edp-50ml | 2/3/39 |
35695 | nishane-tuberoza-u-edp-50ml | 2/3/39 |