Query time 0.00157
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 |
| 239 |
en |
We ship all orders using Royal Mail unless otherwise stated or paid for. We ship all orders using standard Royal Mail methods which generally do not include tracking numbers, such as Royal Mail 2nd Class and Royal Mail International Standard. A selection of shipping upgrades are available during checkout. Please contact us prior to purchase if you have a favoured courier you'd prefer to use.
Royal Mail orders are generally taken over by your respective country's national postal services (e.g. La Poste for France, USPS for USA, JP Post for Japan etc) so please consider contacting them for any issues we may encounter with orders. Please look out for any notes or cards left at your delivery address with information on how to collect your order, and/or pay for any customs/import duty owed.
Buyers are responsible for any customs and import taxes that may apply. We're not responsible for delays due to customs. If orders are returned to us for any reason that is not our or the customers fault (e.g. problems at the customs border), we will contact you as soon as the order is returned to us. We do not accept returns if your order is returned because you did not pay the customs/import duty on it.
You can always contact us for any further shipping questions at info@8thsin.co.uk. |
We have a 14-day return policy if the item(s) is a standard item we sell (i.e. not customised or bespoke), damaged or not as described, which means you have 14 days after receiving your item to request a return. Buyer pays return shipping. We also accept exchanges for items and will do everything we can to resolve any issues. Buyer pays return shipping and, if applicable, exchange shipping back to themselves.
To be eligible for a return/exchange, your item must be in the same condition that you received it, unworn or unused, with tags, and in its original packaging. You’ll also need the receipt or proof of purchase, and in the event of damaged items/packaging, evidence/photos of the condition.
To start a return, you can contact us at info@8thsin.co.uk. Please note that returns will need to be sent to the following address:
8th Sin C/O Laura Haslam
97b Haydn Road
Nottingham
NG5 2LA
United Kingdom
If your return/exchange is accepted, we’ll send you instructions on how and where to send your package and if applicable, digital return shipping labels if needed. Buyers need to be able to print the shipping label and any documents such as customs information. Items sent back to us without first requesting a return/exchange will not be accepted.
You can always contact us for any return/exchange question at info@8thsin.co.uk.
Damages and issues
Please inspect your order upon reception and contact us immediately if the item is defective, damaged or if you receive the wrong item, so that we can evaluate the issue and make it right.
Exceptions / non-returnable items
Certain types of items cannot be returned, such as custom products (such as special orders or personalized items), and personal care goods (such as beauty products). We also do not accept returns for hazardous materials, flammable liquids, or gases. Please get in touch if you have questions or concerns about your specific item.
We do not accept returns if your order is returned because you did not pay the customs/import duty on it. Buyers are responsible for any customs and import taxes that may apply.
Unfortunately, we cannot accept returns on sale items or gift cards.
Exchanges
The fastest way to ensure you get what you want is to return the item you have, and once the return is accepted, we will ship the new item.
European Union 14 day cooling off period
Notwithstanding the above, if the merchandise is being shipped into the European Union, you have the right to cancel or return your order within 14 days, for any reason and without a justification. As above, your item must be in the same condition that you received it, unworn or unused, with tags, and in its original packaging. You’ll also need the receipt or proof of purchase and pay for return shipping.
Refunds
We will notify you once we’ve received and inspected your return, and let you know if the refund was approved or not. If approved, you’ll be automatically refunded on your original payment method within 10 business days. Please remember it can take some time for your bank or credit card company to process and post the refund too.
If more than 15 business days have passed since we’ve approved your return, please contact us at info@8thsin.co.uk. |
I founded 8th Sin in 2010, starting out making handmade alternative accessories. Over 13 years later, 8th Sin has evolved, grown and expanded to be an affordable, versatile alternative slow fashion brand focusing on fetish fashion in real and vegan leather. 8th Sin designs and/or makes all their original items inhouse, and also stocks and supports other small businesses and brands. We work with both local, family run suppliers, as well as international powerhouses for the best supplies. |
|
8th Sin |
|
|
A |
8th Sin |
|
|
NOT |
GB |
|
info@8thsin.co.uk |
+447980935807 |
https://8thsincreations.etsy.com |
|
|
none |
Y |
|
1720041138 |
|
|
552 |
|
a:4:{s:14:"company_fields";a:8:{i:37;s:5:"Laura";i:38;s:6:"Haslam";i:52;s:16:"www.8thsin.co.uk";i:58;s:39:"https://www.tiktok.com/@8thsincreations";i:54;s:40:"https://www.facebook.com/8thSinCreations";i:55;s:41:"https://www.instagram.com/8thSinCreations";i:56;s:0:"";i:57;s:0:"";}s:15:"admin_firstname";s:5:"Laura";s:14:"admin_lastname";s:6:"Haslam";s:6:"fields";a:5:{i:65;s:39:"https://www.tiktok.com/@8thsincreations";i:61;s:40:"https://www.facebook.com/8thSinCreations";i:62;s:41:"https://www.instagram.com/8thSinCreations";i:63;s:0:"";i:64;s:0:"";}} |
def50200d5eef877834bc79c74257db245deafcb16ce23ab8d15bcd3e16ee378a24bed043fd911013c806b7754391de2a27c6057608cbbd018c0b54b8e272a1147b6548870bdb6ef7b7606930b54c42350288410aed9 |
1 |
1 |
N |
N |
N |
0 |
0 |
0 |
0 |
W9XNXQXG8GVR2 |
Y |
N |
Y |
|
|
N |
0 |
|
|
|
|
|
|
|
|
|
|
N |
0 |
N |
|
N |
0 |
|
|
|
8th Sin |
0 |
0 |
0 |
Handmade fetish fashion in real and vegan leather - custom designs and sizes welcome! |
|
|
|
|
|
|
N |
|
|
N |
|
Beta Plan |
8thsin |
|
|
239_0 |