Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

45 Database Queries

14 Different statements

103.81 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.publication_date AS publication_date_3, n0_.video1 AS video1_4, n0_.video2 AS video2_5, n0_.besoccer_id AS besoccer_id_6, n0_.kaltura_id AS kaltura_id_7, n0_.active AS active_8, n1_.title AS title_9, n1_.cod_lang AS cod_lang_10, n1_.text AS text_11, n1_.seo_title AS seo_title_12, n1_.seo_description AS seo_description_13, n1_.subtitle AS subtitle_14, n2_.id AS id_15, n2_.date_created AS date_created_16, n2_.date_modified AS date_modified_17, n2_.sort AS sort_18, n2_.active AS active_19, n3_.name AS name_20, n3_.cod_lang AS cod_lang_21, n0_.banner_id AS banner_id_22, n0_.banner2_id AS banner2_id_23, n1_.news_id AS news_id_24, n2_.banner_id AS banner_id_25, n3_.news_category_id AS news_category_id_26 FROM news n0_ LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id LEFT JOIN news_news_category n4_ ON n0_.id = n4_.news_id LEFT JOIN news_category n2_ ON n2_.id = n4_.news_category_id LEFT JOIN news_category_i18n n3_ ON n2_.id = n3_.news_category_id WHERE COALESCE(n1_.title, '') <> '' AND n1_.cod_lang = ? AND n0_.id = ? AND n0_.active = 1 AND n2_.active = 1 AND n0_.publication_date <= ? AND n3_.cod_lang = ?
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC
SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.active AS active_2, s0_.sort AS sort_3, s0_.date_created AS date_created_4, s0_.date_modified AS date_modified_5, s1_.title AS title_6, s1_.second_title AS second_title_7, s1_.description AS description_8, s1_.seo_title AS seo_title_9, s1_.seo_description AS seo_description_10, s1_.cod_lang AS cod_lang_11, s0_.parent_id AS parent_id_12, s1_.section_id AS section_id_13 FROM section s0_ LEFT JOIN section_i18n s1_ ON s0_.id = s1_.section_id WHERE s1_.cod_lang = ? AND s0_.active = 1 AND s0_.code = ?
SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.size AS size_6, t0.itemId AS itemId_7, t0.section AS section_8, t0.type AS type_9, t0.sort AS sort_10 FROM file t0 WHERE t0.itemId = ? AND t0.section = ? AND t0.type = ? ORDER BY t0.sort ASC LIMIT 1
SELECT title, link
          FROM news_category_banner_i18n 
          WHERE news_category_banner_id = :news_category_banner_id
            AND cod_lang = :cod_lang
SELECT title, link
          FROM news_category_banner_i18n 
          WHERE news_category_banner_id = :news_category_banner_id
            AND cod_lang = :cod_lang
SELECT title, link
          FROM news_category_banner_i18n 
          WHERE news_category_banner_id = :news_category_banner_id
            AND cod_lang = :cod_lang
SELECT title, link
          FROM news_category_banner_i18n 
          WHERE news_category_banner_id = :news_category_banner_id
            AND cod_lang = :cod_lang
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.size AS size_6, t0.itemId AS itemId_7, t0.section AS section_8, t0.type AS type_9, t0.sort AS sort_10 FROM file t0 WHERE t0.itemId = ? AND t0.section = ? AND t0.type = ? ORDER BY t0.sort ASC LIMIT 1
SELECT title, link
          FROM news_category_banner_i18n 
          WHERE news_category_banner_id = :news_category_banner_id
            AND cod_lang = :cod_lang
SELECT title, link
          FROM news_category_banner_i18n 
          WHERE news_category_banner_id = :news_category_banner_id
            AND cod_lang = :cod_lang
SELECT title, link
          FROM news_category_banner_i18n 
          WHERE news_category_banner_id = :news_category_banner_id
            AND cod_lang = :cod_lang
SELECT title, link
          FROM news_category_banner_i18n 
          WHERE news_category_banner_id = :news_category_banner_id
            AND cod_lang = :cod_lang
SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.publication_date AS publication_date_3, n0_.video1 AS video1_4, n0_.video2 AS video2_5, n0_.besoccer_id AS besoccer_id_6, n0_.kaltura_id AS kaltura_id_7, n0_.active AS active_8, n1_.title AS title_9, n1_.cod_lang AS cod_lang_10, n1_.text AS text_11, n1_.seo_title AS seo_title_12, n1_.seo_description AS seo_description_13, n1_.subtitle AS subtitle_14, n2_.id AS id_15, n2_.date_created AS date_created_16, n2_.date_modified AS date_modified_17, n2_.sort AS sort_18, n2_.active AS active_19, n0_.banner_id AS banner_id_20, n0_.banner2_id AS banner2_id_21, n1_.news_id AS news_id_22, n2_.banner_id AS banner_id_23 FROM news n0_ LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_id INNER JOIN news_category n2_ ON n2_.id = n3_.news_category_id WHERE COALESCE(n1_.title, '') <> '' AND n1_.cod_lang = ? AND n0_.active = 1 AND n2_.id = ? AND n0_.publication_date <= ? AND n0_.id <> 9686 ORDER BY n0_.publication_date DESC LIMIT 5
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1
SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1
SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1
SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1
SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1
SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC
SELECT t0_.id AS id_0, t0_.date_created AS date_created_1, t0_.date_modified AS date_modified_2, t0_.sort AS sort_3, t0_.active AS active_4, t0_.besoccer_id AS besoccer_id_5, t0_.league_besoccer_id AS league_besoccer_id_6, t0_.group_id AS group_id_7, t0_.gender AS gender_8, t0_.summary AS summary_9, t0_.base AS base_10, t1_.name AS name_11, t1_.cod_lang AS cod_lang_12, t1_.stadium AS stadium_13, t0_.category_team_id AS category_team_id_14, t1_.team_id AS team_id_15 FROM team t0_ LEFT JOIN team_i18n t1_ ON t0_.id = t1_.team_id WHERE t0_.active = 1 AND t1_.cod_lang = ? AND t0_.sort IS NOT NULL ORDER BY t0_.sort ASC, t1_.cod_lang ASC
SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n0_.active = 1 AND n1_.cod_lang = ? ORDER BY n0_.sort ASC
SELECT s0_.id AS id_0, s0_.date_created AS date_created_1, s0_.date_modified AS date_modified_2, s0_.sort AS sort_3, s0_.active AS active_4, s0_.highlighted AS highlighted_5, s0_.hide_by_ip AS hide_by_ip_6, s1_.link AS link_7, s1_.title AS title_8, s1_.cod_lang AS cod_lang_9, s0_.category_sponsor_id AS category_sponsor_id_10, s1_.sponsor_id AS sponsor_id_11 FROM sponsor s0_ LEFT JOIN sponsor_i18n s1_ ON s0_.id = s1_.sponsor_id WHERE s0_.highlighted = 1 AND s0_.active = 1 AND s1_.cod_lang = ? ORDER BY s0_.sort ASC
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1
(SELECT * 
                FROM sponsor_header
                WHERE fixed = 1 AND active = 1
                ORDER BY sort
                LIMIT 1)
            UNION
                (SELECT * 
                FROM sponsor_header
                WHERE fixed <> 1 AND active = 1
                ORDER BY RAND() /* , sort ASC Si queremos la característica de que dentro de los 2 escogidos al azar se respete el orden asignado por el cliente  15/06/2022: Ahora sólo será 1 escogido al azar */
                LIMIT 2)
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_modified AS date_modified_3, t0.kaltura_id AS kaltura_id_4, t0.active AS active_5 FROM audio t0 WHERE t0.active = ? LIMIT 1
SELECT title, subtitle, text, seo_title AS seoTitle,
                 seo_description AS seoDescription
          FROM news_i18n 
          WHERE news_id = :news_id
            AND cod_lang = :cod_lang
SELECT title, subtitle, text, seo_title AS seoTitle,
                 seo_description AS seoDescription
          FROM news_i18n 
          WHERE news_id = :news_id
            AND cod_lang = :cod_lang
SELECT title, subtitle, text, seo_title AS seoTitle,
                 seo_description AS seoDescription
          FROM news_i18n 
          WHERE news_id = :news_id
            AND cod_lang = :cod_lang
SELECT title, subtitle, text, seo_title AS seoTitle,
                 seo_description AS seoDescription
          FROM news_i18n 
          WHERE news_id = :news_id
            AND cod_lang = :cod_lang

