Query time 0.00298
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 = 375 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": 4,
"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 |
| 375 |
M-LE |
P |
A |
3.49 |
881 |
3.300 |
0 |
0 |
0 |
0.00 |
0 |
1529429619 |
N |
N |
N |
B |
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:5;s:10:"box_height";i:3;} |
N |
1749667342 |
activity |
0 |
1.000 |
Y |
D |
M |
N |
N |
en |
Egyptian Luffa (Loofah) |
|
Luffas (also spelled loofahs) have been used for bathing since the days of the pharaohs. Indeed, these whole luffas are grown in the Nile Delta of Egypt where they get enough sun to grow to mammoth size. They provide an invigorating, gentle scrub to exfoliate dead skin and leave it glowing. Luffas are the fibrous skeletons of fruits from a vegetable in the cucumber and gourd family. All luffas are not created equal. On the left is Luffa aegyptica, which is soft and gentle when wet. The luffa on the right is L. acutangula, hard and rough. Our luffas are unbleached. They are shipped to you dried and compressed. Soak one in water for a minute and it will expand. A whole luffa expands to 20-26 inches long. Cut it into pieces or use it whole. Many people mistakenly think luffas are sea creatures but they grow on a vine. |
<p><strong>The Real Thing</strong></p>
<p>Luffas have been used for bathing since the days of the pharaohs. Indeed, our whole luffas are grown in the Nile Delta of Egypt, where they get enough sun and water to reach mammoth size. They provide an invigorating, gentle scrub to exfoliate dead skin and leave it glowing.</p>
<p><img src="https://www.herbariasoap.com/images/companies/1/AegypticaVsArctangula600-80.jpg?1529434317715" alt="Luffa aegyptica vs L. acutangula" width="600" height="510"></p>
<p><strong>Natural Luffa</strong></p>
<p>Luffas are the fibrous skeletons of fruits from a vegetable in the cucumber and gourd family. The luffa on the right, not ours, is <em>Luffa acutangula</em>, hard and rough, even when wet. On the left is our <em>Luffa aegyptiaca</em>, which is soft and gentle when wet. </p>
<p><img src="https://www.herbariasoap.com/images/companies/1/LuffaWholePackageonWhite-600-80.jpg?1529524010692" alt="Luffa Package" width="600" height="781"></p>
<p><strong>Sizes</strong></p>
<p>Our whole luffas expand to 22-28” long. We offer 5" pieces also. You can cut whole luffas into desired sizes.</p>
<p><strong><img src="https://herbariasoap.com/images/companies/1/womaninbathDegas475-80.jpg?1615327085679" alt="Degas painting of woman in bath" width="475" height="232"></strong></p>
<p><strong>All Natural</strong></p>
<p>We prefer these genuine luffas to plastic poufs for numerous reasons—not being plastic is a start. Our luffas are unbleached. They are shipped to you dried and compressed. Soak one in water for a minute or two, and it will swell to full size.</p>
<p><strong>Multi-Use</strong></p>
<p>Besides bathing and showering, use these natural sponges sink-side to scrub pots and pans. You'll find luffas handy for many jobs such as surface cleaning and car washing. They won't scratch—they're kindly abrasive. </p>
<p><img src="https://www.herbariasoap.com/images/companies/1/Luffasgrowing-80.jpg?1529434808769" alt="Luffa growing" width="600" height="800"></p>
<p><em>Many people mistakenly think luffas are sea creatures—they grow on a vine.</em></p>
<p><strong>A Note of Caution</strong></p>
<p>Bacteria can grow on natural luffas, just like plastic poufs and sponges. Occasionally, sterilize either with diluted bleach.</p>
<p><img src="https://www.herbariasoap.com/images/companies/1/Luffas-600-80.jpg?1566506633556" alt="Luffa Soaps" width="600" height="460"></p>
<p>Looking for our <a href="/luffa-soaps.html">Luffa Soaps</a>?</p>
<h3>Contains</h3>
<ul>
<li><a href="/luffa-soap-category/">luffa</a></li>
</ul>
<p> </p> |
Luffa, loofah, Egyptian Luffa |
Luffas have been used for bathing since the days of the pharaohs. Indeed, our whole luffas are grown in the Nile Delta of Egypt, where they get enough sun and water to reach mammoth size. They provide an invigorating, gentle scrub to exfoliate dead skin a |
|
|
|
|
|
3.49000000 |
6M,217,255,306,337 |
95473 |
Herbaria |
783 |
egyptian-luffa |
6 |
|
|
|