Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.createdat AS createdat_3,
  t0.updatedat AS updatedat_4,
  t0.status AS status_5,
  t0.refclient AS refclient_6,
  t0.quantite AS quantite_7,
  t0.description AS description_8,
  t0.drawing AS drawing_9,
  t0.alttext AS alttext_10,
  t0.drawinga AS drawinga_11,
  t0.isactivesimul AS isactivesimul_12,
  t0.createur_id AS createur_id_13,
  t0.parent_id AS parent_id_14,
  t0.stdconfig_id AS stdconfig_id_15
FROM
  cotation t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.createdat AS createdat_3, t0.updatedat AS updatedat_4, t0.status AS status_5, t0.refclient AS refclient_6, t0.quantite AS quantite_7, t0.description AS description_8, t0.drawing AS drawing_9, t0.alttext AS alttext_10, t0.drawinga AS drawinga_11, t0.isactivesimul AS isactivesimul_12, t0.createur_id AS createur_id_13, t0.parent_id AS parent_id_14, t0.stdconfig_id AS stdconfig_id_15 FROM cotation t0 WHERE t0.parent_id = 292;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5,
  t0.currency AS currency_6,
  t0.recent_requests AS recent_requests_7,
  t0.recent_materials AS recent_materials_8,
  t0.recent_routings AS recent_routings_9
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.currency AS currency_6, t0.recent_requests AS recent_requests_7, t0.recent_materials AS recent_materials_8, t0.recent_routings AS recent_routings_9 FROM user t0 WHERE t0.id = 8;

SELECT
  c0_.cotation_id AS sclr_0,
  c1_.titre AS titre_1,
  c1_.createdat AS createdat_2,
  COUNT(c0_.id) AS sclr_3
FROM
  cotation_process c0_
  INNER JOIN cotation c1_ ON c0_.cotation_id = c1_.id
  INNER JOIN process_prod p2_ ON c0_.processprod_id = p2_.id
WHERE
  c1_.createur_id = ?
  AND c0_.costbool = 1
  AND (
    p2_.refinterne = ?
    OR p2_.unit <> c0_.baseunit
  )
GROUP BY
  c0_.cotation_id
ORDER BY
  c1_.createdat DESC
LIMIT
  10

SELECT c0_.cotation_id AS sclr_0, c1_.titre AS titre_1, c1_.createdat AS createdat_2, COUNT(c0_.id) AS sclr_3 FROM cotation_process c0_ INNER JOIN cotation c1_ ON c0_.cotation_id = c1_.id INNER JOIN process_prod p2_ ON c0_.processprod_id = p2_.id WHERE c1_.createur_id = 8 AND c0_.costbool = 1 AND (p2_.refinterne = '-' OR p2_.unit <> c0_.baseunit) GROUP BY c0_.cotation_id ORDER BY c1_.createdat DESC LIMIT 10;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  cotation_process c0_
  INNER JOIN cotation c1_ ON c0_.cotation_id = c1_.id
  INNER JOIN process_prod p2_ ON c0_.processprod_id = p2_.id
WHERE
  c1_.createur_id = ?
  AND c0_.costbool = 1
  AND (
    p2_.refinterne = ?
    OR p2_.unit <> c0_.baseunit
  )

SELECT COUNT(c0_.id) AS sclr_0 FROM cotation_process c0_ INNER JOIN cotation c1_ ON c0_.cotation_id = c1_.id INNER JOIN process_prod p2_ ON c0_.processprod_id = p2_.id WHERE c1_.createur_id = 8 AND c0_.costbool = 1 AND (p2_.refinterne = '-' OR p2_.unit <> c0_.baseunit);

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  cotation_detail c0_
  INNER JOIN cotation c1_ ON c0_.cotation_id = c1_.id
  INNER JOIN matiere_premiere m2_ ON c0_.matierepremiere_id = m2_.id
WHERE
  c1_.createur_id = ?
  AND c0_.costbool = 1
  AND (
    m2_.refinterne = ?
    OR m2_.bomunit <> c0_.bomunit
  )

SELECT COUNT(c0_.id) AS sclr_0 FROM cotation_detail c0_ INNER JOIN cotation c1_ ON c0_.cotation_id = c1_.id INNER JOIN matiere_premiere m2_ ON c0_.matierepremiere_id = m2_.id WHERE c1_.createur_id = 8 AND c0_.costbool = 1 AND (m2_.refinterne = '-' OR m2_.bomunit <> c0_.bomunit);

