Symfony Profiler

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.description AS description_2,
  n0_.preview_text AS preview_text_3,
  n0_.code AS code_4,
  n0_.weight AS weight_5,
  n0_.is_section AS is_section_6,
  n0_.active AS active_7,
  n0_.pic AS pic_8,
  n0_.meta_title AS meta_title_9,
  n0_.meta_keywords AS meta_keywords_10,
  n0_.meta_desc AS meta_desc_11,
  n0_.views AS views_12,
  n0_.date AS date_13,
  n0_.date_start AS date_start_14,
  n0_.date_finish AS date_finish_15,
  n0_.p_id AS p_id_16
FROM
  news_data n0_
WHERE
  n0_.active = ?
  AND n0_.is_section = ?
  AND (
    n0_.date_start IS NULL
    OR n0_.date_start <= ?
  )
  AND (
    n0_.date_finish IS NULL
    OR n0_.date_finish >= ?
  )
  AND n0_.code = ?
ORDER BY
  n0_.id ASC
LIMIT
  1

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.preview_text AS preview_text_3, n0_.code AS code_4, n0_.weight AS weight_5, n0_.is_section AS is_section_6, n0_.active AS active_7, n0_.pic AS pic_8, n0_.meta_title AS meta_title_9, n0_.meta_keywords AS meta_keywords_10, n0_.meta_desc AS meta_desc_11, n0_.views AS views_12, n0_.date AS date_13, n0_.date_start AS date_start_14, n0_.date_finish AS date_finish_15, n0_.p_id AS p_id_16 FROM news_data n0_ WHERE n0_.active = 1 AND n0_.is_section = 0 AND (n0_.date_start IS NULL OR n0_.date_start <= 1773441107) AND (n0_.date_finish IS NULL OR n0_.date_finish >= 1773441107) AND n0_.code = 'chorna-pyatnitsya' ORDER BY n0_.id ASC LIMIT 1;

SELECT
  k0_.id AS id_0,
  k0_.name AS name_1,
  k0_.code AS code_2,
  k0_.active AS active_3,
  k0_.default AS default_4
FROM
  kk_language k0_
WHERE
  k0_.code = ?
LIMIT
  1

SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.code AS code_2, k0_.active AS active_3, k0_.default AS default_4 FROM kk_language k0_ WHERE k0_.code = 'uk' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.as_default AS as_default_2,
  s0_.product AS product_3,
  s0_.static AS static_4,
  s0_.news AS news_5,
  s0_.category AS category_6,
  s0_.subcategory AS subcategory_7,
  s0_.main AS main_8,
  s0_.catalog AS catalog_9
FROM
  seo_templates s0_
WHERE
  s0_.as_default = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.as_default AS as_default_2, s0_.product AS product_3, s0_.static AS static_4, s0_.news AS news_5, s0_.category AS category_6, s0_.subcategory AS subcategory_7, s0_.main AS main_8, s0_.catalog AS catalog_9 FROM seo_templates s0_ WHERE s0_.as_default = 1 LIMIT 1;

SELECT
  t0.currency_id AS currency_id_1,
  t0.currency AS currency_2,
  t0.is_cash AS is_cash_3,
  t0.rate AS rate_4
FROM
  Currencies t0

SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0;

SELECT
  t0.currency_id AS currency_id_1,
  t0.currency AS currency_2,
  t0.is_cash AS is_cash_3,
  t0.rate AS rate_4
FROM
  Currencies t0

SELECT t0.currency_id AS currency_id_1, t0.currency AS currency_2, t0.is_cash AS is_cash_3, t0.rate AS rate_4 FROM Currencies t0;

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.description AS description_2,
  n0_.preview_text AS preview_text_3,
  n0_.code AS code_4,
  n0_.weight AS weight_5,
  n0_.is_section AS is_section_6,
  n0_.active AS active_7,
  n0_.pic AS pic_8,
  n0_.meta_title AS meta_title_9,
  n0_.meta_keywords AS meta_keywords_10,
  n0_.meta_desc AS meta_desc_11,
  n0_.views AS views_12,
  n0_.date AS date_13,
  n0_.date_start AS date_start_14,
  n0_.date_finish AS date_finish_15,
  n0_.p_id AS p_id_16
FROM
  news_data n0_
WHERE
  n0_.active = ?
  AND n0_.is_section = ?
  AND (
    n0_.date_start IS NULL
    OR n0_.date_start <= ?
  )
  AND (
    n0_.date_finish IS NULL
    OR n0_.date_finish >= ?
  )
  AND n0_.id = ?
