30 duplicated queries found.
Time | Duration | Type | Duplicated | Query |
---|---|---|---|---|
05:21:38.054 | 2.1 ms | SELECT | 1 | SELECT * FROM `nut_posts` WHERE (`PostID`='4521') AND (`Slug`='luchshiy-start-urala-v-rpl-goncharenko-vtoroy-raz-rushit-chempionskie-ambicii-spartaka') |
05:21:38.057 | 3.1 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `nut_posts` |
05:21:38.061 | 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` = 'nut_posts' AND `kcu`.`TABLE_NAME` = 'nut_posts' |
05:21:38.079 | 1.5 ms | SELECT | 2 | SELECT * FROM `nut_posts` WHERE `PostID`='4521' |
05:21:38.081 | 1.1 ms | SELECT | 2 | SELECT * FROM `bookmakers` WHERE `review`=4521 |
05:21:38.116 | 1.1 ms | SELECT | 1 | SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`image` <> '') AND (`StartDate` < 1740450098) AND ((`EndDate` > 1740450098) OR (`EndDate`=0)) |
05:21:38.120 | 1.9 ms | SELECT | 2 | 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:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.124 | 1.0 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
05:21:38.126 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=5 |
05:21:38.127 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=5 |
05:21:38.129 | 1.7 ms | SELECT | 2 | 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:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:21:38.130 | 0.9 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
05:21:38.131 | 1.0 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=598 |
05:21:38.132 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=598 |
05:21:38.133 | 1.0 ms | SELECT | 2 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_1' |
05:21:38.135 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`StartDate` < 1740450098) AND (`bottomImage` <> '') AND ((`EndDate` > 1740450098) OR (`EndDate`=0)) AND (`useBottom`=1) |
05:21:38.139 | 1.0 ms | SELECT | 1 | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE `SectionID`=1 |
05:21:38.140 | 0.9 ms | SELECT | 1 | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE `MenuID`='1' |
05:21:38.141 | 0.9 ms | SELECT | 1 | SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE (`Url`='posts/4521-luchshiy-start-urala-v-rpl-goncharenko-vtoroy-raz-rushit-chempionskie-ambicii-spartaka') AND (`Parent`='1266') |
05:21:38.143 | 1.4 ms | SELECT | 2 | SELECT * FROM `nut_posts` WHERE `PostID`='4521' |
05:21:38.145 | 3.1 ms | SELECT | 1 | SELECT * FROM `nut_posts_teams` WHERE `PostID`=4521 |
05:21:38.149 | 2.3 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `nut_posts_teams` |
05:21:38.151 | 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' |
05:21:38.155 | 1.2 ms | SELECT | 1 | SELECT * FROM `ut_teams` WHERE `TeamID` IN (5, 106) |
05:21:38.158 | 3.9 ms | SELECT | 1 | SELECT * FROM `nut_posts_persons` WHERE `PostID`=4521 |
05:21:38.162 | 0.9 ms | SELECT | 1 | SELECT * FROM `ut_news_categories` WHERE `CategoryID`=1 |
05:21:38.163 | 1.2 ms | SELECT | 1 | SELECT * FROM `ut_users` WHERE `UserID`=395756 |
05:21:38.167 | 1.2 ms | SELECT | 2 | SELECT * FROM `bookmakers` WHERE `review`=4521 |
05:21:38.169 | 1.0 ms | SELECT | 1 | SELECT * FROM `bookmakers` WHERE 0=1 |
05:21:38.170 | 4.3 ms | SELECT | 1 | SELECT * FROM `nut_posts_rating` WHERE `PostID`=4521 |
05:21:38.177 | 1.1 ms | SELECT | 1 | SELECT * FROM `nut_blogs` WHERE `BlogID`=506 |
05:21:38.179 | 2.3 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `nut_blogs` |
05:21:38.182 | 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_blogs' AND `kcu`.`TABLE_NAME` = 'nut_blogs' |
05:21:38.186 | 1.7 ms | SELECT | 1 | SELECT * FROM `nut_blogs_subscribe` WHERE `BlogID`=506 |
05:21:38.189 | 1.9 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `nut_blogs_subscribe` |
05:21:38.190 | 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' |
05:21:38.212 | 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_7') AND (`start_date` <= '2025-02-25 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.214 | 0.9 ms | SELECT | 1 | SELECT * FROM `auth_item` WHERE `name`='posts' |
05:21:38.215 | 1.0 ms | SELECT | 1 | SELECT `parent` FROM `auth_item_child` WHERE `child`='posts' |
05:21:38.216 | 0.9 ms | SELECT | 2 | SELECT * FROM `auth_item` WHERE `name`='admin' |
05:21:38.217 | 0.9 ms | SELECT | 2 | SELECT `parent` FROM `auth_item_child` WHERE `child`='admin' |
05:21:38.218 | 0.9 ms | SELECT | 1 | SELECT * FROM `auth_item` WHERE `name`='author' |
05:21:38.219 | 0.9 ms | SELECT | 1 | SELECT `parent` FROM `auth_item_child` WHERE `child`='author' |
05:21:38.220 | 0.9 ms | SELECT | 1 | SELECT * FROM `auth_item` WHERE `name`='Редактор' |
05:21:38.221 | 0.9 ms | SELECT | 1 | SELECT `parent` FROM `auth_item_child` WHERE `child`='Редактор' |
05:21:38.223 | 1.0 ms | SELECT | 1 | SELECT * FROM `nut_blogs_subscribe` WHERE (`BlogID`=506) AND (`UserID` IS NULL) |
05:21:38.225 | 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 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.227 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=8 |
05:21:38.228 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=295 |
05:21:38.229 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=295 |
05:21:38.230 | 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 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:21:38.231 | 1.0 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_8' |
05:21:38.240 | 1.0 ms | SELECT | 1 | SELECT * FROM `auth_item` WHERE `name`='comments' |
05:21:38.241 | 1.0 ms | SELECT | 1 | SELECT `parent` FROM `auth_item_child` WHERE `child`='comments' |
05:21:38.242 | 1.0 ms | SELECT | 2 | SELECT * FROM `auth_item` WHERE `name`='admin' |
05:21:38.243 | 1.0 ms | SELECT | 2 | SELECT `parent` FROM `auth_item_child` WHERE `child`='admin' |
05:21:38.246 | 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:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.247 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=57 |
05:21:38.248 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=300 |
05:21:38.249 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=300 |
05:21:38.250 | 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:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:21:38.252 | 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_30') AND (`start_date` <= '2025-02-25 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.253 | 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_35') AND (`start_date` <= '2025-02-25 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.258 | 1.8 ms | SELECT | 2 | 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:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.260 | 0.9 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
05:21:38.261 | 1.0 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=5 |
05:21:38.262 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=5 |
05:21:38.263 | 1.7 ms | SELECT | 2 | 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:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:21:38.265 | 0.9 ms | SELECT | 4 | SELECT * FROM `ad_places` WHERE `id`=1 |
05:21:38.266 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_photos` WHERE `ad_id`=598 |
05:21:38.267 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_logos` WHERE `ad_id`=598 |
05:21:38.268 | 0.9 ms | SELECT | 2 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_1' |
05:21:38.269 | 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:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.270 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=16 |
05:21:38.271 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=159 |
05:21:38.272 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=159 |
05:21:38.273 | 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:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:21:38.275 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=16 |
05:21:38.276 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=597 |
05:21:38.277 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=597 |
05:21:38.278 | 1.1 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_16' |
05:21:38.286 | 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_48') AND (`start_date` <= '2025-02-25 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.287 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=48 |
05:21:38.288 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=305 |
05:21:38.289 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=305 |
05:21:38.290 | 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:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:21:38.292 | 1.0 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_48' |
05:21:38.295 | 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 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.297 | 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_2') AND (`start_date` <= '2025-02-25 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.299 | 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 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.300 | 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_41') AND (`start_date` <= '2025-02-25 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.301 | 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 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.306 | 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_26') AND (`start_date` <= '2025-02-25 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.308 | 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 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.309 | 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 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.311 | 1.6 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 |
05:21:38.319 | 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_3') AND (`start_date` <= '2025-02-25 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.321 | 0.9 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=3 |
05:21:38.322 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=6 |
05:21:38.323 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=6 |
05:21:38.324 | 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 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:21:38.325 | 1.0 ms | SELECT | 2 | SELECT * FROM `ad_places` WHERE `id`=3 |
05:21:38.326 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=600 |
05:21:38.327 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=600 |
05:21:38.328 | 0.9 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_3' |
05:21:38.331 | 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_13') AND (`start_date` <= '2025-02-25 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.334 | 0.9 ms | SELECT | 1 | SELECT * FROM `partner_widgets` WHERE (`block_id`=3) AND (`is_disabled`=0) |
05:21:38.335 | 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 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.336 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_places` WHERE `id`=32 |
05:21:38.337 | 1.0 ms | SELECT | 1 | SELECT * FROM `ad_photos` WHERE `ad_id`=180 |
05:21:38.338 | 0.9 ms | SELECT | 1 | SELECT * FROM `ad_logos` WHERE `ad_id`=180 |
05:21:38.339 | 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 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE)) |
05:21:38.341 | 1.0 ms | SELECT | 1 | SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_32' |
05:21:38.342 | 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_33') AND (`start_date` <= '2025-02-25 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.346 | 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_25') AND (`start_date` <= '2025-02-25 05:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
05:21:38.348 | 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:21:38') AND ((`end_date` >= '2025-02-25 05:21:38') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE)) |
Caller | No. of Calls | Total Duration | Queries | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
116 | 143.2 ms |
|