Query Metrics
5
Database Queries
5
Different statements
15.54 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 12.90 ms |
SELECT c0_.id AS id_0, c0_.phone AS phone_1, c0_.email AS email_2, c0_.firstname AS firstname_3, c0_.lastname AS lastname_4, c0_.customer_type AS customer_type_5, c0_.status AS status_6, c0_.add_date AS add_date_7, c0_.reserved_to AS reserved_to_8, c0_.contract_date AS contract_date_9, c0_.link AS link_10, c0_.agent_id AS agent_id_11 FROM customer c0_ WHERE (c0_.phone IS NOT NULL AND c0_.phone = ?) OR (c0_.link IS NOT NULL AND c0_.link = ?)
Parameters:
[ "664 426 911" "https://www.otodom.pl/pl/oferta/nowe-dwupokojowe-pierwszy-najem-jagodno-kajdasza-ID4rffv" ] |
2 | 0.48 ms |
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.customer_type AS customer_type_6, t0.status AS status_7, t0.add_date AS add_date_8, t0.reserved_to AS reserved_to_9, t0.contract_date AS contract_date_10, t0.link AS link_11, t0.agent_id AS agent_id_12 FROM customer t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"4801"
]
|
3 | 0.22 ms |
"START TRANSACTION"
Parameters:
[] |
4 | 0.60 ms |
UPDATE customer SET phone = ?, firstname = ?, customer_type = ?, status = ?, reserved_to = ?, link = ? WHERE id = ?
Parameters:
[ "664 426 911" "Adam" "Wynajmujący" "do obdzwonki" "2024-06-28" "https://www.otodom.pl/pl/oferta/nowe-dwupokojowe-pierwszy-najem-jagodno-kajdasza-ID4rffv" 4801 ] |
5 | 1.33 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\Customer | No errors. |
App\Entity\Agent |
|
App\Entity\CustomerComment | No errors. |