Query time 0.00115
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 |
| 398 |
|
P |
A |
17 |
50.00 |
16 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1726563329 |
1766493055 |
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 - £50 Gift Voucher for 1:1 Sleep Support Session |
|
<p><span style="color: rgb(34, 34, 34); font-size: 21px; font-weight: 700;"></span></p>
<h4>VOUCHER for 1:1 Sleep Consultation with Jade Zammit. </h4>
<h4><em>*Exclusive We are The Helpful offer*</em></h4>
<h4>
</h4>
<h4></h4>
<h4>Give the gift of sleep with a little support from Jade Zammit Sleep Coaching. </h4>
<h4></h4>
<h4>This gift is perfect if you know someone who is struggling right now and needs to speak to someone who just <em>gets it</em>. This clarity call can really help and support parents in giving them some direction and gentle techniques to support in their child’s sleep. Support a family today by giving them peace of mind and sleep filled nights. </h4>
<p>
</p>
<h5>Sometimes we can just tell that the lack of sleep is impacting, and they've run out of ideas on what to do next. Or, maybe they've sent you this service as a quiet nudge that they'd love it as a gift.....(we've all been there...!). Whether it's a new baby, returning to work, or changes in the home, giving the gift of sleep support is an absolute luxury.</h5>
<h5>This gift is perfect if you know someone who is struggling right now and needs to speak to someone who just gets it. This clarity call can really help and support parents in giving them some direction and gentle techniques to support in their child’s sleep. Support a family today by giving them peace of mind and sleep filled nights.</h5>
<h4></h4> |
<h4>VOUCHER for 1:1 Sleep Support Session with Jade Zammit. </h4>
<h4><em>*Exclusive We are The Helpful offer*</em></h4>
<h4></h4>
<h4>Give the gift of sleep with a little support from Jade Zammit Sleep Coaching. </h4>
<h4></h4>
<h4>This gift is perfect if you know someone who is struggling right now and needs to speak to someone who just <em>gets it</em>. This clarity call can really help and support parents in giving them some direction and gentle techniques to support in their child’s sleep. Support a family today by giving them peace of mind and sleep filled nights. </h4>
<p><br></p>
<h5>Sometimes we can just tell that the lack of sleep is impacting, and they've run out of ideas on what to do next. Or, maybe they've sent you this service as a quiet nudge that they'd love it as a gift.....(we've all been there...!). Whether it's a new baby, returning to work, or changes in the home, giving the gift of sleep support is an absolute luxury.</h5>
<h5>This gift is perfect if you know someone who is struggling right now and needs to speak to someone who just gets it. This clarity call can really help and support parents in giving them some direction and gentle techniques to support in their child’s sleep. Support a family today by giving them peace of mind and sleep filled nights.</h5>
<p></p>
<p><br></p>
<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>VOUCHER for 1:1 Sleep Consultation with Jade Zammit. </h4>
<h4><em>*Exclusive We are The Helpful offer*</em></h4>
<h4></h4>
<h4>
</h4>
<h4>Give the gift of sleep with a little support from Jade Zammit Sleep Coaching. </h4>
<h4></h4>
<h4>This gift is perfect if you know someone who is struggling right now and needs to speak to someone who just <em>gets it</em>. This clarity call can really help and support parents in giving them some direction and gentle techniques to support in their child’s sleep. Support a family today by giving them peace of mind and sleep filled nights. </h4>
<h4></h4> |
|
50.00000000 |
267M,276,282,286,266,297,301,303 |
70029 |
Beyond The Stars - Jade Sleep Nanny |
|
the-gift-of-sleep-the-s-l-e-e-p-success-course-clone |
267 |
D |
5.00 |
1 |