Symfony Profiler

[
  "params" => [
    "dbname" => "cashflow_mycashflow-payments-onboarding"
    "host" => "mycashflow-mysql"
    "port" => "3306"
    "user" => "cashflow_mycashflow-payments-onb"
    "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\Component\WebhookLog\WebhookLoggingControllerListener::__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" => "Container9GIRkoC\RequestPayloadValueResolverGhostF9259d2::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT code FROM versiot WHERE url = ? LIMIT 1"
  "params" => [
    1 => "ville.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 => "beqfd1g9a3d502lid421qte3jj"
  ]
  "types" => [
    1 => 2
  ]
]

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

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

[
  "sql" => "SELECT muokattu AS updated_at, data FROM istunnot WHERE tunniste = ? AND IFNULL(poistettu, 0) = 0 LIMIT 1"
  "params" => [
    1 => "a9n05u1m374ulra69snks06l0d"
  ]
  "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 => "ville.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 => "3"
  ]
  "types" => [
    1 => 1
  ]
]

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

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

[
  "sql" => "SHOW TABLES LIKE 'redirects'"
]

[
  "sql" => "SELECT new FROM redirects WHERE ? LIKE REPLACE(old, '*', '%') OR ? LIKE REPLACE(old, '*', '%') ORDER BY old, new ASC LIMIT 1"
  "params" => [
    1 => "https://ville.mcf.dev/product/1421"
    2 => "/product/1421?currency=SEK"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "select code from versiot where url = ?"
  "params" => [
    1 => "ville.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 = 'ville.mcf.dev' LIMIT 1"
]

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

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

[
  "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 koodi as code from laajennukset where kaytossa = 1"
]

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

[
  "sql" => "SELECT * FROM `ostoskorit` LIMIT 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 => "4"
    5 => "5"
    6 => "6"
    7 => "7"
    8 => "8"
    9 => "9"
    10 => "10"
    11 => "11"
    12 => "12"
    13 => "13"
    14 => "14"
    15 => "15"
    16 => "17"
    17 => "18"
    18 => "19"
    19 => "20"
    20 => "21"
    21 => "32"
    22 => "34"
    23 => "36"
    24 => "37"
    25 => "45"
    26 => "46"
    27 => "47"
    28 => "48"
    29 => "49"
    30 => "52"
    31 => "63"
    32 => "64"
    33 => "65"
    34 => "69"
    35 => "70"
    36 => "71"
    37 => "72"
    38 => "73"
    39 => "75"
    40 => "74"
    41 => "80"
    42 => "82"
    43 => "62"
    44 => "87"
    45 => "89"
    46 => "91"
    47 => "92"
    48 => "93"
    49 => "94"
    50 => "95"
    51 => "96"
    52 => "97"
    53 => "98"
    54 => "99"
    55 => "100"
    56 => "101"
    57 => "102"
    58 => "114"
    59 => "122"
    60 => "129"
    61 => "130"
    62 => "131"
    63 => "133"
    64 => "134"
    65 => "136"
    66 => "139"
    67 => "141"
    68 => "142"
    69 => "143"
    70 => "144"
    71 => "145"
    72 => "146"
    73 => "147"
    74 => "1"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
    29 => 2
    30 => 2
    31 => 2
    32 => 2
    33 => 2
    34 => 2
    35 => 2
    36 => 2
    37 => 2
    38 => 2
    39 => 2
    40 => 2
    41 => 2
    42 => 2
    43 => 2
    44 => 2
    45 => 2
    46 => 2
    47 => 2
    48 => 2
    49 => 2
    50 => 2
    51 => 2
    52 => 2
    53 => 2
    54 => 2
    55 => 2
    56 => 2
    57 => 2
    58 => 2
    59 => 2
    60 => 2
    61 => 2
    62 => 2
    63 => 2
    64 => 2
    65 => 2
    66 => 2
    67 => 2
    68 => 2
    69 => 2
    70 => 2
    71 => 2
    72 => 2
    73 => 2
    74 => 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.alennusrivi_tuoteraportti_id AS alennusrivi_tuoteraportti_id_13, t0.alennusrivi_kohde AS alennusrivi_kohde_14, t0.alennusrivi_yksikko AS alennusrivi_yksikko_15, t0.alennusrivi_arvo AS alennusrivi_arvo_16, t0.tuotealennukset_yleinen AS tuotealennukset_yleinen_17, t0.minimitilaus AS minimitilaus_18, t0.tuotealennukset AS tuotealennukset_19, t0.maara_alennukset AS maara_alennukset_20, t0.toimitustavat AS toimitustavat_21, t0.sivu AS sivu_22, t0.kiinnitetty AS kiinnitetty_23, t0.price_list_id AS price_list_id_24, t0.discount_rules AS discount_rules_25, t0.sivu AS sivu_26, t0.kiinnitetty AS kiinnitetty_27 FROM kampanjat t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t0.discount_type IN ('DISCOUNT_CODES', 'FREE_SHIPPING', 'LEGACY', 'X_FOR_Y')"
  "params" => [
    1 => "1"
    2 => "9"
    3 => "12"
    4 => "20"
    5 => "37"
    6 => "62"
    7 => "63"
    8 => "65"
    9 => "69"
    10 => "72"
    11 => "73"
    12 => "75"
    13 => "96"
    14 => "99"
    15 => "100"
    16 => "101"
    17 => "102"
    18 => "114"
    19 => "122"
    20 => "129"
    21 => "130"
    22 => "133"
    23 => "134"
    24 => "139"
    25 => "146"
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
    24 => 1
    25 => 1
  ]
]

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

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

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

[
  "sql" => "SELECT tuote_id FROM kampanjat_tuotteet WHERE kampanja_id = ?"
  "params" => [
    1 => 96
  ]
  "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 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.loyalty_program_id AS loyalty_program_id_4, t0.type, t0.settings AS settings_5, t0.settings AS settings_6, t0.settings AS settings_7, t0.settings AS settings_8 FROM loyalty_program_rules t0 WHERE t0.loyalty_program_id = ? AND t0.type IN ('AccruePointsForDeliveredOrders', 'AccruePointsForSignUp', 'EarnPointsForProductReview', 'RewardDiscountCodeForPoints')"
  "params" => [
    1 => 1
  ]
  "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 = 3 LIMIT 1"
]

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

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

[
  "sql" => "SELECT t0_.saatavuus_alkaa AS saatavuus_alkaa_0, t0_.saatavuus_paattyy AS saatavuus_paattyy_1, t0_.julkaisu_myyntiin AS julkaisu_myyntiin_2, t0_.julkaisu_nakyville AS julkaisu_nakyville_3, t0_.average_rating AS average_rating_4, t0_.approved_reviews_count AS approved_reviews_count_5, t0_.oma_tuotenumero AS oma_tuotenumero_6, t0_.lisatty AS lisatty_7, t0_.id AS id_8, t0_.tuotetiedot_fi AS tuotetiedot_fi_9, t0_.tuotenimi_fi AS tuotenimi_fi_10, t0_.postituskoko AS postituskoko_11, t0_.hinta AS hinta_12, t0_.ostohinta AS ostohinta_13, t0_.MetaDescription_fi AS MetaDescription_fi_14, t0_.PageTitle_fi AS PageTitle_fi_15, t0_.Title_fi AS Title_fi_16, t0_.tuotekuvaus_fi AS tuotekuvaus_fi_17, t0_.toimittajan_tuotenumero AS toimittajan_tuotenumero_18, t0_.muokattu AS muokattu_19, t0_.verokanta AS verokanta_20, t0_.using_redactor AS using_redactor_21, t0_.takuu AS takuu_22, t0_.paino AS paino_23, t0_.tilausrajoitus AS tilausrajoitus_24, t0_.tilausrajoitus_min AS tilausrajoitus_min_25, t0_.lahjakortti_aika AS lahjakortti_aika_26, s1_.backorder_enabled AS backorder_enabled_27, s1_.backorder_estimate AS backorder_estimate_28, s1_.balance_limit AS balance_limit_29, s1_.barcode AS barcode_30, s1_.country_of_origin AS country_of_origin_31, s1_.customs_tariff_code AS customs_tariff_code_32, s1_.deleted_at AS deleted_at_33, s1_.enabled AS enabled_34, s1_.id AS id_35, s1_.location AS location_36, s1_.quantity AS quantity_37, s1_.sku AS sku_38, s1_.created_at AS created_at_39, s1_.updated_at AS updated_at_40, s2_.id AS id_41, s2_.quantity AS quantity_42, s2_.created_at AS created_at_43, s2_.updated_at AS updated_at_44, s3_.expires_at AS expires_at_45, s3_.id AS id_46, s3_.quantity AS quantity_47, s3_.source_type AS source_type_48, s3_.source_id AS source_id_49, s3_.created_at AS created_at_50, s3_.updated_at AS updated_at_51, v4_.tuotenumero AS tuotenumero_52, v4_.id AS id_53, v4_.nimi_fi AS nimi_fi_54, v4_.hinta AS hinta_55, v4_.ostohinta AS ostohinta_56, v4_.jnro AS jnro_57, v4_.paino AS paino_58, v4_.lisatty AS lisatty_59, v4_.muokattu AS muokattu_60, s5_.backorder_enabled AS backorder_enabled_61, s5_.backorder_estimate AS backorder_estimate_62, s5_.balance_limit AS balance_limit_63, s5_.barcode AS barcode_64, s5_.country_of_origin AS country_of_origin_65, s5_.customs_tariff_code AS customs_tariff_code_66, s5_.deleted_at AS deleted_at_67, s5_.enabled AS enabled_68, s5_.id AS id_69, s5_.location AS location_70, s5_.quantity AS quantity_71, s5_.sku AS sku_72, s5_.created_at AS created_at_73, s5_.updated_at AS updated_at_74, s6_.id AS id_75, s6_.quantity AS quantity_76, s6_.created_at AS created_at_77, s6_.updated_at AS updated_at_78, s7_.expires_at AS expires_at_79, s7_.id AS id_80, s7_.quantity AS quantity_81, s7_.source_type AS source_type_82, s7_.source_id AS source_id_83, s7_.created_at AS created_at_84, s7_.updated_at AS updated_at_85, t0_.tuotetyyppi AS tuotetyyppi_86, t0_.tuotemerkki AS tuotemerkki_87, t0_.toimittaja AS toimittaja_88, t0_.stock_item_id AS stock_item_id_89, s2_.stock_item_id AS stock_item_id_90, s2_.stock_location_id AS stock_location_id_91, s3_.stock_item_id AS stock_item_id_92, s3_.stock_location_id AS stock_location_id_93, v4_.tuotteet_id AS tuotteet_id_94, v4_.stock_item_id AS stock_item_id_95, s6_.stock_item_id AS stock_item_id_96, s6_.stock_location_id AS stock_location_id_97, s7_.stock_item_id AS stock_item_id_98, s7_.stock_location_id AS stock_location_id_99 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 => "1421"
  ]
  "types" => [
    1 => 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_ee AS name_ee, tuotteet.tuotenimi_fi AS name_fi, tuotteet.tuotenimi_se AS name_se, tuotteet.tuotenimi_es AS name_es, tuotteet.tuotekuvaus_en AS description_en, tuotteet.tuotekuvaus_ee AS description_ee, tuotteet.tuotekuvaus_fi AS description_fi, tuotteet.tuotekuvaus_se AS description_se, tuotteet.tuotekuvaus_es AS description_es, tuotteet.tuotetiedot_en AS information_en, tuotteet.tuotetiedot_ee AS information_ee, tuotteet.tuotetiedot_fi AS information_fi, tuotteet.tuotetiedot_se AS information_se, tuotteet.tuotetiedot_es AS information_es, tuotteet.Title_en AS seo_title_en, tuotteet.Title_ee AS seo_title_ee, tuotteet.Title_fi AS seo_title_fi, tuotteet.Title_se AS seo_title_se, tuotteet.Title_es AS seo_title_es, tuotteet.PageTitle_en AS seo_page_title_en, tuotteet.PageTitle_ee AS seo_page_title_ee, tuotteet.PageTitle_fi AS seo_page_title_fi, tuotteet.PageTitle_se AS seo_page_title_se, tuotteet.PageTitle_es AS seo_page_title_es, tuotteet.MetaDescription_en AS seo_meta_description_en, tuotteet.MetaDescription_ee AS seo_meta_description_ee, tuotteet.MetaDescription_fi AS seo_meta_description_fi, tuotteet.MetaDescription_se AS seo_meta_description_se, tuotteet.MetaDescription_es AS seo_meta_description_es FROM tuotteet WHERE id = ?"
  "params" => [
    1 => "1421"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT tuotekuvat.id FROM tuotteet_mediat JOIN tuotekuvat ON tuotteet_mediat.tuotekuva_id = tuotekuvat.id WHERE IFNULL(tuotteet_mediat.poistettu,0) = 0 AND IFNULL(tuotekuvat.poistettu,0) = 0 AND tuotteet_mediat.tuote_id = '1421'   ORDER BY tuotteet_mediat.jnro"
]

[
  "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_ee AS name_ee, tuotteet.tuotenimi_fi AS name_fi, tuotteet.tuotenimi_se AS name_se, tuotteet.tuotenimi_es AS name_es, tuotteet.tuotekuvaus_en AS description_en, tuotteet.tuotekuvaus_ee AS description_ee, tuotteet.tuotekuvaus_fi AS description_fi, tuotteet.tuotekuvaus_se AS description_se, tuotteet.tuotekuvaus_es AS description_es, tuotteet.tuotetiedot_en AS information_en, tuotteet.tuotetiedot_ee AS information_ee, tuotteet.tuotetiedot_fi AS information_fi, tuotteet.tuotetiedot_se AS information_se, tuotteet.tuotetiedot_es AS information_es, tuotteet.Title_en AS seo_title_en, tuotteet.Title_ee AS seo_title_ee, tuotteet.Title_fi AS seo_title_fi, tuotteet.Title_se AS seo_title_se, tuotteet.Title_es AS seo_title_es, tuotteet.PageTitle_en AS seo_page_title_en, tuotteet.PageTitle_ee AS seo_page_title_ee, tuotteet.PageTitle_fi AS seo_page_title_fi, tuotteet.PageTitle_se AS seo_page_title_se, tuotteet.PageTitle_es AS seo_page_title_es, tuotteet.MetaDescription_en AS seo_meta_description_en, tuotteet.MetaDescription_ee AS seo_meta_description_ee, tuotteet.MetaDescription_fi AS seo_meta_description_fi, tuotteet.MetaDescription_se AS seo_meta_description_se, tuotteet.MetaDescription_es AS seo_meta_description_es FROM tuotteet WHERE id = ?"
  "params" => [
    1 => "1421"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT tuoteryhma_id AS id FROM tuoteryhmat_tuotteet WHERE tuoteryhma_id > 0 AND tuote_id = 1421 ORDER BY tuoteryhma_jnro"
]

[
  "sql" => "SELECT * FROM versiot WHERE id = 3 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 => "4"
    5 => "5"
    6 => "6"
    7 => "7"
    8 => "8"
    9 => "9"
    10 => "10"
    11 => "11"
    12 => "12"
    13 => "13"
    14 => "14"
    15 => "15"
    16 => "17"
    17 => "18"
    18 => "19"
    19 => "20"
    20 => "21"
    21 => "32"
    22 => "34"
    23 => "36"
    24 => "37"
    25 => "45"
    26 => "46"
    27 => "47"
    28 => "48"
    29 => "49"
    30 => "52"
    31 => "63"
    32 => "64"
    33 => "65"
    34 => "69"
    35 => "70"
    36 => "71"
    37 => "72"
    38 => "73"
    39 => "75"
    40 => "74"
    41 => "80"
    42 => "82"
    43 => "62"
    44 => "87"
    45 => "89"
    46 => "91"
    47 => "92"
    48 => "93"
    49 => "94"
    50 => "95"
    51 => "96"
    52 => "97"
    53 => "98"
    54 => "99"
    55 => "100"
    56 => "101"
    57 => "102"
    58 => "114"
    59 => "122"
    60 => "129"
    61 => "130"
    62 => "131"
    63 => "133"
    64 => "134"
    65 => "136"
    66 => "139"
    67 => "141"
    68 => "142"
    69 => "143"
    70 => "144"
    71 => "145"
    72 => "146"
    73 => "147"
    74 => "1"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
    29 => 2
    30 => 2
    31 => 2
    32 => 2
    33 => 2
    34 => 2
    35 => 2
    36 => 2
    37 => 2
    38 => 2
    39 => 2
    40 => 2
    41 => 2
    42 => 2
    43 => 2
    44 => 2
    45 => 2
    46 => 2
    47 => 2
    48 => 2
    49 => 2
    50 => 2
    51 => 2
    52 => 2
    53 => 2
    54 => 2
    55 => 2
    56 => 2
    57 => 2
    58 => 2
    59 => 2
    60 => 2
    61 => 2
    62 => 2
    63 => 2
    64 => 2
    65 => 2
    66 => 2
    67 => 2
    68 => 2
    69 => 2
    70 => 2
    71 => 2
    72 => 2
    73 => 2
    74 => 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 `tuoteryhmat` LIMIT 1"
]

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

[
  "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_ee AS description_ee, tuotemerkit.kuvaus_fi AS description_fi, tuotemerkit.kuvaus_se AS description_se, tuotemerkit.kuvaus_es AS description_es, tuotemerkit.Title_en AS seo_title_en, tuotemerkit.Title_ee AS seo_title_ee, tuotemerkit.Title_fi AS seo_title_fi, tuotemerkit.Title_se AS seo_title_se, tuotemerkit.Title_es AS seo_title_es, tuotemerkit.PageTitle_en AS seo_page_title_en, tuotemerkit.PageTitle_ee AS seo_page_title_ee, tuotemerkit.PageTitle_fi AS seo_page_title_fi, tuotemerkit.PageTitle_se AS seo_page_title_se, tuotemerkit.PageTitle_es AS seo_page_title_es, tuotemerkit.MetaDescription_en AS seo_meta_description_en, tuotemerkit.MetaDescription_ee AS seo_meta_description_ee, tuotemerkit.MetaDescription_fi AS seo_meta_description_fi, tuotemerkit.MetaDescription_se AS seo_meta_description_se, tuotemerkit.MetaDescription_es AS seo_meta_description_es FROM tuotemerkit WHERE id = ?"
  "params" => [
    1 => "21"
  ]
  "types" => [
    1 => 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_ee AS description_ee, tuotemerkit.kuvaus_fi AS description_fi, tuotemerkit.kuvaus_se AS description_se, tuotemerkit.kuvaus_es AS description_es, tuotemerkit.Title_en AS seo_title_en, tuotemerkit.Title_ee AS seo_title_ee, tuotemerkit.Title_fi AS seo_title_fi, tuotemerkit.Title_se AS seo_title_se, tuotemerkit.Title_es AS seo_title_es, tuotemerkit.PageTitle_en AS seo_page_title_en, tuotemerkit.PageTitle_ee AS seo_page_title_ee, tuotemerkit.PageTitle_fi AS seo_page_title_fi, tuotemerkit.PageTitle_se AS seo_page_title_se, tuotemerkit.PageTitle_es AS seo_page_title_es, tuotemerkit.MetaDescription_en AS seo_meta_description_en, tuotemerkit.MetaDescription_ee AS seo_meta_description_ee, tuotemerkit.MetaDescription_fi AS seo_meta_description_fi, tuotemerkit.MetaDescription_se AS seo_meta_description_se, tuotemerkit.MetaDescription_es AS seo_meta_description_es FROM tuotemerkit WHERE id IN (?)"
  "params" => [
    1 => "21"
  ]
  "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 => "4"
    5 => "5"
    6 => "6"
    7 => "7"
    8 => "8"
    9 => "9"
    10 => "10"
    11 => "11"
    12 => "12"
    13 => "13"
    14 => "14"
    15 => "15"
    16 => "17"
    17 => "18"
    18 => "19"
    19 => "20"
    20 => "21"
    21 => "32"
    22 => "34"
    23 => "36"
    24 => "37"
    25 => "45"
    26 => "46"
    27 => "47"
    28 => "48"
    29 => "49"
    30 => "52"
    31 => "63"
    32 => "64"
    33 => "65"
    34 => "69"
    35 => "70"
    36 => "71"
    37 => "72"
    38 => "73"
    39 => "75"
    40 => "74"
    41 => "80"
    42 => "82"
    43 => "62"
    44 => "87"
    45 => "89"
    46 => "91"
    47 => "92"
    48 => "93"
    49 => "94"
    50 => "95"
    51 => "96"
    52 => "97"
    53 => "98"
    54 => "99"
    55 => "100"
    56 => "101"
    57 => "102"
    58 => "114"
    59 => "122"
    60 => "129"
    61 => "130"
    62 => "131"
    63 => "133"
    64 => "134"
    65 => "136"
    66 => "139"
    67 => "141"
    68 => "142"
    69 => "143"
    70 => "144"
    71 => "145"
    72 => "146"
    73 => "147"
    74 => "1"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
    29 => 2
    30 => 2
    31 => 2
    32 => 2
    33 => 2
    34 => 2
    35 => 2
    36 => 2
    37 => 2
    38 => 2
    39 => 2
    40 => 2
    41 => 2
    42 => 2
    43 => 2
    44 => 2
    45 => 2
    46 => 2
    47 => 2
    48 => 2
    49 => 2
    50 => 2
    51 => 2
    52 => 2
    53 => 2
    54 => 2
    55 => 2
    56 => 2
    57 => 2
    58 => 2
    59 => 2
    60 => 2
    61 => 2
    62 => 2
    63 => 2
    64 => 2
    65 => 2
    66 => 2
    67 => 2
    68 => 2
    69 => 2
    70 => 2
    71 => 2
    72 => 2
    73 => 2
    74 => 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 tuoteryhmat_tuotteet.id AS id, tuoteryhmat_tuotteet.lisatty AS created_at, tuoteryhmat_tuotteet.muokattu AS updated_at, tuoteryhmat_tuotteet.tuoteryhma_id AS category_id, tuoteryhmat_tuotteet.tuoteryhma_jnro AS category_sort, tuoteryhmat_tuotteet.tuote_id AS product_id, tuoteryhmat_tuotteet.tuote_jnro AS product_sort FROM tuoteryhmat_tuotteet WHERE (tuote_id IN (?)) AND (tuoteryhma_id > ?) ORDER BY tuoteryhma_jnro ASC"
  "params" => [
    1 => "1421"
    2 => 0
  ]
  "types" => [
    1 => 2
    2 => 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_ee AS name_ee, tuoteryhmat.tuoteryhma_fi AS name_fi, tuoteryhmat.tuoteryhma_se AS name_se, tuoteryhmat.tuoteryhma_es AS name_es, tuoteryhmat.kuvaus_en AS description_en, tuoteryhmat.kuvaus_ee AS description_ee, tuoteryhmat.kuvaus_fi AS description_fi, tuoteryhmat.kuvaus_se AS description_se, tuoteryhmat.kuvaus_es AS description_es, tuoteryhmat.Title_en AS seo_title_en, tuoteryhmat.Title_ee AS seo_title_ee, tuoteryhmat.Title_fi AS seo_title_fi, tuoteryhmat.Title_se AS seo_title_se, tuoteryhmat.Title_es AS seo_title_es, tuoteryhmat.PageTitle_en AS seo_page_title_en, tuoteryhmat.PageTitle_ee AS seo_page_title_ee, tuoteryhmat.PageTitle_fi AS seo_page_title_fi, tuoteryhmat.PageTitle_se AS seo_page_title_se, tuoteryhmat.PageTitle_es AS seo_page_title_es, tuoteryhmat.MetaDescription_en AS seo_meta_description_en, tuoteryhmat.MetaDescription_ee AS seo_meta_description_ee, tuoteryhmat.MetaDescription_fi AS seo_meta_description_fi, tuoteryhmat.MetaDescription_se AS seo_meta_description_se, tuoteryhmat.MetaDescription_es AS seo_meta_description_es FROM tuoteryhmat WHERE id IN (?)"
  "params" => [
    1 => "42"
  ]
  "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" => "3"
  ]
  "types" => [
    "versio_id" => 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 => "ville.mcf.dev"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.saatavuus_alkaa AS saatavuus_alkaa_1, t0.saatavuus_paattyy AS saatavuus_paattyy_2, t0.julkaisu_myyntiin AS julkaisu_myyntiin_3, t0.julkaisu_nakyville AS julkaisu_nakyville_4, t0.average_rating AS average_rating_5, t0.approved_reviews_count AS approved_reviews_count_6, t0.oma_tuotenumero AS oma_tuotenumero_7, t0.lisatty AS lisatty_8, t0.id AS id_9, t0.tuotetiedot_fi AS tuotetiedot_fi_10, t0.tuotenimi_fi AS tuotenimi_fi_11, t0.postituskoko AS postituskoko_12, t0.hinta AS hinta_13, t0.ostohinta AS ostohinta_14, t0.MetaDescription_fi AS MetaDescription_fi_15, t0.PageTitle_fi AS PageTitle_fi_16, t0.Title_fi AS Title_fi_17, t0.tuotekuvaus_fi AS tuotekuvaus_fi_18, t0.toimittajan_tuotenumero AS toimittajan_tuotenumero_19, t0.muokattu AS muokattu_20, t0.verokanta AS verokanta_21, t0.using_redactor AS using_redactor_22, t0.takuu AS takuu_23, t0.paino AS paino_24, t0.tilausrajoitus AS tilausrajoitus_25, t0.tilausrajoitus_min AS tilausrajoitus_min_26, t0.tuotemerkki AS tuotemerkki_27, t0.toimittaja AS toimittaja_28, t0.stock_item_id AS stock_item_id_29, t0.tuotetyyppi, t0.lahjakortti_aika AS lahjakortti_aika_30 FROM tuotteet t0 WHERE t0.id = ? AND t0.tuotetyyppi IN ('NORMAL', 'GIFT_CARD') LIMIT 1"
  "params" => [
    1 => 1421
  ]
  "types" => [
    1 => 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 => "ville.mcf.dev"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT f0_.id AS id_0, f0_.deleted_at AS deleted_at_1, f0_.type AS type_2, f0_.uuid AS uuid_3, f0_.settings AS settings_4, f0_.enabled AS enabled_5, f0_.created_at AS created_at_6, f0_.updated_at AS updated_at_7 FROM feeds f0_ WHERE f0_.deleted_at IS NULL AND f0_.type = ?"
  "params" => [
    1 => "Facebook"
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "event" => "Mcf\Component\Analytics\Event\ProductViewedEvent"
  "listener" => "Mcf\Component\GoogleTracking\GoogleTrackingEventSubscriber::addEvent"
]

[
  "event" => "Mcf\Component\Analytics\Event\ProductViewedEvent"
  "listener" => "Mcf\Component\MetaTracking\MetaTrackingEventSubscriber::addEvent"
]

[
  "event" => "Mcf\Component\Analytics\Event\ProductViewedEvent"
  "listener" => "Mcf\Component\ProductFeed\FacebookEventSubscriber::onProductViewed"
]

[
  "event" => "Mcf\Component\Analytics\Event\ProductViewedEvent"
  "listener" => "Mcf\Extensions\GoogleAnalytics4\GoogleAnalytics4EventSubscriber::addEvent"
]

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

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

[
  "sql" => "SELECT * FROM tuoteryhmat WHERE id = 100 LIMIT 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.id = ?"
  "params" => [
    1 => 26
  ]
  "types" => [
    1 => 1
  ]
]

[
  "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_ee AS name_ee, variaatiot.nimi_fi AS name_fi, variaatiot.nimi_se AS name_se, variaatiot.nimi_es AS name_es FROM variaatiot WHERE tuotteet_id IN (?) ORDER BY jnro ASC"
  "params" => [
    1 => "1421"
  ]
  "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_ee AS name_ee, lataukset.nimi_fi AS name_fi, lataukset.nimi_se AS name_se, lataukset.nimi_es AS name_es FROM lataukset WHERE tuote_id IN (?)"
  "params" => [
    1 => "1421"
  ]
  "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 => "1421"
    2 => 0
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT tuotteet_mediat.id AS id, tuotteet_mediat.lisatty AS created_at, tuotteet_mediat.muokattu AS updated_at, tuotteet_mediat.tuote_id AS product_id, tuotteet_mediat.tuotekuva_id AS image_id, tuotteet_mediat.jnro AS sort, tuotteet_mediat.tyyppi AS type FROM tuotteet_mediat WHERE (tuote_id IN (?)) AND (tuotekuva_id > ?) ORDER BY jnro ASC"
  "params" => [
    1 => "1421"
    2 => 0
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

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

[
  "sql" => "SELECT id FROM variaatiot WHERE (ISNULL(poistettu) OR poistettu = 0) AND tuotteet_id = '1421' ORDER BY jnro, id"
]

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

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

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

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

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

[
  "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_ee AS description_ee, tuotemerkit.kuvaus_fi AS description_fi, tuotemerkit.kuvaus_se AS description_se, tuotemerkit.kuvaus_es AS description_es, tuotemerkit.Title_en AS seo_title_en, tuotemerkit.Title_ee AS seo_title_ee, tuotemerkit.Title_fi AS seo_title_fi, tuotemerkit.Title_se AS seo_title_se, tuotemerkit.Title_es AS seo_title_es, tuotemerkit.PageTitle_en AS seo_page_title_en, tuotemerkit.PageTitle_ee AS seo_page_title_ee, tuotemerkit.PageTitle_fi AS seo_page_title_fi, tuotemerkit.PageTitle_se AS seo_page_title_se, tuotemerkit.PageTitle_es AS seo_page_title_es, tuotemerkit.MetaDescription_en AS seo_meta_description_en, tuotemerkit.MetaDescription_ee AS seo_meta_description_ee, tuotemerkit.MetaDescription_fi AS seo_meta_description_fi, tuotemerkit.MetaDescription_se AS seo_meta_description_se, tuotemerkit.MetaDescription_es AS seo_meta_description_es FROM tuotemerkit WHERE id IN (?)"
  "params" => [
    1 => "21"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT tuotevalinnat.id FROM tuotteet_valinnat JOIN tuotevalinnat ON tuotteet_valinnat.valinta_id = tuotevalinnat.id WHERE  tuotteet_valinnat.tuote_id = '1421'  AND  tuotteet_valinnat.vaihtoehto_id = '0'   ORDER BY tuotteet_valinnat.valinta_jnro "
]

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

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

[
  "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 => 3
  ]
  "types" => [
    1 => 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_ee AS title_ee, banneriryhmat.nimi_fi AS title_fi, banneriryhmat.nimi_se AS title_se, banneriryhmat.nimi_es AS title_es 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_ee AS title_ee, bannerit.nimi_fi AS title_fi, bannerit.nimi_se AS title_se, bannerit.nimi_es AS title_es, bannerit.teksti_en AS content_en, bannerit.teksti_ee AS content_ee, bannerit.teksti_fi AS content_fi, bannerit.teksti_se AS content_se, bannerit.teksti_es AS content_es, bannerit.linkki_en AS link_en, bannerit.linkki_ee AS link_ee, bannerit.linkki_fi AS link_fi, bannerit.linkki_se AS link_se, bannerit.linkki_es AS link_es FROM bannerit WHERE (IFNULL(poistettu, 0) = 0) AND (id IN (?, ?, ?, ?)) AND ((IFNULL(alkaa, 0) = 0 OR alkaa < 1769530326)) AND ((IFNULL(paattyy, 0) = 0 OR paattyy > 1769530326)) ORDER BY jnro ASC"
  "params" => [
    1 => "1"
    2 => "2"
    3 => "3"
    4 => "4"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT tuoteryhmat_tuotteet.id AS id, tuoteryhmat_tuotteet.lisatty AS created_at, tuoteryhmat_tuotteet.muokattu AS updated_at, tuoteryhmat_tuotteet.tuoteryhma_id AS category_id, tuoteryhmat_tuotteet.tuoteryhma_jnro AS category_sort, tuoteryhmat_tuotteet.tuote_id AS product_id, tuoteryhmat_tuotteet.tuote_jnro AS product_sort FROM tuoteryhmat_tuotteet WHERE (tuote_id IN (?)) AND (tuoteryhma_id > ?) ORDER BY tuoteryhma_jnro ASC"
  "params" => [
    1 => "1421"
    2 => 0
  ]
  "types" => [
    1 => 2
    2 => 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_ee AS name_ee, tuoteryhmat.tuoteryhma_fi AS name_fi, tuoteryhmat.tuoteryhma_se AS name_se, tuoteryhmat.tuoteryhma_es AS name_es, tuoteryhmat.kuvaus_en AS description_en, tuoteryhmat.kuvaus_ee AS description_ee, tuoteryhmat.kuvaus_fi AS description_fi, tuoteryhmat.kuvaus_se AS description_se, tuoteryhmat.kuvaus_es AS description_es, tuoteryhmat.Title_en AS seo_title_en, tuoteryhmat.Title_ee AS seo_title_ee, tuoteryhmat.Title_fi AS seo_title_fi, tuoteryhmat.Title_se AS seo_title_se, tuoteryhmat.Title_es AS seo_title_es, tuoteryhmat.PageTitle_en AS seo_page_title_en, tuoteryhmat.PageTitle_ee AS seo_page_title_ee, tuoteryhmat.PageTitle_fi AS seo_page_title_fi, tuoteryhmat.PageTitle_se AS seo_page_title_se, tuoteryhmat.PageTitle_es AS seo_page_title_es, tuoteryhmat.MetaDescription_en AS seo_meta_description_en, tuoteryhmat.MetaDescription_ee AS seo_meta_description_ee, tuoteryhmat.MetaDescription_fi AS seo_meta_description_fi, tuoteryhmat.MetaDescription_se AS seo_meta_description_se, tuoteryhmat.MetaDescription_es AS seo_meta_description_es FROM tuoteryhmat WHERE id IN (?)"
  "params" => [
    1 => "42"
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => "SELECT toimitustavat.id AS id, toimitustavat.lisatty AS created_at, toimitustavat.muokattu AS updated_at, toimitustavat.poistettu AS deleted_at, toimitustavat.tyyppi AS type, toimitustavat.kasittely AS service_provider, toimitustavat.tuotekoodi AS service_code, toimitustavat.asetukset AS service_settings, toimitustavat.tuotenumero AS product_code, toimitustavat.logo AS image, IF(ISNULL(toimitustavat.rahtivapaus), NULL, IF(toimitustavat.rahtivapaus <> 0, ROUND(toimitustavat.rahtivapaus, 2), '0')) AS free_shipping_threshold, toimitustavat.jnro AS sort, toimitustavat.postituskoot AS allowed_parcel_types, toimitustavat.sallitut_maat AS allowed_countries, toimitustavat.vaadi_puhelin AS phone_required, toimitustavat.using_redactor AS using_redactor, toimitustavat.shipping_additional_features AS shipping_additional_features FROM toimitustavat WHERE IFNULL(poistettu, 0) = 0 ORDER BY jnro ASC"
]

[
  "sql" => "SELECT toimituskulut.id AS id, toimituskulut.lisatty AS created_at, toimituskulut.muokattu AS updated_at, toimituskulut.toimitustapa_id AS shipping_method_id, IF(ISNULL(toimituskulut.hinta), NULL, IF(toimituskulut.hinta <> 0, ROUND(toimituskulut.hinta, 2), '0')) AS price, toimituskulut.paino_enintaan AS max_weight FROM toimituskulut WHERE toimitustapa_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY max_weight ASC"
  "params" => [
    1 => "699"
    2 => "681"
    3 => "163"
    4 => "698"
    5 => "677"
    6 => "29"
    7 => "693"
    8 => "697"
    9 => "695"
    10 => "696"
    11 => "692"
    12 => "52"
    13 => "2"
    14 => "691"
    15 => "162"
    16 => "690"
    17 => "5"
    18 => "48"
    19 => "687"
    20 => "688"
    21 => "689"
    22 => "13"
    23 => "685"
    24 => "686"
    25 => "684"
    26 => "668"
    27 => "666"
    28 => "6"
    29 => "9"
    30 => "10"
    31 => "11"
    32 => "17"
    33 => "67"
    34 => "83"
    35 => "90"
    36 => "101"
    37 => "110"
    38 => "669"
    39 => "161"
    40 => "694"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
    29 => 2
    30 => 2
    31 => 2
    32 => 2
    33 => 2
    34 => 2
    35 => 2
    36 => 2
    37 => 2
    38 => 2
    39 => 2
    40 => 2
  ]
]

[
  "sql" => "SELECT versiot_nakyvyydet.id AS id, versiot_nakyvyydet.lisatty AS created_at, versiot_nakyvyydet.muokattu AS updated_at, versiot_nakyvyydet.versio_id AS version_id, versiot_nakyvyydet.objekti_tyyppi AS item_type, versiot_nakyvyydet.objekti_id AS item_id, versiot_nakyvyydet.nakyvilla AS is_visible FROM versiot_nakyvyydet WHERE (objekti_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (objekti_tyyppi = ?)"
  "params" => [
    1 => "699"
    2 => "681"
    3 => "163"
    4 => "698"
    5 => "677"
    6 => "29"
    7 => "693"
    8 => "697"
    9 => "695"
    10 => "696"
    11 => "692"
    12 => "52"
    13 => "2"
    14 => "691"
    15 => "162"
    16 => "690"
    17 => "5"
    18 => "48"
    19 => "687"
    20 => "688"
    21 => "689"
    22 => "13"
    23 => "685"
    24 => "686"
    25 => "684"
    26 => "668"
    27 => "666"
    28 => "6"
    29 => "9"
    30 => "10"
    31 => "11"
    32 => "17"
    33 => "67"
    34 => "83"
    35 => "90"
    36 => "101"
    37 => "110"
    38 => "669"
    39 => "161"
    40 => "694"
    41 => "SHIPPING"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
    29 => 2
    30 => 2
    31 => 2
    32 => 2
    33 => 2
    34 => 2
    35 => 2
    36 => 2
    37 => 2
    38 => 2
    39 => 2
    40 => 2
    41 => 2
  ]
]

[
  "sql" => "SELECT asiakasryhmat_nakyvyydet.id AS id, asiakasryhmat_nakyvyydet.lisatty AS created_at, asiakasryhmat_nakyvyydet.muokattu AS updated_at, asiakasryhmat_nakyvyydet.asiakasryhma_id AS customer_group_id, asiakasryhmat_nakyvyydet.objekti_tyyppi AS item_type, asiakasryhmat_nakyvyydet.objekti_id AS item_id, asiakasryhmat_nakyvyydet.nakyvilla AS is_visible FROM asiakasryhmat_nakyvyydet WHERE (objekti_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (objekti_tyyppi = ?)"
  "params" => [
    1 => "699"
    2 => "681"
    3 => "163"
    4 => "698"
    5 => "677"
    6 => "29"
    7 => "693"
    8 => "697"
    9 => "695"
    10 => "696"
    11 => "692"
    12 => "52"
    13 => "2"
    14 => "691"
    15 => "162"
    16 => "690"
    17 => "5"
    18 => "48"
    19 => "687"
    20 => "688"
    21 => "689"
    22 => "13"
    23 => "685"
    24 => "686"
    25 => "684"
    26 => "668"
    27 => "666"
    28 => "6"
    29 => "9"
    30 => "10"
    31 => "11"
    32 => "17"
    33 => "67"
    34 => "83"
    35 => "90"
    36 => "101"
    37 => "110"
    38 => "669"
    39 => "161"
    40 => "694"
    41 => "SHIPPING"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
    21 => 2
    22 => 2
    23 => 2
    24 => 2
    25 => 2
    26 => 2
    27 => 2
    28 => 2
    29 => 2
    30 => 2
    31 => 2
    32 => 2
    33 => 2
    34 => 2
    35 => 2
    36 => 2
    37 => 2
    38 => 2
    39 => 2
    40 => 2
    41 => 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 (discount_type = ?) AND (IFNULL(toimitustavat, '') <> '')"
  "params" => [
    1 => "LEGACY"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.sallitut_maat AS sallitut_maat_1, t0.postituskoot AS postituskoot_2, t0.poistettu AS poistettu_3, t0.id AS id_4, t0.logo AS logo_5, t0.nimi_fi AS nimi_fi_6, t0.vaadi_puhelin AS vaadi_puhelin_7, t0.tuotekoodi AS tuotekoodi_8, t0.kasittely AS kasittely_9, t0.asetukset AS asetukset_10, t0.shipping_additional_features AS shipping_additional_features_11, t0.jnro AS jnro_12, t0.tyyppi AS tyyppi_13, t0.rahtivapaus AS rahtivapaus_14, t0.lisatty AS lisatty_15, t0.muokattu AS muokattu_16 FROM toimitustavat t0 INNER JOIN campaign_shipping_methods ON t0.id = campaign_shipping_methods.shipping_method_id WHERE campaign_shipping_methods.campaign_id = ?"
  "params" => [
    1 => 146
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT shipping_method_translations.name AS name, shipping_method_translations.description AS description, shipping_method_translations.tracking_info AS tracking_info, shipping_method_translations.id AS id, shipping_method_translations.translatable_id AS translatable_id, shipping_method_translations.locale AS locale FROM shipping_method_translations WHERE translatable_id IN (?)"
  "params" => [
    1 => "699"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT shipping_method_translations.name AS name, shipping_method_translations.description AS description, shipping_method_translations.tracking_info AS tracking_info, shipping_method_translations.id AS id, shipping_method_translations.translatable_id AS translatable_id, shipping_method_translations.locale AS locale FROM shipping_method_translations WHERE translatable_id IN (?)"
  "params" => [
    1 => "677"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM campaign_translations t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => 146
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT shipping_method_translations.name AS name, shipping_method_translations.description AS description, shipping_method_translations.tracking_info AS tracking_info, shipping_method_translations.id AS id, shipping_method_translations.translatable_id AS translatable_id, shipping_method_translations.locale AS locale FROM shipping_method_translations WHERE translatable_id IN (?)"
  "params" => [
    1 => "29"
  ]
  "types" => [
    1 => 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_ee AS name_ee, tuotteet.tuotenimi_fi AS name_fi, tuotteet.tuotenimi_se AS name_se, tuotteet.tuotenimi_es AS name_es, tuotteet.tuotekuvaus_en AS description_en, tuotteet.tuotekuvaus_ee AS description_ee, tuotteet.tuotekuvaus_fi AS description_fi, tuotteet.tuotekuvaus_se AS description_se, tuotteet.tuotekuvaus_es AS description_es, tuotteet.tuotetiedot_en AS information_en, tuotteet.tuotetiedot_ee AS information_ee, tuotteet.tuotetiedot_fi AS information_fi, tuotteet.tuotetiedot_se AS information_se, tuotteet.tuotetiedot_es AS information_es, tuotteet.Title_en AS seo_title_en, tuotteet.Title_ee AS seo_title_ee, tuotteet.Title_fi AS seo_title_fi, tuotteet.Title_se AS seo_title_se, tuotteet.Title_es AS seo_title_es, tuotteet.PageTitle_en AS seo_page_title_en, tuotteet.PageTitle_ee AS seo_page_title_ee, tuotteet.PageTitle_fi AS seo_page_title_fi, tuotteet.PageTitle_se AS seo_page_title_se, tuotteet.PageTitle_es AS seo_page_title_es, tuotteet.MetaDescription_en AS seo_meta_description_en, tuotteet.MetaDescription_ee AS seo_meta_description_ee, tuotteet.MetaDescription_fi AS seo_meta_description_fi, tuotteet.MetaDescription_se AS seo_meta_description_se, tuotteet.MetaDescription_es AS seo_meta_description_es FROM tuotteet WHERE id = ?"
  "params" => [
    1 => 1421
  ]
  "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_ee AS name_ee, bundles.name_fi AS name_fi, bundles.name_se AS name_se, bundles.name_es AS name_es 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 = 3\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 (\n
    \t\t\tbundles.id IN (\n
    \t\t\t\tSELECT bundle_items.bundle_id\n
    \t\t\t\tFROM bundle_items\n
    \t\t\t\tWHERE bundle_items.product_id = 1421\n
    \t\t\t)\n
    \t\t) ORDER BY created_at DESC
    """
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT tuote2_id FROM tuotteet_yhteydet WHERE IFNULL(poistettu,0) = 0 AND yhteyden_tyyppi='SAMANKALTAINEN' AND tuote1_id IN (1421) GROUP BY tuote2_id ORDER BY jnro ASC"
]

[
  "sql" => "SELECT tuote2_id FROM tuotteet_yhteydet WHERE IFNULL(poistettu,0) = 0 AND yhteyden_tyyppi='YHTEENSOPIVA' AND tuote1_id IN (1421) GROUP BY tuote2_id ORDER BY jnro ASC"
]

[
  "sql" => "SELECT tuote2_id FROM tuotteet_yhteydet WHERE IFNULL(poistettu,0) = 0 AND yhteyden_tyyppi='LISAVARUSTE' AND tuote1_id IN (1421) GROUP BY tuote2_id ORDER BY jnro ASC"
]

[
  "sql" => "SELECT tuote2_id FROM tuotteet_yhteydet WHERE IFNULL(poistettu,0) = 0 AND yhteyden_tyyppi='VARAOSA' AND tuote1_id IN (1421) GROUP BY tuote2_id ORDER BY jnro ASC"
]

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

[
  "sql" => "SELECT id FROM kampanjat WHERE (ISNULL(poistettu) OR poistettu = 0) AND id IN ('1','9','12','20','37','62','63','65','69','72','73','75','96','99','100','101','102','114','122','129','130','133','134','139','146')"
]

[
  "sql" => "SELECT * FROM kampanjat WHERE id IN (1, 9, 12, 20, 37, 62, 63, 65, 69, 72, 73, 75, 96, 99, 100, 101, 102, 114, 122, 129, 130, 133, 134, 139, 146)"
]

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

[
  "sql" => "SELECT id FROM toimitustavat WHERE (ISNULL(poistettu) OR poistettu = 0) AND id IN ('698','681','677','29','691','699')"
]

[
  "sql" => "SELECT * FROM toimitustavat WHERE id IN (29, 677, 681, 691, 698, 699)"
]

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

[
  "sql" => "SELECT id FROM maksutavat WHERE (ISNULL(poistettu) OR poistettu = 0) AND id IN ('40')"
]

[
  "sql" => "SELECT * FROM maksutavat WHERE id IN (40)"
]

[
  "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_ee AS name_ee, tuotteet.tuotenimi_fi AS name_fi, tuotteet.tuotenimi_se AS name_se, tuotteet.tuotenimi_es AS name_es, tuotteet.tuotekuvaus_en AS description_en, tuotteet.tuotekuvaus_ee AS description_ee, tuotteet.tuotekuvaus_fi AS description_fi, tuotteet.tuotekuvaus_se AS description_se, tuotteet.tuotekuvaus_es AS description_es, tuotteet.tuotetiedot_en AS information_en, tuotteet.tuotetiedot_ee AS information_ee, tuotteet.tuotetiedot_fi AS information_fi, tuotteet.tuotetiedot_se AS information_se, tuotteet.tuotetiedot_es AS information_es, tuotteet.Title_en AS seo_title_en, tuotteet.Title_ee AS seo_title_ee, tuotteet.Title_fi AS seo_title_fi, tuotteet.Title_se AS seo_title_se, tuotteet.Title_es AS seo_title_es, tuotteet.PageTitle_en AS seo_page_title_en, tuotteet.PageTitle_ee AS seo_page_title_ee, tuotteet.PageTitle_fi AS seo_page_title_fi, tuotteet.PageTitle_se AS seo_page_title_se, tuotteet.PageTitle_es AS seo_page_title_es, tuotteet.MetaDescription_en AS seo_meta_description_en, tuotteet.MetaDescription_ee AS seo_meta_description_ee, tuotteet.MetaDescription_fi AS seo_meta_description_fi, tuotteet.MetaDescription_se AS seo_meta_description_se, tuotteet.MetaDescription_es AS seo_meta_description_es FROM tuotteet WHERE id = ?"
  "params" => [
    1 => 1421
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT tuoteryhmat_tuotteet.id AS id, tuoteryhmat_tuotteet.lisatty AS created_at, tuoteryhmat_tuotteet.muokattu AS updated_at, tuoteryhmat_tuotteet.tuoteryhma_id AS category_id, tuoteryhmat_tuotteet.tuoteryhma_jnro AS category_sort, tuoteryhmat_tuotteet.tuote_id AS product_id, tuoteryhmat_tuotteet.tuote_jnro AS product_sort FROM tuoteryhmat_tuotteet WHERE (tuote_id IN (?)) AND (tuoteryhma_id > ?) ORDER BY tuoteryhma_jnro ASC"
  "params" => [
    1 => "1421"
    2 => 0
  ]
  "types" => [
    1 => 2
    2 => 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_ee AS name_ee, tuoteryhmat.tuoteryhma_fi AS name_fi, tuoteryhmat.tuoteryhma_se AS name_se, tuoteryhmat.tuoteryhma_es AS name_es, tuoteryhmat.kuvaus_en AS description_en, tuoteryhmat.kuvaus_ee AS description_ee, tuoteryhmat.kuvaus_fi AS description_fi, tuoteryhmat.kuvaus_se AS description_se, tuoteryhmat.kuvaus_es AS description_es, tuoteryhmat.Title_en AS seo_title_en, tuoteryhmat.Title_ee AS seo_title_ee, tuoteryhmat.Title_fi AS seo_title_fi, tuoteryhmat.Title_se AS seo_title_se, tuoteryhmat.Title_es AS seo_title_es, tuoteryhmat.PageTitle_en AS seo_page_title_en, tuoteryhmat.PageTitle_ee AS seo_page_title_ee, tuoteryhmat.PageTitle_fi AS seo_page_title_fi, tuoteryhmat.PageTitle_se AS seo_page_title_se, tuoteryhmat.PageTitle_es AS seo_page_title_es, tuoteryhmat.MetaDescription_en AS seo_meta_description_en, tuoteryhmat.MetaDescription_ee AS seo_meta_description_ee, tuoteryhmat.MetaDescription_fi AS seo_meta_description_fi, tuoteryhmat.MetaDescription_se AS seo_meta_description_se, tuoteryhmat.MetaDescription_es AS seo_meta_description_es FROM tuoteryhmat WHERE id IN (?)"
  "params" => [
    1 => "42"
  ]
  "types" => [
    1 => 2
  ]
]

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

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

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

[
  "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_ee AS name_ee, tuotteet.tuotenimi_fi AS name_fi, tuotteet.tuotenimi_se AS name_se, tuotteet.tuotenimi_es AS name_es, tuotteet.tuotekuvaus_en AS description_en, tuotteet.tuotekuvaus_ee AS description_ee, tuotteet.tuotekuvaus_fi AS description_fi, tuotteet.tuotekuvaus_se AS description_se, tuotteet.tuotekuvaus_es AS description_es, tuotteet.tuotetiedot_en AS information_en, tuotteet.tuotetiedot_ee AS information_ee, tuotteet.tuotetiedot_fi AS information_fi, tuotteet.tuotetiedot_se AS information_se, tuotteet.tuotetiedot_es AS information_es, tuotteet.Title_en AS seo_title_en, tuotteet.Title_ee AS seo_title_ee, tuotteet.Title_fi AS seo_title_fi, tuotteet.Title_se AS seo_title_se, tuotteet.Title_es AS seo_title_es, tuotteet.PageTitle_en AS seo_page_title_en, tuotteet.PageTitle_ee AS seo_page_title_ee, tuotteet.PageTitle_fi AS seo_page_title_fi, tuotteet.PageTitle_se AS seo_page_title_se, tuotteet.PageTitle_es AS seo_page_title_es, tuotteet.MetaDescription_en AS seo_meta_description_en, tuotteet.MetaDescription_ee AS seo_meta_description_ee, tuotteet.MetaDescription_fi AS seo_meta_description_fi, tuotteet.MetaDescription_se AS seo_meta_description_se, tuotteet.MetaDescription_es AS seo_meta_description_es FROM tuotteet WHERE id = ?"
  "params" => [
    1 => 1421
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT id, tuotemerkki        AS name FROM tuotemerkit WHERE id IN('21')"
]

[
  "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 => "ville.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_ee AS name_ee, maksutavat.nimi_fi AS name_fi, maksutavat.nimi_se AS name_se, maksutavat.nimi_es AS name_es, maksutavat.selite_en AS description_en, maksutavat.selite_ee AS description_ee, maksutavat.selite_fi AS description_fi, maksutavat.selite_se AS description_se, maksutavat.selite_es AS description_es, maksutavat.maksuohje_en AS help_en, maksutavat.maksuohje_ee AS help_ee, maksutavat.maksuohje_fi AS help_fi, maksutavat.maksuohje_se AS help_se, maksutavat.maksuohje_es AS help_es FROM maksutavat WHERE (IFNULL(poistettu, 0) = 0) AND (maksupalvelu = ?)"
  "params" => [
    1 => "KCO_V3"
  ]
  "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, 21, 3, 24, 25, 9, 8)  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, 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 => 3
  ]
  "types" => [
    1 => 2
  ]
]