{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "7.91"
},
"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": 12,
"rows_produced_per_join": 12,
"filtered": "100.00",
"index_condition": "((`cscartdb`.`cscart_seo_names`.`object_id` in (30395,30818,30374,30287,30313,30566,30434,30499,30242,30164)) 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": "6.71",
"eval_cost": "1.20",
"prefix_cost": "7.91",
"data_read_per_join": "20K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
30164 | half-and-half-gunmetal-red-black-heart-ring-slip-chain-fashion-version-7844fed | 6/28 |
30242 | biothane-golden-long-spiked-choker-vegan-leather-7392be9 | 4/347 |
30287 | dark-green-biothane-martingale-1-2in-vegan-leather-897aad3 | 4/347 |
30313 | black-wine-red-biothane-leash-vegan-leather-1d3f427 | 4/347 |
30374 | biothane-pink-heart-choker-vegan-leather-92a031 | 4/347 |
30395 | pink-wings-choker-5e0db6b | 4/347 |
30434 | biothane-rainbow-purple-heart-choker-vegan-leather-5bb4969 | 4/347 |
30499 | valentine-red-lace-hearts-choker-8d200bb | 4/347 |
30566 | zodiac-collection-aries-choker-914bdb1 | 4/347 |
30818 | pick-and-choose-build-your-own-fashion-slipchain-youre-the-designer-2bf8469 | 6/28 |