Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• JMS Serializer 0 + 0
• Configuration

Query Metrics

SELECT i0_.invoice_type AS invoice_type_0, i0_.last_analysis_date AS last_analysis_date_1, i0_.advance_date AS advance_date_2, i0_.invoice_number AS invoice_number_3, i0_.broadcast_date AS broadcast_date_4, i0_.delivery_date AS delivery_date_5, i0_.expiration_date AS expiration_date_6, i0_.days_to_expiration AS days_to_expiration_7, i0_.payment_method AS payment_method_8, i0_.tax_base AS tax_base_9, i0_.tax AS tax_10, i0_.retentions AS retentions_11, i0_.total AS total_12, i0_.supplied_expense AS supplied_expense_13, i0_.attached_document AS attached_document_14, i0_.status AS status_15, i0_.discount AS discount_16, i0_.total_to_receive AS total_to_receive_17, i0_.provider_chooses_advance AS provider_chooses_advance_18, i0_.advance_allowed AS advance_allowed_19, i0_.contract_file AS contract_file_20, i0_.invoice_file AS invoice_file_21, i0_.rectified_document AS rectified_document_22, i0_.signed_contract AS signed_contract_23, i0_.concept AS concept_24, i0_.units AS units_25, i0_.price AS price_26, i0_.date_of_service_provision AS date_of_service_provision_27, i0_.created_at AS created_at_28, i0_.updated_at AS updated_at_29, i0_.id AS id_30, i0_.provider_id AS provider_id_31, i0_.client_id AS client_id_32, i0_.target_id AS target_id_33, i0_.advance_bank_account_id AS advance_bank_account_id_34 FROM invoice i0_ LEFT JOIN user u1_ ON i0_.client_id = u1_.id LEFT JOIN user u2_ ON i0_.provider_id = u2_.id WHERE i0_.status IN (?, ?, ?) AND i0_.expiration_date > ? AND u1_.is_account_active = ? AND u2_.is_account_active = ? AND u1_.is_soft_deleted = ? AND u2_.is_soft_deleted = ? ORDER BY i0_.expiration_date ASC, i0_.updated_at ASC, i0_.created_at ASC

[
  1
  2
  3
  "2024-12-23 23:00:01"
  1
  1
  0
  0
]

SELECT
  i0_.invoice_type AS invoice_type_0,
  i0_.last_analysis_date AS last_analysis_date_1,
  i0_.advance_date AS advance_date_2,
  i0_.invoice_number AS invoice_number_3,
  i0_.broadcast_date AS broadcast_date_4,
  i0_.delivery_date AS delivery_date_5,
  i0_.expiration_date AS expiration_date_6,
  i0_.days_to_expiration AS days_to_expiration_7,
  i0_.payment_method AS payment_method_8,
  i0_.tax_base AS tax_base_9,
  i0_.tax AS tax_10,
  i0_.retentions AS retentions_11,
  i0_.total AS total_12,
  i0_.supplied_expense AS supplied_expense_13,
  i0_.attached_document AS attached_document_14,
  i0_.status AS status_15,
  i0_.discount AS discount_16,
  i0_.total_to_receive AS total_to_receive_17,
  i0_.provider_chooses_advance AS provider_chooses_advance_18,
  i0_.advance_allowed AS advance_allowed_19,
  i0_.contract_file AS contract_file_20,
  i0_.invoice_file AS invoice_file_21,
  i0_.rectified_document AS rectified_document_22,
  i0_.signed_contract AS signed_contract_23,
  i0_.concept AS concept_24,
  i0_.units AS units_25,
  i0_.price AS price_26,
  i0_.date_of_service_provision AS date_of_service_provision_27,
  i0_.created_at AS created_at_28,
  i0_.updated_at AS updated_at_29,
  i0_.id AS id_30,
  i0_.provider_id AS provider_id_31,
  i0_.client_id AS client_id_32,
  i0_.target_id AS target_id_33,
  i0_.advance_bank_account_id AS advance_bank_account_id_34
