Database Queries

SELECT `value` FROM `setting` WHERE `key`='website.cache'

SELECT * FROM `session` WHERE `expire`>1749397565 AND `id`='glg7qhqjj04j87pmitpgklimkv'

SELECT * FROM `website` WHERE (`isRemoved`=0) AND ((`subdomain`='www') AND (`language`='fa'))

SELECT * FROM `notification` WHERE (`userId` IS NULL) AND (`seen`=FALSE) ORDER BY moduleId="user" DESC, createdAt DESC

SELECT COUNT(*) FROM `user` WHERE `status`=4

SELECT COUNT(*) FROM `recipient` WHERE recipient.websiteId = NULL

SELECT COUNT(*) FROM `contact` WHERE (contact.websiteId = NULL) AND (`isRead`=0)

SELECT `newsId` FROM `news_suggested_website_relation` WHERE websiteId = NULL

SELECT COUNT(*) FROM `news` LEFT JOIN `news_suggested_website_relation` ON `news`.`id` = `news_suggested_website_relation`.`newsId` WHERE (0=1) AND (`status`=1) AND (news_suggested_website_relation.websiteId = NULL)

SELECT COUNT(*) FROM `comment` WHERE (comment.websiteId = NULL) AND ((`ownerModelClassName`='aca\\news\\backend\\models\\News') AND (`confirmStatus`=0))

SELECT COUNT(*) FROM `comment` WHERE (comment.websiteId = NULL) AND ((`ownerModelClassName`='aca\\download\\backend\\models\\Download') AND (`confirmStatus`=0))

SELECT * FROM `user_login_log` WHERE (`status`=0) AND (`username` IS NULL) ORDER BY `id` DESC

SELECT * FROM `user_login_log` WHERE (`status`=1) AND (`username` IS NULL) ORDER BY `id` DESC

SELECT * FROM `user_profile` WHERE `userId` IS NULL

INSERT INTO `session` (`userId`, `ip`, `clientData`, `createdAt`, `data`, `id`, `expire`) VALUES (0, '192.168.4.240', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Mobile Safari/537.36', 1749397565, '__flash|a:0:{}createdAt|s:24:\"۱۸ خرداد ۱۴۰۴\";userId|s:1:\"0\";', 'glg7qhqjj04j87pmitpgklimkv', 1749399005) ON DUPLICATE KEY UPDATE `userId`=VALUES(`userId`), `ip`=VALUES(`ip`), `clientData`=VALUES(`clientData`), `createdAt`=VALUES(`createdAt`), `data`=VALUES(`data`), `expire`=VALUES(`expire`)