{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "55.21"
},
"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": 28,
"rows_produced_per_join": 28,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (29891,29892,29893,29894,29895,29896,29897,29898,29899,29900,29901,29902,29903,29904,29905,29906)) 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": "49.61",
"eval_cost": "5.60",
"prefix_cost": "55.21",
"data_read_per_join": "47K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
29891 | cute-frog-automatic-bubble-machine-blower-maker-party-summer-outdoor-toy-for-kids-wholesale | 248/249 |
29892 | buck-ball-magnetic-rod-plus-ball-combination-box-set-puzzle-development-brain-educational-toy-stitching-metal-magnetic-block-toy | 248/249/253/532 |
29893 | childrens-beach-swimming-pool-play-with-water-toys-four-pieces-suit-diving-torpedo-toys | 248/257/264/266 |
29894 | electric-pump-ship-model-toys | 248/249/434/435 |
29895 | indoor-polyester-play-house-baby-ocean-ball-pit-pool-kids-princess-hexagonal-tent-blue | 248/257/264/269 |
29896 | dinosaur-stuffed-animal-plush-toy-stuffe-dinosaur-stuffed-toys-lovely-simulation-animal-doll-child-gift-en | 248/249/254/509 |
29897 | pokonyan-piggy-bank-mini-atm-money-box-safety-electronic-password-chewing-coins-cash-deposit-machine-for-children | 6/184/189 |
29898 | 4pcs-lot-rc-quadcopter-motor-accessories-silicone-motor-cap-protector-motor-protective-cover-parts-for-dji-mavic-pro | 299/412/565 |
29899 | bath-and-beach-toy-tools-set-sand-playing-toys-kids-fun-sand-toy-multiplayer-summer-water-beach-outdoor-toy | 248/249/271 |
29900 | diy-miniature-loft-dollhouse-kit-realistic-mini-3d-pink-wooden-house-room-toy-with-furniture-led-lights-christmas-childrens-day | 248/257/264/269 |
29901 | 3-inch-screen-retro-mini-2-handheld-game-console-built-in-168-classic-games-video-game | 299/422/493 |
29902 | funko-pop-hand-model-doll-decoration-stranger-things-eleven-with-eggos-vinyl-figure-toy-for-kids | 248/249/459 |
29903 | fire-truck-toy-cool-toy-simulation-retractable-ladder-truck-fire-truck-model-toy-inertia-fire-ladder-for-baby-kids | 248/249/251 |
29904 | silicone-soft-case-for-apple-watch-series-4-44mm-all-around-cover-thin-clear-frame | 190/204 |
29905 | black-stainless-steel-three-bead-chain-smart-watch-strap-band-for-fitbit-versa-smart-watch-replacement-wrist-band | 190/204 |
29906 | 6-pcs-set-ninja-turtles-action-figure-model-q-version-of-ninja-turtles-pvc-toys-hobby-collection-adult-children-gift-ejv-en | 248/249/459 |