LIMIT
  1

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.preview_text AS preview_text_3, n0_.code AS code_4, n0_.weight AS weight_5, n0_.is_section AS is_section_6, n0_.active AS active_7, n0_.pic AS pic_8, n0_.meta_title AS meta_title_9, n0_.meta_keywords AS meta_keywords_10, n0_.meta_desc AS meta_desc_11, n0_.views AS views_12, n0_.date AS date_13, n0_.date_start AS date_start_14, n0_.date_finish AS date_finish_15, n0_.p_id AS p_id_16 FROM news_data n0_ WHERE n0_.active = 1 AND n0_.is_section = 0 AND (n0_.date_start IS NULL OR n0_.date_start <= 1773441107) AND (n0_.date_finish IS NULL OR n0_.date_finish >= 1773441107) AND n0_.id = 2 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  news_data
SET
  views = ?
WHERE
  id = ?

UPDATE news_data SET views = 52 WHERE id = 2;

"COMMIT"

"COMMIT";

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.description AS description_2,
  n0_.preview_text AS preview_text_3,
  n0_.code AS code_4,
  n0_.weight AS weight_5,
  n0_.is_section AS is_section_6,
  n0_.active AS active_7,
  n0_.pic AS pic_8,
  n0_.meta_title AS meta_title_9,
  n0_.meta_keywords AS meta_keywords_10,
  n0_.meta_desc AS meta_desc_11,
  n0_.views AS views_12,
  n0_.date AS date_13,
  n0_.date_start AS date_start_14,
  n0_.date_finish AS date_finish_15,
  n0_.p_id AS p_id_16
FROM
  news_data n0_
WHERE
  n0_.active = ?
  AND n0_.is_section = ?
  AND (
    n0_.date_start IS NULL
    OR n0_.date_start <= ?
  )
  AND (
    n0_.date_finish IS NULL
    OR n0_.date_finish >= ?
  )
  AND n0_.code = ?
ORDER BY
  n0_.id ASC
LIMIT
  1

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.preview_text AS preview_text_3, n0_.code AS code_4, n0_.weight AS weight_5, n0_.is_section AS is_section_6, n0_.active AS active_7, n0_.pic AS pic_8, n0_.meta_title AS meta_title_9, n0_.meta_keywords AS meta_keywords_10, n0_.meta_desc AS meta_desc_11, n0_.views AS views_12, n0_.date AS date_13, n0_.date_start AS date_start_14, n0_.date_finish AS date_finish_15, n0_.p_id AS p_id_16 FROM news_data n0_ WHERE n0_.active = 1 AND n0_.is_section = 0 AND (n0_.date_start IS NULL OR n0_.date_start <= 1773441107) AND (n0_.date_finish IS NULL OR n0_.date_finish >= 1773441107) AND n0_.code = 'chorna-pyatnitsya' ORDER BY n0_.id ASC LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.description AS description_2,
  n0_.preview_text AS preview_text_3,
  n0_.code AS code_4,
  n0_.weight AS weight_5,
  n0_.is_section AS is_section_6,
  n0_.active AS active_7,
  n0_.pic AS pic_8,
  n0_.meta_title AS meta_title_9,
  n0_.meta_keywords AS meta_keywords_10,
  n0_.meta_desc AS meta_desc_11,
  n0_.views AS views_12,
  n0_.date AS date_13,
  n0_.date_start AS date_start_14,
  n0_.date_finish AS date_finish_15,
  n0_.p_id AS p_id_16
FROM
  news_data n0_
WHERE
  n0_.active = ?
  AND n0_.is_section = ?
  AND (
    n0_.date_start IS NULL
    OR n0_.date_start <= ?
  )
  AND (
    n0_.date_finish IS NULL
    OR n0_.date_finish >= ?
  )
  AND n0_.id <> ?
  AND n0_.date <= ?
ORDER BY
  n0_.date DESC
