60 duplicated queries found.
Time | Duration | Type | Duplicated | Query |
---|---|---|---|---|
05:20:02.950 | 1.1 ms | SELECT | 1 | SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`image` <> '') AND (`StartDate` < 1740450002) AND ((`EndDate` > 1740450002) OR (`EndDate`=0)) |
05:20:02.954 | 2.0 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-02-25 05:20:02') AND ((`end_date` >= '2025-02-25 05:20:02') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:20:02.958 | 0.9 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
05:20:02.960 | 1.0 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=5 |
05:20:02.961 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=5 |
05:20:02.963 | 1.9 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-02-25 05:20:02') AND ((`end_date` >= '2025-02-25 05:20:02') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:20:02.965 | 1.0 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
05:20:02.966 | 1.5 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=598 |
05:20:02.967 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=598 |
05:20:02.968 | 0.9 ms | SELECT | 2 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_1' |
05:20:02.970 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`StartDate` < 1740450002) AND (`bottomImage` <> '') AND ((`EndDate` > 1740450002) OR (`EndDate`=0)) AND (`useBottom`=1) |
05:20:02.974 | 1.1 ms | SELECT | 1 | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE `SectionID`=1 |
05:20:02.975 | 1.4 ms | SELECT | 1 | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE `MenuID`='1' |
05:20:02.976 | 1.0 ms | SELECT | 1 | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE (`Url`='articles/index?id=437862&page=202') AND (`Parent`='1266') |
05:20:02.979 | 2.7 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `ut_sections` |
05:20:02.982 | 2.3 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'ut_sections' AND `kcu`.`TABLE_NAME` = 'ut_sections' |
05:20:02.986 | 1.0 ms | SELECT | 2 | SELECT * FROM `ut_sections` WHERE `SectionID`=1 |
05:20:02.988 | 54.9 ms | SELECT | 1 | SELECT m.ID, m.type, m.Date,m.OnMainPage,m.CategoryID,m.TournamentID,m.TournamentID2,m.DivisionID,m.DivisionID2,m.Views
FROM(
SELECT nut_articles.ArticleID AS ID, 'articles' AS type,nut_articles.Date, nut_articles.OnMainPage,
nut_articles.CategoryID,nut_articles.TournamentID,nut_articles.TournamentID2,
nut_articles.DivisionID, nut_articles.DivisionID2, nut_articles.Views
FROM nut_articles
WHERE nut_articles.Active=1
UNION
SELECT nut_posts.PostID AS ID, 'posts' AS type,nut_posts.Date,nut_posts.isOnMain AS OnMainPage,
nut_posts.CategoryID, nut_posts.TournamentID,NULL AS TournamentID2,
nut_posts.DivisionID, NULL AS DivisionID2, nut_posts.Views
FROM nut_posts
WHERE nut_posts.status=2
) m
WHERE (m.OnMainPage=1)
ORDER BY m.Date DESC LIMIT 20 OFFSET 4020 |
05:20:03.046 | 1.3 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454435' |
05:20:03.047 | 1.3 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454434' |
05:20:03.049 | 1.1 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454432' |
05:20:03.050 | 1.4 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454426' |
05:20:03.051 | 1.3 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454433' |
05:20:03.053 | 1.7 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454417' |
05:20:03.055 | 1.3 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454430' |
05:20:03.056 | 1.3 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454427' |
05:20:03.058 | 1.3 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454428' |
05:20:03.059 | 1.2 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454425' |
05:20:03.060 | 1.3 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454424' |
05:20:03.062 | 1.2 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454423' |
05:20:03.063 | 1.1 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454422' |
05:20:03.064 | 1.2 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454421' |
05:20:03.066 | 1.4 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454420' |
05:20:03.067 | 1.2 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454418' |
05:20:03.068 | 1.2 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454416' |
05:20:03.070 | 1.3 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454415' |
05:20:03.071 | 1.2 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454413' |
05:20:03.072 | 1.2 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE `ArticleID`='454412' |
05:20:03.075 | 1.3 ms | SELECT | 2 | SELECT * FROM `ut_sections` WHERE `SectionID`=1 |
05:20:03.076 | 63.8 ms | SELECT | 1 | SELECT m.ID, m.type, m.Date,m.OnMainPage,m.CategoryID,m.TournamentID,m.TournamentID2,m.DivisionID,m.DivisionID2,m.Views
FROM(
SELECT nut_articles.ArticleID AS ID, 'articles' AS type,nut_articles.Date, nut_articles.OnMainPage,
nut_articles.CategoryID,nut_articles.TournamentID,nut_articles.TournamentID2,
nut_articles.DivisionID, nut_articles.DivisionID2, nut_articles.Views
FROM nut_articles
WHERE nut_articles.Active=1
UNION
SELECT nut_posts.PostID AS ID, 'posts' AS type,nut_posts.Date,nut_posts.isOnMain AS OnMainPage,
nut_posts.CategoryID, nut_posts.TournamentID,NULL AS TournamentID2,
nut_posts.DivisionID, NULL AS DivisionID2, nut_posts.Views
FROM nut_posts
WHERE nut_posts.status=2
) m
WHERE (m.OnMainPage=1)
ORDER BY m.Date DESC |
05:20:03.141 | 1.2 ms | SELECT | 1 | SELECT * FROM `en_menu_new` WHERE `SectionID`=1 |
05:20:03.144 | 1.0 ms | SELECT | 1 | SELECT `MenuID`, `Title`, `ActiveLink`, `Name_rus`, `Target`, `Content`, `Url`, `Parent`, `Icon`, `SectionID` FROM `en_menu_new` WHERE (`Parent`='1266') AND (`Name_rus` != 'Основное') AND (`is_only_mobile`=FALSE) AND (`is_active`=TRUE) ORDER BY `Rang` |
05:20:03.148 | 1.1 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_7') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:20:03.154 | 1.7 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454435) |
05:20:03.157 | 1.2 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454435) |
05:20:03.160 | 1.5 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454434) |
05:20:03.163 | 1.4 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454434) |
05:20:03.167 | 1.2 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454432) |
05:20:03.169 | 1.2 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454432) |
05:20:03.172 | 1.1 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454426) |
05:20:03.175 | 1.1 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454426) |
05:20:03.178 | 1.2 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454433) |
05:20:03.181 | 1.9 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454433) |
05:20:03.185 | 1.8 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454417) |
05:20:03.188 | 1.1 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454417) |
05:20:03.191 | 1.6 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454430) |
05:20:03.195 | 1.5 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454430) |
05:20:03.198 | 1.5 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454427) |
05:20:03.201 | 1.5 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454427) |
05:20:03.208 | 1.2 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454428) |
05:20:03.211 | 1.2 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454428) |
05:20:03.215 | 1.4 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454425) |
05:20:03.218 | 1.2 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454425) |
05:20:03.221 | 1.3 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454424) |
05:20:03.223 | 1.3 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454424) |
05:20:03.227 | 1.6 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454423) |
05:20:03.230 | 1.3 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454423) |
05:20:03.233 | 1.2 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454422) |
05:20:03.236 | 1.2 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454422) |
05:20:03.239 | 3.0 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454421) |
05:20:03.243 | 1.3 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454421) |
05:20:03.246 | 2.2 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454420) |
05:20:03.250 | 1.4 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454420) |
05:20:03.253 | 1.3 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454418) |
05:20:03.256 | 1.3 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454418) |
05:20:03.259 | 1.3 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454416) |
05:20:03.262 | 1.2 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454416) |
05:20:03.265 | 1.8 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454415) |
05:20:03.269 | 1.4 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454415) |
05:20:03.272 | 1.5 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454413) |
05:20:03.275 | 1.2 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454413) |
05:20:03.278 | 1.2 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454412) |
05:20:03.281 | 1.4 ms | SELECT | 2 | SELECT COUNT(CommentID) AS `Count`, `MaterialID` FROM `ut_news_comments` WHERE (`Actual`=1) AND (`TypeID`=0) AND (`MaterialID`=454412) |
05:20:03.284 | 1.4 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_8') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:20:03.285 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=8 |
05:20:03.286 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=295 |
05:20:03.287 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=295 |
05:20:03.288 | 1.3 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_8') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:20:03.290 | 1.2 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_8' |
05:20:03.291 | 2.9 ms | SELECT | 1 | SELECT * FROM `nut_default_params` WHERE `name`='keywords' |
05:20:03.295 | 1.3 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_57') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:20:03.297 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=57 |
05:20:03.298 | 1.1 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=300 |
05:20:03.299 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=300 |
05:20:03.300 | 1.2 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_57') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:20:03.302 | 1.2 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_30') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:20:03.303 | 1.2 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_35') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:20:03.305 | 1.9 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_17') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:20:03.307 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=17 |
05:20:03.308 | 1.1 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=303 |
05:20:03.309 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=303 |
05:20:03.310 | 1.3 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_17') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:20:03.311 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=17 |
05:20:03.312 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=599 |
05:20:03.313 | 1.1 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=599 |
05:20:03.314 | 1.1 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_17' |
05:20:03.320 | 1.8 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:20:03.322 | 2.6 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
05:20:03.325 | 1.1 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=5 |
05:20:03.326 | 1.3 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=5 |
05:20:03.327 | 1.9 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:20:03.329 | 1.1 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
05:20:03.330 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=598 |
05:20:03.331 | 1.0 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=598 |
05:20:03.332 | 0.9 ms | SELECT | 2 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_1' |
05:20:03.333 | 1.5 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_16') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:20:03.335 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=16 |
05:20:03.336 | 1.5 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=159 |
05:20:03.338 | 1.3 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=159 |
05:20:03.339 | 1.3 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_16') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:20:03.341 | 1.0 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=16 |
05:20:03.342 | 2.0 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=597 |
05:20:03.344 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=597 |
05:20:03.345 | 0.9 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_16' |
05:20:03.346 | 1.2 ms | SELECT | 1 | SELECT * FROM `robot_agent` |
05:20:03.354 | 1.5 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_48') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:20:03.356 | 1.3 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=48 |
05:20:03.357 | 1.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=305 |
05:20:03.360 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=305 |
05:20:03.361 | 1.2 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_48') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:20:03.362 | 1.2 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_48' |
05:20:03.366 | 2.0 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_61') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:20:03.369 | 1.2 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `desktop_column_order`=3 ORDER BY `desktop_block_order` |
05:20:03.373 | 1.1 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name` IN ('main_news', 'all_news') |
05:20:03.377 | 1.5 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_34') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:20:03.379 | 2.7 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_11') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:20:03.382 | 2.8 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=11 |
05:20:03.385 | 1.4 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=207 |
05:20:03.386 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=207 |
05:20:03.387 | 3.7 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_11') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:20:03.391 | 0.9 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_11' |
05:20:03.393 | 1.2 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_25') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:20:03.394 | 1.1 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_55') AND (`start_date` <= '2025-02-25 05:20:03') AND ((`end_date` >= '2025-02-25 05:20:03') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
Caller | No. of Calls | Total Duration | Queries | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
143 | 309.7 ms |
|