Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 54
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Migrations 18
• Debug
• Emails
• Notifications
• Configuration

Query Metrics

SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.dept_name AS dept_name_2, m0_.subscription AS subscription_3, m0_.dept_id AS dept_id_4, m0_.status AS status_5, m0_.nb_rows AS nb_rows_6, m0_.langue AS langue_7, m0_.dept_buy AS dept_buy_8, m0_.dept_rent AS dept_rent_9, m0_.dept_buy_id AS dept_buy_id_10, m0_.dept_rent_id AS dept_rent_id_11, m0_.created_by_id AS created_by_id_12 FROM migration m0_ LEFT JOIN subscription_file s1_ ON (m0_.id = s1_.migration_id) WHERE m0_.subscription = ? AND m0_.dept_id = ? AND s1_.name = ?

[
  126
  201
  "generatedcontacts100k-9b4a5e6d2efeafd4b82d38432266d600.csv"
]

SELECT
  m0_.id AS id_0,
  m0_.created_at AS created_at_1,
  m0_.dept_name AS dept_name_2,
  m0_.subscription AS subscription_3,
  m0_.dept_id AS dept_id_4,
  m0_.status AS status_5,
  m0_.nb_rows AS nb_rows_6,
  m0_.langue AS langue_7,
  m0_.dept_buy AS dept_buy_8,
  m0_.dept_rent AS dept_rent_9,
  m0_.dept_buy_id AS dept_buy_id_10,
  m0_.dept_rent_id AS dept_rent_id_11,
  m0_.created_by_id AS created_by_id_12
FROM
  migration m0_
  LEFT JOIN subscription_file s1_ ON (m0_.id = s1_.migration_id)
WHERE
  m0_.subscription = ?
  AND m0_.dept_id = ?
  AND s1_.name = ?

SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.dept_name AS dept_name_2, m0_.subscription AS subscription_3, m0_.dept_id AS dept_id_4, m0_.status AS status_5, m0_.nb_rows AS nb_rows_6, m0_.langue AS langue_7, m0_.dept_buy AS dept_buy_8, m0_.dept_rent AS dept_rent_9, m0_.dept_buy_id AS dept_buy_id_10, m0_.dept_rent_id AS dept_rent_id_11, m0_.created_by_id AS created_by_id_12 FROM migration m0_ LEFT JOIN subscription_file s1_ ON (m0_.id = s1_.migration_id) WHERE m0_.subscription = 126 AND m0_.dept_id = 201 AND s1_.name = 'generatedcontacts100k-9b4a5e6d2efeafd4b82d38432266d600.csv';

SELECT t0.id AS id_1, t0.subscription_id AS subscription_id_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.original_name AS original_name_5, t0.imported AS imported_6, t0.file_type AS file_type_7, t0.records AS records_8, t0.status AS status_9, t0.imported_records AS imported_records_10, t0.report AS report_11, t0.created_by_id AS created_by_id_12, t0.migration_id AS migration_id_13 FROM subscription_file t0 WHERE t0.migration_id = ? AND t0.name = ? LIMIT 1

[
  85
  "generatedcontacts100k-9b4a5e6d2efeafd4b82d38432266d600.csv"
]

SELECT
  t0.id AS id_1,
  t0.subscription_id AS subscription_id_2,
  t0.name AS name_3,
  t0.created_at AS created_at_4,
  t0.original_name AS original_name_5,
  t0.imported AS imported_6,
  t0.file_type AS file_type_7,
  t0.records AS records_8,
  t0.status AS status_9,
  t0.imported_records AS imported_records_10,
  t0.report AS report_11,
  t0.created_by_id AS created_by_id_12,
  t0.migration_id AS migration_id_13
FROM
  subscription_file t0
WHERE
  t0.migration_id = ?
  AND t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.subscription_id AS subscription_id_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.original_name AS original_name_5, t0.imported AS imported_6, t0.file_type AS file_type_7, t0.records AS records_8, t0.status AS status_9, t0.imported_records AS imported_records_10, t0.report AS report_11, t0.created_by_id AS created_by_id_12, t0.migration_id AS migration_id_13 FROM subscription_file t0 WHERE t0.migration_id = 85 AND t0.name = 'generatedcontacts100k-9b4a5e6d2efeafd4b82d38432266d600.csv' LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE subscription_file SET imported_records = ?, report = ? WHERE id = ?

[
  15200
  """
    Importation started at 2024-09-11 17:53:11\n
    0 users created from contacts \n
    User IDs from Contacts: [] \n
    """
  90
]

UPDATE
  subscription_file
SET
  imported_records = ?,
  report = ?
WHERE
  id = ?

UPDATE subscription_file SET imported_records = 15200, report = 'Importation started at 2024-09-11 17:53:11
0 users created from contacts 
User IDs from Contacts: [] 
' WHERE id = 90;

"COMMIT"

[]

"COMMIT"

"COMMIT";