{
"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 (29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29729)) 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 |
---|---|---|
29714 | black-case-for-ipad-pro-11-2018-smart-cover-with-pencil-holder-funda-for-ipad-pro-11-inch-2018-slim-stand-shell | 301 |
29715 | tello-charger-steward-charger-hub-smart-for-dji-tello-1100mah-fpv-quadcopter-drone-battery-accessories | 299/412/565 |
29716 | shoot-2pcs-battery-and-dual-port-battery-charger-for-gopro-hero-5-black-camera-for-gopro-hero-5-accessories | 190/193 |
29717 | coffee-cup-daquan-bars-kitchen-drawing-poster-adornment-vintage-poster-retro-wall-sticker-50x36cm-office-home-decor-en | 6/159/160 |
29718 | smart-cover-protective-stand-case-for-samsung-galaxy-tab-s3-9.7-t820-t825-tablet | 190/191/419 |
29719 | webcam-cover-ultra-thin-web-camera-blocker-anti-spying-for-phone-laptop-computer-notebook-tablet-monitors-black | 299/412/413 |
29720 | 2-in-1-usb-endoscope-inspection-camera-6-led-waterproof-borescope-5m-length-for-android-and-pc | 299/412 |
29721 | oa-9x-desktop-full-motion-dual-arm-laptoptablet-pc-stand-rotate-holder-for-notebook-10-15-inch-and-all-tablet-pc-7-10-inch | 299/383 |
29722 | bm800-professional-studio-broadcasting-recording-condenser-microphone-set | 299/401 |
29723 | oa-7x-multimedia-desktop-dual-arm-25inch-lcd-monior-holder-plus-laptop-holder-stand-table-full-motion-dual-monitor-mount-arm-stand | 299/383 |
29724 | ninebot-by-segway-es2-kick-scooter-8-inch-front-and-7.5-inch-back-tires-up-to-15.5-mile-range-15.5mph-top-speed-cruise-control-mobile-app-connectivity-international-version-black | 248/257/258/261 |
29725 | cycling-bike-bicycle-soft-thick-saddle-seat-cover-cushion-pad | 207/221 |
29726 | apple-iwatch-3d-screen-protector-full-coverage-anti-scratch-high-definition-temperated-glass-for-apple-watch-42mm-series-3-2-1-black | 190/204 |
29727 | telescoping-microphone-stand-mic-clip-360-degree-stage-studio-holder-tripod | 190/195 |
29728 | mini-numeric-keypad-18keys-digital-keypad-2.4g-usb-wireless-keyboard-numpad-for-desktop-notebook-compatible | 190/420 |
29729 | 5pcs-diy-paint-roller-brush-handle-tool-flocked-edger-home-office-room-wall-runner-roller-paint-brush-set | 6/184/558 |