Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 29
• Events
• Routing
• Cache
• Translation 2
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 1
• Migrations
• Debug
• Messages
• Emails
• Workflow
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.status AS status_6, t0.mobile_number AS mobile_number_7, t0.manage_quote AS manage_quote_8, t0.manage_file_deletion AS manage_file_deletion_9, t0.manage_export AS manage_export_10, t0.manage_export_limited AS manage_export_limited_11, t0.sales_department AS sales_department_12, t0.last_activity_timestamp AS last_activity_timestamp_13, t0.password_reset_token AS password_reset_token_14, t0.hex_colour AS hex_colour_15 FROM user t0 WHERE t0.id = ?

[
  88
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.status AS status_6,
  t0.mobile_number AS mobile_number_7,
  t0.manage_quote AS manage_quote_8,
  t0.manage_file_deletion AS manage_file_deletion_9,
  t0.manage_export AS manage_export_10,
  t0.manage_export_limited AS manage_export_limited_11,
  t0.sales_department AS sales_department_12,
  t0.last_activity_timestamp AS last_activity_timestamp_13,
  t0.password_reset_token AS password_reset_token_14,
  t0.hex_colour AS hex_colour_15
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.status AS status_6, t0.mobile_number AS mobile_number_7, t0.manage_quote AS manage_quote_8, t0.manage_file_deletion AS manage_file_deletion_9, t0.manage_export AS manage_export_10, t0.manage_export_limited AS manage_export_limited_11, t0.sales_department AS sales_department_12, t0.last_activity_timestamp AS last_activity_timestamp_13, t0.password_reset_token AS password_reset_token_14, t0.hex_colour AS hex_colour_15 FROM user t0 WHERE t0.id = 88;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE user SET last_activity_timestamp = ? WHERE id = ?

[
  1781272698
  88
]

UPDATE
  user
SET
  last_activity_timestamp = ?
WHERE
  id = ?

UPDATE user SET last_activity_timestamp = 1781272698 WHERE id = 88;

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.additional_name AS additional_name_2, c0_.stripe_id AS stripe_id_3, c0_.address_lines AS address_lines_4, c0_.address_town AS address_town_5, c0_.address_postcode AS address_postcode_6, c0_.address_county AS address_county_7, c0_.address_country AS address_country_8, c0_.created_at_timestamp AS created_at_timestamp_9, c0_.updated_at_timestamp AS updated_at_timestamp_10, c0_.contact_number AS contact_number_11, c0_.e164_contact_number AS e164_contact_number_12, c0_.email_address AS email_address_13, c0_.latitude AS latitude_14, c0_.longitude AS longitude_15, c0_.display_id AS display_id_16, c0_.created_by_user_id AS created_by_user_id_17, c0_.last_updated_by_user_id AS last_updated_by_user_id_18, c0_.xero_guid_id AS xero_guid_id_19 FROM customer c0_ LEFT JOIN project p1_ ON c0_.id = p1_.customer_id ORDER BY c0_.created_at_timestamp DESC

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.additional_name AS additional_name_2,
  c0_.stripe_id AS stripe_id_3,
  c0_.address_lines AS address_lines_4,
  c0_.address_town AS address_town_5,
  c0_.address_postcode AS address_postcode_6,
  c0_.address_county AS address_county_7,
  c0_.address_country AS address_country_8,
  c0_.created_at_timestamp AS created_at_timestamp_9,
  c0_.updated_at_timestamp AS updated_at_timestamp_10,
  c0_.contact_number AS contact_number_11,
  c0_.e164_contact_number AS e164_contact_number_12,
  c0_.email_address AS email_address_13,
  c0_.latitude AS latitude_14,
  c0_.longitude AS longitude_15,
  c0_.display_id AS display_id_16,
  c0_.created_by_user_id AS created_by_user_id_17,
  c0_.last_updated_by_user_id AS last_updated_by_user_id_18,
  c0_.xero_guid_id AS xero_guid_id_19
FROM
  customer c0_
  LEFT JOIN project p1_ ON c0_.id = p1_.customer_id
ORDER BY
  c0_.created_at_timestamp DESC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.additional_name AS additional_name_2, c0_.stripe_id AS stripe_id_3, c0_.address_lines AS address_lines_4, c0_.address_town AS address_town_5, c0_.address_postcode AS address_postcode_6, c0_.address_county AS address_county_7, c0_.address_country AS address_country_8, c0_.created_at_timestamp AS created_at_timestamp_9, c0_.updated_at_timestamp AS updated_at_timestamp_10, c0_.contact_number AS contact_number_11, c0_.e164_contact_number AS e164_contact_number_12, c0_.email_address AS email_address_13, c0_.latitude AS latitude_14, c0_.longitude AS longitude_15, c0_.display_id AS display_id_16, c0_.created_by_user_id AS created_by_user_id_17, c0_.last_updated_by_user_id AS last_updated_by_user_id_18, c0_.xero_guid_id AS xero_guid_id_19 FROM customer c0_ LEFT JOIN project p1_ ON c0_.id = p1_.customer_id ORDER BY c0_.created_at_timestamp DESC;

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM customer c0_ LEFT JOIN project p1_ ON c0_.id = p1_.customer_id

[]

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  customer c0_
  LEFT JOIN project p1_ ON c0_.id = p1_.customer_id

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM customer c0_ LEFT JOIN project p1_ ON c0_.id = p1_.customer_id;

SELECT DISTINCT c0_.id AS id_0, c0_.created_at_timestamp AS created_at_timestamp_1 FROM customer c0_ LEFT JOIN project p1_ ON c0_.id = p1_.customer_id ORDER BY c0_.created_at_timestamp DESC LIMIT 20

[]

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.created_at_timestamp AS created_at_timestamp_1
FROM
  customer c0_
  LEFT JOIN project p1_ ON c0_.id = p1_.customer_id
ORDER BY
  c0_.created_at_timestamp DESC
LIMIT
  20

SELECT DISTINCT c0_.id AS id_0, c0_.created_at_timestamp AS created_at_timestamp_1 FROM customer c0_ LEFT JOIN project p1_ ON c0_.id = p1_.customer_id ORDER BY c0_.created_at_timestamp DESC LIMIT 20;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.additional_name AS additional_name_2, c0_.stripe_id AS stripe_id_3, c0_.address_lines AS address_lines_4, c0_.address_town AS address_town_5, c0_.address_postcode AS address_postcode_6, c0_.address_county AS address_county_7, c0_.address_country AS address_country_8, c0_.created_at_timestamp AS created_at_timestamp_9, c0_.updated_at_timestamp AS updated_at_timestamp_10, c0_.contact_number AS contact_number_11, c0_.e164_contact_number AS e164_contact_number_12, c0_.email_address AS email_address_13, c0_.latitude AS latitude_14, c0_.longitude AS longitude_15, c0_.display_id AS display_id_16, c0_.created_by_user_id AS created_by_user_id_17, c0_.last_updated_by_user_id AS last_updated_by_user_id_18, c0_.xero_guid_id AS xero_guid_id_19 FROM customer c0_ LEFT JOIN project p1_ ON c0_.id = p1_.customer_id WHERE c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.created_at_timestamp DESC

[
  24019
  24018
  24017
  24016
  24015
  24014
  24013
  24012
  24011
  24010
  24009
  24008
  24007
  24006
  24005
  24004
  24003
  24002
  24001
  24000
]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.additional_name AS additional_name_2,
  c0_.stripe_id AS stripe_id_3,
  c0_.address_lines AS address_lines_4,
  c0_.address_town AS address_town_5,
  c0_.address_postcode AS address_postcode_6,
  c0_.address_county AS address_county_7,
  c0_.address_country AS address_country_8,
  c0_.created_at_timestamp AS created_at_timestamp_9,
  c0_.updated_at_timestamp AS updated_at_timestamp_10,
  c0_.contact_number AS contact_number_11,
  c0_.e164_contact_number AS e164_contact_number_12,
  c0_.email_address AS email_address_13,
  c0_.latitude AS latitude_14,
  c0_.longitude AS longitude_15,
  c0_.display_id AS display_id_16,
  c0_.created_by_user_id AS created_by_user_id_17,
  c0_.last_updated_by_user_id AS last_updated_by_user_id_18,
  c0_.xero_guid_id AS xero_guid_id_19
FROM
  customer c0_
  LEFT JOIN project p1_ ON c0_.id = p1_.customer_id
WHERE
  c0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  c0_.created_at_timestamp DESC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.additional_name AS additional_name_2, c0_.stripe_id AS stripe_id_3, c0_.address_lines AS address_lines_4, c0_.address_town AS address_town_5, c0_.address_postcode AS address_postcode_6, c0_.address_county AS address_county_7, c0_.address_country AS address_country_8, c0_.created_at_timestamp AS created_at_timestamp_9, c0_.updated_at_timestamp AS updated_at_timestamp_10, c0_.contact_number AS contact_number_11, c0_.e164_contact_number AS e164_contact_number_12, c0_.email_address AS email_address_13, c0_.latitude AS latitude_14, c0_.longitude AS longitude_15, c0_.display_id AS display_id_16, c0_.created_by_user_id AS created_by_user_id_17, c0_.last_updated_by_user_id AS last_updated_by_user_id_18, c0_.xero_guid_id AS xero_guid_id_19 FROM customer c0_ LEFT JOIN project p1_ ON c0_.id = p1_.customer_id WHERE c0_.id IN (24019, 24018, 24017, 24016, 24015, 24014, 24013, 24012, 24011, 24010, 24009, 24008, 24007, 24006, 24005, 24004, 24003, 24002, 24001, 24000) ORDER BY c0_.created_at_timestamp DESC;