Query time 0.00135
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 |
| 241 |
en |
What is your process (AKA what is hand stamping)?
We make each piece one-at-a-time using a process called 'hand stamping.' Every letter, number, and symbol you see on our pieces is hand stamped using steel font sets and symbols in set sizes and a hammer. Hand stamping forms a much deeper impression than engraving and due to hammering each letter, alignment will not be perfect. These factors contribute to the uniqueness of each piece we make.
Where do I add personalized info when I order?
All personalized info goes in the personalization box on the item page. Please give us info in a list format, not one long paragraph.
Request symbols in ( ), example: (heart, #84)
Note that if you are ordering a piece with symbols & wording shown in our listing, be sure to tell us whether you do or don't want those symbols or what wording at checkout.
Example:
A keychain says:
I LOVE YOU (INFINITY SYMBOL, #185) but you want to change the wording. Tell us like this:
CUSTOM TEXT:
WE LOVE YOU (INFINITY SYMBOL, #185)
**OR**
WE LOVE YOU (NO SYMBOL or HEART, #84)
Leave a cell # so we can text you if have questions.
How will my order be packaged?
All of our pieces are packaged for gift giving the moment you receive them. They come in a fabric bag that doubles as a gift bag. Need a fancier gift wrap? There's an option at checkout. Please note that gift wrap applies to one piece or the entire order. If you need multiple pieces gift wrapped separately, there is an additional fee for each piece.
Will you send a gift on my behalf?
Sure! We'd love to. Please put the giftee's address in the 'ship to' box when checking out and let us know who to say it's from. Please keep the note short so we can fit it on a business card sized gift card.
All of our pieces are packaged for gift giving the moment you receive them. They come in a fabric bag that doubles as a gift bag. Need a fancier gift wrap? There's an option at checkout. Please note that gift wrap applies to one piece or the entire order. If you need multiple pieces gift wrapped separately, there is an additional fee for each piece.
Do you accept rush orders?
Usually, yes. We have a standard production time (typically 1-2 weeks which varies depending on time of year), and when we're not completely busy, we allow rush orders for an additional fee. A rush order ships out in 2 **business** days vs. our standard production time. Rush orders are available in your cart.
Please note that none of our rush options offer overnight delivery.
Can you stamp the backside of the metal?
Sometimes. We can backside on certain types of aluminum keychains only, and if backside wording is permitted, then the listing will say so *and* will specify how many characters are allowed on the back. We cannot stamp the back of non-aluminum pieces.
Because hand stamping is done by hammering letters/symbols into the metal, impressions are left on the reverse side. This means that we can only permit backside stamping when we're able to hide those impressions. This also means that the backside wording needs to be shorter than the front side wording.
Are your items already made?
We typically hand stamp each order as it comes in because much of our work is custom or personalized. *Sometimes* we may have a certain design in stock, but this is not the rule.
Do you accept returns or exchanges?
Due to the nature of our items and how they are used, we no longer allow returns or exchanges. If there is an issue with your order once received, please let us know ASAP so we can help!
Do you ship outside the USA?
No. We no longer ship outside the USA since 2019. |
Returns and exchanges are not permitted due to the type of customized/personalized and adult products we sell. If you have an issue with your order, please message us and let us help you. |
Enjoy 20% off and flat rate shipping of $4.95 sitewide!
The Twisted Screw opened in 2013 on Etsy as the "after dark" arm of my main hand stamping business, Risky Beads. At The Twisted Screw, we specialize in hand stamped customized and personalized jewelry & accessories for power exchange relationships. We cater to BDSM themes, role play, pain play, age play, pet play, etc. If you have a kink you want to express, we're here to help! Message us anytime! |
|
TheTwistedScrew |
13508 Four Oaks Lane |
Matthews |
A |
TheTwistedScrew |
13508 Four Oaks Lane |
Matthews |
NC |
US |
28105 |
thetwistedscrew@gmail.com |
9198152383 |
https://www.etsy.com/shop/TheTwistedScrew |
|
|
none |
Y |
|
1720047337 |
|
|
555 |
|
a:4:{s:14:"company_fields";a:8:{i:37;s:5:"Lori ";i:38;s:4:"Ward";i:52;s:0:"";i:58;s:0:"";i:54;s:0:"";i:55;s:18:"@the.twisted.screw";i:56;s:0:"";i:57;s:0:"";}s:15:"admin_firstname";s:5:"Lori ";s:14:"admin_lastname";s:4:"Ward";s:6:"fields";a:5:{i:65;s:0:"";i:61;s:0:"";i:62;s:18:"@the.twisted.screw";i:63;s:0:"";i:64;s:0:"";}} |
def5020005e39a9d27b9485ddc48baa15d2a33f9f22d519aeae993226741597bace06c22cb82edfcbd1dd0ab523c42f5b0b12f132331fa0b696e9a9ec711f612d9aa651819c449d22cd1a30e105a54e256c857920931 |
1 |
1 |
N |
N |
N |
0 |
0 |
0 |
0 |
CGAPRATDBFG9J |
Y |
N |
Y |
|
|
N |
0 |
|
|
|
|
|
|
|
|
|
|
N |
0 |
N |
|
N |
0 |
|
|
|
TTS/Lori Ward |
0 |
0 |
0 |
power exchange & kinky jewelry and accessories |
|
|
|
|
|
|
N |
|
|
N |
|
Beta Plan |
thetwistedscrew |
|
|
241_0 |