https://lara.camileia.com/api/devices

Query Metrics

21 Database Queries
3 Different statements
3.00 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.53 ms
(51.18%)
10
SELECT t0.id AS id_1, t0.nombre_boutons AS nombre_boutons_2, t0.libelle AS libelle_3, t0.cout AS cout_4, t0.garantie AS garantie_5, t0.photo1 AS photo1_6, t0.photo2 AS photo2_7, t0.photo3 AS photo3_8, t0.duree_vie AS duree_vie_9, t0.description AS description_10, t0.fonction AS fonction_11, t0.is_archive AS is_archive_12, t0.type_device_id AS type_device_id_13 FROM modele t0 WHERE t0.id = ?
Parameters:
[
  19
]
1.06 ms
(35.38%)
10
SELECT t0.id AS id_1, t0.description AS description_2, t0.libelle AS libelle_3, t0.modele_id AS modele_id_4 FROM scenario t0 WHERE t0.id = ?
Parameters:
[
  41
]
0.40 ms
(13.44%)
1
SELECT d0_.id AS id_0, d0_.id_client AS id_client_1, d0_.libelle_client AS libelle_client_2, d0_.numero_serie AS numero_serie_3, d0_.voltage AS voltage_4, d0_.date_activation AS date_activation_5, d0_.is_bon_etat AS is_bon_etat_6, d0_.pourcentage_batterie AS pourcentage_batterie_7, d0_.pac AS pac_8, d0_.link_quality AS link_quality_9, d0_.date_derniere_communication AS date_derniere_communication_10, d0_.ville AS ville_11, d0_.libelle AS libelle_12, d0_.delai_limite AS delai_limite_13, d0_.trigger_alert AS trigger_alert_14, d0_.dev_eui AS dev_eui_15, d0_.gateway_path AS gateway_path_16, d0_.modele_id AS modele_id_17, d0_.scenario_id AS scenario_id_18 FROM device d0_ WHERE (d0_.id_client REGEXP ?) = 1
Parameters:
[
  "(^|,)6(,|$)"
]

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\Device No errors.
App\Entity\Modele No errors.
App\Entity\Scenario No errors.
App\Entity\DataUplinks No errors.
App\Entity\TypeDevice No errors.
App\Entity\Reseau No errors.
App\Entity\Bouton No errors.