{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "58.21"
},
"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": 86,
"rows_produced_per_join": 86,
"filtered": "100.00",
"index_condition": "((`cscartdb`.`cscart_seo_names`.`object_id` in (8633,8619,8458,8576,8611,8470,8468,8591,8526,8622,8596,8469,8597,8583,8657,8462,8601,8465,8621,8651,8544,8646,8660,8625,8618,8064,8594,8607,8087,8065,8073,8061,8647,8634,8435,8683,8070,8056,8724,8709,8067,10982,8080,8711,8712,8723,8554,8649,8731,8537,8538,8532,8522,8631,8605,8445,8713,8533,8612,8681,8672,8705,8539,8455,8674,8635,8075,8675,10201,8632,8626,63370,13303,8063,64630,64621,64650,64633)) 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": "49.61",
"eval_cost": "8.60",
"prefix_cost": "58.21",
"data_read_per_join": "145K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
}
}
product_id | seo_name | seo_path |
---|---|---|
8056 | dame-alu-aloe-lube-4-oz | 92/23 |
8061 | dame-com-wand-vibrator-periwinkle | 2/9/36 |
8063 | dame-body-wipes-15-pack | 5/22/344 |
8064 | dame-body-wipes-25-pack | 5/22/344 |
8065 | dame-sex-oil-2-oz | 92/23 |
8067 | aer-periwinkle | 2/9/38 |
8070 | dame-arc-g-spot-vibrator-plum | 2/9/58 |
8073 | dame-fin-finger-vibrator-citrus | 2/9/345 |
8075 | dame-pom-flexible-vibrator-plum | 2/9 |
8080 | dame-dip-periwinkle | 2/9 |
8087 | dame-massage-oil-candle-wild-lust | 5/409/346 |
8435 | dame-massage-oil-candle-soft-touch | 5/409/346 |
8445 | hot-octopuss-pulse-solo-lux-black | 2/47/356 |
8455 | hot-octopuss-pulse-dragon-eye-le | 2/47/356 |
8458 | lelo-gigi-2-rechargeable-g-spot-vibrator-392e38 | 2/9/58 |
8462 | lelo-hex-original-condoms-12-pack | 92/361 |
8465 | lelo-hex-respect-xl-condoms-12-pack | 92/361 |
8468 | lelo-toy-cleaning-spray-2-oz | 2/110/24 |
8469 | lelo-beads-kegel-balls-set-blue-pink | 92/94 |
8470 | lelo-beads-noir-kegel-balls-set-black | 92/94 |
8522 | lelo-mona-wave-rechargeable-g-spot-vibrator-9b9e2b8 | 2/9/58 |
8526 | lelo-smart-wand-2-large-deep-rose | 2/9/36 |
8532 | intimina-lily-cup-collapsible-size-b | 92/362 |
8533 | intimina-laselle-weighted-kegel-ball-set | 92/94 |
8537 | intimina-kegelsmart-trainer-pink | 92/94 |
8538 | intimina-lily-cup-ultra-soft-size-b | 92/362 |
8539 | intimina-lily-cup-one-menstrual-cup | 92/362 |
8544 | lelo-smart-wand-2-medium-black | 2/9/36 |
8554 | intimina-ziggy-cup-2-size-b | 92/362 |
8576 | lelo-tor-3-vibrating-cockring-35e7b04 | 2/45/357 |
8583 | lelo-soraya-anal-beads-8788ec2 | 2/10/40/364 |
8591 | liberator-fascinator-throw-mini-black | 72/366 |
8594 | liberator-fascinator-throw-travel-black | 72/366 |
8596 | liberator-fascinator-throw-regular-black | 72/366 |
8597 | liberator-heart-wedge-position-aid-blk | 72/93 |
8601 | liberator-wedge-positioning-aid-black | 72/93 |
8605 | liberator-wedge-ramp-combo-black | 72/93 |
8607 | liberator-ramp-positioning-aid-black | 72/93 |
8611 | liberator-pulse-toy-mount-black | 2/368 |
8612 | liberator-wanda-toy-mount-merlot | 2/368 |
8618 | liberator-jaz-motion-position-aid-black | 72/93 |
8619 | liberator-tula-toy-mount-black | 2/368 |
8621 | liberator-hipster-plum | 72/93 |
8622 | liberator-scoop-valkyrie-w-cuffs-black | 72/93 |
8625 | lovense-max-2-masturbator-neutral-sleeve | 2/47/356 |
8626 | lovense-nora-rabbit-vibrator | 2/9/365 |
8631 | lovense-domi-2-wand-vibrator | 2/9/36 |
8632 | lovense-ferri-panty-vibrator | 2/9/37 |
8633 | lovense-edge-2-prostate-massager | 2/10/41/360 |
8634 | lovense-diamo-vibrating-cockring | 2/45/357 |
8635 | lovense-lush-2-bluetooth-remote-controlled-egg-vibrator-4f1216a | 2/9/59 |
8646 | lovense-hyphy-dual-end-vibrator | 2/9/37 |
8647 | lovense-calor-masturbator | 2/47/356 |
8649 | lovense-hush-2-bluetooth-remote-controlled-vibrating-butt-plug-52548e6 | 2/10/39/62 |
8651 | lovense-sex-machine | 2/379 |
8657 | lovense-ridge-vibe-rotating-anal-beads | 2/10/40/364 |
8660 | lovense-lapisvibe-strapless-strap-on | 2/96/380/381 |
8672 | njoy-pure-wand | 2/8/385 |
8674 | njoy-11 | 2/8/385 |
8675 | vedo-yumi-rechg-finger-vibe-turquoise | 2/9/345 |
8681 | femmefunn-delola-vibrator-pink | 2/9/365 |
8683 | femmefunn-lola-g-vibrator-blue | 2/9/58 |
8705 | femmefunn-cora-vibrator-light-blue | 2/9/365 |
8709 | we-vibe-bloom-vibrating-kegel-balls-cor | 92/94 |
8711 | we-vibe-pivot-vibrating-couples-ring-blu | 2/45/357 |
8712 | we-vibe-verge-perineumstimcockring-slate | 2/45/357 |
8713 | womanizer-liberty-compacttravel-pinkrose | 2/9/37 |
8723 | we-vibe-nova-2-flex-rabbit-vibrator-pink | 2/9/365 |
8724 | we-vibe-touch-x-lay-on-vibrator-coral | 2/9/37 |
8731 | womanizer-premium-2-stimulator-black | 2/9/37 |
10201 | femmefunn-vortex-turbo-rabbit-2-0-lt-blu | 2/96/382/388 |
10982 | we-vibe-chorus-couples-vibrator-cosblue | 2/9 |
13303 | lelo-dot-cruise-clitoral-vibrator | 2/9/37 |
63370 | copy-of-8711-we-vibe-pivot-rechargeable-silicone-vibrating-couples-ring-blue-3962339 | 2/9/37 |
64621 | womanizer-wave-2-in-1-showerhead-water-massager-clitoral-stimulation-masturbator-9a5eb6f | 2/9/37 |
64630 | womanizer-blend-pleasure-air-rabbit-vibrator-1ec04d1 | 2/9/37 |
64633 | copy-of-8067-dame-aer-air-pulse-stimulator-2ae0d47 | 2/9/38 |
64650 | copy-of-64633-fifty-shades-of-grey-hearts-and-flowers-suction-rose-3a43d39 | 2/9/365 |