Symfony Profiler

[
  "route" => "main_path"
  "route_parameters" => [
    "_route" => "main_path"
    "entity" => "Bitdefender"
    "_controller" => "App\Themes\Default\Controller\Main::main"
    "path" => "store"
  ]
  "request_uri" => "https://ccms.shady.ro/store/Bitdefender"
  "method" => "GET"
]

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

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

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.name_id = ? AND t0.category_id = ? LIMIT 1"
  "params" => [
    1 => "pref"
    2 => "settings"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.icon AS icon_4, t0.def_language AS def_language_5, t0.visible AS visible_6, t0.insert_date AS insert_date_7 FROM countries t0 WHERE t0.iso_code = ? LIMIT 1"
  "params" => [
    1 => "US"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "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\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "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" => "App\EventListener\FirstRequestListener::onKernelRequest"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.controller AS controller_4, t0.config AS config_5, t0.active AS active_6, t0.insert_date AS insert_date_7, t0.channel_id AS channel_id_8 FROM integrations t0 WHERE t0.controller = ? LIMIT 1"
  "params" => [
    1 => "App\Controller\Plugins\Integrations\Impact"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label_id AS label_id_2, t0.integration AS integration_3, t0.config AS config_4, t0.last_execution AS last_execution_5, t0.every_minutes AS every_minutes_6, t0.next_execution AS next_execution_7 FROM cron t0 WHERE t0.label_id = ? LIMIT 1"
  "params" => [
    1 => "impact_fetch_data"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.controller AS controller_4, t0.config AS config_5, t0.active AS active_6, t0.insert_date AS insert_date_7, t0.channel_id AS channel_id_8 FROM integrations t0 WHERE t0.controller = ? LIMIT 1"
  "params" => [
    1 => "App\Controller\Plugins\Integrations\Skimlinks"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label_id AS label_id_2, t0.integration AS integration_3, t0.config AS config_4, t0.last_execution AS last_execution_5, t0.every_minutes AS every_minutes_6, t0.next_execution AS next_execution_7 FROM cron t0 WHERE t0.label_id = ? LIMIT 1"
  "params" => [
    1 => "impact_fetch_data"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.controller AS controller_4, t0.config AS config_5, t0.active AS active_6, t0.insert_date AS insert_date_7, t0.channel_id AS channel_id_8 FROM integrations t0 WHERE t0.controller = ? LIMIT 1"
  "params" => [
    1 => "App\Controller\Plugins\Integrations\CJ"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label_id AS label_id_2, t0.integration AS integration_3, t0.config AS config_4, t0.last_execution AS last_execution_5, t0.every_minutes AS every_minutes_6, t0.next_execution AS next_execution_7 FROM cron t0 WHERE t0.label_id = ? LIMIT 1"
  "params" => [
    1 => "cj_fetch_data"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.controller AS controller_4, t0.config AS config_5, t0.active AS active_6, t0.insert_date AS insert_date_7, t0.channel_id AS channel_id_8 FROM integrations t0 WHERE t0.controller = ? LIMIT 1"
  "params" => [
    1 => "App\Controller\Plugins\Integrations\Awin"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label_id AS label_id_2, t0.integration AS integration_3, t0.config AS config_4, t0.last_execution AS last_execution_5, t0.every_minutes AS every_minutes_6, t0.next_execution AS next_execution_7 FROM cron t0 WHERE t0.label_id = ? LIMIT 1"
  "params" => [
    1 => "awin_fetch_data"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.icon AS icon_4, t0.parent AS parent_5, t0.menu_position AS menu_position_6, t0.popup_open AS popup_open_7, t0.mandatory AS mandatory_8, t0.menu_default AS menu_default_9 FROM modules t0 WHERE t0.route = ? LIMIT 1"
  "params" => [
    1 => "main_path"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "kernel.controller"
  "listener" => "App\EventListener\MainListener::onKernelController"
]

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.category_id = ?"
  "params" => [
    1 => "paths"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.category_id = ?"
  "params" => [
    1 => "seo"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "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" => "ContainerKrZqq0I\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.logo AS logo_2, s0_.url AS url_3, s0_.cashback AS cashback_4, s0_.featured AS featured_5, s0_.offline AS offline_6, s0_.status AS status_7, s0_.channel AS channel_8, s0_.ext_mapping AS ext_mapping_9, s0_.insert_date AS insert_date_10, COUNT(c1_.id) AS sclr_11, (CASE WHEN f2_.id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_12 FROM stores s0_ INNER JOIN countries_lnk c3_ ON (c3_.entity_type = 1 AND c3_.entity_id = s0_.id AND c3_.country = ?) LEFT JOIN coupons c1_ ON (c1_.store_id = s0_.id) LEFT JOIN favorites_lnk f2_ ON (f2_.store_id = s0_.id AND f2_.user_id = ?) WHERE s0_.status = ? AND s0_.name LIKE ? GROUP BY s0_.id LIMIT 50"
  "params" => [
    1 => "1"
    2 => 0
    3 => 1
    4 => "%Bitdefender%"
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
    4 => 2
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM stores s0_ LEFT JOIN favorites_lnk f1_ ON (f1_.store_id = s0_.id AND f1_.user_id = ?) INNER JOIN countries_lnk c2_ ON (c2_.entity_type = 1 AND c2_.entity_id = s0_.id AND c2_.country = ?) WHERE s0_.status = ? AND s0_.name LIKE ?"
  "params" => [
    1 => 0
    2 => "1"
    3 => 1
    4 => "%Bitdefender%"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
    4 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.category AS category_4, t0.insert_date AS insert_date_5 FROM categories_lnk t0 WHERE t0.entity_type = ? AND t0.entity_id = ?"
  "params" => [
    1 => 1
    2 => 48
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.name_id = ? AND t0.category_id = ? LIMIT 1"
  "params" => [
    1 => "extension"
    2 => "browsers"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.name_id = ? AND t0.category_id = ? LIMIT 1"
  "params" => [
    1 => "home_title"
    2 => "content"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.name_id = ? AND t0.category_id = ? LIMIT 1"
  "params" => [
    1 => "home_description"
    2 => "content"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.value_text AS value_text_4, t0.ord AS ord_5, t0.u_value AS u_value_6, t0.insert_date AS insert_date_7, t0.store_id AS store_id_8 FROM store_meta t0 WHERE t0.store_id = ? AND t0.name = ? LIMIT 1"
  "params" => [
    1 => 48
    2 => "description"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.user_id AS user_id_2, c0_.status AS status_3, c0_.code AS code_4, c0_.type AS type_5, c0_.discount_value AS discount_value_6, c0_.currency AS currency_7, c0_.start_date AS start_date_8, c0_.end_date AS end_date_9, c0_.exclusive AS exclusive_10, c0_.featured AS featured_11, c0_.verified AS verified_12, c0_.usage_limit AS usage_limit_13, c0_.usage_count AS usage_count_14, c0_.clicks AS clicks_15, c0_.conversions AS conversions_16, c0_.priority_score AS priority_score_17, c0_.notes AS notes_18, c0_.user_submit AS user_submit_19, c0_.insert_date AS insert_date_20, s1_.id AS id_21, s1_.name AS name_22, s1_.logo AS logo_23, s1_.url AS url_24, s1_.cashback AS cashback_25, s1_.featured AS featured_26, s1_.offline AS offline_27, s1_.status AS status_28, s1_.channel AS channel_29, s1_.ext_mapping AS ext_mapping_30, s1_.insert_date AS insert_date_31, c0_.store_id AS store_id_32 FROM coupons c0_ INNER JOIN stores s1_ ON c0_.store_id = s1_.id INNER JOIN countries_lnk c2_ ON (c2_.entity_type = ? AND c2_.entity_id = s1_.id AND c2_.country = ?) WHERE c0_.status = ? AND c0_.store_id = ? ORDER BY c0_.priority_score DESC LIMIT 10"
  "params" => [
    1 => 1
    2 => "1"
    3 => 1
    4 => 48
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
    4 => 1
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM coupons c0_ INNER JOIN stores s1_ ON c0_.store_id = s1_.id INNER JOIN countries_lnk c2_ ON (c2_.entity_type = ? AND c2_.entity_id = s1_.id AND c2_.country = ?) WHERE c0_.status = ? AND c0_.store_id = ?"
  "params" => [
    1 => 1
    2 => "1"
    3 => 1
    4 => 48
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
    4 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.logo AS logo_2, s0_.url AS url_3, s0_.cashback AS cashback_4, s0_.featured AS featured_5, s0_.offline AS offline_6, s0_.status AS status_7, s0_.channel AS channel_8, s0_.ext_mapping AS ext_mapping_9, s0_.insert_date AS insert_date_10, COUNT(c1_.id) AS sclr_11, (CASE WHEN f2_.id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_12 FROM stores s0_ INNER JOIN countries_lnk c3_ ON (c3_.entity_type = 1 AND c3_.entity_id = s0_.id AND c3_.country = ?) LEFT JOIN coupons c1_ ON (c1_.store_id = s0_.id) LEFT JOIN favorites_lnk f2_ ON (f2_.store_id = s0_.id AND f2_.user_id = ?) WHERE s0_.status = ? GROUP BY s0_.id LIMIT 10"
  "params" => [
    1 => "1"
    2 => 0
    3 => 1
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM stores s0_ LEFT JOIN favorites_lnk f1_ ON (f1_.store_id = s0_.id AND f1_.user_id = ?) INNER JOIN countries_lnk c2_ ON (c2_.entity_type = 1 AND c2_.entity_id = s0_.id AND c2_.country = ?) WHERE s0_.status = ?"
  "params" => [
    1 => 0
    2 => "1"
    3 => 1
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.logo AS logo_2, s0_.url AS url_3, s0_.cashback AS cashback_4, s0_.featured AS featured_5, s0_.offline AS offline_6, s0_.status AS status_7, s0_.channel AS channel_8, s0_.ext_mapping AS ext_mapping_9, s0_.insert_date AS insert_date_10, COUNT(c1_.id) AS sclr_11, (CASE WHEN f2_.id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_12 FROM stores s0_ INNER JOIN countries_lnk c3_ ON (c3_.entity_type = 1 AND c3_.entity_id = s0_.id AND c3_.country = ?) LEFT JOIN coupons c1_ ON (c1_.store_id = s0_.id) LEFT JOIN favorites_lnk f2_ ON (f2_.store_id = s0_.id AND f2_.user_id = ?) WHERE s0_.status = ? AND s0_.featured = ? GROUP BY s0_.id LIMIT 10"
  "params" => [
    1 => "1"
    2 => 0
    3 => 1
    4 => 1
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
    4 => 1
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM stores s0_ LEFT JOIN favorites_lnk f1_ ON (f1_.store_id = s0_.id AND f1_.user_id = ?) INNER JOIN countries_lnk c2_ ON (c2_.entity_type = 1 AND c2_.entity_id = s0_.id AND c2_.country = ?) WHERE s0_.status = ? AND s0_.featured = ?"
  "params" => [
    1 => 0
    2 => "1"
    3 => 1
    4 => 1
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
    4 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.icon AS icon_4, t0.def_language AS def_language_5, t0.visible AS visible_6, t0.insert_date AS insert_date_7 FROM countries t0 WHERE t0.id = ?"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 1
  ]
]

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