Query Metrics
4
Database Queries
4
Different statements
8.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
3.17 ms (36.88%) |
1 |
SELECT DISTINCT p0_.id AS id_0, p0_.property_name AS property_name_1 FROM property p0_ WHERE (LOWER(CONCAT(p0_.id, '')) LIKE ? OR LOWER(CONCAT(p0_.property_name, '')) LIKE ? OR LOWER(CONCAT(p0_.commune, '')) LIKE ? OR LOWER(CONCAT(p0_.contract_name, '')) LIKE ? OR LOWER(CONCAT(p0_.adresse_1, '')) LIKE ? OR LOWER(CONCAT(p0_.adresse_2, '')) LIKE ? OR LOWER(CONCAT(p0_.code_postal, '')) LIKE ?) AND (LOWER(CONCAT(p0_.id, '')) LIKE ? OR LOWER(CONCAT(p0_.property_name, '')) LIKE ? OR LOWER(CONCAT(p0_.commune, '')) LIKE ? OR LOWER(CONCAT(p0_.contract_name, '')) LIKE ? OR LOWER(CONCAT(p0_.adresse_1, '')) LIKE ? OR LOWER(CONCAT(p0_.adresse_2, '')) LIKE ? OR LOWER(CONCAT(p0_.code_postal, '')) LIKE ?) ORDER BY p0_.property_name ASC LIMIT 20
Parameters:
[ "%la%" "%la%" "%la%" "%la%" "%la%" "%la%" "%la%" "%gor%" "%gor%" "%gor%" "%gor%" "%gor%" "%gor%" "%gor%" ]
|
||||||||||||||||||||||||||||||||
|
3.06 ms (35.62%) |
1 |
SELECT COUNT(p0_.id) AS sclr_0 FROM property p0_ WHERE (LOWER(CONCAT(p0_.id, '')) LIKE ? OR LOWER(CONCAT(p0_.property_name, '')) LIKE ? OR LOWER(CONCAT(p0_.commune, '')) LIKE ? OR LOWER(CONCAT(p0_.contract_name, '')) LIKE ? OR LOWER(CONCAT(p0_.adresse_1, '')) LIKE ? OR LOWER(CONCAT(p0_.adresse_2, '')) LIKE ? OR LOWER(CONCAT(p0_.code_postal, '')) LIKE ?) AND (LOWER(CONCAT(p0_.id, '')) LIKE ? OR LOWER(CONCAT(p0_.property_name, '')) LIKE ? OR LOWER(CONCAT(p0_.commune, '')) LIKE ? OR LOWER(CONCAT(p0_.contract_name, '')) LIKE ? OR LOWER(CONCAT(p0_.adresse_1, '')) LIKE ? OR LOWER(CONCAT(p0_.adresse_2, '')) LIKE ? OR LOWER(CONCAT(p0_.code_postal, '')) LIKE ?)
Parameters:
[ "%la%" "%la%" "%la%" "%la%" "%la%" "%la%" "%la%" "%gor%" "%gor%" "%gor%" "%gor%" "%gor%" "%gor%" "%gor%" ]
|
||||||||||||||||||||||||||||||||
|
1.27 ms (14.70%) |
1 |
SELECT p0_.id AS id_0, p0_.property_name AS property_name_1, p0_.commune AS commune_2, p0_.surface_totale AS surface_totale_3, p0_.contract_name AS contract_name_4, p0_.adresse_1 AS adresse_1_5, p0_.adresse_2 AS adresse_2_6, p0_.code_postal AS code_postal_7, p0_.departement_id AS departement_id_8, p0_.main_consultant_id AS main_consultant_id_9 FROM property p0_ WHERE (LOWER(CONCAT(p0_.id, '')) LIKE ? OR LOWER(CONCAT(p0_.property_name, '')) LIKE ? OR LOWER(CONCAT(p0_.commune, '')) LIKE ? OR LOWER(CONCAT(p0_.contract_name, '')) LIKE ? OR LOWER(CONCAT(p0_.adresse_1, '')) LIKE ? OR LOWER(CONCAT(p0_.adresse_2, '')) LIKE ? OR LOWER(CONCAT(p0_.code_postal, '')) LIKE ?) AND (LOWER(CONCAT(p0_.id, '')) LIKE ? OR LOWER(CONCAT(p0_.property_name, '')) LIKE ? OR LOWER(CONCAT(p0_.commune, '')) LIKE ? OR LOWER(CONCAT(p0_.contract_name, '')) LIKE ? OR LOWER(CONCAT(p0_.adresse_1, '')) LIKE ? OR LOWER(CONCAT(p0_.adresse_2, '')) LIKE ? OR LOWER(CONCAT(p0_.code_postal, '')) LIKE ?) AND p0_.id IN (?) ORDER BY p0_.property_name ASC
Parameters:
[ "%la%" "%la%" "%la%" "%la%" "%la%" "%la%" "%la%" "%gor%" "%gor%" "%gor%" "%gor%" "%gor%" "%gor%" "%gor%" 62 ]
|
||||||||||||||||||||||||||||||||
|
1.10 ms (12.80%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.reset_token AS reset_token_5, t0.is_active AS is_active_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.function AS function_9, t0.type_certiphyto AS type_certiphyto_10, t0.validite_certiphyto AS validite_certiphyto_11, t0.mobile AS mobile_12, t0.phone AS phone_13, t0.num_certiphyto AS num_certiphyto_14, t0.stades_pheno AS stades_pheno_15, t0.p_tordeuses AS p_tordeuses_16, t0.movida AS movida_17, t0.grp_30k AS grp_30k_18, t0.is_admin AS is_admin_19 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
118
]
|
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.