{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "48.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": 23,
"rows_produced_per_join": 23,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (31121,31122,31123,31124,31125,31126,31127,31128,31129,31130,31131,31132,31133,31134,31135,31136)) 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": "43.61",
"eval_cost": "4.60",
"prefix_cost": "48.21",
"data_read_per_join": "38K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
31121 | universal-waterproof-transparent-protective-luggage-suitcase-cover-case-travel | 12/555 |
31122 | foldable-potty-training-seat-baby-travel-toilet-potty-seat-covers-non-slip-pads | 6/7/147/154 |
31123 | aquarium-fish-tank-activated-carbon-charcoal-purify-water-quality-filter-media | 6/367/370 |
31124 | rose-gold-pink-cushion-cover-square-pillowcase-home-decoratio | 6/7/61/64 |
31125 | 6pc-set-home-decorative-pillowcase-cotton-linen-sofa-cushion-throw-pillow-cover-en-2 | 6/7/61/64 |
31126 | 10pcs-acoustic-foam-panel-sound-stop-absorption-sponge-studio-ktv-soundproof | 299/401/576 |
31127 | simulation-yellow-white-tiger-plush-toy-pillow-comfort-decorative-pillow | 248/249/254 |
31128 | devil-tooth-fangs-caps-zombie-vampire-luminous-dentures-halloween-party-props | 6/596 |
31129 | electric-mosquito-swatter-tennis-bat-racket-insect-fly-bug-wasp-swatter | 6/168/529 |
31130 | insulated-lunch-box-soft-cooler-bag-waterproof-thermal-work-school-picnic-bento | 6/438/476/477 |
31131 | soft-furry-sloth-pillow-cushion-stuffed-plush-toy-gifts-for-kids-home-sofa-deco | 248/249/254/507 |
31132 | 485-pcs-heat-shrink-tubing-tube-assortment-wire-cable-insulation-sleeving-kit | 299 |
31133 | xiaomi-mijia-anti-blue-ray-goggles-pro-transparent-white | 12/604/91/94 |
31134 | 6-pcs-underwear-aid-bra-socks-lingerie-laundry-washing-machine-mesh-bag | 6/184/189 |
31135 | 10-pcs-anti-mosquito-insect-repellent-wrist-hair-band-bracelet-camping-outdoor | 248/302/303/323/329 |
31136 | for-women-kids-men-insulated-canvas-box-tote-bag-thermal-cooler-food-lunch-bags | 6/438/476/477 |