{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "82.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": 36,
"rows_produced_per_join": 36,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (32817,32818,32819,32820,32821,32822,32823,32824,32825,32826,32827,32828,32829,32830,32831,32832,32833,32834,32835,32836,32837,32838,32839,32840,32841,32842,32843,32844,32845,32846,32847,32848)) 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": "75.21",
"eval_cost": "7.20",
"prefix_cost": "82.41",
"data_read_per_join": "61K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
32817 | explorer-stainless-steel-womens-two-tone-watch-s12535l-3 | 12/95/96 |
32818 | explorer-stainless-steel-womens-silver-watch-s12535l-4 | 12/95/96 |
32819 | multidimensional-stainless-steel-womens-gold-watch-s12541l-1 | 12/95/96 |
32820 | multidimensional-stainless-steel-womens-silver-watch-s12541l-2 | 12/95/96 |
32821 | truth-seeker-leather-mens-black-watch-s12551m-1 | 12/95/97 |
32822 | truth-seeker-leather-mens-black-watch-s12551m-2 | 12/95/97 |
32823 | truth-seeker-leather-mens-black-watch-s12551m-3 | 12/95/97 |
32824 | truth-seeker-leather-mens-black-watch-s12551m-4 | 12/95/97 |
32825 | creative-stainless-steel-womens-gold-watch-s12553l-1 | 12/95/96 |
32826 | creative-stainless-steel-womens-two-tone-watch-s12553l-2 | 12/95/96 |
32827 | creative-stainless-steel-womens-two-tone-watch-s12553l-3 | 12/95/96 |
32828 | creative-stainless-steel-womens-silver-watch-s12553l-4 | 12/95/96 |
32829 | explorer-stainless-steel-womens-gold-watch-s12554l-1 | 12/95/96 |
32830 | explorer-stainless-steel-womens-gold-watch-s12554l-2 | 12/95/96 |
32831 | explorer-stainless-steel-womens-two-tone-watch-s12554l-3 | 12/95/96 |
32832 | explorer-stainless-steel-womens-two-tone-watch-s12554l-4 | 12/95/96 |
32833 | explorer-stainless-steel-womens-two-tone-rose-watch-s12554l-5 | 12/95/96 |
32834 | multidimensional-mesh-band-mens-silver-watch-s12557m-1 | 12/95/97 |
32835 | multidimensional-mesh-band-mens-silver-watch-s12557m-2 | 12/95/97 |
32836 | multidimensional-mesh-band-mens-silver-watch-s12557m-3 | 12/95/97 |
32837 | multidimensional-mesh-band-mens-silver-watch-s12557m-4 | 12/95/97 |
32838 | multidimensional-mesh-band-mens-silver-watch-s12557m-5 | 12/95/97 |
32839 | multidimensional-mesh-band-mens-silver-watch-s12557m-6 | 12/95/97 |
32840 | truth-seeker-mesh-band-mens-gold-watch-s12560m-1 | 12/95/97 |
32841 | truth-seeker-mesh-band-mens-gold-watch-s12560m-2 | 12/95/97 |
32842 | truth-seeker-mesh-band-mens-gold-watch-s12560m-3 | 12/95/97 |
32843 | truth-seeker-mesh-band-mens-gold-watch-s12560m-4 | 12/95/97 |
32844 | truth-seeker-mesh-band-mens-rose-gold-watch-s12560m-5 | 12/95/97 |
32845 | truth-seeker-mesh-band-mens-rose-gold-watch-s12560m-6 | 12/95/97 |
32846 | truth-seeker-mesh-band-mens-silver-watch-s12560m-7 | 12/95/97 |
32847 | truth-seeker-mesh-band-mens-silver-watch-s12560m-9 | 12/95/97 |
32848 | explorer-stainless-steel-mens-two-tone-watch-s12561m-1 | 12/95/97 |