GET https://remy.bestt.fr/api/commandes?etat=EV&idBestt=0

Response
200 OK
IP
92.154.53.181
Profiled on
Token
c750f6

Query Metrics

19 Database Queries
10 Different statements
4.71 ms Query time
0 Invalid entities
15 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
1.24 ms
(26.24%) 		1 
INSERT INTO log_api (agence, url, method, http_code, data, resultat, date_reception) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  10
  "https://remy.bestt.fr/api/commandes?etat=EV&idBestt=0"
  "GET"
  200
  ""
  "[{"id":"1","dureeHebdo":"39.00","statutCadre":1,"dateDebut":"2025-07-31T00:00:00+00:00","dateFin":"2025-08-31T00:00:00+00:00","quantite":1,"etat":"EV","adresse1":"2 RUE ROBERT KELLER","adresse2":"","ville":"PONT-SAINTE-MARIE","codePostal":"10150","adresseClient":true,"justification":"Va \u00e0 la plage","remplacementNom":"Poljack","remplacementPrenom":"Pierre","dateHeureCreation":"2025-06-24T13:52:05+00:00","qualification":"DIRECTEUR GENERAL","idBestt":0,"contact":{"id":1,"client":"\/api\/clients\/1"},"titre":"DIRECTEUR GENERAL","motif":{"id":2,"code":"01","libelle":"Remplacement d'un salari\u00e9"},"import":false,"documents":[],"documentDemandes":[],"nombreDocuments":0,"salaries":[],"commandePlanning":false,"confirmationClient":false,"traite":false,"horaireTravail":[]},{"id":"2","statutCadre":0,"dateDebut":"2025-07-15T00:00:00+00:00","dateFin":"2025-08-04T00:00:00+00:00","quantite":1,"etat":"EV","adresse1":"rue emile zola","adresse2":"","ville":"Amiens","codePostal":"80000","adresseClient":true,"remplacementNom":"Legrand","remplacementPrenom":"Remy","dateHeureCreation":"2025-07-07T08:04:01+00:00","qualification":"DeveloppeurWeb","idBestt":0,"contact":{"id":1,"client":"\/api\/clients\/1"},"client":{"id":2,"agenceClients":[[]]},"titre":"DeveloppeurWeb(saisie par l'agence)","motif":{"id":2,"code":"01","libelle":"Remplacement d'un salari\u00e9"},"import":false,"documents":[],"documentDemandes":[],"salaries":[],"commandePlanning":false,"confirmationClient":false,"traite":false,"permanent":"\/api\/permanents\/1","horaireTravail":{"lu":[],"ma":[],"me":[],"je":[],"ve":[],"sa":[],"di":[]}},{"id":"4","statutCadre":0,"dateDebut":"2025-11-26T00:00:00+00:00","dateFin":"2025-11-28T00:00:00+00:00","quantite":1,"etat":"EV","adresse1":"2 RUE ROBERT KELLER","adresse2":"","ville":"PONT-SAINTE-MARIE","codePostal":"10150","adresseClient":true,"dateHeureCreation":"2025-11-24T11:32:45+00:00","qualification":"magasinier","idBestt":0,"client":{"id":1,"agenceClients":[{"idBestt":194217733930356951}]},"titre":"magasinier(saisie par l'agence)","motif":{"id":1,"code":"02","libelle":"Accroissement temporaire"},"import":false,"documents":[],"documentDemandes":[],"salaries":[],"commandePlanning":false,"confirmationClient":false,"traite":false,"permanent":"\/api\/permanents\/1","horaireTravail":{"lu":[],"ma":[],"me":[],"je":[],"ve":[],"sa":[],"di":[]}},{"id":"5","statutCadre":0,"dateDebut":"2026-01-26T00:00:00+00:00","dateFin":"2026-04-27T00:00:00+00:00","quantite":1,"etat":"EV","adresse1":"rue emile zola","adresse2":"","ville":"Amiens","codePostal":"80000","adresseClient":true,"dateHeureCreation":"2026-01-19T11:05:21+00:00","qualification":"Designer Web","idBestt":0,"client":{"id":2,"agenceClients":[[]]},"titre":"Designer Web(saisie par l'agence)","motif":{"id":1,"code":"02","libelle":"Accroissement temporaire"},"import":false,"documents":[],"documentDemandes":[],"salaries":[],"commandePlanning":false,"confirmationClient":false,"traite":false,"permanent":"\/api\/permanents\/1","horaireTravail":{"lu":[{"de":"09:00","a":"18:00"}],"ma":[{"de":"09:00","a":"18:00"}],"me":[{"de":"09:00","a":"18:00"}],"je":[{"de":"09:00","a":"18:00"}],"ve":[{"de":"09:00","a":"18:00"}],"sa":[],"di":[]}}]"
  "2026-02-19 15:33:03"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.63 ms
(13.47%) 		4 
SELECT t0.id_document_demande AS id_document_demande_1, t0.type AS type_2, t0.etat AS etat_3, t0.numero_bestt AS numero_bestt_4, t0.date_heure_creation AS date_heure_creation_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.id_bestt_salarie AS id_bestt_salarie_8, t0.id_bestt_client AS id_bestt_client_9, t0.id_bestt_permanent AS id_bestt_permanent_10, t0.id_client AS id_client_11, t0.id_contact AS id_contact_12, t0.id_salarie AS id_salarie_13, t0.id_agence AS id_agence_14, t0.id_permanent AS id_permanent_15, t0.id_commande AS id_commande_16 FROM document_demande t0 WHERE t0.id_commande = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.62 ms
(13.17%) 		4 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_creation AS date_creation_3, t0.doc_path AS doc_path_4, t0.id_agence AS id_agence_5, t0.id_client AS id_client_6, t0.id_commande AS id_commande_7 FROM document t0 WHERE t0.id_commande = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(8.08%) 		1 
SELECT c0_.id_commande AS id_commande_0, c0_.salaire_horaire_brut AS salaire_horaire_brut_1, c0_.duree_hebdo AS duree_hebdo_2, c0_.statut_cadre AS statut_cadre_3, c0_.date_debut AS date_debut_4, c0_.date_fin AS date_fin_5, c0_.quantite AS quantite_6, c0_.etat AS etat_7, c0_.adresse_1 AS adresse_1_8, c0_.adresse_2 AS adresse_2_9, c0_.ville AS ville_10, c0_.code_postal AS code_postal_11, c0_.adresse_client AS adresse_client_12, c0_.justification AS justification_13, c0_.remplacement_nom AS remplacement_nom_14, c0_.remplacement_prenom AS remplacement_prenom_15, c0_.date_heure_creation AS date_heure_creation_16, c0_.date_heure_modification AS date_heure_modification_17, c0_.date_heure_annulation AS date_heure_annulation_18, c0_.qualification AS qualification_19, c0_.id_bestt AS id_bestt_20, c0_.titre AS titre_21, c0_.commentaire AS commentaire_22, c0_.import AS import_23, c0_.nombre_documents AS nombre_documents_24, c0_.salaries AS salaries_25, c0_.commande_planning AS commande_planning_26, c0_.confirmation_client AS confirmation_client_27, c0_.demande_profils_agence AS demande_profils_agence_28, c0_.traite AS traite_29, c0_.horaire_travail AS horaire_travail_30, c0_.id_contact AS id_contact_31, c0_.id_client AS id_client_32, c0_.id_agence AS id_agence_33, c0_.id_motif_recours AS id_motif_recours_34, c0_.id_lieu_mission AS id_lieu_mission_35, c0_.id_permanent AS id_permanent_36 FROM commande c0_ WHERE c0_.id_agence = ? AND c0_.id_bestt = ? AND c0_.etat = ? ORDER BY c0_.id_commande ASC LIMIT 30
Parameters: 
[
  10
  "0"
  "EV"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(7.45%) 		1 
SELECT t0.id_user AS id_user_1, t0.user_name AS user_name_2, t0.mail AS mail_3, t0.roles AS roles_4, t0.password AS password_5, t0.actif AS actif_6, t0.date_creation AS date_creation_7, t0.date_desactivation AS date_desactivation_8, t0.photo_profil AS photo_profil_9, t0.reset_token AS reset_token_10, t0.actif_token AS actif_token_11, t0.recent AS recent_12, t0.last_login AS last_login_13, t0.nombre_connexions AS nombre_connexions_14, t0.modified_push_subscription AS modified_push_subscription_15, t0.is_allowed_to_switch AS is_allowed_to_switch_16, t0.cree_dans_bestt AS cree_dans_bestt_17, t0.id_salarie AS id_salarie_18, t0.id_permanent AS id_permanent_19, t0.id_contact AS id_contact_20 FROM user t0 WHERE t0.user_name = ? LIMIT 1
Parameters: 
[
  "1234-8572afc2c42a4019bd4826e8383bb635"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(7.05%) 		1 
SELECT t0.id_agence AS id_agence_1, t0.mail AS mail_2, t0.telephone AS telephone_3, t0.adresse_1 AS adresse_1_4, t0.adresse_2 AS adresse_2_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.img_logo AS img_logo_8, t0.site_web AS site_web_9, t0.siret AS siret_10, t0.date_creation AS date_creation_11, t0.raison_sociale AS raison_sociale_12, t0.uuid AS uuid_13, t0.password AS password_14, t0.stylesheet AS stylesheet_15, t0.gestion_reglement AS gestion_reglement_16, t0.traitement_journalier AS traitement_journalier_17, t0.traitement_horaire AS traitement_horaire_18, t0.url_bestt_net AS url_bestt_net_19, t0.message_client AS message_client_20, t0.message_salarie AS message_salarie_21, t0.b_acomptes AS b_acomptes_22, t0.b_paies AS b_paies_23, t0.b_contrats_salarie AS b_contrats_salarie_24, t0.b_contrats_client AS b_contrats_client_25, t0.b_factures AS b_factures_26, t0.b_rh_client AS b_rh_client_27, t0.b_rh_salarie AS b_rh_salarie_28, t0.b_sl_docs AS b_sl_docs_29, t0.b_cl_docs AS b_cl_docs_30, t0.b_dpae AS b_dpae_31, t0.msa AS msa_32, t0.mail_client_releves AS mail_client_releves_33, t0.b_commande_salaire AS b_commande_salaire_34, t0.b_planning_client AS b_planning_client_35, t0.b_etat_facture_client AS b_etat_facture_client_36, t0.b_offres_salaries AS b_offres_salaries_37, t0.id_groupe AS id_groupe_38, t0.mail_agence_id AS mail_agence_id_39 FROM agence t0 WHERE t0.uuid = ? LIMIT 1
Parameters: 
[
  "1234-8572afc2c42a4019bd4826e8383bb635"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(6.52%) 		2 
SELECT t0.id_client AS id_client_1, t0.raison_sociale AS raison_sociale_2, t0.siret AS siret_3, t0.adresse_1 AS adresse_1_4, t0.adresse_2 AS adresse_2_5, t0.code_postal AS code_postal_6, t0.telephone_1 AS telephone_1_7, t0.mail AS mail_8, t0.ville AS ville_9, t0.duree_hebdo AS duree_hebdo_10 FROM client t0 WHERE t0.id_client = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(6.24%) 		2 
SELECT t0.id_agence_client AS id_agence_client_1, t0.id_bestt AS id_bestt_2, t0.is_be_sign AS is_be_sign_3, t0.actif AS actif_4, t0.id_client AS id_client_5, t0.id_agence AS id_agence_6 FROM agence_client t0 WHERE t0.id_client = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(5.92%) 		2 
SELECT t0.id_motif_recours AS id_motif_recours_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM motif_recours t0 WHERE t0.id_motif_recours = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(5.86%) 		1 
SELECT t0.id_contact AS id_contact_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.sexe AS sexe_4, t0.telephone_1 AS telephone_1_5, t0.telephone_2 AS telephone_2_6, t0.mail AS mail_7, t0.nouvelle_entree AS nouvelle_entree_8, t0.edited AS edited_9, t0.nouvelle_photo AS nouvelle_photo_10, t0.id_client AS id_client_11, t12.id_user AS id_user_13, t12.user_name AS user_name_14, t12.mail AS mail_15, t12.roles AS roles_16, t12.password AS password_17, t12.actif AS actif_18, t12.date_creation AS date_creation_19, t12.date_desactivation AS date_desactivation_20, t12.photo_profil AS photo_profil_21, t12.reset_token AS reset_token_22, t12.actif_token AS actif_token_23, t12.recent AS recent_24, t12.last_login AS last_login_25, t12.nombre_connexions AS nombre_connexions_26, t12.modified_push_subscription AS modified_push_subscription_27, t12.is_allowed_to_switch AS is_allowed_to_switch_28, t12.cree_dans_bestt AS cree_dans_bestt_29, t12.id_salarie AS id_salarie_30, t12.id_permanent AS id_permanent_31, t12.id_contact AS id_contact_32 FROM contact t0 LEFT JOIN user t12 ON t12.id_contact = t0.id_contact WHERE t0.id_contact = ?
Parameters: 
[
  1
]
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
App\Entity\Commande 4
App\Entity\MotifRecours 2
App\Entity\Client 2
App\Entity\AgenceClient 2
App\Entity\Agence 1
App\Entity\MailAgence 1
App\Entity\Contact 1
App\Entity\Permanent 1
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Salarie No errors.
App\Entity\Permanent No errors.
App\Entity\Contact No errors.
App\Entity\Agence No errors.
App\Entity\Groupe No errors.
App\Entity\MailAgence No errors.
App\Entity\AgenceClient No errors.
App\Entity\AgenceContact No errors.
App\Entity\AgenceSalarie No errors.
App\Entity\AgencePermanent No errors.
App\Entity\Qualification No errors.
App\Entity\Commande No errors.
App\Entity\Indisponibilite No errors.
App\Entity\SalaireSynthese No errors.
App\Entity\FactureSynthese No errors.
App\Entity\DocumentDemande No errors.
App\Entity\Contrat No errors.
App\Entity\Acompte No errors.
App\Entity\LieuMission No errors.
App\Entity\Document No errors.
App\Entity\Notification No errors.
App\Entity\Candidat No errors.
App\Entity\ClientSalarieInfo No errors.
App\Entity\Prospect No errors.
App\Entity\Client No errors.
App\Entity\Releve No errors.
App\Entity\PushSubscription No errors.
App\Entity\NotificationUser No errors.
App\Entity\MotifRecours No errors.