Symfony Profiler

[
  "info" => [
    "header_size" => 303
    "request_size" => 154
    "total_time" => 0.654936
    "namelookup_time" => 0.079174
    "connect_time" => 0.079473
    "pretransfer_time" => 0.090046
    "size_download" => 11465.0
    "speed_download" => 17530.0
    "starttransfer_time" => 0.63712
    "primary_ip" => "185.181.163.147"
    "primary_port" => 443
    "local_ip" => "10.52.26.243"
    "local_port" => 34394
    "http_version" => 3
    "protocol" => 2
    "scheme" => "HTTPS"
    "appconnect_time_us" => 89730
    "connect_time_us" => 79473
    "namelookup_time_us" => 79174
    "pretransfer_time_us" => 90046
    "starttransfer_time_us" => 637120
    "total_time_us" => 654936
    "effective_method" => "GET"
    "start_time" => 1765339910.5013
    "original_url" => "https://frontest.simplyform.lmosoft.com/api/module/details/BAS10"
    "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: Nov 25 23:17:47 2025 GMT\n
      *  expire date: Feb 23 23:17:46 2026 GMT\n
      *  issuer: C=US; O=Let's Encrypt; CN=R13\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 0x3893a80)\n
      > GET /api/module/details/BAS10 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: Wed, 10 Dec 2025 04:11:50 GMT\r\n
      < server: Apache\r\n
      < cache-control: no-cache, private\r\n
      < x-debug-token: 0097d7\r\n
      < x-debug-token-link: https://frontest.simplyform.lmosoft.com/_profiler/0097d7\r\n
      < x-robots-tag: noindex\r\n
      < strict-transport-security: max-age=16000000\r\n
      < content-type: application/json\r\n
      < \r\n
      """
  ]
  "response_headers" => [
    "HTTP/2 200 "
    "date: Wed, 10 Dec 2025 04:11:50 GMT"
    "server: Apache"
    "cache-control: no-cache, private"
    "x-debug-token: 0097d7"
    "x-debug-token-link: https://frontest.simplyform.lmosoft.com/_profiler/0097d7"
    "x-robots-tag: noindex"
    "strict-transport-security: max-age=16000000"
    "content-type: application/json"
  ]
  "response_content" => [
    "{"id":10,"heures":35,"min":0,"financeurs":[],"path":"Conception-de-bases-de-donnees-et-langage-SQL","dateupdate":"26-09-2025","statistiques":{"tauxobtention":"","tauxabandon":"","tauxsatisfaction":"","tauxpoursuiteetude":"","tauxemployabilite":"","salairemoyen":""},"archive":false,"certification":false,"public":"Charg\u00e9(e)s de reporting ou d\u0027analyse, assistant(e)s, toute personne ayant des besoins d\u0027interrogation simples d\u0027une base de donn\u00e9es avec le langage SQL.","infopratique":"\u003Cp\u003EHORAIRES DE LA FORMATION\u003Cbr\u003Ede 9 h 00 \u00e0 12 h 30 et de 13 h 30 \u00e0 17 h 00\u003Cbr\u003E\u003Cbr\u003E\u003C\/p\u003E","cpf":false,"code":"BAS10","intitule":"Conception de bases de donn\u00e9es et langage SQL (module)","duree":2100,"mode":"Pr\u00e9sentiel","modes":["Classe virtuelle","Pr\u00e9sentiel"],"niveaumateriel":"1 - Niveau d\u0027\u00e9quipement mat\u00e9riel faible","niveautechnique":"D\u00e9butant","description":{"publie":true,"prerequis":"Connaissance du secteur informatique.","objectif":"Comprendre les principes du mod\u00e8le relationnel et les m\u00e9canismes d\u0027une base de donn\u00e9es compatible avec SQL\r\nCr\u00e9er des requ\u00eates pour extraire des donn\u00e9es suivant diff\u00e9rents crit\u00e8res\r\nR\u00e9aliser des jointures pour restituer les informations de plusieurs tables\r\nUtiliser des fonctions et manipuler des calculs d\u0027agr\u00e9gations de donn\u00e9es\r\nCombiner le r\u00e9sultat de plusieurs requ\u00eates (op\u00e9rateurs ensemblistes)","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 notre espace candidat, il y a une rubrique Handicap o\u00f9 vous pourrez d\u00e9poser toutes vos demandes d\u0027adaptation afin de suivre cette formation dans les meilleures conditions.","modalitesDelaisAcces":"L\u2019inscription doit \u00eatre finalis\u00e9e 24 heures avant le d\u00e9but de la formation.","modulesExigeAvant":"\u003Cul\u003E\u003C\/ul\u003E","modulesSouhaitableAvant":"\u003Cul\u003E\u003C\/ul\u003E","modulesConseilleApres":"\u003Cul\u003E\u003C\/ul\u003E","infopratique":"\u003Cp\u003EHORAIRES DE LA FORMATION\u003Cbr\u003Ede 9 h 00 \u00e0 12 h 30 et de 13 h 30 \u00e0 17 h 00\u003Cbr\u003E\u003Cbr\u003E\u003C\/p\u003E","description":"Cette formation \u0022d\u00e9couverte\u0022 vous permettra de comprendre les bases de donn\u00e9es dites relationnelles et leurs principes de fonctionnement. Vous manipulerez le langage SQL pour interroger les donn\u00e9es d\u0027une base. Vous vous familiariserez \u00e9galement avec des r","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\u2026"},"tarifVenteInter":"2100 \u20ac HT","modulesExigeAvant":[],"modulesSouhaitableAvant":[],"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\u2026","listecertifications":[],"listemodules":null,"sessions":[],"competences":{"moduleCompetences":[{"id":21,"intitule":"Cr\u00e9er des requ\u00eates pour extraire des donn\u00e9es suivant diff\u00e9rents crit\u00e8res","ordre":1,"duree":30,"type":"module","aevaluer":true,"evaluations":"Des requ\u00eates sont cr\u00e9\u00e9es en conformit\u00e9.","criteres":"Des requ\u00eates sont cr\u00e9\u00e9es en conformit\u00e9.","modaliteEvaluation":"Un Quiz de fin de s\u00e9quence ainsi que le passage de la Certification pour les participants qui le souhaitent. ","quiz":"","quizId":null,"documents":[],"procedeevaluations":"\u003Cul\u003E\u003Cli\u003EQuiz\u003C\/li\u003E\u003C\/ul\u003E","procedeevaluationIds":[6447]},{"id":22,"intitule":"R\u00e9aliser des jointures pour restituer les informations de plusieurs tables","ordre":2,"duree":30,"type":"module","aevaluer":true,"evaluations":"Savoir r\u00e9aliser des jointures.","criteres":"Savoir r\u00e9aliser des jointures.","modaliteEvaluation":"Un Quiz de fin de s\u00e9quence ainsi que le passage de la Certification pour les participants qui le souhaitent. ","quiz":"","quizId":null,"documents":[],"procedeevaluations":"\u003Cul\u003E\u003Cli\u003EQuiz\u003C\/li\u003E\u003C\/ul\u003E","procedeevaluationIds":[6447]}]},"seo":{"publication":"\u003Cspan class=\u0022badge bg-success\u0022\u003EPubli\u00e9\u003C\/span\u003E","seotitre":"Base de donn\u00e9es SQL","seodescription":"Base de donn\u00e9es SQL","contenuavant":"Base de donn\u00e9es SQL","contenuapres":"Base de donn\u00e9es SQL"},"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-SQL-68d12f936e7b7.png","vignette":"https:\/\/frontest.simplyform.lmosoft.com\/uploads\/module\/vignette\/Vignette-SQL-68d12f936e43d.png","altBanniere":"SQL","altVignette":"SQL"},"Programmes":{"chapitres":[{"id":27,"intitule":"Introduction aux bases de donn\u00e9es","ordre":1,"commentaire":"Qu\u0027est-ce qu\u0027une base et un serveur de base de donn\u00e9es ?\r\nLire un mod\u00e8le relationnel.\r\nComposition d\u0027une table. Notion de colonne et de types.\r\nCl\u00e9 primaire et unicit\u00e9.\r\nNotion d\u0027int\u00e9grit\u00e9 r\u00e9f\u00e9rentielle.\r\nOutil pour interroger une base.","travauxpratiques":"Exercice : Investigation dans la base \u00e0 la recherche de tables, colonnes et cl\u00e9s."},{"id":28,"intitule":"Extraire les donn\u00e9es d\u0027une table","ordre":2,"commentaire":"Qu\u0027est-ce qu\u0027une requ\u00eate d\u0027extraction ?\r\nLister les valeurs \u00e0 retourner.\r\nLa clause WHERE pour filtrer les donn\u00e9es.\r\nL\u0027absence de valeur (marqueur NULL).\r\nRetourner des lignes sans doublon (DISTINCT).\r\nOp\u00e9rateurs de restriction (BETWEEN, IN, LIKE...).","travauxpratiques":"Exercice : Interrogations de plusieurs tables sur des crit\u00e8res diff\u00e9rents."},{"id":29,"intitule":"Interroger les donn\u00e9es de plusieurs tables","ordre":3,"commentaire":"Principe des jointures : restituer les informations \u00e0 partir de plusieurs tables.\r\nJointure interne et jointure externe.\r\nLa jointure \u0022naturelle\u0022 et ses difficult\u00e9s.\r\nOp\u00e9rateurs ensemblistes (UNION, INTERSECT...).\r\nIntroduction aux vues : principe et int\u00e9","travauxpratiques":"Exercice : R\u00e9aliser des requ\u00eates avec des jointures et des op\u00e9rateurs ensemblistes."}]},"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":"Charg\u00e9(e)s de reporting ou d\u0027analyse, assistant(e)s, toute personne ayant des besoins d\u0027interrogation simples d\u0027une base de donn\u00e9es avec le langage SQL.","commentaire":"","iscpf":false,"cpf":"\u003Cspan class=\u0022badge bg-danger\u0022\u003ESans CPF\u003C\/span\u003E","niveautechnique":"D\u00e9butant","niveaumateriel":"1 - Niveau d\u0027\u00e9quipement mat\u00e9riel faible","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\/10\/module-export-pdf-front"}"
  ]
]