Symfony Profiler

[
  "route" => "app_user_request_index"
  "route_parameters" => [
    "_route" => "app_user_request_index"
    "_controller" => "App\Controller\UserRequestController::index"
  ]
  "request_uri" => "http://78.56.202.79/request/"
  "method" => "GET"
]

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

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

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::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" => "Sentry\SentryBundle\EventListener\RequestListener::handleKernelRequestEvent"
]

[
  "event" => "kernel.request"
  "listener" => "Sentry\SentryBundle\EventListener\TracingRequestListener::handleKernelRequestEvent"
]

[
  "event" => "kernel.request"
  "listener" => "Sentry\SentryBundle\EventListener\SubRequestListener::handleKernelRequestEvent"
]

[
  "event" => "kernel.request"
  "listener" => "Sentry\SentryBundle\EventListener\TracingSubRequestListener::handleKernelRequestEvent"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Sentry\SentryBundle\EventListener\LoginListener::handleKernelRequestEvent"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\EmailVerificationChecker::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Sentry\SentryBundle\EventListener\RequestListener::handleKernelControllerEvent"
]

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

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

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

[
  "params" => [
    "driver" => "pdo_pgsql"
    "charset" => "utf8"
    "use_savepoints" => true
    "idle_connection_ttl" => 600
    "host" => "postgres"
    "port" => 5432
    "user" => "globusas"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "16"
    "defaultTableOptions" => []
    "dbname" => "globus"
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.unique_id AS unique_id_1, u0_.title AS title_2, u0_.description AS description_3, u0_.type AS type_4, u0_.category AS category_5, u0_.tags AS tags_6, u0_.budget AS budget_7, u0_.currency AS currency_8, u0_.priority AS priority_9, u0_.status AS status_10, u0_.location AS location_11, u0_.city AS city_12, u0_.country AS country_13, u0_.is_public AS is_public_14, u0_.allow_remote_work AS allow_remote_work_15, u0_.deadline AS deadline_16, u0_.created_at AS created_at_17, u0_.updated_at AS updated_at_18, u0_.attachments AS attachments_19, u0_.notes AS notes_20, u0_.ai_questions AS ai_questions_21, u0_.ai_answers AS ai_answers_22, u0_.suggested_categories AS suggested_categories_23, u0_.suggested_tags AS suggested_tags_24, u0_.view_count AS view_count_25, u0_.is_ai_processed AS is_ai_processed_26, u0_.company_code AS company_code_27, u0_.hide_company_code AS hide_company_code_28, u0_.valid_until AS valid_until_29, u0_.include_vat AS include_vat_30, u0_.allow_partial_bids AS allow_partial_bids_31, u0_.user_id AS user_id_32, u0_.company_id AS company_id_33 FROM user_request u0_ WHERE u0_.is_public = ? AND u0_.status IN (?, ?) ORDER BY u0_.created_at DESC LIMIT 20"
  "params" => [
    1 => 1
    2 => 1
    3 => 2
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(u0_.id) AS sclr_0 FROM user_request u0_ WHERE u0_.is_public = ? AND u0_.status IN (?, ?)"
  "params" => [
    1 => 1
    2 => 1
    3 => 2
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT u0_.category AS category_0, COUNT(u0_.id) AS sclr_1 FROM user_request u0_ WHERE u0_.is_public = ? AND u0_.status IN (?, ?) AND u0_.category IS NOT NULL GROUP BY u0_.category ORDER BY sclr_1 DESC LIMIT 10"
  "params" => [
    1 => 1
    2 => 1
    3 => 2
  ]
  "types" => [
    1 => 5
    2 => 1
    3 => 1
  ]
]

[
  "sql" => """
    \r\n
                    SELECT tag, COUNT(*) as tag_count\r\n
                    FROM (\r\n
                        SELECT DISTINCT json_array_elements_text(tags) as tag\r\n
                        FROM user_request \r\n
                        WHERE is_public = true \r\n
                        AND status IN (:pending, :in_progress)\r\n
                        AND tags IS NOT NULL\r\n
                    ) as tags_table\r\n
                    GROUP BY tag\r\n
                    ORDER BY tag_count DESC\r\n
                    LIMIT :limit\r\n
                
    """
  "params" => [
    "pending" => 1
    "in_progress" => 2
    "limit" => 20
  ]
  "types" => [
    "pending" => 2
    "in_progress" => 2
    "limit" => 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" => "kernel.response"
  "listener" => "Sentry\SentryBundle\EventListener\TracingRequestListener::handleKernelResponseEvent"
]

[
  "event" => "kernel.response"
  "listener" => "Sentry\SentryBundle\EventListener\TracingSubRequestListener::handleKernelResponseEvent"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::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\Mercure\EventSubscriber\SetCookieSubscriber::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" => "Sentry\SentryBundle\EventListener\TracingSubRequestListener::handleKernelFinishRequestEvent"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Sentry\SentryBundle\EventListener\SubRequestListener::handleKernelFinishRequestEvent"
]

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