| 1 | SELECT `Gallery`.`id`, `Gallery`.`user_id`, `Gallery`.`view_count`, `Gallery`.`favourite_count`, `Gallery`.`comment_count`, `Gallery`.`mark_count`, `Gallery`.`mark_sum`, `Gallery`.`flag`, `Gallery`.`created`, `Fpfile`.`id`, `Fpfile`.`caption`, `Fpfile`.`filename`, `Fpfile`.`flag`, `Image`.`width`, `Image`.`height`, `Image`.`has_tags`, `Image`.`has_people`, `Image`.`has_exif`, `GalleriesSerie`.`id`, `GalleriesGalleriesCategoriesPersonal`.`id`, `User`.`id`, `User`.`urlname`, `User`.`nick`, `User`.`gender`, `User`.`pro`, `User`.`access`, `User`.`facebook_id`, `UsersStatus`.`value` FROM `novafotopa`.`galleries` AS `Gallery` LEFT JOIN `novafotopa`.`images` AS `Image` ON (`Image`.`file_id` = `Gallery`.`file_id`) LEFT JOIN `novafotopa`.`galleries__series` AS `GalleriesSerie` ON (`GalleriesSerie`.`gallery_id` = `Gallery`.`id`) LEFT JOIN `novafotopa`.`galleries_galleries__categories_personals` AS `GalleriesGalleriesCategoriesPersonal` ON (`GalleriesGalleriesCategoriesPersonal`.`gallery_id` = `Gallery`.`id` AND `GalleriesGalleriesCategoriesPersonal`.`category_id` = 12 AND `GalleriesGalleriesCategoriesPersonal`.`user_id` = 0) LEFT JOIN `novafotopa`.`users` AS `User` ON (`User`.`id`=`Gallery`.`user_id`) LEFT JOIN `novafotopa`.`users__profiles_chars` AS `UsersStatus` ON (`User`.`id`=`UsersStatus`.`user_id` AND `UsersStatus`.`profile_id`=140) LEFT JOIN `novafotopa`.`files` AS `Fpfile` ON (`Gallery`.`file_id` = `Fpfile`.`id`) WHERE `Gallery`.`id` = 119123 AND `User`.`id` IS NOT NULL LIMIT 1 | | 1 | 1 | 2 |
| 2 | SELECT `GalleriesComment`.`id`, `GalleriesComment`.`user_id`, `GalleriesComment`.`gallery_id`, `GalleriesComment`.`mark_id`, `GalleriesComment`.`text`, `GalleriesComment`.`created`, `GalleriesComment`.`modified` FROM `novafotopa`.`galleries__comments` AS `GalleriesComment` WHERE `GalleriesComment`.`gallery_id` = (119123) | | 2 | 2 | 1 |
| 3 | SELECT `GalleriesCategory`.`name`, `GalleriesGalleriesCategory`.`id`, `GalleriesGalleriesCategory`.`user_id`, `GalleriesGalleriesCategory`.`gallery_id`, `GalleriesGalleriesCategory`.`category_id`, `GalleriesGalleriesCategory`.`created` FROM `novafotopa`.`galleries__categories` AS `GalleriesCategory` JOIN `novafotopa`.`galleries_galleries__categories` AS `GalleriesGalleriesCategory` ON (`GalleriesGalleriesCategory`.`gallery_id` = 119123 AND `GalleriesGalleriesCategory`.`category_id` = `GalleriesCategory`.`id`) WHERE `GalleriesCategory`.`parent_id` = 3 | | 3 | 3 | 1 |
| 4 | SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`simple_name`, `Tag`.`created`, `GalleriesTag`.`id`, `GalleriesTag`.`user_id`, `GalleriesTag`.`gallery_id`, `GalleriesTag`.`area_id`, `GalleriesTag`.`tag_id`, `GalleriesTag`.`created` FROM `novafotopa`.`tags` AS `Tag` JOIN `novafotopa`.`galleries_tags` AS `GalleriesTag` ON (`GalleriesTag`.`gallery_id` = 119123 AND `GalleriesTag`.`tag_id` = `Tag`.`id`) | | 0 | 0 | 1 |
| 5 | SELECT `UsersAbility`.`user_id`, `UsersAbility`.`ability_id` FROM `novafotopa`.`users_abilities` AS `UsersAbility` WHERE `UsersAbility`.`user_id` = 14200 ORDER BY `user_id` asc, `ord` asc | | 2 | 2 | 1 |
| 6 | UPDATE `novafotopa`.`galleries` AS `Gallery` LEFT JOIN `novafotopa`.`files` AS `Fpfile` ON (`Gallery`.`file_id` = `Fpfile`.`id`) SET `Gallery`.`view_count` = view_count+1 WHERE `Gallery`.`id` = 119123 | | 1 | 1 | 11 |
| 7 | SELECT `Gallery`.`id` FROM `novafotopa`.`galleries` AS `Gallery` WHERE `user_id` = 14200 AND id<>119123 LIMIT 1 | | 1 | 1 | 3 |
| 8 | SELECT `Descr`.`txt`, `GalleriesSeriesDescr`.`txt` FROM `novafotopa`.`galleries` AS `Gallery` LEFT JOIN `novafotopa`.`files__descr` AS `Descr` ON (`Descr`.`file_id` = `Gallery`.`file_id`) LEFT JOIN `novafotopa`.`galleries__series` AS `GalleriesSerie` ON (`GalleriesSerie`.`gallery_id` = `Gallery`.`id`) LEFT JOIN `novafotopa`.`galleries__series__descr` AS `GalleriesSeriesDescr` ON (`GalleriesSeriesDescr`.`galleries_serie_id` = `GalleriesSerie`.`id`) WHERE `Gallery`.`id` = 119123 LIMIT 1 | | 1 | 1 | 1 |
| 9 | SELECT `Tag`.`name` FROM `novafotopa`.`galleries_tags` AS `GalleriesTag` INNER JOIN `novafotopa`.`tags` AS `Tag` ON (`Tag`.`id` = `GalleriesTag`.`tag_id`) WHERE `GalleriesTag`.`gallery_id` = 119123 | | 0 | 0 | 1 |
| 10 | SELECT `GalleriesMark`.`id`, `GalleriesMark`.`user_id`, `GalleriesMark`.`gallery_id`, `GalleriesMark`.`mark`, `GalleriesMark`.`created`, `GalleriesMark`.`modified` FROM `novafotopa`.`galleries__marks` AS `GalleriesMark` WHERE `gallery_id` = 119123 LIMIT 1 | | 1 | 1 | 1 |
| 11 | SELECT `Gallery`.`id` FROM `novafotopa`.`galleries` AS `Gallery` WHERE `Gallery`.`id`>0 AND `Gallery`.`old_fp` = -1 ORDER BY `Gallery`.`priority` desc, `Gallery`.`id` desc LIMIT 1 | | 1 | 1 | 1 |
| 12 | SELECT `Gallery`.`id` FROM `novafotopa`.`galleries` AS `Gallery` WHERE `Gallery`.`id`>0 AND `Gallery`.`old_fp` = -1 ORDER BY `Gallery`.`priority` asc, `Gallery`.`id` asc LIMIT 1 | | 1 | 1 | 173 |
| 13 | SELECT `GalleriesComment`.`id`, `GalleriesComment`.`user_id`, `GalleriesComment`.`gallery_id`, `GalleriesComment`.`text`, `GalleriesComment`.`created`, `GalleriesComment2`.`id`, `GalleriesComment2`.`text`, `User2`.`nick`, `GalleriesMark`.`mark`, `GalleriesComment`.`modified`, `GalleriesCommentsDelete`.`user_id`, `GalleriesCommentsDelete`.`by_admin`, `User`.`id`, `User`.`urlname`, `User`.`nick`, `User`.`gender`, `User`.`pro`, `User`.`access`, `User`.`facebook_id`, `UsersStatus`.`value` FROM `novafotopa`.`galleries__comments` AS `GalleriesComment` LEFT JOIN `novafotopa`.`galleries__responses` AS `GalleriesResponse` ON (`GalleriesResponse`.`comment_id` = `GalleriesComment`.`id`) LEFT JOIN `novafotopa`.`galleries__responses` AS `GalleriesResponse2` ON (`GalleriesResponse2`.`id` = `GalleriesResponse`.`parent_id` AND `GalleriesResponse`.`parent_id`>1) LEFT JOIN `novafotopa`.`galleries__comments` AS `GalleriesComment2` ON (`GalleriesComment2`.`id` = `GalleriesResponse2`.`comment_id`) LEFT JOIN `novafotopa`.`users` AS `User2` ON (`User2`.`id` = `GalleriesComment2`.`user_id`) LEFT JOIN `novafotopa`.`galleries__marks` AS `GalleriesMark` ON (`GalleriesMark`.`id` = `GalleriesComment`.`mark_id`) LEFT JOIN `novafotopa`.`users` AS `User` ON (`User`.`id`=`GalleriesComment`.`user_id`) LEFT JOIN `novafotopa`.`users__profiles_chars` AS `UsersStatus` ON (`User`.`id`=`UsersStatus`.`user_id` AND `UsersStatus`.`profile_id`=140) LEFT JOIN `novafotopa`.`galleries__comments__deletes` AS `GalleriesCommentsDelete` ON (`GalleriesCommentsDelete`.`galleries_comment_id` = `GalleriesComment`.`id`) WHERE `GalleriesComment`.`gallery_id` = 119123 AND `User`.`id` IS NOT NULL ORDER BY `GalleriesComment`.`id` desc LIMIT 20 | | 2 | 2 | 3 |
| 14 | SELECT `GalleriesCommentsAttachment`.`id`, `GalleriesCommentsAttachment`.`filename`, `GalleriesCommentsAttachment`.`caption`, `GalleriesCommentsAttachment`.`tp`, `GalleriesCommentsAttachment`.`flag`, `GalleriesCommentsAttachment`.`access`, `GalleriesCommentsGalleriesAttachment`.`id`, `GalleriesCommentsGalleriesAttachment`.`galleries_comment_id`, `GalleriesCommentsGalleriesAttachment`.`ord`, `GalleriesCommentsImage`.`width`, `GalleriesCommentsImage`.`height`, `GalleriesCommentsImage`.`twidth`, `GalleriesCommentsImage`.`theight` FROM `galleries__comments__attachments` AS `GalleriesCommentsAttachment`
JOIN `galleries__comments_galleries__attachments` AS `GalleriesCommentsGalleriesAttachment` ON (`GalleriesCommentsGalleriesAttachment`.`galleries_comment_id` IN (666655, 660672) AND `GalleriesCommentsGalleriesAttachment`.`attachment_id` = `GalleriesCommentsAttachment`.`id`)
LEFT JOIN `galleries__comments__images` AS `GalleriesCommentsImage` ON (`GalleriesCommentsAttachment`.`id` = `GalleriesCommentsImage`.`attachment_id`) ORDER BY `GalleriesCommentsGalleriesAttachment`.`ord` | | 0 | 0 | 1 |
| 15 | SELECT `UsersAbility`.`user_id`, `UsersAbility`.`ability_id` FROM `novafotopa`.`users_abilities` AS `UsersAbility` WHERE `UsersAbility`.`user_id` IN (111478, 30635) ORDER BY `user_id` asc, `ord` asc | | 2 | 2 | 1 |
| 16 | SELECT COUNT(*) AS `count` FROM `novafotopa`.`galleries__comments` AS `GalleriesComment` LEFT JOIN `novafotopa`.`galleries__responses` AS `GalleriesResponse` ON (`GalleriesResponse`.`comment_id` = `GalleriesComment`.`id`) LEFT JOIN `novafotopa`.`galleries__responses` AS `GalleriesResponse2` ON (`GalleriesResponse2`.`id` = `GalleriesResponse`.`parent_id` AND `GalleriesResponse`.`parent_id`>1) LEFT JOIN `novafotopa`.`galleries__comments` AS `GalleriesComment2` ON (`GalleriesComment2`.`id` = `GalleriesResponse2`.`comment_id`) LEFT JOIN `novafotopa`.`users` AS `User2` ON (`User2`.`id` = `GalleriesComment2`.`user_id`) LEFT JOIN `novafotopa`.`galleries__marks` AS `GalleriesMark` ON (`GalleriesMark`.`id` = `GalleriesComment`.`mark_id`) LEFT JOIN `novafotopa`.`users` AS `User` ON (`User`.`id`=`GalleriesComment`.`user_id`) LEFT JOIN `novafotopa`.`galleries__comments__deletes` AS `GalleriesCommentsDelete` ON (`GalleriesCommentsDelete`.`galleries_comment_id` = `GalleriesComment`.`id`) WHERE `GalleriesComment`.`gallery_id` = 119123 AND `User`.`id` IS NOT NULL | | 1 | 1 | 1 |
nahlásit
nahlásit