Symfony Profiler

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

Query Metrics

SELECT a0_.id AS id_0, a0_.role AS role_1, a0_.scope AS scope_2, a0_.is_active AS is_active_3, a0_.created_at AS created_at_4, a0_.account_id AS account_id_5, a0_.company_id AS company_id_6, a0_.team_id AS team_id_7 FROM account_role a0_ WHERE a0_.account_id = ? AND a0_.is_active = true

[
  450
]

SELECT
  a0_.id AS id_0,
  a0_.role AS role_1,
  a0_.scope AS scope_2,
  a0_.is_active AS is_active_3,
  a0_.created_at AS created_at_4,
  a0_.account_id AS account_id_5,
  a0_.company_id AS company_id_6,
  a0_.team_id AS team_id_7
FROM
  account_role a0_
WHERE
  a0_.account_id = ?
  AND a0_.is_active = true

SELECT a0_.id AS id_0, a0_.role AS role_1, a0_.scope AS scope_2, a0_.is_active AS is_active_3, a0_.created_at AS created_at_4, a0_.account_id AS account_id_5, a0_.company_id AS company_id_6, a0_.team_id AS team_id_7 FROM account_role a0_ WHERE a0_.account_id = 450 AND a0_.is_active = true;

SELECT t0.id AS id_1, t0.email AS email_2, t0.full_name AS full_name_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.contact_info AS contact_info_7, t0.timezone AS timezone_8, t0.current_company_id AS current_company_id_9, t0.current_team_id AS current_team_id_10 FROM account t0 WHERE t0.id = ? LIMIT 1

