{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "72.01"
},
"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": 30,
"rows_produced_per_join": 30,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (16317,16318,16319,16320,16321,16322,16323,16324,16325,16326,16327,16328,16329,16331,16332,16333,16334,16335,16336,16337,16338,16339,16340,16341,16342,16343,16344,16345,16346,16347)) 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": "66.01",
"eval_cost": "6.00",
"prefix_cost": "72.01",
"data_read_per_join": "50K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
16317 | lego-creator-ocean-explorer-31045 | 248/249/252 |
16318 | lego-friends-stephanies-bakery-stand-set-30113-bagged | 248/249/252 |
16319 | lego-chima-nest-dive-70105 | 248/249/252 |
16320 | lego-lone-ranger-tontos-campfire-30261 | 248/249/252 |
16321 | playmobil-tactical-unit-car-playset | 248/249/251 |
16322 | lego-minifigure-collection-lego-movie-series-loose-wild-west-wyldstyle | 248/249/250/499 |
16323 | legoa-compatible-x-large-dark-bluish-gray-15.75-x-15.75-50-x-50-studs-building-base-plates | 248/249/252 |
16324 | paw-patrol-roll-patrol-rubbles-mountain-rescue-track-set | 248/249/252 |
16325 | disney-frozen-olaf-snow-foam-set | 248/249/255 |
16326 | meccano-multimodels-flight-adventure-10-model-set | 248/249/251 |
16327 | n-code-80-nickel-silver-19-radius-snap-track-6-atlas-trains | 248/249/250/496 |
16328 | paw-patrol-adventure-game | 248/249/253/532 |
16329 | melissa-and-doug-deluxe-magnetic-responsibility-chart. | 248/249/256 |
16331 | toysmith-cardinal-thomas-and-friends-pop-up-game | 248/249/253/489 |
16332 | chinese-checkers-7-inch | 248/249/253/489 |
16333 | catan-traders-and-barbarians-5-6-player-extension | 248/249/253/489 |
16334 | stack-it-peg-game-with-board-occupational-therapy-autism-fine-motor-skills | 248/249/253/489 |
16335 | wholesale-chess-archer-chess-set-combo-forest-green | 248/249/253/489 |
16336 | pandemic-the-cure | 248/249/253/489 |
16337 | hotel-tycoon | 248/249/253/489 |
16338 | spider-man-card-games-old-vulture-go-spidey-spider-8s-spider-match | 248/249/253/489 |
16339 | set-the-family-game-of-visual-perception | 248/249/253/489 |
16340 | disney-doc-mcstuffins-uno-card-game-case-pack-12 | 248/249/253/489 |
16341 | pokemon-excadrill-ex-82-113-legendary-treasures-holo | 248/249/253/489 |
16342 | eeboo-fairy-queen-playing-cards | 248/249/253/489 |
16343 | united-states-playing-cards-1001781-double-pack-poker-cards | 248/249/253/489 |
16344 | monster-high-great-scarrier-reef-glowsome-ghoulfish-toralei-doll | 248/249/250/499 |
16345 | disney-princess-little-kingdom-magiclip-fashion-cinderella-doll | 248/249/250/499 |
16346 | dollhouse-miniature-tennis-racket | 248/249/250/496 |
16347 | barbie-princess-charm-school-blair-doll | 248/249/250/499 |