{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "45.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 (5878,5879,5880,5881,5882,5883,5884,5885,5886,5887,5888,5889,5890,5891,5892,5893,5894,5895,5896)) 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.81",
"eval_cost": "3.80",
"prefix_cost": "45.61",
"data_read_per_join": "32K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
5878 | adidas-grip-case-for-iphone-8-7-6s-6 | 190/191/418 |
5879 | adidas-grip-case-for-iphone-8-7-6s-6-plus | 190/191/418 |
5880 | adidas-grip-case-black-for-iphone-xs-x | 190/191/418 |
5881 | adidas-grip-case-sesame-for-iphone-xs-x | 190/191/418 |
5882 | adidas-grip-case-mystery-blue-for-iphone-xs-x | 190/191/418 |
5883 | adidas-folio-grip-case-for-iphone-xs-x | 190/191/418 |
5884 | adidas-iphone-xs-x-original-trefoil-case-clear-flowe | 190/191/418 |
5885 | adidas-iphone-xs-x-grip-case-black | 190/191/418 |
5886 | adidas-folio-grip-case-for-iphone-xs-x-en | 190/191/418 |
5887 | adidas-iphone-xs-max-original-trefoil-case-black | 190/191/418 |
5888 | adidas-3-stripes-case-for-iphone-xs-max-blue | 190/191/418 |
5889 | adidas-iphone-xs-x-3-stripes-case-gazelle-pink | 190/191/418 |
5890 | adidas-iphone-xr-3-stripes-case-gazelle-pink | 190/191/418 |
5891 | adidas-3-stripes-case-for-iphone-xs-max | 190/191/418 |
5892 | adidas-iphone-xr-original-trefoil-case-clear-flowers | 190/191/418 |
5893 | adidas-iphone-xr-grip-case-blue | 190/191/418 |
5894 | adidas-iphone-xs-max-grip-case-blue | 190/191/418 |
5895 | adidas-originals-hard-case-for-iphone-6-6s | 190/191/418 |
5896 | adidas-originals-hard-case-for-iphone-6-6s-silver | 190/191/418 |