Query time 0.00115
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "28.39"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"idx_products_inventory"
],
"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": "5K"
},
"used_columns": [
"product_id",
"product_code",
"status",
"company_id",
"list_price",
"shipping_params"
]
}
},
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "const",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id",
"idx_product_prices_usergroup_limit",
"idx_prices_discount_lookup",
"idx_prices_min_calc",
"idx_prices_usergroup_lookup",
"idx_prices_usergroup_product"
],
"key": "usergroup",
"used_key_parts": [
"product_id",
"usergroup_id",
"lower_limit"
],
"key_length": "9",
"ref": [
"const",
"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": "24"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
]
}
},
{
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id",
"idx_product_desc_lang",
"idx_product_name_search",
"idx_product_desc_sort"
],
"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.00",
"data_read_per_join": "4K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"short_description",
"full_description",
"promo_text"
]
}
},
{
"table": {
"table_name": "pc",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"link_type",
"pt",
"idx_product_category_lookup",
"idx_products_categories_composite"
],
"key": "idx_products_categories_composite",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 1,
"filtered": "50.00",
"using_index": true,
"cost_info": {
"read_cost": "0.33",
"eval_cost": "0.10",
"prefix_cost": "0.53",
"data_read_per_join": "16"
},
"used_columns": [
"product_id",
"category_id",
"link_type"
],
"attached_condition": "(`cscart_db`.`pc`.`link_type` = 'M')"
}
},
{
"table": {
"table_name": "cc",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"parent",
"p_category_id",
"idx_categories_parent_status"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"cscart_db.pc.category_id"
],
"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.88",
"data_read_per_join": "2K"
},
"used_columns": [
"category_id",
"parent_id"
]
}
},
{
"table": {
"table_name": "cd",
"access_type": "ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"cscart_db.cc.parent_id"
],
"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": "1.23",
"data_read_per_join": "3K"
},
"used_columns": [
"category_id",
"category"
]
}
},
{
"table": {
"table_name": "cscart_product_review_prepared_data",
"access_type": "ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.72",
"eval_cost": "0.20",
"prefix_cost": "2.15",
"data_read_per_join": "32"
},
"used_columns": [
"product_id",
"average_rating"
]
}
},
{
"table": {
"table_name": "opr",
"access_type": "ref",
"possible_keys": [
"idx_product_id",
"idx_product_reviews_status"
],
"key": "idx_product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 6,
"rows_produced_per_join": 12,
"filtered": "100.00",
"cost_info": {
"read_cost": "9.95",
"eval_cost": "1.20",
"prefix_cost": "13.31",
"data_read_per_join": "19K"
},
"used_columns": [
"product_id",
"rating_value",
"status"
],
"attached_condition": "<if>(is_not_null_compl(opr), (`cscart_db`.`opr`.`status` = 'A'), true)"
}
},
{
"table": {
"table_name": "pfv",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"product_id",
"fpl",
"idx_product_feature_variant_id",
"fl"
],
"key": "idx_product_feature_variant_id",
"used_key_parts": [
"product_id",
"feature_id"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 12,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "7.12",
"eval_cost": "1.20",
"prefix_cost": "21.62",
"data_read_per_join": "480"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id"
]
}
},
{
"table": {
"table_name": "pvd",
"access_type": "ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id"
],
"key_length": "3",
"ref": [
"cscart_db.pfv.variant_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 12,
"filtered": "100.00",
"cost_info": {
"read_cost": "5.49",
"eval_cost": "1.27",
"prefix_cost": "28.39",
"data_read_per_join": "95K"
},
"used_columns": [
"variant_id",
"variant"
]
}
}
]
}
}
Result
| product_id |
product_code |
status |
company_id |
list_price |
shipping_params |
average_rating |
product |
short_description |
full_description |
promo_text |
actual_rating |
category |
category_id |
main_category |
variant_id |
variant |
price |
| 9552 |
GG-01 |
A |
13 |
575.00 |
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;} |
4.83 |
Grow and Glow | Hair Fall Control & Glowing Skin | 30 gummies |
<p><strong>Hair & Skin Gummies with Biotin</strong></p> |
<p><strong>PERFECT BLEND OF PROBIOTICS, NATURAL EXTRACTS AND VITAMINS: Happy Cultures Grow (Hair) & Glow (Skin) Gummies is for all women and men Packed with the Power of Probiotics along with Biotin, Brahmi, Sesbania, Vitamin C, Hyaluronic Acid, Collagen Type 1 and Sea Buckthorn for healthy hair and skin. Gummies promote fast and proper absorption of the nutrients, resulting in improved visible health of hair & Skin. <br /> DELICIOUS GUMMIES WITH NO ADDED SUGAR: Happy Cultures Hair & Skin Gummies Rejuvenate your skin and strengthen your hair without any synthetic sugars. Say GOODBYE to the boring biotin pills and choose the amazing Grow & Glow Gummies, which will make you want to stick to the healthy habit of daily nutrition for hair & Skin with easy to Carry along with Your Busy Schedules.<br /> <br /> INDIAN STRAIN FOR INDIAN GUT: NATURALLY TASTY GUMMIES: As Indians, our unique dietary patterns and environmental factors necessitate probiotic strains specifically tailored to our needs. At Happy Cultures, we source probiotic strains best suited for Indians. Happy Cultures Grow & Glow Health gummy vitamins have an orange flavour, making it enjoyable and simple to receive your daily wellness dose.<br /> Happy Cultures Grow (Hair) & Glow (Skin) Gummies: A delicious blend of essential nutrients in these Probiotics gummies helps boost hair growth, hydrate skin, and maintain Glow. We have Biotin, Brahmi, Sesbania, Vitamin C, Hyaluronic Acid, Collagen Type 1 and Sea Buckthorn for healthy hair and skin. Biotin & Brahmi for hair growth is highly recommended. Hyaluronic Acid & Collagen Type 1 for Tighten Skin, Reducing Face Wrinkles.<br /> <br /> Nourishes Hair from Roots to Tips & Promotes Healthy Hair Growth: Biotin, Sesbania & Brahmi promote healthy hair growth, strength and shine. Biotin, Brahmi, and sesbania work together to strengthen hair follicles and promote growth. Enriched with Biotin from natural source Sesbania extract and essential vitamins to support stronger, healthier hair and control hair fall.<br /> ENHANCES SKIN RADIANCE: Our Hair and Skin Gummies with Hyaluronic Acid & Collagen Type 1 which we have in Grow & Glow Specially Designed to Tighten Skin, Reducing Face Wrinkles Over Time. Our Probiotics Gummies Contains a Blend of sea Buckthorn & hyaluronic Acid that helps in Hydrating skin from inside. <br /> <br /> HYALURONIC ACID, COLLAGEN TYPE 1, PROBIOTICS & SEA BUCKTHORN IN GROW & GLOW Our Hair & Skin Gummies Helps in Keeping Skin Hydrated & Plumpy by Locking Moisture in Deep Skin. It Sinks deep into the skin to deliver the best nourishing results. Altogether, it brightens, hydrates and protects your skin. The presence of hyaluronic acid gives a soft touch to the skin and keeps the skin hydrated.<br /> <br /> SUPPORTS OVERALL BEAUTY AND WELLNESS THROUGH PROBIOTIC GUMMIES: Our Hair & Skin Gummies, we only source the best ingredients to ensure your safety that are backed by clinical research and have the highest potency. This is a non-GMO. We believe taking your Gummies shouldnt be a task. So, we made these naturally tasty Probiotics gummies, with Biotin, Hyaluronic Acid, Collagen type 1, Sea Buckthorn which helps in strengthening your hair, reduce hair fall, brighten & hydrate your skin. These Probiotics gummies are easy to consume & super tasty. <br />SUITABLE FOR MEN AND WOMEN: POP, CHEW, RADIANT YOU: Ideal for anyone seeking to improve hair & skin with a delicious supplement. (Men and women above the age of 18).</strong></p> |
<ul><li>Use<strong> KLOVE</strong> & Get flat 5% off orders above Rs. 999.</li><li>Use<strong> GLOW10</strong> & Get Flat 10% off on orders above Rs. 1799.</li></ul> |
4.8333 |
Haircare |
2759 |
2764 |
60580 |
Happy Cultures |
546.250000 |