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

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

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

[
  "sql" => "SELECT muokattu AS updated_at, data FROM istunnot WHERE tunniste = ? AND IFNULL(poistettu, 0) = 0 LIMIT 1"
  "params" => [
    1 => "g766l9anp13b42lnmu2h83m1pb"
  ]
  "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 = 'g766l9anp13b42lnmu2h83m1pb' 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 `tuoteryhmat` LIMIT 1"
]

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

[
  "sql" => "SELECT product_attributes.id AS id, product_attributes.created_at AS created_at, product_attributes.updated_at AS updated_at, product_attributes.code AS code, product_attributes.sort AS sort, product_attributes.filterable AS filterable, product_attributes.listable AS listable FROM product_attributes WHERE filterable = ? ORDER BY sort ASC"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT tuoteryhmat.id AS id, tuoteryhmat.lisatty AS created_at, tuoteryhmat.muokattu AS updated_at, tuoteryhmat.parent AS parent_id, tuoteryhmat.jnro AS parent_sort, tuoteryhmat.tyyppi AS type, tuoteryhmat.external_id AS external_id, tuoteryhmat.featured AS featured, tuoteryhmat.kuva AS image, tuoteryhmat.Template AS template, tuoteryhmat.tuoteryhma_en AS name_en, tuoteryhmat.tuoteryhma_fi AS name_fi, tuoteryhmat.kuvaus_en AS description_en, tuoteryhmat.kuvaus_fi AS description_fi, tuoteryhmat.Title_en AS seo_title_en, tuoteryhmat.Title_fi AS seo_title_fi, tuoteryhmat.PageTitle_en AS seo_page_title_en, tuoteryhmat.PageTitle_fi AS seo_page_title_fi, tuoteryhmat.MetaDescription_en AS seo_meta_description_en, tuoteryhmat.MetaDescription_fi AS seo_meta_description_fi FROM tuoteryhmat WHERE id = ?"
  "params" => [
    1 => "2"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT product_attributes.id AS id, product_attributes.created_at AS created_at, product_attributes.updated_at AS updated_at, product_attributes.code AS code, product_attributes.sort AS sort, product_attributes.filterable AS filterable, product_attributes.listable AS listable FROM product_attributes WHERE filterable = ? ORDER BY sort ASC"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "Mcf\Component\Analytics\Event\CategoryPageViewedEvent"
  "listener" => "Mcf\Component\GoogleRecommendationsAi\Subscriber\GoogleRecommendationsCustomerEventSubscriber::onAnalyticsEvent"
]

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

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

[
  "sql" => "SELECT id, parent AS parent_id FROM tuoteryhmat"
]

[
  "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 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 id, parent AS parent_id FROM tuoteryhmat"
]

[
  "sql" => "SELECT id, tuoteryhma_en AS name FROM tuoteryhmat WHERE id IN('2')"
]

[
  "sql" => "SELECT t0.code AS code_1, t0.consumable AS consumable_2, t0.id AS id_3, t0.logged AS logged_4, t0.name AS name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM stock_locations t0 WHERE t0.code = ? LIMIT 1"
  "params" => [
    1 => "_mycashflow"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT parent.id                            parent_id,\n
    \t\t\t\t       GROUP_CONCAT(child.id ORDER BY child.jnro SEPARATOR ',') child_ids\n
    \t\t\t\tFROM tuoteryhmat parent\n
    \t\t\t\t         JOIN tuoteryhmat child\n
    \t\t\t\t              ON parent.id = child.parent\n
    \t\t\t\t         LEFT JOIN versiot_nakyvyydet parent_visibilities\n
    \t\t\t\t                   ON parent_visibilities.versio_id = :version_id\n
    \t\t\t\t                       AND parent_visibilities.objekti_tyyppi = 'CATEGORY'\n
    \t\t\t\t                       AND parent_visibilities.objekti_id = parent.id\n
    \t\t\t\t         LEFT JOIN versiot_nakyvyydet child_visibilities\n
    \t\t\t\t                   ON child_visibilities.versio_id = :version_id\n
    \t\t\t\t                       AND child_visibilities.objekti_tyyppi = 'CATEGORY'\n
    \t\t\t\t                       AND child_visibilities.objekti_id = child.id\n
    \t\t\t\tWHERE parent.id != child.id\n
    \t\t\t\t  AND parent_visibilities.nakyvilla = 1\n
    \t\t\t\t  AND child_visibilities.nakyvilla = 1\n
    \t\t\t\tGROUP BY parent_id
    """
  "params" => [
    "version_id" => 2
  ]
  "types" => [
    "version_id" => 2
  ]
]

[
  "sql" => """
    \n
    \t\t\t\tSELECT CONCAT(tuotteet.id, '-0')\n
    \t\t\t\tFROM tuoteryhmat_tuotteet\n
    \t\t\t\t\tINNER JOIN tuotteet ON tuoteryhmat_tuotteet.tuote_id = tuotteet.id\n
    \t\t\t\tWHERE tuoteryhmat_tuotteet.tuoteryhma_id IN (2)\n
    \t\t\t
    """
]

[
  "sql" => """
    \n
    \t\t\t\tSELECT CONCAT(tuotteet.id, '-0')\n
    \t\t\t\tFROM tuoteryhmat_tuotteet\n
    \t\t\t\t\tINNER JOIN tuotteet ON tuoteryhmat_tuotteet.tuote_id = tuotteet.id\n
    \t\t\t\tWHERE tuoteryhmat_tuotteet.tuoteryhma_id IN (2)\n
    \t\t\t
    """
]

[
  "sql" => """
    \n
    \t\t\t\tSELECT CONCAT(tuotteet.id, '-0')\n
    \t\t\t\tFROM tuotteet\n
    \t\t\t\t\tLEFT JOIN tuoteryhmat_tuotteet\n
    \t\t\t\t\t\tON tuotteet.id = tuoteryhmat_tuotteet.tuote_id\n
    \t\t\t\tWHERE tuoteryhmat_tuotteet.tuoteryhma_id = ?\n
    \t\t\t\tORDER BY tuoteryhmat_tuotteet.tuote_jnro ASC,\n
    \t\t\t\t         tuoteryhmat_tuotteet.id DESC\n
    \t\t\t
    """
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT * FROM tuotteet WHERE id IN ('2') ORDER BY FIND_IN_SET(id, '2')"
]

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

[
  "sql" => "SELECT * FROM variaatiot WHERE tuotteet_id IN ('2') ORDER BY jnro"
]

[
  "sql" => "SELECT * FROM lataukset WHERE tuote_id IN ('2') ORDER BY jnro"
]

[
  "sql" => """
    SELECT tuotekuvat.*, tuotteet_mediat.tuote_id as tuote_id\n
    \t\t\t\tFROM tuotekuvat\n
    \t\t\t\tLEFT JOIN tuotteet_mediat ON tuotekuvat.id = tuotteet_mediat.tuotekuva_id\n
    \t\t\t\tWHERE tuotteet_mediat.tuote_id IN ('2')\n
    \t\t\t\tORDER BY jnro
    """
]

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

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

[
  "sql" => """
    SELECT tuotevalinnat.*, tuotteet_valinnat.tuote_id as tuote_id\n
    \t\t\t\tFROM tuotevalinnat\n
    \t\t\t\tLEFT JOIN tuotteet_valinnat ON tuotevalinnat.id = tuotteet_valinnat.valinta_id\n
    \t\t\t\tWHERE tuotteet_valinnat.vaihtoehto_id = 0\n
    \t\t\t\tAND tuotteet_valinnat.tuote_id IN ('2')\n
    \t\t\t\tORDER BY valinta_jnro
    """
]

[
  "sql" => """
    SELECT tuotemerkit.*, tuotteet.id as tuote_id\n
    \t\t        FROM tuotteet\n
    \t\t        LEFT JOIN tuotemerkit ON tuotemerkit.id = tuotteet.tuotemerkki\n
    \t\t        WHERE tuotteet.tuotemerkki > 0 AND tuotteet.id IN ('2')
    """
]

[
  "sql" => "SELECT tuotteet.id AS id, tuotteet.lisatty AS created_at, tuotteet.muokattu AS updated_at, tuotteet.ean AS ean, tuotteet.oma_tuotenumero AS product_code, tuotteet.toimittajan_tuotenumero AS supplier_code, tuotteet.avainsanat AS keywords, IF(ISNULL(tuotteet.hinta), NULL, IF(tuotteet.hinta <> 0, ROUND(tuotteet.hinta, 2), '0')) AS price, IF(ISNULL(tuotteet.ostohinta), NULL, IF(tuotteet.ostohinta <> 0, ROUND(tuotteet.ostohinta, 2), '0')) AS purchase_price, tuotteet.verokanta AS vat_rate, tuotteet.paino AS weight, tuotteet.postituskoko AS parcel_type, tuotteet.takuu AS warranty, tuotteet.tuotemerkki AS brand_id, tuotteet.toimittaja AS supplier_id, tuotteet.stock_item_id AS stock_item_id, tuotteet.saatavuus_alkaa AS available_from, tuotteet.saatavuus_paattyy AS available_to, tuotteet.using_redactor AS using_redactor, tuotteet.mainosta AS featured, tuotteet.julkaisu_nakyville AS visible_from, tuotteet.julkaisu_myyntiin AS purchasable_from, tuotteet.tilausrajoitus AS order_limit, tuotteet.tilausrajoitus_min AS order_limit_min, tuotteet.Template AS template, tuotteet.tuotetyyppi AS type, tuotteet.lahjakortti_aika AS gift_card_expires_after_months, tuotteet.google_category_id AS google_category_id, tuotteet.age_group AS age_group, tuotteet.gender AS gender, tuotteet.notes AS notes, tuotteet.adult AS adult, tuotteet.average_rating AS average_rating, tuotteet.approved_reviews_count AS approved_reviews_count, tuotteet.shipping_additional_features AS shipping_additional_features, tuotteet.tuotenimi_en AS name_en, tuotteet.tuotenimi_fi AS name_fi, tuotteet.tuotekuvaus_en AS description_en, tuotteet.tuotekuvaus_fi AS description_fi, tuotteet.tuotetiedot_en AS information_en, tuotteet.tuotetiedot_fi AS information_fi, tuotteet.Title_en AS seo_title_en, tuotteet.Title_fi AS seo_title_fi, tuotteet.PageTitle_en AS seo_page_title_en, tuotteet.PageTitle_fi AS seo_page_title_fi, tuotteet.MetaDescription_en AS seo_meta_description_en, tuotteet.MetaDescription_fi AS seo_meta_description_fi FROM tuotteet WHERE id IN (?)"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT tuotekuvat.id AS id, tuotekuvat.lisatty AS created_at, tuotekuvat.muokattu AS updated_at, tuotekuvat.tiedosto AS filename, tuotekuvat.kuvateksti_en AS caption_en, tuotekuvat.kuvateksti_fi AS caption_fi FROM tuotekuvat WHERE id IN (?)"
  "params" => [
    1 => "6"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT id, tuotenimi_en  AS name FROM tuotteet WHERE id IN('2')"
]

[
  "sql" => "SELECT t0_.saatavuus_alkaa AS saatavuus_alkaa_0, t0_.saatavuus_paattyy AS saatavuus_paattyy_1, t0_.average_rating AS average_rating_2, t0_.approved_reviews_count AS approved_reviews_count_3, t0_.oma_tuotenumero AS oma_tuotenumero_4, t0_.lisatty AS lisatty_5, t0_.id AS id_6, t0_.tuotetiedot_fi AS tuotetiedot_fi_7, t0_.tuotenimi_fi AS tuotenimi_fi_8, t0_.hinta AS hinta_9, t0_.MetaDescription_fi AS MetaDescription_fi_10, t0_.PageTitle_fi AS PageTitle_fi_11, t0_.Title_fi AS Title_fi_12, t0_.tuotekuvaus_fi AS tuotekuvaus_fi_13, t0_.toimittajan_tuotenumero AS toimittajan_tuotenumero_14, t0_.muokattu AS muokattu_15, t0_.verokanta AS verokanta_16, t0_.using_redactor AS using_redactor_17, t0_.lahjakortti_aika AS lahjakortti_aika_18, s1_.backorder_enabled AS backorder_enabled_19, s1_.backorder_estimate AS backorder_estimate_20, s1_.balance_limit AS balance_limit_21, s1_.barcode AS barcode_22, s1_.country_of_origin AS country_of_origin_23, s1_.customs_tariff_code AS customs_tariff_code_24, s1_.deleted_at AS deleted_at_25, s1_.enabled AS enabled_26, s1_.id AS id_27, s1_.location AS location_28, s1_.quantity AS quantity_29, s1_.sku AS sku_30, s1_.created_at AS created_at_31, s1_.updated_at AS updated_at_32, s2_.id AS id_33, s2_.quantity AS quantity_34, s2_.created_at AS created_at_35, s2_.updated_at AS updated_at_36, s3_.expires_at AS expires_at_37, s3_.id AS id_38, s3_.quantity AS quantity_39, s3_.source_type AS source_type_40, s3_.source_id AS source_id_41, s3_.created_at AS created_at_42, s3_.updated_at AS updated_at_43, v4_.tuotenumero AS tuotenumero_44, v4_.id AS id_45, v4_.nimi_fi AS nimi_fi_46, v4_.hinta AS hinta_47, v4_.ostohinta AS ostohinta_48, v4_.jnro AS jnro_49, v4_.lisatty AS lisatty_50, v4_.muokattu AS muokattu_51, s5_.backorder_enabled AS backorder_enabled_52, s5_.backorder_estimate AS backorder_estimate_53, s5_.balance_limit AS balance_limit_54, s5_.barcode AS barcode_55, s5_.country_of_origin AS country_of_origin_56, s5_.customs_tariff_code AS customs_tariff_code_57, s5_.deleted_at AS deleted_at_58, s5_.enabled AS enabled_59, s5_.id AS id_60, s5_.location AS location_61, s5_.quantity AS quantity_62, s5_.sku AS sku_63, s5_.created_at AS created_at_64, s5_.updated_at AS updated_at_65, s6_.id AS id_66, s6_.quantity AS quantity_67, s6_.created_at AS created_at_68, s6_.updated_at AS updated_at_69, s7_.expires_at AS expires_at_70, s7_.id AS id_71, s7_.quantity AS quantity_72, s7_.source_type AS source_type_73, s7_.source_id AS source_id_74, s7_.created_at AS created_at_75, s7_.updated_at AS updated_at_76, t0_.tuotetyyppi AS tuotetyyppi_77, t0_.tuotemerkki AS tuotemerkki_78, t0_.toimittaja AS toimittaja_79, t0_.stock_item_id AS stock_item_id_80, s2_.stock_item_id AS stock_item_id_81, s2_.stock_location_id AS stock_location_id_82, s3_.stock_item_id AS stock_item_id_83, s3_.stock_location_id AS stock_location_id_84, v4_.tuotteet_id AS tuotteet_id_85, v4_.stock_item_id AS stock_item_id_86, s6_.stock_item_id AS stock_item_id_87, s6_.stock_location_id AS stock_location_id_88, s7_.stock_item_id AS stock_item_id_89, s7_.stock_location_id AS stock_location_id_90 FROM tuotteet t0_ LEFT JOIN stock_items s1_ ON t0_.stock_item_id = s1_.id LEFT JOIN stock_item_quantities s2_ ON s1_.id = s2_.stock_item_id LEFT JOIN stock_item_reservations s3_ ON s1_.id = s3_.stock_item_id LEFT JOIN variaatiot v4_ ON t0_.id = v4_.tuotteet_id LEFT JOIN stock_items s5_ ON v4_.stock_item_id = s5_.id LEFT JOIN stock_item_quantities s6_ ON s5_.id = s6_.stock_item_id LEFT JOIN stock_item_reservations s7_ ON s5_.id = s7_.stock_item_id WHERE (t0_.id IN (?)) AND t0_.tuotetyyppi IN ('NORMAL', 'GIFT_CARD')"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.entity FROM custom_attributes t0 WHERE t0.type = ? AND t0.entity IN ('PRODUCT')"
  "params" => [
    1 => "SHORT_TEXT"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.entity FROM custom_attributes t0 WHERE t0.type = ? AND t0.entity IN ('PRODUCT') LIMIT 1"
  "params" => [
    1 => "SHORT_TEXT"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.value AS value_1, t0.id AS id_2, t0.entity_id AS entity_id_3, t0.custom_attribute_id AS custom_attribute_id_4 FROM custom_attribute_value_short_text t0 WHERE t0.custom_attribute_id = ? AND t0.entity_id IN (?)"
  "params" => [
    1 => 4
    2 => 2
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.code AS code_1, t0.consumable AS consumable_2, t0.id AS id_3, t0.logged AS logged_4, t0.name AS name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM stock_locations t0 WHERE t0.code = ? LIMIT 1"
  "params" => [
    1 => "_mycashflow"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT k.id\n
    FROM kampanjat k\n
    \tJOIN versiot_nakyvyydet vn\n
    \t\tON vn.objekti_tyyppi = 'CAMPAIGN'\n
    \t\tAND vn.objekti_id = k.id\n
    \t\tAND vn.versio_id = :versio_id\n
    \t\tAND vn.nakyvilla = 1\n
    WHERE k.enabled = 1\n
    \tAND k.tuotealennukset = 1\n
    \tAND k.tuotealennukset_yleinen = 1\n
    \tAND k.paattyy < UNIX_TIMESTAMP(CURRENT_TIMESTAMP())\n
    \tAND k.paattyy > UNIX_TIMESTAMP(CURRENT_TIMESTAMP() - INTERVAL 30 DAY)
    """
  "params" => [
    "versio_id" => "2"
  ]
  "types" => [
    "versio_id" => 2
  ]
]

[
  "sql" => """
    SELECT 'PRODUCT'       AS type,\n
    \t\t\t       id              AS product_id,\n
    \t\t\t       verokanta       AS tax_rate,\n
    \t\t\t       NULL            AS variation_id,\n
    \t\t\t       NULL            AS download_id,\n
    \t\t\t       ROUND(hinta, 2) AS price,\n
    \t\t\t       NULL            AS quantity,\n
    \t\t\t       NULL            AS campaign_id,\n
    \t\t\t       NULL            AS campaign_price_id\n
    \t\t\tFROM tuotteet\n
    \t\t\tWHERE id = :product_id\n
    \t\t\tUNION ALL\n
    \t\t\tSELECT 'VARIATION', tuotteet_id, NULL, id, NULL, ROUND(hinta, 2), NULL, NULL, NULL\n
    \t\t\tFROM variaatiot\n
    \t\t\tWHERE tuotteet_id = :product_id\n
    \t\t\tUNION ALL\n
    \t\t\tSELECT 'DOWNLOAD', tuote_id, NULL, NULL, id, ROUND(hinta, 2), NULL, NULL, NULL\n
    \t\t\tFROM lataukset\n
    \t\t\tWHERE tuote_id = :product_id\n
    \t\t\tUNION ALL\n
    \t\t\tSELECT 'DISCOUNT',\n
    \t\t\t       tuote_id,\n
    \t\t\t       NULL,\n
    \t\t\t       variaatio_id,\n
    \t\t\t       lataus_id,\n
    \t\t\t       ROUND(hinta, 2),\n
    \t\t\t       maara,\n
    \t\t\t       kampanja_id,\n
    \t\t\t       id\n
    \t\t\tFROM kampanjat_tuotteet\n
    \t\t\tWHERE tuote_id = :product_id\n
    \t\t\t  AND hinta >= 0
    """
  "params" => [
    "product_id" => 2
  ]
  "types" => [
    "product_id" => 2
  ]
]

[
  "sql" => "SELECT variaatiot.id AS id, variaatiot.lisatty AS created_at, variaatiot.muokattu AS updated_at, variaatiot.tuotteet_id AS product_id, variaatiot.jnro AS sort, variaatiot.tuotenumero AS product_code, IF(ISNULL(variaatiot.hinta), NULL, IF(variaatiot.hinta <> 0, ROUND(variaatiot.hinta, 2), '0')) AS price, IF(ISNULL(variaatiot.ostohinta), NULL, IF(variaatiot.ostohinta <> 0, ROUND(variaatiot.ostohinta, 2), '0')) AS purchase_price, variaatiot.paino AS weight, variaatiot.tuotekuvat_id AS image_id, variaatiot.stock_item_id AS stock_item_id, variaatiot.nimi_en AS name_en, variaatiot.nimi_fi AS name_fi FROM variaatiot WHERE tuotteet_id IN (?) ORDER BY jnro ASC"
  "params" => [
    1 => "2"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT lataukset.id AS id, lataukset.lisatty AS created_at, lataukset.muokattu AS updated_at, lataukset.tuote_id AS product_id, lataukset.jnro AS sort, lataukset.tuotenumero AS product_code, IF(ISNULL(lataukset.hinta), NULL, IF(lataukset.hinta <> 0, ROUND(lataukset.hinta, 2), '0')) AS price, lataukset.tiedosto AS filename, lataukset.latauskerrat AS download_count, lataukset.latausaika AS download_period, lataukset.nimi_en AS name_en, lataukset.nimi_fi AS name_fi FROM lataukset WHERE tuote_id IN (?)"
  "params" => [
    1 => "2"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT tuotteet_valinnat.id AS id, tuotteet_valinnat.lisatty AS created_at, tuotteet_valinnat.muokattu AS updated_at, tuotteet_valinnat.tuote_id AS product_id, tuotteet_valinnat.valinta_id AS option_id, tuotteet_valinnat.valinta_jnro AS option_sort, tuotteet_valinnat.vaihtoehto_id AS option_choice_id, tuotteet_valinnat.vaihtoehto_jnro AS option_choice_sort FROM tuotteet_valinnat WHERE (tuote_id IN (?)) AND (vaihtoehto_id = ?)"
  "params" => [
    1 => "2"
    2 => 0
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT tuotemerkit.id AS id, tuotemerkit.lisatty AS created_at, tuotemerkit.muokattu AS updated_at, tuotemerkit.poistettu AS deleted_at, tuotemerkit.tuotemerkki AS name, tuotemerkit.kuva AS logo, tuotemerkit.fiiliskuva AS campaign_image, tuotemerkit.linkki AS campaign_link, tuotemerkit.Template AS template, tuotemerkit.using_redactor AS using_redactor, tuotemerkit.kuvaus_en AS description_en, tuotemerkit.kuvaus_fi AS description_fi, tuotemerkit.Title_en AS seo_title_en, tuotemerkit.Title_fi AS seo_title_fi, tuotemerkit.PageTitle_en AS seo_page_title_en, tuotemerkit.PageTitle_fi AS seo_page_title_fi, tuotemerkit.MetaDescription_en AS seo_meta_description_en, tuotemerkit.MetaDescription_fi AS seo_meta_description_fi FROM tuotemerkit WHERE id IN (NULL)"
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT DISTINCT\n
    \tpa.code AS attribute_code,\n
    \tpav.code AS attribute_value_code\n
    FROM product_features pf\n
    \tLEFT JOIN product_attribute_values pav ON pf.product_attribute_value_id = pav.id\n
    \tLEFT JOIN product_attributes pa ON pav.product_attribute_id = pa.id\n
    WHERE product_id = ?\n
    ORDER BY pa.sort, pav.sort
    """
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT tuoteryhmat.id AS id, tuoteryhmat.lisatty AS created_at, tuoteryhmat.muokattu AS updated_at, tuoteryhmat.parent AS parent_id, tuoteryhmat.jnro AS parent_sort, tuoteryhmat.tyyppi AS type, tuoteryhmat.external_id AS external_id, tuoteryhmat.featured AS featured, tuoteryhmat.kuva AS image, tuoteryhmat.Template AS template, tuoteryhmat.tuoteryhma_en AS name_en, tuoteryhmat.tuoteryhma_fi AS name_fi, tuoteryhmat.kuvaus_en AS description_en, tuoteryhmat.kuvaus_fi AS description_fi, tuoteryhmat.Title_en AS seo_title_en, tuoteryhmat.Title_fi AS seo_title_fi, tuoteryhmat.PageTitle_en AS seo_page_title_en, tuoteryhmat.PageTitle_fi AS seo_page_title_fi, tuoteryhmat.MetaDescription_en AS seo_meta_description_en, tuoteryhmat.MetaDescription_fi AS seo_meta_description_fi FROM tuoteryhmat WHERE id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT bundles.id AS id, bundles.created_at AS created_at, bundles.updated_at AS updated_at, bundles.deleted_at AS deleted_at, bundles.is_released AS is_released, bundles.category_id AS category_id, bundles.featured AS featured, bundles.name_en AS name_en, bundles.name_fi AS name_fi FROM bundles WHERE (bundles.deleted_at IS NULL) AND (bundles.is_released = ?) AND (\n
    \t\t\tbundles.id NOT IN (\n
    \t\t\t\tSELECT bundle_items.bundle_id\n
    \t\t\t\tFROM bundle_items\n
    \t\t\t\tLEFT JOIN versiot_nakyvyydet ON\n
    \t\t\t\t\t\tversiot_nakyvyydet.objekti_tyyppi = 'PRODUCT'\n
    \t\t\t\t\tAND versiot_nakyvyydet.objekti_id = bundle_items.product_id\n
    \t\t\t\t\tAND versiot_nakyvyydet.versio_id = 2\n
    \t\t\t\t\tAND versiot_nakyvyydet.nakyvilla = '1'\n
    \t\t\t\tWHERE versiot_nakyvyydet.nakyvilla IS NULL\n
    \t\t\t)\n
    \t\t) AND (bundles.category_id = ?) ORDER BY created_at DESC
    """
  "params" => [
    1 => "1"
    2 => "2"
  ]
  "types" => [
    1 => 2
    2 => 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 * 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 id, parent AS parent_id FROM tuoteryhmat"
]

[
  "sql" => "SELECT id, tuoteryhma_en AS name FROM tuoteryhmat WHERE id IN('1')"
]

[
  "sql" => "select id, tuoteryhma_en, tuoteryhma_fi from tuoteryhmat"
]

[
  "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 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 < 1765038824)) AND ((IFNULL(paattyy, 0) = 0 OR paattyy > 1765038824)) 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 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"
]