Symfony Profiler

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

Query Metrics

SELECT MAX(p0_.canvass_day) AS sclr_0 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.reviewed = 0

[]

SELECT
  MAX(p0_.canvass_day) AS sclr_0
FROM
  photos p0_
WHERE
  p0_.exclude = 0
  AND p0_.reviewed = 0

SELECT MAX(p0_.canvass_day) AS sclr_0 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.reviewed = 0;

SELECT MIN(p0_.canvass_day) AS sclr_0, MAX(p0_.canvass_day) AS sclr_1 FROM photos p0_ WHERE p0_.exclude = 0

[]

SELECT
  MIN(p0_.canvass_day) AS sclr_0,
  MAX(p0_.canvass_day) AS sclr_1
FROM
  photos p0_
WHERE
  p0_.exclude = 0

SELECT MIN(p0_.canvass_day) AS sclr_0, MAX(p0_.canvass_day) AS sclr_1 FROM photos p0_ WHERE p0_.exclude = 0;

SELECT p0_.id AS id_0, p0_.photo_id AS photo_id_1, p0_.cropped_object_path AS cropped_object_path_2, p0_.original_object_path AS original_object_path_3, p0_.canvass_day AS canvass_day_4, p0_.date_source AS date_source_5, p0_.canvasser_name AS canvasser_name_6, p0_.exclude AS exclude_7, p0_.reviewed AS reviewed_8, p0_.gcs_time_created AS gcs_time_created_9, p0_.canvasser_email AS canvasser_email_10, p0_.canvasser_id AS canvasser_id_11, p0_.event_time AS event_time_12, p0_.site_name AS site_name_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.last_synced_at AS last_synced_at_16 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.canvass_day >= ? AND p0_.canvass_day <= ? ORDER BY p0_.canvass_day DESC, p0_.canvasser_name ASC, p0_.photo_id ASC LIMIT 100

[
  "2026-08-05"
  "2026-08-05"
]

SELECT
  p0_.id AS id_0,
  p0_.photo_id AS photo_id_1,
  p0_.cropped_object_path AS cropped_object_path_2,
  p0_.original_object_path AS original_object_path_3,
  p0_.canvass_day AS canvass_day_4,
  p0_.date_source AS date_source_5,
  p0_.canvasser_name AS canvasser_name_6,
  p0_.exclude AS exclude_7,
  p0_.reviewed AS reviewed_8,
  p0_.gcs_time_created AS gcs_time_created_9,
  p0_.canvasser_email AS canvasser_email_10,
  p0_.canvasser_id AS canvasser_id_11,
  p0_.event_time AS event_time_12,
  p0_.site_name AS site_name_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15,
  p0_.last_synced_at AS last_synced_at_16
FROM
  photos p0_
WHERE
  p0_.exclude = 0
  AND p0_.canvass_day >= ?
  AND p0_.canvass_day <= ?
ORDER BY
  p0_.canvass_day DESC,
  p0_.canvasser_name ASC,
  p0_.photo_id ASC
LIMIT
  100

SELECT p0_.id AS id_0, p0_.photo_id AS photo_id_1, p0_.cropped_object_path AS cropped_object_path_2, p0_.original_object_path AS original_object_path_3, p0_.canvass_day AS canvass_day_4, p0_.date_source AS date_source_5, p0_.canvasser_name AS canvasser_name_6, p0_.exclude AS exclude_7, p0_.reviewed AS reviewed_8, p0_.gcs_time_created AS gcs_time_created_9, p0_.canvasser_email AS canvasser_email_10, p0_.canvasser_id AS canvasser_id_11, p0_.event_time AS event_time_12, p0_.site_name AS site_name_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.last_synced_at AS last_synced_at_16 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.canvass_day >= '2026-08-05' AND p0_.canvass_day <= '2026-08-05' ORDER BY p0_.canvass_day DESC, p0_.canvasser_name ASC, p0_.photo_id ASC LIMIT 100;

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.photo_id AS photo_id_1, p0_.cropped_object_path AS cropped_object_path_2, p0_.original_object_path AS original_object_path_3, p0_.canvass_day AS canvass_day_4, p0_.date_source AS date_source_5, p0_.canvasser_name AS canvasser_name_6, p0_.exclude AS exclude_7, p0_.reviewed AS reviewed_8, p0_.gcs_time_created AS gcs_time_created_9, p0_.canvasser_email AS canvasser_email_10, p0_.canvasser_id AS canvasser_id_11, p0_.event_time AS event_time_12, p0_.site_name AS site_name_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.last_synced_at AS last_synced_at_16 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.canvass_day >= ? AND p0_.canvass_day <= ? ORDER BY p0_.canvass_day DESC, p0_.canvasser_name ASC, p0_.photo_id ASC) dctrn_result) dctrn_table

