Query time 0.00147
JSON explain
{
"query_block": {
"select_id": 1,
"table": {
"table_name": "shared_prices",
"access_type": "system",
"possible_keys": [
"usergroup",
"product_id",
"company_id",
"lower_limit",
"usergroup_id"
],
"rows": 0,
"filtered": 0,
"const_row_not_found": true
},
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": ["PRIMARY", "status"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "companies",
"access_type": "system",
"possible_keys": ["PRIMARY"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": ["PRIMARY", "total"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_product_sales",
"access_type": "const",
"possible_keys": ["PRIMARY", "pa"],
"key": "PRIMARY",
"key_length": "6",
"used_key_parts": ["category_id", "product_id"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_product_prices",
"access_type": "range",
"possible_keys": ["product_id"],
"key": "product_id",
"key_length": "9",
"used_key_parts": ["product_id", "lower_limit", "usergroup_id"],
"rows": 2,
"filtered": 100,
"attached_condition": "trigcond(1) and trigcond(cscart_product_prices.product_id = 313 and cscart_product_prices.lower_limit = 1 and cscart_product_prices.usergroup_id in (0,0,1))"
},
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "const",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["product_id", "lang_code"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_product_descriptions.lang_code = 'en')"
},
"table": {
"table_name": "cscart_products_categories",
"access_type": "ref",
"possible_keys": ["PRIMARY", "pt"],
"key": "pt",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 3,
"filtered": 100
},
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "c_status"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["category_id"],
"ref": ["herbaria_cscart_4_18.cscart_products_categories.category_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "cscart_categories.storefront_id in (0,1) and (cscart_categories.usergroup_ids = '' or find_in_set(0,cscart_categories.usergroup_ids) or find_in_set(1,cscart_categories.usergroup_ids)) and cscart_categories.`status` in ('A','H')"
},
"table": {
"table_name": "cscart_seo_names",
"access_type": "const",
"possible_keys": ["PRIMARY", "dispatch"],
"key": "PRIMARY",
"key_length": "210",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code",
"company_id"
],
"ref": ["const", "const", "const", "const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en')"
},
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": ["object_id", "idx_company_id"],
"key": "object_id",
"key_length": "10",
"used_key_parts": ["object_id", "object_type", "company_id"],
"ref": ["const", "const", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(cscart_discussion.object_type = 'P')"
},
"table": {
"table_name": "cscart_product_review_prepared_data",
"access_type": "const",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "7",
"used_key_parts": ["product_id", "storefront_id"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100
}
}
}
Result
| product_id |
product_code |
product_type |
status |
list_price |
amount |
weight |
length |
width |
height |
shipping_freight |
low_avail_limit |
timestamp |
is_edp |
edp_shipping |
unlimited_download |
tracking |
free_shipping |
zero_price_action |
is_pbp |
is_op |
is_oper |
company_id |
is_returnable |
return_period |
avail_since |
localization |
min_qty |
max_qty |
qty_step |
list_qty_count |
tax_ids |
age_verification |
age_limit |
usergroup_ids |
options_type |
exceptions_type |
details_layout |
shipping_params |
out_of_stock_actions |
updated_timestamp |
facebook_obj_type |
parent_product_id |
cp_bar |
cp_seo_use_addon |
cp_seo_no_index |
cp_sr_variation_type |
cp_fake_product |
cp_not_crop_auto |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
cp_contents |
price |
category_ids |
popularity |
company_name |
sales_amount |
seo_name |
seo_path |
discussion_type |
average_rating |
product_reviews_count |
| 313 |
B-NM1 |
P |
A |
7.49 |
100 |
2.850 |
0 |
0 |
0 |
0.00 |
0 |
1418277600 |
N |
N |
N |
D |
N |
R |
N |
N |
N |
1 |
Y |
10 |
0 |
|
0 |
0 |
0 |
0 |
7,8,9 |
N |
0 |
0 |
P |
F |
default |
a:5:{s:16:"min_items_in_box";i:1;s:16:"max_items_in_box";i:100;s:10:"box_length";i:5;s:9:"box_width";i:1;s:10:"box_height";i:1;} |
N |
1749671250 |
activity |
0 |
1.000 |
Y |
D |
M |
N |
N |
en |
Neem Oil |
|
Neem has been valued for thousands of years in India. We at Herbaria find it most helpful. Pressed from the fruits and seeds of the tropical neem tree, Azadirachta indica, our Neem Oil is virgin and cold pressed. Neem oil separates in the bottle. You will see solids when you lift the dropper. To reblend, gently warm the bottle. The oil will remain uniform for quite some time. |
<p class="pquote">"Drug companies don't want you to know how well this works."</p>
<p class="pquotedperson">Ken Gilberg, St. Louis</p>
<p> </p>
<p><strong>Nature's Pharmacy</strong></p>
<p>Before you turn to over-the-counter topical steroidal medications, anti-fungal creams, or anti-bacterial ointments, consider Neem Oil. It has been valued for thousands of years in India, where it’s called "heal-all" or "nature’s pharmacy." We at Herbaria find it most helpful.</p>
<p><strong><img src="https://herbariasoap.com/images/companies/1/Neem_seed475-70.jpg?1613763869524" alt="Neem seeds" width="475" height="317"></strong></p>
<p><strong>An Ayurvedic Treasure</strong></p>
<p>Neem is said to be antifungal, antibacterial, and antiviral. Neem oil is pressed from the fruits and seeds of the tropical neem tree, <em>Azadirachta indica</em>. Our Neem Oil is virgin and cold-pressed. It is packed with phytonutrients and natural steroids.</p>
<p><strong>Why Many Haven't Heard of Neem</strong></p>
<p>In the book, <em>Around the World in 80 Trees </em>(2018), author Jonathan Drori writes, "Neem has a long tradition of use, which makes it difficult for commercial firms to patent products based on it. Without being able to protect the product from competition, those firms have little incentive to pay for regulatory approval of neem oil products, or for advertising and distribution. Companies can more profitably sell patentable synthetic chemicals, even though in some instances they may be less effective or more harmful. The free market doesn't always get it right."</p>
<p><strong>Using Neem</strong></p>
<p>Neem oil separates in the bottle. You will see solids when you lift the dropper. To reblend, gently warm the bottle. The oil will remain uniform for quite some time.</p>
<p><strong>Unique Scent</strong></p>
<p>"It stinks," you may say. It smells like sulfur, burnt tires, and onions. But it’s a fascinating scent—quite the conversation starter. It really doesn’t smell that bad. Indians love it. However, you probably don’t want to apply it just before a date.</p>
<p> </p>
<div class="divCalloutCenter">
<p class="pquote">"Whenever I get a little outbreak of eczema, I treat it with some neem!"</p>
<p class="pquotedpersonlast">John H., Athens, GA</p>
<p class="pquote">"We took our dog to the vet for these bumps all over her back. The vet didn’t know what the bumps were from but wanted to give her antibiotics. That didn’t sound right. We didn’t want to overuse antibiotics which might upset her system. We used neem oil instead. In just a day, her skin was smooth again."</p>
<p class="pquotedpersonlast">Martin Larson, St. Louis, MO</p>
<p class="pquote">"I use neem on athlete's foot and cracked toes."</p>
<p class="pquotedpersonlast">Bill Lawson, Naples, FL</p>
</div>
<p><strong>Neem as Insecticide</strong></p>
<p>Neem is used in the garden as an insecticide against over 200 species, particularly small soft-bodied pests, such as whiteflies and aphids. A simple dilution of neem is effective against eggs and immature insects. It won’t kill them immediately, as poisons do. Neem works by disturbing insect hormones, growth, and feeding. Neem also prevents powdery mildew and black spot. Use it on roses, fruit trees, and vegetables.</p>
<p>To make a batch of neem spray, shake one tablespoon of Neem Oil and a half teaspoon of dish detergent in a half-gallon of warm water.</p>
<p><strong>Caution</strong></p>
<p>Neem should not be used by children, pregnant or nursing women, men, and women trying to conceive, or those with auto-immune diseases. We do not recommend Neem Oil for internal use. It’s okay to use neem on non-breeding cats and dogs.</p>
<h3>Contains</h3>
<ul>
<li><a href="/products-by-ingredient/emollients/neem-oil-soaps/">neem oil</a></li>
<li><strong>nothing else</strong></li>
</ul>
<h3>Product Categories</h3>
<ul>
<li><a href="/dog-care">dog care</a></li>
<li><a href="/moisturizers">moisturizers</a></li>
</ul>
<div id="divProductDetailIncentiveValue">
<p>Each bottle of Neem Oil counts as 1 bar toward our <a href="/free-bar-offer-details.html">free bar offer</a>.</p>
</div> |
|
Ayurvedic medicine deems it antifungal, antibacterial, antiviral. In India it’s called “heal all,” “nature’s drugstore.” Free shipping on orders over $60. Enjoy all our excellent face and body soaps plus other personal products. |
|
Herbaria Neem Oil - Cold Pressed - Virgin |
|
|
|
7.49000000 |
228M,175,267,306 |
111136 |
Herbaria |
380 |
neem-oil |
228 |
|
|
|