Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.roles AS roles_4,
  t0.password AS password_5
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.roles AS roles_4, t0.password AS password_5 FROM `user` t0 WHERE t0.email = 'contact@maluttebio.com' LIMIT 1;

SELECT
  SUM(stock * price) AS purchase_value,
  SUM(
    stock * (selling_price - price)
  ) AS gross_margin,
  AVG(margin_rate_stored) AS avg_margin,
  COUNT(*) AS total_products
FROM
  product
WHERE
  active = 1
  AND stock > 0

SELECT
                SUM(stock * price) AS purchase_value,
                SUM(stock * (selling_price - price)) AS gross_margin,
                AVG(margin_rate_stored) AS avg_margin,
                COUNT(*) AS total_products
            FROM product
            WHERE active = 1 AND stock > 0
        ;

SELECT
  COUNT(*)
FROM
  product
WHERE
  active = 1
  AND stock <= 0

SELECT COUNT(*) FROM product WHERE active = 1 AND stock <= 0;

SELECT
  COUNT(*)
FROM
  product
WHERE
  active = 1
  AND remaining_days IS NOT NULL
  AND remaining_days < 30
  AND remaining_days > 0

SELECT COUNT(*) FROM product WHERE active = 1 AND remaining_days IS NOT NULL AND remaining_days < 30 AND remaining_days > 0;

SELECT
  COUNT(*)
FROM
  product
WHERE
  active = 1
  AND supplier_id IS NULL

SELECT COUNT(*) FROM product WHERE active = 1 AND supplier_id IS NULL;

SELECT
  DATE_FORMAT(order_date, '%Y-%m') AS month,
  SUM(quantity * unit_price) AS revenue
FROM
  order_item
WHERE
  order_date >= DATE_SUB(
    NOW(),
    INTERVAL 12 MONTH
  )
GROUP BY
  month
ORDER BY
  month ASC

SELECT
                DATE_FORMAT(order_date, '%Y-%m') AS month,
                SUM(quantity * unit_price) AS revenue
            FROM order_item
            WHERE order_date >= DATE_SUB(NOW(), INTERVAL 12 MONTH)
            GROUP BY month
            ORDER BY month ASC
        ;

SELECT
  DATE_FORMAT(
    DATE_ADD(order_date, INTERVAL 12 MONTH),
    '%Y-%m'
  ) AS month,
  SUM(quantity * unit_price) AS revenue
FROM
  order_item
WHERE
  order_date >= DATE_SUB(
    NOW(),
    INTERVAL 24 MONTH
  )
  AND order_date < DATE_SUB(
    NOW(),
    INTERVAL 12 MONTH
  )
GROUP BY
  DATE_FORMAT(
    DATE_ADD(order_date, INTERVAL 12 MONTH),
    '%Y-%m'
  )
ORDER BY
  month ASC

SELECT
                DATE_FORMAT(DATE_ADD(order_date, INTERVAL 12 MONTH), '%Y-%m') AS month,
                SUM(quantity * unit_price) AS revenue
            FROM order_item
            WHERE order_date >= DATE_SUB(NOW(), INTERVAL 24 MONTH)
              AND order_date < DATE_SUB(NOW(), INTERVAL 12 MONTH)
            GROUP BY DATE_FORMAT(DATE_ADD(order_date, INTERVAL 12 MONTH), '%Y-%m')
            ORDER BY month ASC
        ;

SELECT
  oi.prestashop_product_id,
  oi.prestashop_combination_id,
  SUM(oi.quantity) AS total_qty,
  SUM(oi.quantity * oi.unit_price) AS total_revenue,
  REGEXP_REPLACE(
    MAX(p.name),
    '[0-9]+\s*$',
    ''
  ) AS name,
  MAX(p.img_url) AS img_url,
  MAX(p.id) AS product_id
FROM
  order_item oi
  LEFT JOIN product p ON p.prestashop_id = oi.prestashop_product_id
  AND (
    (
      oi.prestashop_combination_id IS NULL
      AND p.prestashop_combination_id IS NULL
    )
    OR p.prestashop_combination_id = oi.prestashop_combination_id
  )
WHERE
  oi.order_date >= DATE_SUB(
    NOW(),
    INTERVAL 30 DAY
  )
GROUP BY
  oi.prestashop_product_id,
  oi.prestashop_combination_id
ORDER BY
  total_qty DESC
LIMIT
  20