SELECT
  c0_.cotation_id AS sclr_0,
  c1_.titre AS titre_1,
  c1_.createdat AS createdat_2,
  COUNT(c0_.id) AS sclr_3
FROM
  cotation_detail c0_
  INNER JOIN cotation c1_ ON c0_.cotation_id = c1_.id
  INNER JOIN matiere_premiere m2_ ON c0_.matierepremiere_id = m2_.id
WHERE
  c1_.createur_id = ?
  AND c0_.costbool = 1
  AND (
    m2_.refinterne = ?
    OR m2_.bomunit <> c0_.bomunit
  )
GROUP BY
  c0_.cotation_id
ORDER BY
  c1_.createdat DESC
LIMIT
  10

SELECT c0_.cotation_id AS sclr_0, c1_.titre AS titre_1, c1_.createdat AS createdat_2, COUNT(c0_.id) AS sclr_3 FROM cotation_detail c0_ INNER JOIN cotation c1_ ON c0_.cotation_id = c1_.id INNER JOIN matiere_premiere m2_ ON c0_.matierepremiere_id = m2_.id WHERE c1_.createur_id = 8 AND c0_.costbool = 1 AND (m2_.refinterne = '-' OR m2_.bomunit <> c0_.bomunit) GROUP BY c0_.cotation_id ORDER BY c1_.createdat DESC LIMIT 10;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  cotation_process c0_
  INNER JOIN cotation c1_ ON c0_.cotation_id = c1_.id
WHERE
  c1_.createur_id = ?
  AND c0_.costbool = 1

SELECT COUNT(c0_.id) AS sclr_0 FROM cotation_process c0_ INNER JOIN cotation c1_ ON c0_.cotation_id = c1_.id WHERE c1_.createur_id = 8 AND c0_.costbool = 1;

SELECT
  c0_.id AS id_0,
  c0_.titre AS titre_1,
  c0_.createdat AS createdat_2,
  c0_.updatedat AS updatedat_3,
  c0_.status AS status_4,
  c0_.refclient AS refclient_5,
  c0_.quantite AS quantite_6,
  c0_.description AS description_7,
  c0_.drawing AS drawing_8,
  c0_.alttext AS alttext_9,
  c0_.drawinga AS drawinga_10,
  c0_.isactivesimul AS isactivesimul_11,
  c0_.createur_id AS createur_id_12,
  c0_.parent_id AS parent_id_13,
  c0_.stdconfig_id AS stdconfig_id_14
FROM
  cotation c0_
WHERE
  c0_.status IN ('INIT', 'DRAFT', 'OK', 'Autre')
ORDER BY
  c0_.createdat DESC

SELECT c0_.id AS id_0, c0_.titre AS titre_1, c0_.createdat AS createdat_2, c0_.updatedat AS updatedat_3, c0_.status AS status_4, c0_.refclient AS refclient_5, c0_.quantite AS quantite_6, c0_.description AS description_7, c0_.drawing AS drawing_8, c0_.alttext AS alttext_9, c0_.drawinga AS drawinga_10, c0_.isactivesimul AS isactivesimul_11, c0_.createur_id AS createur_id_12, c0_.parent_id AS parent_id_13, c0_.stdconfig_id AS stdconfig_id_14 FROM cotation c0_ WHERE c0_.status IN ('INIT', 'DRAFT', 'OK', 'Autre') ORDER BY c0_.createdat DESC;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  cotation_detail c0_
  INNER JOIN cotation c1_ ON c0_.cotation_id = c1_.id
WHERE
  c1_.createur_id = ?
  AND c0_.costbool = 1

SELECT COUNT(c0_.id) AS sclr_0 FROM cotation_detail c0_ INNER JOIN cotation c1_ ON c0_.cotation_id = c1_.id WHERE c1_.createur_id = 8 AND c0_.costbool = 1;

SELECT
  c0_.id AS id_0,
  c0_.status AS status_1
FROM
  cotation c0_
WHERE
  c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT c0_.id AS id_0, c0_.status AS status_1 FROM cotation c0_ WHERE c0_.id IN (235, 293, 292, 291, 285, 274, 265, 276, 259, 256);