Symfony Profiler

[
  "info" => [
    "header_size" => 504
    "request_size" => 155
    "total_time" => 0.50623
    "namelookup_time" => 0.000787
    "connect_time" => 0.001194
    "pretransfer_time" => 0.010814
    "size_download" => 12156.0
    "speed_download" => 24023.0
    "starttransfer_time" => 0.476087
    "primary_ip" => "185.181.163.147"
    "primary_port" => 443
    "local_ip" => "10.52.26.243"
    "local_port" => 39552
    "http_version" => 3
    "protocol" => 2
    "scheme" => "HTTPS"
    "appconnect_time_us" => 10566
    "connect_time_us" => 1194
    "namelookup_time_us" => 787
    "pretransfer_time_us" => 10814
    "starttransfer_time_us" => 476087
    "total_time_us" => 506230
    "effective_method" => "GET"
    "start_time" => 1769961812.3987
    "original_url" => "https://frontest.simplyform.lmosoft.com/api/module/details/BAS116"
    "pause_handler" => Closure(float $duration) {#1513
      class: "Symfony\Component\HttpClient\Response\CurlResponse"
      use: {
        $ch: CurlHandle {#1487 …}
        $multi: Symfony\Component\HttpClient\Internal\CurlClientState {#1498 …}
        $execCounter: -9223372036854775808
      }
    }
    "debug" => """
      *   Trying 185.181.163.147:443...\n
      * Connected to frontest.simplyform.lmosoft.com (185.181.163.147) port 443 (#0)\n
      * ALPN, offering h2\n
      * ALPN, offering http/1.1\n
      * successfully set certificate verify locations:\n
      *  CAfile: /etc/ssl/certs/ca-certificates.crt\n
      *  CApath: /etc/ssl/certs\n
      * SSL connection using TLSv1.3 / TLS_AES_256_GCM_SHA384\n
      * ALPN, server accepted to use h2\n
      * Server certificate:\n
      *  subject: CN=frontest.simplyform.lmosoft.com\n
      *  start date: Jan 29 22:42:28 2026 GMT\n
      *  expire date: Apr 29 22:42:27 2026 GMT\n
      *  issuer: C=US; O=Let's Encrypt; CN=R12\n
      *  SSL certificate verify ok.\n
      * Using HTTP2, server supports multi-use\n
      * Connection state changed (HTTP/2 confirmed)\n
      * Copying HTTP/2 data in stream buffer to connection buffer after upgrade: len=0\n
      * Using Stream ID: 1 (easy handle 0x4d12190)\n
      > GET /api/module/details/BAS116 HTTP/2\r\n
      Host: frontest.simplyform.lmosoft.com\r\n
      accept: */*\r\n
      user-agent: Symfony HttpClient (Curl)\r\n
      accept-encoding: gzip\r\n
      \r\n
      * old SSL session ID is stale, removing\n
      * Connection state changed (MAX_CONCURRENT_STREAMS == 30)!\n
      < HTTP/2 200 \r\n
      < date: Sun, 01 Feb 2026 16:03:32 GMT\r\n
      < server: Apache\r\n
      < cache-control: no-cache, private\r\n
      < x-debug-token: 9cc791\r\n
      < x-debug-token-link: https://frontest.simplyform.lmosoft.com/_profiler/9cc791\r\n
      < x-robots-tag: noindex\r\n
      * Added cookie gestiform_deauth_profile_token="9cc791" for domain frontest.simplyform.lmosoft.com, path /, expire 0\n
      < set-cookie: gestiform_deauth_profile_token=9cc791; path=/; httponly; samesite=lax\r\n
      * Added cookie gestiform_auth_profile_token="deleted" for domain frontest.simplyform.lmosoft.com, path /, expire 1\n
      < set-cookie: gestiform_auth_profile_token=deleted; expires=Sat, 01 Feb 2025 16:03:31 GMT; Max-Age=0; path=/; httponly\r\n
      < strict-transport-security: max-age=16000000\r\n
      < content-type: application/json\r\n
      < \r\n
      """
  ]
  "response_headers" => [
    "HTTP/2 200 "
    "date: Sun, 01 Feb 2026 16:03:32 GMT"
    "server: Apache"
    "cache-control: no-cache, private"
    "x-debug-token: 9cc791"
    "x-debug-token-link: https://frontest.simplyform.lmosoft.com/_profiler/9cc791"
    "x-robots-tag: noindex"
    "set-cookie: gestiform_deauth_profile_token=9cc791; path=/; httponly; samesite=lax"
    "set-cookie: gestiform_auth_profile_token=deleted; expires=Sat, 01 Feb 2025 16:03:31 GMT; Max-Age=0; path=/; httponly"
    "strict-transport-security: max-age=16000000"
    "content-type: application/json"
  ]
  "response_content" => [
    "{"id":116,"heures":35,"min":0,"financeurs":[],"path":"Optimisation-base-de-donnees-sous-Oracle","dateupdate":"","statistiques":{"tauxobtention":"","tauxabandon":"","tauxsatisfaction":"","tauxpoursuiteetude":"","tauxemployabilite":"","salairemoyen":""},"archive":false,"certification":false,"public":"D\u00e9veloppeurs, exploitants de bases de donn\u00e9es, administrateurs de bases de donn\u00e9es.","infopratique":"HORAIRES DE LA FORMATION de 9 h 00 \u00e0 12 h 30 et de 13 h 30 \u00e0 17 h 00","cpf":false,"code":"BAS116","intitule":"Optimisation base de donn\u00e9es sous Oracle (module)","duree":2100,"mode":"Classe virtuelle","modes":["Classe virtuelle","Pr\u00e9sentiel"],"niveaumateriel":"4 - Niveau d\u0027\u00e9quipement mat\u00e9riel excellent","niveautechnique":"Avanc\u00e9","description":{"publie":false,"prerequis":"Connaissance du langage SQL, MySql et des principes g\u00e9n\u00e9raux des bases de donn\u00e9es.","objectif":"Exploiter les fonctionnalit\u00e9s d\u0027Oracle pour optimiser une base de donn\u00e9es.","plus":"Acc\u00e8s \u00e0 la biblioth\u00e8que num\u00e9rique pendant 3 mois : + de 1000 tutos, livres num\u00e9riques et vid\u00e9os Salles de formation climatis\u00e9es \u00e9quip\u00e9es d\u2019ordinateurs PC de derni\u00e8re g\u00e9n\u00e9ration Vid\u00e9os projecteurs interactifs Support de cours du formateur.","accessibiliteHandicap":"Dans votre espace candidat, une rubrique d\u00e9di\u00e9e au handicap vous permettra d\u0027exprimer vos besoins d\u0027adaptation afin que vous puissiez suivre votre formation dans les meilleures conditions.","modalitesDelaisAcces":"L\u2019inscription doit \u00eatre finalis\u00e9e 72 heures avant le d\u00e9but de la formation.","modulesExigeAvant":"\u003Cul\u003E\u003C\/ul\u003E","modulesSouhaitableAvant":"\u003Cul\u003E\u003Cli\u003EPL\/SQL sous ORACLE, requ\u00eates avec Triggers\u003C\/li\u003E\u003Cli\u003ETriggers et proc\u00e9dures stock\u00e9es avec Oracle \u2013 PL\/SQL\u003C\/li\u003E\u003C\/ul\u003E","modulesConseilleApres":"\u003Cul\u003E\u003C\/ul\u003E","infopratique":"HORAIRES DE LA FORMATION de 9 h 00 \u00e0 12 h 30 et de 13 h 30 \u00e0 17 h 00","description":"Cette formation vous permettra d\u0027apprendre \u00e0 optimiser vos bases de donn\u00e9es sous Oracle.","modalitepedagogiques":"Alternance \u00e9quilibr\u00e9e de pr\u00e9sentations, d\u0027ateliers sur simulateur et de mises en situation dans des conditions similaires \u00e0 celles de l\u0027examen.","modaliteevaluationinitial":"Test de positionnement en amont de la session de formation.","modaliteevaluationfinal":"Le formateur \u00e9value la progression p\u00e9dagogique du participant tout au long de la formation au moyen de QCM, mises en situation, travaux pratiques."},"tarifVenteInter":"2100 \u20ac HT","modulesExigeAvant":[],"modulesSouhaitableAvant":[{"id":114,"isnew":false,"statistiques":"\u003Cp\u003ETaux de satisfaction : 100%\u003C\/p\u003E\u003Cp\u003ETaux d\u0027abandon : 0%\u003C\/p\u003E","description":"PL\/SQL est un langage de programmation proc\u00e9dural et structur\u00e9. Trigger (d\u00e9clencheur) est un dispositif logiciel qui provoque un traitement particulier en fonction d\u0027\u00e9v\u00e9nements pr\u00e9d\u00e9finis.","archive":false,"cpf":false,"code":"BAS114","intitule":"PL\/SQL sous ORACLE, requ\u00eates avec Triggers (module)","duree":"5 jours","soustheme":"Langage SQL, MySQL, PostgreSQL","tarif":"2100 \u20ac HT","mode":"Classe virtuelle","images":{"banniere":"https:\/\/frontest.simplyform.lmosoft.com\/uploads\/module\/banniere\/Banniere-oracle-6900a22bf2e1b.png","vignette":"https:\/\/frontest.simplyform.lmosoft.com\/uploads\/module\/vignette\/Vignette-oracle-6900a22bf291f.png","altBanniere":"PL\/SQL sous ORACLE, requ\u00eates avec Triggers","altVignette":"PL\/SQL sous ORACLE, requ\u00eates avec Triggers"}},{"id":115,"isnew":false,"statistiques":"\u003Cp\u003ETaux de satisfaction : 100%\u003C\/p\u003E\u003Cp\u003ETaux d\u0027abandon : 0%\u003C\/p\u003E","description":"PL\/SQL est un langage de programmation proc\u00e9dural et structur\u00e9. Trigger (d\u00e9clencheur) est un dispositif logiciel qui provoque un traitement particulier en fonction d\u0027\u00e9v\u00e9nements pr\u00e9d\u00e9finis.","archive":false,"cpf":false,"code":"ASS115","intitule":"Triggers et proc\u00e9dures stock\u00e9es avec Oracle \u2013 PL\/SQL (module)","duree":"5 jours","soustheme":"Langage SQL, MySQL, PostgreSQL","tarif":"2100 \u20ac HT","mode":"Classe virtuelle","images":{"banniere":"https:\/\/frontest.simplyform.lmosoft.com\/uploads\/module\/banniere\/Banniere-oracle-6900acda04e0e.png","vignette":"https:\/\/frontest.simplyform.lmosoft.com\/uploads\/module\/vignette\/Vignette-oracle-6900acda04a53.png","altBanniere":"Triggers et proc\u00e9dures stock\u00e9es avec Oracle \u2013 PL\/SQL","altVignette":"Triggers et proc\u00e9dures stock\u00e9es avec Oracle \u2013 PL\/SQL"}}],"modulesConseilleApres":[],"theme":"Bases de donn\u00e9es \u0026 Big data","soustheme":"Langage SQL, MySQL, PostgreSQL","tarifVenteIntra":"Tarif sur demande","modalitepedagogiques":"Alternance \u00e9quilibr\u00e9e de pr\u00e9sentations, d\u0027ateliers sur simulateur et de mises en situation dans des conditions similaires \u00e0 celles de l\u0027examen.","modaliteevaluationinitial":"Test de positionnement en amont de la session de formation.","modaliteevaluationfinal":"Le formateur \u00e9value la progression p\u00e9dagogique du participant tout au long de la formation au moyen de QCM, mises en situation, travaux pratiques.","listecertifications":[],"listemodules":null,"sessions":[],"competences":{"moduleCompetences":[{"id":234,"intitule":"Int\u00e9grer des fonctions dans PL\/SQL ;","ordre":1,"duree":30,"type":"module","aevaluer":true,"evaluations":"Les fonctions sont int\u00e9gr\u00e9es dans PL\/SQL.","criteres":"Les fonctions sont int\u00e9gr\u00e9es dans PL\/SQL.","modaliteEvaluation":"","quiz":"","quizId":null,"documents":[],"procedeevaluations":"\u003Cul\u003E\u003Cli\u003E\u00c9tude de cas\u003C\/li\u003E\u003C\/ul\u003E","procedeevaluationIds":[264]},{"id":235,"intitule":"Utiliser des proc\u00e9dures stock\u00e9es avec les \u00e9l\u00e9ments du langage SQL (variables, boucles, conditions, etc) ;","ordre":2,"duree":30,"type":"module","aevaluer":true,"evaluations":"Des proc\u00e9dures stock\u00e9es sont utilis\u00e9es avec les \u00e9l\u00e9ments du langage SQL (variables, boucles, conditions, etc).","criteres":"Des proc\u00e9dures stock\u00e9es sont utilis\u00e9es avec les \u00e9l\u00e9ments du langage SQL (variables, boucles, conditions, etc).","modaliteEvaluation":"","quiz":"","quizId":null,"documents":[],"procedeevaluations":"\u003Cul\u003E\u003Cli\u003E\u00c9tude de cas\u003C\/li\u003E\u003C\/ul\u003E","procedeevaluationIds":[264]}]},"seo":{"publication":"\u003Cspan class=\u0022badge bg-success\u0022\u003EPubli\u00e9\u003C\/span\u003E","seotitre":"Oracle","seodescription":"Oracle","contenuavant":"","contenuapres":""},"plus":"Acc\u00e8s \u00e0 la biblioth\u00e8que num\u00e9rique pendant 3 mois : + de 1000 tutos, livres num\u00e9riques et vid\u00e9os Salles de formation climatis\u00e9es \u00e9quip\u00e9es d\u2019ordinateurs PC de derni\u00e8re g\u00e9n\u00e9ration Vid\u00e9os projecteurs interactifs Support de cours du formateur.","Images":{"banniere":"https:\/\/frontest.simplyform.lmosoft.com\/uploads\/module\/banniere\/Banniere-oracle-6900b1b2aa99b.png","vignette":"https:\/\/frontest.simplyform.lmosoft.com\/uploads\/module\/vignette\/Vignette-oracle-6900b1b2aa4fb.png","altBanniere":"Oracle","altVignette":"Oracle"},"Programmes":{"chapitres":[{"id":332,"intitule":"Optimiser les requ\u00eates","ordre":1,"commentaire":"Utiliser la commande EXPLAIN \r\nUtilisation des requ\u00eates pr\u00e9par\u00e9es \r\nIdentifier les requ\u00eates lentes","travauxpratiques":"Exercice pratique"},{"id":333,"intitule":"Optimiser la structure de base de donn\u00e9es","ordre":2,"commentaire":"Bien choisir les types de donn\u00e9es \r\nPositionner et optimiser ses indexes","travauxpratiques":"Exercice pratique"},{"id":334,"intitule":"Optimiser la configuration","ordre":3,"commentaire":"Architecture du serveur \t\r\nShow Status : les variables d\u0027\u00e9tat \r\nUtiliser le cache de requ\u00eates (query cache)","travauxpratiques":"Exercice pratique"},{"id":335,"intitule":"Optimiser la sauvegarde","ordre":4,"commentaire":"Sauvegardes \u00e0 chaud, \u00e0 froid, incr\u00e9mentale \r\nRestaurer une sauvegarde","travauxpratiques":"Exercice pratique"}]},"programme":"","Othersdomaines":[{"id":23,"intitule":"NOUVEAUTHEME","code":"NOUV","path":"","etat":"\u003Cspan class=\u0022badge bg-success\u0022\u003EActif\u003C\/span\u003E","ordre":2,"couleur":"#48cb8e","archive":false,"commentaire":"NOUVEAUTHEME","seodescription":"NOUVEAUTHEME","seotitre":"NOUVEAUTHEME","publication":"\u003Cspan class=\u0022badge bg-success\u0022\u003EOui\u003C\/span\u003E","banniere":"","vignette":"","altBanniere":"","altVignette":""},{"id":22,"intitule":"MEGATHEME","code":"MEG","path":"","etat":"\u003Cspan class=\u0022badge bg-success\u0022\u003EActif\u003C\/span\u003E","ordre":2,"couleur":"#3f9aec","archive":false,"commentaire":"1234","seodescription":"MEGATHEM","seotitre":"MEGATHEME","publication":"\u003Cspan class=\u0022badge bg-success\u0022\u003EOui\u003C\/span\u003E","banniere":"","vignette":"","altBanniere":"","altVignette":""},{"id":21,"intitule":"Agenda","code":"agenda","path":"","etat":"\u003Cspan class=\u0022badge bg-success\u0022\u003EActif\u003C\/span\u003E","ordre":2,"couleur":"#000000","archive":false,"commentaire":"agenda","seodescription":"agenda","seotitre":"agenda","publication":"\u003Cspan class=\u0022badge bg-success\u0022\u003EOui\u003C\/span\u003E","banniere":"","vignette":"","altBanniere":"","altVignette":""},{"id":20,"intitule":"Hypertest","code":"HYP","path":"","etat":"\u003Cspan class=\u0022badge bg-success\u0022\u003EActif\u003C\/span\u003E","ordre":2,"couleur":"#249b91","archive":false,"commentaire":"Hypertest","seodescription":"Hypertest","seotitre":"Hypertest","publication":"\u003Cspan class=\u0022badge bg-success\u0022\u003EOui\u003C\/span\u003E","banniere":"https:\/\/frontest.simplyform.lmosoft.com\/uploads\/theme\/banniere\/Screenshot-from-2024-05-19-19-26-32-6909edddcacd7.png","vignette":"https:\/\/frontest.simplyform.lmosoft.com\/uploads\/theme\/vignette\/Screenshot-from-2024-05-19-19-26-32-6909edddca904.png","altBanniere":"banniere","altVignette":"vignette*"},{"id":19,"intitule":"Gigatheme","code":"GIG","path":"","etat":"\u003Cspan class=\u0022badge bg-success\u0022\u003EActif\u003C\/span\u003E","ordre":2,"couleur":"#cd2727","archive":false,"commentaire":"Gigatheme","seodescription":"Gigatheme","seotitre":"Gigatheme","publication":"\u003Cspan class=\u0022badge bg-success\u0022\u003EOui\u003C\/span\u003E","banniere":"","vignette":"","altBanniere":"","altVignette":""},{"id":18,"intitule":"Sauvetage","code":"SAUV","path":"","etat":"\u003Cspan class=\u0022badge bg-success\u0022\u003EActif\u003C\/span\u003E","ordre":2,"couleur":"#ddd052","archive":false,"commentaire":"Sauvetage","seodescription":"Sauvetage","seotitre":"Sauvetage","publication":"\u003Cspan class=\u0022badge bg-success\u0022\u003EOui\u003C\/span\u003E","banniere":"","vignette":"","altBanniere":"","altVignette":""}],"Details":{"identifiantDokelio":"","public":"D\u00e9veloppeurs, exploitants de bases de donn\u00e9es, administrateurs de bases de donn\u00e9es.","commentaire":"","iscpf":false,"cpf":"\u003Cspan class=\u0022badge bg-danger\u0022\u003ESans CPF\u003C\/span\u003E","niveautechnique":"Avanc\u00e9","niveaumateriel":"4 - Niveau d\u0027\u00e9quipement mat\u00e9riel excellent","autoriteDelivranceCpf":null,"codeCpfSalarie":"","codeCpfDemandeurEmploi":"","financeurs":"\u003Cul\u003E\u003C\/ul\u003E","sessions":[]},"Certifications":{"certifiante":"\u003Cspan class=\u0022badge bg-danger\u0022\u003ENon\u003C\/span\u003E","certifiantes":"\u003Cspan class=\u0022badge bg-danger\u0022\u003ENon\u003C\/span\u003E","certificationcommentaire":"","certifications":"\u003Cul\u003E\u003C\/ul\u003E"},"type":"module","urlFront":"https:\/\/frontest.simplyform.lmosoft.com\/116\/module-export-pdf-front"}"
  ]
]