Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 72
• Events
• Routing
• Cache
• Translation 10
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• Configuration

Query Metrics

SELECT t0.enabled AS enabled_1, t0.salt AS salt_2, t0.password AS password_3, t0.last_login AS last_login_4, t0.confirmation_token AS confirmation_token_5, t0.password_requested_at AS password_requested_at_6, t0.id AS id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.user_type AS user_type_10, t0.roles AS roles_11, t0.email AS email_12, t0.email_canonical AS email_canonical_13, t0.username AS username_14, t0.username_canonical AS username_canonical_15, t0.distributor_id AS distributor_id_16, t0.crm_repo_id AS crm_repo_id_17, t0.practice_id AS practice_id_18, t0.provider_id AS provider_id_19 FROM user t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.enabled AS enabled_1,
  t0.salt AS salt_2,
  t0.password AS password_3,
  t0.last_login AS last_login_4,
  t0.confirmation_token AS confirmation_token_5,
  t0.password_requested_at AS password_requested_at_6,
  t0.id AS id_7,
  t0.first_name AS first_name_8,
  t0.last_name AS last_name_9,
  t0.user_type AS user_type_10,
  t0.roles AS roles_11,
  t0.email AS email_12,
  t0.email_canonical AS email_canonical_13,
  t0.username AS username_14,
  t0.username_canonical AS username_canonical_15,
  t0.distributor_id AS distributor_id_16,
  t0.crm_repo_id AS crm_repo_id_17,
  t0.practice_id AS practice_id_18,
  t0.provider_id AS provider_id_19
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.enabled AS enabled_1, t0.salt AS salt_2, t0.password AS password_3, t0.last_login AS last_login_4, t0.confirmation_token AS confirmation_token_5, t0.password_requested_at AS password_requested_at_6, t0.id AS id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.user_type AS user_type_10, t0.roles AS roles_11, t0.email AS email_12, t0.email_canonical AS email_canonical_13, t0.username AS username_14, t0.username_canonical AS username_canonical_15, t0.distributor_id AS distributor_id_16, t0.crm_repo_id AS crm_repo_id_17, t0.practice_id AS practice_id_18, t0.provider_id AS provider_id_19 FROM user t0 WHERE t0.id = 2;

SELECT t0.id AS id_1, t0.setting AS setting_2, t0.slug AS slug_3 FROM settings t0 WHERE t0.slug = ? LIMIT 1

[
  "setting"
]

SELECT
  t0.id AS id_1,
  t0.setting AS setting_2,
  t0.slug AS slug_3
FROM
  settings t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting AS setting_2, t0.slug AS slug_3 FROM settings t0 WHERE t0.slug = 'setting' LIMIT 1;

SELECT COUNT(c0_.id) AS sclr_0 FROM claim c0_ WHERE YEAR(c0_.claim_insert_date) = ? AND MONTH(c0_.claim_insert_date) = ? AND c0_.id LIKE ?

[
  "2026"
  "02"
  "%"
]

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  claim c0_
WHERE
  YEAR(c0_.claim_insert_date) = ?
  AND MONTH(c0_.claim_insert_date) = ?
  AND c0_.id LIKE ?

SELECT COUNT(c0_.id) AS sclr_0 FROM claim c0_ WHERE YEAR(c0_.claim_insert_date) = '2026' AND MONTH(c0_.claim_insert_date) = '02' AND c0_.id LIKE '%';

SELECT count(*) as count
                    FROM invoice 
                    INNER JOIN claim c on c.`claim_invoice_id` = invoice.`id`
                    INNER JOIN advanced_insurance_check_claim aicc on aicc.`advanced_insurance_check_claim_claim_id` = c.`id`
                    WHERE c.`claim_sent` = '1' 
                    and aicc.`advanced_insurance_check_claims_denied` = '1'
                    and invoice.id like CONCAT(?, '%')
                    and aicc.advanced_insurance_check_claim_insert_date = (
                        SELECT MAX(sub.advanced_insurance_check_claim_insert_date)
                        FROM advanced_insurance_check_claim sub
                        WHERE sub.advanced_insurance_check_claim_claim_id = c.id
                    )

[
  null
]

SELECT
  count(*) as count
FROM
  invoice
  INNER JOIN claim c on c.`claim_invoice_id` = invoice.`id`
  INNER JOIN advanced_insurance_check_claim aicc on aicc.`advanced_insurance_check_claim_claim_id` = c.`id`
WHERE
  c.`claim_sent` = '1'
  and aicc.`advanced_insurance_check_claims_denied` = '1'
  and invoice.id like CONCAT(?, '%')
  and aicc.advanced_insurance_check_claim_insert_date = (
    SELECT
      MAX(
        sub.advanced_insurance_check_claim_insert_date
      )
    FROM
      advanced_insurance_check_claim sub
    WHERE
      sub.advanced_insurance_check_claim_claim_id = c.id
  )

