Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.product_name AS product_name_1,
          p0_.qtt AS qtt_2,
          p0_.prix AS prix_3,
          p0_.publish_item AS publish_item_4,
          p0_.promo AS promo_5,
          p0_.description AS description_6,
          p0_.publish_date AS publish_date_7,
          p0_.sale_price AS sale_price_8,
          p0_.cost_price AS cost_price_9,
          p0_.date_production AS date_production_10,
          p0_.date_expiration AS date_expiration_11,
          c1_.id AS id_12,
          c1_.nom AS nom_13,
          c1_.tax AS tax_14
        FROM
          produit p0_
          INNER JOIN category c1_ ON p0_.category_id = c1_.id
        WHERE
          (
            p0_.publish_item = 1
            OR ? = 1
          )
          AND p0_.magasin_id IN (?)
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_name AS product_name_1, p0_.qtt AS qtt_2, p0_.prix AS prix_3, p0_.publish_item AS publish_item_4, p0_.promo AS promo_5, p0_.description AS description_6, p0_.publish_date AS publish_date_7, p0_.sale_price AS sale_price_8, p0_.cost_price AS cost_price_9, p0_.date_production AS date_production_10, p0_.date_expiration AS date_expiration_11, c1_.id AS id_12, c1_.nom AS nom_13, c1_.tax AS tax_14 FROM produit p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE (p0_.publish_item = 1 OR 0 = 1) AND p0_.magasin_id IN (1)) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.logo_path AS logo_path_3,
  t0.active AS active_4
FROM
  magasin t0
WHERE
  t0.nom IN (?)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.logo_path AS logo_path_3, t0.active AS active_4 FROM magasin t0 WHERE t0.nom IN ('ARZ');

SELECT
  m0_.id AS id_0,
  m0_.start_time AS start_time_1,
  m0_.end_time AS end_time_2,
  m0_.description AS description_3,
  m0_.is_active AS is_active_4
FROM
  maintenance_schedule m0_
WHERE
  m0_.is_active = ?
  AND m0_.start_time <= ?
  AND m0_.end_time >= ?
ORDER BY
  m0_.end_time DESC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.start_time AS start_time_1, m0_.end_time AS end_time_2, m0_.description AS description_3, m0_.is_active AS is_active_4 FROM maintenance_schedule m0_ WHERE m0_.is_active = 1 AND m0_.start_time <= '2026-02-15 09:21:48' AND m0_.end_time >= '2026-02-15 09:21:48' ORDER BY m0_.end_time DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.tax AS tax_3
FROM
  category t0
ORDER BY
  t0.nom ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.tax AS tax_3 FROM category t0 ORDER BY t0.nom ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.logo_path AS logo_path_3,
  t0.active AS active_4
FROM
  magasin t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.logo_path AS logo_path_3, t0.active AS active_4 FROM magasin t0;

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.tax AS tax_2
FROM
  category c0_

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.tax AS tax_2 FROM category c0_;