LIMIT
  1

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.preview_text AS preview_text_3, n0_.code AS code_4, n0_.weight AS weight_5, n0_.is_section AS is_section_6, n0_.active AS active_7, n0_.pic AS pic_8, n0_.meta_title AS meta_title_9, n0_.meta_keywords AS meta_keywords_10, n0_.meta_desc AS meta_desc_11, n0_.views AS views_12, n0_.date AS date_13, n0_.date_start AS date_start_14, n0_.date_finish AS date_finish_15, n0_.p_id AS p_id_16 FROM news_data n0_ WHERE n0_.active = 1 AND n0_.is_section = 0 AND (n0_.date_start IS NULL OR n0_.date_start <= 1773441107) AND (n0_.date_finish IS NULL OR n0_.date_finish >= 1773441107) AND n0_.id <> 2 AND n0_.date <= 1730213640 ORDER BY n0_.date DESC LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.description AS description_2,
  n0_.preview_text AS preview_text_3,
  n0_.code AS code_4,
  n0_.weight AS weight_5,
  n0_.is_section AS is_section_6,
  n0_.active AS active_7,
  n0_.pic AS pic_8,
  n0_.meta_title AS meta_title_9,
  n0_.meta_keywords AS meta_keywords_10,
  n0_.meta_desc AS meta_desc_11,
  n0_.views AS views_12,
  n0_.date AS date_13,
  n0_.date_start AS date_start_14,
  n0_.date_finish AS date_finish_15,
  n0_.p_id AS p_id_16
FROM
  news_data n0_
WHERE
  n0_.active = ?
  AND n0_.is_section = ?
  AND (
    n0_.date_start IS NULL
    OR n0_.date_start <= ?
  )
  AND (
    n0_.date_finish IS NULL
    OR n0_.date_finish >= ?
  )
  AND n0_.code = ?
ORDER BY
  n0_.id ASC
LIMIT
  1

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.preview_text AS preview_text_3, n0_.code AS code_4, n0_.weight AS weight_5, n0_.is_section AS is_section_6, n0_.active AS active_7, n0_.pic AS pic_8, n0_.meta_title AS meta_title_9, n0_.meta_keywords AS meta_keywords_10, n0_.meta_desc AS meta_desc_11, n0_.views AS views_12, n0_.date AS date_13, n0_.date_start AS date_start_14, n0_.date_finish AS date_finish_15, n0_.p_id AS p_id_16 FROM news_data n0_ WHERE n0_.active = 1 AND n0_.is_section = 0 AND (n0_.date_start IS NULL OR n0_.date_start <= 1773441107) AND (n0_.date_finish IS NULL OR n0_.date_finish >= 1773441107) AND n0_.code = 'chorna-pyatnitsya' ORDER BY n0_.id ASC LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.description AS description_2,
  n0_.preview_text AS preview_text_3,
  n0_.code AS code_4,
  n0_.weight AS weight_5,
  n0_.is_section AS is_section_6,
  n0_.active AS active_7,
  n0_.pic AS pic_8,
  n0_.meta_title AS meta_title_9,
  n0_.meta_keywords AS meta_keywords_10,
  n0_.meta_desc AS meta_desc_11,
  n0_.views AS views_12,
  n0_.date AS date_13,
  n0_.date_start AS date_start_14,
  n0_.date_finish AS date_finish_15,
  n0_.p_id AS p_id_16
FROM
  news_data n0_
WHERE
  n0_.active = ?
  AND n0_.is_section = ?
  AND (
    n0_.date_start IS NULL
    OR n0_.date_start <= ?
  )
  AND (
    n0_.date_finish IS NULL
    OR n0_.date_finish >= ?
  )
  AND n0_.id <> ?
  AND n0_.date >= ?
ORDER BY
  n0_.date ASC
LIMIT
  1

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.preview_text AS preview_text_3, n0_.code AS code_4, n0_.weight AS weight_5, n0_.is_section AS is_section_6, n0_.active AS active_7, n0_.pic AS pic_8, n0_.meta_title AS meta_title_9, n0_.meta_keywords AS meta_keywords_10, n0_.meta_desc AS meta_desc_11, n0_.views AS views_12, n0_.date AS date_13, n0_.date_start AS date_start_14, n0_.date_finish AS date_finish_15, n0_.p_id AS p_id_16 FROM news_data n0_ WHERE n0_.active = 1 AND n0_.is_section = 0 AND (n0_.date_start IS NULL OR n0_.date_start <= 1773441107) AND (n0_.date_finish IS NULL OR n0_.date_finish >= 1773441107) AND n0_.id <> 2 AND n0_.date >= 1730213640 ORDER BY n0_.date ASC LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.description AS description_2,
  n0_.preview_text AS preview_text_3,
  n0_.code AS code_4,
  n0_.weight AS weight_5,
  n0_.is_section AS is_section_6,
  n0_.active AS active_7,
  n0_.pic AS pic_8,
  n0_.meta_title AS meta_title_9,
  n0_.meta_keywords AS meta_keywords_10,
  n0_.meta_desc AS meta_desc_11,
  n0_.views AS views_12,
  n0_.date AS date_13,
  n0_.date_start AS date_start_14,
  n0_.date_finish AS date_finish_15,
  n0_.p_id AS p_id_16
