Symfony Profiler

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 = 5;

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 = 5 LIMIT 30;

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 = '5';