Query time 0.00384
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.00"
},
"ordering_operation": {
"using_filesort": false,
"nested_loop": [
{
"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": "14K"
},
"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",
"plan_id",
"stripe_connect_account_id",
"identifier_facebook_pixel",
"featured_products",
"sd_ga_tracking_code",
"paypal_commerce_platform_account_id",
"tagline",
"url_facebook",
"url_instagram",
"url_twitter",
"url_pinterest",
"announcement",
"shippo_api_token",
"shippo_carrier",
"shippo_service_type",
"vendor_ga_tracking_code",
"vendor_fb_tracking_code",
"custom_domain",
"custom_domain_status",
"taxjar_key",
"taxjar_export_statuses",
"taxjar_export_csv_data",
"ag_hide_city",
"updated_timestamp",
"suspend_date",
"grace_period_start",
"last_time_suspended",
"last_debt_notification_time",
"tax_number",
"stripe_connect_account_type",
"registered_from_storefront_id"
]
}
},
{
"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",
"subdomain_colors",
"i18n_company",
"i18n_address",
"i18n_city"
]
}
},
{
"table": {
"table_name": "p",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"plan_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": "112"
},
"used_columns": [
"plan_id",
"price",
"periodicity",
"commission",
"products_limit",
"revenue_limit",
"vendor_store",
"categories",
"storefronts"
]
}
}
]
}
}
}
Result
| company_id |
lang_code |
company_description |
terms |
subdomain_colors |
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 |
plan_id |
stripe_connect_account_id |
identifier_facebook_pixel |
featured_products |
sd_ga_tracking_code |
paypal_commerce_platform_account_id |
tagline |
url_facebook |
url_instagram |
url_twitter |
url_pinterest |
announcement |
shippo_api_token |
shippo_carrier |
shippo_service_type |
vendor_ga_tracking_code |
vendor_fb_tracking_code |
custom_domain |
custom_domain_status |
taxjar_key |
taxjar_export_statuses |
taxjar_export_csv_data |
ag_hide_city |
updated_timestamp |
suspend_date |
grace_period_start |
last_time_suspended |
last_debt_notification_time |
tax_number |
stripe_connect_account_type |
registered_from_storefront_id |
price |
periodicity |
commission |
products_limit |
revenue_limit |
vendor_store |
categories |
storefronts |
| 4521 |
en |
<p>Hi everyone! My name is Katharina and I originally come from Germany. Love brought me to the Pittsburgh, PA area in 2014 and we have lived here happily ever after since then. If you‘re local you might have seen me at a craft show. But thanks to Goimagine I can now offer my products everywhere in the US. And I am so proud to be part of this wonderful group of makers here. </p>
<p>I hope you will find something you like and if not - please do not hesitate to contact me. My sewing studio is FULL of fabric and I am sure we can find something you will like! </p> |
<p><span style="color: rgb(34, 34, 34); font-size: 18px; font-weight: 700; -webkit-text-size-adjust: 100%;">Returns and exchanges</span></p>
<h6>I gladly accept returns and exchanges</h6>
<p>Contact me within: 14 days of delivery<br>Ship items back within: 30 days of delivery</p>
<h6>I don't accept cancellations</h6>
<p>But please contact me if you have any problems with your order.</p>
<h6>The following items can't be returned or exchanged</h6>
<p>Because of the nature of these items, unless they arrive damaged or defective, I can't accept returns for:</p>
<ul><li>Custom or personalized orders</li><li>Intimate items (for health/hygiene reasons)</li></ul>
<h6>Returns and exchange details</h6>
<p>If there are any issue with the product, please do not hesitate to contact me, and we can work together to resolve the issue.</p>
<h5>Payment</h5>
<p>Payment<br><br>Kat's Sewing Korner accepts payments through PayPal. You do not need a PayPal Account to pay for your items through PayPal:<br><br>You can choose the PayPal Option during checkout. After you submit your order click the "Pay Now" button. Scroll Down and you will see the option to pay with a Credit or Debit Card WITHOUT having to sign up for a PayPal account.<br><br>If you are having issues with PayPal or any other aspect of the transaction, please do not hesitate to contact us. We will work with you to accommodate your needs.<br></p>
<h5>Shipping</h5>
<p>Shipping<br><br>All orders will ship within 1-5 business days from the date of payment. This highly depends on whether you order something, that is already finished (1-3 days shipping) or order something personalized 'made to order' which then will take me some more time to make and ship (4-5 days). <br><br>All packages will be sent via USPS. When shipping overseas, customs can delay packages by up to 6 weeks. This doesn't happen often, but it can happen.<br><br>All orders are sent via standard mail, unless noted otherwise. Notify the seller prior to making the purchase, if priority or first class mail is preferred.<br><br></p>
<h5>Additional policies and FAQs</h5>
<p>Additional Policies and FAQs<br><br>If you're purchasing an item as a gift, special packaging and a hand written note can be included at no extra cost. Please use the "contact the seller" link at the bottom of the page to inform us of the occasion, shipping address, and personal message to be included in the package</p> |
{"tmenu_style":"H","default_colors":"N","link_color":"#007d89","label_color":"#00a0af","icon_color":"#00a0af","main_btn_color":"#6dd1d6","branded_text_color":"#00a0af","vbp_1_url":"","vbp_2_url":"","vbp_3_url":"","vba_1_url":"","vba_2_url":"","vba_3_url":""} |
Kat’s Sewing Korner |
2276 Flint Dr |
Washington |
A |
Kat’s Sewing Korner |
2276 Flint Dr |
Washington |
PA |
US |
15301 |
katharina@katssewingkorner.com |
|
|
|
|
none |
Y |
|
1638560748 |
|
|
0 |
|
|
3 |
acct_1KBPchBPygAeO9Mj |
|
260004,271009,253418,253628,253617,229562 |
|
Y4PGCVWA9N7KS |
|
https://www.facebook.com/Katssewingkorner/ |
https://www.instagram.com/kats_sewing_korner/ |
|
|
|
|
|
|
UA-240618653-1 |
911394990102178 |
katssewingkorner.com |
A |
|
|
{"items_per_file":"2500","time_from":"","time_to":""} |
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
7.50 |
onetime |
4.00 |
250 |
0.00 |
1 |
|
|