{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "17.71"
},
"table": {
"table_name": "cscart_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": 26,
"rows_produced_per_join": 26,
"filtered": "100.00",
"index_condition": "((`cscartdb`.`cscart_seo_names`.`object_id` in (60362,60403,60371,60401,60357,60402,60358,60375,60376,60377,60373,60383,60359,60392,60393,60381,60385,60394,60386,60391,60408,60407,60384,60397)) and (`cscartdb`.`cscart_seo_names`.`type` = 'p') and (`cscartdb`.`cscart_seo_names`.`dispatch` = '') and (`cscartdb`.`cscart_seo_names`.`lang_code` = 'en'))",
"cost_info": {
"read_cost": "15.11",
"eval_cost": "2.60",
"prefix_cost": "17.71",
"data_read_per_join": "44K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
60357 | leather-bondage-armbinder | 4/14/556 |
60358 | leather-bondage-armbinder-zipper | 4/14/556 |
60359 | leather-bondage-gwendoline-armbinder | 4/14/556 |
60362 | leather-gwendoline-bondage-hood | 4/516 |
60371 | leather-bondage-hood-en | 4/516 |
60373 | leather-bondage-blindfold-with-buckle | 4/15 |
60375 | leather-bondage-curved-blindfold-with-buckle | 4/15 |
60376 | leather-bondage-face-cover-blindfold | 4/15 |
60377 | leather-bondage-facehugger-ball-gag | 4/16 |
60381 | leather-bondage-heavy-harness-gag | 4/16 |
60383 | leather-bondage-mittens | 4/14/556 |
60384 | leather-bondage-o-ring-collar | 4/347 |
60385 | leather-bondage-panel-gag | 4/16 |
60386 | leather-bondage-simple-style-harness-gag | 4/16 |
60391 | leather-simple-chin-strap-bondage-ball-gag | 4/16 |
60392 | leather-chin-strap-bondage-ball-gag | 4/16 |
60393 | leather-simple-single-strap-bondage-ball-gag | 4/16 |
60394 | leather-single-strap-bondage-ball-gag | 4/16 |
60397 | locking-post-arms-to-collar-bondage-detention-restraint-system | 4/14/556 |
60401 | leather-open-airway-bondage-hood | 4/516 |
60402 | leather-open-eye-hole-bondage-hood | 4/516 |
60403 | leather-open-mouth-bondage-hood | 4/516 |
60407 | tear-drop-leather-bondage-collar | 4/347 |
60408 | tear-drop-leather-bondage-collar-and-leash-set | 4/347 |