Query time 0.00238
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3.75"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status",
"idx_company_id",
"idx_usergroup_ids"
],
"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",
"weight_lbs",
"weight_oz",
"product_tax_code",
"deleted_at",
"archived_at",
"position"
]
}
},
{
"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": "cd",
"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.00",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"terms"
]
}
},
{
"table": {
"table_name": "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.31",
"eval_cost": "0.10",
"prefix_cost": "0.41",
"data_read_per_join": "24"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "<if>(is_not_null_compl(product_prices), ((`goimagine`.`product_prices`.`lower_limit` = 1) and (`goimagine`.`product_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"table": {
"table_name": "product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "11",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.63",
"eval_cost": "0.10",
"prefix_cost": "1.14",
"data_read_per_join": "5K"
},
"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",
"cls_stop_words",
"how_its_made",
"custom_header"
]
}
},
{
"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.89",
"eval_cost": "0.10",
"prefix_cost": "2.13",
"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.68",
"eval_cost": "0.10",
"prefix_cost": "2.91",
"data_read_per_join": "14K"
},
"used_columns": [
"company_id",
"status"
],
"attached_condition": "<if>(found_match(companies), ((`goimagine`.`companies`.`status` = 'A') or false), true)"
}
},
{
"table": {
"table_name": "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": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.26",
"eval_cost": "0.10",
"prefix_cost": "3.27",
"data_read_per_join": "16"
},
"used_columns": [
"product_id",
"category_id",
"link_type",
"category_position"
]
}
},
{
"table": {
"table_name": "categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"goimagine.products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.01",
"prefix_cost": "3.62",
"data_read_per_join": "134"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "((`goimagine`.`categories`.`storefront_id` in (0,1)) and ((`goimagine`.`categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`goimagine`.`categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`goimagine`.`categories`.`usergroup_ids`))) and (`goimagine`.`categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "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.04",
"eval_cost": "0.01",
"prefix_cost": "3.67",
"data_read_per_join": "86"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "company_descriptions",
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.04",
"eval_cost": "0.01",
"prefix_cost": "3.72",
"data_read_per_join": "88"
},
"used_columns": [
"company_id",
"lang_code",
"company_description"
]
}
},
{
"table": {
"table_name": "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.03",
"eval_cost": "0.01",
"prefix_cost": "3.76",
"data_read_per_join": "1"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
}
]
}
}
}
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 |
weight_lbs |
weight_oz |
product_tax_code |
deleted_at |
archived_at |
position |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
cls_stop_words |
how_its_made |
custom_header |
price |
category_ids |
popularity |
company_name |
terms |
seo_name |
seo_path |
company_description |
discussion_type |
| 209440 |
GI-209440-WVF |
P |
A |
6322 |
25.00 |
1 |
1.000 |
0 |
0 |
0 |
0.00 |
0 |
1650409437 |
1682083714 |
0 |
N |
N |
N |
B |
N |
R |
N |
N |
N |
Y |
10 |
0 |
N |
|
0 |
0 |
0 |
0 |
|
N |
0 |
P |
F |
|
a:5:{s:16:"min_items_in_box";i:1;s:16:"max_items_in_box";i:3;s:10:"box_length";i:9;s:9:"box_width";i:4;s:10:"box_height";i:4;} |
0.000 |
16.000 |
|
|
|
2147483647 |
en |
Relaxing Beeswax Candle with Essential Oils and Crackling Wooden Wick | 9oz Amber Glass Jar | Oasis |
|
|
<p><span style="-webkit-text-size-adjust: 100%;"></span></p>
<p>Our beeswax candles are hand-poured in small batches in Oregon and contain only three ingredients - beeswax, coconut oil & essential oils. </p>
<p>Beeswax candles burn slower and cleaner than soy or paraffin-based candles. When lit, beeswax cleanses the air by emitting negative ions, which trap and neutralize pollutants in the air. </p>
<p>Our wooden wicks burn brightly and crackle lightly, while the amber glass jar adds a warm glow to any room.</p>
<p>OASIS - Turn your home into a peaceful oasis with this candle. The calming scent promotes relaxation, while refreshing and rejuvenating the spirit at the same time. Perfect for those days when you need a little extra self-love.</p>
<p>- ESSENTIAL OILS -<br>• Lavender: contains calming and relaxing properties; promotes peaceful sleep<br>• Eucalyptus: soothing and comforting; effective in helping lessen tension<br>• Rosemary: helps reduce stress levels and nervous tension; boosts mental clarity<br>• Sage: contains clarifying properties; creates a calm and relaxing environment</p>
<p>- PRODUCT DESCRIPTION - <br>• Beeswax sourced from the U.S.<br>• Organic, unrefined coconut oil<br>• Therapeutic grade essential oils - steam distilled or cold pressed<br>• FSC Certified crackling wooden wick - sounds like a mini campfire!<br>• 9 oz amber glass jar with black metal lid - totally recyclable & re-usable!<br>• Burn time: approximately 50 hours</p>
<p>Please note that since each candle is handmade, slight variations may occur. Also, essential oils have a lighter scent when heated compared to synthetic fragrance oils. As such, our candles have a gentler throw and will not overpower the room with scent.<br></p>
<p>**Also available as a 7oz matte black tin!</p>
<p>---</p>
<p>Save 15% off your order now when you sign up for our free newsletter! <a href="https://mailchi.mp/19dc5dc5e203/berrylanegoods" target="_blank" data-saferedirecturl="https://www.google.com/url?q=https://mailchi.mp/19dc5dc5e203/berrylanegoods&source=gmail&ust=1670280930258000&usg=AOvVaw0Rg2XmJ7HWpcIBzl0ifAZd">https://mailchi.mp/19dc5dc5e203/berrylanegoods</a></p> |
|
|
candle, beeswax essential oil candle, coconut soy candle, mason jar candle, wood wick candle, spring candle, holiday gift, natural candle, Mother's Day gift, amber jar candle, soy beeswax, handmade gift |
Beeswax Candle with Essential Oils and Crackling Wooden Wick |
|
<p>This product ships within 1-3 business days.</p> |
|
|
|
25.00000000 |
99M |
1641 |
Berry Lane Goods |
<h6><b style="color: rgb(51, 51, 51);">Shipping</b></h6>
<p>Orders usually ship within 1-2 business days and are carried out by USPS. Upon shipping, you will receive a confirmation email containing the tracking number. Please note, estimated shipping times are from the time of shipping, not the time of order. Berry Lane Goods is not responsible for any shipping delays that USPS encounters.</p><p>Additionally, Berry Lane Goods only ships orders between Monday and Friday. Orders placed on Friday will ship out the following Monday.</p>
<h6>Recycling/Re-using</h6>
<p>To remove the remaining wax & re-use your candle container, place the jar in a pot of simmering water. Once all the wax has melted, pour out the wax and remove the wooden wick. Wash with warm, soapy water and ta-da! Your jar is as good as new :)</p>
<h6>I gladly accept cancellations</h6>
<p>Please request a cancellation before the item has shipped.</p>
<h6>I don't accept returns or exchanges</h6>
<p>But please contact me if you have any problems with your order.</p> |
beeswax-candle-with-essential-oils-and-crackling-wooden-wick-breathe-clone |
4/99 |
<p>Hi there! My name is Mari, and I’m the founder of Berry Lane Goods. I’m a mama, wife & lover of all things DIY. An autoimmune condition prompted me to make changes to my lifestyle and incorporate a more natural way of living. Somewhere along the way, I started creating my own clean-burning, natural candles. And thus, Berry Lane Goods was born!<br><br>My candles are free from synthetic waxes and chemical-based fragrance oils. I only use clean ingredients, such as beeswax, coconut oil and essential oils - all pure and sourced from nature!<br><br>All my products are handmade by yours truly and are definitely a labor of love! I hope you enjoy all of my creations. Thank you for taking the time to visit my shop! I appreciate you!</p> |
D |