Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.last_login AS last_login_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.active AS active_8
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.last_login AS last_login_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.active AS active_8 FROM `user` t0 WHERE t0.id = 16;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      s0_.id AS id_0,
      s0_.id_warehouse AS id_warehouse_1,
      s1_.name AS name_2,
      s0_.date_add AS date_add_3,
      COUNT(s2_.id) AS sclr_4,
      s0_.date_add AS date_add_5,
      s0_.date_store_reception AS date_store_reception_6,
      SUM(s2_.stock_added) AS sclr_7,
      s0_.uniqid AS uniqid_8,
      s0_.mvt_type AS mvt_type_9
    FROM
      stock_mvt s0_
      INNER JOIN stock_mvt_detail s2_ ON s0_.id = s2_.id_stock_mvt_id
      INNER JOIN store s1_ ON (
        s1_.id_warehouse = s0_.id_warehouse
      )
    GROUP BY
      s0_.id
    ORDER BY
      s0_.date_add DESC
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT s0_.id AS id_0, s0_.id_warehouse AS id_warehouse_1, s1_.name AS name_2, s0_.date_add AS date_add_3, COUNT(s2_.id) AS sclr_4, s0_.date_add AS date_add_5, s0_.date_store_reception AS date_store_reception_6, SUM(s2_.stock_added) AS sclr_7, s0_.uniqid AS uniqid_8, s0_.mvt_type AS mvt_type_9 FROM stock_mvt s0_ INNER JOIN stock_mvt_detail s2_ ON s0_.id = s2_.id_stock_mvt_id INNER JOIN store s1_ ON (s1_.id_warehouse = s0_.id_warehouse) GROUP BY s0_.id ORDER BY s0_.date_add DESC) dctrn_table;

SELECT
  s0_.id AS id_0,
  s0_.id_warehouse AS id_warehouse_1,
  s1_.name AS name_2,
  s0_.date_add AS date_add_3,
  COUNT(s2_.id) AS sclr_4,
  s0_.date_add AS date_add_5,
  s0_.date_store_reception AS date_store_reception_6,
  SUM(s2_.stock_added) AS sclr_7,
  s0_.uniqid AS uniqid_8,
  s0_.mvt_type AS mvt_type_9
FROM
  stock_mvt s0_
  INNER JOIN stock_mvt_detail s2_ ON s0_.id = s2_.id_stock_mvt_id
  INNER JOIN store s1_ ON (
    s1_.id_warehouse = s0_.id_warehouse
  )
GROUP BY
  s0_.id
ORDER BY
  s0_.date_add DESC
LIMIT
  20

SELECT s0_.id AS id_0, s0_.id_warehouse AS id_warehouse_1, s1_.name AS name_2, s0_.date_add AS date_add_3, COUNT(s2_.id) AS sclr_4, s0_.date_add AS date_add_5, s0_.date_store_reception AS date_store_reception_6, SUM(s2_.stock_added) AS sclr_7, s0_.uniqid AS uniqid_8, s0_.mvt_type AS mvt_type_9 FROM stock_mvt s0_ INNER JOIN stock_mvt_detail s2_ ON s0_.id = s2_.id_stock_mvt_id INNER JOIN store s1_ ON (s1_.id_warehouse = s0_.id_warehouse) GROUP BY s0_.id ORDER BY s0_.date_add DESC LIMIT 20;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 6 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 6 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 10 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 10 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 5 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 5 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 3 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 3 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 12 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 12 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 9 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 9 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 4 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 4 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 15 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 15 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 5 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 5 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 6 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 6 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 3 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 3 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 10 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 10 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 12 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 12 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 4 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 4 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 9 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 9 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 15 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 15 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.id_warehouse AS id_warehouse_2,
  t0.name AS name_3,
  t0.hours AS hours_4
FROM
  store t0
WHERE
  t0.id_warehouse = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.name AS name_3, t0.hours AS hours_4 FROM store t0 WHERE t0.id_warehouse = 2 LIMIT 1;