Query time 0.00499
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 |
| 402 |
|
P |
A |
22 |
250.00 |
1 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1726576105 |
1766492971 |
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 |
Full antenatal weekend course for two - GROW + GATHER (GIFT VOUCHER - Edinburgh) |
|
<h4><span style="color: var(--redactor2-fg-heading);">Full antenatal weekend course for two - the gift of preparation and peace of mind when they are preparing to welcome a new little love into the world.</span></h4>
<p><b><em>**Classes are located in Edinburgh**</em></b></p>
<p>Perhaps friends or colleagues are coming together to buy a gift. Rather than a piece of equipment or more clothes for baby, our full weekend of classes would make a perfect baby gift. Led my qualified midwives the weekend sessions focus on preparing for labour and birth, what to expect as well as a full day focused on going home with baby and time to practice skills like using a sling and swaddling. This antenatal weekend course also includes the active birth class as part of the package. For expectant folk and birth partner.</p>
<p><span style="color: var(--redactor2-fg-heading); font-size: 18px; font-weight: 700;">COURSE INCLUDES:</span><br></p>
<p><span class="wixui-rich-text__text"><b>SATURDAY</b></span></p>
<ul><li>Labour and Birth</li><li>Coping at home</li><li>When to call Hospital</li><li>Birth Places</li><li>Stages of Labour</li><li>Role of the birth partner</li><li>Birth environment</li><li>All types of birth</li><li>Pain relief options</li></ul>
<p><span class="wixui-rich-text__text"><b>SUNDAY</b></span></p>
<ul><li>Going Home with Baby</li><li>Safe Sleeping</li><li>Swaddling</li><li>Out and about</li><li>Managing a crying baby</li><li>How to bath a baby </li><li>Feeding your baby</li></ul> |
<h4><span style="color: var(--redactor2-fg-heading);">Full antenatal weekend course for two - the gift of preparation and peace of mind when they are preparing to welcome a new little love into the world.</span></h4>
<p><b><em>**Classes are located in Edinburgh**</em></b></p>
<p>Perhaps friends or colleagues are coming together to buy a gift. Rather than a piece of equipment or more clothes for baby, our full weekend of classes would make a perfect baby gift. Led my qualified midwives the weekend sessions focus on preparing for labour and birth, what to expect as well as a full day focused on going home with baby and time to practice skills like using a sling and swaddling. This antenatal weekend course also includes the active birth class as part of the package. For expectant folk and birth partner.</p>
<p></p>
<h5>COURSE INCLUDES:</h5>
<p><span class="wixui-rich-text__text"><b><span class="wixui-rich-text__text">SATURDAY</span></b></span></p>
<ul><li>Labour and Birth</li><li>Coping at home</li><li>When to call Hospital</li><li>Birth Places</li><li>Stages of Labour</li><li>Role of the birth partner</li><li>Birth environment</li><li>All types of birth</li><li>Pain relief options</li></ul>
<p><span class="wixui-rich-text__text"><b><span class="wixui-rich-text__text">SUNDAY</span></b></span></p>
<ul><li>Going Home with Baby</li><li>Safe Sleeping</li><li>Swaddling</li><li>Out and about</li><li>Managing a crying baby</li><li>How to bath a baby </li><li>Feeding your baby</li></ul>
<p><br></p>
<h4>About Grow + Gather</h4>
<p><span class="wixui-rich-text__text">Meet Hannah + Hayley; they're friends who are both Midwives.</span></p>
<p><span class="wixui-rich-text__text"><span class="wixui-rich-text__text">After years of working with expectant families in India, Costa Rica, Uganda, London and all over Scotland, Hannah + Hayley decided to bring together their experience in midwifery, yoga and hypnobirthing and co-founded Grow + Gather.</span></span></p>
<p>Now settled in Edinburgh, Hannah + Hayley work with pregnant women and their families in their roles as NHS midwives. Hannah is a hypnobirthing teacher and Hailey is an antenatal and postnatal yoga instructor and met whilst working in the same community midwifery team.</p>
<p><span class="wixui-rich-text__text"><span class="wixui-rich-text__text"></span></span><span class="wixui-rich-text__text"><span class="wixui-rich-text__text">Both Hannah + Hayley are passionate about antenatal education and want to make sure all expectant parents are equipped for labour and parenthood; a journey that is both exciting and daunting. They</span></span><span class="wixui-rich-text__text"><span class="wixui-rich-text__text"> love to bring together local parents within relaxed and informal settings, ensuring you get the chance to meet other expectant parents in an atmosphere that is friendly and informative. Regardless of whether or not you join us for antenatal classes, 1:1 sessions or active birth workshops; our classes are honest, evidence-based and great fun.</span></span></p>
<p><br></p> |
|
|
Postnatal support, Antenatal course Edinburgh, postnatal support 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, Feeding Support Edinburgh, Breastfeeding support Edinburgh |
|
|
<h4><span style="color: var(--redactor2-fg-heading);">Full antenatal weekend course for two - the gift of preparation and peace of mind when they are preparing to welcome a new little love into the world.</span></h4>
<p><b><em>**Classes are located in Edinburgh**</em></b></p> |
|
250.00000000 |
276M,286 |
2442 |
Grow+Gather |
|
active-birth-class-grow-gather-edinburgh-clone |
276 |
D |
|
|