{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "45.41"
},
"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": 21,
"rows_produced_per_join": 21,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (30702,30703,30704,30705,30706,30707,30708,30709,30710,30711,30712,30713,30714,30715,30716,30717)) 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": "41.21",
"eval_cost": "4.20",
"prefix_cost": "45.41",
"data_read_per_join": "35K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
30702 | sport-hifi-in-ear-wireless-cord-free-headphone-for-samsung-gear-iconx-sm-r150-bluetooth-headset | 190/201 |
30703 | hand-strap-hanging-wrist-band-sling-lanyard-safety-belt-buckle-for-dji-osmo-pocket-gimbal-camera | 301 |
30704 | fitbit-versa-protector-case-cover-full-frame-screen-protector-soft-slim-tpu-shell-case-flexible-anti-scratch-bumper-cover-black | 190/204 |
30705 | pgytech-dji-osmo-pocket-foldable-phone-holder-plus-bracket-set-of-dji-osmo-pocket-mount-clip-adapter-accessories | 299/412/413 |
30706 | movable-up-8t-aluminum-7-20-inch-laptop-floor-stand-height-adjustable-bedside-lapdesk-sofa-desk-for-tablet-pc-notebook-tea-table | 299/383 |
30707 | for-lenovo-tab-m10-case-10.1inch-tb-x605f-tb-x605l-slim-pu-leather-magnetic-shockproof-hard-cover | 190/191/419 |
30708 | soft-silicone-shockproof-cover-with-carabiner-for-huawei-honor-flypods-flypods-pro-earphone-protector-case | 190/201 |
30709 | ulanzi-op-5-large-wide-angle-lens-for-dji-osmo-pocket-professional-hd-magnetic-structure-lens-osmo-pocket-accessories | 299/412/413 |
30710 | sunnylife-adjustable-mcuv-cpl-nd4-nd8-nd16-nd32-lens-filter-set-for-dji-osmo-pocket-handheld-gimbal-camera | 299/412/413 |
30711 | black-leather-case-for-huawei-mediapad-m5-lite-10inch-tablet-stand-smart-cover-auto-sleep-wake | 190/191/419 |
30712 | for-huawei-flypods-case-leather-cases-for-huavei-aipods-wireless-bluetooth-earphone-cover-for-honor-airpods-fly-pod | 190/201 |
30713 | films-dust-guard-for-apple-airpods-2-pieces-18k-gold-plating-protect-airpods-from-iron-metal-shavings | 190/201 |
30714 | metal-dust-guard-for-apple-airpods-case-cover-accessory-protective-sticker-skin-protecting-airpods-from-iron-metal-shavings | 190/201 |
30715 | mifo-o5-tws-earbuds-true-wireless-earphones-dynamic-drivers-ipx-7-100-hours-playtime | 190/201 |
30716 | for-huawei-flypods-case-leather-cases-for-huavei-aipods-wireless-bluetooth-earphone-cover-for-honor-airpods-fly-pod-en | 190/201 |
30717 | multicolor-stripes-mens-tie-set-necktie-cufflinks-and-tie-clips-design-for-male | 248/302/330/352/356 |