{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "65.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": 31,
"rows_produced_per_join": 31,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (47544,47645,47646,47649,47651,47652,47656,47660,47676,47677,47678,47686,47690,47692,47693,47697,47698,47699,47700,47701,47703,47771)) 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": "59.21",
"eval_cost": "6.20",
"prefix_cost": "65.41",
"data_read_per_join": "52K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
47544 | bestway-1.22mx1.22m-swan-41123 | 248/257/264/272 |
47645 | bestway-60x42-jumping-tube-gym-52056 | 248/257 |
47646 | bestway-84x48x54-soccer-net-52058 | 248/257 |
47649 | bestway-1.37m-x-66cm-water-polo-frame-52123 | 248/257 |
47651 | bestway-2.44m-x-64cm-volleyball-set-52133 | 248/257 |
47652 | bestway-36-bop-bags-52152 | 248/257 |
47656 | bestway-25x13x13-baby-step-roller-52176 | 248/257 |
47660 | bestway-52x31x27-helicopter-ball-pit-52183 | 248/257 |
47676 | bestway-18x5.49m-h2ogo-slide-n-splash-bowling-52213 | 248/257 |
47677 | bestway-2.54mx1.12m-x-1.30m-soccer-splash-set-52215 | 248/257 |
47678 | bestway-h2ogo-91cm-x-63cm-x-1.63m-hydro-hoopz-52216e | 248/257 |
47686 | bestway-1.30mx33cmx33cm-sticks-52227e | 248/257 |
47690 | bestway-1.32mx1.32mx23cm-freindly-animals-mat-52240 | 248/257 |
47692 | bestway-21cm-x-10cm-catch-and-throw-set-52244 | 248/257 |
47693 | bestway-h2ogo-18ft-5.49m-slime-blast-slide-52251 | 248/257 |
47697 | bestway-1.42mx1.37mx1.14m-octopus-bouncer-52267 | 248/257 |
47698 | bestway-1.22mx84cmx84cm-scoops-n-smile-icecream-52268 | 248/257 |
47699 | bestway-1.75mx1.73mx1.37m-hot-air-balloon-bouncr-52269 | 248/257 |
47700 | bestway-91cmx91cmx89cm-candyville-playtime-pool-52270 | 248/257 |
47701 | bestway-1.93m-x-1.5m-x-89cm-play-center-53026 | 248/257 |
47703 | bestway-1.9m-x-1.4m-x-96cm-pirate-play-pool-53041 | 248/257 |
47771 | bestway-1.12mx90cm-kids-ball-pit-and-play-land-68080 | 248/257 |