Redirect 301 redirect from GET @news_single (1e60e5)

GET https://b2c-leobro.url.org.ua/info-news/detail/kak-pravilno-vybrat-invertor/

Query Metrics

38 Database Queries
26 Different statements
33.34 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
12.49 ms
(37.45%)
2
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "leobro"
]
4.70 ms
(14.10%)
1
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'leobro' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[
  "leobro"
  "doctrine_migration_versions"
]
3.59 ms
(10.78%)
1
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS TYPE,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS COMMENT,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS COLLATION
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[
  "leobro"
  "leobro"
  "doctrine_migration_versions"
]
1.24 ms
(3.72%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.weight AS weight_3, s0_.description AS description_4, s0_.full_description AS full_description_5, s0_.code AS code_6, s0_.meta_title AS meta_title_7, s0_.meta_desc AS meta_desc_8, s0_.meta_keywords AS meta_keywords_9, k1_.id AS id_10, k1_.ln_id AS ln_id_11, k1_.name AS name_12, k1_.description AS description_13, k1_.preview_text AS preview_text_14, k1_.meta_title AS meta_title_15, k1_.meta_keywords AS meta_keywords_16, k1_.meta_desc AS meta_desc_17, k1_.data_id AS data_id_18 FROM static_pages s0_ LEFT JOIN kk_static_pages_ln k1_ ON s0_.id = k1_.data_id WHERE s0_.active = ? ORDER BY s0_.weight ASC LIMIT 20
Parameters:
[
  1
]
1.12 ms
(3.36%)
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_.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
Parameters:
[
  1
  0
  1766637887
  1766637887
  "kak-pravilno-vybrat-invertor"
]
1.04 ms
(3.12%)
6
SELECT DATABASE()
Parameters:
[]
0.96 ms
(2.87%)
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
Parameters:
[
  1
  0
  1766637887
  1766637887
  1
]
0.87 ms
(2.62%)
1
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
	     ON /*M!101001 ccsa.FULL_COLLATION_NAME = t.TABLE_COLLATION OR */
               ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[
  "leobro"
  "doctrine_migration_versions"
]
0.75 ms
(2.25%)
3
SELECT t0.id AS id_1, t0.ln_id AS ln_id_2, t0.name AS name_3, t0.description AS description_4, t0.preview_text AS preview_text_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_desc AS meta_desc_8, t0.data_id AS data_id_9 FROM kk_news_data_ln t0 WHERE t0.data_id = ?
Parameters:
[
  88
]
0.65 ms
(1.96%)
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
Parameters:
[
  1
  0
  1766637887
  1766637887
  1
]
0.61 ms
(1.83%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, k1_.id AS id_11, k1_.ln_id AS ln_id_12, k1_.name AS name_13, s0_.category_id AS category_id_14, k1_.menu_id AS menu_id_15 FROM site_menu s0_ LEFT JOIN kk_site_menu_ln k1_ ON s0_.id = k1_.menu_id WHERE s0_.is_active = 1 AND s0_.lft > ? AND s0_.rgt < ? AND s0_.level = ? AND s0_.id > 0 AND s0_.is_menu_item = ? ORDER BY s0_.lft ASC
Parameters:
[
  1
  2
  1
  1
]
0.59 ms
(1.78%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.lft AS lft_2, s0_.level AS level_3, s0_.rgt AS rgt_4, s0_.is_published AS is_published_5, s0_.is_active AS is_active_6, s0_.is_menu_item AS is_menu_item_7, s0_.is_hot_filter AS is_hot_filter_8, s0_.img AS img_9, s0_.filters AS filters_10, s0_.category_id AS category_id_11 FROM site_menu s0_ WHERE s0_.id = ? AND s0_.is_active = 1 AND s0_.is_menu_item = 1 LIMIT 1
Parameters:
[
  0
]
0.57 ms
(1.71%)
2
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
Parameters:
[
  1
  1
  "news"
]
0.53 ms
(1.58%)
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
Parameters:
[
  1
  0
  1766637887
  1766637887
  88
  1727092500
]
0.46 ms
(1.38%)
1
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
Parameters:
[
  "notify_top"
  "datepicker"
  "notify_url"
]
0.45 ms
(1.35%)
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 = ? LIMIT 1
Parameters:
[
  1
  0
  1766637887
  1766637887
  88
]
0.44 ms
(1.32%)
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
Parameters:
[
  1
  0
  1766637887
  1766637887
  88
  1727092500
]
0.39 ms
(1.18%)
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
Parameters:
[
  "uk"
]
0.38 ms
(1.14%)
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
Parameters:
[
  1
]
0.33 ms
(0.98%)
1
UPDATE news_data SET views = ? WHERE id = ?
Parameters:
[
  3946
  88
]
0.31 ms
(0.94%)
2
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
Parameters:
[]
0.28 ms
(0.83%)
1
SELECT t0.data_id AS data_id_1, t0.ln_id AS ln_id_2, t0.product AS product_3, t0.static AS static_4, t0.news AS news_5, t0.category AS category_6, t0.subcategory AS subcategory_7, t0.main AS main_8, t0.catalog AS catalog_9, t0.data_id AS data_id_10 FROM kk_seo_templates_ln t0 WHERE t0.data_id = ?
Parameters:
[
  1
]
0.23 ms
(0.70%)
1
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[
  "leobro"
  "doctrine_migration_versions"
]
0.19 ms
(0.56%)
1
"COMMIT"
Parameters:
[]
0.09 ms
(0.27%)
1
SELECT * FROM doctrine_migration_versions
Parameters:
[]
0.08 ms
(0.23%)
1
"START TRANSACTION"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.