Query time 0.00054
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.10"
},
"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": "6K"
},
"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",
"override_delivery_days",
"delivery_days",
"stripe_connect_account_id",
"stripe_connect_account_type",
"paypal_commerce_platform_account_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",
"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.25",
"eval_cost": "0.10",
"prefix_cost": "0.70",
"data_read_per_join": "24"
},
"used_columns": [
"thread_id",
"object_id",
"object_type"
]
}
},
{
"table": {
"table_name": "cscart_discussion_posts",
"access_type": "ref",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"key": "thread_id",
"used_key_parts": [
"thread_id"
],
"key_length": "3",
"ref": [
"wearethehelpful_scalesta_net.cscart_discussion.thread_id"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.50",
"eval_cost": "0.20",
"prefix_cost": "1.40",
"data_read_per_join": "896"
},
"used_columns": [
"post_id",
"thread_id",
"status"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion_posts), (`wearethehelpful_scalesta_net`.`cscart_discussion_posts`.`status` = 'A'), true)"
}
},
{
"table": {
"table_name": "cscart_discussion_rating",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"thread_id"
],
"key": "PRIMARY",
"used_key_parts": [
"post_id"
],
"key_length": "3",
"ref": [
"wearethehelpful_scalesta_net.cscart_discussion_posts.post_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.50",
"eval_cost": "0.20",
"prefix_cost": "2.10",
"data_read_per_join": "32"
},
"used_columns": [
"rating_value",
"post_id",
"thread_id"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion_rating), (`wearethehelpful_scalesta_net`.`cscart_discussion_rating`.`thread_id` = `wearethehelpful_scalesta_net`.`cscart_discussion`.`thread_id`), true)"
}
}
]
}
}
Result
| company_id |
lang_code |
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 |
override_delivery_days |
delivery_days |
stripe_connect_account_id |
stripe_connect_account_type |
paypal_commerce_platform_account_id |
plan |
seo_name |
seo_path |
average_rating |
company_thread_ids |
| 25 |
en |
<p><span style="font-size:32px;font-weight:700;">Empowered Wellness</span></p>
<p><span>Our all-natural products, daily self-care rituals and guidance empower you to take charge of your wellbeing. Combining traditional women’s medicine and the best of modern technology, we leverage the</span><b> magic and science of plants</b><span> for hormonal balancing in our debut collection of restorative skin care and herbal infusions.</span></p> |
<p>Terms and Conditions<br />By using this website or purchasing The SABI products via We are The Helpful, you agree to these terms. The SABI is based in The United Kingdom, and these terms are governed by UK law.</p>
<p>1. General Information<br />This website operates as a partner platform for The SABI. The SABI, part of The Sabi Collective B.V. (VAT number 437 4786 57), is responsible for the sale and fulfillment of its products. The goods available here are for personal use only and may not be resold.</p>
<p>2. Delivery<br />Delivery is handled by The SABI. We Are The Helpful is not responsible for incorrect addresses or delivery delays. Please inspect your goods upon arrival and report any issues within 48 hours.</p>
<p>3. Sales & Pricing<br />The SABI reserves the right to refuse sales and adjust prices without notice. Orders are confirmed only when payment is processed. Prices may not include taxes or shipping. International orders may incur additional duties or taxes.</p>
<p>4. Returns & Refunds<br />Order cancellations are accepted within 24 hours if the product has not been dispatched. Returns must be requested within 7 days for unopened items. Refunds are only issued for faulty or unfit products.</p>
<p>5. Payment<br />Payments are securely processed through approved methods. Fraudulent transactions will be reported.</p>
<p>6. Intellectual Property<br />All content on this website, including branding, belongs to We Are The Helpful or its partners, including The SABI. Unauthorized use of any content is prohibited.</p>
<p>7. Liability<br />Neither We Are The Helpful nor The SABI are liable for indirect damages from product use. The products are provided “as is,” and medical or legal concerns should be discussed with a professional.</p>
<p>8. Privacy<br />Customer information is protected and only used for processing orders and providing services. Data will not be shared without consent unless required by law.</p>
<p>9. Changes<br />We reserve the right to update these terms at any time. If any clause is found invalid, the remaining terms remain in effect.</p>
<p>10. Third-Party Links<br />This website may contain links to third-party sites. We Are The Helpful is not responsible for their content or transactions.</p>
<p>11. Governing Law<br />These terms are governed by UK law, and disputes will be resolved under the jurisdiction of The United Kingdom.</p>
<p></p> |
The SABI |
|
|
A |
The SABI |
|
|
|
|
|
anna@thesabi.co |
+573046419330 |
|
|
|
none |
Y |
|
1729997105 |
30 |
|
0 |
|
a:4:{s:14:"company_fields";a:6:{i:37;s:4:"Anna";i:38;s:11:"Cave Bigley";i:53;s:15:"CEO of The SABI";i:54;s:108:"1) therapeutic and lifestyle herbal blends 2) hormone conscious skincare 3) supporting with content creation";i:55;s:90:"100% female, 24-73 years of age, searching for a solution, either problem or hormone aware";i:56;s:162:"1) postpartum 2) complicated periods 3) endometriosis 4) PCOS, 5) hormonal acne 6) (peri)menopausal 7) stressed or burnt out 8) Trouble sleeping 9) stomach issues";}s:15:"admin_firstname";s:4:"Anna";s:14:"admin_lastname";s:11:"Cave Bigley";s:6:"fields";a:0:{}} |
437 4786 57 |
1 |
10 |
N |
N |
N |
0 |
0 |
0 |
0 |
N |
0 |
acct_1QvypMGgHcirGvqp |
S |
|
Launch - 20% |
the-sabi |
|
|
25_0 |