Symfony Profiler

SELECT
  asetus AS db_name,
  arvo AS value
FROM
  asetukset
WHERE
  1

SELECT asetus AS db_name, arvo AS value FROM asetukset WHERE 1;

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')) AND (enabled = '1');

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

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

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
  parent.id parent_id,
  GROUP_CONCAT(
    child.id
    ORDER BY
      child.jnro SEPARATOR ','
  ) child_ids
FROM
  tuoteryhmat parent
  JOIN tuoteryhmat child ON parent.id = child.parent
  LEFT JOIN versiot_nakyvyydet parent_visibilities ON parent_visibilities.versio_id = :version_id
  AND parent_visibilities.objekti_tyyppi = 'CATEGORY'
  AND parent_visibilities.objekti_id = parent.id
  LEFT JOIN versiot_nakyvyydet child_visibilities ON child_visibilities.versio_id = :version_id
  AND child_visibilities.objekti_tyyppi = 'CATEGORY'
  AND child_visibilities.objekti_id = child.id
WHERE
  parent.id != child.id
  AND parent_visibilities.nakyvilla = 1
  AND child_visibilities.nakyvilla = 1
GROUP BY
  parent_id

SELECT parent.id                            parent_id,
				       GROUP_CONCAT(child.id ORDER BY child.jnro SEPARATOR ',') child_ids
				FROM tuoteryhmat parent
				         JOIN tuoteryhmat child
				              ON parent.id = child.parent
				         LEFT JOIN versiot_nakyvyydet parent_visibilities
				                   ON parent_visibilities.versio_id = 2
				                       AND parent_visibilities.objekti_tyyppi = 'CATEGORY'
				                       AND parent_visibilities.objekti_id = parent.id
				         LEFT JOIN versiot_nakyvyydet child_visibilities
				                   ON child_visibilities.versio_id = 2
				                       AND child_visibilities.objekti_tyyppi = 'CATEGORY'
				                       AND child_visibilities.objekti_id = child.id
				WHERE parent.id != child.id
				  AND parent_visibilities.nakyvilla = 1
				  AND child_visibilities.nakyvilla = 1
				GROUP BY parent_id;

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 = 'ilkka.mcf.dev' LIMIT 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 NOT EXISTS (SELECT * FROM asiakasryhmat_nakyvyydet WHERE objekti_tyyppi = 'CAMPAIGN' AND objekti_id = kampanjat.id AND nakyvilla = 1);

SELECT
  bundles.id AS id,
  bundles.created_at AS created_at,
  bundles.updated_at AS updated_at,
  bundles.deleted_at AS deleted_at,
  bundles.is_released AS is_released,
  bundles.category_id AS category_id,
  bundles.featured AS featured,
  bundles.name_en AS name_en,
  bundles.name_fi AS name_fi
FROM
  bundles
WHERE
  (bundles.deleted_at IS NULL)
  AND (bundles.is_released = ?)
  AND (
    bundles.id NOT IN (
      SELECT
        bundle_items.bundle_id
      FROM
        bundle_items
        LEFT JOIN versiot_nakyvyydet ON versiot_nakyvyydet.objekti_tyyppi = 'PRODUCT'
        AND versiot_nakyvyydet.objekti_id = bundle_items.product_id
        AND versiot_nakyvyydet.versio_id = 2
        AND versiot_nakyvyydet.nakyvilla = '1'
      WHERE
        versiot_nakyvyydet.nakyvilla IS NULL
    )
  )
  AND (bundles.category_id = ?)
ORDER BY
  created_at DESC

SELECT bundles.id AS id, bundles.created_at AS created_at, bundles.updated_at AS updated_at, bundles.deleted_at AS deleted_at, bundles.is_released AS is_released, bundles.category_id AS category_id, bundles.featured AS featured, bundles.name_en AS name_en, bundles.name_fi AS name_fi FROM bundles WHERE (bundles.deleted_at IS NULL) AND (bundles.is_released = '1') AND (
			bundles.id NOT IN (
				SELECT bundle_items.bundle_id
				FROM bundle_items
				LEFT JOIN versiot_nakyvyydet ON
						versiot_nakyvyydet.objekti_tyyppi = 'PRODUCT'
					AND versiot_nakyvyydet.objekti_id = bundle_items.product_id
					AND versiot_nakyvyydet.versio_id = 2
					AND versiot_nakyvyydet.nakyvilla = '1'
				WHERE versiot_nakyvyydet.nakyvilla IS NULL
			)
		) AND (bundles.category_id = '2') ORDER BY created_at DESC;

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
  CONCAT(tuotteet.id, '-0')
FROM
  tuoteryhmat_tuotteet
  INNER JOIN tuotteet ON tuoteryhmat_tuotteet.tuote_id = tuotteet.id
WHERE
  tuoteryhmat_tuotteet.tuoteryhma_id IN (2)

SELECT CONCAT(tuotteet.id, '-0')
				FROM tuoteryhmat_tuotteet
					INNER JOIN tuotteet ON tuoteryhmat_tuotteet.tuote_id = tuotteet.id
				WHERE tuoteryhmat_tuotteet.tuoteryhma_id IN (2)
			;

SELECT
  muokattu AS updated_at,
  data
FROM
  istunnot
WHERE
  tunniste = ?
  AND IFNULL(poistettu, 0) = 0
LIMIT
  1

SELECT muokattu AS updated_at, data FROM istunnot WHERE tunniste = 'so5rm57vm0jnjc0liha6prd5eh' AND IFNULL(poistettu, 0) = 0 LIMIT 1;

SELECT
  DISTINCT pa.code AS attribute_code,
  pav.code AS attribute_value_code
FROM
  product_features pf
  LEFT JOIN product_attribute_values pav ON pf.product_attribute_value_id = pav.id
  LEFT JOIN product_attributes pa ON pav.product_attribute_id = pa.id
WHERE
  product_id = ?
ORDER BY
  pa.sort,
  pav.sort

SELECT DISTINCT
	pa.code AS attribute_code,
	pav.code AS attribute_value_code
FROM product_features pf
	LEFT JOIN product_attribute_values pav ON pf.product_attribute_value_id = pav.id
	LEFT JOIN product_attributes pa ON pav.product_attribute_id = pa.id
WHERE product_id = 2
ORDER BY pa.sort, pav.sort;

SELECT
  *
FROM
  versiot
WHERE
  id = 2
LIMIT
  1

SELECT * FROM versiot WHERE id = 2 LIMIT 1;

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

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

SELECT
  tuotevalinnat.*,
  tuotteet_valinnat.tuote_id as tuote_id
FROM
  tuotevalinnat
  LEFT JOIN tuotteet_valinnat ON tuotevalinnat.id = tuotteet_valinnat.valinta_id
WHERE
  tuotteet_valinnat.vaihtoehto_id = 0
  AND tuotteet_valinnat.tuote_id IN ('2')
ORDER BY
  valinta_jnro