Query Metrics
4
Database Queries
4
Different statements
67.35 ms
Query time
0
Invalid entities
3
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.37 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.service AS service_6, t0.phone AS phone_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
11
]
|
||||||||||||||||||||||||||||||||
| 2 | 33.34 ms |
SELECT DISTINCT a0_.id AS id_0 FROM article a0_ WHERE a0_.id = ? OR LOWER(CONCAT(a0_.name, '')) LIKE ? OR LOWER(CONCAT(a0_.designation, '')) LIKE ? OR LOWER(CONCAT(a0_.fabricant, '')) LIKE ? OR LOWER(CONCAT(a0_.reference_fabricant, '')) LIKE ? OR LOWER(CONCAT(a0_.type, '')) LIKE ? OR a0_.prf = ? OR LOWER(CONCAT(a0_.unite_de_prix, '')) LIKE ? OR LOWER(CONCAT(a0_.code_tarif, '')) LIKE ? OR LOWER(CONCAT(a0_.code_douanier, '')) LIKE ? OR LOWER(CONCAT(a0_.dimentions, '')) LIKE ? OR LOWER(CONCAT(a0_.poids, '')) LIKE ? OR LOWER(CONCAT(a0_.pays_origine, '')) LIKE ? OR LOWER(CONCAT(a0_.numero_magasin, '')) LIKE ? OR LOWER(CONCAT(a0_.emplacement_magasin, '')) LIKE ? OR LOWER(CONCAT(a0_.image, '')) LIKE ? OR LOWER(CONCAT(a0_.id_monday, '')) LIKE ? OR LOWER(CONCAT(a0_.updated_by, '')) LIKE ? LIMIT 20
Parameters:
[ 1066596 "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" 1066596 "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" ]
|
||||||||||||||||||||||||||||||||
| 3 | 0.66 ms |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.designation AS designation_2, a0_.fabricant AS fabricant_3, a0_.reference_fabricant AS reference_fabricant_4, a0_.type AS type_5, a0_.prf AS prf_6, a0_.unite_de_prix AS unite_de_prix_7, a0_.date_validite_tarif AS date_validite_tarif_8, a0_.code_tarif AS code_tarif_9, a0_.code_douanier AS code_douanier_10, a0_.dimentions AS dimentions_11, a0_.poids AS poids_12, a0_.pays_origine AS pays_origine_13, a0_.numero_magasin AS numero_magasin_14, a0_.emplacement_magasin AS emplacement_magasin_15, a0_.created_at AS created_at_16, a0_.image AS image_17, a0_.id_monday AS id_monday_18, a0_.updated_at AS updated_at_19, a0_.updated_by AS updated_by_20, a0_.coeff_prix_id AS coeff_prix_id_21 FROM article a0_ WHERE (a0_.id = ? OR LOWER(CONCAT(a0_.name, '')) LIKE ? OR LOWER(CONCAT(a0_.designation, '')) LIKE ? OR LOWER(CONCAT(a0_.fabricant, '')) LIKE ? OR LOWER(CONCAT(a0_.reference_fabricant, '')) LIKE ? OR LOWER(CONCAT(a0_.type, '')) LIKE ? OR a0_.prf = ? OR LOWER(CONCAT(a0_.unite_de_prix, '')) LIKE ? OR LOWER(CONCAT(a0_.code_tarif, '')) LIKE ? OR LOWER(CONCAT(a0_.code_douanier, '')) LIKE ? OR LOWER(CONCAT(a0_.dimentions, '')) LIKE ? OR LOWER(CONCAT(a0_.poids, '')) LIKE ? OR LOWER(CONCAT(a0_.pays_origine, '')) LIKE ? OR LOWER(CONCAT(a0_.numero_magasin, '')) LIKE ? OR LOWER(CONCAT(a0_.emplacement_magasin, '')) LIKE ? OR LOWER(CONCAT(a0_.image, '')) LIKE ? OR LOWER(CONCAT(a0_.id_monday, '')) LIKE ? OR LOWER(CONCAT(a0_.updated_by, '')) LIKE ?) AND a0_.id IN (?)
Parameters:
[ 1066596 "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" 1066596 "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" 10346 ]
|
||||||||||||||||||||||||||||||||
| 4 | 32.99 ms |
SELECT count(*) AS sclr_0 FROM article a0_ WHERE a0_.id = ? OR LOWER(CONCAT(a0_.name, '')) LIKE ? OR LOWER(CONCAT(a0_.designation, '')) LIKE ? OR LOWER(CONCAT(a0_.fabricant, '')) LIKE ? OR LOWER(CONCAT(a0_.reference_fabricant, '')) LIKE ? OR LOWER(CONCAT(a0_.type, '')) LIKE ? OR a0_.prf = ? OR LOWER(CONCAT(a0_.unite_de_prix, '')) LIKE ? OR LOWER(CONCAT(a0_.code_tarif, '')) LIKE ? OR LOWER(CONCAT(a0_.code_douanier, '')) LIKE ? OR LOWER(CONCAT(a0_.dimentions, '')) LIKE ? OR LOWER(CONCAT(a0_.poids, '')) LIKE ? OR LOWER(CONCAT(a0_.pays_origine, '')) LIKE ? OR LOWER(CONCAT(a0_.numero_magasin, '')) LIKE ? OR LOWER(CONCAT(a0_.emplacement_magasin, '')) LIKE ? OR LOWER(CONCAT(a0_.image, '')) LIKE ? OR LOWER(CONCAT(a0_.id_monday, '')) LIKE ? OR LOWER(CONCAT(a0_.updated_by, '')) LIKE ?
Parameters:
[ 1066596 "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" 1066596 "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" "%1066596%" ]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\User | 1 |
| App\Entity\Article | 1 |
| App\Entity\CoeffPrix | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\CoeffPrix | No errors. |
| App\Entity\DevisLigne | No errors. |