Database Queries

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

SELECT * FROM `session` WHERE `expire`>1749321083 AND `id`='fjrd32tf034lp4j15q9tivmmoq'

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_profile` WHERE `userId` IS NULL

INSERT INTO `session` (`userId`, `ip`, `clientData`, `createdAt`, `data`, `id`, `expire`) VALUES (0, '192.168.4.240', 'Mozilla/5.0 (Android 14; Mobile; rv:139.0) Gecko/139.0 Firefox/139.0', 1749321083, '__flash|a:0:{}createdAt|s:24:\"۱۷ خرداد ۱۴۰۴\";userId|s:1:\"0\";', 'fjrd32tf034lp4j15q9tivmmoq', 1749322523) ON DUPLICATE KEY UPDATE `userId`=VALUES(`userId`), `ip`=VALUES(`ip`), `clientData`=VALUES(`clientData`), `createdAt`=VALUES(`createdAt`), `data`=VALUES(`data`), `expire`=VALUES(`expire`)