Symfony Profiler

[
  "params" => [
    "dbname" => "cashflow_devel"
    "host" => "mysql"
    "port" => "3306"
    "user" => "cashflow_devel"
    "password" => "<redacted>"
    "charset" => "utf8"
    "driver" => "pdo_mysql"
    "use_savepoints" => true
    "idle_connection_ttl" => 600
    "driverOptions" => [
      "EMULATE_PREPARES" => true
      2 => 3
      17 => true
    ]
    "serverVersion" => "5.7.44"
    "defaultTableOptions" => [
      "collate" => "utf8_unicode_ci"
    ]
  ]
]

[
  "sql" => "SELECT asetus AS db_name, arvo AS value FROM asetukset WHERE 1"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "Tiime\NewRelicBundle\Listener\RequestListener::setApplicationName"
]

[
  "event" => "kernel.request"
  "listener" => "Mcf\Core\NewRelic\NewRelicRequestListener::setCustomParameters"
]

[
  "event" => "kernel.request"
  "listener" => "Mcf\Core\NewRelic\NewRelicRequestListener::setBackgroundJob"
]

[
  "event" => "kernel.request"
  "listener" => "Mcf\Component\DeviceDetection\BotDetectionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Tiime\NewRelicBundle\Listener\RequestListener::setIgnoreTransaction"
]

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

[
  "event" => "kernel.request"
  "listener" => "Mcf\Core\Api\ApiValidateRequiredSchemeListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "Mcf\Core\Api\TrustedDomainListener::__invoke"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "Mcf\Component\ProductFeed\FacebookEventSubscriber::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" => "Mcf\Component\GoogleRecommendationsAi\Subscriber\GoogleRecommendationsCustomerEventSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Scheb\TwoFactorBundle\Security\TwoFactor\Event\TwoFactorFormListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Tiime\NewRelicBundle\Listener\RequestListener::setTransactionName"
]

[
  "event" => "kernel.controller"
  "listener" => "Mcf\Component\FlowPaywall\FlowPaywallControllerListener::__invoke"
]

[
  "event" => "kernel.controller"
  "listener" => "Mcf\Core\Api\ApiJsonPayloadControllerListener::__invoke"
]

[
  "event" => "kernel.controller"
  "listener" => "Mcf\Core\Extension\CustomPhpCustomizationEnabledControllerListener::__invoke"
]

[
  "event" => "kernel.controller"
  "listener" => "Mcf\Core\Extension\ExtensionEnabledControllerListener::__invoke"
]

[
  "event" => "kernel.controller"
  "listener" => "Mcf\Core\FeatureConfig\FeatureEnabledControllerListener::__invoke"
]

[
  "event" => "kernel.controller"
  "listener" => "Mcf\Core\Flow\FlowUrlControllerListener::__invoke"
]

[
  "event" => "kernel.controller"
  "listener" => "Mcf\Core\Security\PulseApiAuthControllerListener::__invoke"
]

