{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "64.66"
},
"table": {
"table_name": "cscart_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": 97,
"rows_produced_per_join": 97,
"filtered": "100.00",
"index_condition": "((`cscartdb`.`cscart_seo_names`.`object_id` in (11058,11003,11098,11052,11015,11060,11094,10998,10997,11001,11084,11047,11049,11073,10993,11086,11002,11074,10996,11099,11004,11046,10994,11071,10995,11103,10999,11066,56065,11000,10992,11082,11105,11076,11048,11044,11095,11006,11017,11080,11106,11110,11062,11008,11111,10962,11053,11088,11068,11057,11096,11093,11014,11016,11072,11077,11078,11104,11061,11091,11102,11081,11090,11075,11079,11043,11067,11109,11059,11097,11051,11092,11107,11018,11108,11101,11087,11089,11069,56066,11070,11083,11100,11065)) and (`cscartdb`.`cscart_seo_names`.`type` = 'p') and (`cscartdb`.`cscart_seo_names`.`dispatch` = '') and (`cscartdb`.`cscart_seo_names`.`lang_code` = 'en'))",
"cost_info": {
"read_cost": "54.96",
"eval_cost": "9.70",
"prefix_cost": "64.66",
"data_read_per_join": "164K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
10962 | lost-in-netherspace-984c449 | 2/8/31 |
10992 | sidon-71918e5 | 2/8/31 |
10993 | void-maw | 2/8/31 |
10994 | archangel-wearable | 2/46 |
10995 | archangel-7db215b | 2/8/31 |
10996 | nacht-171242d | 2/8/31 |
10997 | amphibian-pin | 7 |
10998 | rushan | 2/8/31 |
10999 | zompeen | 2/8/31 |
11000 | gag-on-it-mount | 4/16 |
11001 | ganon | 2/8/31 |
11002 | the-curse | 2/8/31 |
11003 | lycan-packer | 92/428/336 |
11004 | abyss-xl | 2/8/31 |
11006 | archangels-maw | 2/8/31 |
11008 | undertow | 2/8/31 |
11014 | abyss | 2/8/31 |
11015 | archangel-packer | 92/428/336 |
11016 | gag-on-it-archangel | 4/16 |
11017 | hunter | 2/8/31 |
11018 | siha | 2/8/31 |
11043 | alicorn | 2/8/31 |
11044 | the-licker | 2/8/31 |
11046 | kitsune | 2/8/31 |
11047 | squishies | 2/8/34 |
11048 | spooky | 2/8/31 |
11049 | teeny-peens | 7/90 |
11051 | helix | 2/8/31 |
11052 | tentipeen-packer | 92/428/336 |
11053 | amphibian-man | 2/8/31 |
11057 | jella | 2/8/31 |
11058 | rushan-duel-packer | 92/428/336 |
11059 | harbinger | 2/8/31 |
11060 | rushan-packer | 92/428/336 |
11061 | azure | 2/8/31 |
11062 | king | 2/8/31 |
11065 | the-crafty-hedonist-sticker-en-2 | 7/90 |
11066 | lynel | 2/8/31 |
11067 | giger-grinder | 2/12 |
11068 | mordin | 2/8/31 |
11069 | chaimberlain | 2/8/31 |
11070 | primordial-6cdf4e1 | 2/8/31 |
11071 | iron-bull | 2/8/31 |
11072 | gag-on-it-helix | 4/16 |
11073 | undertow-pin | 7 |
11074 | hellboy-xl | 2/8/31 |
11075 | krampus | 2/8/31 |
11076 | solas | 2/8/31 |
11077 | small-helix | 2/8/31 |
11078 | hellboy | 2/8/31 |
11079 | duel-rushan | 2/8/31 |
11080 | helix-pin | 7 |
11081 | fenris | 2/8/31 |
11082 | axol-wearable | 2/46 |
11083 | keelah | 2/8/31 |
11084 | the-crafty-hedonist-stickers-en-2 | 7 |
11086 | kraken-feeldo | 2/96/380 |
11087 | nacht-xl | 2/8/31 |
11088 | octopuss-stroker | 2/47 |
11089 | spyro-slim | 2/8/31 |
11090 | enkindled | 2/8/31 |
11091 | ancient-torment | 2/8/31 |
11092 | taoshay | 2/8/31 |
11093 | vizier-staff | 2/8/31 |
11094 | drake-packer | 92/428/336 |
11095 | legion | 2/8/31 |
11096 | striped-martingale-collar | 4/347 |
11097 | elias | 2/8/31 |
11098 | fenris-packer | 92/428/336 |
11099 | suspension-en-2 | 828 |
11100 | smile | 828 |
11101 | breathe-en-2 | 828 |
11102 | bound-en-2 | 828 |
11103 | the-hanging-man-en-2 | 828 |
11104 | dekuuna | 2/8/31 |
11105 | archangel-xxl | 2/8/31 |
11106 | spyro | 2/8/31 |
11107 | mechlobite-grinder | 2/12 |
11108 | cobra | 2/8/31 |
11109 | xl-rushan | 2/8/31 |
11110 | uroboros-feeldo | 2/96/380 |
11111 | candy-cane | 2/8/31 |
56065 | alucard-7ffa8d7 | 2/8/31 |
56066 | arbiter-195aba9 | 2/8/31 |