Database Queries

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

SELECT * FROM `session` WHERE `expire`>1749454587 AND `id`='s54oso983o3hq1h9cte9c6pp1h'

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

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

SELECT * FROM `user_login_log` WHERE `ip`='192.168.4.240' ORDER BY `time` DESC

INSERT INTO `session` (`userId`, `ip`, `clientData`, `createdAt`, `data`, `id`, `expire`) VALUES (0, '192.168.4.240', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36', 1749454587, '__flash|a:0:{}createdAt|s:24:\"۱۹ خرداد ۱۴۰۴\";userId|s:1:\"0\";__captcha/send/captcha|s:6:\"gimlka\";__captcha/send/captchacount|i:1;active-website|O:34:\"aca\\website\\backend\\models\\Website\":11:{s:61:\"\0aca\\website\\common\\models\\Website\0sameLanguageDefaultWebsite\";O:34:\"aca\\website\\backend\\models\\Website\":11:{s:61:\"\0aca\\website\\common\\models\\Website\0sameLanguageDefaultWebsite\";N;s:36:\"\0yii\\db\\BaseActiveRecord\0_attributes\";a:15:{s:2:\"id\";i:2;s:8:\"language\";s:2:\"fa\";s:9:\"subdomain\";s:3:\"www\";s:5:\"title\";s:42:\"دانشگاه ولایت ایرانشهر\";s:11:\"description\";s:0:\"\";s:8:\"priority\";i:5;s:8:\"isActive\";i:1;s:9:\"isRemoved\";i:0;s:9:\"createdAt\";i:1558773617;s:9:\"updatedAt\";i:1655621055;s:10:\"categoryId\";N;s:5:\"theme\";s:17:\"velayatuniversity\";s:6:\"domain\";N;s:7:\"logoUrl\";s:0:\"\";s:13:\"secondLogoUrl\";s:0:\"\";}s:39:\"\0yii\\db\\BaseActiveRecord\0_oldAttributes\";a:15:{s:2:\"id\";i:2;s:8:\"language\";s:2:\"fa\";s:9:\"subdomain\";s:3:\"www\";s:5:\"title\";s:42:\"دانشگاه ولایت ایرانشهر\";s:11:\"description\";s:0:\"\";s:8:\"priority\";i:5;s:8:\"isActive\";i:1;s:9:\"isRemoved\";i:0;s:9:\"createdAt\";i:1558773617;s:9:\"updatedAt\";i:1655621055;s:10:\"categoryId\";N;s:5:\"theme\";s:17:\"velayatuniversity\";s:6:\"domain\";N;s:7:\"logoUrl\";s:0:\"\";s:13:\"secondLogoUrl\";s:0:\"\";}s:33:\"\0yii\\db\\BaseActiveRecord\0_related\";a:0:{}s:47:\"\0yii\\db\\BaseActiveRecord\0_relationsDependencies\";a:0:{}s:23:\"\0yii\\base\\Model\0_errors\";N;s:27:\"\0yii\\base\\Model\0_validators\";N;s:25:\"\0yii\\base\\Model\0_scenario\";s:7:\"default\";s:27:\"\0yii\\base\\Component\0_events\";a:10:{s:12:\"beforeInsert\";a:3:{i:0;a:2:{i:0;a:2:{i:0;O:38:\"aca\\fileManager\\behaviors\\FileBehavior\":10:{s:6:\"groups\";a:3:{s:4:\"logo\";a:2:{s:4:\"type\";b:1;s:5:\"rules\";a:2:{s:10:\"extensions\";a:4:{i:0;s:3:\"png\";i:1;s:3:\"jpg\";i:2;s:4:\"jpeg\";i:3;s:3:\"gif\";}s:7:\"maxSize\";i:5242880;}}s:10:\"secondLogo\";a:2:{s:4:\"type\";b:1;s:5:\"rules\";a:2:{s:10:\"extensions\";a:4:{i:0;s:3:\"png\";i:1;s:3:\"jpg\";i:2;s:4:\"jpeg\";i:3;s:3:\"gif\";}s:7:\"maxSize\";i:5242880;}}s:7:\"favicon\";a:2:{s:4:\"type\";b:0;s:5:\"rules\";a:2:{s:10:\"extensions\";a:1:{i:0;s:3:\"ico\";}s:7:\"maxSize\";i:102400;}}}s:22:\"fallbackModelClassName\";N;s:20:\"fileUploaderUniqueId\";N;s:15:\"newFileUploaded\";N;s:10:\"uploadType\";s:12:\"simpleUpload\";s:50:\"\0aca\\fileManager\\behaviors\\FileBehavior\0fileErrors\";a:0:{}s:45:\"\0aca\\fileManager\\behaviors\\FileBehavior\0files\";N;s:54:\"\0aca\\fileManager\\behaviors\\FileBehavior\0deletedFileIds\";a:0:{}s:5:\"owner\";r:7;s:34:\"\0yii\\base\\Behavior\0_attachedEvents\";a:7:{s:12:\"beforeInsert\";s:13:\"validateFiles\";s:12:\"beforeUpdate\";s:13:\"validateFiles\";s:10:\"clonedData\";s:10:\"cloneFiles\";s:11:\"afterInsert\";s:11:\"uploadFiles\";s:12:\"acceptedData\";s:18:\"moveToOriginalData\";s:11:\"afterUpdate\";s:39:\"deleteRemovalRequestFilesAndUploadFiles\";s:12:\"beforeDelete\";s:11:\"deleteFiles\";}}i:1;s:13:\"validateFiles\";}i:1;N;}i:1;a:2:{i:0;a:2:{i:0;O:38:\"aca\\common\\behaviors\\TimestampBehavior\":8:{s:18:\"createdAtAttribute\";s:9:\"createdAt\";s:18:\"updatedAtAttribute\";s:9:\"updatedAt\";s:5:\"value\";N;s:10:\"attributes\";a:2:{s:12:\"beforeInsert\";a:2:{i:0;s:9:\"createdAt\";i:1;s:9:\"updatedAt\";}s:12:\"beforeUpdate\";s:9:\"updatedAt\";}s:17:\"skipUpdateOnClean\";b:1;s:22:\"preserveNonEmptyValues\";b:0;s:5:\"owner\";r:7;s:34:\"\0yii\\base\\Behavior\0_attachedEvents\";a:2:{s:12:\"beforeInsert\";s:18:\"evaluateAttributes\";s:12:\"beforeUpdate\";s:18:\"evaluateAttributes\";}}i:1;s:18:\"evaluateAttributes\";}i:1;N;}i:2;a:2:{i:0;a:2:{i:0;O:42:\"aca\\log\\backend\\behaviors\\LoggableBehavior\":11:{s:19:\"modelTitleAttribute\";s:5:\"title\";s:13:\"ignoredFields\";a:0:{}s:6:\"action\";a:1:{s:17:\"ajax-select-theme\";s:19:\"تغییر قالب\";}s:14:\"ignoredActions\";a:0:{}s:15:\"isMultiLanguage\";b:0;s:6:\"\0*\0log\";N;s:59:\"\0aca\\log\\backend\\behaviors\\LoggableBehavior\0forbiddenModels\";a:1:{i:0;s:24:\"aca\\gallery\\models\\Image\";}s:57:\"\0aca\\log\\backend\\behaviors\\LoggableBehavior\0oldAttributes\";a:0:{}s:61:\"\0aca\\log\\backend\\behaviors\\LoggableBehavior\0changedAttributes\";N;s:5:\"owner\";r:7;s:34:\"\0yii\\base\\Behavior\0_attachedEvents\";a:7:{s:12:\"beforeInsert\";s:12:\"beforeInsert\";s:12:\"beforeUpdate\";s:12:\"beforeUpdate\";s:12:\"beforeDelete\";s:12:\"beforeDelete\";s:11:\"afterInsert\";s:11:\"afterInsert\";s:11:\"afterUpdate\";s:11:\"afterUpdate\";s:11:\"afterDelete\";s:11:\"afterDelete\";s:15:\"logCustomAction\";s:15:\"logCustomAction\";}}i:1;s:12:\"beforeInsert\";}i:1;N;}}s:12:\"beforeUpdate\";a:3:{i:0;a:2:{i:0;a:2:{i:0;r:50;i:1;s:13:\"validateFiles\";}i:1;N;}i:1;a:2:{i:0;a:2:{i:0;r:96;i:1;s:18:\"evaluateAttributes\";}i:1;N;}i:2;a:2:{i:0;a:2:{i:0;r:115;i:1;s:12:\"beforeUpdate\";}i:1;N;}}s:10:\"clonedData\";a:1:{i:0;a:2:{i:0;a:2:{i:0;r:50;i:1;s:10:\"cloneFiles\";}i:1;N;}}s:11:\"afterInsert\";a:2:{i:0;a:2:{i:0;a:2:{i:0;r:50;i:1;s:11:\"uploadFiles\";}i:1;N;}i:1;a:2:{i:0;a:2:{i:0;r:115;i:1;s:11:\"afterInsert\";}i:1;N;}}s:12:\"acceptedData\";a:1:{i:0;a:2:{i:0;a:2:{i:0;r:50;i:1;s:18:\"moveToOriginalData\";}i:1;N;}}s:11:\"afterUpdate\";a:2:{i:0;a:2:{i:0;a:2:{i:0;r:50;i:1;s:39:\"deleteRemovalRequestFilesAndUploadFiles\";}i:1;N;}i:1;a:2:{i:0;a:2:{i:0;r:115;i:1;s:11:\"afterUpdate\";}i:1;N;}}s:12:\"beforeDelete\";a:2:{i:0;a:2:{i:0;a:2:{i:0;r:50;i:1;s:11:\"deleteFiles\";}i:1;N;}i:1;a:2:{i:0;a:2:{i:0;r:115;i:1;s:12:\"beforeDelete\";}i:1;N;}}s:11:\"themeChange\";a:2:{i:0;a:2:{i:0;a:2:{i:0;O:47:\"aca\\widgetConfig\\behaviors\\ThemeConfigsBehavior\":2:{s:5:\"owner\";r:7;s:34:\"\0yii\\base\\Behavior\0_attachedEvents\";a:1:{s:11:\"themeChange\";s:20:\"transferThemeConfigs\";}}i:1;s:20:\"transferThemeConfigs\";}i:1;N;}i:1;a:2:{i:0;a:2:{i:0;r:7;i:1;s:17:\"cleanCachedImages\";}i:1;N;}}s:11:\"afterDelete\";a:1:{i:0;a:2:{i:0;a:2:{i:0;r:115;i:1;s:11:\"afterDelete\";}i:1;N;}}s:15:\"logCustomAction\";a:1:{i:0;a:2:{i:0;a:2:{i:0;r:115;i:1;s:15:\"logCustomAction\";}i:1;N;}}}s:35:\"\0yii\\base\\Component\0_eventWildcards\";a:0:{}s:30:\"\0yii\\base\\Component\0_behaviors\";a:4:{i:0;r:50;i:1;r:202;i:2;r:96;s:8:\"loggable\";r:115;}}s:36:\"\0yii\\db\\BaseActiveRecord\0_attributes\";a:15:{s:2:\"id\";i:2;s:8:\"language\";s:2:\"fa\";s:9:\"subdomain\";s:3:\"www\";s:5:\"title\";s:42:\"دانشگاه ولایت ایرانشهر\";s:11:\"description\";s:0:\"\";s:8:\"priority\";i:5;s:8:\"isActive\";i:1;s:9:\"isRemoved\";i:0;s:9:\"createdAt\";i:1558773617;s:9:\"updatedAt\";i:1655621055;s:10:\"categoryId\";N;s:5:\"theme\";s:17:\"velayatuniversity\";s:6:\"domain\";N;s:7:\"logoUrl\";s:0:\"\";s:13:\"secondLogoUrl\";s:0:\"\";}s:39:\"\0yii\\db\\BaseActiveRecord\0_oldAttributes\";a:15:{s:2:\"id\";i:2;s:8:\"language\";s:2:\"fa\";s:9:\"subdomain\";s:3:\"www\";s:5:\"title\";s:42:\"دانشگاه ولایت ایرانشهر\";s:11:\"description\";s:0:\"\";s:8:\"priority\";i:5;s:8:\"isActive\";i:1;s:9:\"isRemoved\";i:0;s:9:\"createdAt\";i:1558773617;s:9:\"updatedAt\";i:1655621055;s:10:\"categoryId\";N;s:5:\"theme\";s:17:\"velayatuniversity\";s:6:\"domain\";N;s:7:\"logoUrl\";s:0:\"\";s:13:\"secondLogoUrl\";s:0:\"\";}s:33:\"\0yii\\db\\BaseActiveRecord\0_related\";a:1:{s:15:\"languageDetails\";O:35:\"aca\\website\\backend\\models\\Language\":10:{s:36:\"\0yii\\db\\BaseActiveRecord\0_attributes\";a:5:{s:4:\"code\";s:2:\"fa\";s:4:\"name\";s:7:\"Persian\";s:9:\"direction\";s:3:\"rtl\";s:8:\"calendar\";s:6:\"jalali\";s:5:\"order\";i:1;}s:39:\"\0yii\\db\\BaseActiveRecord\0_oldAttributes\";a:5:{s:4:\"code\";s:2:\"fa\";s:4:\"name\";s:7:\"Persian\";s:9:\"direction\";s:3:\"rtl\";s:8:\"calendar\";s:6:\"jalali\";s:5:\"order\";i:1;}s:33:\"\0yii\\db\\BaseActiveRecord\0_related\";a:0:{}s:47:\"\0yii\\db\\BaseActiveRecord\0_relationsDependencies\";a:0:{}s:23:\"\0yii\\base\\Model\0_errors\";N;s:27:\"\0yii\\base\\Model\0_validators\";N;s:25:\"\0yii\\base\\Model\0_scenario\";s:7:\"default\";s:27:\"\0yii\\base\\Component\0_events\";a:0:{}s:35:\"\0yii\\base\\Component\0_eventWildcards\";a:0:{}s:30:\"\0yii\\base\\Component\0_behaviors\";a:0:{}}}s:47:\"\0yii\\db\\BaseActiveRecord\0_relationsDependencies\";a:0:{}s:23:\"\0yii\\base\\Model\0_errors\";N;s:27:\"\0yii\\base\\Model\0_validators\";N;s:25:\"\0yii\\base\\Model\0_scenario\";s:7:\"default\";s:27:\"\0yii\\base\\Component\0_events\";a:10:{s:12:\"beforeInsert\";a:3:{i:0;a:2:{i:0;a:2:{i:0;O:38:\"aca\\fileManager\\behaviors\\FileBehavior\":10:{s:6:\"groups\";a:3:{s:4:\"logo\";a:2:{s:4:\"type\";b:1;s:5:\"rules\";a:2:{s:10:\"extensions\";a:4:{i:0;s:3:\"png\";i:1;s:3:\"jpg\";i:2;s:4:\"jpeg\";i:3;s:3:\"gif\";}s:7:\"maxSize\";i:5242880;}}s:10:\"secondLogo\";a:2:{s:4:\"type\";b:1;s:5:\"rules\";a:2:{s:10:\"extensions\";a:4:{i:0;s:3:\"png\";i:1;s:3:\"jpg\";i:2;s:4:\"jpeg\";i:3;s:3:\"gif\";}s:7:\"maxSize\";i:5242880;}}s:7:\"favicon\";a:2:{s:4:\"type\";b:0;s:5:\"rules\";a:2:{s:10:\"extensions\";a:1:{i:0;s:3:\"ico\";}s:7:\"maxSize\";i:102400;}}}s:22:\"fallbackModelClassName\";N;s:20:\"fileUploaderUniqueId\";N;s:15:\"newFileUploaded\";N;s:10:\"uploadType\";s:12:\"simpleUpload\";s:50:\"\0aca\\fileManager\\behaviors\\FileBehavior\0fileErrors\";a:0:{}s:45:\"\0aca\\fileManager\\behaviors\\FileBehavior\0files\";N;s:54:\"\0aca\\fileManager\\behaviors\\FileBehavior\0deletedFileIds\";a:0:{}s:5:\"owner\";r:6;s:34:\"\0yii\\base\\Behavior\0_attachedEvents\";a:7:{s:12:\"beforeInsert\";s:13:\"validateFiles\";s:12:\"beforeUpdate\";s:13:\"validateFiles\";s:10:\"clonedData\";s:10:\"cloneFiles\";s:11:\"afterInsert\";s:11:\"uploadFiles\";s:12:\"acceptedData\";s:18:\"moveToOriginalData\";s:11:\"afterUpdate\";s:39:\"deleteRemovalRequestFilesAndUploadFiles\";s:12:\"beforeDelete\";s:11:\"deleteFiles\";}}i:1;s:13:\"validateFiles\";}i:1;N;}i:1;a:2:{i:0;a:2:{i:0;O:38:\"aca\\common\\behaviors\\TimestampBehavior\":8:{s:18:\"createdAtAttribute\";s:9:\"createdAt\";s:18:\"updatedAtAttribute\";s:9:\"updatedAt\";s:5:\"value\";N;s:10:\"attributes\";a:2:{s:12:\"beforeInsert\";a:2:{i:0;s:9:\"createdAt\";i:1;s:9:\"updatedAt\";}s:12:\"beforeUpdate\";s:9:\"updatedAt\";}s:17:\"skipUpdateOnClean\";b:1;s:22:\"preserveNonEmptyValues\";b:0;s:5:\"owner\";r:6;s:34:\"\0yii\\base\\Behavior\0_attachedEvents\";a:2:{s:12:\"beforeInsert\";s:18:\"evaluateAttributes\";s:12:\"beforeUpdate\";s:18:\"evaluateAttributes\";}}i:1;s:18:\"evaluateAttributes\";}i:1;N;}i:2;a:2:{i:0;a:2:{i:0;O:42:\"aca\\log\\backend\\behaviors\\LoggableBehavior\":11:{s:19:\"modelTitleAttribute\";s:5:\"title\";s:13:\"ignoredFields\";a:0:{}s:6:\"action\";a:1:{s:17:\"ajax-select-theme\";s:19:\"تغییر قالب\";}s:14:\"ignoredActions\";a:0:{}s:15:\"isMultiLanguage\";b:0;s:6:\"\0*\0log\";N;s:59:\"\0aca\\log\\backend\\behaviors\\LoggableBehavior\0forbiddenModels\";a:1:{i:0;s:24:\"aca\\gallery\\models\\Image\";}s:57:\"\0aca\\log\\backend\\behaviors\\LoggableBehavior\0oldAttributes\";a:0:{}s:61:\"\0aca\\log\\backend\\behaviors\\LoggableBehavior\0changedAttributes\";N;s:5:\"owner\";r:6;s:34:\"\0yii\\base\\Behavior\0_attachedEvents\";a:7:{s:12:\"beforeInsert\";s:12:\"beforeInsert\";s:12:\"beforeUpdate\";s:12:\"beforeUpdate\";s:12:\"beforeDelete\";s:12:\"beforeDelete\";s:11:\"afterInsert\";s:11:\"afterInsert\";s:11:\"afterUpdate\";s:11:\"afterUpdate\";s:11:\"afterDelete\";s:11:\"afterDelete\";s:15:\"logCustomAction\";s:15:\"logCustomAction\";}}i:1;s:12:\"beforeInsert\";}i:1;N;}}s:12:\"beforeUpdate\";a:3:{i:0;a:2:{i:0;a:2:{i:0;r:293;i:1;s:13:\"validateFiles\";}i:1;N;}i:1;a:2:{i:0;a:2:{i:0;r:339;i:1;s:18:\"evaluateAttributes\";}i:1;N;}i:2;a:2:{i:0;a:2:{i:0;r:358;i:1;s:12:\"beforeUpdate\";}i:1;N;}}s:10:\"clonedData\";a:1:{i:0;a:2:{i:0;a:2:{i:0;r:293;i:1;s:10:\"cloneFiles\";}i:1;N;}}s:11:\"afterInsert\";a:2:{i:0;a:2:{i:0;a:2:{i:0;r:293;i:1;s:11:\"uploadFiles\";}i:1;N;}i:1;a:2:{i:0;a:2:{i:0;r:358;i:1;s:11:\"afterInsert\";}i:1;N;}}s:12:\"acceptedData\";a:1:{i:0;a:2:{i:0;a:2:{i:0;r:293;i:1;s:18:\"moveToOriginalData\";}i:1;N;}}s:11:\"afterUpdate\";a:2:{i:0;a:2:{i:0;a:2:{i:0;r:293;i:1;s:39:\"deleteRemovalRequestFilesAndUploadFiles\";}i:1;N;}i:1;a:2:{i:0;a:2:{i:0;r:358;i:1;s:11:\"afterUpdate\";}i:1;N;}}s:12:\"beforeDelete\";a:2:{i:0;a:2:{i:0;a:2:{i:0;r:293;i:1;s:11:\"deleteFiles\";}i:1;N;}i:1;a:2:{i:0;a:2:{i:0;r:358;i:1;s:12:\"beforeDelete\";}i:1;N;}}s:11:\"themeChange\";a:2:{i:0;a:2:{i:0;a:2:{i:0;O:47:\"aca\\widgetConfig\\behaviors\\ThemeConfigsBehavior\":2:{s:5:\"owner\";r:6;s:34:\"\0yii\\base\\Behavior\0_attachedEvents\";a:1:{s:11:\"themeChange\";s:20:\"transferThemeConfigs\";}}i:1;s:20:\"transferThemeConfigs\";}i:1;N;}i:1;a:2:{i:0;a:2:{i:0;r:6;i:1;s:17:\"cleanCachedImages\";}i:1;N;}}s:11:\"afterDelete\";a:1:{i:0;a:2:{i:0;a:2:{i:0;r:358;i:1;s:11:\"afterDelete\";}i:1;N;}}s:15:\"logCustomAction\";a:1:{i:0;a:2:{i:0;a:2:{i:0;r:358;i:1;s:15:\"logCustomAction\";}i:1;N;}}}s:35:\"\0yii\\base\\Component\0_eventWildcards\";a:0:{}s:30:\"\0yii\\base\\Component\0_behaviors\";a:4:{i:0;r:293;i:1;r:445;i:2;r:339;s:8:\"loggable\";r:358;}}__returnUrl|s:32:\"https://www.velayat.ac.ir/admin/\";', 's54oso983o3hq1h9cte9c6pp1h', 1749456027) ON DUPLICATE KEY UPDATE `userId`=VALUES(`userId`), `ip`=VALUES(`ip`), `clientData`=VALUES(`clientData`), `createdAt`=VALUES(`createdAt`), `data`=VALUES(`data`), `expire`=VALUES(`expire`)