{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "39.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": 17,
"rows_produced_per_join": 17,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (29273,29280,29281,29301,29313,29368,29379,29695,29820,29831,29863,29865,29867,29868,29869,29873)) 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": "36.41",
"eval_cost": "3.40",
"prefix_cost": "39.81",
"data_read_per_join": "28K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
29273 | foldable-colorful-play-toy-tent-ocean-ball-pit-pool-for-kids-sz1004 | 248/249 |
29280 | money-gun-red-can-be-sprayed-50-100-money-works-on-a-9-volt-battery-included | 248/249 |
29281 | 6pcs-exclusive-interesting-chic-pull-back-car-toys-car-children-racing-car-baby-mini-cars-cartoon-pull-back-bus-truck-kids-toys-for-children-boy-gifts-gyh | 248/249 |
29301 | headrest-safety-protection-for-children-head-protection-pad-anti-falling-cap-baby-walking-anti-falling-pillow-helmet | 248/249/254/507 |
29313 | 2-in-1-magnetielearning-blackboard-for-kids-by-easel-zjj-en | 248/249/256 |
29368 | baby-music-plush-activity-crib-stroller-soft-toys-rabbit-star-shape | 248/249/579 |
29379 | pgytech-control-stick-protector-for-mavic-2 | 248/249/533 |
29695 | 80-colors-art-sketch-drawing-twin-marker-paiting-pen-set-black | 248/249/255/436 |
29820 | 6pcs-train-toy-set-children-educational-toys-railway-track-train-gift-for-kids | 248/249 |
29831 | hoselling-60-pieces-wooden-puzzles-kids-educational-toys-diy-wooden-jigsaw-puzzle-for-children-adults-baby-childrens-building | 248/249/253/532 |
29863 | pipeline-tunnel-blocks-diy-bricks-toys-kids-educational-toy-pipe-blocks-training-toys-child-gift-family-board-game | 248/249/253/532 |
29865 | children-cute-lovely-totoro-doll-kids-new-cartoon-plush-doll-toy | 248/249/254/509 |
29867 | action-figures-toys-star-wars-4pcs-character-model-garage-kits-model-toys-office-decoration-accessories-for-childrens-holiday-gifts | 248/249/459 |
29868 | 5pcs-sets-fishing-toys-network-bag-random-color-pick-up-sun-flower-kids-toy-swimming-classes-summer-play-water-bath-doll-water-spray-bath-toys | 248/249/271 |
29869 | 1-32-scale-metal-diecast-figure-model-car-toys-mini-alloy-antique-vintage-batman-beatles-classic-cars | 248/249/251 |
29873 | building-blocks-clock-childrens-educational-toys-digital-animals-clock-puzzle-toys | 248/249/256 |