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
  *
FROM
  maksutavat
WHERE
  id IN (3, 4, 5, 6, 11, 12, 27, 29, 30, 31)

SELECT * FROM maksutavat WHERE id IN (3, 4, 5, 6, 11, 12, 27, 29, 30, 31);

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

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

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
  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
  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 = '5isjqedt8ioau9utljehcpdm53' AND IFNULL(poistettu, 0) = 0 LIMIT 1;

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
  code
FROM
  versiot
WHERE
  url = ?
LIMIT
  1

SELECT code FROM versiot WHERE url = 'ilkka.mcf.dev' LIMIT 1;

SELECT
  *
FROM
  kampanjat
WHERE
  id IN (2, 3)

SELECT * FROM kampanjat WHERE id IN (2, 3);

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

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 = 0;

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

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 = 'ilkka.mcf.dev';

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

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

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 = 2
						AND versiot_nakyvyydet.nakyvilla = '1'
						AND versiot_nakyvyydet.objekti_tyyppi = 'CATEGORY'
						AND versiot_nakyvyydet.objekti_id = tuoteryhmat.id;

SELECT
  *
FROM
  toimitustavat
WHERE
  id IN (1, 2, 111)

SELECT * FROM toimitustavat WHERE id IN (1, 2, 111);

SELECT
  id
FROM
  kampanjat
WHERE
  (
    ISNULL(poistettu)
    OR poistettu = 0
  )
  AND id IN ('2', '3')

SELECT id FROM kampanjat WHERE (ISNULL(poistettu) OR poistettu = 0) AND id IN ('2','3');