Query time 0.00078
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "4.34"
},
"ordering_operation": {
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "cscart_pages",
"access_type": "ref",
"possible_keys": [
"parent_id"
],
"key": "parent_id",
"used_key_parts": [
"parent_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 19,
"rows_produced_per_join": 0,
"filtered": "0.81",
"cost_info": {
"read_cost": "2.28",
"eval_cost": "0.02",
"prefix_cost": "4.18",
"data_read_per_join": "391"
},
"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"
],
"attached_condition": "((`wearethehelpful_scalesta_net`.`cscart_pages`.`status` = 'A') and (`wearethehelpful_scalesta_net`.`cscart_pages`.`page_type` = 'B') and ((`wearethehelpful_scalesta_net`.`cscart_pages`.`usergroup_ids` = '') or (0 <> find_in_set(0,`wearethehelpful_scalesta_net`.`cscart_pages`.`usergroup_ids`)) or (0 <> find_in_set(1,`wearethehelpful_scalesta_net`.`cscart_pages`.`usergroup_ids`))) and ((`wearethehelpful_scalesta_net`.`cscart_pages`.`use_avail_period` = 'N') or ((`wearethehelpful_scalesta_net`.`cscart_pages`.`use_avail_period` = 'Y') and (`wearethehelpful_scalesta_net`.`cscart_pages`.`avail_from_timestamp` <= 1771350282) and ((`wearethehelpful_scalesta_net`.`cscart_pages`.`avail_till_timestamp` >= 1771350282) or (`wearethehelpful_scalesta_net`.`cscart_pages`.`avail_till_timestamp` = 0)))))"
}
},
{
"table": {
"table_name": "cscart_page_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_id",
"lang_code"
],
"key_length": "9",
"ref": [
"wearethehelpful_scalesta_net.cscart_pages.page_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.04",
"eval_cost": "0.02",
"prefix_cost": "4.24",
"data_read_per_join": "596"
},
"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": [
"wearethehelpful_scalesta_net.cscart_pages.page_id",
"const",
"const",
"const"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.08",
"eval_cost": "0.03",
"prefix_cost": "4.34",
"data_read_per_join": "536"
},
"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 |
| 76 |
0 |
73 |
73/76 |
A |
B |
0 |
1722207600 |
0 |
|
0 |
N |
0 |
0 |
|
en |
Real Gifts: This is Incense |
<p>This is Incense: “Out of the blue my beautiful friend sent a stunning set of incense, with the most amazingly calming, nurturing scents that made the newly renovated house smell like a spa. It was such an amazing gift, it lifted the whole family and prompted me to create a much needed ritual of self care (or, I've since learnt - adopt a Gentle Habit into my day).”
</p>
<p>- Rebecca</p>
<p>
</p>
<ol><li><b>What were you gifted?</b> Two boxes of ‘This is Incense’ - in Yamba and Byron Bay.
</li><li><b>Why did your loved one gift it to you?</b> To help me find a sense of calm in my new home, and to remind me to take a moment out for myself each day. It might sound small, but it was exactly what I needed and she knew that.</li><li><b>How did it help / make you feel?</b> After months of feeling like it would never happen, we finally moved our family into our dream home, only to find the builders still there, rubble and dirt everywhere, an unfinished bathroom, no kitchen. We'd envisioned it being an adventure, it was what we signed up for afterall, but it felt more like a nightmare; stress levels were high, comfort levels low. Out of the blue my beautiful friend sent this lovely set of incense, with the most amazingly calming, nurturing scents that made the house smell like a spa. It was such an amazing gift, it lifted the whole family, and really reminded us to take a moment just to sit and take stock of everything we had, rather than everything that felt hard.
</li><li><b>Would you now gift this to someone else?</b> I would absolutely give this to another friend, and will be re-buying 'Yamba' again for myself when it runs out.</li><li><b>Rating out of 5</b>. 5 out of 5</li></ol>
<p></p><p><a href="https://wearethehelpful.com/family-self-care/this-is-incense-byron-bay/">SHOP</a></p> |
|
|
|
|
real-gifts-this-is-incense |
73 |
| 81 |
0 |
73 |
73/81 |
A |
B |
0 |
1722207600 |
0 |
|
0 |
N |
0 |
0 |
|
en |
Real Gifts: Pots for Tots |
<p>Best Seller Bundle from Pots for Tots: “This box of meals for my two young kiddies came at the best possible time and helped me enormously. I had just returned to work and started a new job after having my second child. Not having to worry about dinner time while my family and I settled into our new routine was a total relief.”
</p>
<p> - Rachel </p>
<p>
</p>
<ol><li><b>What were you gifted?</b> I was gifted a lovely variety pack of Pots for Tots toddler meals.
</li><li><b>Why did your loved one gift it to you?</b> My lovely friend gifted it to me knowing I was returning to work in a brand new and very busy medical job after around 3 years out from clinical work due to maternity leave and multiple house moves. Knowing that I was working around having two toddlers to care for (and crucially, to feed!) my friend felt that the meals could help take the load off by providing my children with a pre-prepared nutritious option for the times when I didn't have any time to make my own.
</li><li><b>How did it help / make you feel?</b> The gift made me feel so valued and understood, that someone had really thought about what our family might need at a time of change for me was really special. The meals are really handy as an option to placate two hangry toddlers when I feel like I'm on the back foot with dinner or lunch.
</li><li><b>Would you now gift this to someone else?</b> Yes I definitely would - I know so many families facing similar changes and who would really appreciate a gift like this. </li><li><b>Rating out of 5</b>. 5</li></ol><p><br></p><p><a href="https://wearethehelpful.com/feed-nourish/kids/">SHOP</a></p> |
|
|
|
|
real-gifts-pots-for-tots |
73 |
| 74 |
0 |
73 |
73/74 |
A |
B |
0 |
1719529200 |
0 |
|
0 |
N |
0 |
0 |
activity |
en |
Real Gifts: FieldGoods |
<p>“Receiving a box of beautiful, delicious food felt like a hug from home. I was in a period of deep grief, living on the other side of the world from family and solo parenting our three year old. I was only just holding it together.”
</p>
<p>- Kate, Founder of We are The Helpful</p>
<p>
</p>
<ul><li><b>What were you gifted? </b> Family from Australia sent a beautiful meal bundle from FieldGoods, and it was literally one of the most impactful gifts I have ever received.
</li><li><b>Why did your loved one gift it?</b> I had very recently lost my Mum who was one of the most important people in the world to me, was in a period of solo parenting our toddler, trying to start this business and living on the other side of the world from family and friends. Grief is an exhausting and isolating experience on its own, but it was so hugely compounded by everything else happening.</li><li><b>How did it help / make you feel? </b> With everything going on, looking after myself was low on the priority list (to be fair it didn't feature at all), so to see the FieldGoods box arrive at my door step a day after my Husband left for a work trip literally made me cry; I felt like someone was looking after me, and understood what I was experiencing. And the fact that it was organised by family in Australia made me feel less alone - like the support was there despite the distance. I'm a HUGE lover of food - it's a passion of mine & my love language, and the meals were DELICIOUS. They are the most delicious pre-made meals I've had - there's a feeling of genuine comfort, quality and amazing taste.</li><li><b>Would you gift this to someone else?</b> 100% would gift a FieldGoods bundle to someone I love, and I will even purchase them for myself and my family again when we know we have busy periods coming up to reduce the mental load - I love some comforting indulgence, especially when it means I don't have to cook or plan. The meals are restaurant quality with beautiful packaging and very, very comforting - this combo is really hard to find in the ready-made food arena, and FieldGoods have nailed it. Also, a big shout out to the Thai Curry's - they're an absolute winner. </li><li><b>Rating out of 5:</b> 5
</li></ul>
<p></p><p><a href="https://wearethehelpful.com/feed-nourish/the-classics/">SHOP</a></p> |
|
|
|
|
real-gifts-field-goods |
73 |
| 80 |
0 |
73 |
73/80 |
A |
B |
0 |
1719529200 |
0 |
|
0 |
N |
0 |
0 |
activity |
en |
Real Gifts: Positive Outcomes Journal |
<p>Positive Outcomes Journal: “Being gifted this journal made me feel seen, it was so thoughtful as a gift and such a beautiful reminder to be gentle with myself and to give myself some time and space.”</p>
<p>- Lucy </p>
<p><br></p>
<ul><li><b>What were you gifted?</b> The Gentle Habits Positive Outcomes journal </li><li><b>Why did your loved one gift it to you?</b> To help me to prioritise myself and take time out of my day to reflect during a time when I was processing a lot and felt particularly overwhelmed.
</li><li><b>How did it help / make you feel?</b> Being gifted this journal made me feel seen, it was so thoughtful as a gift and such a beautiful reminder to be gentle with myself and to give myself some time and space. On a more practical level the journal has allowed me to reflect on, and process, some of the emotions I was experiencing without being overwhelmed by them.</li><li><b>Would you now gift this to someone else?</b> I would 100% gift this to someone else who just needed a little space in their day, or a little reflection time to help them process feelings.
</li><li><b>Rating out of 5</b>. 5 out of 5
</li></ul><p><br></p><p><a href="https://wearethehelpful.com/family-self-care/clean-organise/gentle-habits-positive-outcomes-journal/">SHOP</a></p> |
|
|
|
|
real-gifts-positive-outcomes-journal |
73 |