{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "23.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": 11,
"rows_produced_per_join": 11,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (13575,13608,13681,15525,15532,15533,15534,15818)) 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": "21.21",
"eval_cost": "2.20",
"prefix_cost": "23.41",
"data_read_per_join": "18K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
13575 | riverridge-x-frame-bathroom-wall-shelf-white | 6/7/147 |
13608 | command-refill-strips-medium-white-9-strips-pack-of-3 | 6/7/147/151 |
13681 | jacomo-for-men-by-jacomo-3.4-oz-eau-de-toilette-spray | 6/7/147/154 |
15525 | hiendurea-bathroom-accessories-solid-brass-towel-ring-antique-brass-finish-lavatory-home-decor-bath-shower-improvement-towel-racks-and-holders-space-saver-towel-bars | 6/7/147/584 |
15532 | waterpik-cf-201-cascadia-dual-mode-8-inch-showerhead-white | 6/7/147/153 |
15533 | hotelspaa-aquacare-series-shower-luxury-convenience-package-7-setting-handheld-shower-head-with-patented-on-off-pause-switch-extra-long-hose-and-bonus-low-reach-bracket | 6/7/147/153 |
15534 | allomn-cloth-diaper-sprayer-premium-stainless-steel-handheld-toilet-bidet-sprayer-kit-with-t-valve-metal-hose-mounting-accessories-for-toilet-seat-cleaning-bathroom-floors-one-spray | 6/7/147/584 |
15818 | white-plain-weave-striped-tea-towel-20x28-red-pack-of-3 | 6/7/147/148 |