Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

70 Database Queries

12 Different statements

158.82 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_.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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.id = ?
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, publication_date_3 FROM (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, n1_.news_id AS news_id_20 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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.publication_date <= ? AND n2_.id = ?) dctrn_result_inner ORDER BY publication_date_3 DESC) dctrn_result LIMIT 24 OFFSET 744
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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.publication_date <= ? AND n2_.id = ? AND n0_.id IN (?) ORDER BY n0_.publication_date DESC
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 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 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 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 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 COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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, n1_.news_id AS news_id_20 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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.publication_date <= ? AND n2_.id = ? ORDER BY n0_.publication_date DESC) dctrn_result) dctrn_table
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 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 DISTINCT id_0 FROM (SELECT DISTINCT id_0, publication_date_3 FROM (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, n1_.news_id AS news_id_20 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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.publication_date <= ? AND n2_.id = ?) dctrn_result_inner ORDER BY publication_date_3 DESC) dctrn_result LIMIT 24 OFFSET 744
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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.publication_date <= ? AND n2_.id = ? AND n0_.id IN (?) ORDER BY n0_.publication_date DESC

#▲	Time	Info
1	0.69 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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.id = ? Parameters: [`"cn" 4`] 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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.id = ? 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 n1_.cod_lang = 'cn' AND n0_.active = 1 AND n0_.id = 4;
2	37.10 ms	SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, publication_date_3 FROM (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, n1_.news_id AS news_id_20 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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.publication_date <= ? AND n2_.id = ?) dctrn_result_inner ORDER BY publication_date_3 DESC) dctrn_result LIMIT 24 OFFSET 744 Parameters: [`"cn" "2025-10-19 04:58:51" 4`] View formatted query View runnable query Explain query SELECT DISTINCT id_0 FROM ( SELECT DISTINCT id_0, publication_date_3 FROM ( 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, n1_.news_id AS news_id_20 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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.publication_date <= ? AND n2_.id = ? ) dctrn_result_inner ORDER BY publication_date_3 DESC ) dctrn_result LIMIT 24 OFFSET 744 SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, publication_date_3 FROM (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, n1_.news_id AS news_id_20 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 n1_.cod_lang = 'cn' AND n0_.active = 1 AND n0_.publication_date <= '2025-10-19 04:58:51' AND n2_.id = 4) dctrn_result_inner ORDER BY publication_date_3 DESC) dctrn_result LIMIT 24 OFFSET 744;
3	4.24 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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.publication_date <= ? AND n2_.id = ? AND n0_.id IN (?) ORDER BY n0_.publication_date DESC Parameters: [`"cn" "2025-10-19 04:58:51" 4 [ 10617 10615 10614 10564 10600 10598 10592 10586 10585 10580 10579 10570 10568 10560 10558 10555 10546 10544 10551 10543 10537 10522 10538 10536 ]`] 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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.publication_date <= ? AND n2_.id = ? AND n0_.id IN (?) ORDER BY n0_.publication_date DESC 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 n1_.cod_lang = 'cn' AND n0_.active = 1 AND n0_.publication_date <= '2025-10-19 04:58:51' AND n2_.id = 4 AND n0_.id IN (10617, 10615, 10614, 10564, 10600, 10598, 10592, 10586, 10585, 10580, 10579, 10570, 10568, 10560, 10558, 10555, 10546, 10544, 10551, 10543, 10537, 10522, 10538, 10536) ORDER BY n0_.publication_date DESC;
4	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: [`10617 "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 = 10617 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
5	0.81 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" 10617`] 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 = 10617 ORDER BY n0_.sort ASC;
6	0.65 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: [`10615 "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 = 10615 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
7	1.13 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" 10615`] 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 = 10615 ORDER BY n0_.sort ASC;
8	0.65 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: [`10614 "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 = 10614 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
9	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" 10614`] 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 = 10614 ORDER BY n0_.sort ASC;
10	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: [`10564 "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 = 10564 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
11	0.94 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" 10564`] 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 = 10564 ORDER BY n0_.sort ASC;
12	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: [`10600 "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 = 10600 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
13	0.75 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" 10600`] 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 = 10600 ORDER BY n0_.sort ASC;
14	0.76 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: [`10598 "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 = 10598 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
15	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" 10598`] 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 = 10598 ORDER BY n0_.sort ASC;
16	0.65 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: [`10592 "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 = 10592 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
17	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" 10592`] 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 = 10592 ORDER BY n0_.sort ASC;
18	0.68 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: [`10586 "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 = 10586 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
19	0.74 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" 10586`] 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 = 10586 ORDER BY n0_.sort ASC;
20	0.71 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: [`10585 "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 = 10585 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
21	0.95 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" 10585`] 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 = 10585 ORDER BY n0_.sort ASC;
22	0.75 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: [`10580 "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 = 10580 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
23	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" 10580`] 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 = 10580 ORDER BY n0_.sort ASC;
24	0.75 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: [`10579 "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 = 10579 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
25	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" 10579`] 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 = 10579 ORDER BY n0_.sort ASC;
26	0.87 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: [`10570 "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 = 10570 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
27	0.81 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" 10570`] 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 = 10570 ORDER BY n0_.sort ASC;
28	0.64 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: [`10568 "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 = 10568 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
29	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" 10568`] 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 = 10568 ORDER BY n0_.sort ASC;
30	0.64 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: [`10560 "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 = 10560 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
31	0.81 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" 10560`] 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 = 10560 ORDER BY n0_.sort ASC;
32	0.63 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: [`10558 "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 = 10558 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
33	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" 10558`] 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 = 10558 ORDER BY n0_.sort ASC;
34	0.68 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: [`10555 "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 = 10555 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
35	0.83 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" 10555`] 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 = 10555 ORDER BY n0_.sort ASC;
36	0.71 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: [`10546 "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 = 10546 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
37	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" 10546`] 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 = 10546 ORDER BY n0_.sort ASC;
38	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: [`10544 "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 = 10544 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
39	0.88 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" 10544`] 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 = 10544 ORDER BY n0_.sort ASC;
40	0.96 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: [`10551 "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 = 10551 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
41	1.12 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" 10551`] 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 = 10551 ORDER BY n0_.sort ASC;
42	0.79 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: [`10543 "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 = 10543 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
43	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" 10543`] 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 = 10543 ORDER BY n0_.sort ASC;
44	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: [`10537 "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 = 10537 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
45	0.73 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" 10537`] 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 = 10537 ORDER BY n0_.sort ASC;
46	0.62 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: [`10522 "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 = 10522 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
47	0.73 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" 10522`] 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 = 10522 ORDER BY n0_.sort ASC;
48	0.62 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: [`10538 "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 = 10538 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
49	0.79 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" 10538`] 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 = 10538 ORDER BY n0_.sort ASC;
50	0.62 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: [`10536 "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 = 10536 AND f0_.section = 'news' AND f0_.type = 'image' ORDER BY f0_.sort ASC LIMIT 1;
51	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" 10536`] 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 = 10536 ORDER BY n0_.sort ASC;
52	29.22 ms	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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, n1_.news_id AS news_id_20 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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.publication_date <= ? AND n2_.id = ? ORDER BY n0_.publication_date DESC) dctrn_result) dctrn_table Parameters: [`"cn" "2025-10-19 04:58:51" 4`] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_0 FROM ( 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, n1_.news_id AS news_id_20 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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.publication_date <= ? AND n2_.id = ? ORDER BY n0_.publication_date DESC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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, n1_.news_id AS news_id_20 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 n1_.cod_lang = 'cn' AND n0_.active = 1 AND n0_.publication_date <= '2025-10-19 04:58:51' AND n2_.id = 4 ORDER BY n0_.publication_date DESC) dctrn_result) dctrn_table;
53	0.85 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';
54	1.06 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;
55	0.70 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;
56	0.76 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;
57	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;
58	0.81 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;
59	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: [`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;
60	0.69 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;
61	0.69 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;
62	0.63 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;
63	0.68 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;
64	0.80 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) ;
65	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: [`"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;
66	0.64 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;
67	0.70 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;
68	0.48 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;
69	33.68 ms	SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, publication_date_3 FROM (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, n1_.news_id AS news_id_20 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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.publication_date <= ? AND n2_.id = ?) dctrn_result_inner ORDER BY publication_date_3 DESC) dctrn_result LIMIT 24 OFFSET 744 Parameters: [`"cn" "2025-10-19 04:58:51" 4`] View formatted query View runnable query Explain query SELECT DISTINCT id_0 FROM ( SELECT DISTINCT id_0, publication_date_3 FROM ( 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, n1_.news_id AS news_id_20 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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.publication_date <= ? AND n2_.id = ? ) dctrn_result_inner ORDER BY publication_date_3 DESC ) dctrn_result LIMIT 24 OFFSET 744 SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, publication_date_3 FROM (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, n1_.news_id AS news_id_20 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 n1_.cod_lang = 'cn' AND n0_.active = 1 AND n0_.publication_date <= '2025-10-19 04:58:51' AND n2_.id = 4) dctrn_result_inner ORDER BY publication_date_3 DESC) dctrn_result LIMIT 24 OFFSET 744;
70	4.48 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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.publication_date <= ? AND n2_.id = ? AND n0_.id IN (?) ORDER BY n0_.publication_date DESC Parameters: [`"cn" "2025-10-19 04:58:51" 4 [ 10617 10615 10614 10564 10600 10598 10592 10586 10585 10580 10579 10570 10568 10560 10558 10555 10546 10544 10551 10543 10537 10522 10538 10536 ]`] 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 n1_.cod_lang = ? AND n0_.active = 1 AND n0_.publication_date <= ? AND n2_.id = ? AND n0_.id IN (?) ORDER BY n0_.publication_date DESC 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 n1_.cod_lang = 'cn' AND n0_.active = 1 AND n0_.publication_date <= '2025-10-19 04:58:51' AND n2_.id = 4 AND n0_.id IN (10617, 10615, 10614, 10564, 10600, 10598, 10592, 10586, 10585, 10580, 10579, 10570, 10568, 10560, 10558, 10555, 10546, 10544, 10551, 10543, 10537, 10522, 10538, 10536) ORDER BY n0_.publication_date DESC;

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\NewsCategory	No errors.
App\Entity\NewsCategoryI18n	No errors.
App\Entity\NewsCategoryBanner	No errors.
App\Entity\News	No errors.
App\Entity\File	No errors.
App\Entity\NewsI18n	No errors.
App\Entity\NewsBanner	No errors.
App\Entity\Employee	No errors.
App\Entity\SlideNews	No errors.
App\Entity\Section	No errors.
App\Entity\SectionI18n	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\NewsCategoryBannerI18n	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/%E6%B6%88%E6%81%AF/%E4%BF%B1%E4%B9%90%E9%83%A8%E3%80%81%E7%A4%BE%E4%BC%9A%E5%92%8C%E7%90%83%E8%BF%B7/4/32

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping