ShowCatalog.php#80descuento2.11sselect*from products FORCE INDEX (products_discount_index) innerjoin (selectdistinct `product_id` from `category_product` force index (category_product_category_id_product_id_index) where `category_id` in (12902)) as `cp` on `products`.`id` = `cp`.`product_id` whereexists (select*from `stores` where `products`.`store_id` = `stores`.`id` and `stores`.`country` ='mx') and `is_active` =1and `priced_at` >='2025-03-11 04:07:30'and `store_id` =5and `brand_slug` ='electronic'orderby `discount` desc, `priced_at` desc limit 25offset0
TaxonomyTree.php#21descuento2.15msWITHRECURSIVE taxonomy_cte AS (
SELECT slug, title, CAST(NULLASCHAR(255)) AS parent_slug, `order`
FROM taxonomies
WHERE parent_id ISNULLAND store_id =5UNIONALLSELECT t.slug, t.title, CAST(cte.slug ASCHAR(255)) AS parent_slug, t.`order`
FROM taxonomies t
INNERJOIN taxonomy_cte cte ON t.parent_id = (
SELECT id FROM taxonomies WHERE slug = cte.slug AND store_id =5 LIMIT 1
)
)
SELECTDISTINCT slug, title, parent_slug, `order`
FROM taxonomy_cte
ORDERBY `order`
TaxonomyTree.php#21descuento3.1msWITHRECURSIVE taxonomy_cte AS (
SELECT slug, title, CAST(NULLASCHAR(255)) AS parent_slug, `order`
FROM taxonomies
WHERE parent_id ISNULLUNIONALLSELECT t.slug, t.title, CAST(cte.slug ASCHAR(255)) AS parent_slug, t.`order`
FROM taxonomies t
INNERJOIN taxonomy_cte cte ON t.parent_id = (
SELECT id FROM taxonomies WHERE slug = cte.slug LIMIT 1
)
)
SELECTDISTINCT slug, title, parent_slug, `order`
FROM taxonomy_cte
ORDERBY `order`
TaxonomyTree.php#21descuento3.06msWITHRECURSIVE taxonomy_cte AS (
SELECT slug, title, CAST(NULLASCHAR(255)) AS parent_slug, `order`
FROM taxonomies
WHERE parent_id ISNULLUNIONALLSELECT t.slug, t.title, CAST(cte.slug ASCHAR(255)) AS parent_slug, t.`order`
FROM taxonomies t
INNERJOIN taxonomy_cte cte ON t.parent_id = (
SELECT id FROM taxonomies WHERE slug = cte.slug LIMIT 1
)
)
SELECTDISTINCT slug, title, parent_slug, `order`
FROM taxonomy_cte
ORDERBY `order`
