Fotopátračka.cz

(default) 3 queries took 4 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `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` ASC	13	13	1
2	SELECT `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`, `AlbumsFile`.`id`, `AlbumsFile`.`ord` 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) INNER JOIN `novafotopa`.`albums` AS `Album` ON (`Album`.`id` = `AlbumsFile`.`album_id`) WHERE `AlbumsFile`.`album_id` = 96676 AND ((`Fpfile`.`access`&256)=0 AND (`Fpfile`.`flag`&256=0)) AND `Fpfile`.`tp` = 0 AND `Album`.`user_id` = 136794 AND `Album`.`access` = 0 ORDER BY `AlbumsFile`.`ord` asc, `AlbumsFile`.`file_id` desc LIMIT 20	20	20	2
3	SELECT 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` = 96676 AND ((`Fpfile`.`access`&256)=0 AND (`Fpfile`.`flag`&256=0)) AND `Fpfile`.`tp` = 0 AND `Album`.`user_id` = 136794 AND `Album`.`access` = 0	1	1	1

(default) 3 queries took 4 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `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` ASC

SELECT `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`, `AlbumsFile`.`id`, `AlbumsFile`.`ord` 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) INNER JOIN `novafotopa`.`albums` AS `Album` ON (`Album`.`id` = `AlbumsFile`.`album_id`) WHERE `AlbumsFile`.`album_id` = 96676 AND ((`Fpfile`.`access`&256)=0 AND (`Fpfile`.`flag`&256=0)) AND `Fpfile`.`tp` = 0 AND `Album`.`user_id` = 136794 AND `Album`.`access` = 0 ORDER BY `AlbumsFile`.`ord` asc, `AlbumsFile`.`file_id` desc LIMIT 20

SELECT 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` = 96676 AND ((`Fpfile`.`access`&256)=0 AND (`Fpfile`.`flag`&256=0)) AND `Fpfile`.`tp` = 0 AND `Album`.`user_id` = 136794 AND `Album`.`access` = 0

Fotopátračka.cz

Pomoc

Pravidla

Novinky