Symfony Profiler

[
  "route" => "admin"
  "route_parameters" => [
    "_route" => "admin"
    "_controller" => "App\Controller\Admin\DashboardController::index"
  ]
  "request_uri" => "https://callcenter.calcoweb.net/admin"
  "method" => "GET"
]

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

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

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "bitcubo_callcenter"
    "serverVersion" => "mariadb-10.4.18"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.codvendedor AS codvendedor_6, t0.is_enabled AS is_enabled_7 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "cindy.alvarez"
]

[
  "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.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

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

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

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

[
  "sql" => "SELECT c0_.id AS id_0, c0_.nombrecliente AS nombrecliente_1, c0_.nombres AS nombres_2, c0_.apellidos AS apellidos_3, c0_.codpostalcliente AS codpostalcliente_4, c0_.direccioncliente AS direccioncliente_5, c0_.poblacioncliente AS poblacioncliente_6, c0_.provinciacliente AS provinciacliente_7, c0_.paiscliente AS paiscliente_8, c0_.telefonocliente AS telefonocliente_9, c0_.telefono2cliente AS telefono2cliente_10, c0_.movilcliente AS movilcliente_11, c0_.emailcliente AS emailcliente_12, c0_.codmonedaminuta AS codmonedaminuta_13, c0_.nifcliente AS nifcliente_14, c0_.zona AS zona_15, c0_.fechareserva AS fechareserva_16, c0_.codcliente AS codcliente_17, c0_.direccion2cliente AS direccion2cliente_18, c0_.total AS total_19, c0_.totalsiniva AS totalsiniva_20, c0_.sucursal AS sucursal_21, c0_.comentario AS comentario_22, c0_.is_finalizada AS is_finalizada_23, c0_.metododepago AS metododepago_24, c0_.tipodeservicio AS tipodeservicio_25, c0_.is_enviado AS is_enviado_26, c0_.filename AS filename_27, c0_.estado AS estado_28, c0_.propinatotal AS propinatotal_29, c0_.propinaporcentaje AS propinaporcentaje_30, c0_.linkdepago AS linkdepago_31, c0_.facturaelectronica AS facturaelectronica_32, c0_.DIRECCION_2 AS DIRECCION_2_33, c0_.NOMBRE_1 AS NOMBRE_1_34, c0_.OTROS_NOMBRES AS OTROS_NOMBRES_35, c0_.APELLIDO_1 AS APELLIDO_1_36, c0_.APELLIDO_2 AS APELLIDO_2_37, c0_.FE_MUNICIPIO AS FE_MUNICIPIO_38, c0_.FE_RESPONSABILIDADES AS FE_RESPONSABILIDADES_39, c0_.TIPO_DE_DOCUMENTO AS TIPO_DE_DOCUMENTO_40, c0_.TIPOPERSONA AS TIPOPERSONA_41, c0_.FE_REGIMEN AS FE_REGIMEN_42, c0_.FE_DET_TRIBUTARIO AS FE_DET_TRIBUTARIO_43, c0_.CUENTA_ALIMENTACION AS CUENTA_ALIMENTACION_44, c0_.CENTRO_COSTOS AS CENTRO_COSTOS_45, c0_.CENTRO_OPERACION AS CENTRO_OPERACION_46, c0_.alias AS alias_47, c0_.email_linkdepago AS email_linkdepago_48, c0_.nombre_receptor AS nombre_receptor_49, c0_.telefono_receptor AS telefono_receptor_50, c0_.observaciones_receptor AS observaciones_receptor_51, c0_.created_at AS created_at_52, c0_.updated_at AS updated_at_53, c0_.user_id AS user_id_54 FROM cabecera c0_ WHERE c0_.is_enviado = ? AND c0_.is_finalizada = ? AND c0_.estado = ? AND c0_.updated_at < ? AND c0_.updated_at > ? ORDER BY c0_.updated_at ASC"
  "params" => [
    1 => 0
    2 => 1
    3 => "PROCESANDO"
    4 => "2025-08-27 14:51:54"
    5 => "2025-08-26 14:56:54"
  ]
  "types" => [
    1 => 5
    2 => 5
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT c0_.sucursal AS sucursal_0, s1_.id AS id_1, s1_.nombre AS nombre_2, s1_.lat AS lat_3, s1_.lng AS lng_4, s1_.poligono AS poligono_5, s1_.color AS color_6, s1_.mon_open_at AS mon_open_at_7, s1_.mon_closed_at AS mon_closed_at_8, s1_.tue_open_at AS tue_open_at_9, s1_.tue_closed_at AS tue_closed_at_10, s1_.wed_open_at AS wed_open_at_11, s1_.wed_closed_at AS wed_closed_at_12, s1_.thu_open_at AS thu_open_at_13, s1_.thu_closed_at AS thu_closed_at_14, s1_.fri_open_at AS fri_open_at_15, s1_.fri_closed_at AS fri_closed_at_16, s1_.sat_open_at AS sat_open_at_17, s1_.sat_closed_at AS sat_closed_at_18, s1_.sun_open_at AS sun_open_at_19, s1_.sun_closed_at AS sun_closed_at_20, s1_.is_enabled AS is_enabled_21, s1_.is_enabled_programming AS is_enabled_programming_22, s1_.is_enabled_reservation AS is_enabled_reservation_23, s1_.is_active AS is_active_24, s1_.delivery_capacity AS delivery_capacity_25, s1_.number_delivery_men AS number_delivery_men_26, s1_.codalmvent AS codalmvent_27, s1_.server AS server_28, s1_.server_db AS server_db_29, s1_.server_user AS server_user_30, s1_.server_pass AS server_pass_31, COUNT(DISTINCT (CASE WHEN c0_.estado = 'PREPARANDO' THEN c0_.id ELSE ? END)) AS sclr_32, COUNT(DISTINCT (CASE WHEN c0_.estado = 'REPARTO' THEN c0_.id ELSE ? END)) AS sclr_33 FROM cabecera c0_ INNER JOIN sucursal s1_ ON (s1_.nombre = c0_.sucursal) WHERE c0_.updated_at > ? GROUP BY c0_.sucursal ORDER BY c0_.updated_at ASC"
  "params" => [
    1 => null
    2 => null
    3 => "2025-08-26 14:56:54"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT e0_.sucursal AS sucursal_0, s1_.id AS id_1, s1_.nombre AS nombre_2, s1_.lat AS lat_3, s1_.lng AS lng_4, s1_.poligono AS poligono_5, s1_.color AS color_6, s1_.mon_open_at AS mon_open_at_7, s1_.mon_closed_at AS mon_closed_at_8, s1_.tue_open_at AS tue_open_at_9, s1_.tue_closed_at AS tue_closed_at_10, s1_.wed_open_at AS wed_open_at_11, s1_.wed_closed_at AS wed_closed_at_12, s1_.thu_open_at AS thu_open_at_13, s1_.thu_closed_at AS thu_closed_at_14, s1_.fri_open_at AS fri_open_at_15, s1_.fri_closed_at AS fri_closed_at_16, s1_.sat_open_at AS sat_open_at_17, s1_.sat_closed_at AS sat_closed_at_18, s1_.sun_open_at AS sun_open_at_19, s1_.sun_closed_at AS sun_closed_at_20, s1_.is_enabled AS is_enabled_21, s1_.is_enabled_programming AS is_enabled_programming_22, s1_.is_enabled_reservation AS is_enabled_reservation_23, s1_.is_active AS is_active_24, s1_.delivery_capacity AS delivery_capacity_25, s1_.number_delivery_men AS number_delivery_men_26, s1_.codalmvent AS codalmvent_27, s1_.server AS server_28, s1_.server_db AS server_db_29, s1_.server_user AS server_user_30, s1_.server_pass AS server_pass_31, COUNT(DISTINCT (CASE WHEN e0_.estado = 'PREPARACION' THEN e0_.id ELSE ? END)) AS sclr_32, COUNT(DISTINCT (CASE WHEN e0_.estado = 'REPARTO' THEN e0_.id ELSE ? END)) AS sclr_33 FROM ecommerce_cabecera e0_ INNER JOIN sucursal s1_ ON (s1_.nombre = e0_.sucursal) WHERE e0_.updated_at > ? GROUP BY e0_.sucursal ORDER BY e0_.updated_at ASC"
  "params" => [
    1 => null
    2 => null
    3 => "2025-08-26 14:56:54"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[
  "key" => "_security_main"
]

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

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

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

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

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

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

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

[
  "sql" => """
    SELECT DISTINCT            k.CONSTRAINT_NAME,\n
                k.COLUMN_NAME,\n
                k.REFERENCED_TABLE_NAME,\n
                k.REFERENCED_COLUMN_NAME,\n
                k.ORDINAL_POSITION /*!50116,\n
                c.UPDATE_RULE,\n
                c.DELETE_RULE */\n
    FROM information_schema.key_column_usage k /*!50116\n
    INNER JOIN information_schema.referential_constraints c\n
    ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME\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 = 'bitcubo_callcenter' */ ORDER BY k.ORDINAL_POSITION
    """
  "params" => [
    1 => "bitcubo_callcenter"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    SELECT       c.COLUMN_NAME        AS field,\n
               IF(\n
            c.COLUMN_TYPE = 'longtext'\n
            AND EXISTS(\n
                SELECT * from information_schema.CHECK_CONSTRAINTS i_c\n
                WHERE i_c.CONSTRAINT_SCHEMA = 'bitcubo_callcenter'\n
                AND i_c.TABLE_NAME = c.TABLE_NAME\n
                AND i_c.CHECK_CLAUSE = CONCAT(\n
                    'json_valid(`',\n
                        c.COLUMN_NAME,\n
                    '`)'\n
                )\n
            ),\n
            'json',\n
            c.COLUMN_TYPE\n
        )       AS type,\n
           c.IS_NULLABLE        AS `null`,\n
           c.COLUMN_KEY         AS `key`,\n
           c.COLUMN_DEFAULT     AS `default`,\n
           c.EXTRA,\n
           c.COLUMN_COMMENT     AS comment,\n
           c.CHARACTER_SET_NAME AS characterset,\n
           c.COLLATION_NAME     AS collation\n
    FROM information_schema.COLUMNS c\n
        INNER JOIN information_schema.TABLES t\n
            ON t.TABLE_NAME = c.TABLE_NAME\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 => "bitcubo_callcenter"
    2 => "bitcubo_callcenter"
    3 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

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

[
  "sql" => """
    SELECT        NON_UNIQUE  AS Non_Unique,\n
            INDEX_NAME  AS Key_name,\n
            COLUMN_NAME AS Column_Name,\n
            SUB_PART    AS Sub_Part,\n
            INDEX_TYPE  AS Index_Type\n
    FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
    """
  "params" => [
    1 => "bitcubo_callcenter"
    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\Security\Http\Firewall\ContextListener::onKernelResponse"
]

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

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::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.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::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\Component\HttpKernel\EventListener\SessionListener::onFinishRequest"
]

[
  "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"
]