Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.field_type AS field_type_4,
  t0.field_params AS field_params_5,
  t0.value AS value_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  parameters t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.field_type AS field_type_4, t0.field_params AS field_params_5, t0.value AS value_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM parameters t0;

SELECT
  u0_.id AS id_0,
  u0_.domain AS domain_1,
  u0_.ip AS ip_2,
  u0_.iprange AS iprange_3,
  u0_.comment AS comment_4,
  u0_.dateadded AS dateadded_5,
  u0_.hitsblocked AS hitsblocked_6
FROM
  users_ipbanned u0_
WHERE
  u0_.iprange IS NOT NULL
  AND u0_.iprange = LEFT(
    ?,
    LENGTH(u0_.iprange)
  )
  OR u0_.ip = ?

SELECT u0_.id AS id_0, u0_.domain AS domain_1, u0_.ip AS ip_2, u0_.iprange AS iprange_3, u0_.comment AS comment_4, u0_.dateadded AS dateadded_5, u0_.hitsblocked AS hitsblocked_6 FROM users_ipbanned u0_ WHERE u0_.iprange IS NOT NULL AND u0_.iprange = LEFT('172.18.0.2', LENGTH(u0_.iprange)) OR u0_.ip = '172.18.0.2';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.nameen AS nameen_2,
  p0_.pos AS pos_3,
  p0_.hits AS hits_4,
  p0_.type AS type_5,
  p0_.parentcategid AS parentcategid_6
FROM
  prod_categs p0_
WHERE
  p0_.parentcategid IS NULL
  AND p0_.type = 0
ORDER BY
  p0_.pos ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.nameen AS nameen_2, p0_.pos AS pos_3, p0_.hits AS hits_4, p0_.type AS type_5, p0_.parentcategid AS parentcategid_6 FROM prod_categs p0_ WHERE p0_.parentcategid IS NULL AND p0_.type = 0 ORDER BY p0_.pos ASC;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  prod_shops p0_
  LEFT JOIN prod_shopsvotes p1_ ON p0_.id = p1_.shopid
WHERE
  1 = 1
  AND p0_.status = 1
GROUP BY
  p0_.id

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prod_shops p0_ LEFT JOIN prod_shopsvotes p1_ ON p0_.id = p1_.shopid WHERE 1 = 1 AND p0_.status = 1 GROUP BY p0_.id;

SELECT
  DISTINCT p0_.id AS id_0,
  COUNT(p1_.id) AS sclr_1
FROM
  prod_shops p0_
  LEFT JOIN prod_shopsvotes p1_ ON p0_.id = p1_.shopid
WHERE
  1 = 1
  AND p0_.status = 1
GROUP BY
  p0_.id
ORDER BY
  sclr_1 DESC
LIMIT
  20

SELECT DISTINCT p0_.id AS id_0, COUNT(p1_.id) AS sclr_1 FROM prod_shops p0_ LEFT JOIN prod_shopsvotes p1_ ON p0_.id = p1_.shopid WHERE 1 = 1 AND p0_.status = 1 GROUP BY p0_.id ORDER BY sclr_1 DESC LIMIT 20;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.url AS url_2,
  p0_.type AS type_3,
  p0_.companyid AS companyid_4,
  p0_.siteid AS siteid_5,
  p0_.picid AS picid_6
FROM
  prod_brands p0_
WHERE
  p0_.type = 0
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.url AS url_2, p0_.type AS type_3, p0_.companyid AS companyid_4, p0_.siteid AS siteid_5, p0_.picid AS picid_6 FROM prod_brands p0_ WHERE p0_.type = 0 ORDER BY p0_.name ASC;