{
"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 (29794,29795,29796,29797,29798,29799,29800,29801,29802,29804,29805,29806,29807,29808,29809,29810)) 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 |
---|---|---|
29794 | qi-wireless-charging-headset-case-for-iphone-airpods-case-earphone-polycarbonate-back-cover-for-airpods-portable-charger | 190/193 |
29795 | double-pet-dog-bowl-stainless-steel-pet-bowl-bamboo-bottom-food-water-dual-use-feeding-dish | 6/367/368 |
29796 | universal-tablet-stand-holder-for-ipad-2-3-4-air-mini-for-samsung-lenovo-lazy-bed-desk-mount-for-6-11-inch-tablet-pc-en | 190/195 |
29797 | sades-comfort-mousepad-gaming-mouse-mice-pad-mat-for-optical-mouse | 299/383/560 |
29798 | practical-floating-magnetic-brush-aquarium-fish-tank-glass-algae-scraper-cleaner-aquarium-window-cleaning-magnets-brush-cleaner | 6/367/370 |
29799 | silent-electric-ultraviolet-mosquito-fly-bug-insect-zapper-trap-killer-lamp-black | 6/168/529 |
29800 | usb-charging-data-cradle-dock-for-fitbit-versa-watch-smart-accessories | 190/204 |
29801 | dux-ducis-pu-leather-case-for-ipad-pro-10.5-magnet-stand-smart-cover-for-ipad-pro-10.5-inch-2018-with-pencil-holder | 190/191/419 |
29802 | 15mm-nbr-non-slip-yoga-mat-fitness-pilates | 207/233 |
29804 | fitness-body-building-electric-muscle-stimulator-abdominal-exercise-machine-ems-trainer-slimming-belt | 207/513 |
29805 | 5kg-1g-abs-digital-kitchen-bowl-scale-electronic-weighing-scale-household-scales-tool-for-milk-or-liquid-with-lcd-display | 6/438/454 |
29806 | orico-duk-10p-120w-universal-usb-10-ports-power-charging-station | 190/193 |
29807 | pets-game-toy-cylinder-design-sisal-scratching-post-scratch-board-climbing-frame-toy-for-cat-pet | 6/367/369 |
29808 | u3-coolcold-height-adjustable-aluminum-alloy-laptop-cooling-stand-360-rotation-ergonomic-10-17-inch-notebook-holder | 299/383 |
29809 | pilates-yoga-stretch-resistance-exercise-band-tube-workout-1.2m-blue | 207/233 |
29810 | razer-gaming-mouse-pad-700x300x3mm-locking-edge-mouse-mat-speed-version-mouse-pad | 299/383/560 |