[
  "2026-08-05"
  "2026-08-05"
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.photo_id AS photo_id_1,
          p0_.cropped_object_path AS cropped_object_path_2,
          p0_.original_object_path AS original_object_path_3,
          p0_.canvass_day AS canvass_day_4,
          p0_.date_source AS date_source_5,
          p0_.canvasser_name AS canvasser_name_6,
          p0_.exclude AS exclude_7,
          p0_.reviewed AS reviewed_8,
          p0_.gcs_time_created AS gcs_time_created_9,
          p0_.canvasser_email AS canvasser_email_10,
          p0_.canvasser_id AS canvasser_id_11,
          p0_.event_time AS event_time_12,
          p0_.site_name AS site_name_13,
          p0_.created_at AS created_at_14,
          p0_.updated_at AS updated_at_15,
          p0_.last_synced_at AS last_synced_at_16
        FROM
          photos p0_
        WHERE
          p0_.exclude = 0
          AND p0_.canvass_day >= ?
          AND p0_.canvass_day <= ?
        ORDER BY
          p0_.canvass_day DESC,
          p0_.canvasser_name ASC,
          p0_.photo_id ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.photo_id AS photo_id_1, p0_.cropped_object_path AS cropped_object_path_2, p0_.original_object_path AS original_object_path_3, p0_.canvass_day AS canvass_day_4, p0_.date_source AS date_source_5, p0_.canvasser_name AS canvasser_name_6, p0_.exclude AS exclude_7, p0_.reviewed AS reviewed_8, p0_.gcs_time_created AS gcs_time_created_9, p0_.canvasser_email AS canvasser_email_10, p0_.canvasser_id AS canvasser_id_11, p0_.event_time AS event_time_12, p0_.site_name AS site_name_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.last_synced_at AS last_synced_at_16 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.canvass_day >= '2026-08-05' AND p0_.canvass_day <= '2026-08-05' ORDER BY p0_.canvass_day DESC, p0_.canvasser_name ASC, p0_.photo_id ASC) dctrn_result) dctrn_table;

SELECT p0_.photo_id AS photo_id_0, p0_.category AS category_1 FROM photo_category p0_ ORDER BY p0_.category ASC

[]

SELECT
  p0_.photo_id AS photo_id_0,
  p0_.category AS category_1
FROM
  photo_category p0_
ORDER BY
  p0_.category ASC

SELECT p0_.photo_id AS photo_id_0, p0_.category AS category_1 FROM photo_category p0_ ORDER BY p0_.category ASC;

SELECT DISTINCT p0_.canvasser_name AS canvasser_name_0 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.canvasser_name IS NOT NULL ORDER BY p0_.canvasser_name ASC

[]

SELECT
  DISTINCT p0_.canvasser_name AS canvasser_name_0
FROM
  photos p0_
WHERE
  p0_.exclude = 0
  AND p0_.canvasser_name IS NOT NULL
ORDER BY
  p0_.canvasser_name ASC

SELECT DISTINCT p0_.canvasser_name AS canvasser_name_0 FROM photos p0_ WHERE p0_.exclude = 0 AND p0_.canvasser_name IS NOT NULL ORDER BY p0_.canvasser_name ASC;

SELECT MIN(p0_.canvass_day) AS sclr_0, MAX(p0_.canvass_day) AS sclr_1 FROM photos p0_ WHERE p0_.exclude = 0

[]

SELECT
  MIN(p0_.canvass_day) AS sclr_0,
  MAX(p0_.canvass_day) AS sclr_1
FROM
  photos p0_
WHERE
  p0_.exclude = 0

SELECT MIN(p0_.canvass_day) AS sclr_0, MAX(p0_.canvass_day) AS sclr_1 FROM photos p0_ WHERE p0_.exclude = 0;