Query time 0.00115
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.85"
},
"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": "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": "1K"
},
"used_columns": [
"plan_id",
"lang_code",
"plan"
]
}
},
{
"table": {
"table_name": "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.86",
"eval_cost": "0.10",
"prefix_cost": "0.96",
"data_read_per_join": "1K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "discussionA",
"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",
"using_index": true,
"cost_info": {
"read_cost": "0.75",
"eval_cost": "0.10",
"prefix_cost": "1.81",
"data_read_per_join": "24"
},
"used_columns": [
"thread_id",
"object_id",
"object_type"
]
}
},
{
"table": {
"table_name": "discussion_posts",
"access_type": "ref",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"key": "thread_id_2",
"used_key_parts": [
"thread_id",
"status"
],
"key_length": "6",
"ref": [
"goimagine.discussionA.thread_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.18",
"prefix_cost": "2.24",
"data_read_per_join": "787"
},
"used_columns": [
"post_id",
"thread_id",
"status"
]
}
},
{
"table": {
"table_name": "discussion_rating",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"thread_id"
],
"key": "PRIMARY",
"used_key_parts": [
"post_id"
],
"key_length": "3",
"ref": [
"goimagine.discussion_posts.post_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.44",
"eval_cost": "0.18",
"prefix_cost": "2.85",
"data_read_per_join": "28"
},
"used_columns": [
"rating_value",
"post_id",
"thread_id"
],
"attached_condition": "<if>(is_not_null_compl(discussion_rating), (`goimagine`.`discussion_rating`.`thread_id` = `goimagine`.`discussionA`.`thread_id`), true)"
}
}
]
}
}
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 |
plan |
seo_name |
seo_path |
average_rating |
company_thread_ids |
| 337 |
en |
<p class="text-justify"></p>
<p class="text-justify"><strong>SING-ALONG SOAP</strong> is committed to promoting wellness and offers HANDMADE soap that is 100% NATURAL, VEGAN, and Palm Oil Free. In addition to carefully selecting our natural ingredients, we make our soap using the cold process method to preserve as many of the nutrients as possible. Our REAL soap is GOOD for your skin. You won’t find any harsh detergents, toxic chemicals or man-made fragrances in our soap.</p>
<p class="text-justify">We use unrefined, nutrient-rich vegetable oils, rich in antioxidants to revitalize your skin. Natural botanicals, purifying earth clays, and tropical butters are added to exfoliate, deep clean and moisturize. Our scented bars are enriched with aromatherapy grade ESSENTIAL OILS.</p>
<p class="text-justify">We LOVE <strong>music</strong> and have named each of our creations after a SONG. Studies have shown that singing is actually good for you… physically, mentally as well as spiritually, so of course we want you to do more of it. <em><span style="color: rgb(79, 129, 189); background-color: rgb(255, 255, 255);">We think a daily dosage of SINGING in the shower with our ALL-NATURAL soap is a perfect way to start each and every day!</span></em><br></p> |
<p class="text-justify"><strong></strong></p>
<p><strong>Shipping & Handling</strong>: We ship anywhere in the United States, usually within 1 – 2 business days via USPS – First Class or Priority Mail. Shipping costs are based on weight of item(s) ordered. <em>(Please note: Entering an incorrect shipping address may delay shipment. Additional fees will incur if a package is returned or has to be re-routed.)</em></p>
<p><strong>Returns:</strong> All retail orders come with a 30-day money back guarantee. Simply return the merchandise with the sales receipt and a note stating your reason for the return and we will refund your purchase price. Personalized items are excluded. Shipping & handling charges are not refundable.</p>
<p><strong>Cancellations:</strong> Please review your order carefully before you checkout. Our goal is to fulfill orders quickly. If your order has already been packed for shipment, we cannot make changes. All cancelled orders will incur a 15% cancellation fee.</p>
<p><strong>Incorrect, Damaged or Lost Items:</strong> For incorrect or damaged items, save all contents and packing materials and contact us within 3 business days. If you suspect your package is lost, contact us immediately. Failure to contact us promptly voids any responsibility we may have had.<strong></strong><br></p>
<p><strong>Disclaimer:</strong> Although allergic reactions to our natural ingredients are uncommon, we recommend testing our products first by using them on a small patch of skin for 24 hours. If redness or irritation develops, discontinue use. Also, the information presented on this vendor page is not meant to diagnose or treat any medical condition nor to replace the advice or care of a qualified health professional.</p>
<p><br></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":""} |
Sing-Along Soap |
PO Box 20 |
Oilville |
A |
Sing-Along Soap |
PO Box 20 |
Oilville |
VA |
US |
23129 |
julie@singalongsoap.com |
|
|
|
|
none |
Y |
|
1586718758 |
|
|
0 |
|
a:4:{s:14:"company_fields";a:2:{i:37;s:5:"Julie";i:38;s:5:"Kogut";}s:15:"admin_firstname";s:5:"Julie";s:14:"admin_lastname";s:5:"Kogut";s:6:"fields";a:0:{}} |
15 |
acct_1GXfUmILIwKd015w |
|
|
UA-58675992-3 |
|
HANDMADE SOAP: 100% NATURAL, VEGAN, PALM OIL FREE |
www.facebook.com/singalongsoap |
|
www.twitter.com/singalongsoap |
|
<p>Now it’s more IMPORTANT than ever to WASH YOUR HANDS... naturally! </p> |
|
|
|
UA-58675992-3 |
|
|
A |
|
|
{"items_per_file":"2500","time_from":"","time_to":""} |
N |
0 |
0 |
0 |
0 |
0 |
|
S |
|
Starter Investor |
singalongsoap |
|
5.0000 |
337_856 |