Symfony Profiler

[
  "route" => "app_proveedor"
  "route_parameters" => [
    "_route" => "app_proveedor"
    "_controller" => "App\Controller\HomeController::proveedor"
    "slug" => "hotel-mi-tierra"
  ]
  "request_uri" => "https://dreamvacationpr.com/proveedor/hotel-mi-tierra"
  "method" => "GET"
]

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

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

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

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

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

[
  "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" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::handleLegacyEaContext"
]

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "matantan"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "dvpr2022"
    "serverVersion" => "8.0.20"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.is_activo AS is_activo_3, t0.slug AS slug_4, t0.description AS description_5, t0.location AS location_6, t0.subcontent AS subcontent_7, t0.provider_type_id AS provider_type_id_8 FROM provider t0 WHERE t0.slug = ? AND t0.is_activo = ? LIMIT 1"
  "params" => [
    1 => "hotel-mi-tierra"
    2 => 1
  ]
  "types" => [
    1 => 2
    2 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.post_content AS post_content_3, t0.is_activo AS is_activo_4, t0.discount_name_id AS discount_name_id_5, t0.discount_type_id AS discount_type_id_6, t0.provider_id AS provider_id_7 FROM discount t0 WHERE t0.provider_id = ?"
  "params" => [
    1 => 94
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM discount_name t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 INNER JOIN discount_restriction ON t0.id = discount_restriction.restriction_id WHERE discount_restriction.discount_id = ?"
  "params" => [
    1 => 113
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM discount_type t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 INNER JOIN discount_restriction ON t0.id = discount_restriction.restriction_id WHERE discount_restriction.discount_id = ?"
  "params" => [
    1 => 114
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "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 => "dvpr2022"
  ]
  "types" => [
    1 => 2
  ]
]

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

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