Symfony Profiler

[
  "route" => "app_publisher_faq"
  "route_parameters" => [
    "_route" => "app_publisher_faq"
    "_controller" => "App\Controller\Frontend\PublisherController::faq"
  ]
  "request_uri" => "https://devel-uhrin.friendlybunny.com/publishers/faq"
  "method" => "GET"
]

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

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

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

[
  "firewall_name" => "main"
  "authenticator" => "Scheb\TwoFactorBundle\Security\Http\Authenticator\TwoFactorAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Scheb\TwoFactorBundle\Security\Http\Authenticator\TwoFactorAuthenticator"
]

[
  "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" => "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" => "Scheb\TwoFactorBundle\Security\TwoFactor\Event\TwoFactorFormListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\RequestTrackingSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "App\EventSubscriber\CronSubscriber::startCount"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sonata\AdminBundle\EventListener\ConfigureCRUDControllerListener::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" => "ContainerWl9m9e4\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "mariadb105.r1.websupport.sk"
    "port" => 3315
    "user" => "pupu_7001"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "pupu_7001"
    "unix_socket" => "/tmp/mariadb105.sock"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.fixed_internal_fee AS fixed_internal_fee_3, p0_.percentage_internal_fee AS percentage_internal_fee_4, p0_.external_fee AS external_fee_5, p0_.payout_minimum AS payout_minimum_6, p0_.net AS net_7, p0_.active AS active_8, p0_.public AS public_9, p0_.icon AS icon_10, p0_.slug AS slug_11, p0_.transfer_duration AS transfer_duration_12, p0_.rank AS rank_13, FIELD(p0_.id, 4, 3, 7, 8, 2, 11, 1, 5) AS sclr_14, p0_.payment_service_id AS payment_service_id_15 FROM payment_method p0_ WHERE p0_.active = ? AND p0_.public = ? ORDER BY sclr_14 DESC"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => 5
    2 => 5
  ]
]

[
  "sql" => "SELECT min(p0_.payout_minimum) AS sclr_0 FROM payment_method p0_ WHERE p0_.active = 1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.fixed_fee AS fixed_fee_3, t0.percentage_fee AS percentage_fee_4 FROM payout_period t0"
]

[
  "sql" => """
    \r\n
    \t\tWITH RECURSIVE cte AS (\r\n
                SELECT niche.id, niche.parent_id, niche.id as totalParent\r\n
                FROM niche \r\n
                 WHERE niche.active = 1 \r\n
                UNION ALL\r\n
                SELECT pc.id, pc.parent_id, cte.totalParent\r\n
                FROM niche AS pc, cte\r\n
                WHERE pc.parent_id = cte.id  AND pc.active = 1 AND (pc.available_from_date <= :date OR pc.available_from_date IS NULL) AND (pc.available_to_date >= :date OR pc.available_to_date IS NULL) \r\n
            )\r\n
            SELECT \r\n
                cte.totalParent as id, count(DISTINCT landing.id) as totalActiveLandings, count(DISTINCT lp.id) as activeLandings \r\n
            FROM cte\r\n
            LEFT JOIN rel_landing_niche lnp ON lnp.niche_id = cte.totalParent\r\n
            LEFT JOIN landing lp ON lp.id = lnp.landing_id and lp.active = 1\r\n
            LEFT JOIN rel_landing_niche ON cte.id = rel_landing_niche.niche_id \r\n
            LEFT JOIN landing ON landing.id = rel_landing_niche.landing_id and landing.active = 1\r\n
            GROUP BY cte.totalParent\r\n
             HAVING totalActiveLandings > 0 OR activeLandings > 0 \r\n
            ORDER BY NULL
    """
  "params" => [
    ":date" => "2026-09-27"
  ]
  "types" => [
    ":date" => 2
  ]
]

[
  "sql" => "SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.icon AS icon_2, n0_.active AS active_3, n0_.default_keyword AS default_keyword_4, n0_.available_from_date AS available_from_date_5, n0_.available_to_date AS available_to_date_6, n0_.id AS id_7, n0_.name AS name_8, n0_.icon AS icon_9, n0_.active AS active_10, n0_.default_keyword AS default_keyword_11, n0_.available_from_date AS available_from_date_12, n0_.available_to_date AS available_to_date_13, l1_.prelanding AS prelanding_14, l1_.required_link_parameters AS required_link_parameters_15, l1_.name AS name_16, l1_.id AS id_17, l1_.active AS active_18, l1_.deactivated_by AS deactivated_by_19, l1_.created_at AS created_at_20, l1_.updated_at AS updated_at_21, l1_.note AS note_22, l1_.preview AS preview_23, l1_.admin_cap_lifetime_budget_limit AS admin_cap_lifetime_budget_limit_24, l1_.admin_cap_lifetime_budget_status AS admin_cap_lifetime_budget_status_25, l1_.admin_cap_lifetime_lead_limit AS admin_cap_lifetime_lead_limit_26, l1_.admin_cap_lifetime_lead_status AS admin_cap_lifetime_lead_status_27, l1_.cap_lifetime_budget_limit AS cap_lifetime_budget_limit_28, l1_.cap_lifetime_budget_status AS cap_lifetime_budget_status_29, l1_.cap_lifetime_lead_limit AS cap_lifetime_lead_limit_30, l1_.cap_lifetime_lead_status AS cap_lifetime_lead_status_31, l1_.cap_monthly_budget_limit AS cap_monthly_budget_limit_32, l1_.cap_monthly_budget_status AS cap_monthly_budget_status_33, l1_.cap_monthly_lead_limit AS cap_monthly_lead_limit_34, l1_.cap_monthly_lead_status AS cap_monthly_lead_status_35, l1_.cap_weekly_budget_limit AS cap_weekly_budget_limit_36, l1_.cap_weekly_budget_status AS cap_weekly_budget_status_37, l1_.cap_weekly_lead_limit AS cap_weekly_lead_limit_38, l1_.cap_weekly_lead_status AS cap_weekly_lead_status_39, l1_.cap_daily_budget_limit AS cap_daily_budget_limit_40, l1_.cap_daily_budget_status AS cap_daily_budget_status_41, l1_.cap_daily_lead_limit AS cap_daily_lead_limit_42, l1_.cap_daily_lead_status AS cap_daily_lead_status_43, n0_.parent_id AS parent_id_44, l1_.advertiser_id AS advertiser_id_45, l1_.product_id AS product_id_46 FROM niche n0_ LEFT JOIN rel_landing_niche r2_ ON n0_.id = r2_.niche_id LEFT JOIN landing l1_ ON l1_.id = r2_.landing_id AND (l1_.active = 1) WHERE n0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1
    2 => 2
    3 => 4
    4 => 5
    5 => 6
    6 => 7
    7 => 8
    8 => 9
    9 => 10
    10 => 11
    11 => 13
    12 => 14
    13 => 15
    14 => 17
    15 => 18
    16 => 19
    17 => 20
    18 => 22
    19 => 26
    20 => 27
    21 => 31
    22 => 32
    23 => 33
    24 => 34
    25 => 35
    26 => 37
    27 => 39
    28 => 41
    29 => 42
    30 => 43
    31 => 47
    32 => 48
    33 => 49
    34 => 50
    35 => 56
    36 => 57
    37 => 58
    38 => 59
  ]
  "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
    31 => 1
    32 => 1
    33 => 1
    34 => 1
    35 => 1
    36 => 1
    37 => 1
    38 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\PreLoadAssetsEventListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Scheb\TwoFactorBundle\Security\TwoFactor\Provider\TwoFactorProviderPreparationListener::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\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\ContentSecurityPolicyListener::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"
]