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

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  `order` o0_
WHERE
  o0_.status_id <> ?
  AND o0_.active = ?
  AND o0_.shop_id = ?

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.status_id <> 10 AND o0_.active = 1 AND o0_.shop_id = 17;

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.date AS date_1
FROM
  `order` o0_
WHERE
  o0_.status_id <> ?
  AND o0_.active = ?
  AND o0_.shop_id = ?
ORDER BY
  o0_.date DESC
LIMIT
  30

SELECT DISTINCT o0_.id AS id_0, o0_.date AS date_1 FROM `order` o0_ WHERE o0_.status_id <> 10 AND o0_.active = 1 AND o0_.shop_id = 17 ORDER BY o0_.date DESC LIMIT 30;