Přeskočit navigaci
/users/viewalbumpage/12098/1/26255/page:2/ins:1
(default) 4 queries took 10 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `UsersCategory`.`id`, `UsersCategory`.`name`, `UsersCategory`.`parent_id`, `UsersCategory`.`count`, `UsersCategory`.`icon`, `UsersCategory`.`active` FROM `novafotopa`.`abilities` AS `UsersCategory` WHERE `active` = '1' AND id>0 ORDER BY `lft` ASC13131
2SELECT `UsersProfilesCheck`.`id` FROM `novafotopa`.`users__profiles_checks` AS `UsersProfilesCheck` WHERE `user_id` = 12098 AND `profile_id` = 255 AND `value` = 306 LIMIT 1001
3SELECT `Fpfile`.`id`, `Fpfile`.`filename`, `Fpfile`.`caption`, `Fpfile`.`tp`, `Fpfile`.`flag`, `Fpfile`.`created`, `Image`.`twidth`, `Image`.`theight`, `Image`.`width`, `Image`.`height`, `Image`.`has_tags`, `Image`.`has_people`, `Descr`.`txt`, `Exif`.`shooted`, `AlbumsFile`.`id`, `AlbumsFile`.`ord`, `Gallery`.`id` FROM `novafotopa`.`files` AS `Fpfile` JOIN albums_files AS AlbumsFile ON (AlbumsFile.file_id = Fpfile.id) LEFT JOIN images AS Image ON (Image.file_id = Fpfile.id) LEFT JOIN files__descr AS Descr ON (Descr.file_id = Fpfile.id) LEFT JOIN images__exif AS Exif ON (Exif.file_id = Fpfile.id) LEFT JOIN galleries AS Gallery ON (Gallery.file_id = Fpfile.id) INNER JOIN `novafotopa`.`albums` AS `Album` ON (`Album`.`id` = `AlbumsFile`.`album_id`) WHERE `AlbumsFile`.`album_id` = 26255 AND ((`Fpfile`.`access`&256)=0 AND (`Fpfile`.`flag`&256=0)) AND `Album`.`user_id` = 12098 AND `Album`.`access` = 0 ORDER BY `AlbumsFile`.`ord` asc, `AlbumsFile`.`file_id` desc LIMIT 20, 2020205
4SELECT COUNT(*) AS `count` FROM `novafotopa`.`files` AS `Fpfile` JOIN albums_files AS AlbumsFile ON (AlbumsFile.file_id = Fpfile.id) INNER JOIN `novafotopa`.`albums` AS `Album` ON (`Album`.`id` = `AlbumsFile`.`album_id`) WHERE `AlbumsFile`.`album_id` = 26255 AND ((`Fpfile`.`access`&256)=0 AND (`Fpfile`.`flag`&256=0)) AND `Album`.`user_id` = 12098 AND `Album`.`access` = 0113