Symfony Profiler

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

Query Metrics

SELECT l0_.id AS id_0, l0_.zipcode AS zipcode_1, l0_.locality AS locality_2, l0_.latitude AS latitude_3, l0_.longitude AS longitude_4, l0_.osm AS osm_5, l0_.tier AS tier_6, l0_.city AS city_7, l0_.slug AS slug_8, l0_.search AS search_9, l0_.area AS area_10, l0_.state AS state_11, l0_.illustration AS illustration_12, l0_.priority AS priority_13, l0_.city_en AS city_en_14, l0_.state_en AS state_en_15, l0_.search_city AS search_city_16, l0_.state_slug AS state_slug_17, l0_.state_reference_id AS state_reference_id_18 FROM locality l0_ WHERE l0_.state_slug = ? AND l0_.priority IS NOT NULL AND (l0_.id = (SELECT MIN(l1_.id) AS sclr_19 FROM locality l1_ WHERE l1_.priority = l0_.priority AND l1_.state_slug = ?)) ORDER BY l0_.priority DESC LIMIT 12

[
  "fontaine-38600"
  "fontaine-38600"
]

SELECT
  l0_.id AS id_0,
  l0_.zipcode AS zipcode_1,
  l0_.locality AS locality_2,
  l0_.latitude AS latitude_3,
  l0_.longitude AS longitude_4,
  l0_.osm AS osm_5,
  l0_.tier AS tier_6,
  l0_.city AS city_7,
  l0_.slug AS slug_8,
  l0_.search AS search_9,
  l0_.area AS area_10,
  l0_.state AS state_11,
  l0_.illustration AS illustration_12,
  l0_.priority AS priority_13,
  l0_.city_en AS city_en_14,
  l0_.state_en AS state_en_15,
  l0_.search_city AS search_city_16,
  l0_.state_slug AS state_slug_17,
  l0_.state_reference_id AS state_reference_id_18
FROM
  locality l0_
WHERE
  l0_.state_slug = ?
  AND l0_.priority IS NOT NULL
  AND (
    l0_.id = (
      SELECT
        MIN(l1_.id) AS sclr_19
      FROM
        locality l1_
      WHERE
        l1_.priority = l0_.priority
        AND l1_.state_slug = ?
    )
  )
ORDER BY
  l0_.priority DESC
LIMIT
  12

SELECT l0_.id AS id_0, l0_.zipcode AS zipcode_1, l0_.locality AS locality_2, l0_.latitude AS latitude_3, l0_.longitude AS longitude_4, l0_.osm AS osm_5, l0_.tier AS tier_6, l0_.city AS city_7, l0_.slug AS slug_8, l0_.search AS search_9, l0_.area AS area_10, l0_.state AS state_11, l0_.illustration AS illustration_12, l0_.priority AS priority_13, l0_.city_en AS city_en_14, l0_.state_en AS state_en_15, l0_.search_city AS search_city_16, l0_.state_slug AS state_slug_17, l0_.state_reference_id AS state_reference_id_18 FROM locality l0_ WHERE l0_.state_slug = 'fontaine-38600' AND l0_.priority IS NOT NULL AND (l0_.id = (SELECT MIN(l1_.id) AS sclr_19 FROM locality l1_ WHERE l1_.priority = l0_.priority AND l1_.state_slug = 'fontaine-38600')) ORDER BY l0_.priority DESC LIMIT 12;

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.locality AS locality_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.osm AS osm_6, t0.tier AS tier_7, t0.city AS city_8, t0.slug AS slug_9, t0.search AS search_10, t0.area AS area_11, t0.state AS state_12, t0.illustration AS illustration_13, t0.priority AS priority_14, t0.city_en AS city_en_15, t0.state_en AS state_en_16, t0.search_city AS search_city_17, t0.state_slug AS state_slug_18, t0.state_reference_id AS state_reference_id_19 FROM locality t0 WHERE t0.state_slug = ? LIMIT 1

[
  "fontaine-38600"
]

SELECT
  t0.id AS id_1,
  t0.zipcode AS zipcode_2,
  t0.locality AS locality_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.osm AS osm_6,
  t0.tier AS tier_7,
  t0.city AS city_8,
  t0.slug AS slug_9,
  t0.search AS search_10,
  t0.area AS area_11,
  t0.state AS state_12,
  t0.illustration AS illustration_13,
  t0.priority AS priority_14,
  t0.city_en AS city_en_15,
  t0.state_en AS state_en_16,
  t0.search_city AS search_city_17,
  t0.state_slug AS state_slug_18,
  t0.state_reference_id AS state_reference_id_19
FROM
  locality t0
WHERE
  t0.state_slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.locality AS locality_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.osm AS osm_6, t0.tier AS tier_7, t0.city AS city_8, t0.slug AS slug_9, t0.search AS search_10, t0.area AS area_11, t0.state AS state_12, t0.illustration AS illustration_13, t0.priority AS priority_14, t0.city_en AS city_en_15, t0.state_en AS state_en_16, t0.search_city AS search_city_17, t0.state_slug AS state_slug_18, t0.state_reference_id AS state_reference_id_19 FROM locality t0 WHERE t0.state_slug = 'fontaine-38600' LIMIT 1;