{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "42.61"
},
"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": 19,
"rows_produced_per_join": 19,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (30734,30735,30736,30737,30738,30739,30740,30741,30742,30743,30744,30745,30746,30747,30748,30749)) 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": "38.81",
"eval_cost": "3.80",
"prefix_cost": "42.61",
"data_read_per_join": "32K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
30734 | smart-watchband-stainless-steel-bracelet-quick-replacement-watch-band-strap-for-huawei-watch-gt-silver | 190/204 |
30735 | smart-watchband-silicone-sports-replacement-watch-band-wriststrap-for-huawei-watch-gt-smartwatch-dark-blue | 190/204 |
30736 | case-cover-for-samsung-galaxy-tab-a-10.1-2019-pouch-sleeve-bag-shell-for-samsung-tab-sm-t510-sm-t515-10.1-inch-tablet | 190/191/419 |
30737 | airpods-accessories-set-silicone-anti-lost-protective-cover-skin-case-for-apple-airpods-2-charging-case-purple | 190/201 |
30738 | smart-watchband-silicone-sports-replacement-watch-band-wriststrap-for-huawei-watch-gt-smartwatch-white | 190/204 |
30739 | airpods-accessories-set-silicone-anti-lost-protective-cover-skin-case-for-apple-airpods-2-charging-case-blue | 190/201 |
30740 | smart-watchband-replacement-nylon-sport-loop-wrist-band-strap-for-huawei-watch-gt-smartwatch-green | 190/204 |
30741 | bicycle-handlebar-mount-kit-for-garmin-forerunner-230-235-305-gps-universal-watch-holder-stand-for-tomtom-for-suunto-watches | 300/572 |
30742 | remote-control-silicone-protector-case-cover-skin-for-logitech-harmony-650-700 | 299/431 |
30743 | dji-mavic-2-smart-controller-carrying-case-dji-drone-remote-controller-with-screen-accessories-storage-handbag-nylon-sling-bag | 299/412/413 |
30744 | nylon-sport-band-for-apple-watch-40mm-38mm-soft-replacement-strap-for-iwatch-series-4-3-2-1-nectarine | 190/204 |
30745 | leather-case-for-samsung-galaxy-tab-s5e-tablet-for-galaxy-tab-s5e-10.5-sm-t720-sm-t725-cover-case | 190/191/419 |
30746 | logitech-g502-proteus-rgb-spectrum-tunable-gaming-mouse-black-en-3 | 299/383/560 |
30747 | logitech-g502-proteus-spectrum-rgb-tunable-gaming-mouse-12-000-dpi-on-the-fly-dpi-shifting-black | 299/383/560 |
30748 | inflatable-baby-swimming-float-ring-foonee-children-waist-adjustable-baby-pool-float-ring-toys-u-shape-underarm-design-double-airbags-swimming-laps-opening-float-lifebuoy-for-toddlers-3-36-months | 248/257/264/266 |
30749 | logitech-g502-proteus-rgb-spectrum-tunable-gaming-mouse-black-en-en | 299/383/560 |