Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.code_otg AS code_otg_1,
  p0_.date_event AS date_event_2,
  p0_.date_plan_in AS date_plan_in_3,
  p0_.koment AS koment_4,
  p0_.switch_sub_reason AS switch_sub_reason_5,
  p0_.building_names AS building_names_6,
  p0_.type_off AS type_off_7,
  p1_.id AS id_8,
  p1_.code AS code_9,
  p1_.name AS name_10,
  p2_.id AS id_11,
  p2_.name AS name_12,
  p2_.code_otg AS code_otg_13,
  p3_.id AS id_14,
  p3_.name AS name_15,
  p4_.id AS id_16,
  p4_.name AS name_17,
  p4_.code_otg AS code_otg_18,
  p0_.city_id AS city_id_19,
  p0_.street_id AS street_id_20,
  p0_.otg_id AS otg_id_21,
  p2_.otg_id AS otg_id_22,
  p3_.city_id AS city_id_23,
  p4_.otg_id AS otg_id_24
FROM
  pw_accident p0_
  INNER JOIN pw_otg p1_ ON p0_.otg_id = p1_.id
  INNER JOIN pw_city p2_ ON p0_.city_id = p2_.id
  INNER JOIN pw_street p3_ ON p0_.street_id = p3_.id
  LEFT JOIN pw_city p4_ ON p3_.city_id = p4_.id
WHERE
  p0_.id IN (
    SELECT
      p5_.id
    FROM
      pw_accident p5_
      INNER JOIN pw_otg p6_ ON p5_.otg_id = p6_.id
      INNER JOIN pw_city p7_ ON p5_.city_id = p7_.id
      INNER JOIN pw_street p8_ ON p5_.street_id = p8_.id
    WHERE
      p7_.id = ?
  )
ORDER BY
  p0_.id ASC
LIMIT
  30

SELECT p0_.id AS id_0, p0_.code_otg AS code_otg_1, p0_.date_event AS date_event_2, p0_.date_plan_in AS date_plan_in_3, p0_.koment AS koment_4, p0_.switch_sub_reason AS switch_sub_reason_5, p0_.building_names AS building_names_6, p0_.type_off AS type_off_7, p1_.id AS id_8, p1_.code AS code_9, p1_.name AS name_10, p2_.id AS id_11, p2_.name AS name_12, p2_.code_otg AS code_otg_13, p3_.id AS id_14, p3_.name AS name_15, p4_.id AS id_16, p4_.name AS name_17, p4_.code_otg AS code_otg_18, p0_.city_id AS city_id_19, p0_.street_id AS street_id_20, p0_.otg_id AS otg_id_21, p2_.otg_id AS otg_id_22, p3_.city_id AS city_id_23, p4_.otg_id AS otg_id_24 FROM pw_accident p0_ INNER JOIN pw_otg p1_ ON p0_.otg_id = p1_.id INNER JOIN pw_city p2_ ON p0_.city_id = p2_.id INNER JOIN pw_street p3_ ON p0_.street_id = p3_.id LEFT JOIN pw_city p4_ ON p3_.city_id = p4_.id WHERE p0_.id IN (SELECT p5_.id FROM pw_accident p5_ INNER JOIN pw_otg p6_ ON p5_.otg_id = p6_.id INNER JOIN pw_city p7_ ON p5_.city_id = p7_.id INNER JOIN pw_street p8_ ON p5_.street_id = p8_.id WHERE p7_.id = '457') ORDER BY p0_.id ASC LIMIT 30;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  pw_accident p0_
  INNER JOIN pw_otg p1_ ON p0_.otg_id = p1_.id
  INNER JOIN pw_city p2_ ON p0_.city_id = p2_.id
  INNER JOIN pw_street p3_ ON p0_.street_id = p3_.id
  LEFT JOIN pw_city p4_ ON p3_.city_id = p4_.id
WHERE
  p0_.id IN (
    SELECT
      p5_.id
    FROM
      pw_accident p5_
      INNER JOIN pw_otg p6_ ON p5_.otg_id = p6_.id
      INNER JOIN pw_city p7_ ON p5_.city_id = p7_.id
      INNER JOIN pw_street p8_ ON p5_.street_id = p8_.id
    WHERE
      p7_.id = ?
  )

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM pw_accident p0_ INNER JOIN pw_otg p1_ ON p0_.otg_id = p1_.id INNER JOIN pw_city p2_ ON p0_.city_id = p2_.id INNER JOIN pw_street p3_ ON p0_.street_id = p3_.id LEFT JOIN pw_city p4_ ON p3_.city_id = p4_.id WHERE p0_.id IN (SELECT p5_.id FROM pw_accident p5_ INNER JOIN pw_otg p6_ ON p5_.otg_id = p6_.id INNER JOIN pw_city p7_ ON p5_.city_id = p7_.id INNER JOIN pw_street p8_ ON p5_.street_id = p8_.id WHERE p7_.id = '457');