Query time 0.00114
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 |
| 6 |
en |
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.
Where are you products made?
All of our products are proudly made in Fort Lauderdale Florida, USA.
What are your products made out of?
All our products are made using only the highest quality 100% body safe platinum silicone as well as pigment coloring materials. These materials are non-porous, hypoallergenic, unscented and easy to clean.
How long does a custom order take to ship?
Orders typically take 1-3 days to make and ship.
How are you products shipped?
Our products are shipped in a discreet box with no mention of our company name on the shipping label. |
Due to to the intimate nature of our products, we do not accept returns or exchanges.
If your item arrives damaged, please reach out immediately so we can correct the situation. |
Twisted Fantasies is a proud creator of the highest quality Fantasy inspired Sex Toys. With imaginative designs ranging from mythical creatures to whimsical realism, each handcrafted piece caters to individual desires for an unforgettable experience.
All of our toys are made with industry standard 100% body safe Platinum Grade Silicone and mica powders, to ensure your pleasure is never compromised. |
|
Twisted Fantasies |
3530 NW 53rd St |
Fort Lauderdale |
A |
Twisted Fantasies |
3530 NW 53rd St |
Fort Lauderdale |
FL |
US |
33309 |
info@twisted-fantasies.com |
+1(718)551-1815 |
|
|
|
none |
Y |
|
1690303277 |
|
|
0 |
|
a:4:{s:14:"company_fields";a:4:{i:37;s:5:"Naomi";i:38;s:9:"Goldstein";i:52;s:0:"";i:53;s:0:"";}s:15:"admin_firstname";s:5:"Naomi";s:14:"admin_lastname";s:9:"Goldstein";s:6:"fields";a:0:{}} |
def50200bb938c64556e16d70708ac7e454b1d26c675935e7bbbd1f5597f3e3f41348f7d38894817e8cc792858cd3e759433f8e6f709a2ce73c1ec6558bb974083eadb1889d5de3c7744472068548389c6d22f43599de3f070391ebb1ab5 |
1 |
1 |
N |
N |
N |
1692645486 |
0 |
1710442731 |
0 |
6FNCYJN5EP8AQ |
Y |
Y |
Y |
9a04ae946c0a410799e53936f6d62ae3 |
2234d56ed68547bdbc3d7abf7592af67 |
Y |
23998 |
434363 |
|
|
|
|
|
|
|
|
|
N |
0 |
N |
|
N |
0 |
|
|
|
TW Fan |
0 |
0 |
0 |
|
|
|
|
|
acct_1PlAsUQDYEZYF0uI |
E |
N |
|
|
N |
|
Beta Plan |
twistedfantasies |
|
|
6_0 |