58 duplicated queries found.
Time | Duration | Type | Duplicated | Query |
---|---|---|---|---|
07:20:29.289 | 1.3 ms | SELECT | 1 | SELECT * FROM `nut_news` WHERE (`NewsID`='762091') AND (`Slug`='messi-ne-zahotel-igrat-v-holodnuyu-pogodu-match-intera-mayami-perenesli') |
07:20:29.309 | 1.2 ms | SELECT | 3 | SELECT * FROM `nut_news` WHERE `NewsID`='762091' |
07:20:29.346 | 1.1 ms | SELECT | 1 | SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`image` <> '') AND (`StartDate` < 1740457229) AND ((`EndDate` > 1740457229) OR (`EndDate`=0)) |
07:20:29.349 | 2.1 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 07:20:29') AND ((`end_date` >= '2025-02-25 07:20:29') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:29.353 | 1.0 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
07:20:29.356 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=5 |
07:20:29.357 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=5 |
07:20:29.358 | 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 07:20:29') AND ((`end_date` >= '2025-02-25 07:20:29') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
07:20:29.360 | 0.9 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
07:20:29.361 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=598 |
07:20:29.362 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=598 |
07:20:29.363 | 0.9 ms | SELECT | 2 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_1' |
07:20:29.365 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`StartDate` < 1740457229) AND (`bottomImage` <> '') AND ((`EndDate` > 1740457229) OR (`EndDate`=0)) AND (`useBottom`=1) |
07:20:29.369 | 1.1 ms | SELECT | 1 | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE `SectionID`=1 |
07:20:29.370 | 0.9 ms | SELECT | 1 | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE `MenuID`='1' |
07:20:29.371 | 1.0 ms | SELECT | 1 | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE (`Url`='news/762091-messi-ne-zahotel-igrat-v-holodnuyu-pogodu-match-intera-mayami-perenesli') AND (`Parent`='1266') |
07:20:29.373 | 1.1 ms | SELECT | 3 | SELECT * FROM `nut_news` WHERE `NewsID`='762091' |
07:20:29.375 | 1.0 ms | SELECT | 1 | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=1542 |
07:20:29.378 | 1.1 ms | SELECT | 6 | SELECT * FROM `ut_sections` WHERE `SectionID`=1 |
07:20:29.381 | 1.0 ms | SELECT | 1 | SELECT * FROM `nut_news_teams` WHERE `NewsID`=762091 |
07:20:29.383 | 1.2 ms | SELECT | 1 | SELECT * FROM `ut_teams` WHERE `TeamID` IN (3333, 1238) |
07:20:29.387 | 1.0 ms | SELECT | 1 | SELECT * FROM `nut_news_persons` WHERE `NewsID`=762091 |
07:20:29.390 | 1.5 ms | SELECT | 2 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=762091) |
07:20:29.394 | 1.7 ms | SELECT | 2 | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=338) |
07:20:29.397 | 1.4 ms | SELECT | 8 | SELECT * FROM `ut_players` WHERE `PlayerID`=2361 |
07:20:29.407 | 1.1 ms | SELECT | 3 | SELECT * FROM `ut_sections` WHERE `SectionID`=143 |
07:20:29.408 | 1.7 ms | SELECT | 6 | SELECT * FROM `ut_sections` WHERE `SectionID`=1 |
07:20:29.410 | 1.6 ms | SELECT | 1 | SELECT * FROM `nut_news` WHERE (`Main`=1) AND ((`Active`=1) AND (`is_translation`=0) AND (`is_prediction`=0)) AND (`OnMainPage`=1) ORDER BY `Pinned` DESC, `Date` DESC LIMIT 5 |
07:20:29.412 | 1.1 ms | SELECT | 1 | SELECT * FROM `ut_tournaments` WHERE `TournamentID` IN (1511, 1444) |
07:20:29.413 | 1.3 ms | SELECT | 1 | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID` IN (1, 169)) |
07:20:29.415 | 1.1 ms | SELECT | 6 | SELECT * FROM `ut_sections` WHERE `SectionID`=1 |
07:20:29.416 | 1.1 ms | SELECT | 1 | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=1415 |
07:20:29.417 | 1.9 ms | SELECT | 1 | SELECT * FROM `nut_news_teams` WHERE `NewsID` IN (762815, 762813, 762812, 762811, 762809) |
07:20:29.419 | 1.3 ms | SELECT | 1 | SELECT * FROM `ut_teams` WHERE `TeamID` IN (2, 3, 1507, 3333, 1226336, 1244588) |
07:20:29.421 | 1.4 ms | SELECT | 1 | SELECT * FROM `nut_news_persons` WHERE `NewsID` IN (762815, 762813, 762812, 762811, 762809) |
07:20:29.422 | 3.1 ms | SELECT | 1 | SELECT * FROM `nut_news` WHERE (`NewsID` NOT IN (762815, 762813, 762812, 762811, 762809)) AND ((`Active`=1) AND (`is_translation`=0) AND (`is_prediction`=0)) AND (DivisionID=338 OR DivisionID2=338 ) ORDER BY `Date` DESC LIMIT 28 |
07:20:29.426 | 0.9 ms | SELECT | 1 | SELECT * FROM `nut_content_type` WHERE `id`=2 |
07:20:29.429 | 1.1 ms | SELECT | 1 | SELECT * FROM `ut_tournaments` WHERE `TournamentID` IN (1542, 1311, 1394) |
07:20:29.431 | 1.3 ms | SELECT | 1 | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID` IN (1, 338)) |
07:20:29.432 | 1.0 ms | SELECT | 6 | SELECT * FROM `ut_sections` WHERE `SectionID`=1 |
07:20:29.433 | 1.1 ms | SELECT | 1 | SELECT * FROM `ut_tournaments` WHERE `TournamentID`=1394 |
07:20:29.435 | 1.8 ms | SELECT | 1 | SELECT * FROM `nut_news_teams` WHERE `NewsID` IN (762804, 762446, 762428, 762091, 734139, 728670, 728640, 727772, 725774, 725127, 725105, 725093) |
07:20:29.437 | 3.5 ms | SELECT | 1 | SELECT * FROM `ut_teams` WHERE `TeamID` IN (3333, 4178, 1786, 1237, 1687, 3, 4, 1238) |
07:20:29.441 | 1.5 ms | SELECT | 1 | SELECT * FROM `nut_news_persons` WHERE `NewsID` IN (762804, 762446, 762428, 762091, 734139, 728670, 728640, 727772, 725774, 725127, 725105, 725093) |
07:20:29.443 | 1.2 ms | SELECT | 2 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=762804) |
07:20:29.445 | 1.8 ms | SELECT | 8 | SELECT * FROM `ut_players` WHERE `PlayerID`=2361 |
07:20:29.447 | 1.0 ms | SELECT | 3 | SELECT * FROM `ut_judges` WHERE `JudgeID`=2107 |
07:20:29.450 | 1.1 ms | SELECT | 1 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=762446) |
07:20:29.452 | 1.2 ms | SELECT | 8 | SELECT * FROM `ut_players` WHERE `PlayerID`=2361 |
07:20:29.454 | 1.0 ms | SELECT | 3 | SELECT * FROM `ut_judges` WHERE `JudgeID`=2107 |
07:20:29.455 | 1.1 ms | SELECT | 1 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=762428) |
07:20:29.457 | 1.3 ms | SELECT | 8 | SELECT * FROM `ut_players` WHERE `PlayerID`=2361 |
07:20:29.459 | 0.9 ms | SELECT | 3 | SELECT * FROM `ut_judges` WHERE `JudgeID`=2107 |
07:20:29.460 | 1.3 ms | SELECT | 2 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=762091) |
07:20:29.462 | 1.9 ms | SELECT | 8 | SELECT * FROM `ut_players` WHERE `PlayerID`=2361 |
07:20:29.465 | 1.3 ms | SELECT | 1 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=734139) |
07:20:29.466 | 1.4 ms | SELECT | 2 | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=338) |
07:20:29.468 | 2.4 ms | SELECT | 1 | SELECT * FROM `ut_players` WHERE `PlayerID`=20565 |
07:20:29.471 | 1.3 ms | SELECT | 1 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=728670) |
07:20:29.473 | 1.0 ms | SELECT | 3 | SELECT * FROM `ut_coaches` WHERE `CoachID`=964 |
07:20:29.477 | 1.2 ms | SELECT | 1 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=728640) |
07:20:29.479 | 1.2 ms | SELECT | 8 | SELECT * FROM `ut_players` WHERE `PlayerID`=2361 |
07:20:29.480 | 1.1 ms | SELECT | 1 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=727772) |
07:20:29.482 | 1.2 ms | SELECT | 8 | SELECT * FROM `ut_players` WHERE `PlayerID`=2361 |
07:20:29.484 | 0.9 ms | SELECT | 3 | SELECT * FROM `ut_coaches` WHERE `CoachID`=964 |
07:20:29.485 | 1.1 ms | SELECT | 1 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=725774) |
07:20:29.487 | 1.2 ms | SELECT | 2 | SELECT * FROM `ut_players` WHERE `PlayerID` IN (2361, 7584) |
07:20:29.489 | 1.3 ms | SELECT | 1 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=725127) |
07:20:29.491 | 1.3 ms | SELECT | 8 | SELECT * FROM `ut_players` WHERE `PlayerID`=2361 |
07:20:29.492 | 1.0 ms | SELECT | 3 | SELECT * FROM `ut_coaches` WHERE `CoachID`=964 |
07:20:29.494 | 1.1 ms | SELECT | 1 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=725105) |
07:20:29.496 | 1.3 ms | SELECT | 2 | SELECT * FROM `ut_players` WHERE `PlayerID` IN (2361, 7584) |
07:20:29.498 | 1.2 ms | SELECT | 1 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=725093) |
07:20:29.499 | 1.3 ms | SELECT | 1 | SELECT * FROM `ut_players` WHERE `PlayerID` IN (2361, 7584, 9380) |
07:20:29.502 | 1.1 ms | SELECT | 3 | SELECT * FROM `ut_sections` WHERE `SectionID`=143 |
07:20:29.503 | 1.2 ms | SELECT | 6 | SELECT * FROM `ut_sections` WHERE `SectionID`=1 |
07:20:29.504 | 69.4 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE (`Main`=1) AND (`Active`=1) AND (`OnMainPage`=1) ORDER BY `Pinned` DESC, `Date` DESC LIMIT 5 |
07:20:29.576 | 1.2 ms | SELECT | 1 | SELECT * FROM `ut_tournaments` WHERE `TournamentID` IN (1454, 1453) |
07:20:29.578 | 1.3 ms | SELECT | 1 | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID` IN (8, 13)) |
07:20:29.579 | 7.1 ms | SELECT | 1 | SELECT * FROM `nut_articles_teams` WHERE `ArticleID` IN (458565, 458563, 458561, 458559, 458556) |
07:20:29.588 | 1.5 ms | SELECT | 1 | SELECT * FROM `ut_teams` WHERE `TeamID` IN (195, 273, 540, 203, 3189, 266, 2226, 172, 305, 1293, 20) |
07:20:29.590 | 9.3 ms | SELECT | 1 | SELECT * FROM `nut_articles_persons` WHERE `ArticleID` IN (458565, 458563, 458561, 458559, 458556) |
07:20:29.602 | 80.9 ms | SELECT | 1 | SELECT * FROM `nut_articles` WHERE (`ArticleID` NOT IN (458565, 458563, 458561, 458559, 458556)) AND (`Active`=1) AND (DivisionID=338 OR DivisionID2=338 ) ORDER BY `Date` DESC LIMIT 28 |
07:20:29.683 | 1.2 ms | SELECT | 3 | SELECT * FROM `ut_sections` WHERE `SectionID`=143 |
07:20:29.684 | 1.2 ms | SELECT | 6 | SELECT * FROM `ut_sections` WHERE `SectionID`=1 |
07:20:29.685 | 23.0 ms | SELECT | 1 | SELECT * FROM `nut_posts` WHERE (`Main`=1) AND (`status`=2) AND (`isOnMain`=1) ORDER BY `Date` DESC LIMIT 5 |
07:20:29.709 | 3.1 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `nut_posts` |
07:20:29.713 | 2.2 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` = 'nut_posts' AND `kcu`.`TABLE_NAME` = 'nut_posts' |
07:20:29.718 | 1.1 ms | SELECT | 1 | SELECT * FROM `ut_tournaments` WHERE `TournamentID` IN (1377, 1312) |
07:20:29.720 | 1.2 ms | SELECT | 1 | SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID` IN (13, 68)) |
07:20:29.721 | 4.8 ms | SELECT | 1 | SELECT * FROM `nut_posts_teams` WHERE `PostID` IN (4807, 4802, 4795, 4794, 4792) |
07:20:29.727 | 2.2 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `nut_posts_teams` |
07:20:29.729 | 2.1 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` = 'nut_posts_teams' AND `kcu`.`TABLE_NAME` = 'nut_posts_teams' |
07:20:29.733 | 1.8 ms | SELECT | 1 | SELECT * FROM `ut_teams` WHERE `TeamID` IN (133, 96, 123, 162, 2, 240, 667, 4, 65) |
07:20:29.736 | 4.1 ms | SELECT | 1 | SELECT * FROM `nut_posts_persons` WHERE `PostID` IN (4807, 4802, 4795, 4794, 4792) |
07:20:29.740 | 1.9 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `nut_posts_persons` |
07:20:29.742 | 2.0 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` = 'nut_posts_persons' AND `kcu`.`TABLE_NAME` = 'nut_posts_persons' |
07:20:29.747 | 1.2 ms | SELECT | 1 | SELECT * FROM `ut_users` WHERE `UserID`=396976 |
07:20:29.751 | 1.1 ms | SELECT | 1 | SELECT * FROM `bookmakers` WHERE `review` IN (4807, 4802, 4795, 4794, 4792) |
07:20:29.752 | 0.9 ms | SELECT | 1 | SELECT * FROM `nut_blogs` WHERE `BlogID`=527 |
07:20:29.754 | 2.1 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `nut_blogs` |
07:20:29.756 | 2.1 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` = 'nut_blogs' AND `kcu`.`TABLE_NAME` = 'nut_blogs' |
07:20:29.760 | 1.7 ms | SELECT | 1 | SELECT * FROM `nut_blogs_subscribe` WHERE `BlogID`=527 |
07:20:29.763 | 1.8 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `nut_blogs_subscribe` |
07:20:29.765 | 2.0 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` = 'nut_blogs_subscribe' AND `kcu`.`TABLE_NAME` = 'nut_blogs_subscribe' |
07:20:29.769 | 22.0 ms | SELECT | 1 | SELECT * FROM `nut_posts` WHERE (`PostID` NOT IN (4807, 4802, 4795, 4794, 4792)) AND (`status`=2) AND (DivisionID=338 ) ORDER BY `Date` DESC LIMIT 28 |
07:20:29.795 | 1.2 ms | SELECT | 1 | SELECT * FROM `ut_sections` WHERE `DivisionID`=338 ORDER BY `SectionID` DESC |
07:20:29.811 | 1.2 ms | SELECT | 1 | SELECT * FROM `ut_sections` WHERE `DivisionID`=338 |
07:20:29.812 | 1.2 ms | SELECT | 3 | SELECT * FROM `nut_news` WHERE `NewsID`='762091' |
07:20:29.814 | 240.2 ms | SELECT | 1 | SELECT `nut_news`.* FROM `nut_news` LEFT JOIN `nut_news_persons` ON `nut_news`.`NewsID` = `nut_news_persons`.`NewsID` WHERE ((`nut_news_persons`.`PersonID`='2361') AND (`Active`=TRUE)) AND (`Type`='p') ORDER BY `Date` DESC LIMIT 5 |
07:20:30.054 | 1.1 ms | SELECT | 1 | SELECT * FROM `nut_news_persons` WHERE `NewsID` IN (762813, 762804, 762726, 762650, 762614) |
07:20:30.060 | 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_7') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.061 | 1.0 ms | SELECT | 1 | SELECT * FROM `auth_item` WHERE `name`='news' |
07:20:30.062 | 1.0 ms | SELECT | 1 | SELECT `parent` FROM `auth_item_child` WHERE `child`='news' |
07:20:30.063 | 0.9 ms | SELECT | 2 | SELECT * FROM `auth_item` WHERE `name`='admin' |
07:20:30.064 | 0.9 ms | SELECT | 2 | SELECT `parent` FROM `auth_item_child` WHERE `child`='admin' |
07:20:30.065 | 1.0 ms | SELECT | 1 | SELECT * FROM `auth_item` WHERE `name`='новостники' |
07:20:30.066 | 1.0 ms | SELECT | 1 | SELECT `parent` FROM `auth_item_child` WHERE `child`='новостники' |
07:20:30.067 | 0.9 ms | SELECT | 1 | SELECT * FROM `auth_item` WHERE `name`='Редактор' |
07:20:30.068 | 0.9 ms | SELECT | 1 | SELECT `parent` FROM `auth_item_child` WHERE `child`='Редактор' |
07:20:30.069 | 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_44') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.071 | 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_64') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.072 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=64 |
07:20:30.073 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=563 |
07:20:30.074 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=563 |
07:20:30.076 | 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_64') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
07:20:30.077 | 1.0 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_64' |
07:20:30.078 | 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_37') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.080 | 1.2 ms | SELECT | 1 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=762813) |
07:20:30.084 | 1.3 ms | SELECT | 2 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=762804) |
07:20:30.092 | 2.5 ms | SELECT | 1 | SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=762726) |
07:20:30.101 | 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 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.103 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=8 |
07:20:30.104 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=295 |
07:20:30.105 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=295 |
07:20:30.106 | 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_8') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
07:20:30.107 | 0.9 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_8' |
07:20:30.110 | 1.2 ms | SELECT | 1 | SELECT * FROM `partner_widgets` WHERE (`block_id`=2) AND (`is_disabled`=0) |
07:20:30.127 | 0.9 ms | SELECT | 1 | SELECT * FROM `auth_item` WHERE `name`='comments' |
07:20:30.128 | 0.9 ms | SELECT | 1 | SELECT `parent` FROM `auth_item_child` WHERE `child`='comments' |
07:20:30.129 | 0.9 ms | SELECT | 2 | SELECT * FROM `auth_item` WHERE `name`='admin' |
07:20:30.130 | 0.9 ms | SELECT | 2 | SELECT `parent` FROM `auth_item_child` WHERE `child`='admin' |
07:20:30.134 | 0.9 ms | SELECT | 1 | SELECT * FROM `partner_widgets` WHERE (`block_id`=1) AND (`is_disabled`=0) |
07:20:30.136 | 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_57') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.138 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=57 |
07:20:30.139 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=300 |
07:20:30.140 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=300 |
07:20:30.141 | 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 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
07:20:30.142 | 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 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.144 | 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 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.149 | 2.1 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 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.151 | 0.9 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
07:20:30.152 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=5 |
07:20:30.153 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=5 |
07:20:30.155 | 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 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
07:20:30.157 | 0.9 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
07:20:30.158 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=598 |
07:20:30.159 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=598 |
07:20:30.160 | 0.9 ms | SELECT | 2 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_1' |
07:20:30.161 | 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 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.162 | 1.0 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=16 |
07:20:30.163 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=159 |
07:20:30.164 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=159 |
07:20:30.165 | 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 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
07:20:30.167 | 1.8 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=16 |
07:20:30.169 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=597 |
07:20:30.170 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=597 |
07:20:30.171 | 1.0 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_16' |
07:20:30.180 | 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 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.182 | 1.1 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=48 |
07:20:30.183 | 1.1 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=305 |
07:20:30.184 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=305 |
07:20:30.185 | 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_48') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
07:20:30.186 | 0.9 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_48' |
07:20:30.191 | 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_61') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.193 | 2.2 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_2') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.196 | 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_10') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.198 | 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_41') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.199 | 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_36') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.205 | 1.2 ms | SELECT | 2 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_26') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.206 | 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_38') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.208 | 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_5') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.209 | 1.7 ms | SELECT | 1 | SELECT *, (SELECT COUNT(*) FROM `nut_posts_likes` WHERE (`PostID`=nut_posts.PostID) AND (`type`=2)) AS `Dislikes`, (SELECT COUNT(*) FROM `nut_posts_likes` WHERE (`PostID`=nut_posts.PostID) AND (`type`=1)) AS `Likes` FROM `nut_posts` LEFT JOIN `nut_blogs` `blog` ON `nut_posts`.`BlogID` = `blog`.`BlogID` WHERE ((`status`=2) AND (`blog`.`is_hide`=FALSE)) AND (nut_posts.BlogID IN (SELECT nut_blogs_subscribe.BlogID from nut_blogs_subscribe WHERE UserID = '0')) ORDER BY `nut_posts`.`Date` DESC LIMIT 3 |
07:20:30.213 | 1.2 ms | SELECT | 2 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_26') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.220 | 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_3') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.221 | 1.0 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=3 |
07:20:30.222 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=6 |
07:20:30.223 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=6 |
07:20:30.225 | 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_3') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
07:20:30.226 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=3 |
07:20:30.227 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=600 |
07:20:30.228 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=600 |
07:20:30.229 | 0.9 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_3' |
07:20:30.232 | 2.2 ms | SELECT | 1 | SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_13') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.236 | 1.0 ms | SELECT | 1 | SELECT * FROM `partner_widgets` WHERE (`block_id`=3) AND (`is_disabled`=0) |
07:20:30.237 | 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_32') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.239 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=32 |
07:20:30.240 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=180 |
07:20:30.241 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=180 |
07:20:30.242 | 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_32') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
07:20:30.243 | 1.0 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_32' |
07:20:30.245 | 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_33') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.253 | 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 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
07:20:30.254 | 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_55') AND (`start_date` <= '2025-02-25 07:20:30') AND ((`end_date` >= '2025-02-25 07:20:30') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
Caller | No. of Calls | Total Duration | Queries | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
204 | 704.9 ms |
|