FROM
  invoice i0_
  LEFT JOIN user u1_ ON i0_.client_id = u1_.id
  LEFT JOIN user u2_ ON i0_.provider_id = u2_.id
WHERE
  i0_.status IN (?, ?, ?)
  AND i0_.expiration_date > ?
  AND u1_.is_account_active = ?
  AND u2_.is_account_active = ?
  AND u1_.is_soft_deleted = ?
  AND u2_.is_soft_deleted = ?
ORDER BY
  i0_.expiration_date ASC,
  i0_.updated_at ASC,
  i0_.created_at ASC

SELECT i0_.invoice_type AS invoice_type_0, i0_.last_analysis_date AS last_analysis_date_1, i0_.advance_date AS advance_date_2, i0_.invoice_number AS invoice_number_3, i0_.broadcast_date AS broadcast_date_4, i0_.delivery_date AS delivery_date_5, i0_.expiration_date AS expiration_date_6, i0_.days_to_expiration AS days_to_expiration_7, i0_.payment_method AS payment_method_8, i0_.tax_base AS tax_base_9, i0_.tax AS tax_10, i0_.retentions AS retentions_11, i0_.total AS total_12, i0_.supplied_expense AS supplied_expense_13, i0_.attached_document AS attached_document_14, i0_.status AS status_15, i0_.discount AS discount_16, i0_.total_to_receive AS total_to_receive_17, i0_.provider_chooses_advance AS provider_chooses_advance_18, i0_.advance_allowed AS advance_allowed_19, i0_.contract_file AS contract_file_20, i0_.invoice_file AS invoice_file_21, i0_.rectified_document AS rectified_document_22, i0_.signed_contract AS signed_contract_23, i0_.concept AS concept_24, i0_.units AS units_25, i0_.price AS price_26, i0_.date_of_service_provision AS date_of_service_provision_27, i0_.created_at AS created_at_28, i0_.updated_at AS updated_at_29, i0_.id AS id_30, i0_.provider_id AS provider_id_31, i0_.client_id AS client_id_32, i0_.target_id AS target_id_33, i0_.advance_bank_account_id AS advance_bank_account_id_34 FROM invoice i0_ LEFT JOIN user u1_ ON i0_.client_id = u1_.id LEFT JOIN user u2_ ON i0_.provider_id = u2_.id WHERE i0_.status IN (1, 2, 3) AND i0_.expiration_date > '2024-12-23 23:00:01' AND u1_.is_account_active = 1 AND u2_.is_account_active = 1 AND u1_.is_soft_deleted = 0 AND u2_.is_soft_deleted = 0 ORDER BY i0_.expiration_date ASC, i0_.updated_at ASC, i0_.created_at ASC;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO cron_result (success, message, stats, created_at, updated_at, id) VALUES (?, ?, ?, ?, ?, ?)

[
  1
  "Cron executed successfully"
  "{"analysis":{"PASS":[],"FAIL":[]},"processedUsers":[],"processedInvoices":[],"successfulProcessing":[],"failedProcessing":[]}"
  "2024-12-23 23:00:01"
  "2024-12-23 23:00:01"
  "d7b52a5c-61fe-438d-8e97-a7d64a125acd"
]

INSERT INTO cron_result (
  success, message, stats, created_at,
  updated_at, id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO cron_result (success, message, stats, created_at, updated_at, id) VALUES (1, 'Cron executed successfully', '{\"analysis\":{\"PASS\":[],\"FAIL\":[]},\"processedUsers\":[],\"processedInvoices\":[],\"successfulProcessing\":[],\"failedProcessing\":[]}', '2024-12-23 23:00:01', '2024-12-23 23:00:01', 'd7b52a5c-61fe-438d-8e97-a7d64a125acd');

"COMMIT"

[]

"COMMIT"

"COMMIT";