cheeseCake
 

Browse Archive : Tags - tag3


tag4画像tag3
 
RSS 2.0 / ATOM feed | Valid xHTML / Valid CSS | Cake Power3d
10 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `CHEESECAKE_photos`770
2DESCRIBE `CHEESECAKE_comments`990
3DESCRIBE `CHEESECAKE_tags`220
4DESCRIBE `CHEESECAKE_configs`13130
5SELECT `Config`.`modified` FROM `CHEESECAKE_configs` AS `Config` WHERE id=1 LIMIT 1110
6SELECT `Config`.`id`, `Config`.`siteName`, `Config`.`siteUrl`, `Config`.`theme`, `Config`.`thumbSize`, `Config`.`thumbType`, `Config`.`updateNews`, `Config`.`moderateComment`, `Config`.`commentNotification`, `Config`.`timezone`, `Config`.`filmstripCount`, `Config`.`created`, `Config`.`modified` FROM `CHEESECAKE_configs` AS `Config` WHERE id=1 LIMIT 1110
7DESCRIBE `CHEESECAKE_addons`330
8SELECT `Addon`.`id`, `Addon`.`directory`, `Addon`.`activated` FROM `CHEESECAKE_addons` AS `Addon` WHERE `Addon`.`activated` = 'yes' 000
9SELECT count(Photo.id) AS count, COUNT(DISTINCT tags.tag) AS uniques FROM CHEESECAKE_photos Photo, CHEESECAKE_photos_tags photos_tags, CHEESECAKE_tags tags WHERE Photo.id = photos_tags.photo_id AND tags.id = photos_tags.tag_id AND tags.tag IN ('tag3') AND Photo.created <= '2025-05-21 16:59:00' HAVING uniques = 1110
10SELECT Photo.id,Photo.filename,Photo.title,Photo.created, COUNT(DISTINCT tags.tag) AS uniques FROM CHEESECAKE_photos Photo, CHEESECAKE_photos_tags photos_tags, CHEESECAKE_tags tags WHERE Photo.id = photos_tags.photo_id AND tags.id = photos_tags.tag_id AND tags.tag IN ('tag3') AND Photo.created <= '2025-05-21 16:59:00' GROUP BY photos_tags.photo_id HAVING uniques = '1' ORDER BY Photo.created DESC LIMIT 0, 5221