Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.country AS country_3,
  t0.wtt_id AS wtt_id_4,
  t0.wtt_name AS wtt_name_5,
  t0.logo AS logo_6,
  t0.config AS config_7,
  t0.apikey AS apikey_8,
  t0.login_hash AS login_hash_9,
  t0.channel AS channel_10,
  t0.mail_copy AS mail_copy_11,
  t0.active AS active_12
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.wtt_id AS wtt_id_4, t0.wtt_name AS wtt_name_5, t0.logo AS logo_6, t0.config AS config_7, t0.apikey AS apikey_8, t0.login_hash AS login_hash_9, t0.channel AS channel_10, t0.mail_copy AS mail_copy_11, t0.active AS active_12 FROM shop t0 WHERE t0.id = '9';

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  `user` u0_
  LEFT JOIN company c1_ ON u0_.company_id = c1_.id
  LEFT JOIN shop s2_ ON u0_.shop_id = s2_.id
WHERE
  u0_.active = ?
  AND u0_.shop_id = ?

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM `user` u0_ LEFT JOIN company c1_ ON u0_.company_id = c1_.id LEFT JOIN shop s2_ ON u0_.shop_id = s2_.id WHERE u0_.active = 1 AND u0_.shop_id = 9;

SELECT
  DISTINCT u0_.id AS id_0
FROM
  `user` u0_
  LEFT JOIN company c1_ ON u0_.company_id = c1_.id
  LEFT JOIN shop s2_ ON u0_.shop_id = s2_.id
WHERE
  u0_.active = ?
  AND u0_.shop_id = ?
LIMIT
  30

SELECT DISTINCT u0_.id AS id_0 FROM `user` u0_ LEFT JOIN company c1_ ON u0_.company_id = c1_.id LEFT JOIN shop s2_ ON u0_.shop_id = s2_.id WHERE u0_.active = 1 AND u0_.shop_id = 9 LIMIT 30;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.is_verified AS is_verified_4,
  u0_.firstname AS firstname_5,
  u0_.lastname AS lastname_6,
  u0_.phone AS phone_7,
  u0_.active AS active_8,
  u0_.shop_id AS shop_id_9,
  u0_.company_id AS company_id_10,
  u0_.parent_id AS parent_id_11
FROM
  `user` u0_
  LEFT JOIN company c1_ ON u0_.company_id = c1_.id
  LEFT JOIN shop s2_ ON u0_.shop_id = s2_.id
WHERE
  u0_.active = ?
  AND u0_.shop_id = ?
  AND u0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.firstname AS firstname_5, u0_.lastname AS lastname_6, u0_.phone AS phone_7, u0_.active AS active_8, u0_.shop_id AS shop_id_9, u0_.company_id AS company_id_10, u0_.parent_id AS parent_id_11 FROM `user` u0_ LEFT JOIN company c1_ ON u0_.company_id = c1_.id LEFT JOIN shop s2_ ON u0_.shop_id = s2_.id WHERE u0_.active = 1 AND u0_.shop_id = 9 AND u0_.id IN (34, 36, 37, 38, 39, 40, 41, 43, 44, 45, 46, 47, 49, 50, 51, 52, 54, 55, 56, 57, 59, 60, 61, 62, 63, 70, 73, 84, 86, 87);