Query time 0.00125
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 |
| 365 |
en |
Thank you for your order! We're excited to ship your purchase to you.
Enjoy FREE SHIPPING on all US orders over $35.
Order Processing:
We aim to process your order within 2-3 business days of receipt. Once your order ships, you will receive a shipping confirmation email with a tracking number.
Shipping:
Please allow 7-14 business days for standard shipping to the US. We ship via our local post service which is handled in the US by USPS Service, and provide a tracking number with each shipment.
Discreet Packaging:
Your privacy is important to us. All orders are shipped discreetly in unmarked packaging under the name Shnaider.T Co., Ltd. Items will be described as leather belts, bracelets, etc.
Lost or Damaged Packages:
If your package is lost or damaged during shipping, please contact us within 7 days of the expected delivery date. We will work with the shipping carrier to resolve the issue and either replace the item or issue a refund. |
"No Questions Asked" Return Policy
If you are unhappy with your purchase, you can return your order for a refund or exchange.
**All items being returned must be pre-approved.** Please contact us for a Return Merchandise Authorization (RMA) before sending your item back.
#### Refunds and Exchanges
- The returned item must be in original (new and unused) condition with its tags on.
- Items can be returned within 30 days of delivery.
- The buyer is responsible for return shipping costs.
#### Custom-Made Items
Custom items made according to instructions provided by the customer cannot be returned. We'll send pictures of the work before sending it to get your approval. If there is a fit issue, we can work it out, but please contact us within 7 days of delivery.
**Please contact us if you have any questions.** |
At BONBDSM, we craft premium leather, silicone, and stainless steel items in our Bangkok workshop. Each piece is meticulously handmade, combining traditional techniques with modern innovation. We focus on durability and elegance, ensuring every product enhances your experience. Your feedback inspires us to continually refine our craft.
— BONBDSM TEAM |
|
BONBDSM |
508 Sammie Alley, Bang Bumru, |
Bang Phlat |
A |
BONBDSM |
508 Sammie Alley, Bang Bumru, |
Bang Phlat |
Bangkok |
TH |
10700 |
tubi@bonbdsm.com |
+66819841102 |
https://www.etsy.com/shop/BONBDSM |
|
|
none |
Y |
|
1722837537 |
|
|
1014 |
|
a:4:{s:14:"company_fields";a:8:{i:37;s:5:"Tuvia";i:38;s:8:"Shnaider";i:52;s:11:"bonbdsm.com";i:58;s:0:"";i:54;s:0:"";i:55;s:0:"";i:56;s:0:"";i:57;s:0:"";}s:15:"admin_firstname";s:5:"Tuvia";s:14:"admin_lastname";s:8:"Shnaider";s:6:"fields";a:5:{i:65;s:0:"";i:61;s:0:"";i:62;s:0:"";i:63;s:0:"";i:64;s:0:"";}} |
def502001502cd685d012f2145078fff1b8791a77fd37d39c08468bf48255edab8850ff088a80889e895ee3e3190a7a90c50839dd090a583a7a8ba869497326ca13c8365a1d2e1a61dc219c44ae53b4f84e9d9aa5509 |
1 |
1 |
N |
N |
N |
0 |
0 |
0 |
0 |
GBMTX4K4PZJK4 |
Y |
N |
Y |
|
|
N |
0 |
|
|
|
|
|
|
|
|
|
|
N |
0 |
N |
|
N |
0 |
|
|
|
Shnaider.T Co.,Ltd. |
0 |
0 |
0 |
Crafted Elegance: Premium Leather, Silicone, and Stainless Steel Bondage Gear and BDSM Toys |
|
|
|
|
|
|
N |
|
|
N |
|
Beta Plan |
bonbdsm |
|
|
365_0 |