Symfony Profiler

[
  "route" => "photo_gallery"
  "route_parameters" => [
    "_route" => "photo_gallery"
    "categorySlug" => ""
    "page" => 1
    "_controller" => "App\Controller\Photo\GalleryController::index"
  ]
  "request_uri" => "https://beta22.photopost.cz/fotografie?aut=1757"
  "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\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" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\OnlineTrackingSubscriber::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" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SortableSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\FiltrationSubscriber::before"
]

[
  "event" => "knp_pager.before"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::before"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => null
    "user" => "photopostng"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "photopostng"
    "serverVersion" => "11.4.8-MariaDB"
    "charset" => "utf8mb4"
    "unix_socket" => "/var/run/mysql/mysql.sock"
  ]
]

[
  "sql" => "SELECT count(DISTINCT f0_.foto_id) AS sclr_0 FROM foto f0_ LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id WHERE f0_.foto_kos = 0 AND f0_.foto_autor = ?"
  "params" => [
    1 => 1757
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#903
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT DISTINCT f0_.foto_id AS foto_id_0, f0_.foto_datum AS foto_datum_1, f0_.foto_id AS foto_id_2 FROM foto f0_ LEFT JOIN autor a1_ ON f0_.foto_autor = a1_.autor_id WHERE f0_.foto_kos = 0 AND f0_.foto_autor = ? ORDER BY f0_.foto_datum DESC, f0_.foto_id DESC LIMIT 30"
  "params" => [
    1 => 1757
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#903
      +name: "INTEGER"
    }
  ]
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\DBALQueryBuilderSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Sortable\ArraySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Filtration\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Callback\CallbackSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\MongoDB\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ODM\PHPCR\QuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\CollectionSubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PropelQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\SolariumQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ElasticaQuerySubscriber::items"
]

[
  "event" => "knp_pager.items"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\ArraySubscriber::items"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::pagination"
]

[
  "event" => "knp_pager.pagination"
  "listener" => "Knp\Component\Pager\Event\Subscriber\Paginate\PaginationSubscriber::pagination"
]

[
  "sql" => "SELECT t0.kategorie_id AS kategorie_id_1, t0.kategorie_nazev AS kategorie_nazev_2, t0.url AS url_3, t0.title AS title_4, t0.metadescription AS metadescription_5, t0.h1 AS h1_6, t0.description AS description_7 FROM kategorie t0 ORDER BY t0.kategorie_nazev ASC"
]

