Query time 0.00266
JSON explain
{
"query_block": {
"select_id": 1,
"cost": 0.030090378,
"filesort": {
"sort_key": "descr1.product, products.product_id",
"temporary_table": {
"filesort": {
"sort_key": "case when products.parent_product_id <> 0 then products.parent_product_id else products.product_id end",
"temporary_table": {
"nested_loop": [
{
"table": {
"table_name": "cscart_categories",
"access_type": "const",
"possible_keys": ["PRIMARY", "c_status", "p_category_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["category_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": ["PRIMARY", "pt"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["category_id"],
"ref": ["const"],
"loops": 1,
"rows": 5,
"cost": 0.00260527,
"filtered": 100
}
},
{
"table": {
"table_name": "products",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status",
"idx_master_product_id",
"wdbi_master_product_status_master_product_id_produc_46b93429beec",
"wdbi_master_product_id_master_product_status_produc_611007cab252",
"wdbi_master_product_id_master_product_status_produc_37d8c9a2112a",
"wdbi_master_product_id_master_product_status_status_1d4dcd83320a",
"wdbi_master_product_id_master_product_status_produc_909a0cf2d55b",
"wdbi_master_product_id_master_product_status_status_ff7ba2ae2fb0"
],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": [
"u985510652_ecartify_abhi.products_categories.product_id"
],
"loops": 5,
"rows": 1,
"cost": 0.0085682,
"filtered": 100,
"attached_condition": "products.master_product_id = 0 and (products.usergroup_ids = '' or find_in_set(0,products.usergroup_ids) or find_in_set(1,products.usergroup_ids)) and products.`status` = 'A' and products.master_product_status = 'A' and products.product_type <> 'D'"
}
},
{
"table": {
"table_name": "var_val_18",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"fl",
"variant_id",
"lang_code",
"product_id",
"fpl",
"idx_product_feature_variant_id"
],
"key": "variant_id",
"key_length": "15",
"used_key_parts": [
"variant_id",
"feature_id",
"product_id",
"lang_code"
],
"ref": [
"const",
"const",
"u985510652_ecartify_abhi.products_categories.product_id",
"const"
],
"loops": 5,
"rows": 1,
"cost": 0.008468025,
"filtered": 33.33333206,
"attached_condition": "var_val_18.lang_code = 'en'",
"using_index": true
}
},
{
"table": {
"table_name": "companies",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "4",
"used_key_parts": ["company_id"],
"ref": ["u985510652_ecartify_abhi.products.company_id"],
"loops": 1.666666667,
"rows": 1,
"cost": 0.002309933,
"filtered": 100,
"attached_condition": "trigcond(companies.`status` = 'A' or products.company_id = 0)"
}
},
{
"table": {
"table_name": "master_products_storefront_offers_count",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "idx_storefront_id"],
"key": "PRIMARY",
"key_length": "8",
"used_key_parts": ["product_id", "storefront_id"],
"ref": [
"u985510652_ecartify_abhi.products_categories.product_id",
"const"
],
"loops": 1.666666667,
"rows": 1,
"cost": 0.002309933,
"filtered": 100,
"attached_condition": "trigcond(products.company_id > 0 or master_products_storefront_offers_count.count > 0) and trigcond(master_products_storefront_offers_count.product_id = products_categories.product_id)"
}
},
{
"table": {
"table_name": "descr1",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "product_id"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["product_id", "lang_code"],
"ref": [
"u985510652_ecartify_abhi.products_categories.product_id",
"const"
],
"loops": 1.666666667,
"rows": 1,
"cost": 0.002856067,
"filtered": 100,
"attached_condition": "trigcond(descr1.lang_code = 'en')"
}
},
{
"table": {
"table_name": "prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id",
"wdbi_product_id_lower_limit_usergroup_id_price_eff1727beeef",
"wdbi_usergroup_id_lower_limit_product_id_92b7e8f6a250",
"wdbi_product_id_lower_limit_usergroup_id_price_perc_3b2301d551d0",
"wdbi_lower_limit_usergroup_id_product_id_b93629431718"
],
"key": "usergroup",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": [
"u985510652_ecartify_abhi.products_categories.product_id"
],
"loops": 1.666666667,
"rows": 1,
"cost": 0.00297295,
"filtered": 100,
"attached_condition": "prices.lower_limit = 1 and prices.usergroup_id in (0,0,1)"
}
}
]
}
}
}
}
}
}
Result
| product_id |
product |
company_name |
product_ids |
product_types |
parent_product_ids |
product_type |
parent_product_id |
master_product_offers_count |
master_product_id |
company_id |
full_description |
short_description |
| 786975 |
White Elegant lighting monaco 8 light chandelier |
AutoZone |
786975 |
P |
0 |
P |
0 |
0 |
0 |
17 |
<p>The Elegant Lighting Monaco 8-Light Chandelier is a stunning statement lighting fixture designed to bring sophistication, warmth, and a luxurious touch to any interior. Featuring eight beautifully arranged lights, this chandelier provides ample illumination while creating an elegant focal point in dining rooms, living areas, entryways, bedrooms, and other stylish spaces.</p>
<p>Its refined design combines classic elegance with a contemporary aesthetic, making it easy to complement a wide range of interior styles. The carefully crafted frame and balanced eight-light configuration add visual appeal while ensuring light is distributed beautifully throughout the room. Whether you are refreshing your home décor or creating an upscale atmosphere, the Monaco 8-Light Chandelier adds a distinctive decorative element to your space.</p>
<p>Perfect for both everyday lighting and special occasions, this chandelier can enhance the ambiance of your home with its graceful presence and inviting illumination. Its sophisticated appearance makes it an excellent choice for homeowners looking to create a polished, comfortable, and luxurious environment.</p> |
|