Query Metrics
429
Database Queries
8
Different statements
608.51 ms
Query time
1
Invalid entities
302
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
139.55 ms (22.93%) |
90 |
SELECT t0.id AS id_1, t0.label AS label_2 FROM access_type t0 INNER JOIN garage_access_type ON t0.id = garage_access_type.access_type_id WHERE garage_access_type.garage_id = ?
Parameters:
[
1
]
|
|
138.14 ms (22.70%) |
90 |
SELECT t0.id AS id_1, t0.door_number AS door_number_2, t0.place_number AS place_number_3, t0.access_control_technical_name AS access_control_technical_name_4, t0.shelter_id AS shelter_id_5 FROM rack t0 WHERE t0.shelter_id IN (?)
Parameters:
[
1
]
|
|
110.97 ms (18.24%) |
90 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.icon AS icon_3, t0.rack_service_type_id AS rack_service_type_id_4 FROM rack_service t0 INNER JOIN garage_rack_service ON t0.id = garage_rack_service.rack_service_id WHERE garage_rack_service.garage_id = ?
Parameters:
[
1
]
|
|
109.53 ms (18.00%) |
90 |
SELECT t0.id AS id_1, t0.locktag AS locktag_2, t0.lock_id AS lock_id_3, t0.serial AS serial_4, t0.garage_id AS garage_id_5 FROM garage_luckey t0 WHERE t0.garage_id = ?
Parameters:
[
1
]
|
|
90.49 ms (14.87%) |
65 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.icon AS icon_3, t0.rack_service_type_id AS rack_service_type_id_4 FROM rack_service t0 INNER JOIN rack_rack_service ON t0.id = rack_rack_service.rack_service_id WHERE rack_rack_service.rack_id = ?
Parameters:
[
3
]
|
|
11.52 ms (1.89%) |
1 |
SELECT g0_.id AS id_0, g0_.technical_identifier AS technical_identifier_1, g0_.address AS address_2, g0_.zip AS zip_3, g0_.city AS city_4, g0_.country AS country_5, g0_.capacite AS capacite_6, g0_.license_key AS license_key_7, g0_.version AS version_8, g0_.url AS url_9, g0_.last_seen AS last_seen_10, g0_.rfid_test AS rfid_test_11, g0_.moxa_test AS moxa_test_12, g0_.current_version AS current_version_13, g0_.force_open AS force_open_14, g0_.occupation AS occupation_15, g0_.alertedroite AS alertedroite_16, g0_.alertegauche AS alertegauche_17, g0_.alertedroitedate AS alertedroitedate_18, g0_.alertegauchedate AS alertegauchedate_19, g0_.downloadrefresh AS downloadrefresh_20, g0_.uploadrefresh AS uploadrefresh_21, g0_.openrefresh AS openrefresh_22, g0_.doordelay AS doordelay_23, g0_.lightdelay AS lightdelay_24, g0_.dooralarm AS dooralarm_25, g0_.import AS import_26, g0_.export AS export_27, g0_.dateouverture AS dateouverture_28, g0_.datefermeture AS datefermeture_29, g0_.status AS status_30, g0_.destinataire_alertes AS destinataire_alertes_31, g0_.deleted_at AS deleted_at_32, g0_.alimentation AS alimentation_33, g0_.abonnementdispo AS abonnementdispo_34, g0_.opt AS opt_35, g0_.surnom AS surnom_36, g0_.latitude AS latitude_37, g0_.longitude AS longitude_38, g0_.nb_theorique_abo AS nb_theorique_abo_39, g0_.sms AS sms_40, g0_.abelsensoruuid AS abelsensoruuid_41, g0_.bbg AS bbg_42, g0_.di3 AS di3_43, g0_.di4 AS di4_44, g0_.di5 AS di5_45, g0_.synchronize AS synchronize_46, g0_.synchronize_demo AS synchronize_demo_47, g0_.lravuuid AS lravuuid_48, g0_.network_quality AS network_quality_49, g0_.visible AS visible_50, g0_.bi_sync AS bi_sync_51, g0_.id_bi AS id_bi_52, g0_.idfm_station_id AS idfm_station_id_53, g0_.id_marketing AS id_marketing_54, g0_.shelter_type_id AS shelter_type_id_55, g0_.shelter_address_id AS shelter_address_id_56 FROM garage g0_ WHERE g0_.last_seen > ?
Parameters:
[
"2026-03-11 23:06:08"
]
|
|
5.58 ms (0.92%) |
1 |
SELECT g0_.id AS id_0, g0_.technical_identifier AS technical_identifier_1, g0_.address AS address_2, g0_.zip AS zip_3, g0_.city AS city_4, g0_.country AS country_5, g0_.capacite AS capacite_6, g0_.license_key AS license_key_7, g0_.version AS version_8, g0_.url AS url_9, g0_.last_seen AS last_seen_10, g0_.rfid_test AS rfid_test_11, g0_.moxa_test AS moxa_test_12, g0_.current_version AS current_version_13, g0_.force_open AS force_open_14, g0_.occupation AS occupation_15, g0_.alertedroite AS alertedroite_16, g0_.alertegauche AS alertegauche_17, g0_.alertedroitedate AS alertedroitedate_18, g0_.alertegauchedate AS alertegauchedate_19, g0_.downloadrefresh AS downloadrefresh_20, g0_.uploadrefresh AS uploadrefresh_21, g0_.openrefresh AS openrefresh_22, g0_.doordelay AS doordelay_23, g0_.lightdelay AS lightdelay_24, g0_.dooralarm AS dooralarm_25, g0_.import AS import_26, g0_.export AS export_27, g0_.dateouverture AS dateouverture_28, g0_.datefermeture AS datefermeture_29, g0_.status AS status_30, g0_.destinataire_alertes AS destinataire_alertes_31, g0_.deleted_at AS deleted_at_32, g0_.alimentation AS alimentation_33, g0_.abonnementdispo AS abonnementdispo_34, g0_.opt AS opt_35, g0_.surnom AS surnom_36, g0_.latitude AS latitude_37, g0_.longitude AS longitude_38, g0_.nb_theorique_abo AS nb_theorique_abo_39, g0_.sms AS sms_40, g0_.abelsensoruuid AS abelsensoruuid_41, g0_.bbg AS bbg_42, g0_.di3 AS di3_43, g0_.di4 AS di4_44, g0_.di5 AS di5_45, g0_.synchronize AS synchronize_46, g0_.synchronize_demo AS synchronize_demo_47, g0_.lravuuid AS lravuuid_48, g0_.network_quality AS network_quality_49, g0_.visible AS visible_50, g0_.bi_sync AS bi_sync_51, g0_.id_bi AS id_bi_52, g0_.idfm_station_id AS idfm_station_id_53, g0_.id_marketing AS id_marketing_54, g0_.shelter_type_id AS shelter_type_id_55, g0_.shelter_address_id AS shelter_address_id_56 FROM garage g0_ LEFT JOIN shelter_type s1_ ON g0_.shelter_type_id = s1_.id WHERE s1_.id IS NOT NULL AND s1_.id <> ? ORDER BY g0_.id ASC
Parameters:
[
3
]
|
|
2.72 ms (0.45%) |
2 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.value AS value_3, p0_.parameter_category_id AS parameter_category_id_4 FROM parameter p0_ ORDER BY p0_.parameter_category_id ASC
Parameters:
[] |
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\Garage | 90 |
| App\Entity\ShelterAddress | 77 |
| App\Entity\Rack | 65 |
| App\Entity\Parameter | 49 |
| App\Entity\ParameterCategory | 9 |
| App\Entity\GarageLuckey | 5 |
| App\Entity\RackService | 3 |
| App\Entity\ShelterType | 2 |
| App\Entity\RackServiceType | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Parameter | No errors. |
| App\Entity\ParameterCategory | No errors. |
| App\Entity\Garage | No errors. |
| App\Entity\ShelterType | No errors. |
| App\Entity\ShelterAddress | No errors. |
| App\Entity\AccessType | No errors. |
| App\Entity\Rack | No errors. |
| App\Entity\RackService | No errors. |
| App\Entity\RackServiceType | No errors. |
| App\Entity\LogsGarage | No errors. |
| App\Entity\LogsUsage | No errors. |
| App\Entity\OccupationGarages | No errors. |
| App\Entity\Capteur | No errors. |
| App\Entity\GarageEquipment | No errors. |
| App\Entity\Abonnement | No errors. |
| App\Entity\Offre |
|
| App\Entity\BatteryLog | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\LogsUser | No errors. |
| App\Entity\GarageLuckey | No errors. |
| App\Entity\ZShelterMonthlyOccupation | No errors. |
| App\Entity\Alert | No errors. |
| App\Entity\GarageDiagnostics | No errors. |