{
"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 (31069,31070,31071,31072,31074,31077,31079,31080,31081,31082,31083,31086,31087,31088,31089,31091)) 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 |
---|---|---|
31069 | colourful-mini-plastic-flower-pot-succulent-plant-flowerpot-home-office-decor | 6/159/166 |
31070 | aquarium-jellyfish-decoration-glowing-effect-fish-tank-artificial-ornament | 6/367/370 |
31071 | dog-claw-towel-dog-cat-cleaning-towel-pet-dirty-paw-carpet-high-suction-towel | 6/367/368 |
31072 | 58-inch-heavy-duty-waterproof-bbq-cover-gas-barbecue-grill-for-patio-protector | 6/425/426 |
31074 | 6pcs-reusable-gas-range-stove-top-burner-protector-liner-cover-for-cleaning | 6/168/183 |
31077 | 300-ml-wood-aroma-humidifier-for-office-home-living-room-bedroom-en | 6/159/570 |
31079 | green-eco-friendly-waterproof-grafting-tape-graft-membrane-garden-bind-belt-2018 | 6/184/187 |
31080 | 5oz-stainless-steel-pocket-hip-flask-alcohol-whiskey-liquor-screw-cap | 6/438 |
31081 | bidet-spray-chrome-hygienic-toilet-shower-head-hose-set-muslim | 6/7/147/153 |
31082 | cake-decorating-turntable-rotating-revolving-icing-kitchen-display-stand-28cm | 6/168/183 |
31083 | 2pcs-pe-foam-3d-self-adhesive-wall-stickers-decor-tile-waterproof-wall-stickers | 6/159/160 |
31086 | non-stick-plastic-sushi-roll-mat-made-kitchen-diy-mould-roller-mat-new | 6/438/454/455 |
31087 | foldable-storage-bag-clothes-blanket-quilt-closet-sweater-organizer-box-pouch | 6/184/189 |
31088 | himalayan-natural-usb-plug-crystal-rock-night-light-salt-lamp-ionic-air-purifier | 6/184/378 |
31089 | spiral-vegetable-fruit-slicer-cutter-grater-twister-peeler-kitchen-gadgets-tools | 6/168/183 |
31091 | mini-heater-mini-heater-mini-electric-heater-electric-heater-electric-fan | 6/168/179 |