Query time 0.00145
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "4.47"
},
"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": 8,
"rows_produced_per_join": 8,
"filtered": "100.00",
"cost_info": {
"read_cost": "2.00",
"eval_cost": "0.80",
"prefix_cost": "3.45",
"data_read_per_join": "128"
},
"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.04",
"prefix_cost": "4.25",
"data_read_per_join": "1K"
},
"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.10",
"eval_cost": "0.04",
"prefix_cost": "4.39",
"data_read_per_join": "694"
},
"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.04",
"prefix_cost": "4.43",
"data_read_per_join": "9"
},
"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.04",
"prefix_cost": "4.47",
"data_read_per_join": "6"
},
"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 |
| 399 |
|
P |
A |
17 |
100.00 |
16 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1726564013 |
1766493036 |
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 |
THE GIFT OF SLEEP - Sleep Support Membership |
|
<p><span style="color: rgb(34, 34, 34); font-size: 21px; font-weight: 700;"></span></p>
<h4>Sleep Support Membership with Jade Zammit. </h4>
<h4></h4>
<h4>Give the gift of sleep with a little support from Jade Zammit Sleep Coaching.</h4>
<h5></h5>
<h5>Baby sleep can bring a rollercoaster of changes, between nap transitions, development leaps and so much more. This membership is all about navigating change and bringing consistently great sleep for families. Includes weekly group support calls, access to the S.L.E.E.P Success Course, monthly masterclasses and key speaker sessions.</h5>
<h5>This is a perfect gift for baby showers, a parent with a new baby or for any family where sleep is constantly changing. This brings confidence, support and gentle tools and methods to bring consistently great sleep!</h5> |
<h4>Sleep Support Membership with Jade Zammit. </h4>
<h4></h4>
<h4>Give the gift of sleep with a little support from Jade Zammit Sleep Coaching.</h4>
<h5></h5>
<h5>Baby sleep can bring a rollercoaster of changes, between nap transitions, development leaps and so much more. This membership is all about navigating change and bringing consistently great sleep for families. Includes weekly group support calls, access to the S.L.E.E.P Success Course, monthly masterclasses and key speaker sessions.</h5>
<h5>This is a perfect gift for baby showers, a parent with a new baby or for any family where sleep is constantly changing. This brings confidence, support and gentle tools and methods to bring consistently great sleep!
</h5>
<p></p>
<h4>The S.L.E.E.P Success Club for littles to age seven. Membership includes:</h4>
<ul><li><span class="wixui-rich-text__text">Monthly Workshops: </span><span class="wixui-rich-text__text">Virtual Workshops within the group<b> - Topics</b> to include - Responsive Settles, Early Rising, Night Awakenings, Development changes, Co-sleeping, Sleep Safety & More</span></li><li><span class="wixui-rich-text__text">Key Speaker Sessions: </span><span class="wixui-rich-text__text"><span class="wixui-rich-text__text"><b>Monthly Workshops</b> from <b>key speakers and Specialists</b> with everything from feeding, behaviours baby first aid to returning to work coaching & mentors!</span></span></li><li><span class="wixui-rich-text__text">Mindset & Goals: </span><span class="wixui-rich-text__text">Focus on growth mindset, plan <b>ultimate sleep goals</b> and have a space for accountability!</span>
<span class="wixui-rich-text__text"><b>Monthly goal sessions where Jade will give the best tips on</b> taking actionable steps to improve sleep!</span></li><li><span class="wixui-rich-text__text">Sleep Support Sessions: </span><span class="wixui-rich-text__text"><b>Weekly Online Support Sessions to ask questions and get guidance from Jade. </b>Plus a community filled with others for support (like a new sleep support family).</span></li><li><span class="wixui-rich-text__text">Mastering Sleep: </span><span class="wixui-rich-text__text">Not only will they have access to guides for their little one's age and beyond - but they'll have optional <b>BONUS</b> content with <b>lifetime access to my "S.L.E.E.P Success" Step by Step Course </b>to fully guide through every step of the way, with in depth training sessions.</span></li><li><span class="wixui-rich-text__text">Exclusives: </span><span class="wixui-rich-text__text"><b>Priority Access</b> to 1-1 Support and additional programs</span>
<span class="wixui-rich-text__text"><b>Exclusive Discounts </b>& Access to additional courses and events.</span></li></ul>
<h5></h5>
<h5>About Jade Zammit</h5>
<p>Based in Midlothian on the outskirts of Edinburgh, Scotland, Jade is a qualified expert in Infant & Child Sleep, and there are so many reasons why she truly loves what she does as a coach and consultant. Transforming families from a place of pain, stress and exhaustion to happy rested nights is what she does best. Jade is also a self-confessed "sleep geek", with a love for the science and psychology behind child sleep. So you are in good hands.</p>
<p><span class="wixui-rich-text__text">Jade has also qualified as a ADHD Sleep Awareness Practitioner. Working with super alert little ones and toddlers has always been a speciality, allowing her to open up support avenues for families with really alert and stimulated little ones and for older diagnosed children with ADHD.</span></p>
<p><span class="wixui-rich-text__text"></span>Over the last 2 years Jade has received awards globally for her services and online programs, ensuring the standard that she promises to provide to families. </p>
<p>Jade is here and ready to help support the ones you love, by helping them the ultimate luxury and support - <strong><em>sleep</em></strong>.</p> |
|
|
Sleep support, help with sleep, child sleep, 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, practical gifts, how to help them sleep, help sleeping |
|
|
<h4></h4>
<h4>Sleep Support Membership with Jade Zammit. </h4>
<h4></h4>
<h4>Give the gift of sleep with a little support from Jade Zammit Sleep Coaching.</h4>
<h5></h5>
<h5>Baby sleep can bring a rollercoaster of changes, between nap transitions, development leaps and so much more. This is a perfect gift for baby showers, a parent with a new baby or for any family where sleep is constantly changing. This brings confidence, support and gentle tools and methods to bring consistently great sleep!</h5>
<p><br></p>
<p><br></p> |
|
100.00000000 |
267M,276,282,286,266,297,301,303 |
69033 |
Beyond The Stars - Jade Sleep Nanny |
|
the-gift-of-sleep-50-gift-voucher-for-1-1-sleep-support-session-clone |
267 |
D |
5.00 |
1 |