{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "45.41"
},
"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": 21,
"rows_produced_per_join": 21,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (14690,14691,14692,14693,14694,14695,14696,14697,14698,14699,14700,14701,14702,14703,14704,14705)) 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": "41.21",
"eval_cost": "4.20",
"prefix_cost": "45.41",
"data_read_per_join": "35K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
14690 | trianium-holster-case-duranium-series-designed-for-iphone-xs-max-w-rotating-belt-clip-kickstand-heavy-duty-protection-scratch-resistant-shock-absorption-for-iphone-xs-max-2018-gunmetal | 190/191 |
14691 | igadgitz-black-silicone-skin-case-cover-for-apple-ipod-video-30gb-5th-6th-generation-screen-protector | 190/191 |
14692 | vangoddy-neoprene-armband-case-for-smartphones-black | 190/204 |
14693 | brics-x-travel-roller-case-55-cm-black-nero | 12/555 |
14694 | gear4-d3o-battersea-case-for-samsung-galaxy-note-8-black | 190/191 |
14695 | gear4-d3o-piccadilly-case-for-samsung-galaxy-s9-black | 190/191 |
14696 | gear4-d3o-piccadilly-case-for-samsung-galaxy-s9-blue | 190/191 |
14697 | gear4-d3o-battersea-case-for-samsung-galaxy-s9-black | 190/191 |
14698 | gear4-d3o-oxford-case-for-samsung-galaxy-s9-black | 190/191/418 |
14699 | gear4-d3o-oxford-case-for-samsung-galaxy-note-8-black | 190/191 |
14700 | gear4-d3o-oxford-case-for-samsung-galaxy-note-8-blue | 190/191 |
14701 | for-samsung-galaxy-s7-edge-g935-bolt-cover-w-kickstand-holster-and-lanyard-orange-black-bolt-no-glass | 190/191 |
14702 | for-motorola-moto-z-bolt-cover-w-kickstand-holster-tempered-glass-screen-protector-lanyard-black-black-bolt | 190/191 |
14703 | motorola-moto-g5-plus-32gb-xt1681-5.2-dual-sim-unlocked-android-7.0-grey-international-model-no-warranty | 190 |
14704 | oneplus-3t-a3010-gray-6gb-ram-64-gb-5.5-inch-international-version-no-warranty | 190 |
14705 | lg-flip-phone-senior-unlocked-gsm-only-2g-g360-dual-sim-duos-mp3-camera-big-buttons-facebook-twitter-lcd-3.0-bluetooth-factory-desbloqueados-red | 190 |