Database Queries

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

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

SELECT * FROM `session` WHERE `expire`>1750554710 AND `id`='j9lruoh5fsjgqmim233cbgo3on'

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 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.7151.103 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 1750554710, '__flash|a:0:{}', 'j9lruoh5fsjgqmim233cbgo3on', 1750556150) ON DUPLICATE KEY UPDATE `userId`=VALUES(`userId`), `ip`=VALUES(`ip`), `clientData`=VALUES(`clientData`), `createdAt`=VALUES(`createdAt`), `data`=VALUES(`data`), `expire`=VALUES(`expire`)