{
"query_block": {
"select_id": 1,
"table": {
"table_name": "cscart_seo_names",
"access_type": "range",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "PRIMARY",
"key_length": "206",
"used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
"rows": 10,
"filtered": 100,
"attached_condition": "cscart_seo_names.object_id in (551390,552905,552783,552926,551876,552881,552606,552882,551536,551904) and cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en'"
}
}
}
product_id | seo_name | seo_path |
---|---|---|
551390 | ladies-the-one-eau-de-parfum-2.5-oz.-en | 1/8 |
551536 | ladies-pour-femme-eau-de-parfum-1.6-oz.-en | 1/8 |
551876 | pour-homme-intenso-eau-de-parfum-2.5-oz. | 1/8 |
551904 | mens-k-eau-de-toilette-3.3-oz.-en | 1/8 |
552606 | mens-the-one-eau-de-toilette-3.3-oz. | 1/8 |
552783 | ladies-light-blue-eau-de-toilette-1.6-oz. | 1/8 |
552881 | ladies-light-blue-fragrance-1.6-oz.-en | 1/8 |
552882 | mens-light-blue-cologne-2.5-oz.-en | 1/8 |
552905 | ladies-the-one-fragrance-1.6-oz. | 1/8 |
552926 | mens-dolce-and-gabbana-eau-de-toilette-2.5-oz. | 1/8 |