{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "41.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": 18,
"rows_produced_per_join": 18,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (29859,29860,29861,29862,29863,29864,29865,29866,29867,29868,29869,29870,29871,29872,29873,29874)) 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": "37.61",
"eval_cost": "3.60",
"prefix_cost": "41.21",
"data_read_per_join": "30K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
29859 | mavic-pro-platinum-air-remote-controller-signal-booster-fold-antenna-signal-enhance-specular-surface-with-film-protection | 299 |
29860 | 16mm-quick-release-pin-watch-band-for-huawei-talkband-b3-stainless-steel-loop-milanese-strap-magnetic-button | 190/204 |
29861 | giyo-black-breaking-wind-cycling-gloves-half-finger-anti-slip-bicycle-mittens-racing-road-bike-glove-mtb-biciclet-guantes-ciclismo-l | 207/513/516 |
29862 | wood-hd-mobile-phone-screen-3d-video-amplifier-folding-stand-magnifier | 190/195 |
29863 | pipeline-tunnel-blocks-diy-bricks-toys-kids-educational-toy-pipe-blocks-training-toys-child-gift-family-board-game | 248/249/253/532 |
29864 | for-dji-tello-drone-usb-battery-charger-hub-rc-intelligent-charging-for-dji-tello | 190/193 |
29865 | children-cute-lovely-totoro-doll-kids-new-cartoon-plush-doll-toy | 248/249/254/509 |
29866 | women-girls-pinching-rabbit-ears-move-airbag-magnet-cap-plush-cute-hat-funny-toys | 12/50/84/88 |
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 |
29870 | adjustable-150cm-kids-basketball-back-board-stand-and-hoop-set-for-children-gift | 207/220 |
29871 | 2-pairs-dji-tello-propellers-spare-parts-cw-ccw-quick-release-props-replacement-colorful-blade | 299/412/565 |
29872 | 40-pcs-set-led-light-bar-decal-skin-stickers-for-ps4-playstation-4-controller | 6/159/160 |
29873 | building-blocks-clock-childrens-educational-toys-digital-animals-clock-puzzle-toys | 248/249/256 |
29874 | education-childrens-toy-kart-assembly-model-car-boy-and-girls-fun-toys-disassemble-toys | 248/249/251 |