#▲	Time	Info
1	1.50 ms	SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.publication_date AS publication_date_3, n0_.video1 AS video1_4, n0_.video2 AS video2_5, n0_.besoccer_id AS besoccer_id_6, n0_.kaltura_id AS kaltura_id_7, n0_.active AS active_8, n1_.title AS title_9, n1_.cod_lang AS cod_lang_10, n1_.text AS text_11, n1_.seo_title AS seo_title_12, n1_.seo_description AS seo_description_13, n1_.subtitle AS subtitle_14, n2_.id AS id_15, n2_.date_created AS date_created_16, n2_.date_modified AS date_modified_17, n2_.sort AS sort_18, n2_.active AS active_19, n3_.name AS name_20, n3_.cod_lang AS cod_lang_21, n0_.banner_id AS banner_id_22, n0_.banner2_id AS banner2_id_23, n1_.news_id AS news_id_24, n2_.banner_id AS banner_id_25, n3_.news_category_id AS news_category_id_26 FROM news n0_ LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id LEFT JOIN news_news_category n4_ ON n0_.id = n4_.news_id LEFT JOIN news_category n2_ ON n2_.id = n4_.news_category_id LEFT JOIN news_category_i18n n3_ ON n2_.id = n3_.news_category_id WHERE COALESCE(n1_.title, '') <> '' AND n1_.cod_lang = ? AND n0_.id = ? AND n0_.active = 1 AND n2_.active = 1 AND n0_.publication_date <= ? AND n3_.cod_lang = ? Parameters: [`"cn" 9686 "2025-10-19 04:53:10" "cn"`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.publication_date AS publication_date_3, n0_.video1 AS video1_4, n0_.video2 AS video2_5, n0_.besoccer_id AS besoccer_id_6, n0_.kaltura_id AS kaltura_id_7, n0_.active AS active_8, n1_.title AS title_9, n1_.cod_lang AS cod_lang_10, n1_.text AS text_11, n1_.seo_title AS seo_title_12, n1_.seo_description AS seo_description_13, n1_.subtitle AS subtitle_14, n2_.id AS id_15, n2_.date_created AS date_created_16, n2_.date_modified AS date_modified_17, n2_.sort AS sort_18, n2_.active AS active_19, n3_.name AS name_20, n3_.cod_lang AS cod_lang_21, n0_.banner_id AS banner_id_22, n0_.banner2_id AS banner2_id_23, n1_.news_id AS news_id_24, n2_.banner_id AS banner_id_25, n3_.news_category_id AS news_category_id_26 FROM news n0_ LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id LEFT JOIN news_news_category n4_ ON n0_.id = n4_.news_id LEFT JOIN news_category n2_ ON n2_.id = n4_.news_category_id LEFT JOIN news_category_i18n n3_ ON n2_.id = n3_.news_category_id WHERE COALESCE(n1_.title, '') <> '' AND n1_.cod_lang = ? AND n0_.id = ? AND n0_.active = 1 AND n2_.active = 1 AND n0_.publication_date <= ? AND n3_.cod_lang = ? SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.publication_date AS publication_date_3, n0_.video1 AS video1_4, n0_.video2 AS video2_5, n0_.besoccer_id AS besoccer_id_6, n0_.kaltura_id AS kaltura_id_7, n0_.active AS active_8, n1_.title AS title_9, n1_.cod_lang AS cod_lang_10, n1_.text AS text_11, n1_.seo_title AS seo_title_12, n1_.seo_description AS seo_description_13, n1_.subtitle AS subtitle_14, n2_.id AS id_15, n2_.date_created AS date_created_16, n2_.date_modified AS date_modified_17, n2_.sort AS sort_18, n2_.active AS active_19, n3_.name AS name_20, n3_.cod_lang AS cod_lang_21, n0_.banner_id AS banner_id_22, n0_.banner2_id AS banner2_id_23, n1_.news_id AS news_id_24, n2_.banner_id AS banner_id_25, n3_.news_category_id AS news_category_id_26 FROM news n0_ LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id LEFT JOIN news_news_category n4_ ON n0_.id = n4_.news_id LEFT JOIN news_category n2_ ON n2_.id = n4_.news_category_id LEFT JOIN news_category_i18n n3_ ON n2_.id = n3_.news_category_id WHERE COALESCE(n1_.title, '') <> '' AND n1_.cod_lang = 'cn' AND n0_.id = 9686 AND n0_.active = 1 AND n2_.active = 1 AND n0_.publication_date <= '2025-10-19 04:53:10' AND n3_.cod_lang = 'cn';
2	0.83 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC Parameters: [`9686 "news" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 9686 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC;
3	0.61 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC Parameters: [`9686 "news" "document_cn"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 9686 AND f0_.section = 'news' AND f0_.type = 'document_cn' ORDER BY f0_.sort ASC;
4	0.71 ms	SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.active AS active_2, s0_.sort AS sort_3, s0_.date_created AS date_created_4, s0_.date_modified AS date_modified_5, s1_.title AS title_6, s1_.second_title AS second_title_7, s1_.description AS description_8, s1_.seo_title AS seo_title_9, s1_.seo_description AS seo_description_10, s1_.cod_lang AS cod_lang_11, s0_.parent_id AS parent_id_12, s1_.section_id AS section_id_13 FROM section s0_ LEFT JOIN section_i18n s1_ ON s0_.id = s1_.section_id WHERE s1_.cod_lang = ? AND s0_.active = 1 AND s0_.code = ? Parameters: [`"cn" "news"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.active AS active_2, s0_.sort AS sort_3, s0_.date_created AS date_created_4, s0_.date_modified AS date_modified_5, s1_.title AS title_6, s1_.second_title AS second_title_7, s1_.description AS description_8, s1_.seo_title AS seo_title_9, s1_.seo_description AS seo_description_10, s1_.cod_lang AS cod_lang_11, s0_.parent_id AS parent_id_12, s1_.section_id AS section_id_13 FROM section s0_ LEFT JOIN section_i18n s1_ ON s0_.id = s1_.section_id WHERE s1_.cod_lang = ? AND s0_.active = 1 AND s0_.code = ? SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.active AS active_2, s0_.sort AS sort_3, s0_.date_created AS date_created_4, s0_.date_modified AS date_modified_5, s1_.title AS title_6, s1_.second_title AS second_title_7, s1_.description AS description_8, s1_.seo_title AS seo_title_9, s1_.seo_description AS seo_description_10, s1_.cod_lang AS cod_lang_11, s0_.parent_id AS parent_id_12, s1_.section_id AS section_id_13 FROM section s0_ LEFT JOIN section_i18n s1_ ON s0_.id = s1_.section_id WHERE s1_.cod_lang = 'cn' AND s0_.active = 1 AND s0_.code = 'news';
5	0.98 ms	SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC Parameters: [`"cn" 9686`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = 'cn' AND n2_.id = 9686 ORDER BY n0_.sort ASC;
6	0.63 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.size AS size_6, t0.itemId AS itemId_7, t0.section AS section_8, t0.type AS type_9, t0.sort AS sort_10 FROM file t0 WHERE t0.itemId = ? AND t0.section = ? AND t0.type = ? ORDER BY t0.sort ASC LIMIT 1 Parameters: [`3 "newscategorybanner" "image_cn"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.size AS size_6, t0.itemId AS itemId_7, t0.section AS section_8, t0.type AS type_9, t0.sort AS sort_10 FROM file t0 WHERE t0.itemId = ? AND t0.section = ? AND t0.type = ? ORDER BY t0.sort ASC LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.size AS size_6, t0.itemId AS itemId_7, t0.section AS section_8, t0.type AS type_9, t0.sort AS sort_10 FROM file t0 WHERE t0.itemId = 3 AND t0.section = 'newscategorybanner' AND t0.type = 'image_cn' ORDER BY t0.sort ASC LIMIT 1;
7	0.39 ms	SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang Parameters: [`"news_category_banner_id" => 3 "cod_lang" => "ca"`] View formatted query View runnable query Explain query SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = 3 AND cod_lang = 'ca';
8	0.31 ms	SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang Parameters: [`"news_category_banner_id" => 3 "cod_lang" => "cn"`] View formatted query View runnable query Explain query SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = 3 AND cod_lang = 'cn';
9	0.28 ms	SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang Parameters: [`"news_category_banner_id" => 3 "cod_lang" => "en"`] View formatted query View runnable query Explain query SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = 3 AND cod_lang = 'en';
10	0.31 ms	SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang Parameters: [`"news_category_banner_id" => 3 "cod_lang" => "es"`] View formatted query View runnable query Explain query SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = 3 AND cod_lang = 'es';
11	0.64 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.size AS size_6, t0.itemId AS itemId_7, t0.section AS section_8, t0.type AS type_9, t0.sort AS sort_10 FROM file t0 WHERE t0.itemId = ? AND t0.section = ? AND t0.type = ? ORDER BY t0.sort ASC LIMIT 1 Parameters: [`2 "newscategorybanner" "image_cn"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.size AS size_6, t0.itemId AS itemId_7, t0.section AS section_8, t0.type AS type_9, t0.sort AS sort_10 FROM file t0 WHERE t0.itemId = ? AND t0.section = ? AND t0.type = ? ORDER BY t0.sort ASC LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.date_created AS date_created_4, t0.date_modified AS date_modified_5, t0.size AS size_6, t0.itemId AS itemId_7, t0.section AS section_8, t0.type AS type_9, t0.sort AS sort_10 FROM file t0 WHERE t0.itemId = 2 AND t0.section = 'newscategorybanner' AND t0.type = 'image_cn' ORDER BY t0.sort ASC LIMIT 1;
12	0.30 ms	SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang Parameters: [`"news_category_banner_id" => 2 "cod_lang" => "ca"`] View formatted query View runnable query Explain query SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = 2 AND cod_lang = 'ca';
13	0.33 ms	SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang Parameters: [`"news_category_banner_id" => 2 "cod_lang" => "cn"`] View formatted query View runnable query Explain query SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = 2 AND cod_lang = 'cn';
14	0.27 ms	SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang Parameters: [`"news_category_banner_id" => 2 "cod_lang" => "en"`] View formatted query View runnable query Explain query SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = 2 AND cod_lang = 'en';
15	0.27 ms	SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang Parameters: [`"news_category_banner_id" => 2 "cod_lang" => "es"`] View formatted query View runnable query Explain query SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = :news_category_banner_id AND cod_lang = :cod_lang SELECT title, link FROM news_category_banner_i18n WHERE news_category_banner_id = 2 AND cod_lang = 'es';
16	74.32 ms	SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.publication_date AS publication_date_3, n0_.video1 AS video1_4, n0_.video2 AS video2_5, n0_.besoccer_id AS besoccer_id_6, n0_.kaltura_id AS kaltura_id_7, n0_.active AS active_8, n1_.title AS title_9, n1_.cod_lang AS cod_lang_10, n1_.text AS text_11, n1_.seo_title AS seo_title_12, n1_.seo_description AS seo_description_13, n1_.subtitle AS subtitle_14, n2_.id AS id_15, n2_.date_created AS date_created_16, n2_.date_modified AS date_modified_17, n2_.sort AS sort_18, n2_.active AS active_19, n0_.banner_id AS banner_id_20, n0_.banner2_id AS banner2_id_21, n1_.news_id AS news_id_22, n2_.banner_id AS banner_id_23 FROM news n0_ LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_id INNER JOIN news_category n2_ ON n2_.id = n3_.news_category_id WHERE COALESCE(n1_.title, '') <> '' AND n1_.cod_lang = ? AND n0_.active = 1 AND n2_.id = ? AND n0_.publication_date <= ? AND n0_.id <> 9686 ORDER BY n0_.publication_date DESC LIMIT 5 Parameters: [`"cn" 2 "2025-10-19 04:53:10"`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.publication_date AS publication_date_3, n0_.video1 AS video1_4, n0_.video2 AS video2_5, n0_.besoccer_id AS besoccer_id_6, n0_.kaltura_id AS kaltura_id_7, n0_.active AS active_8, n1_.title AS title_9, n1_.cod_lang AS cod_lang_10, n1_.text AS text_11, n1_.seo_title AS seo_title_12, n1_.seo_description AS seo_description_13, n1_.subtitle AS subtitle_14, n2_.id AS id_15, n2_.date_created AS date_created_16, n2_.date_modified AS date_modified_17, n2_.sort AS sort_18, n2_.active AS active_19, n0_.banner_id AS banner_id_20, n0_.banner2_id AS banner2_id_21, n1_.news_id AS news_id_22, n2_.banner_id AS banner_id_23 FROM news n0_ LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_id INNER JOIN news_category n2_ ON n2_.id = n3_.news_category_id WHERE COALESCE(n1_.title, '') <> '' AND n1_.cod_lang = ? AND n0_.active = 1 AND n2_.id = ? AND n0_.publication_date <= ? AND n0_.id <> 9686 ORDER BY n0_.publication_date DESC LIMIT 5 SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.publication_date AS publication_date_3, n0_.video1 AS video1_4, n0_.video2 AS video2_5, n0_.besoccer_id AS besoccer_id_6, n0_.kaltura_id AS kaltura_id_7, n0_.active AS active_8, n1_.title AS title_9, n1_.cod_lang AS cod_lang_10, n1_.text AS text_11, n1_.seo_title AS seo_title_12, n1_.seo_description AS seo_description_13, n1_.subtitle AS subtitle_14, n2_.id AS id_15, n2_.date_created AS date_created_16, n2_.date_modified AS date_modified_17, n2_.sort AS sort_18, n2_.active AS active_19, n0_.banner_id AS banner_id_20, n0_.banner2_id AS banner2_id_21, n1_.news_id AS news_id_22, n2_.banner_id AS banner_id_23 FROM news n0_ LEFT JOIN news_i18n n1_ ON n0_.id = n1_.news_id INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_id INNER JOIN news_category n2_ ON n2_.id = n3_.news_category_id WHERE COALESCE(n1_.title, '') <> '' AND n1_.cod_lang = 'cn' AND n0_.active = 1 AND n2_.id = 2 AND n0_.publication_date <= '2025-10-19 04:53:10' AND n0_.id <> 9686 ORDER BY n0_.publication_date DESC LIMIT 5;
17	0.77 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 Parameters: [`14278 "news" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 14278 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
18	0.97 ms	SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC Parameters: [`"cn" 14278`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = 'cn' AND n2_.id = 14278 ORDER BY n0_.sort ASC;
19	0.82 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 Parameters: [`14277 "news" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 14277 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
20	0.76 ms	SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC Parameters: [`"cn" 14277`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = 'cn' AND n2_.id = 14277 ORDER BY n0_.sort ASC;
21	0.83 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 Parameters: [`14276 "news" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 14276 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
22	0.84 ms	SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC Parameters: [`"cn" 14276`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = 'cn' AND n2_.id = 14276 ORDER BY n0_.sort ASC;
23	0.67 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 Parameters: [`14251 "news" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 14251 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
24	0.89 ms	SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC Parameters: [`"cn" 14251`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = 'cn' AND n2_.id = 14251 ORDER BY n0_.sort ASC;
25	0.80 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 Parameters: [`14249 "news" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 14249 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
26	0.92 ms	SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC Parameters: [`"cn" 14249`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = ? AND n2_.id = ? ORDER BY n0_.sort ASC SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ INNER JOIN news_news_category n3_ ON n0_.id = n3_.news_category_id INNER JOIN news n2_ ON n2_.id = n3_.news_id LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n1_.cod_lang = 'cn' AND n2_.id = 14249 ORDER BY n0_.sort ASC;
27	1.30 ms	SELECT t0_.id AS id_0, t0_.date_created AS date_created_1, t0_.date_modified AS date_modified_2, t0_.sort AS sort_3, t0_.active AS active_4, t0_.besoccer_id AS besoccer_id_5, t0_.league_besoccer_id AS league_besoccer_id_6, t0_.group_id AS group_id_7, t0_.gender AS gender_8, t0_.summary AS summary_9, t0_.base AS base_10, t1_.name AS name_11, t1_.cod_lang AS cod_lang_12, t1_.stadium AS stadium_13, t0_.category_team_id AS category_team_id_14, t1_.team_id AS team_id_15 FROM team t0_ LEFT JOIN team_i18n t1_ ON t0_.id = t1_.team_id WHERE t0_.active = 1 AND t1_.cod_lang = ? AND t0_.sort IS NOT NULL ORDER BY t0_.sort ASC, t1_.cod_lang ASC Parameters: [`"cn"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.date_created AS date_created_1, t0_.date_modified AS date_modified_2, t0_.sort AS sort_3, t0_.active AS active_4, t0_.besoccer_id AS besoccer_id_5, t0_.league_besoccer_id AS league_besoccer_id_6, t0_.group_id AS group_id_7, t0_.gender AS gender_8, t0_.summary AS summary_9, t0_.base AS base_10, t1_.name AS name_11, t1_.cod_lang AS cod_lang_12, t1_.stadium AS stadium_13, t0_.category_team_id AS category_team_id_14, t1_.team_id AS team_id_15 FROM team t0_ LEFT JOIN team_i18n t1_ ON t0_.id = t1_.team_id WHERE t0_.active = 1 AND t1_.cod_lang = ? AND t0_.sort IS NOT NULL ORDER BY t0_.sort ASC, t1_.cod_lang ASC SELECT t0_.id AS id_0, t0_.date_created AS date_created_1, t0_.date_modified AS date_modified_2, t0_.sort AS sort_3, t0_.active AS active_4, t0_.besoccer_id AS besoccer_id_5, t0_.league_besoccer_id AS league_besoccer_id_6, t0_.group_id AS group_id_7, t0_.gender AS gender_8, t0_.summary AS summary_9, t0_.base AS base_10, t1_.name AS name_11, t1_.cod_lang AS cod_lang_12, t1_.stadium AS stadium_13, t0_.category_team_id AS category_team_id_14, t1_.team_id AS team_id_15 FROM team t0_ LEFT JOIN team_i18n t1_ ON t0_.id = t1_.team_id WHERE t0_.active = 1 AND t1_.cod_lang = 'cn' AND t0_.sort IS NOT NULL ORDER BY t0_.sort ASC, t1_.cod_lang ASC;
28	0.67 ms	SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n0_.active = 1 AND n1_.cod_lang = ? ORDER BY n0_.sort ASC Parameters: [`"cn"`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n0_.active = 1 AND n1_.cod_lang = ? ORDER BY n0_.sort ASC SELECT n0_.id AS id_0, n0_.date_created AS date_created_1, n0_.date_modified AS date_modified_2, n0_.sort AS sort_3, n0_.active AS active_4, n1_.name AS name_5, n1_.cod_lang AS cod_lang_6, n0_.banner_id AS banner_id_7, n1_.news_category_id AS news_category_id_8 FROM news_category n0_ LEFT JOIN news_category_i18n n1_ ON n0_.id = n1_.news_category_id WHERE n0_.active = 1 AND n1_.cod_lang = 'cn' ORDER BY n0_.sort ASC;
29	1.21 ms	SELECT s0_.id AS id_0, s0_.date_created AS date_created_1, s0_.date_modified AS date_modified_2, s0_.sort AS sort_3, s0_.active AS active_4, s0_.highlighted AS highlighted_5, s0_.hide_by_ip AS hide_by_ip_6, s1_.link AS link_7, s1_.title AS title_8, s1_.cod_lang AS cod_lang_9, s0_.category_sponsor_id AS category_sponsor_id_10, s1_.sponsor_id AS sponsor_id_11 FROM sponsor s0_ LEFT JOIN sponsor_i18n s1_ ON s0_.id = s1_.sponsor_id WHERE s0_.highlighted = 1 AND s0_.active = 1 AND s1_.cod_lang = ? ORDER BY s0_.sort ASC Parameters: [`"cn"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.date_created AS date_created_1, s0_.date_modified AS date_modified_2, s0_.sort AS sort_3, s0_.active AS active_4, s0_.highlighted AS highlighted_5, s0_.hide_by_ip AS hide_by_ip_6, s1_.link AS link_7, s1_.title AS title_8, s1_.cod_lang AS cod_lang_9, s0_.category_sponsor_id AS category_sponsor_id_10, s1_.sponsor_id AS sponsor_id_11 FROM sponsor s0_ LEFT JOIN sponsor_i18n s1_ ON s0_.id = s1_.sponsor_id WHERE s0_.highlighted = 1 AND s0_.active = 1 AND s1_.cod_lang = ? ORDER BY s0_.sort ASC SELECT s0_.id AS id_0, s0_.date_created AS date_created_1, s0_.date_modified AS date_modified_2, s0_.sort AS sort_3, s0_.active AS active_4, s0_.highlighted AS highlighted_5, s0_.hide_by_ip AS hide_by_ip_6, s1_.link AS link_7, s1_.title AS title_8, s1_.cod_lang AS cod_lang_9, s0_.category_sponsor_id AS category_sponsor_id_10, s1_.sponsor_id AS sponsor_id_11 FROM sponsor s0_ LEFT JOIN sponsor_i18n s1_ ON s0_.id = s1_.sponsor_id WHERE s0_.highlighted = 1 AND s0_.active = 1 AND s1_.cod_lang = 'cn' ORDER BY s0_.sort ASC;
30	0.73 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 Parameters: [`3 "sponsor" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 3 AND f0_.section = 'sponsor' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
31	0.74 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 Parameters: [`4 "sponsor" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 4 AND f0_.section = 'sponsor' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
32	0.61 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 Parameters: [`7 "sponsor" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 7 AND f0_.section = 'sponsor' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
33	0.53 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 Parameters: [`1 "sponsor" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 1 AND f0_.section = 'sponsor' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
34	0.59 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 Parameters: [`2 "sponsor" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 2 AND f0_.section = 'sponsor' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
35	0.60 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 Parameters: [`14 "sponsor" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 14 AND f0_.section = 'sponsor' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
36	0.57 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 Parameters: [`13 "sponsor" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = 13 AND f0_.section = 'sponsor' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
37	0.84 ms	(SELECT * FROM sponsor_header WHERE fixed = 1 AND active = 1 ORDER BY sort LIMIT 1) UNION (SELECT * FROM sponsor_header WHERE fixed <> 1 AND active = 1 ORDER BY RAND() /* , sort ASC Si queremos la característica de que dentro de los 2 escogidos al azar se respete el orden asignado por el cliente 15/06/2022: Ahora sólo será 1 escogido al azar / LIMIT 2) Parameters: [] View formatted query View runnable query Explain query ( SELECT FROM sponsor_header WHERE fixed = 1 AND active = 1 ORDER BY sort LIMIT 1 ) UNION ( SELECT * FROM sponsor_header WHERE fixed <> 1 AND active = 1 ORDER BY RAND() /* , sort ASC Si queremos la característica de que dentro de los 2 escogidos al azar se respete el orden asignado por el cliente 15/06/2022: Ahora sólo será 1 escogido al azar / LIMIT 2 ) (SELECT FROM sponsor_header WHERE fixed = 1 AND active = 1 ORDER BY sort LIMIT 1) UNION (SELECT * FROM sponsor_header WHERE fixed <> 1 AND active = 1 ORDER BY RAND() /* , sort ASC Si queremos la característica de que dentro de los 2 escogidos al azar se respete el orden asignado por el cliente 15/06/2022: Ahora sólo será 1 escogido al azar */ LIMIT 2) ;
38	0.61 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 Parameters: [`"7" "sponsorHeader" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = '7' AND f0_.section = 'sponsorHeader' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
39	0.74 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 Parameters: [`"1" "sponsorHeader" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = '1' AND f0_.section = 'sponsorHeader' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
40	0.61 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 Parameters: [`"2" "sponsorHeader" "image"`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = ? AND f0_.section = ? AND f0_.type = ? ORDER BY f0_.sort ASC LIMIT 1 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.extension AS extension_2, f0_.date_created AS date_created_3, f0_.date_modified AS date_modified_4, f0_.size AS size_5, f0_.itemId AS itemId_6, f0_.section AS section_7, f0_.type AS type_8, f0_.sort AS sort_9 FROM file f0_ WHERE f0_.itemId = '2' AND f0_.section = 'sponsorHeader' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
41	0.44 ms	SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_modified AS date_modified_3, t0.kaltura_id AS kaltura_id_4, t0.active AS active_5 FROM audio t0 WHERE t0.active = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_modified AS date_modified_3, t0.kaltura_id AS kaltura_id_4, t0.active AS active_5 FROM audio t0 WHERE t0.active = ? LIMIT 1 SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_modified AS date_modified_3, t0.kaltura_id AS kaltura_id_4, t0.active AS active_5 FROM audio t0 WHERE t0.active = 1 LIMIT 1;
42	0.62 ms	SELECT title, subtitle, text, seo_title AS seoTitle, seo_description AS seoDescription FROM news_i18n WHERE news_id = :news_id AND cod_lang = :cod_lang Parameters: [`"news_id" => 9686 "cod_lang" => "es"`] View formatted query View runnable query Explain query SELECT title, subtitle, text, seo_title AS seoTitle, seo_description AS seoDescription FROM news_i18n WHERE news_id = :news_id AND cod_lang = :cod_lang SELECT title, subtitle, text, seo_title AS seoTitle, seo_description AS seoDescription FROM news_i18n WHERE news_id = 9686 AND cod_lang = 'es';
43	0.51 ms	SELECT title, subtitle, text, seo_title AS seoTitle, seo_description AS seoDescription FROM news_i18n WHERE news_id = :news_id AND cod_lang = :cod_lang Parameters: [`"news_id" => 9686 "cod_lang" => "ca"`] View formatted query View runnable query Explain query SELECT title, subtitle, text, seo_title AS seoTitle, seo_description AS seoDescription FROM news_i18n WHERE news_id = :news_id AND cod_lang = :cod_lang SELECT title, subtitle, text, seo_title AS seoTitle, seo_description AS seoDescription FROM news_i18n WHERE news_id = 9686 AND cod_lang = 'ca';
44	0.46 ms	SELECT title, subtitle, text, seo_title AS seoTitle, seo_description AS seoDescription FROM news_i18n WHERE news_id = :news_id AND cod_lang = :cod_lang Parameters: [`"news_id" => 9686 "cod_lang" => "en"`] View formatted query View runnable query Explain query SELECT title, subtitle, text, seo_title AS seoTitle, seo_description AS seoDescription FROM news_i18n WHERE news_id = :news_id AND cod_lang = :cod_lang SELECT title, subtitle, text, seo_title AS seoTitle, seo_description AS seoDescription FROM news_i18n WHERE news_id = 9686 AND cod_lang = 'en';
45	0.48 ms	SELECT title, subtitle, text, seo_title AS seoTitle, seo_description AS seoDescription FROM news_i18n WHERE news_id = :news_id AND cod_lang = :cod_lang Parameters: [`"news_id" => 9686 "cod_lang" => "cn"`] View formatted query View runnable query Explain query SELECT title, subtitle, text, seo_title AS seoTitle, seo_description AS seoDescription FROM news_i18n WHERE news_id = :news_id AND cod_lang = :cod_lang SELECT title, subtitle, text, seo_title AS seoTitle, seo_description AS seoDescription FROM news_i18n WHERE news_id = 9686 AND cod_lang = 'cn';

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.

Entities Mapping

Class	Mapping errors
App\Entity\News	No errors.
App\Entity\File	No errors.
App\Entity\NewsI18n	No errors.
App\Entity\NewsCategory	No errors.
App\Entity\NewsCategoryI18n	No errors.
App\Entity\NewsBanner	No errors.
App\Entity\NewsCategoryBanner	No errors.
App\Entity\Employee	No errors.
App\Entity\SlideNews	No errors.
App\Entity\Section	No errors.
App\Entity\SectionI18n	No errors.
App\Entity\NewsCategoryBannerI18n	No errors.
App\Entity\Team	No errors.
App\Entity\TeamI18n	No errors.
App\Entity\TeamCategory	No errors.
App\Entity\Sponsor	No errors.
App\Entity\SponsorI18n	No errors.
App\Entity\SponsorCategory	No errors.
App\Entity\SponsorHeader	No errors.
App\Entity\Audio	No errors.
App\Entity\NewsBannerI18n	No errors.
App\Entity\EmployeeI18n	No errors.
App\Entity\Profession	No errors.
App\Entity\Position	No errors.
App\Entity\PlayerType	No errors.
App\Entity\HomeSlide	No errors.
App\Entity\TeamCategoryI18n	No errors.
App\Entity\SponsorCategoryI18n	No errors.

Symfony Profiler

https://webstaging.rcdespanyol.com/cn/new-cn/%E8%BE%BE%E5%B0%BC%E5%93%88%E5%B0%94%E5%85%8B%E7%A6%BB%E4%B8%96%E5%8D%81%E5%91%A8%E5%B9%B4%EF%BC%8C%E7%BC%85%E6%80%80%E6%88%91%E4%BB%AC%E4%BC%9F%E5%A4%A7%E7%9A%84%E9%98%9F%E9%95%BF/9686

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping