Query Metrics
7
Database Queries
7
Different statements
0.92 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.18 ms |
SELECT param FROM doli_extrafields WHERE name = "sous_destination" AND elementtype = "societe"
Parameters:
[] |
2 | 0.24 ms |
SELECT b0_.id AS id_0, b0_.icone AS icone_1, b0_.vue AS vue_2, b0_.email_sent AS email_sent_3, b0_.recap_sent AS recap_sent_4, b0_.titre AS titre_5, b0_.description AS description_6, b0_.date_publication AS date_publication_7, b0_.extra_info AS extra_info_8, b0_.is_rappel AS is_rappel_9, b0_.is_in_app AS is_in_app_10, b0_.is_recap AS is_recap_11, b0_.is_email AS is_email_12, b0_.created_at AS created_at_13, b0_.updated_at AS updated_at_14, b0_.type_id AS type_id_15, b0_.source_id AS source_id_16, b0_.destination_id AS destination_id_17, b0_.event_id AS event_id_18, b0_.created_by AS created_by_19, b0_.updated_by AS updated_by_20 FROM ba_notification b0_ WHERE b0_.destination_id = ? AND b0_.vue = 0 AND b0_.date_publication >= 2025 - 08 - 02 ORDER BY b0_.date_publication DESC
Parameters:
[ Symfony\Component\Security\Core\User\User {#924 : "kernix_admin" } ] |
3 | 0.13 ms |
SELECT b0_.id AS id_0, b0_.icone AS icone_1, b0_.vue AS vue_2, b0_.email_sent AS email_sent_3, b0_.recap_sent AS recap_sent_4, b0_.titre AS titre_5, b0_.description AS description_6, b0_.date_publication AS date_publication_7, b0_.extra_info AS extra_info_8, b0_.is_rappel AS is_rappel_9, b0_.is_in_app AS is_in_app_10, b0_.is_recap AS is_recap_11, b0_.is_email AS is_email_12, b0_.created_at AS created_at_13, b0_.updated_at AS updated_at_14, b0_.type_id AS type_id_15, b0_.source_id AS source_id_16, b0_.destination_id AS destination_id_17, b0_.event_id AS event_id_18, b0_.created_by AS created_by_19, b0_.updated_by AS updated_by_20 FROM ba_notification b0_ WHERE b0_.destination_id = ? AND b0_.vue = 1 AND b0_.date_publication >= 2025 - 08 - 02 ORDER BY b0_.date_publication DESC
Parameters:
[ Symfony\Component\Security\Core\User\User {#924 : "kernix_admin" } ] |
4 | 0.09 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.actif AS actif_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM walkinn_voyage_categorie t0 WHERE t0.actif = ?
Parameters:
[
1
]
|
5 | 0.11 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.actif AS actif_3, t0.is_taux_de_remplissage AS is_taux_de_remplissage_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM walkinn_dossier_type t0 WHERE t0.actif = ?
Parameters:
[
1
]
|
6 | 0.09 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.icone AS icone_3, t0.color AS color_4, t0.actif AS actif_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9 FROM walkinn_voyage_etat t0 WHERE t0.actif = ?
Parameters:
[
1
]
|
7 | 0.09 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.icone AS icone_3, t0.color AS color_4, t0.actif AS actif_5, t0.is_valide AS is_valide_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM walkinn_dossier_etat t0 WHERE t0.actif = ?
Parameters:
[
1
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\DossierSegmentServiceGroupement | No errors. |
App\Entity\VoyageServiceGroupement | No errors. |
App\Entity\User | No errors. |
App\Entity\Role | No errors. |
App\Entity\Notification | No errors. |
App\Entity\NotificationType | No errors. |
App\Entity\Evenement | No errors. |
App\Entity\VoyageCategorie | No errors. |
App\Entity\Voyage | No errors. |
App\Entity\Dossier | No errors. |
App\Entity\DossierType | No errors. |
App\Entity\VoyageEtat | No errors. |
App\Entity\DossierEtat | No errors. |