Symfony Profiler

[
  "route" => "getEvents"
  "route_parameters" => [
    "_route" => "getEvents"
    "_controller" => "api_platform.symfony.main_controller"
    "_format" => null
    "_stateless" => true
    "_api_resource_class" => "App\Entity\Event"
    "_api_operation_name" => "getEvents"
  ]
  "request_uri" => "https://api.mmafriend.com/api/events?date%255Bstrictly_after%255D%3D2026-06-18%26itemsPerPage%3D1%26order%255Bdate%255D%253="
  "method" => "GET"
]

[
  "firewall_name" => "api"
  "authenticators" => 0
]

[
  "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\UX\Turbo\Request\RequestListener::__invoke"
]

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

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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.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\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" => "Container0WSk1aL\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "51.91.111.72"
    "port" => 3306
    "user" => "ufcuser"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "ufcapp"
    "serverVersion" => "8.0.32"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT count(DISTINCT e0_.id) AS sclr_0 FROM event e0_ LEFT JOIN fights f1_ ON e0_.id = f1_.event_id LEFT JOIN fighter f2_ ON f1_.fighter_red_id = f2_.id LEFT JOIN fighter f3_ ON f1_.fighter_blue_id = f3_.id LEFT JOIN fighter f4_ ON f1_.winner_id = f4_.id"
]

[
  "sql" => "SELECT DISTINCT e0_.id AS id_0, e0_.id AS id_1 FROM event e0_ LEFT JOIN fights f1_ ON e0_.id = f1_.event_id LEFT JOIN fighter f2_ ON f1_.fighter_red_id = f2_.id LEFT JOIN fighter f3_ ON f1_.fighter_blue_id = f3_.id LEFT JOIN fighter f4_ ON f1_.winner_id = f4_.id ORDER BY e0_.id ASC LIMIT 30"
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.date AS date_2, e0_.date_string AS date_string_3, e0_.link_ufc_site AS link_ufc_site_4, e0_.location AS location_5, f1_.id AS id_6, f1_.decision AS decision_7, f1_.total_round AS total_round_8, f1_.odds_fighter_red AS odds_fighter_red_9, f1_.odds_fighter_blue AS odds_fighter_blue_10, f1_.odds_fighter_red_decimal AS odds_fighter_red_decimal_11, f1_.odds_fighter_blue_decimal AS odds_fighter_blue_decimal_12, f1_.is_main_card AS is_main_card_13, f2_.id AS id_14, f2_.name AS name_15, f2_.origin AS origin_16, f2_.wins AS wins_17, f2_.loses AS loses_18, f2_.category AS category_19, f2_.ufc_page_link AS ufc_page_link_20, f2_.nick_name AS nick_name_21, f2_.draws AS draws_22, f3_.id AS id_23, f3_.name AS name_24, f3_.origin AS origin_25, f3_.wins AS wins_26, f3_.loses AS loses_27, f3_.category AS category_28, f3_.ufc_page_link AS ufc_page_link_29, f3_.nick_name AS nick_name_30, f3_.draws AS draws_31, f4_.id AS id_32, f4_.name AS name_33, f4_.origin AS origin_34, f4_.wins AS wins_35, f4_.loses AS loses_36, f4_.category AS category_37, f4_.ufc_page_link AS ufc_page_link_38, f4_.nick_name AS nick_name_39, f4_.draws AS draws_40, f1_.fighter_red_id AS fighter_red_id_41, f1_.fighter_blue_id AS fighter_blue_id_42, f1_.event_id AS event_id_43, f1_.winner_id AS winner_id_44 FROM event e0_ LEFT JOIN fights f1_ ON e0_.id = f1_.event_id LEFT JOIN fighter f2_ ON f1_.fighter_red_id = f2_.id LEFT JOIN fighter f3_ ON f1_.fighter_blue_id = f3_.id LEFT JOIN fighter f4_ ON f1_.winner_id = f4_.id WHERE e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.id ASC"
  "params" => [
    1 => 71
    2 => 72
    3 => 73
    4 => 74
    5 => 75
    6 => 76
    7 => 77
    8 => 78
    9 => 79
    10 => 80
    11 => 81
    12 => 82
    13 => 83
    14 => 84
    15 => 85
    16 => 87
    17 => 88
    18 => 89
    19 => 90
    20 => 91
    21 => 92
    22 => 93
    23 => 94
    24 => 95
    25 => 96
    26 => 97
    27 => 98
    28 => 99
    29 => 100
    30 => 101
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
    24 => 1
    25 => 1
    26 => 1
    27 => 1
    28 => 1
    29 => 1
    30 => 1
  ]
]

[
  "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" => "Nelmio\CorsBundle\EventListener\CorsListener::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" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]