{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "44.01"
},
"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": 20,
"rows_produced_per_join": 20,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (14674,14675,14676,14677,14678,14679,14680,14681,14682,14683,14684,14685,14686,14687,14688,14689)) 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": "40.01",
"eval_cost": "4.00",
"prefix_cost": "44.01",
"data_read_per_join": "33K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
14674 | gear4-d3o-piccadilly-case-for-moto-e4-black | 190/191/418 |
14675 | gear4-d3o-piccadilly-case-for-moto-e4-plus-black | 190/191/418 |
14676 | gear4-d3o-victoria-case-for-iphone-6-and-8-compatible-teal | 190/191/418 |
14677 | gear4-d3o-victoria-case-for-iphone-6-and-8-compatible-blue-swirl | 190/191/418 |
14678 | gear4-d3o-victoria-case-for-iphone-6-and-8-plus-compatible-teal | 190/191/418 |
14679 | iphone-6s-case-tozo-shiny-series-bling-crystal-ultra-thin-sparkle-premium-3-layer-hybrid-semi-transparent-lightweight-exact-fit-soft-case-for-iphone-6-2014-6s-2015-4.7-pink | 190/191/418 |
14680 | reiko-vertical-pouch-iphone-4g-plus-black-cell-phone-with-cover-4.5x2.4x0.4-inches-vp385b-iphone4plbk | 190/191/418 |
14681 | for-lg-v20-zizo-ion-single-layered-hybrid-cover-w-tempered-glass-screen-protector-retail-packaging-black-smoke | 190/192 |
14682 | simple-cell-blackberry-silicone-skin-for-blackberry-pearl-9100-turquoise-hexagon | 190/191/418 |
14683 | whiteoak-original-oneplus-karbon-kevlar-styleswap-back-cover-case-for-oneplus-two-2-kevlar | 190/191/418 |
14684 | hr-wireless-cell-phone-case-for-lg-g6-q-gold-pc-black-tpu | 190/191 |
14685 | hr-wireless-cell-phone-case-for-zte-avid-trio-plus-blackred | 190/191 |
14686 | mophie-lightweight-and-compact-mobile-protective-battery-case-juice-pack-reserve-for-iphone-6-6s-blue | 190/191 |
14687 | for-lg-v20-zizo-ion-single-layered-hybrid-cover-w-customized-tempered-glass-screen-protector-retail-packaging-silver-clear | 190/192 |
14688 | for-iphone-7-plus-zizo-ion-single-layered-hybrid-cover-w-tempered-glass-screen-protector-retail-packaging-gold-clear | 190/191 |
14689 | htc-hard-shell-for-htc-desire-610-translucent | 190/191 |