Symfony Profiler

[
  "route" => "app_frontend_index"
  "route_parameters" => [
    "_route" => "app_frontend_index"
    "_controller" => "App\Controller\Frontend\IndexController::index"
  ]
  "request_uri" => "http://tv-schweinheim.werbebanden-manager.de/"
  "method" => "GET"
]

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

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

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

[
  "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"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "db002258.mydbserver.com"
    "port" => 3306
    "user" => "p676854"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "usr_p676854_1"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.name AS name_2, c0_.subtitle AS subtitle_3, c0_.created_at AS created_at_4, c0_.person_id AS person_id_5, c0_.address_id AS address_id_6, c0_.user_id AS user_id_7, c0_.contact_id AS contact_id_8, c0_.configuration_id AS configuration_id_9, c0_.partner_id AS partner_id_10, c0_.logo_id AS logo_id_11, c0_.tax_information_id AS tax_information_id_12, c0_.invoice_settings_id AS invoice_settings_id_13, c0_.contract_settings_id AS contract_settings_id_14, c0_.content_how_to_id AS content_how_to_id_15, c0_.content_about_us_id AS content_about_us_id_16, c0_.template_id AS template_id_17, c0_.faq_id AS faq_id_18, c0_.notification_id AS notification_id_19 FROM customer c0_ LEFT JOIN customer_configuration c1_ ON c0_.configuration_id = c1_.id WHERE c1_.host LIKE ? AND c1_.contract_start <= ? AND c1_.contract_end >= ? AND c1_.active = 1"
  "params" => [
    1 => "%tv-schweinheim.werbebanden-manager.de%"
    2 => "2024-11-05"
    3 => "2024-11-05"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.host AS host_2, t0.test AS test_3, t0.active AS active_4, t0.contribution_allow AS contribution_allow_5, t0.contribution_active AS contribution_active_6, t0.contribution_price AS contribution_price_7, t0.contract_start AS contract_start_8, t0.contract_end AS contract_end_9, t0.homedir AS homedir_10, t0.basic_price AS basic_price_11, t0.area_basic_price AS area_basic_price_12 FROM customer_configuration t0 WHERE t0.id IN (?)"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.token AS token_2, t0.free_field AS free_field_3, t0.next_value AS next_value_4, t0.min_length AS min_length_5, t0.tax_rate AS tax_rate_6, t0.invoice_due AS invoice_due_7, t0.automatic_send AS automatic_send_8, t0.payment_term_in_days AS payment_term_in_days_9 FROM customer_invoice_settings t0 WHERE t0.id IN (?)"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.active AS active_2, t0.how_to_text1 AS how_to_text1_3, t0.how_to_text2 AS how_to_text2_4, t0.how_to_text3 AS how_to_text3_5, t0.background_color AS background_color_6, t0.icon_color AS icon_color_7, t0.fk_icon_1 AS fk_icon_1_8, t0.fk_icon_2 AS fk_icon_2_9, t0.fk_icon_3 AS fk_icon_3_10, t0.background_image_id AS background_image_id_11 FROM customer_content_how_to t0 WHERE t0.id IN (?)"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.active AS active_2, t0.description AS description_3 FROM customer_content_about_us t0 WHERE t0.id IN (?)"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.active AS active_2, t0.text_color AS text_color_3, t0.background_color AS background_color_4 FROM customer_faq t0 WHERE t0.id IN (?)"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.name AS name_2, c0_.subtitle AS subtitle_3, c0_.created_at AS created_at_4, c0_.person_id AS person_id_5, c0_.address_id AS address_id_6, c0_.user_id AS user_id_7, c0_.contact_id AS contact_id_8, c0_.configuration_id AS configuration_id_9, c0_.partner_id AS partner_id_10, c0_.logo_id AS logo_id_11, c0_.tax_information_id AS tax_information_id_12, c0_.invoice_settings_id AS invoice_settings_id_13, c0_.contract_settings_id AS contract_settings_id_14, c0_.content_how_to_id AS content_how_to_id_15, c0_.content_about_us_id AS content_about_us_id_16, c0_.template_id AS template_id_17, c0_.faq_id AS faq_id_18, c0_.notification_id AS notification_id_19 FROM customer c0_ LEFT JOIN customer_configuration c1_ ON c0_.configuration_id = c1_.id WHERE c1_.host LIKE ? AND c1_.contract_start <= ? AND c1_.contract_end >= ? AND c1_.active = 1"
  "params" => [
    1 => "%tv-schweinheim.werbebanden-manager.de%"
    2 => "2024-11-05"
    3 => "2024-11-05"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.name AS name_2, c0_.subtitle AS subtitle_3, c0_.created_at AS created_at_4, c0_.person_id AS person_id_5, c0_.address_id AS address_id_6, c0_.user_id AS user_id_7, c0_.contact_id AS contact_id_8, c0_.configuration_id AS configuration_id_9, c0_.partner_id AS partner_id_10, c0_.logo_id AS logo_id_11, c0_.tax_information_id AS tax_information_id_12, c0_.invoice_settings_id AS invoice_settings_id_13, c0_.contract_settings_id AS contract_settings_id_14, c0_.content_how_to_id AS content_how_to_id_15, c0_.content_about_us_id AS content_about_us_id_16, c0_.template_id AS template_id_17, c0_.faq_id AS faq_id_18, c0_.notification_id AS notification_id_19 FROM customer c0_ LEFT JOIN customer_configuration c1_ ON c0_.configuration_id = c1_.id WHERE c1_.host LIKE ? AND c1_.contract_start <= ? AND c1_.contract_end >= ? AND c1_.active = 1"
  "params" => [
    1 => "%tv-schweinheim.werbebanden-manager.de%"
    2 => "2024-11-05"
    3 => "2024-11-05"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

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

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

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.name AS name_2, c0_.subtitle AS subtitle_3, c0_.created_at AS created_at_4, c0_.person_id AS person_id_5, c0_.address_id AS address_id_6, c0_.user_id AS user_id_7, c0_.contact_id AS contact_id_8, c0_.configuration_id AS configuration_id_9, c0_.partner_id AS partner_id_10, c0_.logo_id AS logo_id_11, c0_.tax_information_id AS tax_information_id_12, c0_.invoice_settings_id AS invoice_settings_id_13, c0_.contract_settings_id AS contract_settings_id_14, c0_.content_how_to_id AS content_how_to_id_15, c0_.content_about_us_id AS content_about_us_id_16, c0_.template_id AS template_id_17, c0_.faq_id AS faq_id_18, c0_.notification_id AS notification_id_19 FROM customer c0_ LEFT JOIN customer_configuration c1_ ON c0_.configuration_id = c1_.id WHERE c1_.host LIKE ? AND c1_.contract_start <= ? AND c1_.contract_end >= ? AND c1_.active = 1"
  "params" => [
    1 => "%tv-schweinheim.werbebanden-manager.de%"
    2 => "2024-11-05"
    3 => "2024-11-05"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.field_length AS field_length_2, t0.field_width AS field_width_3, t0.color_free AS color_free_4, t0.color_sold AS color_sold_5, t0.color_reserved AS color_reserved_6, t0.color_blocked AS color_blocked_7, t0.draft AS draft_8, t0.package_image_id AS package_image_id_9, t0.customer_id AS customer_id_10 FROM customer_package t0 WHERE t0.customer_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fk_customer AS fk_customer_2, t0.fk_customer_package AS fk_customer_package_3, t0.fk_advertising_area_tier AS fk_advertising_area_tier_4, t0.fk_advertising_area_tier_position AS fk_advertising_area_tier_position_5 FROM customer_advertising_area_tier_position t0 WHERE t0.fk_customer = ? AND t0.fk_customer_package = ?"
  "params" => [
    1 => 4
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.sorting_index AS sorting_index_4, t0.price AS price_5, t0.setup_price_unit AS setup_price_unit_6, t0.within_setup_price AS within_setup_price_7, t0.min_duration AS min_duration_8, t0.fk_customer AS fk_customer_9, t0.fk_advertising_area_tier AS fk_advertising_area_tier_10, t11.id AS id_12, t11.name AS name_13, t11.identifier AS identifier_14, t0.fk_advertising_area_tier_position AS fk_advertising_area_tier_position_15, t16.id AS id_17, t16.position AS position_18, t16.advertising_area_tier_id AS advertising_area_tier_id_19, t0.fk_customer_advertising_area_tier_position AS fk_customer_advertising_area_tier_position_20, t0.fk_advertising_area_tier_settings AS fk_advertising_area_tier_settings_21, t0.fk_advertising_area_status AS fk_advertising_area_status_22, t0.sponsor_id AS sponsor_id_23, t0.fk_contract AS fk_contract_24 FROM customer_advertising_area t0 INNER JOIN advertising_area_tier t11 ON t0.fk_advertising_area_tier = t11.id INNER JOIN advertising_area_tier_position t16 ON t0.fk_advertising_area_tier_position = t16.id WHERE t0.fk_customer = ? AND t0.fk_customer_advertising_area_tier_position = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 4
    2 => 5
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.sorting_index AS sorting_index_4, t0.price AS price_5, t0.setup_price_unit AS setup_price_unit_6, t0.within_setup_price AS within_setup_price_7, t0.min_duration AS min_duration_8, t0.fk_customer AS fk_customer_9, t0.fk_advertising_area_tier AS fk_advertising_area_tier_10, t11.id AS id_12, t11.name AS name_13, t11.identifier AS identifier_14, t0.fk_advertising_area_tier_position AS fk_advertising_area_tier_position_15, t16.id AS id_17, t16.position AS position_18, t16.advertising_area_tier_id AS advertising_area_tier_id_19, t0.fk_customer_advertising_area_tier_position AS fk_customer_advertising_area_tier_position_20, t0.fk_advertising_area_tier_settings AS fk_advertising_area_tier_settings_21, t0.fk_advertising_area_status AS fk_advertising_area_status_22, t0.sponsor_id AS sponsor_id_23, t0.fk_contract AS fk_contract_24 FROM customer_advertising_area t0 INNER JOIN advertising_area_tier t11 ON t0.fk_advertising_area_tier = t11.id INNER JOIN advertising_area_tier_position t16 ON t0.fk_advertising_area_tier_position = t16.id WHERE t0.fk_customer = ? AND t0.fk_customer_advertising_area_tier_position = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 4
    2 => 6
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.sorting_index AS sorting_index_4, t0.price AS price_5, t0.setup_price_unit AS setup_price_unit_6, t0.within_setup_price AS within_setup_price_7, t0.min_duration AS min_duration_8, t0.fk_customer AS fk_customer_9, t0.fk_advertising_area_tier AS fk_advertising_area_tier_10, t11.id AS id_12, t11.name AS name_13, t11.identifier AS identifier_14, t0.fk_advertising_area_tier_position AS fk_advertising_area_tier_position_15, t16.id AS id_17, t16.position AS position_18, t16.advertising_area_tier_id AS advertising_area_tier_id_19, t0.fk_customer_advertising_area_tier_position AS fk_customer_advertising_area_tier_position_20, t0.fk_advertising_area_tier_settings AS fk_advertising_area_tier_settings_21, t0.fk_advertising_area_status AS fk_advertising_area_status_22, t0.sponsor_id AS sponsor_id_23, t0.fk_contract AS fk_contract_24 FROM customer_advertising_area t0 INNER JOIN advertising_area_tier t11 ON t0.fk_advertising_area_tier = t11.id INNER JOIN advertising_area_tier_position t16 ON t0.fk_advertising_area_tier_position = t16.id WHERE t0.fk_customer = ? AND t0.fk_customer_advertising_area_tier_position = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 4
    2 => 7
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.sorting_index AS sorting_index_4, t0.price AS price_5, t0.setup_price_unit AS setup_price_unit_6, t0.within_setup_price AS within_setup_price_7, t0.min_duration AS min_duration_8, t0.fk_customer AS fk_customer_9, t0.fk_advertising_area_tier AS fk_advertising_area_tier_10, t11.id AS id_12, t11.name AS name_13, t11.identifier AS identifier_14, t0.fk_advertising_area_tier_position AS fk_advertising_area_tier_position_15, t16.id AS id_17, t16.position AS position_18, t16.advertising_area_tier_id AS advertising_area_tier_id_19, t0.fk_customer_advertising_area_tier_position AS fk_customer_advertising_area_tier_position_20, t0.fk_advertising_area_tier_settings AS fk_advertising_area_tier_settings_21, t0.fk_advertising_area_status AS fk_advertising_area_status_22, t0.sponsor_id AS sponsor_id_23, t0.fk_contract AS fk_contract_24 FROM customer_advertising_area t0 INNER JOIN advertising_area_tier t11 ON t0.fk_advertising_area_tier = t11.id INNER JOIN advertising_area_tier_position t16 ON t0.fk_advertising_area_tier_position = t16.id WHERE t0.fk_customer = ? AND t0.fk_customer_advertising_area_tier_position = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 4
    2 => 8
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.sorting_index AS sorting_index_4, t0.price AS price_5, t0.setup_price_unit AS setup_price_unit_6, t0.within_setup_price AS within_setup_price_7, t0.min_duration AS min_duration_8, t0.fk_customer AS fk_customer_9, t0.fk_advertising_area_tier AS fk_advertising_area_tier_10, t11.id AS id_12, t11.name AS name_13, t11.identifier AS identifier_14, t0.fk_advertising_area_tier_position AS fk_advertising_area_tier_position_15, t16.id AS id_17, t16.position AS position_18, t16.advertising_area_tier_id AS advertising_area_tier_id_19, t0.fk_customer_advertising_area_tier_position AS fk_customer_advertising_area_tier_position_20, t0.fk_advertising_area_tier_settings AS fk_advertising_area_tier_settings_21, t0.fk_advertising_area_status AS fk_advertising_area_status_22, t0.sponsor_id AS sponsor_id_23, t0.fk_contract AS fk_contract_24 FROM customer_advertising_area t0 INNER JOIN advertising_area_tier t11 ON t0.fk_advertising_area_tier = t11.id INNER JOIN advertising_area_tier_position t16 ON t0.fk_advertising_area_tier_position = t16.id WHERE t0.fk_customer = ? AND t0.fk_customer_advertising_area_tier_position = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 4
    2 => 9
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.sorting_index AS sorting_index_4, t0.price AS price_5, t0.setup_price_unit AS setup_price_unit_6, t0.within_setup_price AS within_setup_price_7, t0.min_duration AS min_duration_8, t0.fk_customer AS fk_customer_9, t0.fk_advertising_area_tier AS fk_advertising_area_tier_10, t11.id AS id_12, t11.name AS name_13, t11.identifier AS identifier_14, t0.fk_advertising_area_tier_position AS fk_advertising_area_tier_position_15, t16.id AS id_17, t16.position AS position_18, t16.advertising_area_tier_id AS advertising_area_tier_id_19, t0.fk_customer_advertising_area_tier_position AS fk_customer_advertising_area_tier_position_20, t0.fk_advertising_area_tier_settings AS fk_advertising_area_tier_settings_21, t0.fk_advertising_area_status AS fk_advertising_area_status_22, t0.sponsor_id AS sponsor_id_23, t0.fk_contract AS fk_contract_24 FROM customer_advertising_area t0 INNER JOIN advertising_area_tier t11 ON t0.fk_advertising_area_tier = t11.id INNER JOIN advertising_area_tier_position t16 ON t0.fk_advertising_area_tier_position = t16.id WHERE t0.fk_customer = ? AND t0.fk_customer_advertising_area_tier_position = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 4
    2 => 95
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.person_id AS person_id_4, t0.address_id AS address_id_5, t0.contact_id AS contact_id_6, t0.fk_customer AS fk_customer_7, t0.image_id AS image_id_8 FROM sponsor t0 WHERE t0.fk_customer = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.created_at AS created_at_5, t0.date_next_invoice AS date_next_invoice_6, t0.state AS state_7, t0.file AS file_8, t0.notify_cancellable AS notify_cancellable_9, t0.number AS number_10, t0.duration AS duration_11, t0.existing_contract AS existing_contract_12, t0.contribution_active AS contribution_active_13, t0.contribution_price AS contribution_price_14, t0.signature AS signature_15, t0.extending_period_in_month AS extending_period_in_month_16, t0.canceling_period_in_month AS canceling_period_in_month_17, t0.fk_customer AS fk_customer_18, t0.fk_sponsor AS fk_sponsor_19, t0.fk_invoice_interval AS fk_invoice_interval_20, t21.id AS id_22, t21.content AS content_23, t21.fk_contract AS fk_contract_24 FROM contract t0 LEFT JOIN contract_agreement t21 ON t21.fk_contract = t0.id WHERE t0.fk_sponsor = ? ORDER BY t0.id DESC"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.created_at AS created_at_5, t0.date_next_invoice AS date_next_invoice_6, t0.state AS state_7, t0.file AS file_8, t0.notify_cancellable AS notify_cancellable_9, t0.number AS number_10, t0.duration AS duration_11, t0.existing_contract AS existing_contract_12, t0.contribution_active AS contribution_active_13, t0.contribution_price AS contribution_price_14, t0.signature AS signature_15, t0.extending_period_in_month AS extending_period_in_month_16, t0.canceling_period_in_month AS canceling_period_in_month_17, t0.fk_customer AS fk_customer_18, t0.fk_sponsor AS fk_sponsor_19, t0.fk_invoice_interval AS fk_invoice_interval_20, t21.id AS id_22, t21.content AS content_23, t21.fk_contract AS fk_contract_24 FROM contract t0 LEFT JOIN contract_agreement t21 ON t21.fk_contract = t0.id WHERE t0.fk_sponsor = ? ORDER BY t0.id DESC"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.created_at AS created_at_5, t0.date_next_invoice AS date_next_invoice_6, t0.state AS state_7, t0.file AS file_8, t0.notify_cancellable AS notify_cancellable_9, t0.number AS number_10, t0.duration AS duration_11, t0.existing_contract AS existing_contract_12, t0.contribution_active AS contribution_active_13, t0.contribution_price AS contribution_price_14, t0.signature AS signature_15, t0.extending_period_in_month AS extending_period_in_month_16, t0.canceling_period_in_month AS canceling_period_in_month_17, t0.fk_customer AS fk_customer_18, t0.fk_sponsor AS fk_sponsor_19, t0.fk_invoice_interval AS fk_invoice_interval_20, t21.id AS id_22, t21.content AS content_23, t21.fk_contract AS fk_contract_24 FROM contract t0 LEFT JOIN contract_agreement t21 ON t21.fk_contract = t0.id WHERE t0.fk_sponsor = ? ORDER BY t0.id DESC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.created_at AS created_at_5, t0.date_next_invoice AS date_next_invoice_6, t0.state AS state_7, t0.file AS file_8, t0.notify_cancellable AS notify_cancellable_9, t0.number AS number_10, t0.duration AS duration_11, t0.existing_contract AS existing_contract_12, t0.contribution_active AS contribution_active_13, t0.contribution_price AS contribution_price_14, t0.signature AS signature_15, t0.extending_period_in_month AS extending_period_in_month_16, t0.canceling_period_in_month AS canceling_period_in_month_17, t0.fk_customer AS fk_customer_18, t0.fk_sponsor AS fk_sponsor_19, t0.fk_invoice_interval AS fk_invoice_interval_20, t21.id AS id_22, t21.content AS content_23, t21.fk_contract AS fk_contract_24 FROM contract t0 LEFT JOIN contract_agreement t21 ON t21.fk_contract = t0.id WHERE t0.fk_sponsor = ? ORDER BY t0.id DESC"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.name AS name_2, c0_.subtitle AS subtitle_3, c0_.created_at AS created_at_4, c0_.person_id AS person_id_5, c0_.address_id AS address_id_6, c0_.user_id AS user_id_7, c0_.contact_id AS contact_id_8, c0_.configuration_id AS configuration_id_9, c0_.partner_id AS partner_id_10, c0_.logo_id AS logo_id_11, c0_.tax_information_id AS tax_information_id_12, c0_.invoice_settings_id AS invoice_settings_id_13, c0_.contract_settings_id AS contract_settings_id_14, c0_.content_how_to_id AS content_how_to_id_15, c0_.content_about_us_id AS content_about_us_id_16, c0_.template_id AS template_id_17, c0_.faq_id AS faq_id_18, c0_.notification_id AS notification_id_19 FROM customer c0_ LEFT JOIN customer_configuration c1_ ON c0_.configuration_id = c1_.id WHERE c1_.host LIKE ? AND c1_.contract_start <= ? AND c1_.contract_end >= ? AND c1_.active = 1"
  "params" => [
    1 => "%tv-schweinheim.werbebanden-manager.de%"
    2 => "2024-11-05"
    3 => "2024-11-05"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.src AS src_2, t0.size AS size_3, t0.complete AS complete_4 FROM image t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.primary_color AS primary_color_2, t0.secondary_color AS secondary_color_3, t0.footer_background_color AS footer_background_color_4, t0.footer_text_color AS footer_text_color_5, t0.header_image_id AS header_image_id_6 FROM customer_template t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.image_id AS image_id_3 FROM package_image t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.src AS src_2, t0.size AS size_3, t0.complete AS complete_4 FROM image t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.identifier AS identifier_3 FROM advertising_area_status t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.identifier AS identifier_3 FROM advertising_area_status t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company AS company_2, t0.street AS street_3, t0.housenr AS housenr_4, t0.city AS city_5, t0.zipcode AS zipcode_6, t0.country AS country_7 FROM address t0 WHERE t0.id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company AS company_2, t0.street AS street_3, t0.housenr AS housenr_4, t0.city AS city_5, t0.zipcode AS zipcode_6, t0.country AS country_7 FROM address t0 WHERE t0.id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company AS company_2, t0.street AS street_3, t0.housenr AS housenr_4, t0.city AS city_5, t0.zipcode AS zipcode_6, t0.country AS country_7 FROM address t0 WHERE t0.id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company AS company_2, t0.street AS street_3, t0.housenr AS housenr_4, t0.city AS city_5, t0.zipcode AS zipcode_6, t0.country AS country_7 FROM address t0 WHERE t0.id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company AS company_2, t0.street AS street_3, t0.housenr AS housenr_4, t0.city AS city_5, t0.zipcode AS zipcode_6, t0.country AS country_7 FROM address t0 WHERE t0.id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company AS company_2, t0.street AS street_3, t0.housenr AS housenr_4, t0.city AS city_5, t0.zipcode AS zipcode_6, t0.country AS country_7 FROM address t0 WHERE t0.id = ?"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company AS company_2, t0.street AS street_3, t0.housenr AS housenr_4, t0.city AS city_5, t0.zipcode AS zipcode_6, t0.country AS country_7 FROM address t0 WHERE t0.id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company AS company_2, t0.street AS street_3, t0.housenr AS housenr_4, t0.city AS city_5, t0.zipcode AS zipcode_6, t0.country AS country_7 FROM address t0 WHERE t0.id = ?"
  "params" => [
    1 => 17
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.identifier AS identifier_3 FROM advertising_area_status t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.phone AS phone_2, t0.fax AS fax_3, t0.email AS email_4, t0.url AS url_5 FROM contact t0 WHERE t0.id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.phone AS phone_2, t0.fax AS fax_3, t0.email AS email_4, t0.url AS url_5 FROM contact t0 WHERE t0.id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.phone AS phone_2, t0.fax AS fax_3, t0.email AS email_4, t0.url AS url_5 FROM contact t0 WHERE t0.id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.phone AS phone_2, t0.fax AS fax_3, t0.email AS email_4, t0.url AS url_5 FROM contact t0 WHERE t0.id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company AS company_2, t0.street AS street_3, t0.housenr AS housenr_4, t0.city AS city_5, t0.zipcode AS zipcode_6, t0.country AS country_7 FROM address t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.phone AS phone_2, t0.fax AS fax_3, t0.email AS email_4, t0.url AS url_5 FROM contact t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "usr_p676854_1"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "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" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::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"
]