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

SELECT
  code
FROM
  versiot
WHERE
  url = ?
LIMIT
  1

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

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

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

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

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 = 2 AND l0_.deleted_at IS NULL;

SELECT
  t0.enabled AS enabled_1,
  t0.id AS id_2,
  t0.source_id AS source_id_3,
  t0.source_type AS source_type_4,
  t0.alkaa AS alkaa_5,
  t0.paattyy AS paattyy_6,
  t0.lisatty AS lisatty_7,
  t0.muokattu AS muokattu_8,
  t0.discount_type,
  t0.kampanjakoodi AS kampanjakoodi_9,
  t0.discount_rules AS discount_rules_10,
  t0.kampanjakoodi AS kampanjakoodi_11,
  t0.alennusrivi AS alennusrivi_12,
  t0.tuotealennukset AS tuotealennukset_13,
  t0.maara_alennukset AS maara_alennukset_14,
  t0.tuotealennukset_yleinen AS tuotealennukset_yleinen_15,
  t0.toimitustavat AS toimitustavat_16,
  t0.minimitilaus AS minimitilaus_17,
  t0.sivu AS sivu_18,
  t0.kiinnitetty AS kiinnitetty_19,
  t0.price_list_id AS price_list_id_20,
  t0.discount_rules AS discount_rules_21,
  t0.sivu AS sivu_22,
  t0.kiinnitetty AS kiinnitetty_23
FROM
  kampanjat t0
WHERE
  t0.id IN (?, ?)
  AND t0.discount_type IN (
    'DISCOUNT_CODES', 'FREE_SHIPPING',
    'LEGACY', 'X_FOR_Y'
  )

SELECT t0.enabled AS enabled_1, t0.id AS id_2, t0.source_id AS source_id_3, t0.source_type AS source_type_4, t0.alkaa AS alkaa_5, t0.paattyy AS paattyy_6, t0.lisatty AS lisatty_7, t0.muokattu AS muokattu_8, t0.discount_type, t0.kampanjakoodi AS kampanjakoodi_9, t0.discount_rules AS discount_rules_10, t0.kampanjakoodi AS kampanjakoodi_11, t0.alennusrivi AS alennusrivi_12, t0.tuotealennukset AS tuotealennukset_13, t0.maara_alennukset AS maara_alennukset_14, t0.tuotealennukset_yleinen AS tuotealennukset_yleinen_15, t0.toimitustavat AS toimitustavat_16, t0.minimitilaus AS minimitilaus_17, t0.sivu AS sivu_18, t0.kiinnitetty AS kiinnitetty_19, t0.price_list_id AS price_list_id_20, t0.discount_rules AS discount_rules_21, t0.sivu AS sivu_22, t0.kiinnitetty AS kiinnitetty_23 FROM kampanjat t0 WHERE t0.id IN ('2', '3') AND t0.discount_type IN ('DISCOUNT_CODES', 'FREE_SHIPPING', 'LEGACY', 'X_FOR_Y');

SELECT
  code
FROM
  maintenance
WHERE
  completed > 0

SELECT code FROM maintenance WHERE completed > 0;

SELECT
  *
FROM
  versiot
WHERE
  id = 2
LIMIT
  1

SELECT * FROM versiot WHERE id = 2 LIMIT 1;

SELECT
  id
FROM
  versiot
WHERE
  (
    ISNULL(poistettu)
    OR poistettu = 0
  )
  AND url = 'ilkka.mcf.dev'
LIMIT
  1

SELECT id FROM versiot WHERE (ISNULL(poistettu) OR poistettu = 0) AND url = 'ilkka.mcf.dev' LIMIT 1;

SELECT
  tuote_id
FROM
  kampanjat_tuotteet
WHERE
  kampanja_id = ?

SELECT tuote_id FROM kampanjat_tuotteet WHERE kampanja_id = 2;

select
  kaytossa
from
  laajennukset
where
  koodi = 'CustomUrls'

select kaytossa from laajennukset where koodi = 'CustomUrls';

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
  code AS kieli
FROM
  versiot
ORDER BY
  jnro,
  id

SELECT code AS kieli FROM versiot ORDER BY jnro, 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 = ?

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
  nakyvilla
from
  versiot_nakyvyydet
where
  versio_id = '2'
  AND objekti_tyyppi = 'CATEGORY'
  AND objekti_id = '1'

select nakyvilla from versiot_nakyvyydet where versio_id='2' AND objekti_tyyppi='CATEGORY' AND objekti_id='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
  *
FROM
  `versiot`
LIMIT
  1

SELECT * FROM `versiot` LIMIT 1;

select
  code
from
  versiot
where
  url = ?

select code from versiot where url = 'ilkka.mcf.dev';

SELECT
  *
FROM
  versiot
WHERE
  id IN (2)

SELECT * FROM versiot WHERE id IN (2);

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
  *
FROM
  `ostoskorit`
LIMIT
  1

SELECT * FROM `ostoskorit` LIMIT 1;

SELECT
  koodi
FROM
  laajennukset
WHERE
  kaytossa = 1

SELECT koodi FROM laajennukset WHERE kaytossa = 1;

SELECT
  id
FROM
  ostoskorit_tuotteet
WHERE
  (
    ISNULL(poistettu)
    OR poistettu = 0
  )
  AND ostoskori_id = '0'

SELECT id FROM ostoskorit_tuotteet WHERE (ISNULL(poistettu) OR poistettu = 0) AND ostoskori_id = '0';

SELECT
  *
FROM
  `osoitekirja`
LIMIT
  1

SELECT * FROM `osoitekirja` LIMIT 1;