Query time 0.00029
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "0.35"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_pages",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_id"
],
"key_length": "3",
"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": "2K"
},
"used_columns": [
"page_id",
"company_id",
"parent_id",
"id_path",
"status",
"page_type",
"position",
"timestamp",
"usergroup_ids",
"localization",
"new_window",
"use_avail_period",
"avail_from_timestamp",
"avail_till_timestamp",
"facebook_obj_type"
]
}
},
{
"table": {
"table_name": "cscart_page_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_id",
"lang_code"
],
"key_length": "9",
"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": "3K"
},
"used_columns": [
"page_id",
"lang_code",
"page",
"description",
"meta_keywords",
"meta_description",
"page_title",
"link"
]
}
},
{
"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"
]
}
}
]
}
}
Result
| page_id |
company_id |
parent_id |
id_path |
status |
page_type |
position |
timestamp |
usergroup_ids |
localization |
new_window |
use_avail_period |
avail_from_timestamp |
avail_till_timestamp |
facebook_obj_type |
lang_code |
page |
description |
meta_keywords |
meta_description |
page_title |
link |
seo_name |
seo_path |
| 96 |
0 |
7 |
7/96 |
A |
B |
0 |
1709683200 |
0 |
|
0 |
N |
0 |
0 |
|
en |
Partner in Focus: Dook |
<p>Dook is an award-winning artisanal company based in Edinburgh, Scotland, making salt soap in small batches using organic ingredients, essential oils and natural colours. Each batch is mixed and poured by hand resulting in distinctive, high-quality hand and body soap.<br> <br>We've curated Dook because the products are truly special; they're a brand which couples a luxury beauty product with a sustainable lifestyle, offering a stunning gifting option for the Self & Sisterhood.<br> <br>My personal favourite is the Lavender Mandarin, Coriander & Cedar Bath Salts - they look beautiful in the bathroom and are an absolute luxury at the end of the day. It's a beautifully simple gift to send to a loved one needing that little reminder to take a moment for herself, or for yourself (this is what I did!).</p>
<p>I've asked Helen, Founder of Dook a few questions - enjoy! </p>
<p><strong><em>Your name and role with Dook:</em></strong> </p>
<p>Helen Atherton, Founder, Dook</p>
<p><span style="color: var(--redactor2-text-color);"><strong><em>Why did you start Dook? </em></strong></span></p>
<p><span style="color: var(--redactor2-text-color);">After years of making soap as a hobby, I found joy in the act of making beautiful things that smell great and work really really well. Taking these things and creating a brand and business around them has been hugely rewarding, I love the diversity of roles that being a small business owner demands. I'm constantly learning and evolving - it's very satisfying!</span></p>
<p><span class="im"></span></p>
<p><strong><em>Tell us more about Dook</em></strong></p>
<p><span style="color: var(--redactor2-text-color);">Dook is an award-winning artisanal soap company based in Edinburgh, Scotland. We make salt soap in small batches using organic ingredients, essential oils and natural colours. Each batch is mixed and poured by hand resulting in distinctive, high-quality hand and body soap. These salt soaps are a fantastic product: the salt adds a beautiful colour and texture, is rich in skin-loving minerals and creates a firm, long-lasting bar. Put simply, these are brilliant soaps and we are extremely proud of them.</span><br></p>
<p><span class="im"><em><strong>What has been the most impactful and helpful gift you've received from a loved one and why?</strong></em></span></p>
<p>The gift of time! When my children were little and my parents watched my kids. My partner and I had a couple of pretty wonderful weekends away.<br><span class="im"></span></p>
<p><strong><em>Tell us 3 - 4 words that best describe your Inner Circle (you know, the ones who look after you while you're busy looking after everyone else):</em></strong><br><br>I feel like those I look after (my children and partner) look after me in their own ways too... It's pretty reciprocal most of the time! </p>
<p></p> |
|
|
|
|
partner-in-focus-dook |
7 |