Query Metrics

3 Database Queries
3 Different statements
24.18 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.