Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

SELECT i0_.id AS id_0, i0_.slug AS slug_1, i0_.name AS name_2, i0_.description AS description_3, i0_.surface AS surface_4, i0_.latitude AS latitude_5, i0_.longitude AS longitude_6, i0_.status AS status_7, i0_.created_at AS created_at_8, i0_.updated_at AS updated_at_9, s1_.id AS id_10, s1_.name AS name_11, s1_.slug AS slug_12, s1_.address AS address_13, s1_.postcode AS postcode_14, s1_.city AS city_15, s1_.phone AS phone_16, s1_.created_at AS created_at_17, s1_.updated_at AS updated_at_18, m2_.id AS id_19, m2_.original_filename AS original_filename_20, m2_.stored_filename AS stored_filename_21, m2_.mime_type AS mime_type_22, m2_.size AS size_23, m2_.context AS context_24, m2_.status AS status_25, m2_.created_at AS created_at_26, m2_.is_hero AS is_hero_27, i0_.school_id AS school_id_28, m2_.island_id AS island_id_29, m2_.uploaded_by_id AS uploaded_by_id_30, m2_.camera_trap_id AS camera_trap_id_31 FROM island i0_ LEFT JOIN school s1_ ON i0_.school_id = s1_.id LEFT JOIN media m2_ ON i0_.id = m2_.island_id WHERE i0_.status IN (?, ?) AND i0_.latitude IS NOT NULL AND i0_.longitude IS NOT NULL ORDER BY i0_.name ASC

[
  "active"
  "creation"
]

SELECT
  i0_.id AS id_0,
  i0_.slug AS slug_1,
  i0_.name AS name_2,
  i0_.description AS description_3,
  i0_.surface AS surface_4,
  i0_.latitude AS latitude_5,
  i0_.longitude AS longitude_6,
  i0_.status AS status_7,
  i0_.created_at AS created_at_8,
  i0_.updated_at AS updated_at_9,
  s1_.id AS id_10,
  s1_.name AS name_11,
  s1_.slug AS slug_12,
  s1_.address AS address_13,
  s1_.postcode AS postcode_14,
  s1_.city AS city_15,
  s1_.phone AS phone_16,
  s1_.created_at AS created_at_17,
  s1_.updated_at AS updated_at_18,
  m2_.id AS id_19,
  m2_.original_filename AS original_filename_20,
  m2_.stored_filename AS stored_filename_21,
  m2_.mime_type AS mime_type_22,
  m2_.size AS size_23,
  m2_.context AS context_24,
  m2_.status AS status_25,
  m2_.created_at AS created_at_26,
  m2_.is_hero AS is_hero_27,
  i0_.school_id AS school_id_28,
  m2_.island_id AS island_id_29,
  m2_.uploaded_by_id AS uploaded_by_id_30,
  m2_.camera_trap_id AS camera_trap_id_31
FROM
  island i0_
  LEFT JOIN school s1_ ON i0_.school_id = s1_.id
  LEFT JOIN media m2_ ON i0_.id = m2_.island_id
WHERE
  i0_.status IN (?, ?)
  AND i0_.latitude IS NOT NULL
  AND i0_.longitude IS NOT NULL
ORDER BY
  i0_.name ASC

SELECT i0_.id AS id_0, i0_.slug AS slug_1, i0_.name AS name_2, i0_.description AS description_3, i0_.surface AS surface_4, i0_.latitude AS latitude_5, i0_.longitude AS longitude_6, i0_.status AS status_7, i0_.created_at AS created_at_8, i0_.updated_at AS updated_at_9, s1_.id AS id_10, s1_.name AS name_11, s1_.slug AS slug_12, s1_.address AS address_13, s1_.postcode AS postcode_14, s1_.city AS city_15, s1_.phone AS phone_16, s1_.created_at AS created_at_17, s1_.updated_at AS updated_at_18, m2_.id AS id_19, m2_.original_filename AS original_filename_20, m2_.stored_filename AS stored_filename_21, m2_.mime_type AS mime_type_22, m2_.size AS size_23, m2_.context AS context_24, m2_.status AS status_25, m2_.created_at AS created_at_26, m2_.is_hero AS is_hero_27, i0_.school_id AS school_id_28, m2_.island_id AS island_id_29, m2_.uploaded_by_id AS uploaded_by_id_30, m2_.camera_trap_id AS camera_trap_id_31 FROM island i0_ LEFT JOIN school s1_ ON i0_.school_id = s1_.id LEFT JOIN media m2_ ON i0_.id = m2_.island_id WHERE i0_.status IN ('active', 'creation') AND i0_.latitude IS NOT NULL AND i0_.longitude IS NOT NULL ORDER BY i0_.name ASC;