{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "100.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": 49,
"rows_produced_per_join": 49,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (32849,32850,32851,32852,32853,32854,32855,32856,32857,32858,32859,32860,32861,32862,32863,32864,32865,32866,32867,32868,32869,32870,32871,32872,32873,32874,32875,32876,32877,32878,32879,32880)) 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": "90.81",
"eval_cost": "9.80",
"prefix_cost": "100.61",
"data_read_per_join": "83K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
32849 | explorer-stainless-steel-mens-two-tone-watch-s12561m-2 | 12/95/97 |
32850 | explorer-stainless-steel-mens-two-tone-rose-watch-s12561m-3 | 12/95/97 |
32851 | explorer-stainless-steel-mens-silver-watch-s12561m-4 | 12/95/97 |
32852 | explorer-stainless-steel-mens-silver-watch-s12561m-5 | 12/95/97 |
32853 | creative-mesh-band-womens-gold-watch-s12562l-1 | 12/95/96 |
32854 | creative-mesh-band-womens-gold-watch-s12562l-2 | 12/95/96 |
32855 | creative-mesh-band-womens-gold-watch-s12562l-3 | 12/95/96 |
32856 | creative-mesh-band-womens-gold-watch-s12562l-4 | 12/95/96 |
32857 | creative-mesh-band-womens-silver-watch-s12562l-5 | 12/95/96 |
32858 | creative-mesh-band-womens-silver-watch-s12562l-6 | 12/95/96 |
32859 | creative-mesh-band-womens-silver-watch-s12562l-7 | 12/95/96 |
32860 | explorer-mesh-band-womens-gold-watch-s12575l-1 | 12/95/96 |
32861 | explorer-mesh-band-womens-gold-watch-s12575l-2 | 12/95/96 |
32862 | explorer-mesh-band-womens-gold-watch-s12575l-3 | 12/95/96 |
32863 | explorer-mesh-band-womens-silver-watch-s12575l-4 | 12/95/96 |
32864 | explorer-mesh-band-womens-silver-watch-s12575l-5 | 12/95/96 |
32865 | truth-seeker-mesh-band-womens-gold-watch-s12576l-1 | 12/95/96 |
32866 | truth-seeker-mesh-band-womens-gold-watch-s12576l-2 | 12/95/96 |
32867 | truth-seeker-mesh-band-womens-blue-watch-s12576l-3 | 12/95/96 |
32868 | truth-seeker-mesh-band-womens-blue-watch-s12576l-4 | 12/95/96 |
32869 | truth-seeker-mesh-band-womens-brown-watch-s12576l-5 | 12/95/96 |
32870 | truth-seeker-mesh-band-womens-gun-metal-watch-s12576l-6 | 12/95/96 |
32871 | challenger-mesh-band-womens-gold-watch-s12577l-1 | 12/95/96 |
32872 | challenger-mesh-band-womens-blue-watch-s12577l-2 | 12/95/96 |
32873 | challenger-mesh-band-womens-blue-watch-s12577l-3 | 12/95/96 |
32874 | challenger-mesh-band-womens-brown-watch-s12577l-4 | 12/95/96 |
32875 | challenger-mesh-band-womens-black-watch-s12577l-5 | 12/95/96 |
32876 | creative-mesh-band-womens-gold-watch-s15036l-1 | 12/95/96 |
32877 | creative-mesh-band-womens-gold-watch-s15036l-2 | 12/95/96 |
32878 | creative-mesh-band-womens-rose-watch-s15036l-3 | 12/95/96 |
32879 | creative-mesh-band-mens-gold-watch-s15036m-1 | 12/95/97 |
32880 | creative-mesh-band-mens-gold-watch-s15036m-2 | 12/95/97 |