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

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
  versiot
WHERE
  id = 3
LIMIT
  1

SELECT * FROM versiot WHERE id = 3 LIMIT 1;

SELECT
  tuote_id
FROM
  kampanjat_tuotteet
WHERE
  kampanja_id = ?

SELECT tuote_id FROM kampanjat_tuotteet WHERE kampanja_id = 62;

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

SELECT * FROM `toimitustavat` LIMIT 1;

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

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,
  nimi_en AS name
FROM
  infosivut
WHERE
  id IN(
    '30', '29', '27', '3', '4', '5', '6',
    '8', '1', '9', '10', '11', '12', '13',
    '14', '15', '16', '17', '18', '19',
    '20', '21', '22'
  )

SELECT id, nimi_en       AS name FROM infosivut WHERE id IN('30','29','27','3','4','5','6','8','1','9','10','11','12','13','14','15','16','17','18','19','20','21','22');

SELECT
  id,
  parent AS parent_id
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
  )
ORDER BY
  jnro ASC

SELECT id, parent AS parent_id 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) ORDER BY jnro ASC;

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.alennusrivi_tuoteraportti_id AS alennusrivi_tuoteraportti_id_13,
  t0.alennusrivi_kohde AS alennusrivi_kohde_14,
  t0.alennusrivi_yksikko AS alennusrivi_yksikko_15,
  t0.alennusrivi_arvo AS alennusrivi_arvo_16,
  t0.tuotealennukset_yleinen AS tuotealennukset_yleinen_17,
  t0.minimitilaus AS minimitilaus_18,
  t0.tuotealennukset AS tuotealennukset_19,
  t0.maara_alennukset AS maara_alennukset_20,
  t0.toimitustavat AS toimitustavat_21,
  t0.sivu AS sivu_22,
  t0.kiinnitetty AS kiinnitetty_23,
  t0.price_list_id AS price_list_id_24,
  t0.discount_rules AS discount_rules_25,
  t0.sivu AS sivu_26,
  t0.kiinnitetty AS kiinnitetty_27
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.alennusrivi_tuoteraportti_id AS alennusrivi_tuoteraportti_id_13, t0.alennusrivi_kohde AS alennusrivi_kohde_14, t0.alennusrivi_yksikko AS alennusrivi_yksikko_15, t0.alennusrivi_arvo AS alennusrivi_arvo_16, t0.tuotealennukset_yleinen AS tuotealennukset_yleinen_17, t0.minimitilaus AS minimitilaus_18, t0.tuotealennukset AS tuotealennukset_19, t0.maara_alennukset AS maara_alennukset_20, t0.toimitustavat AS toimitustavat_21, t0.sivu AS sivu_22, t0.kiinnitetty AS kiinnitetty_23, t0.price_list_id AS price_list_id_24, t0.discount_rules AS discount_rules_25, t0.sivu AS sivu_26, t0.kiinnitetty AS kiinnitetty_27 FROM kampanjat t0 WHERE t0.id IN ('1', '9', '12', '20', '37', '62', '63', '65', '69', '72', '73', '75', '96', '99', '100', '101', '102', '114', '122', '129', '130', '133', '134', '139', '146') AND t0.discount_type IN ('DISCOUNT_CODES', 'FREE_SHIPPING', 'LEGACY', 'X_FOR_Y');

SELECT
  id
FROM
  kampanjat
WHERE
  (
    ISNULL(poistettu)
    OR poistettu = 0
  )

SELECT id FROM kampanjat WHERE (ISNULL(poistettu) OR poistettu = 0);

SELECT
  kampanjat.id
FROM
  kampanjat
  JOIN versiot_nakyvyydet ON kampanjat.enabled = 1
  AND versio_id = 3
  AND objekti_tyyppi = 'CAMPAIGN'
  AND objekti_id = kampanjat.id
  AND versiot_nakyvyydet.nakyvilla = 1

SELECT kampanjat.id
				FROM kampanjat
				JOIN versiot_nakyvyydet
					ON kampanjat.enabled = 1
					AND versio_id = 3
					AND objekti_tyyppi = 'CAMPAIGN'
					AND objekti_id = kampanjat.id
					AND versiot_nakyvyydet.nakyvilla = 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 = 'r7ed67omugd972tp5us482rifb' AND IFNULL(poistettu, 0) = 0 LIMIT 1;

SELECT
  *
FROM
  kampanjat
WHERE
  id IN (
    1, 9, 12, 20, 37, 62, 63, 65, 69, 72, 73,
    75, 96, 99, 100, 101, 102, 114, 122, 129,
    130, 133, 134, 139, 146
  )