Symfony Profiler

[
  "route" => "admin_accounts_add_entreprise"
  "route_parameters" => [
    "_route" => "admin_accounts_add_entreprise"
    "_controller" => "App\Controller\AccountEntrepriseController::addEntreprise"
    "id" => "52"
  ]
  "request_uri" => "https://admin.smartimmo-app.com/admin/accounts/52/add-entreprise"
  "method" => "POST"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "331n9.myd.infomaniak.com"
    "port" => 3306
    "user" => "331n9_gka229"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "331n9_immo"
    "serverVersion" => "10.4.24-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.name AS name_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.code AS code_7, t0.phone AS phone_8, t0.sexe AS sexe_9, t0.status AS status_10, t0.role_id AS role_id_11, t0.admin_id AS admin_id_12 FROM admin t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3 FROM roles t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "eliekaboza2025@gmail.com"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\UsersAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\UsersAuthenticator"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.name AS name_4, t0.lastname AS lastname_5, t0.code AS code_6, t0.status AS status_7, t0.reset AS reset_8, t0.sexe AS sexe_9, t0.phone AS phone_10, t0.picture AS picture_11, t0.notif AS notif_12, t0.email AS email_13, t0.profil AS profil_14, t0.level AS level_15, t0.adress AS adress_16, t0.city AS city_17, t0.province AS province_18, t0.mode AS mode_19, t0.last_action AS last_action_20, t0.role_id AS role_id_21, t0.entreprise_id AS entreprise_id_22, t0.created_by_id AS created_by_id_23, t0.country_id AS country_id_24 FROM User t0 WHERE t0.id = ?"
  "params" => [
    1 => "52"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.adress AS adress_4, t0.email AS email_5, t0.phone AS phone_6, t0.pseudo AS pseudo_7, t0.description AS description_8, t0.rccm AS rccm_9, t0.icon AS icon_10, t0.status AS status_11, t0.smsservice AS smsservice_12, t0.invoiceservice AS invoiceservice_13, t0.idnat AS idnat_14, t0.numeroimpot AS numeroimpot_15, t0.city AS city_16, t0.province AS province_17, t0.nbrebiensimmobiliers AS nbrebiensimmobiliers_18, t0.free_trail AS free_trail_19, t0.period AS period_20, t0.recallpaymentnotification AS recallpaymentnotification_21, t0.smart_paykey AS smart_paykey_22, t0.make_journal AS make_journal_23, t0.admin_id AS admin_id_24, t0.country_id AS country_id_25, t0.package_id AS package_id_26, t0.owner_id AS owner_id_27 FROM entreprise t0 WHERE t0.id = ?"
  "params" => [
    1 => "39"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.role AS role_2, t0.status AS status_3, t0.user_id AS user_id_4, t0.entreprise_id AS entreprise_id_5 FROM user_entreprise t0 WHERE t0.user_id = ? AND t0.entreprise_id = ? LIMIT 1"
  "params" => [
    1 => 52
    2 => 39
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "INSERT INTO user_entreprise (role, status, user_id, entreprise_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "OWNER"
    2 => 1
    3 => 52
    4 => 39
  ]
  "types" => [
    1 => 2
    2 => 5
    3 => 1
    4 => 1
  ]
]

[
  "sql" => "UPDATE User SET entreprise_id = ? WHERE id = ?"
  "params" => [
    1 => 39
    2 => 52
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "UPDATE entreprise SET email = ?, phone = ?, owner_id = ? WHERE id = ?"
  "params" => [
    1 => "eliekabozailunga@gmail.com"
    2 => "0828821532"
    3 => 52
    4 => 39
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
    4 => 1
  ]
]

[
  "key" => "_security_main"
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\r\n
    FROM information_schema.TABLES\r\n
    WHERE TABLE_SCHEMA = ?\r\n
      AND TABLE_TYPE = 'BASE TABLE'\r\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "331n9_immo"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\r\n
    FROM information_schema.TABLES\r\n
    WHERE TABLE_SCHEMA = ?\r\n
      AND TABLE_TYPE = 'BASE TABLE'\r\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "331n9_immo"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
        SELECT t.TABLE_NAME,\r\n
               t.ENGINE,\r\n
               t.AUTO_INCREMENT,\r\n
               t.TABLE_COMMENT,\r\n
               t.CREATE_OPTIONS,\r\n
               t.TABLE_COLLATION,\r\n
               ccsa.CHARACTER_SET_NAME\r\n
          FROM information_schema.TABLES t\r\n
            INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa\r\n
                ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
    """
  "params" => [
    1 => "331n9_immo"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT DISTINCT            k.CONSTRAINT_NAME,\r\n
                k.COLUMN_NAME,\r\n
                k.REFERENCED_TABLE_NAME,\r\n
                k.REFERENCED_COLUMN_NAME,\r\n
                k.ORDINAL_POSITION /*!50116,\r\n
                c.UPDATE_RULE,\r\n
                c.DELETE_RULE */\r\n
    FROM information_schema.key_column_usage k /*!50116\r\n
    INNER JOIN information_schema.referential_constraints c\r\n
    ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME\r\n
    AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = '331n9_immo' */ ORDER BY k.ORDINAL_POSITION
    """
  "params" => [
    1 => "331n9_immo"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    SELECT       c.COLUMN_NAME        AS field,\r\n
               IF(\r\n
            x.CHECK_CLAUSE IS NOT NULL AND c.COLUMN_TYPE = 'longtext',\r\n
            'json',\r\n
            c.COLUMN_TYPE\r\n
        )       AS type,\r\n
           c.IS_NULLABLE        AS `null`,\r\n
           c.COLUMN_KEY         AS `key`,\r\n
           c.COLUMN_DEFAULT     AS `default`,\r\n
           c.EXTRA,\r\n
           c.COLUMN_COMMENT     AS comment,\r\n
           c.CHARACTER_SET_NAME AS characterset,\r\n
           c.COLLATION_NAME     AS collation\r\n
    FROM information_schema.COLUMNS c\r\n
        INNER JOIN information_schema.TABLES t\r\n
            ON t.TABLE_NAME = c.TABLE_NAME\r\n
        LEFT JOIN information_schema.CHECK_CONSTRAINTS x\r\n
        ON (\r\n
            c.TABLE_SCHEMA = x.CONSTRAINT_SCHEMA\r\n
            AND c.TABLE_NAME = x.TABLE_NAME\r\n
            AND x.CHECK_CLAUSE = CONCAT('json_valid(`', c.COLUMN_NAME , '`)')\r\n
        ) WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
    """
  "params" => [
    1 => "331n9_immo"
    2 => "331n9_immo"
    3 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT        NON_UNIQUE  AS Non_Unique,\r\n
            INDEX_NAME  AS Key_name,\r\n
            COLUMN_NAME AS Column_Name,\r\n
            SUB_PART    AS Sub_Part,\r\n
            INDEX_TYPE  AS Index_Type\r\n
    FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
    """
  "params" => [
    1 => "331n9_immo"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT * FROM doctrine_migration_versions"
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]