GET https://remplacement.bxl.lire-et-ecrire.be/cron/nouvelles-demandes-formateurs?token=8d4f2a1c9e7b3d5f1a9c7e5b3d1f9a7c5e3b

Response
200 OK
IP
23.88.105.37
Profiled on
Token
c6e2d8

Query Metrics

3 Database Queries
1 Different statements
5.33 ms Query time
1 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.61 ms 
SELECT o0_.id AS id_0, o0_.date AS date_1, o0_.heure_debut AS heure_debut_2, o0_.heure_fin AS heure_fin_3, o0_.is_annuler AS is_annuler_4, o0_.motifs_annuler AS motifs_annuler_5, o0_.commentaire AS commentaire_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8, o0_.reference_groupe AS reference_groupe_9, o0_.id_groupe AS id_groupe_10, o0_.niveau AS niveau_11, c1_.id AS id_12, c1_.label AS label_13, c1_.created_at AS created_at_14, c1_.updated_at AS updated_at_15, c1_.is_active AS is_active_16, p2_.id AS id_17, p2_.first_name AS first_name_18, p2_.last_name AS last_name_19, p2_.is_archived AS is_archived_20, p2_.created_at AS created_at_21, p2_.updated_at AS updated_at_22, l3_.id AS id_23, l3_.label AS label_24, l3_.siege_address AS siege_address_25, l3_.cours_address AS cours_address_26, l3_.contact AS contact_27, l3_.is_lee AS is_lee_28, l3_.created_at AS created_at_29, l3_.updated_at AS updated_at_30, m4_.id AS id_31, m4_.label AS label_32, m4_.created_at AS created_at_33, m4_.updated_at AS updated_at_34, o0_.created_by_id AS created_by_id_35, o0_.updated_by_id AS updated_by_id_36, o0_.centre_alpha_id AS centre_alpha_id_37, o0_.formateur_titulaire_id AS formateur_titulaire_id_38, o0_.lieu_id AS lieu_id_39, o0_.motif_remplacement_id AS motif_remplacement_id_40, c1_.created_by_id AS created_by_id_41, c1_.updated_by_id AS updated_by_id_42, p2_.genre_id AS genre_id_43, p2_.fonction_id AS fonction_id_44, p2_.created_by_id AS created_by_id_45, p2_.updated_by_id AS updated_by_id_46, l3_.created_by_id AS created_by_id_47, l3_.updated_by_id AS updated_by_id_48, m4_.created_by_id AS created_by_id_49, m4_.updated_by_id AS updated_by_id_50 FROM offre o0_ LEFT JOIN centre_alpha c1_ ON o0_.centre_alpha_id = c1_.id LEFT JOIN personnel p2_ ON o0_.formateur_titulaire_id = p2_.id LEFT JOIN lieu_formation l3_ ON o0_.lieu_id = l3_.id LEFT JOIN motif_absence m4_ ON o0_.motif_remplacement_id = m4_.id WHERE o0_.created_at >= ? AND o0_.created_at < ? AND ((o0_.is_annuler IS NULL OR o0_.is_annuler = 0)) ORDER BY o0_.date ASC, o0_.heure_debut ASC
Parameters: 
[
  "2026-06-19 00:00:00"
  "2026-06-20 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 3.11 ms 
SELECT o0_.id AS id_0, o0_.date AS date_1, o0_.heure_debut AS heure_debut_2, o0_.heure_fin AS heure_fin_3, o0_.is_annuler AS is_annuler_4, o0_.motifs_annuler AS motifs_annuler_5, o0_.commentaire AS commentaire_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8, o0_.reference_groupe AS reference_groupe_9, o0_.id_groupe AS id_groupe_10, o0_.niveau AS niveau_11, c1_.id AS id_12, c1_.label AS label_13, c1_.created_at AS created_at_14, c1_.updated_at AS updated_at_15, c1_.is_active AS is_active_16, p2_.id AS id_17, p2_.first_name AS first_name_18, p2_.last_name AS last_name_19, p2_.is_archived AS is_archived_20, p2_.created_at AS created_at_21, p2_.updated_at AS updated_at_22, l3_.id AS id_23, l3_.label AS label_24, l3_.siege_address AS siege_address_25, l3_.cours_address AS cours_address_26, l3_.contact AS contact_27, l3_.is_lee AS is_lee_28, l3_.created_at AS created_at_29, l3_.updated_at AS updated_at_30, m4_.id AS id_31, m4_.label AS label_32, m4_.created_at AS created_at_33, m4_.updated_at AS updated_at_34, o0_.created_by_id AS created_by_id_35, o0_.updated_by_id AS updated_by_id_36, o0_.centre_alpha_id AS centre_alpha_id_37, o0_.formateur_titulaire_id AS formateur_titulaire_id_38, o0_.lieu_id AS lieu_id_39, o0_.motif_remplacement_id AS motif_remplacement_id_40, c1_.created_by_id AS created_by_id_41, c1_.updated_by_id AS updated_by_id_42, p2_.genre_id AS genre_id_43, p2_.fonction_id AS fonction_id_44, p2_.created_by_id AS created_by_id_45, p2_.updated_by_id AS updated_by_id_46, l3_.created_by_id AS created_by_id_47, l3_.updated_by_id AS updated_by_id_48, m4_.created_by_id AS created_by_id_49, m4_.updated_by_id AS updated_by_id_50 FROM offre o0_ LEFT JOIN centre_alpha c1_ ON o0_.centre_alpha_id = c1_.id LEFT JOIN personnel p2_ ON o0_.formateur_titulaire_id = p2_.id LEFT JOIN lieu_formation l3_ ON o0_.lieu_id = l3_.id LEFT JOIN motif_absence m4_ ON o0_.motif_remplacement_id = m4_.id WHERE o0_.created_at >= ? AND o0_.created_at < ? AND ((o0_.is_annuler IS NULL OR o0_.is_annuler = 0)) ORDER BY o0_.date ASC, o0_.heure_debut ASC
Parameters: 
[
  "2026-06-20 00:00:00"
  "2026-06-21 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.61 ms 
SELECT o0_.id AS id_0, o0_.date AS date_1, o0_.heure_debut AS heure_debut_2, o0_.heure_fin AS heure_fin_3, o0_.is_annuler AS is_annuler_4, o0_.motifs_annuler AS motifs_annuler_5, o0_.commentaire AS commentaire_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8, o0_.reference_groupe AS reference_groupe_9, o0_.id_groupe AS id_groupe_10, o0_.niveau AS niveau_11, c1_.id AS id_12, c1_.label AS label_13, c1_.created_at AS created_at_14, c1_.updated_at AS updated_at_15, c1_.is_active AS is_active_16, p2_.id AS id_17, p2_.first_name AS first_name_18, p2_.last_name AS last_name_19, p2_.is_archived AS is_archived_20, p2_.created_at AS created_at_21, p2_.updated_at AS updated_at_22, l3_.id AS id_23, l3_.label AS label_24, l3_.siege_address AS siege_address_25, l3_.cours_address AS cours_address_26, l3_.contact AS contact_27, l3_.is_lee AS is_lee_28, l3_.created_at AS created_at_29, l3_.updated_at AS updated_at_30, m4_.id AS id_31, m4_.label AS label_32, m4_.created_at AS created_at_33, m4_.updated_at AS updated_at_34, o0_.created_by_id AS created_by_id_35, o0_.updated_by_id AS updated_by_id_36, o0_.centre_alpha_id AS centre_alpha_id_37, o0_.formateur_titulaire_id AS formateur_titulaire_id_38, o0_.lieu_id AS lieu_id_39, o0_.motif_remplacement_id AS motif_remplacement_id_40, c1_.created_by_id AS created_by_id_41, c1_.updated_by_id AS updated_by_id_42, p2_.genre_id AS genre_id_43, p2_.fonction_id AS fonction_id_44, p2_.created_by_id AS created_by_id_45, p2_.updated_by_id AS updated_by_id_46, l3_.created_by_id AS created_by_id_47, l3_.updated_by_id AS updated_by_id_48, m4_.created_by_id AS created_by_id_49, m4_.updated_by_id AS updated_by_id_50 FROM offre o0_ LEFT JOIN centre_alpha c1_ ON o0_.centre_alpha_id = c1_.id LEFT JOIN personnel p2_ ON o0_.formateur_titulaire_id = p2_.id LEFT JOIN lieu_formation l3_ ON o0_.lieu_id = l3_.id LEFT JOIN motif_absence m4_ ON o0_.motif_remplacement_id = m4_.id WHERE o0_.created_at >= ? AND o0_.created_at < ? AND ((o0_.is_annuler IS NULL OR o0_.is_annuler = 0)) ORDER BY o0_.date ASC, o0_.heure_debut ASC
Parameters: 
[
  "2026-06-21 00:00:00"
  "2026-06-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace

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

Entities Mapping

Class Mapping errors
App\Entity\Offre No errors.
App\Entity\CentreAlpha No errors.
App\Entity\Personnel
  • The field App\Entity\Personnel#user is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User#personnel does not contain the required 'inversedBy: "user"' attribute.
App\Entity\LieuFormation No errors.
App\Entity\MotifAbsence No errors.
App\Entity\User No errors.
App\Entity\Genre No errors.
App\Entity\Fonction No errors.