https://erp-vv-staging.vertuoz.fr/symfony/public/kernix/api/v1/reservations?timestamp=1754117642

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

Group similar statements

# 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
    __toString(): "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
    __toString(): "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.