[
  "event" => "kernel.controller"
  "listener" => "Mcf\Core\Security\UserPermissionControllerListener::__invoke"
]

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

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Container6w4SNHl\RequestPayloadValueResolverGhostF9259d2::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT code FROM versiot WHERE url = ? LIMIT 1"
  "params" => [
    1 => "ilkka.mcf.dev"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT muokattu AS updated_at, data FROM istunnot WHERE tunniste = ? AND IFNULL(poistettu, 0) = 0 LIMIT 1"
  "params" => [
    1 => "7or0hhchg56h0k4gl9aegde8s8"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "select * from istunnot where tunniste = ? limit 1"
  "params" => [
    1 => "7or0hhchg56h0k4gl9aegde8s8"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT muokattu AS updated_at, data FROM istunnot WHERE tunniste = ? AND IFNULL(poistettu, 0) = 0 LIMIT 1"
  "params" => [
    1 => "o2c0ekpulp2oisi03ae85km2g9"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT muokattu AS updated_at, data FROM istunnot WHERE tunniste = ? AND IFNULL(poistettu, 0) = 0 LIMIT 1"
  "params" => [
    1 => "o2c0ekpulp2oisi03ae85km2g9"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT versiot.id AS id, versiot.lisatty AS created_at, versiot.homepage_id AS homepage_id, versiot.muokattu AS updated_at, versiot.name AS name, versiot.code AS language, versiot.logo AS logo, versiot.favicon AS favicon, versiot.url AS url, versiot.use_ssl AS ssl_enabled, versiot.shopclosed AS is_closed, versiot.require_login AS is_login_required, versiot.shopname AS shop_name, versiot.shopemail AS shop_email, versiot.default_country AS default_country, versiot.default_currency AS default_currency, versiot.theme AS theme, versiot.theme_emails AS theme_emails, versiot.theme_prints AS theme_prints, versiot.theme_settings AS theme_settings, versiot.time_settings AS time_settings, versiot.notifications AS notifications, IF(ISNULL(versiot.minimum_order), NULL, IF(versiot.minimum_order <> 0, ROUND(versiot.minimum_order, 2), '0')) AS minimum_order, versiot.jnro AS sort, versiot.klevu_js_api_key AS klevu_js_api_key, versiot.klevu_rest_api_key AS klevu_rest_api_key, versiot.klevu_search_backend AS klevu_search_backend, versiot.privacy_page_id AS privacy_page_id, versiot.contact_information AS contact_information, versiot.company AS company, versiot.street_address_1 AS address_line_1, versiot.street_address_2 AS address_line_2, versiot.postal_code AS postal_code, versiot.post_office AS city, versiot.country AS country, versiot.phone AS phone, versiot.no_vat AS no_vat, versiot.internet AS internet, versiot.stock_location_id AS stock_location_id, versiot.preview_key AS preview_key, versiot.parent_id AS parent_id, versiot.type AS type FROM versiot WHERE url = ?"
  "params" => [
    1 => "ilkka.mcf.dev"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.shopclosed AS shopclosed_1, t0.shopclosed_info AS shopclosed_info_2, t0.lisatty AS lisatty_3, t0.require_login AS require_login_4, t0.default_country AS default_country_5, t0.default_currency AS default_currency_6, t0.poistettu AS poistettu_7, t0.homepage_id AS homepage_id_8, t0.id AS id_9, t0.klevu_js_api_key AS klevu_js_api_key_10, t0.klevu_rest_api_key AS klevu_rest_api_key_11, t0.klevu_search_backend AS klevu_search_backend_12, t0.code AS code_13, t0.logo AS logo_14, t0.favicon AS favicon_15, t0.name AS name_16, t0.notifications AS notifications_17, t0.no_vat AS no_vat_18, t0.minimum_order AS minimum_order_19, t0.preview_key AS preview_key_20, t0.privacy_page_id AS privacy_page_id_21, t0.reseller_terms AS reseller_terms_22, t0.use_ssl AS use_ssl_23, t0.shopemail AS shopemail_24, t0.shopname AS shopname_25, t0.jnro AS jnro_26, t0.terms_page_id AS terms_page_id_27, t0.theme AS theme_28, t0.theme_emails AS theme_emails_29, t0.theme_prints AS theme_prints_30, t0.theme_settings AS theme_settings_31, t0.time_settings AS time_settings_32, t0.type AS type_33, t0.muokattu AS muokattu_34, t0.url AS url_35, t0.using_redactor AS using_redactor_36, t0.vat_code AS vat_code_37, t0.bank_account AS bank_account_38, t0.post_office AS post_office_39, t0.company AS company_40, t0.country AS country_41, t0.contact_information AS contact_information_42, t0.email AS email_43, t0.fax AS fax_44, t0.internet AS internet_45, t0.phone AS phone_46, t0.postal_code AS postal_code_47, t0.street_address_1 AS street_address_1_48, t0.street_address_2 AS street_address_2_49, t0.parent_id AS parent_id_50, t0.price_list_id AS price_list_id_51, t0.stock_location_id AS stock_location_id_52 FROM versiot t0 WHERE t0.id = ?"
  "params" => [
    1 => "2"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT code AS kieli FROM versiot ORDER BY jnro, id"
]

[
  "sql" => "select kaytossa from laajennukset where koodi = 'CustomUrls'"
]

[
  "sql" => "select code from versiot where url = ?"
  "params" => [
    1 => "ilkka.mcf.dev"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "select code from versiot order by jnro, id asc"
]

[
  "sql" => "SELECT * FROM `versiot` LIMIT 1"
]

[
  "sql" => "SELECT id FROM versiot WHERE (ISNULL(poistettu) OR poistettu = 0) AND url = 'ilkka.mcf.dev' LIMIT 1"
]

[
  "sql" => "SELECT * FROM versiot WHERE id IN (2)"
]

[
  "sql" => "select nakyvilla from versiot_nakyvyydet where versio_id='2' AND objekti_tyyppi='CATEGORY' AND objekti_id='1'"
]

[
  "sql" => "SELECT code FROM maintenance WHERE completed > 0"
]

[
  "sql" => "SELECT koodi AS code, `en` AS translation FROM kielitiedosto WHERE `en` <> ''"
]

[
  "sql" => "SELECT koodi FROM laajennukset WHERE kaytossa = 1"
]

[
  "sql" => "SELECT id FROM istunnot WHERE tunniste = 'o2c0ekpulp2oisi03ae85km2g9' LIMIT 1"
]

[
  "sql" => "SELECT * FROM `ostoskorit` LIMIT 1"
]

[
  "sql" => "select koodi as code from laajennukset where kaytossa = 1"
]

[
  "sql" => "SELECT * FROM `ostoskorit_tuotteet` LIMIT 1"
]

[
  "sql" => "SELECT id FROM ostoskorit_tuotteet WHERE (ISNULL(poistettu) OR poistettu = 0) AND ostoskori_id = '0'"
]

[
  "sql" => "SELECT kampanjat.id AS id, kampanjat.lisatty AS created_at, kampanjat.muokattu AS updated_at, kampanjat.poistettu AS deleted_at, kampanjat.alkaa AS starts_at, kampanjat.paattyy AS ends_at, kampanjat.kampanjakoodi AS campaign_code, kampanjat.minimitilaus AS minimum_purchase, kampanjat.tuotealennukset AS product_discounts, kampanjat.maara_alennukset AS quantity_discounts, kampanjat.hinnoittelu_prosentti AS discount_percent, kampanjat.hinnoittelu_pyoristys_kerroin AS rounding_multiple, kampanjat.hinnoittelu_pyoristys_tarkenne AS rounding_operation, kampanjat.hinnoittelu_pyoristys_sievennys AS rounding_amount, kampanjat.toimitustavat AS shipping_method_ids, kampanjat.nollahinnat AS allow_zero_prices, kampanjat.alennusrivi AS discount_row, kampanjat.alennusrivi_kohde AS discount_row_target, kampanjat.alennusrivi_yksikko AS discount_row_type, kampanjat.alennusrivi_arvo AS discount_row_value, kampanjat.alennusrivi_tuoteraportti_id AS discount_row_product_report, kampanjat.enabled AS published, kampanjat.sivu AS page_enabled, kampanjat.kiinnitetty AS pinned, kampanjat.kuva AS image, kampanjat.linkki AS link, kampanjat.Template AS template, kampanjat.discount_type AS discount_type, kampanjat.tuotealennukset_yleinen AS generally_available, kampanjat.source_type AS source_type, kampanjat.source_id AS source_id FROM kampanjat WHERE (id IN (?, ?, ?)) AND (enabled = ?)"
  "params" => [
    1 => "1"
    2 => "2"
    3 => "3"
    4 => "1"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT id FROM kampanjat WHERE enabled = 1 AND IFNULL(alkaa, 0) <= UNIX_TIMESTAMP() AND (IFNULL(paattyy, 0) = 0 OR paattyy >= UNIX_TIMESTAMP())"
]

[
  "sql" => "SELECT id FROM kampanjat WHERE IFNULL(kampanjakoodi, '') = '' AND NOT EXISTS (SELECT * FROM kampanjat_koodit WHERE kampanja_id = kampanjat.id)"
]

[
  "sql" => "SELECT id FROM kampanjat WHERE NOT EXISTS (SELECT * FROM asiakasryhmat_nakyvyydet WHERE objekti_tyyppi = 'CAMPAIGN' AND objekti_id = kampanjat.id AND nakyvilla = 1)"
]

[
  "sql" => "SELECT t0.enabled AS enabled_1, t0.id AS id_2, t0.source_id AS source_id_3, t0.source_type AS source_type_4, t0.alkaa AS alkaa_5, t0.paattyy AS paattyy_6, t0.lisatty AS lisatty_7, t0.muokattu AS muokattu_8, t0.discount_type, t0.kampanjakoodi AS kampanjakoodi_9, t0.discount_rules AS discount_rules_10, t0.kampanjakoodi AS kampanjakoodi_11, t0.alennusrivi AS alennusrivi_12, t0.tuotealennukset AS tuotealennukset_13, t0.maara_alennukset AS maara_alennukset_14, t0.tuotealennukset_yleinen AS tuotealennukset_yleinen_15, t0.toimitustavat AS toimitustavat_16, t0.minimitilaus AS minimitilaus_17, t0.sivu AS sivu_18, t0.kiinnitetty AS kiinnitetty_19, t0.price_list_id AS price_list_id_20, t0.discount_rules AS discount_rules_21, t0.sivu AS sivu_22, t0.kiinnitetty AS kiinnitetty_23 FROM kampanjat t0 WHERE t0.id IN (?, ?) AND t0.discount_type IN ('DISCOUNT_CODES', 'FREE_SHIPPING', 'LEGACY', 'X_FOR_Y')"
  "params" => [
    1 => "2"
    2 => "3"
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT tuote_id FROM kampanjat_tuotteet WHERE kampanja_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM `osoitekirja` LIMIT 1"
]

[
  "sql" => "SELECT gift_cards.id AS id, gift_cards.created_at AS created_at, gift_cards.updated_at AS updated_at, gift_cards.deleted_at AS deleted_at, gift_cards.expires_at AS expires_at, gift_cards.source_type AS source_type, gift_cards.source_id AS source_id, gift_cards.code AS code, gift_cards.custom_code AS custom_code, gift_cards.balance AS balance, gift_cards.notes AS notes FROM gift_cards WHERE (gift_cards.deleted_at IS NULL) AND (id IN (NULL))"
  "params" => []
  "types" => []
]

[
  "sql" => "SELECT l0_.id AS id_0, l0_.published_at AS published_at_1, l0_.deleted_at AS deleted_at_2, l0_.settings AS settings_3, l0_.created_at AS created_at_4, l0_.updated_at AS updated_at_5 FROM loyalty_programs l0_ INNER JOIN loyalty_programs_versions l2_ ON l0_.id = l2_.loyalty_program_id INNER JOIN versiot v1_ ON v1_.id = l2_.version_id WHERE v1_.id = ? AND l0_.deleted_at IS NULL"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT ostoskorit.id AS id, ostoskorit.lisatty AS created_at, ostoskorit.muokattu AS updated_at, ostoskorit.istunto_id AS session_id, ostoskorit.ip_osoite AS session_ip, ostoskorit.asiakas_id AS customer_id, ostoskorit.tilaus_id AS order_id, ostoskorit.laskutusosoite_id AS customer_information_id, ostoskorit.toimitusosoite_id AS shipping_information_id, ostoskorit.toimitustapa_id AS shipping_method_id, ostoskorit.toimitustapa_tarkenne AS external_pickup_point_id, ostoskorit.lahjakortti_idt AS gift_card_ids, ostoskorit.maksutapa_id AS payment_method_id, ostoskorit.versio_id AS version_id, ostoskorit.kieli AS language, ostoskorit.kuponkikoodi AS coupon_code, ostoskorit.kampanjakoodi AS campaign_code, ostoskorit.lisatiedot AS details, ostoskorit.hinnat AS data, ostoskorit.custom_data AS custom_data FROM ostoskorit WHERE id = ?"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM versiot WHERE id = 2 LIMIT 1"
]

[
  "sql" => "SELECT * FROM versiot WHERE id = 2 LIMIT 1"
]

[
  "sql" => "SELECT kampanjat.id AS id, kampanjat.lisatty AS created_at, kampanjat.muokattu AS updated_at, kampanjat.poistettu AS deleted_at, kampanjat.alkaa AS starts_at, kampanjat.paattyy AS ends_at, kampanjat.kampanjakoodi AS campaign_code, kampanjat.minimitilaus AS minimum_purchase, kampanjat.tuotealennukset AS product_discounts, kampanjat.maara_alennukset AS quantity_discounts, kampanjat.hinnoittelu_prosentti AS discount_percent, kampanjat.hinnoittelu_pyoristys_kerroin AS rounding_multiple, kampanjat.hinnoittelu_pyoristys_tarkenne AS rounding_operation, kampanjat.hinnoittelu_pyoristys_sievennys AS rounding_amount, kampanjat.toimitustavat AS shipping_method_ids, kampanjat.nollahinnat AS allow_zero_prices, kampanjat.alennusrivi AS discount_row, kampanjat.alennusrivi_kohde AS discount_row_target, kampanjat.alennusrivi_yksikko AS discount_row_type, kampanjat.alennusrivi_arvo AS discount_row_value, kampanjat.alennusrivi_tuoteraportti_id AS discount_row_product_report, kampanjat.enabled AS published, kampanjat.sivu AS page_enabled, kampanjat.kiinnitetty AS pinned, kampanjat.kuva AS image, kampanjat.linkki AS link, kampanjat.Template AS template, kampanjat.discount_type AS discount_type, kampanjat.tuotealennukset_yleinen AS generally_available, kampanjat.source_type AS source_type, kampanjat.source_id AS source_id FROM kampanjat WHERE (id IN (?, ?, ?)) AND (enabled = ?)"
  "params" => [
    1 => "1"
    2 => "2"
    3 => "3"
    4 => "1"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT id FROM kampanjat WHERE enabled = 1 AND IFNULL(alkaa, 0) <= UNIX_TIMESTAMP() AND (IFNULL(paattyy, 0) = 0 OR paattyy >= UNIX_TIMESTAMP())"
]

[
  "sql" => "SELECT id FROM kampanjat WHERE IFNULL(kampanjakoodi, '') = '' AND NOT EXISTS (SELECT * FROM kampanjat_koodit WHERE kampanja_id = kampanjat.id)"
]

[
  "sql" => "SELECT id FROM kampanjat WHERE NOT EXISTS (SELECT * FROM asiakasryhmat_nakyvyydet WHERE objekti_tyyppi = 'CAMPAIGN' AND objekti_id = kampanjat.id AND nakyvilla = 1)"
]

[
  "sql" => "SELECT * FROM `kampanjat` LIMIT 1"
]

[
  "sql" => "SELECT id FROM kampanjat WHERE (ISNULL(poistettu) OR poistettu = 0) AND id IN ('2','3')"
]

[
  "sql" => "SELECT * FROM kampanjat WHERE id IN (2, 3)"
]

[
  "sql" => "SELECT * FROM `toimitustavat` LIMIT 1"
]

[
  "sql" => "SELECT id FROM toimitustavat WHERE (ISNULL(poistettu) OR poistettu = 0) AND id IN ('1','2','6','7','10','11','14','15','16','17','18','20','21','22','23','24','25','26','28','29','31','32','34','35','36','38','39','40','41','42','37','43','44','48','49','50','52','54','55','56','53','60','61','62','64','65','67','68','69','51','66','71','73','74','75','76','77','78','79','80','81','83','84','47','63','86','87','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','105','107','108','109','110','111')"
]

[
  "sql" => "SELECT * FROM toimitustavat WHERE id IN (1, 2, 111)"
]

[
  "sql" => "SELECT * FROM `maksutavat` LIMIT 1"
]

[
  "sql" => "SELECT id FROM maksutavat WHERE (ISNULL(poistettu) OR poistettu = 0) AND id IN ('3','4','5','6','11','12','27','29','30','31')"
]

[
  "sql" => "SELECT * FROM maksutavat WHERE id IN (3, 4, 5, 6, 11, 12, 27, 29, 30, 31)"
]

[
  "sql" => "SELECT * FROM `tuoteryhmat` LIMIT 1"
]

[
  "sql" => "SELECT * FROM tuoteryhmat WHERE id = 1 LIMIT 1"
]

[
  "sql" => "SELECT t0.shopclosed AS shopclosed_1, t0.shopclosed_info AS shopclosed_info_2, t0.lisatty AS lisatty_3, t0.require_login AS require_login_4, t0.default_country AS default_country_5, t0.default_currency AS default_currency_6, t0.poistettu AS poistettu_7, t0.homepage_id AS homepage_id_8, t0.id AS id_9, t0.klevu_js_api_key AS klevu_js_api_key_10, t0.klevu_rest_api_key AS klevu_rest_api_key_11, t0.klevu_search_backend AS klevu_search_backend_12, t0.code AS code_13, t0.logo AS logo_14, t0.favicon AS favicon_15, t0.name AS name_16, t0.notifications AS notifications_17, t0.no_vat AS no_vat_18, t0.minimum_order AS minimum_order_19, t0.preview_key AS preview_key_20, t0.privacy_page_id AS privacy_page_id_21, t0.reseller_terms AS reseller_terms_22, t0.use_ssl AS use_ssl_23, t0.shopemail AS shopemail_24, t0.shopname AS shopname_25, t0.jnro AS jnro_26, t0.terms_page_id AS terms_page_id_27, t0.theme AS theme_28, t0.theme_emails AS theme_emails_29, t0.theme_prints AS theme_prints_30, t0.theme_settings AS theme_settings_31, t0.time_settings AS time_settings_32, t0.type AS type_33, t0.muokattu AS muokattu_34, t0.url AS url_35, t0.using_redactor AS using_redactor_36, t0.vat_code AS vat_code_37, t0.bank_account AS bank_account_38, t0.post_office AS post_office_39, t0.company AS company_40, t0.country AS country_41, t0.contact_information AS contact_information_42, t0.email AS email_43, t0.fax AS fax_44, t0.internet AS internet_45, t0.phone AS phone_46, t0.postal_code AS postal_code_47, t0.street_address_1 AS street_address_1_48, t0.street_address_2 AS street_address_2_49, t0.parent_id AS parent_id_50, t0.price_list_id AS price_list_id_51, t0.stock_location_id AS stock_location_id_52 FROM versiot t0 WHERE t0.url = ? LIMIT 1"
  "params" => [
    1 => "ilkka.mcf.dev"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.shopclosed AS shopclosed_1, t0.shopclosed_info AS shopclosed_info_2, t0.lisatty AS lisatty_3, t0.require_login AS require_login_4, t0.default_country AS default_country_5, t0.default_currency AS default_currency_6, t0.poistettu AS poistettu_7, t0.homepage_id AS homepage_id_8, t0.id AS id_9, t0.klevu_js_api_key AS klevu_js_api_key_10, t0.klevu_rest_api_key AS klevu_rest_api_key_11, t0.klevu_search_backend AS klevu_search_backend_12, t0.code AS code_13, t0.logo AS logo_14, t0.favicon AS favicon_15, t0.name AS name_16, t0.notifications AS notifications_17, t0.no_vat AS no_vat_18, t0.minimum_order AS minimum_order_19, t0.preview_key AS preview_key_20, t0.privacy_page_id AS privacy_page_id_21, t0.reseller_terms AS reseller_terms_22, t0.use_ssl AS use_ssl_23, t0.shopemail AS shopemail_24, t0.shopname AS shopname_25, t0.jnro AS jnro_26, t0.terms_page_id AS terms_page_id_27, t0.theme AS theme_28, t0.theme_emails AS theme_emails_29, t0.theme_prints AS theme_prints_30, t0.theme_settings AS theme_settings_31, t0.time_settings AS time_settings_32, t0.type AS type_33, t0.muokattu AS muokattu_34, t0.url AS url_35, t0.using_redactor AS using_redactor_36, t0.vat_code AS vat_code_37, t0.bank_account AS bank_account_38, t0.post_office AS post_office_39, t0.company AS company_40, t0.country AS country_41, t0.contact_information AS contact_information_42, t0.email AS email_43, t0.fax AS fax_44, t0.internet AS internet_45, t0.phone AS phone_46, t0.postal_code AS postal_code_47, t0.street_address_1 AS street_address_1_48, t0.street_address_2 AS street_address_2_49, t0.parent_id AS parent_id_50, t0.price_list_id AS price_list_id_51, t0.stock_location_id AS stock_location_id_52 FROM versiot t0 WHERE t0.url = ? LIMIT 1"
  "params" => [
    1 => "ilkka.mcf.dev"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT maksutavat.id AS id, maksutavat.lisatty AS created_at, maksutavat.muokattu AS updated_at, maksutavat.poistettu AS deleted_at, maksutavat.maksupalvelu AS provider_id, maksutavat.provider_settings AS provider_settings, maksutavat.kayttajatunnus AS username, maksutavat.salasana AS password, maksutavat.tuotenumero AS product_code, maksutavat.jnro AS sort, maksutavat.logo AS logo, maksutavat.maksukulut_kiinteat AS fixed_costs, maksutavat.maksukulut_muuttuvat AS variable_costs, maksutavat.using_redactor AS using_redactor, maksutavat.enabled AS published, maksutavat.nimi_en AS name_en, maksutavat.nimi_fi AS name_fi, maksutavat.selite_en AS description_en, maksutavat.selite_fi AS description_fi, maksutavat.maksuohje_en AS help_en, maksutavat.maksuohje_fi AS help_fi FROM maksutavat WHERE (IFNULL(poistettu, 0) = 0) AND (maksupalvelu = ?)"
  "params" => [
    1 => "KCO_V3"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT kampanjat.id AS id, kampanjat.lisatty AS created_at, kampanjat.muokattu AS updated_at, kampanjat.poistettu AS deleted_at, kampanjat.alkaa AS starts_at, kampanjat.paattyy AS ends_at, kampanjat.kampanjakoodi AS campaign_code, kampanjat.minimitilaus AS minimum_purchase, kampanjat.tuotealennukset AS product_discounts, kampanjat.maara_alennukset AS quantity_discounts, kampanjat.hinnoittelu_prosentti AS discount_percent, kampanjat.hinnoittelu_pyoristys_kerroin AS rounding_multiple, kampanjat.hinnoittelu_pyoristys_tarkenne AS rounding_operation, kampanjat.hinnoittelu_pyoristys_sievennys AS rounding_amount, kampanjat.toimitustavat AS shipping_method_ids, kampanjat.nollahinnat AS allow_zero_prices, kampanjat.alennusrivi AS discount_row, kampanjat.alennusrivi_kohde AS discount_row_target, kampanjat.alennusrivi_yksikko AS discount_row_type, kampanjat.alennusrivi_arvo AS discount_row_value, kampanjat.alennusrivi_tuoteraportti_id AS discount_row_product_report, kampanjat.enabled AS published, kampanjat.sivu AS page_enabled, kampanjat.kiinnitetty AS pinned, kampanjat.kuva AS image, kampanjat.linkki AS link, kampanjat.Template AS template, kampanjat.discount_type AS discount_type, kampanjat.tuotealennukset_yleinen AS generally_available, kampanjat.source_type AS source_type, kampanjat.source_id AS source_id FROM kampanjat WHERE (id IN (?, ?, ?)) AND (enabled = ?)"
  "params" => [
    1 => "1"
    2 => "2"
    3 => "3"
    4 => "1"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT id FROM kampanjat WHERE enabled = 1 AND IFNULL(alkaa, 0) <= UNIX_TIMESTAMP() AND (IFNULL(paattyy, 0) = 0 OR paattyy >= UNIX_TIMESTAMP())"
]

[
  "sql" => "SELECT id FROM kampanjat WHERE IFNULL(kampanjakoodi, '') = '' AND NOT EXISTS (SELECT * FROM kampanjat_koodit WHERE kampanja_id = kampanjat.id)"
]

[
  "sql" => "SELECT id FROM kampanjat WHERE NOT EXISTS (SELECT * FROM asiakasryhmat_nakyvyydet WHERE objekti_tyyppi = 'CAMPAIGN' AND objekti_id = kampanjat.id AND nakyvilla = 1)"
]

[
  "sql" => "SELECT banneriryhmat.id AS id, banneriryhmat.lisatty AS created_at, banneriryhmat.muokattu AS updated_at, banneriryhmat.poistettu AS deleted_at, banneriryhmat.koodi AS code, banneriryhmat.nimi_en AS title_en, banneriryhmat.nimi_fi AS title_fi FROM banneriryhmat"
]

[
  "sql" => "SELECT bannerit.id AS id, bannerit.lisatty AS created_at, bannerit.muokattu AS updated_at, bannerit.poistettu AS deleted_at, bannerit.ryhma AS group_id, bannerit.jnro AS sort, bannerit.koodi AS code, bannerit.alkaa AS visible_from, bannerit.paattyy AS visible_to, bannerit.banneri AS file, bannerit.using_redactor AS using_redactor, bannerit.nimi_en AS title_en, bannerit.nimi_fi AS title_fi, bannerit.teksti_en AS content_en, bannerit.teksti_fi AS content_fi, bannerit.linkki_en AS link_en, bannerit.linkki_fi AS link_fi FROM bannerit WHERE (IFNULL(poistettu, 0) = 0) AND (id IN (?)) AND ((IFNULL(alkaa, 0) = 0 OR alkaa < 1765038669)) AND ((IFNULL(paattyy, 0) = 0 OR paattyy > 1765038669)) ORDER BY jnro ASC"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT id FROM versiot WHERE (ISNULL(poistettu) OR poistettu = 0) AND shopclosed = '0' ORDER BY jnro ASC"
]

[
  "sql" => "SELECT * FROM versiot WHERE id IN (1, 2)  ORDER BY jnro ASC"
]

[
  "sql" => "SELECT ostoskorit_tuotteet.id AS id, ostoskorit_tuotteet.lisatty AS created_at, ostoskorit_tuotteet.muokattu AS updated_at, ostoskorit_tuotteet.ostoskori_id AS cart_id, ostoskorit_tuotteet.tuotepaketti_id AS bundle_id, ostoskorit_tuotteet.tuote_id AS product_id, ostoskorit_tuotteet.variaatio_id AS variation_id, ostoskorit_tuotteet.lataus_id AS download_id, ostoskorit_tuotteet.valinnat AS customizations, ostoskorit_tuotteet.maara AS quantity, ostoskorit_tuotteet.tuotepaketti_joukko AS bundle_set, ostoskorit_tuotteet.hintasaannot AS data, ostoskorit_tuotteet.custom_data AS custom_data FROM ostoskorit_tuotteet WHERE ostoskori_id IN (NULL)"
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT tuoteryhmat.*\n
    \t\t\t\tFROM versiot_nakyvyydet\n
    \t\t\t\t\tJOIN tuoteryhmat\n
    \t\t\t\t\t\tON versiot_nakyvyydet.versio_id = ?\n
    \t\t\t\t\t\tAND versiot_nakyvyydet.nakyvilla = '1'\n
    \t\t\t\t\t\tAND versiot_nakyvyydet.objekti_tyyppi = 'CATEGORY'\n
    \t\t\t\t\t\tAND versiot_nakyvyydet.objekti_id = tuoteryhmat.id
    """
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT id FROM kampanjat WHERE (ISNULL(poistettu) OR poistettu = 0)"
]

[
  "sql" => "select id from kampanjat where kiinnitetty = 1 and id in ('1','2','3')"
]

[
  "sql" => "SELECT id FROM kampanjat WHERE enabled = 1 AND IFNULL(alkaa, 0) <= UNIX_TIMESTAMP() AND (IFNULL(paattyy, 0) = 0 OR paattyy >= UNIX_TIMESTAMP())"
]

[
  "sql" => """
    SELECT kampanjat.id\n
    \t\t\t\tFROM kampanjat\n
    \t\t\t\tJOIN versiot_nakyvyydet\n
    \t\t\t\t\tON kampanjat.enabled = 1\n
    \t\t\t\t\tAND versio_id = 2\n
    \t\t\t\t\tAND objekti_tyyppi = 'CAMPAIGN'\n
    \t\t\t\t\tAND objekti_id = kampanjat.id\n
    \t\t\t\t\tAND versiot_nakyvyydet.nakyvilla = 1
    """
]

[
  "sql" => "select id from kampanjat where sivu = 1 and id in ('1','2','3')"
]

[
  "sql" => "SELECT id, parent AS parent_id FROM infosivut WHERE id IN (1,2) ORDER BY jnro ASC"
]

[
  "sql" => "SELECT infosivut.id AS id, infosivut.lisatty AS created_at, infosivut.muokattu AS updated_at, infosivut.poistettu AS deleted_at, infosivut.parent AS parent, infosivut.jnro AS sort, infosivut.kuva AS image, infosivut.Template AS template, infosivut.using_redactor AS using_redactor, infosivut.nimi_en AS name_en, infosivut.nimi_fi AS name_fi, infosivut.teksti_en AS content_en, infosivut.teksti_fi AS content_fi, infosivut.linkki_en AS link_en, infosivut.linkki_fi AS link_fi, infosivut.Title_en AS seo_title_en, infosivut.Title_fi AS seo_title_fi, infosivut.PageTitle_en AS seo_page_title_en, infosivut.PageTitle_fi AS seo_page_title_fi, infosivut.MetaDescription_en AS seo_meta_description_en, infosivut.MetaDescription_fi AS seo_meta_description_fi FROM infosivut WHERE id IN (?, ?)"
  "params" => [
    1 => "1"
    2 => "2"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT id, nimi_en       AS name FROM infosivut WHERE id IN('1','2')"
]

[
  "sql" => "SELECT id, parent AS parent_id FROM infosivut WHERE id IN (1,2) ORDER BY jnro ASC"
]

[
  "sql" => "SELECT infosivut.id AS id, infosivut.lisatty AS created_at, infosivut.muokattu AS updated_at, infosivut.poistettu AS deleted_at, infosivut.parent AS parent, infosivut.jnro AS sort, infosivut.kuva AS image, infosivut.Template AS template, infosivut.using_redactor AS using_redactor, infosivut.nimi_en AS name_en, infosivut.nimi_fi AS name_fi, infosivut.teksti_en AS content_en, infosivut.teksti_fi AS content_fi, infosivut.linkki_en AS link_en, infosivut.linkki_fi AS link_fi, infosivut.Title_en AS seo_title_en, infosivut.Title_fi AS seo_title_fi, infosivut.PageTitle_en AS seo_page_title_en, infosivut.PageTitle_fi AS seo_page_title_fi, infosivut.MetaDescription_en AS seo_meta_description_en, infosivut.MetaDescription_fi AS seo_meta_description_fi FROM infosivut WHERE id IN (?, ?)"
  "params" => [
    1 => "1"
    2 => "2"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT id, nimi_en       AS name FROM infosivut WHERE id IN('1','2')"
]

[
  "event" => "kernel.response"
  "listener" => "Scheb\TwoFactorBundle\Security\TwoFactor\Provider\TwoFactorProviderPreparationListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Mcf\Core\Security\ResponseListener::__invoke"
]

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

[
  "event" => "kernel.response"
  "listener" => "Mcf\Component\Analytics\AmplitudeEventSubscriber::onKernelTerminate"
]

[
  "event" => "kernel.response"
  "listener" => "Mcf\Component\CampaignMonitor\CampaignMonitorEventSubscriber::onKernelTerminate"
]

[
  "event" => "kernel.response"
  "listener" => "Mcf\Component\ElasticAppSearch\ElasticAppSearchEventSubscriber::onKernelTerminate"
]

[
  "event" => "kernel.response"
  "listener" => "Mcf\Component\ElasticAppSearch\ElasticAppSearchIndexingEventSubscriber::onKernelTerminate"
]

[
  "event" => "kernel.response"
  "listener" => "Mcf\Component\ElectronicShelfLabel\EwqSyncEventSubscriber::onKernelTerminate"
]

[
  "event" => "kernel.response"
  "listener" => "Mcf\Component\Flow\EventListener\OrderChangedToOpenStateEventSubscriber::onKernelTerminate"
]

[
  "event" => "kernel.response"
  "listener" => "Mcf\Component\Flow\EventListener\ProductReviewChangedToNewStateEventSubscriber::onKernelTerminate"
]

[
  "event" => "kernel.response"
  "listener" => "Mcf\Component\GoogleRecommendationsAi\Subscriber\GoogleRecommendationsCustomerEventSubscriber::onKernelTerminate"
]

[
  "event" => "kernel.response"
  "listener" => "Mcf\Component\ProductFeed\ProductFeedTaskEventSubscriber::onKernelTerminate"
]

[
  "event" => "kernel.response"
  "listener" => "Mcf\Component\ProductSearch\EventListener\RefreshSortByNameOnProductUpdatedEventSubscriber::onKernelTerminate"
]

[
  "event" => "kernel.response"
  "listener" => "Mcf\Component\Webhook\WebhookEventSubscriber::onKernelTerminate"
]

[
  "event" => "kernel.response"
  "listener" => "Mcf\Extensions\Verkkologistiikka\VerkkologistiikkaUpdateEventSubscriber::onKernelTerminate"
]

[
  "event" => "kernel.response"
  "listener" => "Mcf\Legacy\Component\Product\AvailabilityNotificationSendRequestedEventSubscriber::onKernelTerminate"
]

[
  "event" => "kernel.response"
  "listener" => "Mcf\Legacy\Component\Product\SendAvailabilitynotificationsWhenStockItemUpdatedEventSubscriber::onKernelTerminate"
]

[
  "event" => "kernel.response"
  "listener" => "Mcf\Legacy\EventListener\InvalidateCachesOnLegacyModelUpdatedEventSubscriber::onKernelTerminate"
]

[
  "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" => "Mcf\Component\ProductFeed\FacebookEventSubscriber::onKernelResponse"
]

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

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

[
  "event" => "kernel.response"
  "listener" => "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" => "Tiime\NewRelicBundle\Listener\ResponseListener::onKernelResponse"
]

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

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

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

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

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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