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

SELECT code FROM versiot WHERE url = 'ville.mcf.dev' LIMIT 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 = '0sfms1m0u0usoromg44t6uufp2' AND IFNULL(poistettu, 0) = 0 LIMIT 1;

select
  *
from
  istunnot
where
  tunniste = ?
limit
  1

select * from istunnot where tunniste = '0sfms1m0u0usoromg44t6uufp2' limit 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 = 'mucs8ci1s3tbjme18u23b0h61a' AND IFNULL(poistettu, 0) = 0 LIMIT 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 = 'mucs8ci1s3tbjme18u23b0h61a' AND IFNULL(poistettu, 0) = 0 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 = 'ville.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 = '3';

SELECT
  code AS kieli
FROM
  versiot
ORDER BY
  jnro,
  id

SELECT code AS kieli FROM versiot ORDER BY jnro, id;

select
  kaytossa
from
  laajennukset
where
  koodi = 'CustomUrls'

select kaytossa from laajennukset where koodi = 'CustomUrls';

SHOW TABLES LIKE 'redirects'

SHOW TABLES LIKE 'redirects';

SELECT
  new
FROM
  redirects
WHERE
  ? LIKE REPLACE(old, '*', '%')
  OR ? LIKE REPLACE(old, '*', '%')
ORDER BY
  old,
  new ASC
LIMIT
  1

SELECT new FROM redirects WHERE 'https://ville.mcf.dev/page/1' LIKE REPLACE(old, '*', '%') OR '/page/1' LIKE REPLACE(old, '*', '%') ORDER BY old, new ASC LIMIT 1;

select
  code
from
  versiot
where
  url = ?

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

select
  code
from
  versiot
order by
  jnro,
  id asc

select code from versiot order by jnro, id asc;

SELECT
  *
FROM
  `versiot`
LIMIT
  1

SELECT * FROM `versiot` LIMIT 1;

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

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

SELECT
  *
FROM
  versiot
WHERE
  id IN (3)

SELECT * FROM versiot WHERE id IN (3);

select
  nakyvilla
from
  versiot_nakyvyydet
where
  versio_id = '3'
  AND objekti_tyyppi = 'CATEGORY'
  AND objekti_id = '100'

select nakyvilla from versiot_nakyvyydet where versio_id='3' AND objekti_tyyppi='CATEGORY' AND objekti_id='100';

SELECT
  code
FROM
  maintenance
WHERE
  completed > 0

SELECT code FROM maintenance WHERE completed > 0;

SELECT
  koodi AS code,
  `en` AS translation
FROM
  kielitiedosto
WHERE
  `en` <> ''

SELECT koodi AS code, `en` AS translation FROM kielitiedosto WHERE `en` <> '';

SELECT
  koodi
FROM
  laajennukset
WHERE
  kaytossa = 1

SELECT koodi FROM laajennukset WHERE kaytossa = 1;

SELECT
  id
FROM
  istunnot
WHERE
  tunniste = 'mucs8ci1s3tbjme18u23b0h61a'
LIMIT
  1

SELECT id FROM istunnot WHERE tunniste = 'mucs8ci1s3tbjme18u23b0h61a' LIMIT 1;

SELECT
  *
FROM
  `ostoskorit`
LIMIT
  1

SELECT * FROM `ostoskorit` LIMIT 1;

select
  koodi as code
from
  laajennukset
where
  kaytossa = 1

select koodi as code from laajennukset where kaytossa = 1;

SELECT
  *
FROM
  `ostoskorit_tuotteet`
LIMIT
  1

SELECT * FROM `ostoskorit_tuotteet` LIMIT 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
  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
  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
  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);