[
  450
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.full_name AS full_name_3,
  t0.password AS password_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.contact_info AS contact_info_7,
  t0.timezone AS timezone_8,
  t0.current_company_id AS current_company_id_9,
  t0.current_team_id AS current_team_id_10
FROM
  account t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.full_name AS full_name_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.contact_info AS contact_info_7, t0.timezone AS timezone_8, t0.current_company_id AS current_company_id_9, t0.current_team_id AS current_team_id_10 FROM account t0 WHERE t0.id = 450 LIMIT 1;

SELECT t0.id AS id_1, t0.account_id AS account_id_2, t0.expires_in AS expires_in_3, t0.token AS token_4, t0.created_at AS created_at_5 FROM access_token t0 WHERE t0.token = ? LIMIT 1

[
  "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3ODA5NjM0ODgsImV4cCI6MTc4MjI1OTQ4OCwicm9sZXMiOlsiUk9MRV9NRU1CRVIiXSwidXNlcm5hbWUiOiJhZG1pbkBjb3p5LmNvbSJ9.WdU8vP4HKy-jVmacN-uOoyndFEcaZnXPskS46wgo5_eM0w2FGahXyd0vlltZ1iGF6lZABqLhKzl7RuIsmceuEO1Wka4i3mZgOYD459tWbUI4wNQmjDkmrtTPcT4LmnIcKKq-XCAt7c1TpGx27azGQSypbutuiXKAMfEV9jG23EDfqFQ7kYs5MOr7udkiQ5TI9-lq-rPC6ECtuGk51KjKmsqoF97cwNIZOfjWM6308kh5saaUQTf0yP6howYZi0480SKQLJRzoehI1Cf_xK2pFg3FJmW3pjAJma6Ih1PkXoIn2c3Lc-IJxA3gMaBJtdXoc1X5xsTr6u-fI_HBD5GKlw"
]

SELECT
  t0.id AS id_1,
  t0.account_id AS account_id_2,
  t0.expires_in AS expires_in_3,
  t0.token AS token_4,
  t0.created_at AS created_at_5
FROM
  access_token t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.account_id AS account_id_2, t0.expires_in AS expires_in_3, t0.token AS token_4, t0.created_at AS created_at_5 FROM access_token t0 WHERE t0.token = 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3ODA5NjM0ODgsImV4cCI6MTc4MjI1OTQ4OCwicm9sZXMiOlsiUk9MRV9NRU1CRVIiXSwidXNlcm5hbWUiOiJhZG1pbkBjb3p5LmNvbSJ9.WdU8vP4HKy-jVmacN-uOoyndFEcaZnXPskS46wgo5_eM0w2FGahXyd0vlltZ1iGF6lZABqLhKzl7RuIsmceuEO1Wka4i3mZgOYD459tWbUI4wNQmjDkmrtTPcT4LmnIcKKq-XCAt7c1TpGx27azGQSypbutuiXKAMfEV9jG23EDfqFQ7kYs5MOr7udkiQ5TI9-lq-rPC6ECtuGk51KjKmsqoF97cwNIZOfjWM6308kh5saaUQTf0yP6howYZi0480SKQLJRzoehI1Cf_xK2pFg3FJmW3pjAJma6Ih1PkXoIn2c3Lc-IJxA3gMaBJtdXoc1X5xsTr6u-fI_HBD5GKlw' LIMIT 1;

SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.todo_date AS todo_date_3, t0.status AS status_4, t0.priority AS priority_5, t0.assignee_id AS assignee_id_6, t0.created_at AS created_at_7, t0.company_id AS company_id_8, t0.listing_id AS listing_id_9, t0.related_task_id AS related_task_id_10, t0.reported_by AS reported_by_11, t0.team_id AS team_id_12, t0.started_at AS started_at_13, t0.completed_at AS completed_at_14, t0.completed_by AS completed_by_15, t0.estimated_duration AS estimated_duration_16, t0.actual_duration AS actual_duration_17, t0.updated_at AS updated_at_18, t0.inspection_status AS inspection_status_19, t0.inspected_by AS inspected_by_20, t0.inspected_at AS inspected_at_21, t0.source_issue_id AS source_issue_id_22, t0.cancelled_at AS cancelled_at_23, t0.due_at AS due_at_24, t0.unit_price AS unit_price_25, t0.is_deleted AS is_deleted_26, t0.type, t0.checkout_time AS checkout_time_27, t0.guest_name AS guest_name_28, t0.number_of_guests AS number_of_guests_29, t0.next_checkin_time AS next_checkin_time_30, t0.damage_check_completed AS damage_check_completed_31, t0.checkin_time AS checkin_time_32, t0.guest_name AS guest_name_33, t0.number_of_guests AS number_of_guests_34, t0.maintenance_type AS maintenance_type_35, t0.actual_cost AS actual_cost_36, t0.vendor_name AS vendor_name_37, t0.vendor_phone AS vendor_phone_38 FROM task t0 WHERE t0.id = ? AND t0.type IN ('CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING', 'MAINTENANCE')

[
  102457
]

SELECT
  t0.id AS id_1,
  t0.order_id AS order_id_2,
  t0.todo_date AS todo_date_3,
  t0.status AS status_4,
  t0.priority AS priority_5,
  t0.assignee_id AS assignee_id_6,
  t0.created_at AS created_at_7,
  t0.company_id AS company_id_8,
  t0.listing_id AS listing_id_9,
  t0.related_task_id AS related_task_id_10,
  t0.reported_by AS reported_by_11,
  t0.team_id AS team_id_12,
  t0.started_at AS started_at_13,
  t0.completed_at AS completed_at_14,
  t0.completed_by AS completed_by_15,
  t0.estimated_duration AS estimated_duration_16,
  t0.actual_duration AS actual_duration_17,
  t0.updated_at AS updated_at_18,
  t0.inspection_status AS inspection_status_19,
  t0.inspected_by AS inspected_by_20,
  t0.inspected_at AS inspected_at_21,
  t0.source_issue_id AS source_issue_id_22,
  t0.cancelled_at AS cancelled_at_23,
  t0.due_at AS due_at_24,
  t0.unit_price AS unit_price_25,
  t0.is_deleted AS is_deleted_26,
  t0.type,
  t0.checkout_time AS checkout_time_27,
  t0.guest_name AS guest_name_28,
  t0.number_of_guests AS number_of_guests_29,
  t0.next_checkin_time AS next_checkin_time_30,
  t0.damage_check_completed AS damage_check_completed_31,
  t0.checkin_time AS checkin_time_32,
  t0.guest_name AS guest_name_33,
  t0.number_of_guests AS number_of_guests_34,
  t0.maintenance_type AS maintenance_type_35,
  t0.actual_cost AS actual_cost_36,
  t0.vendor_name AS vendor_name_37,
  t0.vendor_phone AS vendor_phone_38
FROM
  task t0
WHERE
  t0.id = ?
  AND t0.type IN (
    'CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING',
    'MAINTENANCE'
  )

SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.todo_date AS todo_date_3, t0.status AS status_4, t0.priority AS priority_5, t0.assignee_id AS assignee_id_6, t0.created_at AS created_at_7, t0.company_id AS company_id_8, t0.listing_id AS listing_id_9, t0.related_task_id AS related_task_id_10, t0.reported_by AS reported_by_11, t0.team_id AS team_id_12, t0.started_at AS started_at_13, t0.completed_at AS completed_at_14, t0.completed_by AS completed_by_15, t0.estimated_duration AS estimated_duration_16, t0.actual_duration AS actual_duration_17, t0.updated_at AS updated_at_18, t0.inspection_status AS inspection_status_19, t0.inspected_by AS inspected_by_20, t0.inspected_at AS inspected_at_21, t0.source_issue_id AS source_issue_id_22, t0.cancelled_at AS cancelled_at_23, t0.due_at AS due_at_24, t0.unit_price AS unit_price_25, t0.is_deleted AS is_deleted_26, t0.type, t0.checkout_time AS checkout_time_27, t0.guest_name AS guest_name_28, t0.number_of_guests AS number_of_guests_29, t0.next_checkin_time AS next_checkin_time_30, t0.damage_check_completed AS damage_check_completed_31, t0.checkin_time AS checkin_time_32, t0.guest_name AS guest_name_33, t0.number_of_guests AS number_of_guests_34, t0.maintenance_type AS maintenance_type_35, t0.actual_cost AS actual_cost_36, t0.vendor_name AS vendor_name_37, t0.vendor_phone AS vendor_phone_38 FROM task t0 WHERE t0.id = 102457 AND t0.type IN ('CHECK_OUT', 'CHECK_IN', 'ONE_TIME_CLEANING', 'MAINTENANCE');

SELECT t0.id AS id_1, t0.team_name AS team_name_2, t0.phone_number AS phone_number_3, t0.email AS email_4, t0.cleaning_rules AS cleaning_rules_5, t0.company_id AS company_id_6, t0.created_at AS created_at_7 FROM team t0 WHERE t0.id = ?

[
  10
]

SELECT
  t0.id AS id_1,
  t0.team_name AS team_name_2,
  t0.phone_number AS phone_number_3,
  t0.email AS email_4,
  t0.cleaning_rules AS cleaning_rules_5,
  t0.company_id AS company_id_6,
  t0.created_at AS created_at_7
FROM
  team t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.team_name AS team_name_2, t0.phone_number AS phone_number_3, t0.email AS email_4, t0.cleaning_rules AS cleaning_rules_5, t0.company_id AS company_id_6, t0.created_at AS created_at_7 FROM team t0 WHERE t0.id = 10;

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.phone_number AS phone_number_3, t0.email AS email_4, t0.created_at AS created_at_5, t0.cleaning_rules AS cleaning_rules_6 FROM company t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.phone_number AS phone_number_3,
  t0.email AS email_4,
  t0.created_at AS created_at_5,
  t0.cleaning_rules AS cleaning_rules_6
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.phone_number AS phone_number_3, t0.email AS email_4, t0.created_at AS created_at_5, t0.cleaning_rules AS cleaning_rules_6 FROM company t0 WHERE t0.id = 1;