Database Queries

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

SELECT * FROM `session` WHERE `expire`>1750539581 AND `id`='056k7b2aq3n4t4fh48qdnfd4tn'

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 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1', 1750539581, '__flash|a:0:{}createdAt|s:20:\"۰۱ تیر ۱۴۰۴\";userId|s:1:\"0\";', '056k7b2aq3n4t4fh48qdnfd4tn', 1750541021) ON DUPLICATE KEY UPDATE `userId`=VALUES(`userId`), `ip`=VALUES(`ip`), `clientData`=VALUES(`clientData`), `createdAt`=VALUES(`createdAt`), `data`=VALUES(`data`), `expire`=VALUES(`expire`)