SELECT
                oi.prestashop_product_id,
                oi.prestashop_combination_id,
                SUM(oi.quantity) AS total_qty,
                SUM(oi.quantity * oi.unit_price) AS total_revenue,
                REGEXP_REPLACE(MAX(p.name), '[0-9]+\s*$', '') AS name,
                MAX(p.img_url) AS img_url,
                MAX(p.id) AS product_id
            FROM order_item oi
            LEFT JOIN product p ON p.prestashop_id = oi.prestashop_product_id
                AND (
                    (oi.prestashop_combination_id IS NULL AND p.prestashop_combination_id IS NULL)
                    OR p.prestashop_combination_id = oi.prestashop_combination_id
                )
            WHERE oi.order_date >= DATE_SUB(NOW(), INTERVAL 30 DAY)
            GROUP BY oi.prestashop_product_id, oi.prestashop_combination_id
            ORDER BY total_qty DESC
            LIMIT 20
        ;

SELECT
  SUM(quantity * unit_price)
FROM
  order_item
WHERE
  YEAR(order_date) = ?
  AND DATE_FORMAT(order_date, '%m-%d') <= ?

SELECT SUM(quantity * unit_price)
            FROM order_item
            WHERE YEAR(order_date) = 2026
              AND DATE_FORMAT(order_date, '%m-%d') <= '07-13'
        ;

SELECT
  SUM(quantity * unit_price)
FROM
  order_item
WHERE
  YEAR(order_date) = ?
  AND DATE_FORMAT(order_date, '%m-%d') <= ?

SELECT SUM(quantity * unit_price)
            FROM order_item
            WHERE YEAR(order_date) = 2025
              AND DATE_FORMAT(order_date, '%m-%d') <= '07-13'
        ;

SELECT
  MONTH(order_date) AS month_num,
  SUM(quantity * unit_price) AS revenue
FROM
  order_item
WHERE
  YEAR(order_date) = ?
GROUP BY
  MONTH(order_date)

SELECT MONTH(order_date) AS month_num, SUM(quantity * unit_price) AS revenue
            FROM order_item
            WHERE YEAR(order_date) = 2025
            GROUP BY MONTH(order_date)
        ;

SELECT
  SUM(quantity * unit_price)
FROM
  order_item
WHERE
  YEAR(order_date) = ?
  AND MONTH(order_date) < ?

SELECT SUM(quantity * unit_price)
            FROM order_item
            WHERE YEAR(order_date) = 2026
              AND MONTH(order_date) < 7
        ;

SELECT
  SUM(quantity * unit_price)
FROM
  order_item
WHERE
  YEAR(order_date) = ?

SELECT SUM(quantity * unit_price) FROM order_item WHERE YEAR(order_date) = 2025
        ;

SELECT
  COUNT(*)
FROM
  shop_order
WHERE
  status_id IN (2, 9)

SELECT COUNT(*) FROM shop_order WHERE status_id IN (2, 9);

SELECT
  COUNT(*)
FROM
  shop_order
WHERE
  status_id IN (2, 9)
  AND order_date <= DATE_SUB(
    NOW(),
    INTERVAL 15 DAY
  )

SELECT COUNT(*) FROM shop_order WHERE status_id IN (2, 9) AND order_date <= DATE_SUB(NOW(), INTERVAL 15 DAY);

SELECT
  COUNT(*)
FROM
  shop_order
WHERE
  status_id IN (2, 9)
  AND order_date <= DATE_SUB(
    NOW(),
    INTERVAL 7 DAY
  )

SELECT COUNT(*) FROM shop_order WHERE status_id IN (2, 9) AND order_date <= DATE_SUB(NOW(), INTERVAL 7 DAY);

SELECT
  COUNT(*)
FROM
  shop_order
WHERE
  status_id IN (2, 9)
  AND order_date <= DATE_SUB(
    NOW(),
    INTERVAL 3 DAY
  )

SELECT COUNT(*) FROM shop_order WHERE status_id IN (2, 9) AND order_date <= DATE_SUB(NOW(), INTERVAL 3 DAY);

SELECT
  s.id,
  s.name,
  COUNT(p.id) AS product_count
FROM
  supplier s
  LEFT JOIN product p ON p.supplier_id = s.id
  AND p.active = 1
GROUP BY
  s.id,
  s.name
ORDER BY
  s.name ASC

SELECT s.id, s.name, COUNT(p.id) AS product_count
            FROM supplier s
            LEFT JOIN product p ON p.supplier_id = s.id AND p.active = 1
            GROUP BY s.id, s.name
            ORDER BY s.name ASC
        ;

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  ticket t0_
WHERE
  t0_.status <> ?

SELECT COUNT(t0_.id) AS sclr_0 FROM ticket t0_ WHERE t0_.status <> 'closed';