{
"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 (31009,31010,31011,31012,31013,31014,31015,31016,31017,31018,31019,31020,31021,31022,31023,31024)) 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 |
---|---|---|
31009 | wood-rattan-twine-ball-lights-table-lamp-room-home-art-decor-desk-light | 6/159/166 |
31010 | 4pcs-sea-style-non-slip-toilet-polyester-cover-mat-set-bathroom-shower-curtain-en | 6/7/147/150 |
31011 | acid-reflux-foam-bed-wedge-pillow-leg-elevation-back-lumbar-support-cushions | 6/7/61/64 |
31012 | center-offset-marking-tool-for-woodworking-carpentry-joinery-worksite | 6/184/186 |
31013 | 600ml-sport-cycling-mist-spray-water-gym-beach-bottle-leak-proof-drinking-cup | 207/513 |
31014 | leather-passport-holder-wallet-cover-case-rfid-blocking-travel-wallet | 12/50/77/82 |
31015 | gooseneck-304-stainless-steel-pour-over-coffee-kettle-hand-drip-tea-pot | 6/168/177 |
31016 | useful-double-side-flat-mop-hands-free-washable-mop-home-cleaning-tool-lazy | 6/445/446/450 |
31017 | clothes-hangers-for-closet-10pcs-metal-clips-coat-skirt-dress-blouse-bulk-shirt | 6/184/189 |
31018 | 8pcs-women-for-whom-you-loved-pretty-red-rose-nice-girls-unique-gift-for-mom | 6/596 |
31019 | natural-crystal-point-healing-obelisk-wand-elixir-quartz-crystal-water-bottle | 6/438/454 |
31020 | wireless-remote-floating-thermometer-swimming-pool-waterproof-hot-tub-pond-spa | 207/217 |
31021 | 3in1-aquarium-internal-filter-oxygen-submersible-water-pump-for-fish-tank-pond | 301 |
31022 | 6pc-set-home-decorative-pillowcase-cotton-linen-sofa-cushion-throw-pillow-cover-en-4 | 6/7/61/64 |
31023 | 10pcs-diamond-tool-drill-bit-hole-saw-set-for-glass-ceramic-marble-6-50mm-pro | 6/184/186 |
31024 | diy-potato-grow-planter-pe-cloth-planting-container-bag-thicken-garden-pot-en | 6/184/187 |