SELECT count(*) as count
                    FROM invoice 
                    INNER JOIN claim c on c.`claim_invoice_id` = invoice.`id`
                    INNER JOIN advanced_insurance_check_claim aicc on aicc.`advanced_insurance_check_claim_claim_id` = c.`id`
                    WHERE c.`claim_sent` = '1' 
                    and aicc.`advanced_insurance_check_claims_denied` = '1'
                    and invoice.id like CONCAT(NULL, '%')
                    and aicc.advanced_insurance_check_claim_insert_date = (
                        SELECT MAX(sub.advanced_insurance_check_claim_insert_date)
                        FROM advanced_insurance_check_claim sub
                        WHERE sub.advanced_insurance_check_claim_claim_id = c.id
                    );

SELECT COUNT(i0_.id) AS sclr_0 FROM invoice i0_ INNER JOIN claim c1_ ON (c1_.claim_invoice_id = i0_.id) WHERE c1_.claim_rejected = ? AND c1_.claim_sent = ? AND i0_.id LIKE ?

[
  "1"
  "1"
  "%"
]

SELECT
  COUNT(i0_.id) AS sclr_0
FROM
  invoice i0_
  INNER JOIN claim c1_ ON (c1_.claim_invoice_id = i0_.id)
WHERE
  c1_.claim_rejected = ?
  AND c1_.claim_sent = ?
  AND i0_.id LIKE ?

SELECT COUNT(i0_.id) AS sclr_0 FROM invoice i0_ INNER JOIN claim c1_ ON (c1_.claim_invoice_id = i0_.id) WHERE c1_.claim_rejected = '1' AND c1_.claim_sent = '1' AND i0_.id LIKE '%';

SELECT SUM(t0_.transaction_amount) AS sclr_0 FROM transaction t0_ LEFT JOIN transaction_type t1_ ON (t1_.id = t0_.transaction_transaction_type_id) WHERE YEAR(t0_.transaction_insert_date) = ? AND MONTH(t0_.transaction_insert_date) = ? AND t0_.id LIKE ? AND (t1_.transaction_type_category_id LIKE ? OR t1_.transaction_type_category_id LIKE ?)

[
  "2026"
  "02"
  "%"
  "%1"
  "%2"
]

SELECT
  SUM(t0_.transaction_amount) AS sclr_0
FROM
  transaction t0_
  LEFT JOIN transaction_type t1_ ON (
    t1_.id = t0_.transaction_transaction_type_id
  )
WHERE
  YEAR(t0_.transaction_insert_date) = ?
  AND MONTH(t0_.transaction_insert_date) = ?
  AND t0_.id LIKE ?
  AND (
    t1_.transaction_type_category_id LIKE ?
    OR t1_.transaction_type_category_id LIKE ?
  )

SELECT SUM(t0_.transaction_amount) AS sclr_0 FROM transaction t0_ LEFT JOIN transaction_type t1_ ON (t1_.id = t0_.transaction_transaction_type_id) WHERE YEAR(t0_.transaction_insert_date) = '2026' AND MONTH(t0_.transaction_insert_date) = '02' AND t0_.id LIKE '%' AND (t1_.transaction_type_category_id LIKE '%1' OR t1_.transaction_type_category_id LIKE '%2');

SELECT c0_.id AS id_0, c0_.crm_practice_name AS crm_practice_name_1, c0_.crm_practice_npi AS crm_practice_npi_2, c0_.crm_practice_acronym AS crm_practice_acronym_3, c0_.crm_practice_req AS crm_practice_req_4, c0_.crm_practice_active AS crm_practice_active_5 FROM crmpractice c0_ WHERE c0_.crm_practice_active = 0 ORDER BY c0_.crm_practice_name ASC

[]

SELECT
  c0_.id AS id_0,
  c0_.crm_practice_name AS crm_practice_name_1,
  c0_.crm_practice_npi AS crm_practice_npi_2,
  c0_.crm_practice_acronym AS crm_practice_acronym_3,
  c0_.crm_practice_req AS crm_practice_req_4,
  c0_.crm_practice_active AS crm_practice_active_5
FROM
  crmpractice c0_
WHERE
  c0_.crm_practice_active = 0
ORDER BY
  c0_.crm_practice_name ASC

SELECT c0_.id AS id_0, c0_.crm_practice_name AS crm_practice_name_1, c0_.crm_practice_npi AS crm_practice_npi_2, c0_.crm_practice_acronym AS crm_practice_acronym_3, c0_.crm_practice_req AS crm_practice_req_4, c0_.crm_practice_active AS crm_practice_active_5 FROM crmpractice c0_ WHERE c0_.crm_practice_active = 0 ORDER BY c0_.crm_practice_name ASC;