ShowCatalog.php#80descuento3.1sselect*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 (3128)) 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-14 06:34:37'and `store_id` =1and `brand_slug` ='the-pattern'orderby `discount` desc, `priced_at` desc limit 25offset0
TaxonomyTree.php#21descuento2.62msWITHRECURSIVE taxonomy_cte AS (
SELECT slug, title, CAST(NULLASCHAR(255)) AS parent_slug, `order`
FROM taxonomies
WHERE parent_id ISNULLAND store_id =1UNIONALLSELECT 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 =1 LIMIT 1
)
)
SELECTDISTINCT slug, title, parent_slug, `order`
FROM taxonomy_cte
ORDERBY `order`
TaxonomyTree.php#21descuento3msWITHRECURSIVE 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#21descuento2.99msWITHRECURSIVE 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`