FROM
  news_data n0_
WHERE
  n0_.active = ?
  AND n0_.is_section = ?
  AND n0_.code = ?
ORDER BY
  n0_.id ASC
LIMIT
  1

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.preview_text AS preview_text_3, n0_.code AS code_4, n0_.weight AS weight_5, n0_.is_section AS is_section_6, n0_.active AS active_7, n0_.pic AS pic_8, n0_.meta_title AS meta_title_9, n0_.meta_keywords AS meta_keywords_10, n0_.meta_desc AS meta_desc_11, n0_.views AS views_12, n0_.date AS date_13, n0_.date_start AS date_start_14, n0_.date_finish AS date_finish_15, n0_.p_id AS p_id_16 FROM news_data n0_ WHERE n0_.active = 1 AND n0_.is_section = 1 AND n0_.code = 'news' ORDER BY n0_.id ASC LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.description AS description_2,
  n0_.preview_text AS preview_text_3,
  n0_.code AS code_4,
  n0_.weight AS weight_5,
  n0_.is_section AS is_section_6,
  n0_.active AS active_7,
  n0_.pic AS pic_8,
  n0_.meta_title AS meta_title_9,
  n0_.meta_keywords AS meta_keywords_10,
  n0_.meta_desc AS meta_desc_11,
  n0_.views AS views_12,
  n0_.date AS date_13,
  n0_.date_start AS date_start_14,
  n0_.date_finish AS date_finish_15,
  k1_.id AS id_16,
  k1_.ln_id AS ln_id_17,
  k1_.name AS name_18,
  k1_.description AS description_19,
  k1_.preview_text AS preview_text_20,
  k1_.meta_title AS meta_title_21,
  k1_.meta_keywords AS meta_keywords_22,
  k1_.meta_desc AS meta_desc_23,
  n0_.p_id AS p_id_24,
  k1_.data_id AS data_id_25
FROM
  news_data n0_
  LEFT JOIN kk_news_data_ln k1_ ON n0_.id = k1_.data_id
WHERE
  n0_.active = ?
  AND n0_.is_section = ?
  AND (
    n0_.date_start IS NULL
    OR n0_.date_start <= ?
  )
  AND (
    n0_.date_finish IS NULL
    OR n0_.date_finish >= ?
  )
  AND n0_.p_id = ?
ORDER BY
  n0_.views DESC,
  n0_.weight ASC,
  n0_.name ASC
LIMIT
  3

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.preview_text AS preview_text_3, n0_.code AS code_4, n0_.weight AS weight_5, n0_.is_section AS is_section_6, n0_.active AS active_7, n0_.pic AS pic_8, n0_.meta_title AS meta_title_9, n0_.meta_keywords AS meta_keywords_10, n0_.meta_desc AS meta_desc_11, n0_.views AS views_12, n0_.date AS date_13, n0_.date_start AS date_start_14, n0_.date_finish AS date_finish_15, k1_.id AS id_16, k1_.ln_id AS ln_id_17, k1_.name AS name_18, k1_.description AS description_19, k1_.preview_text AS preview_text_20, k1_.meta_title AS meta_title_21, k1_.meta_keywords AS meta_keywords_22, k1_.meta_desc AS meta_desc_23, n0_.p_id AS p_id_24, k1_.data_id AS data_id_25 FROM news_data n0_ LEFT JOIN kk_news_data_ln k1_ ON n0_.id = k1_.data_id WHERE n0_.active = 1 AND n0_.is_section = 0 AND (n0_.date_start IS NULL OR n0_.date_start <= 1773441107) AND (n0_.date_finish IS NULL OR n0_.date_finish >= 1773441107) AND n0_.p_id = 1 ORDER BY n0_.views DESC, n0_.weight ASC, n0_.name ASC LIMIT 3;

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.description AS description_2,
  n0_.preview_text AS preview_text_3,
  n0_.code AS code_4,
  n0_.weight AS weight_5,
  n0_.is_section AS is_section_6,
  n0_.active AS active_7,
  n0_.pic AS pic_8,
  n0_.meta_title AS meta_title_9,
  n0_.meta_keywords AS meta_keywords_10,
  n0_.meta_desc AS meta_desc_11,
  n0_.views AS views_12,
  n0_.date AS date_13,
  n0_.date_start AS date_start_14,
  n0_.date_finish AS date_finish_15,
  n0_.p_id AS p_id_16
FROM
  news_data n0_
WHERE
  n0_.active = ?
  AND n0_.is_section = ?
  AND n0_.code = ?
