Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Security
• Twig
• Doctrine 1
• Emails 1
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.address_line_one AS address_line_one_3, t0.address_line_two AS address_line_two_4, t0.address_line_three AS address_line_three_5, t0.city AS city_6, t0.county AS county_7, t0.post_code AS post_code_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.default_event_description AS default_event_description_11, t0.region_id AS region_id_12 FROM site t0 WHERE t0.name = ? LIMIT 1

[
  "Brighton"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address_line_one AS address_line_one_3,
  t0.address_line_two AS address_line_two_4,
  t0.address_line_three AS address_line_three_5,
  t0.city AS city_6,
  t0.county AS county_7,
  t0.post_code AS post_code_8,
  t0.latitude AS latitude_9,
  t0.longitude AS longitude_10,
  t0.default_event_description AS default_event_description_11,
  t0.region_id AS region_id_12
FROM
  site t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.address_line_one AS address_line_one_3, t0.address_line_two AS address_line_two_4, t0.address_line_three AS address_line_three_5, t0.city AS city_6, t0.county AS county_7, t0.post_code AS post_code_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.default_event_description AS default_event_description_11, t0.region_id AS region_id_12 FROM site t0 WHERE t0.name = 'Brighton' LIMIT 1;

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date AS date_2, e0_.recurring AS recurring_3, e0_.bookable AS bookable_4, e0_.max_guests AS max_guests_5, e0_.guest_count AS guest_count_6, e0_.show_phone_on_form AS show_phone_on_form_7, e0_.site_id AS site_id_8 FROM event e0_ WHERE e0_.site_id = ? AND e0_.date > ? AND e0_.bookable = ? ORDER BY e0_.date ASC

[
  57
  "2024-12-03 17:46:53"
  1
]

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.date AS date_2,
  e0_.recurring AS recurring_3,
  e0_.bookable AS bookable_4,
  e0_.max_guests AS max_guests_5,
  e0_.guest_count AS guest_count_6,
  e0_.show_phone_on_form AS show_phone_on_form_7,
  e0_.site_id AS site_id_8
FROM
  event e0_
WHERE
  e0_.site_id = ?
  AND e0_.date > ?
  AND e0_.bookable = ?
ORDER BY
  e0_.date ASC

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date AS date_2, e0_.recurring AS recurring_3, e0_.bookable AS bookable_4, e0_.max_guests AS max_guests_5, e0_.guest_count AS guest_count_6, e0_.show_phone_on_form AS show_phone_on_form_7, e0_.site_id AS site_id_8 FROM event e0_ WHERE e0_.site_id = 57 AND e0_.date > '2024-12-03 17:46:53' AND e0_.bookable = 1 ORDER BY e0_.date ASC;

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date AS date_2, e0_.recurring AS recurring_3, e0_.bookable AS bookable_4, e0_.max_guests AS max_guests_5, e0_.guest_count AS guest_count_6, e0_.show_phone_on_form AS show_phone_on_form_7, e0_.site_id AS site_id_8 FROM event e0_ WHERE e0_.site_id = ? AND e0_.date > ? ORDER BY e0_.date ASC

[
  57
  "2024-12-03 17:46:53"
]

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.date AS date_2,
  e0_.recurring AS recurring_3,
  e0_.bookable AS bookable_4,
  e0_.max_guests AS max_guests_5,
  e0_.guest_count AS guest_count_6,
  e0_.show_phone_on_form AS show_phone_on_form_7,
  e0_.site_id AS site_id_8
FROM
  event e0_
WHERE
  e0_.site_id = ?
  AND e0_.date > ?
ORDER BY
  e0_.date ASC

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date AS date_2, e0_.recurring AS recurring_3, e0_.bookable AS bookable_4, e0_.max_guests AS max_guests_5, e0_.guest_count AS guest_count_6, e0_.show_phone_on_form AS show_phone_on_form_7, e0_.site_id AS site_id_8 FROM event e0_ WHERE e0_.site_id = 57 AND e0_.date > '2024-12-03 17:46:53' ORDER BY e0_.date ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.email AS email_4, t0.event_id AS event_id_5 FROM guest t0 WHERE t0.email = ? AND t0.event_id = ? LIMIT 1

[
  "[email protected]"
  378
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.phone AS phone_3,
  t0.email AS email_4,
  t0.event_id AS event_id_5
FROM
  guest t0
WHERE
  t0.email = ?
  AND t0.event_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.email AS email_4, t0.event_id AS event_id_5 FROM guest t0 WHERE t0.email = '[email protected]' AND t0.event_id = 378 LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO guest (name, phone, email, event_id) VALUES (?, ?, ?, ?)

[
  "Max Hamilton"
  ""
  "[email protected]"
  378
]

INSERT INTO guest (name, phone, email, event_id)
VALUES
  (?, ?, ?, ?)

INSERT INTO guest (name, phone, email, event_id) VALUES ('Max Hamilton', '', '[email protected]', 378);

UPDATE event SET guest_count = ? WHERE id = ?

[
  4
  378
]

UPDATE
  event
SET
  guest_count = ?
WHERE
  id = ?

UPDATE event SET guest_count = 4 WHERE id = 378;

INSERT INTO booking_removal_code (code, guest_id) VALUES (?, ?)

[
  "90a675a81f"
  6423
]

INSERT INTO booking_removal_code (code, guest_id)
VALUES
  (?, ?)

INSERT INTO booking_removal_code (code, guest_id) VALUES ('90a675a81f', 6423);

SELECT t0.id AS id_1, t0.type_name AS type_name_2, t0.type_level AS type_level_3 FROM log_type t0 WHERE t0.type_name = ? LIMIT 1

[
  "INFO"
]

SELECT
  t0.id AS id_1,
  t0.type_name AS type_name_2,
  t0.type_level AS type_level_3
FROM
  log_type t0
WHERE
  t0.type_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type_name AS type_name_2, t0.type_level AS type_level_3 FROM log_type t0 WHERE t0.type_name = 'INFO' LIMIT 1;

INSERT INTO log (created, message, context, extra, tags, details, log_type_id) VALUES (?, ?, ?, ?, ?, ?, ?)

[
  "2024-12-03 17:46:55"
  "Successfully sent email to Max Hamilton at [email protected] for event BTG Brighton - 06 Dec 20:00"
  "[]"
  "[]"
  null
  null
  2
]

INSERT INTO log (
  created, message, context, extra, tags,
  details, log_type_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO log (created, message, context, extra, tags, details, log_type_id) VALUES ('2024-12-03 17:46:55', 'Successfully sent email to Max Hamilton at [email protected] for event BTG Brighton - 06 Dec 20:00', '[]', '[]', NULL, NULL, 2);

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT t0.id AS id_1, t0.type_name AS type_name_2, t0.type_level AS type_level_3 FROM log_type t0 WHERE t0.type_name = ? LIMIT 1

[
  "ALERT"
]

SELECT
  t0.id AS id_1,
  t0.type_name AS type_name_2,
  t0.type_level AS type_level_3
FROM
  log_type t0
WHERE
  t0.type_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type_name AS type_name_2, t0.type_level AS type_level_3 FROM log_type t0 WHERE t0.type_name = 'ALERT' LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO log (created, message, context, extra, tags, details, log_type_id) VALUES (?, ?, ?, ?, ?, ?, ?)

[
  "2024-12-03 17:46:55"
  "New Guest "Max Hamilton" booked onto BTG Brighton - 06 Dec 20:00 - 06 Dec 2024 - 20:00"
  "[]"
  "[]"
  null
  null
  7
]

INSERT INTO log (
  created, message, context, extra, tags,
  details, log_type_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO log (created, message, context, extra, tags, details, log_type_id) VALUES ('2024-12-03 17:46:55', 'New Guest \"Max Hamilton\" booked onto BTG Brighton - 06 Dec 20:00 - 06 Dec 2024 - 20:00', '[]', '[]', NULL, NULL, 7);

"COMMIT"

[]

"COMMIT"

"COMMIT";