Log

[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(17) "START TRANSACTION"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(100) "SELECT COUNT(*) FROM `vUsers` u WHERE `userID` <> 1 AND TRUE  AND `sections` REGEXP "^,(15)" LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(116) "SELECT * FROM `vUsers` u WHERE `userID` <> 1 AND TRUE  AND `sections` REGEXP "^,(15)" ORDER BY top5 DESC LIMIT 0, 10"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 25 AND `blockedID` = 1 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/services/SearchService.php:445]:
  string(14) "11|12|13|14|15"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(86) "SELECT count(*) FROM relations WHERE `userID` IN (1,25) AND `mateID` IN (1,25) LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(77) "SELECT count(*) FROM bookmarks WHERE `userID` = 1 AND `targetID` = 25 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 1 AND `blockedID` = 25 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 32 AND `blockedID` = 1 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/services/SearchService.php:445]:
  string(0) ""
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(86) "SELECT count(*) FROM relations WHERE `userID` IN (1,32) AND `mateID` IN (1,32) LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(77) "SELECT count(*) FROM bookmarks WHERE `userID` = 1 AND `targetID` = 32 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 1 AND `blockedID` = 32 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 44 AND `blockedID` = 1 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/services/SearchService.php:445]:
  string(0) ""
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(86) "SELECT count(*) FROM relations WHERE `userID` IN (1,44) AND `mateID` IN (1,44) LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(77) "SELECT count(*) FROM bookmarks WHERE `userID` = 1 AND `targetID` = 44 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 1 AND `blockedID` = 44 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 48 AND `blockedID` = 1 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/services/SearchService.php:445]:
  string(0) ""
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(86) "SELECT count(*) FROM relations WHERE `userID` IN (1,48) AND `mateID` IN (1,48) LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(77) "SELECT count(*) FROM bookmarks WHERE `userID` = 1 AND `targetID` = 48 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 1 AND `blockedID` = 48 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 54 AND `blockedID` = 1 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/services/SearchService.php:445]:
  string(0) ""
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(86) "SELECT count(*) FROM relations WHERE `userID` IN (1,54) AND `mateID` IN (1,54) LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(77) "SELECT count(*) FROM bookmarks WHERE `userID` = 1 AND `targetID` = 54 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 1 AND `blockedID` = 54 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 73 AND `blockedID` = 1 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/services/SearchService.php:445]:
  string(0) ""
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(86) "SELECT count(*) FROM relations WHERE `userID` IN (1,73) AND `mateID` IN (1,73) LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(77) "SELECT count(*) FROM bookmarks WHERE `userID` = 1 AND `targetID` = 73 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 1 AND `blockedID` = 73 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 80 AND `blockedID` = 1 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/services/SearchService.php:445]:
  string(32) "13|14|22|23|25|26|27|28|30|32|41"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(86) "SELECT count(*) FROM relations WHERE `userID` IN (1,80) AND `mateID` IN (1,80) LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(77) "SELECT count(*) FROM bookmarks WHERE `userID` = 1 AND `targetID` = 80 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 1 AND `blockedID` = 80 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 83 AND `blockedID` = 1 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/services/SearchService.php:445]:
  string(0) ""
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(86) "SELECT count(*) FROM relations WHERE `userID` IN (1,83) AND `mateID` IN (1,83) LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(77) "SELECT count(*) FROM bookmarks WHERE `userID` = 1 AND `targetID` = 83 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 1 AND `blockedID` = 83 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 86 AND `blockedID` = 1 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/services/SearchService.php:445]:
  string(0) ""
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(86) "SELECT count(*) FROM relations WHERE `userID` IN (1,86) AND `mateID` IN (1,86) LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(77) "SELECT count(*) FROM bookmarks WHERE `userID` = 1 AND `targetID` = 86 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(74) "SELECT count(*) FROM block WHERE `userID` = 1 AND `blockedID` = 86 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(75) "SELECT count(*) FROM block WHERE `userID` = 113 AND `blockedID` = 1 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/services/SearchService.php:445]:
  string(0) ""
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(88) "SELECT count(*) FROM relations WHERE `userID` IN (1,113) AND `mateID` IN (1,113) LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(78) "SELECT count(*) FROM bookmarks WHERE `userID` = 1 AND `targetID` = 113 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(75) "SELECT count(*) FROM block WHERE `userID` = 1 AND `blockedID` = 113 LIMIT 1"
[2011/10/23 21:39:51 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(6) "COMMIT"
[2011/10/23 21:39:53 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(17) "START TRANSACTION"
[2011/10/23 21:39:53 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(477) "SELECT `type`, SUM(`count`) as `count`, `target`, `roleID`, (CASE WHEN count(DISTINCT `targetID`) = 1 THEN `targetID` ELSE NULL END) AS `targetID`, (CASE WHEN count(DISTINCT `callID`) = 1 THEN `callID` ELSE NULL END) AS `targetCallID`, `callID` AS `callID` FROM vAlerts WHERE 
  					`userID` = 14
  				AND `checked` = 0 
  				AND `created` < CURRENT_TIMESTAMP 
  				AND (`expired` IS NULL OR `expired` > CURRENT_TIMESTAMP)
  				GROUP BY `type` ORDER BY `created` DESC, `alertID` ASC"
[2011/10/23 21:39:53 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(6) "COMMIT"
[2011/10/23 21:39:54 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(17) "START TRANSACTION"
[2011/10/23 21:39:54 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(477) "SELECT `type`, SUM(`count`) as `count`, `target`, `roleID`, (CASE WHEN count(DISTINCT `targetID`) = 1 THEN `targetID` ELSE NULL END) AS `targetID`, (CASE WHEN count(DISTINCT `callID`) = 1 THEN `callID` ELSE NULL END) AS `targetCallID`, `callID` AS `callID` FROM vAlerts WHERE 
  					`userID` = 70
  				AND `checked` = 0 
  				AND `created` < CURRENT_TIMESTAMP 
  				AND (`expired` IS NULL OR `expired` > CURRENT_TIMESTAMP)
  				GROUP BY `type` ORDER BY `created` DESC, `alertID` ASC"
[2011/10/23 21:39:54 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(6) "COMMIT"
[2011/10/23 21:39:55 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(17) "START TRANSACTION"
[2011/10/23 21:39:55 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(476) "SELECT `type`, SUM(`count`) as `count`, `target`, `roleID`, (CASE WHEN count(DISTINCT `targetID`) = 1 THEN `targetID` ELSE NULL END) AS `targetID`, (CASE WHEN count(DISTINCT `callID`) = 1 THEN `callID` ELSE NULL END) AS `targetCallID`, `callID` AS `callID` FROM vAlerts WHERE 
  					`userID` = 1
  				AND `checked` = 0 
  				AND `created` < CURRENT_TIMESTAMP 
  				AND (`expired` IS NULL OR `expired` > CURRENT_TIMESTAMP)
  				GROUP BY `type` ORDER BY `created` DESC, `alertID` ASC"
[2011/10/23 21:39:55 @ /amfphp/managers/database/DBManager.class.php:62]:
  string(6) "COMMIT"