Query Metrics
3
Database Queries
3
Different statements
24.18 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.52 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.avatar AS avatar_8, t0.username AS username_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
10
]
|
2 | 10.77 ms |
SELECT DISTINCT o0_.id AS id_0, o0_.ordernummer AS ordernummer_1 FROM `order` o0_ WHERE (LOWER(CONCAT(o0_.id, '')) LIKE ? OR LOWER(CONCAT(o0_.prijs, '')) LIKE ? OR LOWER(CONCAT(o0_.leges, '')) LIKE ? OR LOWER(CONCAT(o0_.overledene_naam, '')) LIKE ? OR LOWER(CONCAT(o0_.opmerkingen, '')) LIKE ? OR LOWER(CONCAT(o0_.grafnummer, '')) LIKE ? OR LOWER(CONCAT(o0_.planning_aankomst_leverancier, '')) LIKE ? OR LOWER(CONCAT(o0_.bestelling_opmerkingen, '')) LIKE ? OR LOWER(CONCAT(o0_.opslag_locatie, '')) LIKE ? OR LOWER(CONCAT(o0_.levering_opmerkingen, '')) LIKE ? OR LOWER(CONCAT(o0_.provisie, '')) LIKE ? OR LOWER(CONCAT(o0_.ordernummer, '')) LIKE ? OR LOWER(CONCAT(o0_.afhaler_naam_op_steen, '')) LIKE ? OR LOWER(CONCAT(o0_.order_offerte, '')) LIKE ? OR LOWER(CONCAT(o0_.record_type, '')) LIKE ? OR LOWER(CONCAT(o0_.afhaler_opdrachtgever, '')) LIKE ? OR LOWER(CONCAT(o0_.leverweek, '')) LIKE ? OR LOWER(CONCAT(o0_.step, '')) LIKE ? OR LOWER(CONCAT(o0_.prijs_berekend, '')) LIKE ? OR LOWER(CONCAT(o0_.opmerkingen_werkbon, '')) LIKE ? OR LOWER(CONCAT(o0_.belettering_opmerking, '')) LIKE ?) AND (LOWER(CONCAT(o0_.id, '')) LIKE ? OR LOWER(CONCAT(o0_.prijs, '')) LIKE ? OR LOWER(CONCAT(o0_.leges, '')) LIKE ? OR LOWER(CONCAT(o0_.overledene_naam, '')) LIKE ? OR LOWER(CONCAT(o0_.opmerkingen, '')) LIKE ? OR LOWER(CONCAT(o0_.grafnummer, '')) LIKE ? OR LOWER(CONCAT(o0_.planning_aankomst_leverancier, '')) LIKE ? OR LOWER(CONCAT(o0_.bestelling_opmerkingen, '')) LIKE ? OR LOWER(CONCAT(o0_.opslag_locatie, '')) LIKE ? OR LOWER(CONCAT(o0_.levering_opmerkingen, '')) LIKE ? OR LOWER(CONCAT(o0_.provisie, '')) LIKE ? OR LOWER(CONCAT(o0_.ordernummer, '')) LIKE ? OR LOWER(CONCAT(o0_.afhaler_naam_op_steen, '')) LIKE ? OR LOWER(CONCAT(o0_.order_offerte, '')) LIKE ? OR LOWER(CONCAT(o0_.record_type, '')) LIKE ? OR LOWER(CONCAT(o0_.afhaler_opdrachtgever, '')) LIKE ? OR LOWER(CONCAT(o0_.leverweek, '')) LIKE ? OR LOWER(CONCAT(o0_.step, '')) LIKE ? OR LOWER(CONCAT(o0_.prijs_berekend, '')) LIKE ? OR LOWER(CONCAT(o0_.opmerkingen_werkbon, '')) LIKE ? OR LOWER(CONCAT(o0_.belettering_opmerking, '')) LIKE ?) ORDER BY o0_.ordernummer DESC LIMIT 20
Parameters:
[ "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" ] |
3 | 12.89 ms |
SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE (LOWER(CONCAT(o0_.id, '')) LIKE ? OR LOWER(CONCAT(o0_.prijs, '')) LIKE ? OR LOWER(CONCAT(o0_.leges, '')) LIKE ? OR LOWER(CONCAT(o0_.overledene_naam, '')) LIKE ? OR LOWER(CONCAT(o0_.opmerkingen, '')) LIKE ? OR LOWER(CONCAT(o0_.grafnummer, '')) LIKE ? OR LOWER(CONCAT(o0_.planning_aankomst_leverancier, '')) LIKE ? OR LOWER(CONCAT(o0_.bestelling_opmerkingen, '')) LIKE ? OR LOWER(CONCAT(o0_.opslag_locatie, '')) LIKE ? OR LOWER(CONCAT(o0_.levering_opmerkingen, '')) LIKE ? OR LOWER(CONCAT(o0_.provisie, '')) LIKE ? OR LOWER(CONCAT(o0_.ordernummer, '')) LIKE ? OR LOWER(CONCAT(o0_.afhaler_naam_op_steen, '')) LIKE ? OR LOWER(CONCAT(o0_.order_offerte, '')) LIKE ? OR LOWER(CONCAT(o0_.record_type, '')) LIKE ? OR LOWER(CONCAT(o0_.afhaler_opdrachtgever, '')) LIKE ? OR LOWER(CONCAT(o0_.leverweek, '')) LIKE ? OR LOWER(CONCAT(o0_.step, '')) LIKE ? OR LOWER(CONCAT(o0_.prijs_berekend, '')) LIKE ? OR LOWER(CONCAT(o0_.opmerkingen_werkbon, '')) LIKE ? OR LOWER(CONCAT(o0_.belettering_opmerking, '')) LIKE ?) AND (LOWER(CONCAT(o0_.id, '')) LIKE ? OR LOWER(CONCAT(o0_.prijs, '')) LIKE ? OR LOWER(CONCAT(o0_.leges, '')) LIKE ? OR LOWER(CONCAT(o0_.overledene_naam, '')) LIKE ? OR LOWER(CONCAT(o0_.opmerkingen, '')) LIKE ? OR LOWER(CONCAT(o0_.grafnummer, '')) LIKE ? OR LOWER(CONCAT(o0_.planning_aankomst_leverancier, '')) LIKE ? OR LOWER(CONCAT(o0_.bestelling_opmerkingen, '')) LIKE ? OR LOWER(CONCAT(o0_.opslag_locatie, '')) LIKE ? OR LOWER(CONCAT(o0_.levering_opmerkingen, '')) LIKE ? OR LOWER(CONCAT(o0_.provisie, '')) LIKE ? OR LOWER(CONCAT(o0_.ordernummer, '')) LIKE ? OR LOWER(CONCAT(o0_.afhaler_naam_op_steen, '')) LIKE ? OR LOWER(CONCAT(o0_.order_offerte, '')) LIKE ? OR LOWER(CONCAT(o0_.record_type, '')) LIKE ? OR LOWER(CONCAT(o0_.afhaler_opdrachtgever, '')) LIKE ? OR LOWER(CONCAT(o0_.leverweek, '')) LIKE ? OR LOWER(CONCAT(o0_.step, '')) LIKE ? OR LOWER(CONCAT(o0_.prijs_berekend, '')) LIKE ? OR LOWER(CONCAT(o0_.opmerkingen_werkbon, '')) LIKE ? OR LOWER(CONCAT(o0_.belettering_opmerking, '')) LIKE ?)
Parameters:
[ "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%nanette%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" "%bouw%" ] |
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\User | No errors. |
App\Entity\Question | No errors. |
App\Entity\Answer | No errors. |
App\Entity\Order | No errors. |
App\Entity\Reminder | No errors. |
App\Entity\Groep | No errors. |