{
"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 (10464,10465,10466,10467,10468,10469,10470,10471,10473,10474,10476,10477,10478,10479,10480,10481)) 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 |
---|---|---|
10464 | xiaomi-362887in-ear-headphones-with-piston-basic-black | 190/386 |
10465 | xiaomi-mi-in-ear-headphones-basic-edition-blue | 190/386 |
10466 | xiaomi-mi-air-purifier-2s-sterilizer-addition-to-formaldehyde-purifiers-air-cleaning-intelligent-household-hepa-filter | 6/184/378 |
10467 | xiaomi-mi-air-purifier-2s-sterilizer-addition-to-formaldehyde-cleaning-intelligent-household-hepa-filter-smart-app-wifi-rc | 6/184/378 |
10468 | xiaomi-bluetooth-temperature-humidity-detector-with-lcd-display-for-smart-mi-home-kit | 2/432 |
10469 | xiaomi-vxn4160gl-power-bank-mi-10000mah-pro-grey | 190/194 |
10470 | xiaomi-imi-cmsxj01c-home-security-camera-1080p-hd-with-infrared-night-vision-support-white | 299/389 |
10471 | xiaomi-car-charger-qc3.0-car-charger-5v-3a-dual-usb-quick-charger-9v-2a-12v-1.5a-mi-quick-car-charger-czcdq02zm | 190/199 |
10473 | xiaomi-drone-4k-version | 248/249/535 |
10474 | xiaomi-mijia-soocas-h3-electric-quick-hair-dryer-1800w-with-double-negative-ions | 2/11/523 |
10476 | xiaomi-youth-wireless-bluetooth-earphone-noise-cancelling-waterproof-sports-headphone-with-mems-mic | 190/201 |
10477 | original-xiaomi-mijia-led-ceiling-light-lamp-ip60-dustproof-wifi-and-bt-wireless-smart-mi-home-app-remote-control | 207/469/470/473 |
10478 | xiaomi-mijia-photo-printer-wireless-remote-connection-white | 299/559 |
10479 | xiaomi-smart-ultra-short-range-laser-projector-150-inch-intelligent-home-application-tv-international-version-white | 299/431 |
10480 | xiaomi-mi-portable-bluetooth-wireless-speaker-bluetooth-4.0-mini-speaker-gold | 190/424 |
10481 | xiaomi-vr-all-in-one-super-player-edition-64g | 190/429 |