{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "88.01"
},
"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": 40,
"rows_produced_per_join": 40,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (13593,13601,14240,14241,14242,14243,14244,14245,14246,14247,14248,14249,14250,14251,14252,14253,14254,14255,14256,14257,14258,14259,14260,14261,14263,14264,14265,14266,14267,14268,14269,14270)) 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": "80.01",
"eval_cost": "8.00",
"prefix_cost": "88.01",
"data_read_per_join": "67K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
13593 | bling-jewelry-polished-paw-print-stud-earrings-925-sterling-silver-10mm | 12/13/44/46/298 |
13601 | bling-jewelry-heart-shaped-matte-gold-plated-brass-petal-flower-clip-on-earrings | 12/13/44/46/298 |
14240 | bio-etic-bijoux-italy-earring-rivolo-10mm-light-turchese-bioetic | 12/13/44/46/298 |
14241 | bio-etic-bijoux-italy-earring-moon-10x7mm-light-siam | 12/13/44/46/298 |
14242 | bio-etic-bijoux-italy-earring-butterfly-10mm-crystal | 12/13/44/46/298 |
14243 | bio-etic-bijoux-italy-earring-drop-8mm-aurora-boreale-bioetic | 12/13/44/46/298 |
14244 | bio-etic-bijoux-italy-earring-flower-10mm-crystal-bioetic | 12/13/44/46/298 |
14245 | bio-etic-bijoux-italy-earring-rivolo-10mm-paradise-shine-bioetic | 12/13/44/46/298 |
14246 | bio-etic-bijoux-italy-earring-star-10mm-bermude-blue-bioetic | 12/13/44/46/298 |
14247 | bio-etic-bijoux-italy-earring-heart-8x8.-8mm-light-siam | 12/13/44/46/298 |
14248 | bio-etic-bijoux-italy-earring-butterfly-10mm-rose-peach-bioetic | 12/13/44/46/298 |
14249 | bio-etic-bijoux-italy-earring-baby-cat-love-smaltato-bioetic | 12/13/44/46/298 |
14250 | bio-etic-bijoux-italy-earring-red-ladybug-smaltata-bioetic | 12/13/44/46/298 |
14251 | bio-etic-bijoux-italy-earring-pendente-heart-bioetic | 12/13/44/46/298 |
14252 | bio-etic-bijoux-italy-earring-turtle-smaltata-verde-bioetic | 12/13/44/46/298 |
14253 | bio-etic-bijoux-italy-earring-star-10mm-crystal | 12/13/44/46/298 |
14254 | bio-etic-bijoux-italy-earring-pearl-8mmcream | 12/13/44/46/298 |
14255 | bio-etic-bijoux-italy-earring-flower-6mm-acquamarina | 12/13/44/46/298 |
14256 | bio-etic-bijoux-italy-earring-star-6mmvitrail-light-bioetic | 12/13/44/46/298 |
14257 | bio-etic-bijoux-italy-earring-bat-8mm-crystal | 12/13/44/46/298 |
14258 | bio-etic-bijoux-italy-earring-heart-6x6.-6mm-light-siam | 12/13/44/46/298 |
14259 | bio-etic-bijoux-italy-earring-drop-6mm-rose | 12/13/44/46/298 |
14260 | bio-etic-bijoux-italy-earring-pearl-8mm-white | 12/13/44/46/298 |
14261 | bio-etic-bijoux-italy-earring-butterfly-5mm-rose-peach | 12/13/44/46/298 |
14263 | bio-etic-bijoux-italy-earring-moon-8x5mm-aurora-boreale | 12/13/44/46/298 |
14264 | bio-etic-bijoux-italy-earring-bat-8mm-denim-blue | 12/13/44/46/298 |
14265 | bio-etic-bijoux-italy-earring-xirius-7.-15mmcrystal | 12/13/44/46/298 |
14266 | bio-etic-bijoux-italy-earring-oval-rivolo-6x8mm-rose | 12/13/44/46/298 |
14267 | bio-etic-bijoux-italy-earring-xirius-7.-15mm-liliac-shadow | 12/13/44/46/298 |
14268 | bio-etic-bijoux-italy-earring-star-5mm-aurora-boreale | 12/13/44/46/298 |
14269 | bio-etic-bijoux-italy-earring-luna-8x5mmcrystal | 12/13/44/46/298 |
14270 | bio-etic-bijoux-italy-earring-goccia-6mm-crystal | 12/13/44/46/298 |