{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "39.06"
},
"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": 59,
"rows_produced_per_join": 59,
"filtered": "100.00",
"index_condition": "((`cscartdb`.`cscart_seo_names`.`object_id` in (7886,5537,5505,9959,7895,10998,8026,5530,5528,5593,67475,11001,7922,16324,5534,7892,10993,7906,7903,5592,63039,5595,5589,5547,13173,7951,7896,5597,7894,5538,11002,7890,5527,7904,11074,7893,7897,13183,5545,10996,5550,13160,9948,11004,5539,13167,11046,5596,5591,12041)) 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": "33.16",
"eval_cost": "5.90",
"prefix_cost": "39.06",
"data_read_per_join": "100K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
5505 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy | 2/8/31 |
5527 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-en | 2/8/31 |
5528 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-en-en | 2/8/31 |
5530 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-en-2 | 2/8/31 |
5534 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-3 | 2/8/31 |
5537 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-3-en-en | 2/8/31 |
5538 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-3-en-2 | 2/8/31 |
5539 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-3-en-3 | 2/8/31 |
5545 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-4 | 2/8/31 |
5547 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-4-en | 2/8/31 |
5550 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-4-en-2 | 2/8/31 |
5589 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-5-en | 2/8/31 |
5591 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-5-en-3 | 2/8/31 |
5592 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-5-en-4 | 2/8/31 |
5593 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-6 | 2/8/31 |
5595 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-6-en-2 | 2/8/31 |
5596 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-6-en-3 | 2/8/31 |
5597 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-6-en-4 | 2/8/31 |
7886 | magmis-solid-color-custom-fantasy-dildo-silicone-monster-sex-toy-90ae100 | 2/8/31 |
7890 | magmis-fade-color-custom-fantasy-dildo-silicone-monster-sex-toy-362ec48 | 2/8/31 |
7892 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-8 | 2/8/31 |
7893 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-8-en | 2/8/31 |
7894 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-8-en-2 | 2/8/31 |
7895 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-8-en-3 | 2/8/31 |
7896 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-8-en-4 | 2/8/31 |
7897 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-8-en-5 | 2/8/31 |
7903 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-9-en-5 | 2/8/31 |
7904 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-10 | 2/8/31 |
7906 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-10-en | 2/8/31 |
7922 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-10-en-2 | 2/8/31 |
7951 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-10-en-3 | 2/8/31 |
8026 | cerberus-solid-color-small-size-custom-fantasy-dildo-with-knot-silicone-dog-style-sex-toy-en-10-en-4 | 2/8/31 |
9948 | custom-stinger-jellyfish-dildo-355987c | 2/8/31 |
9959 | custom-peach-pie-à-la-mode-dildo-2c7b782 | 2/8/31 |
10993 | void-maw | 2/8/31 |
10996 | nacht-171242d | 2/8/31 |
10998 | rushan | 2/8/31 |
11001 | ganon | 2/8/31 |
11002 | the-curse | 2/8/31 |
11004 | abyss-xl | 2/8/31 |
11046 | kitsune | 2/8/31 |
11074 | hellboy-xl | 2/8/31 |
12041 | peach-pie-à-la-mode-dildo-8caa767 | 2/8/31 |
13160 | zachary-xlarge | 2/8/31 |
13167 | maverick-large | 2/8/31 |
13173 | inflatable-tsuki-medium-81f1fff | 2/8/31 |
13183 | dragon-rider-medium-3fb3c33 | 2/8/31 |
16324 | maverick-inflarable-xlarge | 2/8/31 |
63039 | drago-handmade-fantasy-sex-toy-6a07db3 | 2/8/31 |
67475 | vlad-the-impaler-silicone-sex-toy-4095c9b | 2/8/31 |