Query time 0.00120
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.00"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_discussion_posts",
"access_type": "system",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "448"
},
"used_columns": [
"post_id",
"thread_id",
"status"
]
}
},
{
"table": {
"table_name": "cscart_discussion_rating",
"access_type": "system",
"possible_keys": [
"PRIMARY",
"thread_id"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"rating_value",
"post_id",
"thread_id"
]
}
},
{
"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",
"lang_code",
"address",
"city",
"state",
"country",
"zipcode",
"email",
"phone",
"url",
"storefront",
"secure_storefront",
"entry_page",
"redirect_customer",
"countries_list",
"timestamp",
"shippings",
"logos",
"request_user_id",
"request_account_name",
"request_account_data",
"tax_number",
"registered_from_storefront_id",
"plan_id",
"pre_moderation",
"pre_moderation_edit",
"pre_moderation_edit_vendors",
"suspend_date",
"grace_period_start",
"last_time_suspended",
"last_debt_notification_time",
"paypal_commerce_platform_account_id",
"discreet_shipping",
"shipstation_enabled",
"shipstation_fulfillment",
"shipstation_api_key",
"shipstation_api_secret",
"shipstation_api_connected",
"shipstation_webhook_id",
"shipstation_store_id",
"shipstation_warehouse_name",
"shipstation_warehouse_street1",
"shipstation_warehouse_street2",
"shipstation_warehouse_street3",
"shipstation_warehouse_country",
"shipstation_warehouse_state",
"shipstation_warehouse_city",
"shipstation_warehouse_postal_code",
"shipstation_warehouse_phone",
"shipstation_warehouse_residential",
"shipstation_warehouse_id",
"shipengine_enabled",
"shipengine_api_key",
"shipengine_api_connected",
"shipengine_webhook_id",
"shipengine_account_id",
"shipengine_external_account_id",
"shipengine_api_key_id",
"discreet_shipping_shop_name",
"vacation_mode",
"vacation_start_date",
"vacation_end_date",
"tagline",
"shopify_token",
"shopify_link_app",
"shopify_api_key",
"shopify_api_secret",
"stripe_connect_account_id",
"stripe_connect_account_type",
"chitchats_enabled",
"chitchats_client_id",
"chitchats_api_key",
"royal_mail_enabled",
"royal_mail_api_key"
]
}
},
{
"table": {
"table_name": "company_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"ref": [
"const",
"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": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"company_description",
"terms",
"i18n_company",
"i18n_address",
"i18n_city"
]
}
},
{
"table": {
"table_name": "cscart_vendor_plan_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"plan_id",
"lang_code"
],
"key_length": "10",
"ref": [
"const",
"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": "792"
},
"used_columns": [
"plan_id",
"lang_code",
"plan"
]
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "0.35",
"data_read_per_join": "1K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"ref": [
"const",
"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.45",
"data_read_per_join": "24"
},
"used_columns": [
"thread_id",
"object_id",
"object_type"
]
}
},
{
"table": {
"table_name": "return_policies",
"access_type": "ref",
"possible_keys": [
"object_type"
],
"key": "object_type",
"used_key_parts": [
"object_type",
"object_id"
],
"key_length": "95",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "0.80",
"data_read_per_join": "112"
},
"used_columns": [
"policy_id",
"object_type",
"object_id"
]
}
},
{
"table": {
"table_name": "return_policy_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"policy_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscartdb.return_policies.policy_id",
"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.90",
"data_read_per_join": "24"
},
"used_columns": [
"policy_id",
"policy",
"lang_code"
]
}
},
{
"table": {
"table_name": "shop_policies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"ref": [
"const",
"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": "1.00",
"data_read_per_join": "24"
},
"used_columns": [
"company_id",
"lang_code",
"shop_policies"
]
}
}
]
}
}
Result
| company_id |
lang_code |
shop_policies |
return_policy |
company_description |
terms |
i18n_company |
i18n_address |
i18n_city |
status |
company |
address |
city |
state |
country |
zipcode |
email |
phone |
url |
storefront |
secure_storefront |
entry_page |
redirect_customer |
countries_list |
timestamp |
shippings |
logos |
request_user_id |
request_account_name |
request_account_data |
tax_number |
registered_from_storefront_id |
plan_id |
pre_moderation |
pre_moderation_edit |
pre_moderation_edit_vendors |
suspend_date |
grace_period_start |
last_time_suspended |
last_debt_notification_time |
paypal_commerce_platform_account_id |
discreet_shipping |
shipstation_enabled |
shipstation_fulfillment |
shipstation_api_key |
shipstation_api_secret |
shipstation_api_connected |
shipstation_webhook_id |
shipstation_store_id |
shipstation_warehouse_name |
shipstation_warehouse_street1 |
shipstation_warehouse_street2 |
shipstation_warehouse_street3 |
shipstation_warehouse_country |
shipstation_warehouse_state |
shipstation_warehouse_city |
shipstation_warehouse_postal_code |
shipstation_warehouse_phone |
shipstation_warehouse_residential |
shipstation_warehouse_id |
shipengine_enabled |
shipengine_api_key |
shipengine_api_connected |
shipengine_webhook_id |
shipengine_account_id |
shipengine_external_account_id |
shipengine_api_key_id |
discreet_shipping_shop_name |
vacation_mode |
vacation_start_date |
vacation_end_date |
tagline |
shopify_token |
shopify_link_app |
shopify_api_key |
shopify_api_secret |
stripe_connect_account_id |
stripe_connect_account_type |
chitchats_enabled |
chitchats_client_id |
chitchats_api_key |
royal_mail_enabled |
royal_mail_api_key |
plan |
seo_name |
seo_path |
average_rating |
company_thread_ids |
| 67 |
en |
1. All Custom orders must be finalized before the customer pays, once paid, we will make it to the description provided at the time of payment. Sometimes we can accept minor corrections.
2. All leather items are give or take 1/4" (~5mm).
3. Balls for ball gags are within the tolerances of molding (give or take less than 1/16th of an inch)
4. We can accept imperial or metric measurements
5. For ALL International (non-USA) orders, customers are responsible for knowing their customs and related fees, it is not the shop's responsibility to know these. We also will try to be as discrete as possible, but we will not lie on a custom's form. examples of discretion we can do are Ball Gags will be listed as "Ball and Leather Strap", we have listed spreader bars as "exercise bars" (because they can be used for that)
6. Although we use a medical grade of silicone for our balls, we can get the balls certified as the FDA does not certify adult products at this time. However the material we use (unless stated otherwise) is a material that could be certified medical grade if they did.
7. Sizing details
For balls; Measure from the top of the bottom teeth to the bottom of the top teeth with the mouth wide open. For smaller sizes you can go 1/4" (5mm) more at most, for middle sizes 1/8" (3mm) and for Super Large or larger sizes you should not exceed that measurement in the diameter of the ball.
For custom size Straps for Ball Gags: Measure where the ball and strap would go ALL the way around the head with the mouth wide open. That is the size measurement of the strap. The length will be about 5 inches longer. Recommend using the shortest distance you can come up with, which is usually low on the back of the neck with head down.
For Cuffs and Collars: Please provide those sizes in the notes in 1/4" or 5mm increments.
8. Custom and personalized orders
For simple requests please just send a note with the order, for more complicated requests or if unsure make a request first. But I will do most custom orders for ball gags or straps if I can.
9. Wholesale availability
For wholesale on the balls or straps contact me directly via longwatcher@pleasureparadox.com
Minimum order is 30 balls for first wholesale order to get pricing, afterwards 12. This is mix and match for size and colors. There is not a lot of wholesale discount on the straps, unless desired with unfinished edges.
10. And finally if we find you are using our adult products with anyone underage or non-consenting, we will gleefully assist law enforcement in your prosecution. Some of our balls are tiny, but these are for adults who have jaw problems or are themselves smaller. |
No returns accepted for Custom or "AS IS" made items, We will replace an item if there is a manufacturing defect on a custom made item. "AS IS" items presume some defect so we will not replace those.
Balls and ball gags may ONLY be returned if the inner bag's seal is intact
All other items may be returned if unopened for refund except shipping.
If there is a problem with the order, please contact the shop email, we will require a picture of the problem, our policy is to replace when we can, if it is our fault at cost. We allow replacements, but customer must pay for shipping both ways and any difference in price if we originally shipped the correct item AND we can accept it back (such as Ball gags still sealed in their bags). |
Pleasure Paradox (AKA TPP Enterprises, LLC) is a manufacturer of adult goods, including Silicone Ball Gags, leather cuffs and collars (including our well known Easy Wear Cuffs, designed for suspension), Stainless Steel Spreader Bars, and miscellaneous other related items. We also sell some crafting items such as padlocks, buckles, straps, and of course our silicone balls for ball gags made (molded) here in Newport News, Virginia, USA. |
|
Pleasure Paradox |
324 57TH ST |
NEWPORT NEWS |
A |
Pleasure Paradox |
324 57TH ST |
NEWPORT NEWS |
VA |
US |
23607-2050 |
sales@pleasureparadox.com |
757-247-0016 |
pleasureparadox.etsy.com |
|
|
none |
Y |
|
1708214501 |
|
|
121 |
|
a:4:{s:14:"company_fields";a:8:{i:37;s:0:"";i:38;s:0:"";i:52;s:19:"Pleasureparadox.com";i:58;s:0:"";i:54;s:56:"https://www.facebook.com/PleasureParadox-876136722507760";i:55;s:0:"";i:56;s:0:"";i:57;s:0:"";}s:15:"admin_firstname";s:0:"";s:14:"admin_lastname";s:0:"";s:6:"fields";a:5:{i:65;s:0:"";i:61;s:56:"https://www.facebook.com/PleasureParadox-876136722507760";i:62;s:0:"";i:63;s:0:"";i:64;s:0:"";}} |
def502000035d0aae030e0b53c429d9b5335eabe35cf5399bbf3205fecd54c0966487b8fd3f018b7f8589008d0481ab76cd3c891e9a1ac3d31c928f01d909dea9d359f4754aab297e4c76ea72cb4e0d989b42a1c3e23b832295ed64f2984 |
1 |
1 |
N |
N |
N |
0 |
0 |
0 |
0 |
XHCYP7T6V79TC |
N |
N |
Y |
|
|
N |
0 |
|
|
|
|
|
|
|
|
|
|
N |
0 |
N |
|
N |
0 |
|
|
|
|
0 |
0 |
0 |
|
|
|
|
|
|
|
N |
|
|
N |
|
Beta Plan |
pleasureparadox |
|
|
67_0 |