Symfony Profiler

[
  "route" => "app.legacy.show"
  "route_parameters" => [
    "_route" => "app.legacy.show"
    "_controller" => "App\Controller\LegacyController::loadLegacyScript"
    "requestPath" => "show.php"
    "legacyScript" => "/usr/src/splits/src/Legacy/../../../splits-old/show.php"
    "_locale" => "ru"
  ]
  "request_uri" => "https://splits-dev.o-stuff.net/ru/show.php?racer=7966"
  "method" => "GET"
]

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

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

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

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

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

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

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

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\KernelResponseListener::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" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "172.17.0.1"
    "port" => 8026
    "user" => "splits"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "splits"
    "serverVersion" => "8.0.40"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => """
    SELECT * FROM `spl_racers`\n
                    WHERE `ID` = '7966'
    """
]

[
  "sql" => """
    UPDATE `spl_views` \n
                    SET `Views` = `Views` + 1 \n
                    WHERE `ID` = 7966 AND `Type` = 'M'
    """
]

[
  "sql" => """
    SELECT COUNT(DISTINCT(`RatingID`)) AS `cnt` \n
                 FROM `rating_points` AS `p`,`rating_chapters` AS `c` \n
                 WHERE `c`.`ID` = `p`.`RatChapID` AND `RacerID` = 7966
    """
]

[
  "sql" => """
    SELECT `C`.`Name` AS `CompName`, `C`.`ID` AS `CompID`, `C`.`TypeID` AS `TypeID`,\n
                        `C`.`Date`, `C`.`DisciplineID`, `G`.`GroupName`, `R`.`GroupID`, `G`.`Distance`,\n
                        `G`.`ControlCount`, `G`.`RacerCount`,\n
                        `T`.`Name` AS `ClubName`, `T`.`ID` AS `ClubID`, `Q`.`Name` AS `Qual`, `R`.`Position`, \n
                        `R`.`Result`, `R`.`Delay`, `R`.`ID` AS `RowID`,\n
                        CASE WHEN UNIX_TIMESTAMP(`C`.`Date`) > 1760475600 THEN 1 ELSE 0 END AS `new` \n
                    FROM `spl_comps` AS `C`\n
                    LEFT JOIN `spl_groups` AS `G` ON  `C`.`ID` = `G`.`CompID` \n
                    LEFT JOIN `spl_rows` AS `R` ON `G`.`ID` = `R`.`GroupID`\n
                    LEFT JOIN `spl_clubs` AS `T` ON `T`.`ID` = `R`.`ClubID`\n
                    LEFT JOIN `spl_qualifications` AS `Q` ON `Q`.`ID` = `R`.`QualificationID`\n
                    WHERE  `R`.`RacerID` = 7966 \n
                    ORDER BY `C`.`Date` DESC, `C`.`ID` DESC
    """
]

[
  "sql" => """
    SELECT * \n
                         FROM `spl_foto` \n
                         WHERE `serno` = 7966 AND `Type` = 'M' \n
                         ORDER BY `Date`
    """
]

[
  "sql" => """
    SELECT `fid`, `Uphoto`\n
                         FROM `spl_racers` \n
                         WHERE `ID` = 7966
    """
]

[
  "sql" => """
    SELECT * \n
                         FROM `spl_foto` \n
                         WHERE `serno` = 7966 AND `Type` = 'A' \n
                         ORDER BY `Date`
    """
]

[
  "sql" => "SELECT count(*) as cnt FROM `spl_comments` C WHERE C.`Serno`=7966 and `Type`='M' AND `invis`=0;"
]