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

"COMMIT"

[]

"COMMIT"

"COMMIT";

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 = ?

[
  122
  180
  "property537-7390d3d06a78309bbcfa1b92707bb28c.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 = 122 AND m0_.dept_id = 180 AND s1_.name = 'property537-7390d3d06a78309bbcfa1b92707bb28c.csv';

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

[
  "in progress"
  1
  """
    Importation started at 2024-10-04 22:54:03\n
    Error for property 24-612-07 :/srv/www/reals-api-staging/src/Service/Csv/PropertyCsvParser.php 362 Unable to resize in large directoryCan't write image data to path (/srv/www/reals-api-staging/public/uploads/property/6065/large/fontaines15avillarsburquin1727272333_1727273685_73730_5771f69-a1d57ac38d2d67.jpg)\n
    """
  91
]

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

UPDATE subscription_file SET status = 'in progress', imported_records = 1, report = 'Importation started at 2024-10-04 22:54:03
Error for property 24-612-07 :/srv/www/reals-api-staging/src/Service/Csv/PropertyCsvParser.php 362 Unable to resize in large directoryCan\'t write image data to path (/srv/www/reals-api-staging/public/uploads/property/6065/large/fontaines15avillarsburquin1727272333_1727273685_73730_5771f69-a1d57ac38d2d67.jpg)
' WHERE id = 91;

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 IS NULL AND t0.name = ? LIMIT 1

[
  "property537-7390d3d06a78309bbcfa1b92707bb28c.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 IS NULL
  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 IS NULL AND t0.name = 'property537-7390d3d06a78309bbcfa1b92707bb28c.csv' LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";