Query time 0.08419
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3092.60"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "companies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "15K"
},
"used_columns": [
"company_id",
"status",
"company",
"discreet_shipping"
]
}
},
{
"table": {
"table_name": "products",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"status",
"idx_parent_product_id"
],
"key": "idx_parent_product_id",
"used_key_parts": [
"parent_product_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 15524,
"rows_produced_per_join": 305,
"filtered": "1.97",
"cost_info": {
"read_cost": "884.27",
"eval_cost": "30.53",
"prefix_cost": "2436.68",
"data_read_per_join": "1M"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"amount",
"usergroup_ids",
"parent_product_id",
"variation_sku"
],
"attached_condition": "((`cscartdb`.`products`.`company_id` = 23) and (`cscartdb`.`products`.`amount` > 0) and ((`cscartdb`.`products`.`usergroup_ids` = '') or (0 <> find_in_set(0,`cscartdb`.`products`.`usergroup_ids`)) or (0 <> find_in_set(1,`cscartdb`.`products`.`usergroup_ids`))) and (`cscartdb`.`products`.`status` = 'A'))"
}
},
{
"table": {
"table_name": "prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"cscartdb.products.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 305,
"filtered": "99.99",
"cost_info": {
"read_cost": "76.33",
"eval_cost": "30.53",
"prefix_cost": "2543.53",
"data_read_per_join": "7K"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`cscartdb`.`prices`.`lower_limit` = 1) and (`cscartdb`.`prices`.`usergroup_id` in (0,0,1)))"
}
},
{
"table": {
"table_name": "popularity",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"cscartdb.products.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 305,
"filtered": "100.00",
"cost_info": {
"read_cost": "76.32",
"eval_cost": "30.53",
"prefix_cost": "2650.38",
"data_read_per_join": "9K"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"cscartdb.products.product_id"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 610,
"filtered": "100.00",
"cost_info": {
"read_cost": "152.64",
"eval_cost": "61.06",
"prefix_cost": "2864.08",
"data_read_per_join": "9K"
},
"used_columns": [
"product_id",
"category_id"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"cscartdb.products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 30,
"filtered": "5.00",
"cost_info": {
"read_cost": "152.64",
"eval_cost": "3.05",
"prefix_cost": "3077.77",
"data_read_per_join": "102K"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "(((`cscartdb`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`cscartdb`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`cscartdb`.`cscart_categories`.`usergroup_ids`))) and (`cscartdb`.`cscart_categories`.`status` in ('A','H')) and (`cscartdb`.`cscart_categories`.`storefront_id` in (0,1)))"
}
},
{
"table": {
"table_name": "descr1",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscartdb.products.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 30,
"filtered": "100.00",
"cost_info": {
"read_cost": "11.78",
"eval_cost": "3.05",
"prefix_cost": "3092.60",
"data_read_per_join": "116K"
},
"used_columns": [
"product_id",
"lang_code",
"product"
]
}
}
]
}
}
}
}
Result
product_id |
product |
company_name |
product_type |
parent_product_id |
variation_sku |
company_discreet_shipping |
8633 |
Lovense Edge 2 Bluetooth Remote-Controlled Adjustable Prostate Massager |
SpiceStore |
P |
0 |
77293 |
Y |
8619 |
Liberator Tula Toy Mount |
SpiceStore |
P |
0 |
89342 |
Y |
8458 |
LELO GIGI 2 Rechargeable G-Spot Vibrator |
SpiceStore |
P |
0 |
77075 |
Y |
8576 |
LELO TOR 3 Vibrating Cockring |
SpiceStore |
P |
0 |
85092 |
Y |
8611 |
Liberator Pulse Toy Mount Black |
SpiceStore |
P |
0 |
|
Y |
8470 |
LELO BEADS Noir Kegel Balls Set Black |
SpiceStore |
P |
0 |
|
Y |
8468 |
LELO Antibacterial Toy Cleaning Spray 60 ml / 2 oz. |
SpiceStore |
P |
0 |
|
Y |
8591 |
Liberator Mini Fascinator Throw |
SpiceStore |
P |
0 |
89103 |
Y |
8526 |
LELO SMART WAND 2 Large Rechargeable Wand Vibrator |
SpiceStore |
P |
0 |
77233 |
Y |
8622 |
Liberator Scoop Rocker Valkyrie Edition with Cuffs |
SpiceStore |
P |
0 |
89398 |
Y |
8596 |
Liberator Fascinator Throw Regular |
SpiceStore |
P |
0 |
89108 |
Y |
8469 |
LELO BEADS Kegel Balls Set Blue/Pink |
SpiceStore |
P |
0 |
|
Y |
8597 |
Liberator Heart Wedge Positioning Aid |
SpiceStore |
P |
0 |
89109 |
Y |
8583 |
LELO SORAYA Anal Beads |
SpiceStore |
P |
0 |
89127 |
Y |
8657 |
Lovense Ridge Vibrating and Rotating Anal Beads |
SpiceStore |
P |
0 |
|
Y |
8462 |
LELO HEX Original Lubricated Latex Condoms |
SpiceStore |
P |
0 |
77079 |
Y |
8601 |
Liberator Wedge Positioning Aid |
SpiceStore |
P |
0 |
89113 |
Y |
8465 |
LELO HEX Respect XL Lubricated Latex Condoms |
SpiceStore |
P |
0 |
77082 |
Y |
8621 |
Liberator Hipster |
SpiceStore |
P |
0 |
89397 |
Y |
8651 |
Lovense Bluetooth App-Compatible Sex Machine |
SpiceStore |
P |
0 |
|
Y |
8544 |
LELO SMART WAND 2 Medium Rechargeable Wand Vibrator |
SpiceStore |
P |
0 |
78760 |
Y |
8646 |
Lovense Hyphy Bluetooth Remote-Controlled Dual-End Vibrator Clitoral and G-Spot Stimulator |
SpiceStore |
P |
0 |
|
Y |
8660 |
Lovense Lapis Vibrating Strapless Strap-On |
SpiceStore |
P |
0 |
|
Y |
8625 |
Lovense Max 2 Bluetooth App-Controlled Vibrating and Suction Masturbator (Neutral Sleeve) |
SpiceStore |
P |
0 |
|
Y |
8618 |
Liberator Jaz Motion Positioning Aid Black |
SpiceStore |
P |
0 |
|
Y |
8064 |
Dame Body Wipes 25 ct. Dispenser Pack |
SpiceStore |
P |
0 |
|
Y |
8594 |
Liberator Travel Fascinator Throw |
SpiceStore |
P |
0 |
89106 |
Y |
8607 |
Liberator Ramp Positioning Aid |
SpiceStore |
P |
0 |
|
Y |
8087 |
Dame Massage Oil Candle Wild Lust |
SpiceStore |
P |
0 |
|
Y |
8065 |
Dame Sex Oil Massage Oil 2 oz. |
SpiceStore |
P |
0 |
|
Y |
8073 |
Dame Fin Finger Vibrator |
SpiceStore |
P |
0 |
83580 |
Y |
8061 |
Dame Com Rechargeable Silicone Wand Vibrator |
SpiceStore |
P |
0 |
80547 |
Y |
8647 |
Lovense Calor Bluetooth Depth-Controlled Vibrating and Heating Masturbator |
SpiceStore |
P |
0 |
|
Y |
8634 |
Lovense Diamo Bluetooth Remote-Controlled Vibrating Cockring |
SpiceStore |
P |
0 |
|
Y |
8435 |
Dame Massage Oil Candle Soft Touch |
SpiceStore |
P |
0 |
|
Y |
8683 |
FemmeFunn Lola G Rechargeable Silicone G-Spot Vibrator |
SpiceStore |
P |
0 |
76384 |
Y |
8070 |
Dame Arc G-Spot Vibrator |
SpiceStore |
P |
0 |
83577 |
Y |
8056 |
Dame Alu Aloe-Based Lubricant 118 ml / 4 oz. |
SpiceStore |
P |
0 |
|
Y |
8724 |
We-Vibe Touch X Rechargeable Silicone Lay-On Vibrator & Massager |
SpiceStore |
P |
0 |
76329 |
Y |
8709 |
We-Vibe Bloom Rechargeable Silicone Vibrating Kegel Balls Coral |
SpiceStore |
P |
0 |
|
Y |
8067 |
Dame Aer Air Pulse Stimulator |
SpiceStore |
P |
0 |
82365 |
Y |
10982 |
We-Vibe Chorus Rechargeable Remote-Controlled Silicone Couples Vibrator |
SpiceStore |
P |
0 |
73834 |
Y |
8080 |
Dame Dip Classic Vibrator |
SpiceStore |
P |
0 |
83587 |
Y |
8711 |
We-Vibe Pivot Rechargeable Silicone Vibrating Couples Ring Blue |
SpiceStore |
P |
0 |
|
Y |
8712 |
We-Vibe Verge Rechargeable Vibrating Perineum Stimulator Cockring Slate |
SpiceStore |
P |
0 |
|
Y |
8723 |
We-Vibe Nova 2 Rechargeable Flexible Silicone Rabbit Vibrator |
SpiceStore |
P |
0 |
74971 |
Y |
8554 |
INTIMINA Ziggy Cup 2 Flat-Fit Menstrual Cup |
SpiceStore |
P |
0 |
81463 |
Y |
8649 |
Lovense Hush 2 Bluetooth Remote-Controlled Vibrating Butt Plug |
SpiceStore |
P |
0 |
80319 |
Y |
8731 |
Womanizer Premium 2 Rechargeable Silicone Luxurious Pleasure Air Clitoral Stimulator |
SpiceStore |
P |
0 |
79846 |
Y |
8537 |
INTIMINA KegelSmart Pelvic Floor Trainer Pink |
SpiceStore |
P |
0 |
|
Y |
8538 |
INTIMINA Lily Cup Ultra-Soft Menstrual Cup |
SpiceStore |
P |
0 |
77250 |
Y |
8532 |
INTIMINA Lily Cup Compact Collapsible Menstrual Cup |
SpiceStore |
P |
0 |
77243 |
Y |
8522 |
LELO MONA WAVE Rechargeable G-Spot Vibrator |
SpiceStore |
P |
0 |
77224 |
Y |
8631 |
Lovense Domi 2 Bluetooth Programmable Wand Vibrator |
SpiceStore |
P |
0 |
|
Y |
8605 |
Liberator Wedge/Ramp Combo |
SpiceStore |
P |
0 |
89142 |
Y |
8445 |
Hot Octopuss Pulse Solo Lux Rechargeable Remote-Controlled Vibrating Stroker Black |
SpiceStore |
P |
0 |
|
Y |
8713 |
Womanizer Liberty Rechargeable Silicone Compact Travel Pleasure Air Clitoral Stimulator |
SpiceStore |
P |
0 |
69169 |
Y |
8533 |
INTIMINA Laselle Weighted Pelvic Exercise Kegel Balls Set |
SpiceStore |
P |
0 |
|
Y |
8612 |
Liberator Wanda Toy Mount Merlot |
SpiceStore |
P |
0 |
|
Y |
8681 |
FemmeFunn Delola Rechargeable Silicone Dual Stimulation G-Spot Vibrator |
SpiceStore |
P |
0 |
75696 |
Y |
8672 |
njoy Pure Wand |
SpiceStore |
P |
0 |
|
Y |
8705 |
FemmeFunn Cora Rechargeable Silicone Thumping Dual Stimulation Vibrator |
SpiceStore |
P |
0 |
79835 |
Y |
8539 |
INTIMINA Lily Cup One Menstrual Cup |
SpiceStore |
P |
0 |
|
Y |
8455 |
Hot Octopuss Pulse Dragon Eye 10th Anniversary Limited Edition |
SpiceStore |
P |
0 |
|
Y |
8674 |
njoy Eleven |
SpiceStore |
P |
0 |
|
Y |
8635 |
Lovense Lush 2 Bluetooth Remote-Controlled Egg Vibrator |
SpiceStore |
P |
0 |
|
Y |
8075 |
Dame Pom Flexible Vibrator |
SpiceStore |
P |
0 |
83582 |
Y |
8675 |
VeDO Yumi Rechargeable Finger Vibe |
SpiceStore |
P |
0 |
70527 |
Y |
10201 |
FemmeFunn Vortex Turbo Rabbit 2.0 8 in. Dual Stimulation Vibrating Dildo |
SpiceStore |
P |
0 |
79172 |
Y |
8632 |
Lovense Ferri Bluetooth Remote-Controlled Panty Vibrator |
SpiceStore |
P |
0 |
|
Y |
8626 |
Lovense Nora Bluetooth Remote-Controlled Long-Distance Rabbit Vibrator |
SpiceStore |
P |
0 |
|
Y |
63370 |
We-Vibe Sync O |
SpiceStore |
P |
0 |
88374 |
Y |
13303 |
Lelo DOT Cruise Clitoral Vibrator |
SpiceStore |
P |
0 |
B00179 |
Y |
8063 |
Dame Body Wipes 15-Pack - Individually Wrapped |
SpiceStore |
P |
0 |
|
Y |
64630 |
Womanizer Blend Pleasure Air Rabbit Vibrator |
SpiceStore |
P |
0 |
90889 |
Y |
64621 |
Womanizer Wave 2-In-1 Showerhead Water Massager Clitoral Stimulation Masturbator |
SpiceStore |
P |
0 |
86275 |
Y |
64650 |
Fifty Shades of Grey Greedy Girl Rechargeable Silicone G-Spot Rabbit Vibrator |
SpiceStore |
P |
0 |
82365 |
Y |
64633 |
Fifty Shades of Grey Hearts and Flowers Suction Rose |
SpiceStore |
P |
0 |
82365 |
Y |