Symfony Profiler

[
  "route" => "cart"
  "route_parameters" => [
    "_route" => "cart"
    "_controller" => "App\Controller\Cart\PreviewController::indexAction"
    "_shop" => Proxies\__CG__\App\Entity\Shop {#804
      #id: 3
      #deleted: false
      #createdAt: DateTime @1705069074 {#512
        date: 2024-01-12 14:17:54.0 UTC (+00:00)
      }
      #updatedAt: DateTime @1705069074 {#515
        date: 2024-01-12 14:17:54.0 UTC (+00:00)
      }
      #deletedAt: null
      #lifeCycleEnabled: true
      -shopSchedules: Doctrine\ORM\PersistentCollection {#503 …}
      -shopProducts: Doctrine\ORM\PersistentCollection {#482 …}
      -orders: Doctrine\ORM\PersistentCollection {#492 …}
      -quotes: Doctrine\ORM\PersistentCollection {#457 …}
      -users: Doctrine\ORM\PersistentCollection {#413 …}
      -offers: Doctrine\ORM\PersistentCollection {#351 …}
      -default: true
      -prefix: "B2B-CTX-DE"
      -frontend: Proxies\__CG__\App\Entity\Shop\Frontend {#344 …}
      -internationalization: Proxies\__CG__\App\Entity\Shop\Internationalization {#318 …}
      -invoicing: Proxies\__CG__\App\Entity\Shop\Invoicing {#291 …}
      -customFields: Doctrine\ORM\PersistentCollection {#255 …}
      -quoteTemplates: Doctrine\ORM\PersistentCollection {#268 …}
      -productGroups: Doctrine\ORM\PersistentCollection {#285 …}
      -contracts: Doctrine\ORM\PersistentCollection {#234 …}
      -amendments: Doctrine\ORM\PersistentCollection {#200 …}
      -image: null
      -imagecover: null
      -title: "B2B Context Shop Default"
      -address: ""
      -zipcode: ""
      -city: ""
      -state: ""
      -country: "FR"
      -description: ""
      -lazyObjectState: Symfony\Component\VarExporter\Internal\LazyObjectState {#805 …}
    }
  ]
  "request_uri" => "https://shop-generic.valuein.studio/cart"
  "method" => "GET"
]

[
  "params" => [
    "charset" => "UTF8"
    "driver" => "pdo_mysql"
    "host" => "mysql"
    "port" => 3306
    "user" => "valuein"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "valueinvoice"
    "serverVersion" => "mariadb-10.2.40"
  ]
]

[
  "sql" => "SELECT t0.isDefault AS isDefault_1, t0.prefix AS prefix_2, t0.id AS id_3, t0.deleted AS deleted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.title AS title_8, t0.address AS address_9, t0.zipcode AS zipcode_10, t0.city AS city_11, t0.state AS state_12, t0.country AS country_13, t0.description AS description_14, t0.frontend_id AS frontend_id_15, t0.internationalization_id AS internationalization_id_16, t0.invoicing_id AS invoicing_id_17, t0.image_id AS image_id_18, t20.name AS name_19, t20.description AS description_21, t20.enabled AS enabled_22, t20.provider_name AS provider_name_23, t20.provider_status AS provider_status_24, t20.provider_reference AS provider_reference_25, t20.provider_metadata AS provider_metadata_26, t20.width AS width_27, t20.height AS height_28, t20.length AS length_29, t20.content_type AS content_type_30, t20.content_size AS content_size_31, t20.copyright AS copyright_32, t20.author_name AS author_name_33, t20.context AS context_34, t20.cdn_is_flushable AS cdn_is_flushable_35, t20.cdn_flush_identifier AS cdn_flush_identifier_36, t20.cdn_flush_at AS cdn_flush_at_37, t20.cdn_status AS cdn_status_38, t20.updated_at AS updated_at_39, t20.created_at AS created_at_40, t20.uuid AS uuid_41, t20.id AS id_42, t0.imagecover_id AS imagecover_id_43, t0.entityType FROM valueinshop_shop t0 LEFT JOIN valueinshop_media t20 ON t0.image_id = t20.id WHERE t0.id = ? AND t0.entityType IN ('shop') AND ((t0.deleted = 0))"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

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

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

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\OfflineSubscriber::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\EventSubscriber\Admin\FirewallRequestEventSubscriber::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\Admin\IdleRequestEventSubscriber::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\Admin\LoginActivityEventSubscriber::__invoke"
]

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

[
  "event" => "kernel.request"
  "listener" => "ValueIn\ValueInInvoiceEngineBundle\EventSubscriber\RequestEventSubscriber::processRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::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" => "Sonata\AdminBundle\EventListener\ConfigureCRUDControllerListener::onKernelController"
]

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

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

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

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

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

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

[
  "sql" => "SELECT v0_.name AS name_0, v0_.amendment_system_name AS amendment_system_name_1, v0_.enabled_from AS enabled_from_2, v0_.enabled_to AS enabled_to_3, v0_.status AS status_4, v0_.term_types AS term_types_5, v0_.allow_custom_subscription_strategy AS allow_custom_subscription_strategy_6, v0_.id AS id_7, v0_.deleted AS deleted_8, v0_.created_at AS created_at_9, v0_.updated_at AS updated_at_10, v0_.deleted_at AS deleted_at_11 FROM valueinshop_config_amendement v0_ WHERE (v0_.enabled_to >= ? AND v0_.enabled_from <= ?) AND (v0_.deleted = 0) ORDER BY v0_.amendment_system_name ASC"
  "params" => [
    1 => "2025-04-29 00:00:00"
    2 => "2025-04-29 00:00:00"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.use_invoice_engine_preview AS use_invoice_engine_preview_2, t0.context AS context_3, t0.shipping_address_mode AS shipping_address_mode_4, t0.billing_address_mode AS billing_address_mode_5, t0.display_tax_detail AS display_tax_detail_6, t0.display_discount_detail AS display_discount_detail_7, t0.display_map_in_forms AS display_map_in_forms_8 FROM valueinshop_cart t0"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.use_invoice_engine_preview AS use_invoice_engine_preview_2, t0.context AS context_3, t0.shipping_address_mode AS shipping_address_mode_4, t0.billing_address_mode AS billing_address_mode_5, t0.display_tax_detail AS display_tax_detail_6, t0.display_discount_detail AS display_discount_detail_7, t0.display_map_in_forms AS display_map_in_forms_8 FROM valueinshop_cart t0"
]

[
  "event" => "App\EventDispatcher\Event\CartSavePostRefreshEvent"
  "listener" => "App\EventSubscriber\Cart\CartPreviewerEventSubscriber::postRefreshPreview"
]

[
  "sql" => "SELECT t0.label AS label_1, t0.field_group AS field_group_2, t0.visible_on_all_shop AS visible_on_all_shop_3, t0.visible_without_shop AS visible_without_shop_4, t0.priority AS priority_5, t0.scope AS scope_6, t0.destination AS destination_7, t0.custom_field_name AS custom_field_name_8, t0.default_value AS default_value_9, t0.field_type AS field_type_10, t0.choices AS choices_11, t0.self_service_behavior AS self_service_behavior_12, t0.customer_care_behavior AS customer_care_behavior_13, t0.id AS id_14, t0.deleted AS deleted_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.deleted_at AS deleted_at_18 FROM valueinshop_custom_fields t0 WHERE ((t0.deleted = 0))"
]

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

[
  "sql" => "SELECT t0.label AS label_1, t0.field_group AS field_group_2, t0.visible_on_all_shop AS visible_on_all_shop_3, t0.visible_without_shop AS visible_without_shop_4, t0.priority AS priority_5, t0.scope AS scope_6, t0.destination AS destination_7, t0.custom_field_name AS custom_field_name_8, t0.default_value AS default_value_9, t0.field_type AS field_type_10, t0.choices AS choices_11, t0.self_service_behavior AS self_service_behavior_12, t0.customer_care_behavior AS customer_care_behavior_13, t0.id AS id_14, t0.deleted AS deleted_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.deleted_at AS deleted_at_18 FROM valueinshop_custom_fields t0 WHERE ((t0.deleted = 0))"
]

[
  "sql" => "SELECT v0_.name AS name_0, v0_.is_default AS is_default_1, v0_.is_displayed AS is_displayed_2, v0_.commissioning_method AS commissioning_method_3, v0_.subscription_separation_level AS subscription_separation_level_4, v0_.contract_effective_date AS contract_effective_date_5, v0_.service_activation_date AS service_activation_date_6, v0_.customer_acceptance_date AS customer_acceptance_date_7, v0_.term_start_date AS term_start_date_8, v0_.invoice_target_date AS invoice_target_date_9, v0_.invoice_target_date_preview AS invoice_target_date_preview_10, v0_.term_type AS term_type_11, v0_.initial_term AS initial_term_12, v0_.initial_term_period_type AS initial_term_period_type_13, v0_.auto_renew AS auto_renew_14, v0_.renewal_term AS renewal_term_15, v0_.renewal_term_period_type AS renewal_term_period_type_16, v0_.renewal_setting AS renewal_setting_17, v0_.conditionnal_renewal_start_date AS conditionnal_renewal_start_date_18, v0_.conditionnal_renewal_end_date AS conditionnal_renewal_end_date_19, v0_.invoice AS invoice_20, v0_.collect AS collect_21, v0_.invoice_separately AS invoice_separately_22, v0_.apply_credit_balance AS apply_credit_balance_23, v0_.renew_allow AS renew_allow_24, v0_.allow_change_quantity AS allow_change_quantity_25, v0_.renew_apply_credit_balance AS renew_apply_credit_balance_26, v0_.renew_collect AS renew_collect_27, v0_.renew_run_billing AS renew_run_billing_28, v0_.upgrade_policy AS upgrade_policy_29, v0_.upgrade_apply_credit_balance AS upgrade_apply_credit_balance_30, v0_.upgrade_collect AS upgrade_collect_31, v0_.upgrade_run_billing AS upgrade_run_billing_32, v0_.downgrade_policy AS downgrade_policy_33, v0_.downgrade_apply_credit_balance AS downgrade_apply_credit_balance_34, v0_.downgrade_collect AS downgrade_collect_35, v0_.downgrade_run_billing AS downgrade_run_billing_36, v0_.quantity_recurring_policy AS quantity_recurring_policy_37, v0_.quantity_recurring_apply_credit_balance AS quantity_recurring_apply_credit_balance_38, v0_.quantity_recurring_collect AS quantity_recurring_collect_39, v0_.quantity_recurring_run_billing AS quantity_recurring_run_billing_40, v0_.quantity_one_time_policy AS quantity_one_time_policy_41, v0_.quantity_one_time_apply_credit_balance AS quantity_one_time_apply_credit_balance_42, v0_.quantity_one_time_collect AS quantity_one_time_collect_43, v0_.quantity_one_time_run_billing AS quantity_one_time_run_billing_44, v0_.fixed_date AS fixed_date_45, v0_.renewal_date AS renewal_date_46, v0_.id AS id_47, v0_.deleted AS deleted_48, v0_.created_at AS created_at_49, v0_.updated_at AS updated_at_50, v0_.deleted_at AS deleted_at_51, v0_.uuid AS uuid_52 FROM valueinshop_subscription_strategy v0_ WHERE (v0_.is_displayed = 1) AND (v0_.deleted = 0) ORDER BY v0_.name ASC"
]

[
  "sql" => "SELECT t0.default_strategy AS default_strategy_1, t0.title AS title_2, t0.one_time_shipping AS one_time_shipping_3, t0.catchup AS catchup_4, t0.shipping_start_date AS shipping_start_date_5, t0.shipping_period AS shipping_period_6, t0.shipping_end_date AS shipping_end_date_7, t0.shipping_trigger AS shipping_trigger_8, t0.payment_failure_action AS payment_failure_action_9, t0.shipping_expire AS shipping_expire_10, t0.shipping_expiration_delay AS shipping_expiration_delay_11, t0.can_share_packages AS can_share_packages_12, t0.send_ship_order_directly AS send_ship_order_directly_13, t0.wait_for_validation AS wait_for_validation_14, t0.association_required AS association_required_15, t0.id AS id_16, t0.deleted AS deleted_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.deleted_at AS deleted_at_20, t0.uuid AS uuid_21 FROM valueinshop_shipping_strategy t0 WHERE ((t0.deleted = 0))"
]

[
  "sql" => "SELECT t0.language_code AS language_code_1, t0.isDefault AS isDefault_2, t0.enabled AS enabled_3, t0.debug AS debug_4, t0.collect AS collect_5, t0.id AS id_6, t0.deleted AS deleted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM valueinshop_language t0 WHERE t0.language_code = ? AND ((t0.id IN (SELECT vil.language_id FROM valueinshop_internationalization_language vil JOIN valueinshop_shop vs ON vs.internationalization_id = vil.internationalization_id WHERE vs.id=3) OR (SELECT COUNT(vil.language_id) FROM valueinshop_internationalization_language vil JOIN valueinshop_shop vs ON vs.internationalization_id = vil.internationalization_id WHERE vs.id=3)=0) AND (t0.deleted = 0)) LIMIT 1"
  "params" => [
    1 => "en"
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT t0.position AS position_1, t0.external_id AS external_id_2, t0.attributes AS attributes_3, t0.dynamic_pricing_setting AS dynamic_pricing_setting_4, t0.dynamic_pricing_file AS dynamic_pricing_file_5, t0.show_empty_line AS show_empty_line_6, t0.id AS id_7, t0.deleted AS deleted_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.uuid AS uuid_12, t0.title AS title_13, t0.publish_start_date AS publish_start_date_14, t0.publish_end_date AS publish_end_date_15, t0.product_id AS product_id_16, t0.subscription_strategy_override_id AS subscription_strategy_override_id_17, t0.offer_id AS offer_id_18 FROM valueinshop_product_rate_plan t0 WHERE t0.id = ? AND ((t0.product_id IN (SELECT product_id FROM valueinshop_shop_product WHERE shop_id=3) OR (SELECT COUNT(product_id) FROM valueinshop_shop_product WHERE shop_id=3)=0) AND (t0.deleted = 0))"
  "params" => [
    1 => "2"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.is_default AS is_default_2, t0.is_displayed AS is_displayed_3, t0.commissioning_method AS commissioning_method_4, t0.subscription_separation_level AS subscription_separation_level_5, t0.contract_effective_date AS contract_effective_date_6, t0.service_activation_date AS service_activation_date_7, t0.customer_acceptance_date AS customer_acceptance_date_8, t0.term_start_date AS term_start_date_9, t0.invoice_target_date AS invoice_target_date_10, t0.invoice_target_date_preview AS invoice_target_date_preview_11, t0.term_type AS term_type_12, t0.initial_term AS initial_term_13, t0.initial_term_period_type AS initial_term_period_type_14, t0.auto_renew AS auto_renew_15, t0.renewal_term AS renewal_term_16, t0.renewal_term_period_type AS renewal_term_period_type_17, t0.renewal_setting AS renewal_setting_18, t0.conditionnal_renewal_start_date AS conditionnal_renewal_start_date_19, t0.conditionnal_renewal_end_date AS conditionnal_renewal_end_date_20, t0.invoice AS invoice_21, t0.collect AS collect_22, t0.invoice_separately AS invoice_separately_23, t0.apply_credit_balance AS apply_credit_balance_24, t0.renew_allow AS renew_allow_25, t0.allow_change_quantity AS allow_change_quantity_26, t0.renew_apply_credit_balance AS renew_apply_credit_balance_27, t0.renew_collect AS renew_collect_28, t0.renew_run_billing AS renew_run_billing_29, t0.upgrade_policy AS upgrade_policy_30, t0.upgrade_apply_credit_balance AS upgrade_apply_credit_balance_31, t0.upgrade_collect AS upgrade_collect_32, t0.upgrade_run_billing AS upgrade_run_billing_33, t0.downgrade_policy AS downgrade_policy_34, t0.downgrade_apply_credit_balance AS downgrade_apply_credit_balance_35, t0.downgrade_collect AS downgrade_collect_36, t0.downgrade_run_billing AS downgrade_run_billing_37, t0.quantity_recurring_policy AS quantity_recurring_policy_38, t0.quantity_recurring_apply_credit_balance AS quantity_recurring_apply_credit_balance_39, t0.quantity_recurring_collect AS quantity_recurring_collect_40, t0.quantity_recurring_run_billing AS quantity_recurring_run_billing_41, t0.quantity_one_time_policy AS quantity_one_time_policy_42, t0.quantity_one_time_apply_credit_balance AS quantity_one_time_apply_credit_balance_43, t0.quantity_one_time_collect AS quantity_one_time_collect_44, t0.quantity_one_time_run_billing AS quantity_one_time_run_billing_45, t0.fixed_date AS fixed_date_46, t0.renewal_date AS renewal_date_47, t0.id AS id_48, t0.deleted AS deleted_49, t0.created_at AS created_at_50, t0.updated_at AS updated_at_51, t0.deleted_at AS deleted_at_52, t0.uuid AS uuid_53 FROM valueinshop_subscription_strategy t0 WHERE t0.is_default = ? AND ((t0.deleted = 0)) LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT t0.title AS title_1, t0.language AS language_2, t0.id AS id_3, t0.deleted AS deleted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.source_id AS source_id_8 FROM valueinshop_product_rate_plan_translation t0 WHERE t0.source_id = ? AND t0.language = ? AND ((t0.deleted = 0)) LIMIT 1"
  "params" => [
    1 => 2
    2 => "en"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.title AS title_1, t0.external_id AS external_id_2, t0.price AS price_3, t0.overage_price AS overage_price_4, t0.included_units AS included_units_5, t0.quantity AS quantity_6, t0.quantity_configuration AS quantity_configuration_7, t0.uom AS uom_8, t0.position AS position_9, t0.id AS id_10, t0.deleted AS deleted_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.uuid AS uuid_15, t0.description AS description_16, t0.rate_plan_id AS rate_plan_id_17 FROM valueinshop_product_rate_plan_charge t0 WHERE t0.rate_plan_id = ? AND ((t0.deleted = 0)) ORDER BY t0.position ASC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.title AS title_1, t0.uom AS uom_2, t0.language AS language_3, t0.id AS id_4, t0.deleted AS deleted_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.source_id AS source_id_9 FROM valueinshop_product_rate_plan_charge_translation t0 WHERE t0.source_id = ? AND t0.language = ? AND ((t0.deleted = 0)) LIMIT 1"
  "params" => [
    1 => 3
    2 => "en"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.title AS title_1, t0.uom AS uom_2, t0.language AS language_3, t0.id AS id_4, t0.deleted AS deleted_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.source_id AS source_id_9 FROM valueinshop_product_rate_plan_charge_translation t0 WHERE t0.source_id = ? AND t0.language = ? AND ((t0.deleted = 0)) LIMIT 1"
  "params" => [
    1 => 2
    2 => "en"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.username AS username_1, t0.prefix_url AS prefix_url_2, t0.tennant_id AS tennant_id_3, t0.country_code AS country_code_4, t0.id AS id_5, t0.password AS password_6, t0.execution_level AS execution_level_7, t0.preview_charge_prefix AS preview_charge_prefix_8 FROM valueinshop_config_zuora t0"
]

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

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

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

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

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

[
  "sql" => "SELECT t0.context AS context_1, t0.shipping_address_mode AS shipping_address_mode_2, t0.billing_address_mode AS billing_address_mode_3, t0.id AS id_4, t0.deleted AS deleted_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.theme_id AS theme_id_9 FROM valueinshop_shop_frontend t0 WHERE t0.id = ? AND ((t0.deleted = 0))"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

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

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

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

[
  "sql" => "SELECT t0.title AS title_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.head_start AS head_start_4, t0.head_end AS head_end_5, t0.body_start AS body_start_6, t0.body_end AS body_end_7, t0.id AS id_8, t0.deleted AS deleted_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12 FROM valueinshop_html_snippet t0 WHERE ((t0.deleted = 0))"
]

[
  "sql" => "SELECT t0.title AS title_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.head_start AS head_start_4, t0.head_end AS head_end_5, t0.body_start AS body_start_6, t0.body_end AS body_end_7, t0.id AS id_8, t0.deleted AS deleted_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12 FROM valueinshop_html_snippet t0 WHERE ((t0.deleted = 0))"
]

[
  "sql" => "SELECT t0.title AS title_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.head_start AS head_start_4, t0.head_end AS head_end_5, t0.body_start AS body_start_6, t0.body_end AS body_end_7, t0.id AS id_8, t0.deleted AS deleted_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12 FROM valueinshop_html_snippet t0 WHERE ((t0.deleted = 0))"
]

[
  "sql" => "SELECT t0.language_code AS language_code_1, t0.isDefault AS isDefault_2, t0.enabled AS enabled_3, t0.debug AS debug_4, t0.collect AS collect_5, t0.id AS id_6, t0.deleted AS deleted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM valueinshop_language t0 WHERE t0.enabled = ? AND ((t0.id IN (SELECT vil.language_id FROM valueinshop_internationalization_language vil JOIN valueinshop_shop vs ON vs.internationalization_id = vil.internationalization_id WHERE vs.id=3) OR (SELECT COUNT(vil.language_id) FROM valueinshop_internationalization_language vil JOIN valueinshop_shop vs ON vs.internationalization_id = vil.internationalization_id WHERE vs.id=3)=0) AND (t0.deleted = 0))"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

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

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

[
  "sql" => "SELECT t0.allowed_shipping_country AS allowed_shipping_country_1, t0.allowed_billing_country AS allowed_billing_country_2, t0.allowed_global_document AS allowed_global_document_3, t0.currency AS currency_4, t0.id AS id_5, t0.deleted AS deleted_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9 FROM valueinshop_shop_internationalization t0 WHERE t0.id = ? AND ((t0.deleted = 0))"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.title AS title_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.head_start AS head_start_4, t0.head_end AS head_end_5, t0.body_start AS body_start_6, t0.body_end AS body_end_7, t0.id AS id_8, t0.deleted AS deleted_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12 FROM valueinshop_html_snippet t0 WHERE ((t0.deleted = 0))"
]

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

[
  "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 => "valueinvoice"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "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 => "valueinvoice"
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => """
        SELECT t.TABLE_NAME,\n
               t.ENGINE,\n
               t.AUTO_INCREMENT,\n
               t.TABLE_COMMENT,\n
               t.CREATE_OPTIONS,\n
               t.TABLE_COLLATION,\n
               ccsa.CHARACTER_SET_NAME\n
          FROM information_schema.TABLES t\n
            INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa\n
                ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
    """
  "params" => [
    1 => "valueinvoice"
    2 => "valueinshop_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

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

[
  "sql" => """
    SELECT DISTINCT            k.CONSTRAINT_NAME,\n
                k.COLUMN_NAME,\n
                k.REFERENCED_TABLE_NAME,\n
                k.REFERENCED_COLUMN_NAME,\n
                k.ORDINAL_POSITION /*!50116,\n
                c.UPDATE_RULE,\n
                c.DELETE_RULE */\n
    FROM information_schema.key_column_usage k /*!50116\n
    INNER JOIN information_schema.referential_constraints c\n
    ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME\n
    AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'valueinvoice' */ ORDER BY k.ORDINAL_POSITION
    """
  "params" => [
    1 => "valueinvoice"
    2 => "valueinshop_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    SELECT       c.COLUMN_NAME        AS field,\n
           c.COLUMN_TYPE       AS type,\n
           c.IS_NULLABLE        AS `null`,\n
           c.COLUMN_KEY         AS `key`,\n
           c.COLUMN_DEFAULT     AS `default`,\n
           c.EXTRA,\n
           c.COLUMN_COMMENT     AS comment,\n
           c.CHARACTER_SET_NAME AS characterset,\n
           c.COLLATION_NAME     AS collation\n
    FROM information_schema.COLUMNS c\n
        INNER JOIN information_schema.TABLES t\n
            ON t.TABLE_NAME = c.TABLE_NAME\n
         WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
    """
  "params" => [
    1 => "valueinvoice"
    2 => "valueinvoice"
    3 => "valueinshop_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

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

[
  "sql" => """
    SELECT        NON_UNIQUE  AS Non_Unique,\n
            INDEX_NAME  AS Key_name,\n
            COLUMN_NAME AS Column_Name,\n
            SUB_PART    AS Sub_Part,\n
            INDEX_TYPE  AS Index_Type\n
    FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
    """
  "params" => [
    1 => "valueinvoice"
    2 => "valueinshop_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT * FROM valueinshop_migration_versions"
]

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

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "App\EventSubscriber\ResponseEventSubscriber::onKernelController"
]

[
  "event" => "kernel.response"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::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\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.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::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\Component\HttpKernel\EventListener\SessionListener::onFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

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