ORDER BY
  n0_.id ASC
LIMIT
  1

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.preview_text AS preview_text_3, n0_.code AS code_4, n0_.weight AS weight_5, n0_.is_section AS is_section_6, n0_.active AS active_7, n0_.pic AS pic_8, n0_.meta_title AS meta_title_9, n0_.meta_keywords AS meta_keywords_10, n0_.meta_desc AS meta_desc_11, n0_.views AS views_12, n0_.date AS date_13, n0_.date_start AS date_start_14, n0_.date_finish AS date_finish_15, n0_.p_id AS p_id_16 FROM news_data n0_ WHERE n0_.active = 1 AND n0_.is_section = 1 AND n0_.code = 'news' ORDER BY n0_.id ASC LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.description AS description_2,
  n0_.preview_text AS preview_text_3,
  n0_.code AS code_4,
  n0_.weight AS weight_5,
  n0_.is_section AS is_section_6,
  n0_.active AS active_7,
  n0_.pic AS pic_8,
  n0_.meta_title AS meta_title_9,
  n0_.meta_keywords AS meta_keywords_10,
  n0_.meta_desc AS meta_desc_11,
  n0_.views AS views_12,
  n0_.date AS date_13,
  n0_.date_start AS date_start_14,
  n0_.date_finish AS date_finish_15,
  k1_.id AS id_16,
  k1_.ln_id AS ln_id_17,
  k1_.name AS name_18,
  k1_.description AS description_19,
  k1_.preview_text AS preview_text_20,
  k1_.meta_title AS meta_title_21,
  k1_.meta_keywords AS meta_keywords_22,
  k1_.meta_desc AS meta_desc_23,
  n0_.p_id AS p_id_24,
  k1_.data_id AS data_id_25
FROM
  news_data n0_
  LEFT JOIN kk_news_data_ln k1_ ON n0_.id = k1_.data_id
WHERE
  n0_.active = ?
  AND n0_.is_section = ?
  AND (
    n0_.date_start IS NULL
    OR n0_.date_start <= ?
  )
  AND (
    n0_.date_finish IS NULL
    OR n0_.date_finish >= ?
  )
  AND n0_.p_id = ?
ORDER BY
  n0_.weight DESC,
  n0_.weight ASC,
  n0_.name ASC
LIMIT
  3

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.preview_text AS preview_text_3, n0_.code AS code_4, n0_.weight AS weight_5, n0_.is_section AS is_section_6, n0_.active AS active_7, n0_.pic AS pic_8, n0_.meta_title AS meta_title_9, n0_.meta_keywords AS meta_keywords_10, n0_.meta_desc AS meta_desc_11, n0_.views AS views_12, n0_.date AS date_13, n0_.date_start AS date_start_14, n0_.date_finish AS date_finish_15, k1_.id AS id_16, k1_.ln_id AS ln_id_17, k1_.name AS name_18, k1_.description AS description_19, k1_.preview_text AS preview_text_20, k1_.meta_title AS meta_title_21, k1_.meta_keywords AS meta_keywords_22, k1_.meta_desc AS meta_desc_23, n0_.p_id AS p_id_24, k1_.data_id AS data_id_25 FROM news_data n0_ LEFT JOIN kk_news_data_ln k1_ ON n0_.id = k1_.data_id WHERE n0_.active = 1 AND n0_.is_section = 0 AND (n0_.date_start IS NULL OR n0_.date_start <= 1773441107) AND (n0_.date_finish IS NULL OR n0_.date_finish >= 1773441107) AND n0_.p_id = 1 ORDER BY n0_.weight DESC, n0_.weight ASC, n0_.name ASC LIMIT 3;

SELECT
  s0_.setting_id AS setting_id_0,
  s0_.type AS type_1,
  s0_.setting_name AS setting_name_2,
  s0_.setting_value AS setting_value_3,
  s0_.description AS description_4
FROM
  store_settings s0_
  LEFT JOIN kk_settings_ln k1_ ON s0_.setting_id = k1_.setting_id
WHERE
  s0_.type = 'site'
  AND s0_.setting_name IN (?, ?, ?)
LIMIT
  3

SELECT s0_.setting_id AS setting_id_0, s0_.type AS type_1, s0_.setting_name AS setting_name_2, s0_.setting_value AS setting_value_3, s0_.description AS description_4 FROM store_settings s0_ LEFT JOIN kk_settings_ln k1_ ON s0_.setting_id = k1_.setting_id WHERE s0_.type = 'site' AND s0_.setting_name IN ('notify_top', 'datepicker', 'notify_url') LIMIT 3;