Symfony Profiler

[
  "route" => "not_found"
  "route_parameters" => [
    "_route" => "not_found"
    "_controller" => "App\Controller\ErrorController::notFound"
    "any" => "_profiler/60dc78/search/null"
  ]
  "request_uri" => "https://admin-upgrade.mountainbike-parts.ch/_profiler/60dc78/search/null"
  "method" => "GET"
]

[
  "params" => [
    "charset" => "utf8mb4"
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "mtb_upgrade"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collate" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "admin_mtb_upgrade"
    "serverVersion" => "8"
  ]
]

[
  "sql" => "SELECT o0_.time_line AS time_line_0 FROM order_timelines o0_ WHERE o0_.name = ? LIMIT 1"
  "params" => [
    1 => "customer order submit time"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#74
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT o0_.time_line AS time_line_0 FROM order_timelines o0_ WHERE o0_.name = ? LIMIT 1"
  "params" => [
    1 => "SameDay order submit timeline"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#74
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT o0_.time_line AS time_line_0 FROM order_timelines o0_ WHERE o0_.name = ? LIMIT 1"
  "params" => [
    1 => "supplier order submit time"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#74
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.is_b2c AS is_b2c_7, t0.is_b2b AS is_b2b_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0.is_default = ? AND t0.status = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1054
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1054}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.holiday_type AS holiday_type_1, DATE(c0_.start_date) AS sclr_2, DATE(c0_.end_date) AS sclr_3 FROM company_calendar c0_ WHERE DATE(c0_.start_date) >= ? AND DATE(c0_.start_date) <= ? AND c0_.start_date IS NOT NULL"
  "params" => [
    1 => "2026-07-31"
    2 => "2026-09-29"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#74
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#74}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.shipping_key AS shipping_key_2, t0.shipping_value AS shipping_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shipping_method_id AS shipping_method_id_6 FROM shipping_method_settings t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.is_b2c AS is_b2c_7, t0.is_b2b AS is_b2b_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0.is_default = ? AND t0.status = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1054
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1054}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.holiday_type AS holiday_type_1, DATE(c0_.start_date) AS sclr_2, DATE(c0_.end_date) AS sclr_3 FROM company_calendar c0_ WHERE DATE(c0_.start_date) >= ? AND DATE(c0_.start_date) <= ? AND c0_.start_date IS NOT NULL"
  "params" => [
    1 => "2026-07-31"
    2 => "2026-09-29"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#74
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#74}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.is_b2c AS is_b2c_7, t0.is_b2b AS is_b2b_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0.is_default = ? AND t0.status = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1054
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1054}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort AS sort_5, t0.image AS image_6, t0.is_default AS is_default_7, t0.barcode_username AS barcode_username_8, t0.barcode_password AS barcode_password_9, t0.barcode_franking_license AS barcode_franking_license_10, t0.sd_barcode_username AS sd_barcode_username_11, t0.sd_barcode_password AS sd_barcode_password_12, t0.sd_barcode_franking_license AS sd_barcode_franking_license_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM courier t0 WHERE t0.is_default = ? AND t0.status = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1054
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1054}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.is_b2c AS is_b2c_7, t0.is_b2b AS is_b2b_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0.alias = ? AND t0.status = ? AND t0.is_b2c = ? LIMIT 1"
  "params" => [
    1 => "nt-sd-ev"
    2 => "1"
    3 => "1"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#74
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1054
      +name: "BOOLEAN"
    }
    3 => Doctrine\DBAL\ParameterType {#1054}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.status AS status_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.is_b2c AS is_b2c_7, t0.is_b2b AS is_b2b_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0.alias = ? AND t0.status = ? AND t0.is_b2b = ? LIMIT 1"
  "params" => [
    1 => "nt-sd-ev"
    2 => "1"
    3 => "1"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#74
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1054
      +name: "BOOLEAN"
    }
    3 => Doctrine\DBAL\ParameterType {#1054}
  ]
]

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

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

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

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "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" => "App\EventSubscriber\AdminPreviewHostSubscriber::onKernelRequest"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.ip AS ip_2 FROM customer_ban_ip t0 WHERE t0.ip = ?"
  "params" => [
    1 => "57.141.0.45"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#74
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT s0_.current_timezone AS current_timezone_0 FROM settings s0_ LIMIT 1"
]

[
  "event" => "kernel.controller"
  "listener" => "App\EventListener\AdminForceLogoutListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "App\EventListener\User\BeforeControllerListener::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\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerMEUV2Y2\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

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

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\Admin\ResponseListener::onKernelResponse"
]

[
  "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\WebLink\EventListener\AddLinkHeaderListener::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\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\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

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

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