Query time 0.00208
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 |
| 2624 |
en |
<p>Welcome to my shop! My name is Jeannine. I have a bachelor’s degree in Fashion Marketing and Design. I have also been involved working in the Fashion Industry since 2008. I’ve pretty much worked in retail, merchandising, product development and sales my whole career. I love anything and everything about fashion.<br><br>I’m also a wife and a mother of 2 beautiful little girls that inspire me every day and are the reason why I am trying so hard to get my business off the ground. I would love nothing more than be able to stay working from home in the future so I can continue to be with them.<br><br>I fell in love with embroidery about 2 years ago. Since then, I have really been focusing on how to perfect my craft. I am constantly learning and researching new embroidery techniques. I love creating unique personalized gifts for my customers. I am constantly trying to create new listings. Currently in my shop I offer embroidered t-shirts, crewneck pullover sweatshirts, quarter zip pullover stuffed animals and aprons. However, if there is something that you are looking for and do not find in my shop, please send me a message and I will be happy to create something unique and special just for you.<br><br>My goal is to provide beautiful quality products at an affordable price to all my customers. My customers are very important to me, and I want everyone to have a wonderful and pleasant experience when shopping in my shop.<br><br>Thank you so much for taking the time to read this as well as visit my little shop. Hope you find exactly what you are looking for! Happy Shopping!</p> |
<h2>RETURNS: </h2>
<p><b>RETURNS on NON PERSONALIZED items:</b></p>
<p>DreamlikeCreationsLLC.com accepts returns on unused, unaltered, and undamaged items for a full refund within 30 days of the shipment date. We'll always do our absolute best to deal with each situation with the best possible judgement and fairness; we hope our guests will be fair and reasonable with us as well.</p>
<p>To return your product, please send an email to DREAMLIKECREATIONSCORP@GMAIL.COM with your order number, the item(s) you need to return and the reason why you wish to return them. You will receive an answer from us within 24-48 hours of your request.</p>
<p>Once your return has been authorized via e-mail, please mail the unwanted item back to us. We will provide you the address upon return approval.</p>
<p>If we have made a mistake on your order, we will cover all shipping costs for returns. Otherwise, you will be responsible for paying all shipping costs associated with returning the item. You will be refunded within 10 business days of our receipt of your item, and the credit will automatically be applied to your original method of payment. Shipping costs are non-refundable.</p>
<p><b>RETURNS on PERSONALIZED items:</b></p>
<p>Due to the nature of personalized items we <b>DO NOT</b> accept returns.</p>
<p>The only exception would be, if there was a mistake on the personalized item made by us, Dreamlike Creations. In that case, </p>
<p>email to DREAMLIKECREATIONSCORP@GMAIL.COM with your order number, the item(s) you need to return and the reason why you wish to return them. You will receive an answer from us within 24-48 hours of your request.</p>
<p>Once your return has been authorized via e-mail, please mail the unwanted item back to us. We will provide you the address upon return approval.</p>
<p>If we have made a mistake on your order, we will cover all shipping costs for returns. Otherwise, you will be responsible for paying all shipping costs associated with returning the item. You will be refunded within 10 business days of our receipt of your item, and the credit will automatically be applied to your original method of payment. Shipping costs are non-refundable.</p><p></p> |
{"tmenu_style":"V","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":""} |
DreamlikeCreations |
19075 NW 84th ct |
Hialeah |
A |
DreamlikeCreations |
19075 NW 84th ct |
Hialeah |
FL |
US |
33015 |
jeanninecprats@gmail.com |
|
|
|
|
none |
Y |
|
1625588858 |
|
|
0 |
|
|
2 |
acct_1JAdSWJ6w6B6Px2l |
|
|
|
V9L48X59ZGYBC |
You dream it, I create it! |
https://www.facebook.com/DreamlikeCreationsLLC |
https://www.instagram.com/dreamlikecreationsllc/ |
|
https://www.pinterest.com/dancingrl0882/_created/ |
<p>Welcome to Dreamlike Creations LLC. I create personalized embroidered hoodies for all occastions. Can't find what you are looking for? Send me a message, I might be able to create something just for you.</p> |
|
|
|
|
|
|
A |
|
|
|
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
5.00 |
onetime |
4.50 |
100 |
0.00 |
1 |
|
|