{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "39.81"
},
"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": 17,
"rows_produced_per_join": 17,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (30758,30760,30761,30762,30766,30773,30775,30803,10387,10388,10392,10395,10396,10397,10398,10399)) 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": "36.41",
"eval_cost": "3.40",
"prefix_cost": "39.81",
"data_read_per_join": "28K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
10387 | xiaomi-smart-watch-silicone-band-for-android-and-ios-black-amazfit-en | 190/206 |
10388 | english-version-original-xiaomi-huami-watch-amazfit-pace-bluetooth-4.0-sports-smart-watch-zirconia-ceramics-heart-rate-monitor-and-gps | 190/206 |
10392 | xiaomi-mi-bluetooth-speaker-basic-2-bluetooth-4.2-white-en | 190/424 |
10395 | xiaomi-smart-watch-silicone-band-for-android-and-ios-black-a1619-en | 190/204 |
10396 | xiaomi-amazfit-stratos-pace-2-smartwatch-with-heart-rate-activity-tracking-water-resistance-black-en-2 | 190/206 |
10397 | xiaomi-amazfit-bip-smartwatch-youth-edition-obsidian-black-en | 190/206 |
10398 | xiaomi-zbw4353ty-xiaomi-mi-headphones-comfort-white-en | 190/200 |
10399 | xiaomi-15703headphonesblack | 190/386 |
30758 | bluetooth-wireless-earphone-sabbat-x12-pro-charging-box-mini-invisible-earphones-bt5.0-stereo-surround-twins | 190/201 |
30760 | dealmux-tpu-gel-soft-case-skin-cover-pouch-box-for-bose-soundlink-mini-bluetoo-black | 190/424 |
30761 | milanese-loop-for-apple-watch-40mm-38mm-stainless-steel-alloy-replacement-watch-band-for-iwatch-series-4-3-2-1-vintage-gold | 190/204 |
30762 | milanese-loop-for-apple-watch-44mm-42mm-stainless-steel-alloy-replacement-watch-band-for-iwatch-series-4-3-2-1-silver | 190/204 |
30766 | folio-cover-for-samsung-galaxy-tab-s5e-2019-t720-725-released-galaxy-tab-s5e-10.5-2019-tablet-funda-slim-case | 190/191/419 |
30773 | dux-ducis-samsung-galaxy-tab-a-10.1-case-slim-folding-cover-with-auto-wake-sleep-for-samsung-galaxy-tab-a-10.1-2019-model-sm-t510-sm-t515-blue | 190/191/419 |
30775 | folio-cover-for-samsung-galaxy-tab-s5e-2019-t720-725-released-galaxy-tab-s5e-10.5-2019-tablet-funda-slim-case-en | 190/191/419 |
30803 | slim-folio-cover-case-for-samsung-galaxy-tab-s5e-2019-t720-725-new-released-galaxy-tab-s5e-10.5-2019-tablet-funda-en | 190/191/419 |