Symfony Profiler

[
  "route" => "homepage"
  "route_parameters" => [
    "_route" => "homepage"
    "_controller" => "App\Controller\DefaultController::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/"
  "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" => "main"
  "authenticators" => 0
]

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

[
  "sql" => "SELECT t0.enableSlider AS enableSlider_1, t0.enableShop AS enableShop_2, t0.enableRecentlyAddedProduct AS enableRecentlyAddedProduct_3, t0.enableRecommendedProduct AS enableRecommendedProduct_4, t0.enableCustomContent AS enableCustomContent_5, t0.customContent AS customContent_6, t0.id AS id_7, t0.slider_id AS slider_id_8, t0.low_size_screen_slider_id AS low_size_screen_slider_id_9 FROM valueinshop_config_homepage t0"
]

[
  "sql" => "SELECT t0.priority AS priority_6, t0.adminLabel AS adminLabel_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.deleted AS deleted_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.uuid AS uuid_14, t0.type, t1.title AS title_15, t2.title AS title_16, t2.productsListType AS productsListType_17, t3.body AS body_18, t4.title AS title_19, t5.slider_id AS slider_id_20, t5.low_size_screen_slider_id AS low_size_screen_slider_id_21 FROM valueinshop_cms_component t0 LEFT JOIN valueinshop_component_title_separator t1 ON t0.id = t1.id LEFT JOIN valueinshop_component_product_list t2 ON t0.id = t2.id LEFT JOIN valueinshop_component_text_content t3 ON t0.id = t3.id LEFT JOIN valueinshop_component_shop_list t4 ON t0.id = t4.id LEFT JOIN valueinshop_component_slider t5 ON t0.id = t5.id WHERE t0.enabled = ? AND ((t0.deleted = 0)) ORDER BY t0.priority ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT t0.language AS language_1, t0.title AS title_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_component_product_list_translation t0 WHERE t0.source_id = ? AND t0.language = ? AND ((t0.deleted = 0)) LIMIT 1"
  "params" => [
    1 => 1
    2 => "en"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.priority AS priority_1, t0.id AS id_2, t0.deleted AS deleted_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.uuid AS uuid_7, t0.product_filter_id AS product_filter_id_8 FROM valueinshop_cms_product_filter t0 INNER JOIN valueinshop_cms_productfilter_list ON t0.id = valueinshop_cms_productfilter_list.productfilter_id WHERE valueinshop_cms_productfilter_list.component_productlist_id = ? AND ((t0.deleted = 0))"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.short_description AS short_description_1, t0.rating AS rating_2, t0.sku AS sku_3, t0.position AS position_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, t0.uuid AS uuid_10, t0.title AS title_11, t0.description AS description_12, t0.product_type AS product_type_13, t0.provider_id AS provider_id_14, t0.tax_class_id AS tax_class_id_15, t0.upgrade_products_id AS upgrade_products_id_16, t0.downgrade_products_id AS downgrade_products_id_17, t0.included_products_id AS included_products_id_18, t0.excluded_products_id AS excluded_products_id_19, t0.related_product_id AS related_product_id_20, t0.gallery_id AS gallery_id_21, t0.subscription_strategy_override_id AS subscription_strategy_override_id_22, t0.shipping_strategy_id AS shipping_strategy_id_23, t0.product_options_id AS product_options_id_24, t0.image_id AS image_id_25, t27.name AS name_26, t27.description AS description_28, t27.enabled AS enabled_29, t27.provider_name AS provider_name_30, t27.provider_status AS provider_status_31, t27.provider_reference AS provider_reference_32, t27.provider_metadata AS provider_metadata_33, t27.width AS width_34, t27.height AS height_35, t27.length AS length_36, t27.content_type AS content_type_37, t27.content_size AS content_size_38, t27.copyright AS copyright_39, t27.author_name AS author_name_40, t27.context AS context_41, t27.cdn_is_flushable AS cdn_is_flushable_42, t27.cdn_flush_identifier AS cdn_flush_identifier_43, t27.cdn_flush_at AS cdn_flush_at_44, t27.cdn_status AS cdn_status_45, t27.updated_at AS updated_at_46, t27.created_at AS created_at_47, t27.uuid AS uuid_48, t27.id AS id_49, t0.entityType FROM valueinshop_product t0 LEFT JOIN valueinshop_media t27 ON t0.image_id = t27.id WHERE t0.entityType IN ('product') AND ((t0.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))"
]

[
  "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.short_description AS short_description_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.title AS title_8, t0.description AS description_9, t0.source_id AS source_id_10, t0.gallery_id AS gallery_id_11, t0.image_id AS image_id_12, t13.name AS name_14, t13.description AS description_15, t13.enabled AS enabled_16, t13.provider_name AS provider_name_17, t13.provider_status AS provider_status_18, t13.provider_reference AS provider_reference_19, t13.provider_metadata AS provider_metadata_20, t13.width AS width_21, t13.height AS height_22, t13.length AS length_23, t13.content_type AS content_type_24, t13.content_size AS content_size_25, t13.copyright AS copyright_26, t13.author_name AS author_name_27, t13.context AS context_28, t13.cdn_is_flushable AS cdn_is_flushable_29, t13.cdn_flush_identifier AS cdn_flush_identifier_30, t13.cdn_flush_at AS cdn_flush_at_31, t13.cdn_status AS cdn_status_32, t13.updated_at AS updated_at_33, t13.created_at AS created_at_34, t13.uuid AS uuid_35, t13.id AS id_36 FROM valueinshop_product_translation t0 LEFT JOIN valueinshop_media t13 ON t0.image_id = t13.id WHERE t0.source_id = ? AND t0.language = ? AND ((t0.deleted = 0)) LIMIT 1"
  "params" => [
    1 => 1
    2 => "en"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.short_description AS short_description_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.title AS title_8, t0.description AS description_9, t0.source_id AS source_id_10, t0.gallery_id AS gallery_id_11, t0.image_id AS image_id_12, t13.name AS name_14, t13.description AS description_15, t13.enabled AS enabled_16, t13.provider_name AS provider_name_17, t13.provider_status AS provider_status_18, t13.provider_reference AS provider_reference_19, t13.provider_metadata AS provider_metadata_20, t13.width AS width_21, t13.height AS height_22, t13.length AS length_23, t13.content_type AS content_type_24, t13.content_size AS content_size_25, t13.copyright AS copyright_26, t13.author_name AS author_name_27, t13.context AS context_28, t13.cdn_is_flushable AS cdn_is_flushable_29, t13.cdn_flush_identifier AS cdn_flush_identifier_30, t13.cdn_flush_at AS cdn_flush_at_31, t13.cdn_status AS cdn_status_32, t13.updated_at AS updated_at_33, t13.created_at AS created_at_34, t13.uuid AS uuid_35, t13.id AS id_36 FROM valueinshop_product_translation t0 LEFT JOIN valueinshop_media t13 ON t0.image_id = t13.id 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.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.product_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)) ORDER BY t0.position ASC"
  "params" => [
    1 => 1
  ]
  "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 => 1
    2 => "en"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "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.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.product_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)) ORDER BY t0.position ASC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "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.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.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.code AS code_1, t0.title AS title_2, t0.text AS text_3 FROM valueinshop_text t0 WHERE t0.code = ?"
  "params" => [
    1 => "homepage_footer_text"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.language AS language_1, t0.text AS text_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.source AS source_9 FROM valueinshop_text_translation t0 WHERE t0.source = ? AND t0.language = ? AND ((t0.deleted = 0)) LIMIT 1"
  "params" => [
    1 => "homepage_footer_text"
    2 => "en"
  ]
  "types" => [
    1 => 2
    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 => 1
  ]
  "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 => 1
    2 => "en"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

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

[
  "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.name AS name_1, t0.id AS id_2, t0.deleted AS deleted_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.uuid AS uuid_7 FROM valueinshop_product_tax_class t0 WHERE t0.id = ? AND ((t0.deleted = 0))"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.country AS country_1, t0.starting_date AS starting_date_2, t0.tax_rate AS tax_rate_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.uuid AS uuid_9, t0.tax_class_id AS tax_class_id_10 FROM valueinshop_tax_rates t0 WHERE t0.tax_class_id = ? AND ((t0.deleted = 0)) ORDER BY t0.starting_date ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

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

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