[
  "sql" => """
    SELECT h.hodnoceni_foto_id AS photoId, SUM(h.hodnoceni_body) AS recentPoints\n
                 FROM hodnoceni h\n
                 WHERE h.hodnoceni_datum > ?\n
                   AND h.hodnoceni_body IS NOT NULL\n
                   AND h.hodnoceni_body > 0\n
                 GROUP BY h.hodnoceni_foto_id\n
                 ORDER BY recentPoints DESC\n
                 LIMIT 10
    """
  "params" => [
    1 => "2026-05-11 05:59:08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#937
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT h.hodnoceni_foto_id AS photoId, SUM(h.hodnoceni_body) AS recentPoints\n
                 FROM hodnoceni h\n
                 WHERE h.hodnoceni_datum > ?\n
                   AND h.hodnoceni_body IS NOT NULL\n
                   AND h.hodnoceni_body > 0\n
                 GROUP BY h.hodnoceni_foto_id\n
                 ORDER BY recentPoints DESC\n
                 LIMIT 10
    """
  "params" => [
    1 => "2026-05-08 05:59:08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#937
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT hodnoceni_autor AS userId, SUM(hodnoceni_body) AS totalGiven\n
                 FROM hodnoceni\n
                 WHERE hodnoceni_datum > ?\n
                   AND hodnoceni_body IS NOT NULL\n
                   AND hodnoceni_body > 0\n
                 GROUP BY hodnoceni_autor\n
                 ORDER BY totalGiven DESC\n
                 LIMIT 10
    """
  "params" => [
    1 => "2026-05-11 05:59:08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#937
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT hodnoceni_autor AS userId, SUM(hodnoceni_body) AS totalGiven\n
                 FROM hodnoceni\n
                 WHERE hodnoceni_datum > ?\n
                   AND hodnoceni_body IS NOT NULL\n
                   AND hodnoceni_body > 0\n
                 GROUP BY hodnoceni_autor\n
                 ORDER BY totalGiven DESC\n
                 LIMIT 10
    """
  "params" => [
    1 => "2026-05-08 05:59:08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#937
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT hodnoceni_autor AS userId, COUNT(*) AS ratingCount\n
                 FROM hodnoceni\n
                 WHERE hodnoceni_datum > ?\n
                   AND hodnoceni_body IS NOT NULL\n
                   AND hodnoceni_body > 0\n
                 GROUP BY hodnoceni_autor\n
                 ORDER BY ratingCount DESC\n
                 LIMIT 5
    """
  "params" => [
    1 => "2026-05-11 05:59:08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#937
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT hodnoceni_autor AS userId, COUNT(*) AS ratingCount\n
                 FROM hodnoceni\n
                 WHERE hodnoceni_datum > ?\n
                   AND hodnoceni_body IS NOT NULL\n
                   AND hodnoceni_body > 0\n
                 GROUP BY hodnoceni_autor\n
                 ORDER BY ratingCount DESC\n
                 LIMIT 5
    """
  "params" => [
    1 => "2026-05-08 05:59:08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#937
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT h.hodnoceni_foto_id AS photoId, SUM(h.hodnoceni_body) AS recentPoints\n
                 FROM hodnoceni h\n
                 WHERE h.hodnoceni_datum > ?\n
                   AND h.hodnoceni_body IS NOT NULL\n
                   AND h.hodnoceni_body > 0\n
                 GROUP BY h.hodnoceni_foto_id\n
                 ORDER BY recentPoints DESC\n
                 LIMIT 5
    """
  "params" => [
    1 => "2026-05-11 05:59:08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#937
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT h.hodnoceni_foto_id AS photoId, SUM(h.hodnoceni_body) AS recentPoints\n
                 FROM hodnoceni h\n
                 WHERE h.hodnoceni_datum > ?\n
                   AND h.hodnoceni_body IS NOT NULL\n
                   AND h.hodnoceni_body > 0\n
                 GROUP BY h.hodnoceni_foto_id\n
                 ORDER BY recentPoints DESC\n
                 LIMIT 5
    """
  "params" => [
    1 => "2026-05-08 05:59:08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#937
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT f0_.fotoesej_tema_id AS fotoesej_tema_id_0, f0_.fotoesej_tema_nazev AS fotoesej_tema_nazev_1, f0_.fotoesej_tema_text AS fotoesej_tema_text_2, f0_.fotoesej_tema_datum AS fotoesej_tema_datum_3, f0_.fotoesej_tema_termin AS fotoesej_tema_termin_4, f0_.fotoesej_tema_fotek AS fotoesej_tema_fotek_5, f0_.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_6, f0_.fotoesej_tema_autorid AS fotoesej_tema_autorid_7 FROM fotoesej_tema f0_ WHERE f0_.fotoesej_tema_termin <= ? AND f0_.fotoesej_tema_termin > ? ORDER BY f0_.fotoesej_tema_termin DESC LIMIT 1"
  "params" => [
    1 => "2026-05-12 05:59:08"
    2 => "2026-05-02 05:59:08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#937
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#937}
  ]
]

[
  "sql" => "SELECT f0_.fotoesej_tema_id AS fotoesej_tema_id_0, f0_.fotoesej_tema_nazev AS fotoesej_tema_nazev_1, f0_.fotoesej_tema_text AS fotoesej_tema_text_2, f0_.fotoesej_tema_datum AS fotoesej_tema_datum_3, f0_.fotoesej_tema_termin AS fotoesej_tema_termin_4, f0_.fotoesej_tema_fotek AS fotoesej_tema_fotek_5, f0_.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_6, f0_.fotoesej_tema_autorid AS fotoesej_tema_autorid_7 FROM fotoesej_tema f0_ WHERE f0_.fotoesej_tema_termin > ? ORDER BY f0_.fotoesej_tema_termin ASC LIMIT 1"
  "params" => [
    1 => "2026-05-12 05:59:08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#937
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT f0_.fotoesej_tema_id AS fotoesej_tema_id_0, f0_.fotoesej_tema_nazev AS fotoesej_tema_nazev_1, f0_.fotoesej_tema_text AS fotoesej_tema_text_2, f0_.fotoesej_tema_datum AS fotoesej_tema_datum_3, f0_.fotoesej_tema_termin AS fotoesej_tema_termin_4, f0_.fotoesej_tema_fotek AS fotoesej_tema_fotek_5, f0_.fotoesej_tema_hlasu AS fotoesej_tema_hlasu_6, f0_.fotoesej_tema_autorid AS fotoesej_tema_autorid_7 FROM fotoesej_tema f0_ WHERE f0_.fotoesej_tema_termin <= ? AND f0_.fotoesej_tema_fotek > 0 ORDER BY f0_.fotoesej_tema_termin DESC LIMIT 1"
  "params" => [
    1 => "2026-05-02 05:59:08"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#937
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT h.hodnoceni_id AS rating_id, h.hodnoceni_datum AS rating_date, h.hodnoceni_text AS rating_text,\n
                        f.foto_id AS photo_id, f.foto_titulek AS photo_title, f.foto_soubor AS photo_path,\n
                        rater.autor_id AS rater_id, rater.autor_jmeno AS rater_first, rater.autor_prijmeni AS rater_last\n
                 FROM hodnoceni h\n
                 JOIN foto f ON f.foto_id = h.hodnoceni_foto_id\n
                 JOIN autor rater ON rater.autor_id = h.hodnoceni_autor\n
                 WHERE f.foto_kos = 0 AND f.foto_autor != 3\n
                   AND h.hodnoceni_text IS NOT NULL\n
                   AND CHAR_LENGTH(REGEXP_REPLACE(h.hodnoceni_text, '[[:space:]]', '')) > 2\n
                 ORDER BY h.hodnoceni_id DESC\n
                 LIMIT 15
    """
]

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

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::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"
]