ShowCatalog.php#80descuento3.2sselect*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 (2384, 2385, 7737, 9917, 11374)) 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 02:14:47'and `store_id` =4and `brand_slug` ='wund'orderby `discount` desc, `priced_at` desc limit 25offset0
TaxonomyTree.php#21descuento3.17msWITHRECURSIVE taxonomy_cte AS (
SELECT slug, title, CAST(NULLASCHAR(255)) AS parent_slug, `order`
FROM taxonomies
WHERE parent_id ISNULLAND store_id =4UNIONALLSELECT 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 =4 LIMIT 1
)
)
SELECTDISTINCT slug, title, parent_slug, `order`
FROM taxonomy_cte
ORDERBY `order`
TaxonomyTree.php#21descuento6.16msWITHRECURSIVE 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#21descuento5.02msWITHRECURSIVE 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`
