Query time 0.00168
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.60"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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": "4K"
},
"used_columns": [
"product_id",
"product_code",
"product_type",
"status",
"company_id",
"list_price",
"amount",
"weight",
"length",
"width",
"height",
"shipping_freight",
"low_avail_limit",
"timestamp",
"updated_timestamp",
"usergroup_ids",
"is_edp",
"edp_shipping",
"unlimited_download",
"tracking",
"free_shipping",
"zero_price_action",
"is_pbp",
"is_op",
"is_oper",
"is_returnable",
"return_period",
"avail_since",
"out_of_stock_actions",
"localization",
"min_qty",
"max_qty",
"qty_step",
"list_qty_count",
"tax_ids",
"age_verification",
"age_limit",
"options_type",
"exceptions_type",
"details_layout",
"shipping_params",
"facebook_obj_type",
"parent_product_id",
"buy_now_url",
"units_in_product",
"show_price_per_x_units",
"allow_notes",
"delivery_time",
"shopify_product_id",
"shopify_account_id",
"shopify_is_parent"
]
}
},
{
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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": "32"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "cscart_product_sales",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"pa"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"unique_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"category_id",
"product_id",
"amount"
]
}
},
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"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": "24"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "<if>(is_not_null_compl(cscart_product_prices), ((`wearethehelpful_scalesta_net`.`cscart_product_prices`.`lower_limit` = 1) and (`wearethehelpful_scalesta_net`.`cscart_product_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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.45",
"data_read_per_join": "4K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"shortname",
"short_description",
"full_description",
"meta_keywords",
"meta_description",
"search_words",
"page_title",
"age_warning_message",
"promo_text",
"unit_name"
]
}
},
{
"table": {
"table_name": "company_descr",
"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.55",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"i18n_company"
]
}
},
{
"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.65",
"data_read_per_join": "6K"
},
"used_columns": [
"company_id",
"status"
],
"attached_condition": "<if>(found_match(companies), ((`wearethehelpful_scalesta_net`.`companies`.`status` = 'A') or false), true)"
}
},
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"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.35",
"data_read_per_join": "32"
},
"used_columns": [
"product_id",
"category_id",
"link_type",
"category_position"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"wearethehelpful_scalesta_net.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "1.55",
"data_read_per_join": "267"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "((`wearethehelpful_scalesta_net`.`cscart_categories`.`storefront_id` in (0,1)) and ((`wearethehelpful_scalesta_net`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`wearethehelpful_scalesta_net`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`wearethehelpful_scalesta_net`.`cscart_categories`.`usergroup_ids`))) and (`wearethehelpful_scalesta_net`.`cscart_categories`.`status` in ('A','H')))"
}
},
{
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.03",
"eval_cost": "0.01",
"prefix_cost": "1.59",
"data_read_per_join": "173"
},
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "1.60",
"data_read_per_join": "2"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
},
{
"table": {
"table_name": "cscart_product_review_prepared_data",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"storefront_id"
],
"key_length": "7",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "1.61",
"data_read_per_join": "1"
},
"used_columns": [
"product_id",
"storefront_id",
"average_rating",
"reviews_count"
]
}
}
]
}
}
}
Result
| product_id |
product_code |
product_type |
status |
company_id |
list_price |
amount |
weight |
length |
width |
height |
shipping_freight |
low_avail_limit |
timestamp |
updated_timestamp |
usergroup_ids |
is_edp |
edp_shipping |
unlimited_download |
tracking |
free_shipping |
zero_price_action |
is_pbp |
is_op |
is_oper |
is_returnable |
return_period |
avail_since |
out_of_stock_actions |
localization |
min_qty |
max_qty |
qty_step |
list_qty_count |
tax_ids |
age_verification |
age_limit |
options_type |
exceptions_type |
details_layout |
shipping_params |
facebook_obj_type |
parent_product_id |
buy_now_url |
units_in_product |
show_price_per_x_units |
allow_notes |
delivery_time |
shopify_product_id |
shopify_account_id |
shopify_is_parent |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
unit_name |
price |
category_ids |
popularity |
company_name |
sales_amount |
seo_name |
seo_path |
discussion_type |
average_rating |
product_reviews_count |
| 408 |
|
P |
A |
24 |
260.00 |
10 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1727185293 |
1766492931 |
0 |
N |
N |
N |
|
N |
|
N |
N |
N |
Y |
10 |
0 |
N |
|
|
|
|
|
|
N |
0 |
|
|
default |
a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} |
|
0 |
|
0.000 |
0.000 |
N |
0 |
0 |
0 |
Y |
en |
Postpartum Doula Nurture Session Gift Voucher (Central Scotland) |
|
<p><b>POSTPARTUM DOULA NURTURE SESSION - GIFT VOUCHER (Edinburgh)</b></p>
<p>Jenny's postpartum nurture bundles are ideal for mothers in the days, weeks and in some cases years following on from birth. Jenny also tends to women who have lost a pregnancy at any stage, or a baby. No matter the outcome of a pregnancy, women should always receive postpartum care for their physical, emotional and spiritual wellbeing.</p>
<p>Postpartum care is often something that families do not prepare for, however this can be the foundation to THRIVING family life, and a deep bond between mother and baby. It can also be the foundation to a woman’s health in the decades following on from birth. We can view it as an opportunity to really replenish the nutrient stores that we lose from giving birth, tending to our pelvic, hormonal and mental health, meaning a more easeful transition into our menopausal years.</p>
<p>A Postpartum Doula tends to the health and wellbeing of the mother. Saying that, the mother and baby are considered a unit in the months following on from birth, and so tending to the mother directly has an impact on the health and wellbeing of baby. This if often referred to as the mother-baby dyad.</p>
<p><br></p> |
<p><span style="color:rgb(34,34,34);font-size:24px;font-weight:700;">POSTPARTUM DOULA NURTURE SESSION - GIFT VOUCHER (Edinburgh)</span></p>
<p>Jenny's postpartum nurture bundles are ideal for mothers in the days, weeks and in some cases years following on from birth. Jenny also tends to women who have lost a pregnancy at any stage, or a baby. No matter the outcome of a pregnancy, women should always receive postpartum care for their physical, emotional and spiritual wellbeing.</p>
<p>Postpartum care is often something that families do not prepare for, however this can be the foundation to THRIVING family life, and a deep bond between mother and baby. It can also be the foundation to a woman’s health in the decades following on from birth. We can view it as an opportunity to really replenish the nutrient stores that we lose from giving birth, tending to our pelvic, hormonal and mental health, meaning a more easeful transition into our menopausal years.</p>
<p>A Postpartum Doula tends to the health and wellbeing of the mother. Saying that, the mother and baby are considered a unit in the months following on from birth, and so tending to the mother directly has an impact on the health and wellbeing of baby. This if often referred to as the mother-baby dyad.</p>
<p>In-home postpartum care can include:</p>
<ul><li><a href="https://www.instagram.com/reel/CtkF1LpIBA3/?igshid=MzRlODBiNWFlZA%3D%3D">nutritious meals to support postpartum health and replenishment, made with organic ingredients</a></li><li>herbal blends used for teas, steams and bathing</li><li>cacao - Jenny works with this both as nutritional support, and when holding ceremony</li><li>castor-oil heat pads (alleviating pain/discomfort following on from birth)</li><li>scar tissue remediation</li><li>light house work - laundry, dishes, tidying, gardening, food shopping</li><li>sibling care/pet care</li><li>guidance on vaginal steaming (Jenny brings a purpose built chair)</li><li>moxibustion (a Traditional Chinese Medicine practice of burning Moxa, or Chinese Mugwort, in a purpose build moxa box, promoting increased warmth, circulation and qi to the womb area)</li><li>baby wearing support</li><li>gentle oil massage</li><li>postpartum yoga (usually after 6 weeks)</li><li>yoga nidra (suitable for any time after giving birth)</li><li><a href="https://www.innatetraditions.com/blog/Closing-of-the-bones-rebozo">“closing of the bones” using a rebozo</a></li><li>birth storytelling - allowing Mum to feel witnessed in her experience of birth, and all of the emotions surrounding the event</li></ul>
<p>Jenny provides in-home care, so there is a maximum of 30 minutes driving time from EH49 included in the prices. Additional expenses may be added on top of this depending on where your loved one lives.</p> |
|
|
Doula Edinburgh, Doula Scotland, Doula gift, baby shower gift, helpful gift, gifts for new parents, gifts for new mums, gifts for pregnant women, baby shower gifts, best gifts for Mum, new baby |
|
|
<p><b>POSTPARTUM DOULA NURTURE SESSION - GIFT VOUCHER (Edinburgh)</b></p>
<p>Jenny's postpartum nurture bundles are ideal for mothers in the days, weeks and in some cases years following on from birth. Jenny also tends to women who have lost a pregnancy at any stage, or a baby. No matter the outcome of a pregnancy, women should always receive postpartum care for their physical, emotional and spiritual wellbeing.</p>
<p>Postpartum care is often something that families do not prepare for, however this can be the foundation to THRIVING family life, and a deep bond between mother and baby. It can also be the foundation to a woman’s health in the decades following on from birth. We can view it as an opportunity to really replenish the nutrient stores that we lose from giving birth, tending to our pelvic, hormonal and mental health, meaning a more easeful transition into our menopausal years.</p>
<p>A Postpartum Doula tends to the health and wellbeing of the mother. Saying that, the mother and baby are considered a unit in the months following on from birth, and so tending to the mother directly has an impact on the health and wellbeing of baby. This if often referred to as the mother-baby dyad.</p> |
|
260.00000000 |
276M,286 |
2325 |
Yoga Links |
|
postpartum-doula-nurture-session-gift-voucher-edinburgh |
276 |
D |
|
|