ShowCatalog.php#80descuento5.09sselect*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 (108, 114, 1555, 6604, 9318, 9325, 11505, 12184, 12306)) 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-09 10:30:50'and `store_id` =3and `brand_slug` ='kate-spade'orderby `discount` desc, `priced_at` desc limit 25offset0
TaxonomyTree.php#21descuento4.01msWITHRECURSIVE taxonomy_cte AS (
SELECT slug, title, CAST(NULLASCHAR(255)) AS parent_slug, `order`
FROM taxonomies
WHERE parent_id ISNULLAND store_id =3UNIONALLSELECT 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 =3 LIMIT 1
)
)
SELECTDISTINCT slug, title, parent_slug, `order`
FROM taxonomy_cte
ORDERBY `order`
TaxonomyTree.php#21descuento11.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`
TaxonomyTree.php#21descuento6.26msWITHRECURSIVE 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`
