{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "53.21"
},
"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": 23,
"rows_produced_per_join": 23,
"filtered": "100.00",
"index_condition": "((`portal`.`q_seo_names`.`object_id` in (13628,15598,15644,15645,15647,15648,15650,15651,15724,16047,16312,16313,16314,16315,16316,16317,16318,16319,16320,16323,16324)) 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": "48.61",
"eval_cost": "4.60",
"prefix_cost": "53.21",
"data_read_per_join": "38K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
13628 | building-blocks-party-pack-dinner-plates-and-napkins-16-guests | 248/249/252 |
15598 | zuru-hamsters-in-a-house-11-piece-track-set-color-may-vary | 248/249/252 |
15644 | lego-ninjago-set-of-6-anacondrai-warriors-zugu-eyezor-krait-kapau-sleven-and-chope | 248/249/252 |
15645 | lego-technic-new-4-steel-pivot-ball-4-steering-joint-socket-caster-92911-99948 | 248/249/252 |
15647 | mega-bloks-first-builders-zippy-zach-building-kit | 248/249/252 |
15648 | amaze-n-marbles-60-pkg-pack-of-1 | 248/249/252 |
15650 | lego-movie-double-decker-couch | 248/249/252 |
15651 | fisher-price-laugh-learn-first-words-food-blocks | 248/249/252 |
15724 | mega-bloks-first-builders-rescue-squad-40-blocks-firefighter-and-police-office-block-buddies | 248/249/252 |
16047 | lego-star-wars-75059-sandcrawler | 248/249/252 |
16312 | lego-disney-princess-elsas-sparkling-ice-castle | 248/249/252 |
16313 | mega-bloks-bob-the-builder-mucks-rock-drop-loading-station-building-kit | 248/249/252 |
16314 | lego-marvel-super-heroes-avengers-infinity-war-outrider-dropship-attack-76101-building-kit-124-piece | 248/249/252 |
16315 | lego-city-mini-figure-set-30013-police-city-quad-bagged | 248/249/252 |
16316 | lego-parts-electric-light-brick-2-x-3-x-1-1-3-red-led-light-trans-red | 248/249/252 |
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 |
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 |