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 |
| 157 |
en |
Shop Policies
Returns and Exchanges:
All sales are final. We do not accept returns or exchanges unless the item received is damaged or defective.
If you receive a damaged or defective item, please contact us within 7 days of receiving your order with photos of the product and packaging. We will work with you to resolve the issue promptly.
Cancellation Policy:
Orders cannot be canceled once they have been placed due to our automated processing system. Please review your order carefully before completing your purchase.
Shipping Policy:
We strive to ship all orders within 15 business days of receiving payment. Delivery times may vary depending on your location and shipping method chosen at checkout.
Payment Methods:
We accept payments via Spicerack Market methods of payment.
Contact Us:
For any questions regarding our shop policies or your order, please contact us at naughtypawsies.customer@gmail.com
Frequently Asked Questions (FAQs)
Q: How can I track my order?
A: If tracking was paid during the order: Once your order has shipped, you will receive a tracking number via email. You can use this number to track your package on the carrier’s website.
If no tracking was paid during the order: No tracking will be provided.
Q: What should I do if my order arrives damaged?
A: If your order arrives damaged, please contact us within 7 days of receipt with photos of the damaged item and packaging. We will work with you to arrange a replacement or refund.
Q: Can I cancel my order after I’ve placed it?
A: Unfortunately, we are unable to cancel orders once they have been placed due to our automated processing system. Please review your order carefully before completing your purchase.
Q: Do you offer international shipping?
A: Yes, we offer international shipping to selected countries. Shipping rates and delivery times may vary depending on your location.
Q: How can I contact customer service?
A: You can reach our customer service team via email at naughtypawsies.customer@gmail.com or through our contact form on the website. We strive to respond to all inquiries within 24-48 hours during business days.
Q: Do you accept returns or exchanges?
A: All sales are final, and we do not accept returns or exchanges unless the item received is damaged or defective. Please contact us promptly if you encounter any issues with your order.
Additional Information
Privacy Policy: We respect your privacy and are committed to protecting your personal information. Our privacy policy outlines how we collect, use, and safeguard your data.
Terms and Conditions: By placing an order with us, you agree to our terms and conditions, including our policies on returns, cancellations, and shipping.
Feedback: Your satisfaction is important to us! We welcome your feedback and suggestions to help us improve our products and services.
Feel free to tailor the policies and FAQs to fit your specific business model and customer needs. These documents are crucial for providing transparency and clarity to your customers while ensuring a positive shopping experience. |
Thank you for shopping with Naughty Pawsies. Please read our return policy carefully before making a purchase:
All Sales Are Final: We do not accept returns or exchanges on any products purchased.
Quality Assurance: We take pride in ensuring that all items shipped are of the highest quality. If you have concerns about the quality of your order, please contact us within 7 days of receiving your shipment.
Damaged or Defective Products: In the rare event that your order arrives damaged or defective, please contact us immediately so we can resolve the issue promptly.
If you have any questions regarding our return policy, please contact our customer service team at Naughty Pawsies |
Welcome to Naughty Pawsies, where sass meets style in every piece! Proudly LGBTQ+ owned, we specialize in chokers, slipchains, earrings, and wearable art that's as unique as you are. Embrace your wild side with handcrafted jewelry that's purr-fect for expressing your inner roar. Join our pack of trendsetters and unleash your fabulousness, because at Naughty Pawsies, being a little naughty never looked so good! We promise, you won’t be kitten around! |
|
Naughty Pawsies |
97 139e rue |
beauceville |
A |
Naughty Pawsies |
97 139e rue |
beauceville |
QC |
CA |
g5x2r9 |
naughtypawsies@gmail.com |
5147782176 |
Naughtypawsies.etsy.com |
|
|
none |
Y |
|
1716582449 |
|
|
334 |
|
a:4:{s:14:"company_fields";a:8:{i:37;s:7:"camille";i:38;s:8:"tremblay";i:52;s:18:"Naughtypawsies.com";i:58;s:14:"Naughtypawsies";i:54;s:8:"Npawsies";i:55;s:15:"Naughtypawsies ";i:56;s:0:"";i:57;s:0:"";}s:15:"admin_firstname";s:7:"camille";s:14:"admin_lastname";s:8:"tremblay";s:6:"fields";a:5:{i:65;s:14:"Naughtypawsies";i:61;s:8:"Npawsies";i:62;s:15:"Naughtypawsies ";i:63;s:0:"";i:64;s:0:"";}} |
def502005b1a551fd9f77cb4e69a3465325b5e098515709d119b12b227d2e265334c739c345ede2928e6abc269c2a4fa8e92a749a9c92b1b0c2084e9d90aa7a4d09a8226d0ff3cf81af834ac859bc43468e6bbd57782 |
1 |
1 |
N |
N |
N |
0 |
0 |
0 |
0 |
GEWBM3FSY5DRL |
Y |
N |
Y |
|
|
N |
0 |
|
|
|
|
|
|
|
|
|
|
N |
0 |
N |
|
N |
0 |
|
|
|
Camille Tremblay |
0 |
0 |
0 |
Your one-stop shop for alternative jewelry |
|
|
|
|
|
|
N |
|
|
N |
|
Beta Plan |
naughtypawsies |
|
|
157_0 |