| 1 | SELECT `UsersCategory`.`id`, `UsersCategory`.`name`, `UsersCategory`.`jobicon`, `UsersAbility`.`created` FROM `novafotopa`.`users_abilities` AS `UsersAbility` LEFT JOIN `novafotopa`.`abilities` AS `UsersCategory` ON (`UsersCategory`.`id`=`UsersAbility`.`ability_id`) WHERE `UsersAbility`.`user_id` = 136794 AND `UsersAbility`.`access` = 0 ORDER BY `UsersAbility`.`ord` asc | | 1 | 1 | 2 |
| 2 | SELECT `ImagesUser`.`id` FROM `novafotopa`.`images_users` AS `ImagesUser` WHERE `useronimage_id` = 136794 AND `ability_id` = 2 LIMIT 1 | | 0 | 0 | 1 |
| 3 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`OrigUserPsw`, `User`.`urlname`, `User`.`nick`, `User`.`gender`, `User`.`email`, `User`.`emphasized`, `User`.`pro`, `User`.`lastactivity`, `User`.`access`, `User`.`fan_count`, `User`.`friend_count`, `User`.`recommend_count`, `User`.`facebook_id`, `User`.`created`, `User`.`modified`, `User`.`searched` FROM `novafotopa`.`users` AS `User` WHERE `id` = 136794 LIMIT 1 | | 1 | 1 | 1 |
| 4 | SELECT `UsersProfilesInt`.`id`, `UsersProfilesInt`.`user_id`, `UsersProfilesInt`.`profile_id`, `UsersProfilesInt`.`value`, `UsersProfilesInt`.`access`, `UsersProfilesInt`.`ord`, `UsersProfilesInt`.`created`, `UsersProfilesInt`.`modified` FROM `novafotopa`.`users__profiles_ints` AS `UsersProfilesInt` WHERE `UsersProfilesInt`.`profile_id` IN (22, 140, 12, 3, 4, 70, 252, 15, 13, 24, 25, 26, 152, 153, 154, 155, 156, 84, 127, 229, 255, 17, 11, 182, 7, 101, 102, 103, 183, 104, 105, 106, 233, 253, 80, 228, 254, 137, 138, 139, 256, 37, 110, 107, 108, 109, 147, 163, 173, 174, 125, 160, 161, 38, 111, 191, 175, 112, 192, 113, 193, 171, 166, 172, 134, 158, 95, 157, 114, 124, 169, 170, 167, 39, 40, 215, 216) AND `UsersProfilesInt`.`access` = 0 AND `UsersProfilesInt`.`user_id` = (136794) ORDER BY `UsersProfilesInt`.`profile_id` ASC, `UsersProfilesInt`.`ord` ASC | | 21 | 21 | 3 |
| 5 | SELECT `UsersProfilesChar`.`id`, `UsersProfilesChar`.`user_id`, `UsersProfilesChar`.`profile_id`, `UsersProfilesChar`.`value`, `UsersProfilesChar`.`access`, `UsersProfilesChar`.`ord`, `UsersProfilesChar`.`created`, `UsersProfilesChar`.`modified` FROM `novafotopa`.`users__profiles_chars` AS `UsersProfilesChar` WHERE `UsersProfilesChar`.`profile_id` IN (22, 140, 12, 3, 4, 70, 252, 15, 13, 24, 25, 26, 152, 153, 154, 155, 156, 84, 127, 229, 255, 17, 11, 182, 7, 101, 102, 103, 183, 104, 105, 106, 233, 253, 80, 228, 254, 137, 138, 139, 256, 37, 110, 107, 108, 109, 147, 163, 173, 174, 125, 160, 161, 38, 111, 191, 175, 112, 192, 113, 193, 171, 166, 172, 134, 158, 95, 157, 114, 124, 169, 170, 167, 39, 40, 215, 216) AND `UsersProfilesChar`.`access` = 0 AND `UsersProfilesChar`.`user_id` = (136794) ORDER BY `UsersProfilesChar`.`profile_id` ASC, `UsersProfilesChar`.`ord` ASC | | 4 | 4 | 3 |
| 6 | SELECT `UsersProfilesText`.`id`, `UsersProfilesText`.`user_id`, `UsersProfilesText`.`profile_id`, `UsersProfilesText`.`value`, `UsersProfilesText`.`access`, `UsersProfilesText`.`created`, `UsersProfilesText`.`modified` FROM `novafotopa`.`users__profiles_texts` AS `UsersProfilesText` WHERE `UsersProfilesText`.`profile_id` IN (22, 140, 12, 3, 4, 70, 252, 15, 13, 24, 25, 26, 152, 153, 154, 155, 156, 84, 127, 229, 255, 17, 11, 182, 7, 101, 102, 103, 183, 104, 105, 106, 233, 253, 80, 228, 254, 137, 138, 139, 256, 37, 110, 107, 108, 109, 147, 163, 173, 174, 125, 160, 161, 38, 111, 191, 175, 112, 192, 113, 193, 171, 166, 172, 134, 158, 95, 157, 114, 124, 169, 170, 167, 39, 40, 215, 216) AND `UsersProfilesText`.`access` = 0 AND `UsersProfilesText`.`user_id` = (136794) | | 1 | 1 | 2 |
| 7 | SELECT `UsersProfilesDate`.`id`, `UsersProfilesDate`.`user_id`, `UsersProfilesDate`.`profile_id`, `UsersProfilesDate`.`value`, `UsersProfilesDate`.`access`, `UsersProfilesDate`.`created`, `UsersProfilesDate`.`modified` FROM `novafotopa`.`users__profiles_dates` AS `UsersProfilesDate` WHERE `UsersProfilesDate`.`profile_id` IN (22, 140, 12, 3, 4, 70, 252, 15, 13, 24, 25, 26, 152, 153, 154, 155, 156, 84, 127, 229, 255, 17, 11, 182, 7, 101, 102, 103, 183, 104, 105, 106, 233, 253, 80, 228, 254, 137, 138, 139, 256, 37, 110, 107, 108, 109, 147, 163, 173, 174, 125, 160, 161, 38, 111, 191, 175, 112, 192, 113, 193, 171, 166, 172, 134, 158, 95, 157, 114, 124, 169, 170, 167, 39, 40, 215, 216) AND `UsersProfilesDate`.`access` = 0 AND `UsersProfilesDate`.`user_id` = (136794) | | 1 | 1 | 1 |
| 8 | SELECT `UsersProfilesCheck`.`id`, `UsersProfilesCheck`.`user_id`, `UsersProfilesCheck`.`profile_id`, `UsersProfilesCheck`.`value`, `UsersProfilesCheck`.`access`, `UsersProfilesCheck`.`created`, `UsersProfilesCheck`.`modified` FROM `novafotopa`.`users__profiles_checks` AS `UsersProfilesCheck` WHERE `UsersProfilesCheck`.`profile_id` IN (22, 140, 12, 3, 4, 70, 252, 15, 13, 24, 25, 26, 152, 153, 154, 155, 156, 84, 127, 229, 255, 17, 11, 182, 7, 101, 102, 103, 183, 104, 105, 106, 233, 253, 80, 228, 254, 137, 138, 139, 256, 37, 110, 107, 108, 109, 147, 163, 173, 174, 125, 160, 161, 38, 111, 191, 175, 112, 192, 113, 193, 171, 166, 172, 134, 158, 95, 157, 114, 124, 169, 170, 167, 39, 40, 215, 216) AND `UsersProfilesCheck`.`access` = 0 AND `UsersProfilesCheck`.`user_id` = (136794) | | 6 | 6 | 1 |
| 9 | SELECT DISTINCT `AlbumsAlbumsCategory`.`category_id` FROM `novafotopa`.`albums_albums__categories` AS `AlbumsAlbumsCategory` INNER JOIN `novafotopa`.`abilities_albums` AS `AbilitiesAlbum` ON (`AbilitiesAlbum`.`album_id`=`AlbumsAlbumsCategory`.`album_id` AND `AbilitiesAlbum`.`ability_id`=2) WHERE `AlbumsAlbumsCategory`.`user_id` = 136794 | | 1 | 1 | 2 |
| 10 | SELECT `Album`.`id`, `Album`.`name`, `Album`.`icon_id`, `Album`.`file_count`, `Album`.`video_count`, `Album`.`password`, `Album`.`created`, `AlbumsAlbumsCategory`.`category_id`, `AlbumDescr`.`txt` FROM `novafotopa`.`albums` AS `Album` LEFT JOIN `novafotopa`.`albums_albums__categories` AS `AlbumsAlbumsCategory` ON (`Album`.`id` = `AlbumsAlbumsCategory`.`album_id`) LEFT JOIN `novafotopa`.`albums__descr` AS `AlbumDescr` ON (`Album`.`id` = `AlbumDescr`.`album_id`) WHERE `Album`.`id` = 95570 AND `Album`.`user_id` = 136794 AND `Album`.`access` = 0 LIMIT 1 | | 1 | 1 | 1 |
| 11 | 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`, `Exif`.`shooted`, `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) LEFT JOIN images__exif AS Exif ON (Exif.file_id = Fpfile.id) INNER JOIN `novafotopa`.`albums` AS `Album` ON (`Album`.`id` = `AlbumsFile`.`album_id`) WHERE `AlbumsFile`.`album_id` = 95570 AND ((`Fpfile`.`access`&256)=0 AND (`Fpfile`.`flag`&256=0)) AND `Album`.`user_id` = 136794 AND `Album`.`access` = 0 ORDER BY `AlbumsFile`.`ord` asc, `AlbumsFile`.`file_id` desc LIMIT 100 | | 10 | 10 | 31 |
| 12 | 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` = 95570 AND ((`Fpfile`.`access`&256)=0 AND (`Fpfile`.`flag`&256=0)) AND `Album`.`user_id` = 136794 AND `Album`.`access` = 0 | | 1 | 1 | 3 |
| 13 | SELECT `Album`.`id`, `Album`.`name`, `Album`.`icon_id`, `Album`.`file_count`, `Album`.`video_count`, `Album`.`password`, `Album`.`created`, `Fpfile`.`id`, `Fpfile`.`filename`, `Fpfile`.`caption`, `Fpfile`.`tp`, `Fpfile`.`flag`, `Image`.`twidth`, `Image`.`theight`, `Image`.`has_tags`, `Image`.`has_people`, `AlbumsAlbumsCategory`.`category_id`, `AlbumDescr`.`txt`, `AbilitiesAlbum`.`id` FROM `novafotopa`.`albums` AS `Album` LEFT JOIN `novafotopa`.`files` AS `Fpfile` ON (`Album`.`icon_id` = `Fpfile`.`id`) LEFT JOIN `novafotopa`.`images` AS `Image` ON (`Album`.`icon_id` = `Image`.`file_id`) LEFT JOIN `novafotopa`.`albums_albums__categories` AS `AlbumsAlbumsCategory` ON (`Album`.`id` = `AlbumsAlbumsCategory`.`album_id`) LEFT JOIN `novafotopa`.`albums__descr` AS `AlbumDescr` ON (`Album`.`id` = `AlbumDescr`.`album_id`) LEFT JOIN `novafotopa`.`abilities_albums` AS `AbilitiesAlbum` ON (`Album`.`id` = `AbilitiesAlbum`.`album_id`) WHERE `AbilitiesAlbum`.`ability_id` = '2' AND `Album`.`user_id` = 136794 AND `Album`.`access` = 0 ORDER BY `AbilitiesAlbum`.`ord` asc, `Album`.`id` desc | | 8 | 8 | 5 |
| 14 | SELECT `UsersLogin`.`created` FROM `novafotopa`.`users__logins` AS `UsersLogin` WHERE `user_id` = 136794 ORDER BY `created` desc LIMIT 1 | | 1 | 1 | 2 |
| 15 | SELECT `Region`.`lft`, `Region`.`rght` FROM `novafotopa`.`regions` AS `Region` WHERE `Region`.`id` = 172 LIMIT 1 | | 1 | 1 | 1 |
| 16 | SELECT `Region`.`id`, `Region`.`user_id`, `Region`.`parent_id`, `Region`.`lft`, `Region`.`rght`, `Region`.`name`, `Region`.`simple_name`, `Region`.`gps_latitude`, `Region`.`gps_longitude`, `Region`.`created`, `Region`.`modified` FROM `novafotopa`.`regions` AS `Region` WHERE 1 = 1 AND `Region`.`lft` <= 241 AND `Region`.`rght` >= 242 ORDER BY `Region`.`lft` asc | | 5 | 5 | 2 |
| 17 | SELECT `Region`.`lft`, `Region`.`rght` FROM `novafotopa`.`regions` AS `Region` WHERE `Region`.`id` = 135 LIMIT 1 | | 1 | 1 | 1 |
| 18 | SELECT `Region`.`id`, `Region`.`user_id`, `Region`.`parent_id`, `Region`.`lft`, `Region`.`rght`, `Region`.`name`, `Region`.`simple_name`, `Region`.`gps_latitude`, `Region`.`gps_longitude`, `Region`.`created`, `Region`.`modified` FROM `novafotopa`.`regions` AS `Region` WHERE 1 = 1 AND `Region`.`lft` <= 205 AND `Region`.`rght` >= 206 ORDER BY `Region`.`lft` asc | | 5 | 5 | 6 |
| 19 | SELECT `Region`.`lft`, `Region`.`rght` FROM `novafotopa`.`regions` AS `Region` WHERE `Region`.`id` = 146 LIMIT 1 | | 1 | 1 | 1 |
| 20 | SELECT `Region`.`id`, `Region`.`user_id`, `Region`.`parent_id`, `Region`.`lft`, `Region`.`rght`, `Region`.`name`, `Region`.`simple_name`, `Region`.`gps_latitude`, `Region`.`gps_longitude`, `Region`.`created`, `Region`.`modified` FROM `novafotopa`.`regions` AS `Region` WHERE 1 = 1 AND `Region`.`lft` <= 249 AND `Region`.`rght` >= 250 ORDER BY `Region`.`lft` asc | | 5 | 5 | 1 |
| 21 | SELECT `Region`.`lft`, `Region`.`rght` FROM `novafotopa`.`regions` AS `Region` WHERE `Region`.`id` = 147 LIMIT 1 | | 1 | 1 | 1 |
| 22 | SELECT `Region`.`id`, `Region`.`user_id`, `Region`.`parent_id`, `Region`.`lft`, `Region`.`rght`, `Region`.`name`, `Region`.`simple_name`, `Region`.`gps_latitude`, `Region`.`gps_longitude`, `Region`.`created`, `Region`.`modified` FROM `novafotopa`.`regions` AS `Region` WHERE 1 = 1 AND `Region`.`lft` <= 253 AND `Region`.`rght` >= 254 ORDER BY `Region`.`lft` asc | | 5 | 5 | 1 |
| 23 | SELECT `UsersActivity`.*, `User`.`gender` FROM `novafotopa`.`users__activities` AS `UsersActivity` INNER JOIN `novafotopa`.`users` AS `User` ON (`UsersActivity`.`user_id`=`User`.`id`) WHERE `UsersActivity`.`user_id` = 136794 AND `UsersActivity`.`private` = '0' ORDER BY `UsersActivity`.`modified` desc LIMIT 3 | | 0 | 0 | 1 |
| 24 | SELECT `CommentsProfile`.`id`, `CommentsProfile`.`user_id`, `CommentsProfile`.`comment`, `CommentsProfile`.`modified`, `User`.`id`, `User`.`urlname`, `User`.`nick`, `User`.`gender`, `User`.`pro`, `User`.`access`, `User`.`facebook_id`, `UsersStatus`.`value` FROM `novafotopa`.`comments__profiles` AS `CommentsProfile` LEFT JOIN `novafotopa`.`users` AS `User` ON (`User`.`id`=`CommentsProfile`.`user_id`) LEFT JOIN `novafotopa`.`users__profiles_chars` AS `UsersStatus` ON (`User`.`id`=`UsersStatus`.`user_id` AND `UsersStatus`.`profile_id`=140) WHERE `CommentsProfile`.`user2_id` = 136794 AND `User`.`id` IS NOT NULL AND `User`.`access` = 0 ORDER BY `CommentsProfile`.`modified` desc LIMIT 4 | | 2 | 2 | 2 |
| 25 | SELECT `UsersAbility`.`user_id`, `UsersAbility`.`ability_id` FROM `novafotopa`.`users_abilities` AS `UsersAbility` WHERE `UsersAbility`.`user_id` IN (129065, 134544) ORDER BY `user_id` asc, `ord` asc | | 2 | 2 | 1 |
| 26 | SELECT `RecommendsProfile`.`id`, `RecommendsProfile`.`user_id`, `RecommendsProfile`.`note`, `RecommendsProfile`.`modified`, `User`.`id`, `User`.`urlname`, `User`.`nick`, `User`.`gender`, `User`.`pro`, `User`.`access`, `User`.`facebook_id`, `UsersStatus`.`value` FROM `novafotopa`.`recommends__profiles` AS `RecommendsProfile` LEFT JOIN `novafotopa`.`users` AS `User` ON (`User`.`id`=`RecommendsProfile`.`user_id`) LEFT JOIN `novafotopa`.`users__profiles_chars` AS `UsersStatus` ON (`User`.`id`=`UsersStatus`.`user_id` AND `UsersStatus`.`profile_id`=140) WHERE `RecommendsProfile`.`user2_id` = 136794 AND `User`.`id` IS NOT NULL AND `User`.`access` = 0 ORDER BY `RecommendsProfile`.`modified` desc, `RecommendsProfile`.`id` desc LIMIT 4 | | 4 | 4 | 2 |
| 27 | SELECT `UsersAbility`.`user_id`, `UsersAbility`.`ability_id` FROM `novafotopa`.`users_abilities` AS `UsersAbility` WHERE `UsersAbility`.`user_id` IN (129065, 129065, 129065, 134544) ORDER BY `user_id` asc, `ord` asc | | 2 | 2 | 2 |
| 28 | SELECT `RecommendsProfilesCount`.`note`, `RecommendsProfilesCount`.`recommend_count` FROM `novafotopa`.`recommends__profiles_counts` AS `RecommendsProfilesCount` WHERE `user_id` = 136794 | | 3 | 3 | 1 |
| 29 | SELECT `StampsContact`.`modified` FROM `novafotopa`.`stamps__contacts` AS `StampsContact` WHERE `user2_id` = 136794 LIMIT 1 | | 1 | 1 | 1 |
| 30 | SELECT `UsersProfilesCheck`.`id` FROM `novafotopa`.`users__profiles_checks` AS `UsersProfilesCheck` WHERE `user_id` = 136794 AND `profile_id` = 167 AND `value` = 121 LIMIT 1 | | 0 | 0 | 2 |
| 31 | SELECT `User`.`nick`, `User`.`urlname` FROM `novafotopa`.`users` AS `User` INNER JOIN `novafotopa`.`users__roles` AS `UsersRole` ON (`User`.`id` = `UsersRole`.`user2_id`) INNER JOIN `novafotopa`.`users__profiles_ints` AS `UsersProfilesInt` ON (`UsersProfilesInt`.`user_id` = `User`.`id` AND `UsersProfilesInt`.`profile_id` = 22 AND `UsersProfilesInt`.`value` = 8) WHERE `UsersRole`.`user_id` = '136794' AND `UsersRole`.`user2_id` > 1 AND `UsersRole`.`home` <> 'FpAdmin' AND `User`.`access` = 0 ORDER BY `UsersRole`.`id` desc LIMIT 10 | | 0 | 0 | 2 |
