Query Metrics
5
Database Queries
5
Different statements
11.11 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.24 ms |
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 = ?
Parameters:
[ 122 180 "property537-7390d3d06a78309bbcfa1b92707bb28c.csv" ] |
2 | 1.17 ms |
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
Parameters:
[
"property537-7390d3d06a78309bbcfa1b92707bb28c.csv"
]
|
3 | 3.25 ms |
"START TRANSACTION"
Parameters:
[] |
4 | 0.97 ms |
UPDATE subscription_file SET status = ?, report = ? WHERE id = ?
Parameters:
[ "finished" """ 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 3 records saved from 4 : 75% \n 0 new properties created and 3 existing properties updated \n Importation finished at 2024-10-04 23:13:44\n """ 91 ] |
5 | 4.48 ms |
"COMMIT"
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Migration | No errors. |
App\Entity\SubscriptionFile | No errors. |
App\Entity\User | No errors. |
App\Entity\Mapping | No errors. |