Symfony Profiler

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

SELECT id FROM kampanjat WHERE NOT EXISTS (SELECT * FROM asiakasryhmat_nakyvyydet WHERE objekti_tyyppi = 'CAMPAIGN' AND objekti_id = kampanjat.id AND nakyvilla = 1);

SELECT
  id
FROM
  kampanjat
WHERE
  IFNULL(kampanjakoodi, '') = ''
  AND NOT EXISTS (
    SELECT
      *
    FROM
      kampanjat_koodit
    WHERE
      kampanja_id = kampanjat.id
  )

SELECT id FROM kampanjat WHERE IFNULL(kampanjakoodi, '') = '' AND NOT EXISTS (SELECT * FROM kampanjat_koodit WHERE kampanja_id = kampanjat.id);

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 = ?

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 = '14717';

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 = ?)

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 ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '17', '18', '19', '20', '21', '32', '34', '36', '37', '45', '46', '47', '48', '49', '52', '63', '64', '65', '69', '70', '71', '72', '73', '75', '74', '80', '82', '62', '87', '89', '91', '92', '93', '94', '95', '96', '97', '98', '99', '100', '101', '102', '114', '122', '129', '130', '131', '133', '134', '136', '139', '141', '142', '143', '144', '145', '146', '147')) AND (enabled = '1');

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

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 = 'ville.mcf.dev' LIMIT 1;

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 = ?)

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 ('699', '681', '163', '698', '677', '29', '693', '697', '695', '696', '692', '52', '2', '691', '162', '690', '5', '48', '687', '688', '689', '13', '685', '686', '684', '668', '666', '6', '9', '10', '11', '17', '67', '83', '90', '101', '110', '669', '161', '694')) AND (objekti_tyyppi = 'SHIPPING');

SELECT
  tuoteryhmat.*
FROM
  versiot_nakyvyydet
  JOIN tuoteryhmat ON versiot_nakyvyydet.versio_id = ?
  AND versiot_nakyvyydet.nakyvilla = '1'
  AND versiot_nakyvyydet.objekti_tyyppi = 'CATEGORY'
  AND versiot_nakyvyydet.objekti_id = tuoteryhmat.id

SELECT tuoteryhmat.*
				FROM versiot_nakyvyydet
					JOIN tuoteryhmat
						ON versiot_nakyvyydet.versio_id = 3
						AND versiot_nakyvyydet.nakyvilla = '1'
						AND versiot_nakyvyydet.objekti_tyyppi = 'CATEGORY'
						AND versiot_nakyvyydet.objekti_id = tuoteryhmat.id;

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

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

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_ee AS name_ee,
  infosivut.nimi_fi AS name_fi,
  infosivut.nimi_se AS name_se,
  infosivut.nimi_es AS name_es,
  infosivut.teksti_en AS content_en,
  infosivut.teksti_ee AS content_ee,
  infosivut.teksti_fi AS content_fi,
  infosivut.teksti_se AS content_se,
  infosivut.teksti_es AS content_es,
  infosivut.linkki_en AS link_en,
  infosivut.linkki_ee AS link_ee,
  infosivut.linkki_fi AS link_fi,
  infosivut.linkki_se AS link_se,
  infosivut.linkki_es AS link_es,
  infosivut.Title_en AS seo_title_en,
  infosivut.Title_ee AS seo_title_ee,
  infosivut.Title_fi AS seo_title_fi,
  infosivut.Title_se AS seo_title_se,
  infosivut.Title_es AS seo_title_es,
  infosivut.PageTitle_en AS seo_page_title_en,
  infosivut.PageTitle_ee AS seo_page_title_ee,
  infosivut.PageTitle_fi AS seo_page_title_fi,
  infosivut.PageTitle_se AS seo_page_title_se,
  infosivut.PageTitle_es AS seo_page_title_es,
  infosivut.MetaDescription_en AS seo_meta_description_en,
  infosivut.MetaDescription_ee AS seo_meta_description_ee,
  infosivut.MetaDescription_fi AS seo_meta_description_fi,
  infosivut.MetaDescription_se AS seo_meta_description_se,
  infosivut.MetaDescription_es AS seo_meta_description_es
FROM
  infosivut
WHERE
  id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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_ee AS name_ee, infosivut.nimi_fi AS name_fi, infosivut.nimi_se AS name_se, infosivut.nimi_es AS name_es, infosivut.teksti_en AS content_en, infosivut.teksti_ee AS content_ee, infosivut.teksti_fi AS content_fi, infosivut.teksti_se AS content_se, infosivut.teksti_es AS content_es, infosivut.linkki_en AS link_en, infosivut.linkki_ee AS link_ee, infosivut.linkki_fi AS link_fi, infosivut.linkki_se AS link_se, infosivut.linkki_es AS link_es, infosivut.Title_en AS seo_title_en, infosivut.Title_ee AS seo_title_ee, infosivut.Title_fi AS seo_title_fi, infosivut.Title_se AS seo_title_se, infosivut.Title_es AS seo_title_es, infosivut.PageTitle_en AS seo_page_title_en, infosivut.PageTitle_ee AS seo_page_title_ee, infosivut.PageTitle_fi AS seo_page_title_fi, infosivut.PageTitle_se AS seo_page_title_se, infosivut.PageTitle_es AS seo_page_title_es, infosivut.MetaDescription_en AS seo_meta_description_en, infosivut.MetaDescription_ee AS seo_meta_description_ee, infosivut.MetaDescription_fi AS seo_meta_description_fi, infosivut.MetaDescription_se AS seo_meta_description_se, infosivut.MetaDescription_es AS seo_meta_description_es FROM infosivut WHERE id IN ('1', '2', '3', '4', '5', '6', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30');

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 = ?)

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 ('699', '681', '163', '698', '677', '29', '693', '697', '695', '696', '692', '52', '2', '691', '162', '690', '5', '48', '687', '688', '689', '13', '685', '686', '684', '668', '666', '6', '9', '10', '11', '17', '67', '83', '90', '101', '110', '669', '161', '694')) AND (objekti_tyyppi = 'SHIPPING');

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

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 ('14717')) AND (tuoteryhma_id > 0) ORDER BY tuoteryhma_jnro ASC;

SELECT
  campaign_translations.name AS name,
  campaign_translations.description AS description,
  campaign_translations.seo_title AS seo_title,
  campaign_translations.seo_page_title AS seo_page_title,
  campaign_translations.seo_meta_description AS seo_meta_description,
  campaign_translations.id AS id,
  campaign_translations.translatable_id AS translatable_id,
  campaign_translations.locale AS locale
FROM
  campaign_translations
WHERE
  translatable_id = ?

SELECT campaign_translations.name AS name, campaign_translations.description AS description, campaign_translations.seo_title AS seo_title, campaign_translations.seo_page_title AS seo_page_title, campaign_translations.seo_meta_description AS seo_meta_description, campaign_translations.id AS id, campaign_translations.translatable_id AS translatable_id, campaign_translations.locale AS locale FROM campaign_translations WHERE translatable_id = '21';