2023/05/26 11:26:21 [trace] [system.CModule] Loading "log" application component
2023/05/26 11:26:21 [trace] [system.CModule] Loading "ETwigViewRenderer" application component
2023/05/26 11:26:21 [trace] [system.CModule] Loading "request" application component
2023/05/26 11:26:21 [trace] [system.CModule] Loading "urlManager" application component
2023/05/26 11:26:21 [trace] [system.CModule] Loading "cache" application component
2023/05/26 11:26:21 [trace] [application] Route "admin/remotecontrol passed without CSRF validation
2023/05/26 11:26:21 [trace] [system.CModule] Loading "session" application component
2023/05/26 11:26:21 [trace] [system.CModule] Loading "db" application component
2023/05/26 11:26:21 [trace] [system.db.CDbConnection] Opening DB connection
2023/05/26 11:26:21 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_settings_global`
2023/05/26 11:26:21 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_settings_global`
2023/05/26 11:26:21 [trace] [system.db.ar.CActiveRecord] SettingGlobal.findAll()
2023/05/26 11:26:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_settings_global` `t`
2023/05/26 11:26:21 [trace] [system.CModule] Loading "assetManager" application component
2023/05/26 11:26:21 [trace] [system.CModule] Loading "bootstrap" application component
2023/05/26 11:26:21 [trace] [system.CModule] Loading "user" application component
2023/05/26 11:26:21 [trace] [system.CModule] Loading "messages" application component
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation`
FROM `lime_source_message` `t1`, `lime_message` `t2`
WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language
2023/05/26 11:26:22 [trace] [system.CModule] Loading "clientScript" application component
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_surveys`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_surveys`
2023/05/26 11:26:22 [trace] [system.CModule] Loading "pluginManager" application component
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] SettingGlobal.find()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_settings_global` `t` WHERE stg_name=:name LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_plugins`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_plugins`
2023/05/26 11:26:22 [trace] [system.CModule] Loading "sodium" application component
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findAllByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0 ORDER BY priority DESC
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_failed_login_attempts`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_failed_login_attempts`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] FailedLoginAttempt.find()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_failed_login_attempts` `t` WHERE number_attempts >= :attempts AND ip = :ip AND is_frontend = :is_frontend LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_users`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_users`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] User.findByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_users` `t` WHERE `t`.`users_name`=:yp0 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_permissions`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_permissions`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Permission.findByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_permissions` `t` WHERE `t`.`entity_id`=:yp0 AND `t`.`entity`=:yp1 AND `t`.`uid`=:yp2 AND `t`.`permission`=:yp3 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findAll()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=1 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=2 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=3 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=4 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=8 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=9 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=10 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=5 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=6 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=7 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=11 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=12 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=13 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=14 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=15 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=16 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`id`=17 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] SettingGlobal.find()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_settings_global` `t` WHERE stg_name=:name LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findAllByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0 ORDER BY priority DESC
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] User.findAll()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_users` `t` WHERE `t`.`users_name`=:ycp0 LIMIT 2
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] User.update()
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] User.updateByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Executing SQL: UPDATE `lime_users` SET `uid`=:yp0, `users_name`=:yp1, `password`=:yp2, `full_name`=:yp3, `parent_id`=:yp4, `email`=:yp5, `htmleditormode`=:yp6, `templateeditormode`=:yp7, `questionselectormode`=:yp8, `one_time_pw`=:yp9, `dateformat`=:yp10, `last_login`=:yp11, `created`=:yp12, `modified`=NOW(), `validation_key`=:yp13, `validation_key_expiration`=:yp14, `last_forgot_email_password`=:yp15, `expires`=:yp16, `lang`=:yp17 WHERE `lime_users`.`uid`=1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] FailedLoginAttempt.deleteAllByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Executing SQL: DELETE FROM `lime_failed_login_attempts` WHERE `lime_failed_login_attempts`.`ip`=:yp0 AND `lime_failed_login_attempts`.`is_frontend`=:yp1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] User.findByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_users` `t` WHERE `t`.`users_name`=:yp0 LIMIT 1
2023/05/26 11:26:22 [trace] [system.CModule] Loading "securityManager" application component
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_sessions`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_sessions`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Session.insert()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Executing SQL: INSERT INTO `lime_sessions` (`id`, `expire`, `data`) VALUES (:yp0, :yp1, :yp2)
2023/05/26 11:26:22 [trace] [system.CModule] Loading "log" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "ETwigViewRenderer" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "request" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "urlManager" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "cache" application component
2023/05/26 11:26:22 [trace] [application] Route "admin/remotecontrol passed without CSRF validation
2023/05/26 11:26:22 [trace] [system.CModule] Loading "session" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "db" application component
2023/05/26 11:26:22 [trace] [system.db.CDbConnection] Opening DB connection
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_settings_global`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_settings_global`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] SettingGlobal.findAll()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_settings_global` `t`
2023/05/26 11:26:22 [trace] [system.CModule] Loading "assetManager" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "bootstrap" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "user" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "messages" application component
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation`
FROM `lime_source_message` `t1`, `lime_message` `t2`
WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language
2023/05/26 11:26:22 [trace] [system.CModule] Loading "clientScript" application component
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_surveys`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_surveys`
2023/05/26 11:26:22 [trace] [system.CModule] Loading "pluginManager" application component
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] SettingGlobal.find()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_settings_global` `t` WHERE stg_name=:name LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_plugins`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_plugins`
2023/05/26 11:26:22 [trace] [system.CModule] Loading "sodium" application component
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findAllByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0 ORDER BY priority DESC
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Session.deleteAll()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_sessions`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_sessions`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Executing SQL: DELETE FROM `lime_sessions` WHERE expire < 1685093182
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Session.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_sessions` `t` WHERE `t`.`id`='6W9RlJT7fWmV01grsmH_GiYkOp_vIURE' LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_users`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_users`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] User.findByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_users` `t` WHERE `t`.`users_name`=:yp0 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_permissions`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_permissions`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Permission.findByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_permissions` `t` WHERE `t`.`entity_id`=:yp0 AND `t`.`entity`=:yp1 AND `t`.`uid`=:yp2 AND `t`.`permission`=:yp3 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] User.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Survey.findAll()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_surveys_languagesettings`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_surveys_languagesettings`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT `t`.`sid` AS `t0_c0`, `t`.`owner_id` AS `t0_c1`, `t`.`gsid` AS `t0_c2`, `t`.`admin` AS `t0_c3`, `t`.`active` AS `t0_c4`, `t`.`expires` AS `t0_c5`, `t`.`startdate` AS `t0_c6`, `t`.`adminemail` AS `t0_c7`, `t`.`anonymized` AS `t0_c8`, `t`.`format` AS `t0_c9`, `t`.`savetimings` AS `t0_c10`, `t`.`template` AS `t0_c11`, `t`.`language` AS `t0_c12`, `t`.`additional_languages` AS `t0_c13`, `t`.`datestamp` AS `t0_c14`, `t`.`usecookie` AS `t0_c15`, `t`.`allowregister` AS `t0_c16`, `t`.`allowsave` AS `t0_c17`, `t`.`autonumber_start` AS `t0_c18`, `t`.`autoredirect` AS `t0_c19`, `t`.`allowprev` AS `t0_c20`, `t`.`printanswers` AS `t0_c21`, `t`.`ipaddr` AS `t0_c22`, `t`.`ipanonymize` AS `t0_c23`, `t`.`refurl` AS `t0_c24`, `t`.`datecreated` AS `t0_c25`, `t`.`showsurveypolicynotice` AS `t0_c26`, `t`.`publicstatistics` AS `t0_c27`, `t`.`publicgraphs` AS `t0_c28`, `t`.`listpublic` AS `t0_c29`, `t`.`htmlemail` AS `t0_c30`, `t`.`sendconfirmation` AS `t0_c31`, `t`.`tokenanswerspersistence` AS `t0_c32`, `t`.`assessments` AS `t0_c33`, `t`.`usecaptcha` AS `t0_c34`, `t`.`usetokens` AS `t0_c35`, `t`.`bounce_email` AS `t0_c36`, `t`.`attributedescriptions` AS `t0_c37`, `t`.`emailresponseto` AS `t0_c38`, `t`.`emailnotificationto` AS `t0_c39`, `t`.`tokenlength` AS `t0_c40`, `t`.`showxquestions` AS `t0_c41`, `t`.`showgroupinfo` AS `t0_c42`, `t`.`shownoanswer` AS `t0_c43`, `t`.`showqnumcode` AS `t0_c44`, `t`.`bouncetime` AS `t0_c45`, `t`.`bounceprocessing` AS `t0_c46`, `t`.`bounceaccounttype` AS `t0_c47`, `t`.`bounceaccounthost` AS `t0_c48`, `t`.`bounceaccountpass` AS `t0_c49`, `t`.`bounceaccountencryption` AS `t0_c50`, `t`.`bounceaccountuser` AS `t0_c51`, `t`.`showwelcome` AS `t0_c52`, `t`.`showprogress` AS `t0_c53`, `t`.`questionindex` AS `t0_c54`, `t`.`navigationdelay` AS `t0_c55`, `t`.`nokeyboard` AS `t0_c56`, `t`.`alloweditaftercompletion` AS `t0_c57`, `t`.`googleanalyticsstyle` AS `t0_c58`, `t`.`googleanalyticsapikey` AS `t0_c59`, `t`.`tokenencryptionoptions` AS `t0_c60`, `languagesettings`.`surveyls_survey_id` AS `t1_c0`, `languagesettings`.`surveyls_language` AS `t1_c1`, `languagesettings`.`surveyls_title` AS `t1_c2`, `languagesettings`.`surveyls_description` AS `t1_c3`, `languagesettings`.`surveyls_welcometext` AS `t1_c4`, `languagesettings`.`surveyls_endtext` AS `t1_c5`, `languagesettings`.`surveyls_policy_notice` AS `t1_c6`, `languagesettings`.`surveyls_policy_error` AS `t1_c7`, `languagesettings`.`surveyls_policy_notice_label` AS `t1_c8`, `languagesettings`.`surveyls_url` AS `t1_c9`, `languagesettings`.`surveyls_urldescription` AS `t1_c10`, `languagesettings`.`surveyls_email_invite_subj` AS `t1_c11`, `languagesettings`.`surveyls_email_invite` AS `t1_c12`, `languagesettings`.`surveyls_email_remind_subj` AS `t1_c13`, `languagesettings`.`surveyls_email_remind` AS `t1_c14`, `languagesettings`.`surveyls_email_register_subj` AS `t1_c15`, `languagesettings`.`surveyls_email_register` AS `t1_c16`, `languagesettings`.`surveyls_email_confirm_subj` AS `t1_c17`, `languagesettings`.`surveyls_email_confirm` AS `t1_c18`, `languagesettings`.`surveyls_dateformat` AS `t1_c19`, `languagesettings`.`surveyls_attributecaptions` AS `t1_c20`, `languagesettings`.`surveyls_alias` AS `t1_c21`, `languagesettings`.`email_admin_notification_subj` AS `t1_c22`, `languagesettings`.`email_admin_notification` AS `t1_c23`, `languagesettings`.`email_admin_responses_subj` AS `t1_c24`, `languagesettings`.`email_admin_responses` AS `t1_c25`, `languagesettings`.`surveyls_numberformat` AS `t1_c26`, `languagesettings`.`attachments` AS `t1_c27`, `owner`.`uid` AS `t2_c0`, `owner`.`users_name` AS `t2_c1`, `owner`.`password` AS `t2_c2`, `owner`.`full_name` AS `t2_c3`, `owner`.`parent_id` AS `t2_c4`, `owner`.`lang` AS `t2_c5`, `owner`.`email` AS `t2_c6`, `owner`.`htmleditormode` AS `t2_c7`, `owner`.`templateeditormode` AS `t2_c8`, `owner`.`questionselectormode` AS `t2_c9`, `owner`.`one_time_pw` AS `t2_c10`, `owner`.`dateformat` AS `t2_c11`, `owner`.`last_login` AS `t2_c12`, `owner`.`created` AS `t2_c13`, `owner`.`modified` AS `t2_c14`, `owner`.`validation_key` AS `t2_c15`, `owner`.`validation_key_expiration` AS `t2_c16`, `owner`.`last_forgot_email_password` AS `t2_c17`, `owner`.`expires` AS `t2_c18` FROM `lime_surveys` `t`  LEFT OUTER JOIN `lime_surveys_languagesettings` `languagesettings` ON (`languagesettings`.`surveyls_survey_id`=`t`.`sid`) LEFT OUTER JOIN `lime_users` `owner` ON (`t`.`owner_id`=`owner`.`uid`) WHERE (surveyls_language=language)
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] User.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_surveys_groupsettings`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_surveys_groupsettings`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] SurveysGroupsettings.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_surveys_groups`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_surveys_groups`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT `t`.`gsid` AS `t0_c0`, `t`.`owner_id` AS `t0_c1`, `t`.`admin` AS `t0_c2`, `t`.`adminemail` AS `t0_c3`, `t`.`anonymized` AS `t0_c4`, `t`.`format` AS `t0_c5`, `t`.`savetimings` AS `t0_c6`, `t`.`template` AS `t0_c7`, `t`.`datestamp` AS `t0_c8`, `t`.`usecookie` AS `t0_c9`, `t`.`allowregister` AS `t0_c10`, `t`.`allowsave` AS `t0_c11`, `t`.`autonumber_start` AS `t0_c12`, `t`.`autoredirect` AS `t0_c13`, `t`.`allowprev` AS `t0_c14`, `t`.`printanswers` AS `t0_c15`, `t`.`ipaddr` AS `t0_c16`, `t`.`ipanonymize` AS `t0_c17`, `t`.`refurl` AS `t0_c18`, `t`.`showsurveypolicynotice` AS `t0_c19`, `t`.`publicstatistics` AS `t0_c20`, `t`.`publicgraphs` AS `t0_c21`, `t`.`listpublic` AS `t0_c22`, `t`.`htmlemail` AS `t0_c23`, `t`.`sendconfirmation` AS `t0_c24`, `t`.`tokenanswerspersistence` AS `t0_c25`, `t`.`assessments` AS `t0_c26`, `t`.`usecaptcha` AS `t0_c27`, `t`.`bounce_email` AS `t0_c28`, `t`.`attributedescriptions` AS `t0_c29`, `t`.`emailresponseto` AS `t0_c30`, `t`.`emailnotificationto` AS `t0_c31`, `t`.`tokenlength` AS `t0_c32`, `t`.`showxquestions` AS `t0_c33`, `t`.`showgroupinfo` AS `t0_c34`, `t`.`shownoanswer` AS `t0_c35`, `t`.`showqnumcode` AS `t0_c36`, `t`.`showwelcome` AS `t0_c37`, `t`.`showprogress` AS `t0_c38`, `t`.`questionindex` AS `t0_c39`, `t`.`navigationdelay` AS `t0_c40`, `t`.`nokeyboard` AS `t0_c41`, `t`.`alloweditaftercompletion` AS `t0_c42`, `SurveysGroups`.`gsid` AS `t1_c0`, `SurveysGroups`.`name` AS `t1_c1`, `SurveysGroups`.`title` AS `t1_c2`, `SurveysGroups`.`template` AS `t1_c3`, `SurveysGroups`.`description` AS `t1_c4`, `SurveysGroups`.`sortorder` AS `t1_c5`, `SurveysGroups`.`owner_id` AS `t1_c6`, `SurveysGroups`.`parent_id` AS `t1_c7`, `SurveysGroups`.`alwaysavailable` AS `t1_c8`, `SurveysGroups`.`created` AS `t1_c9`, `SurveysGroups`.`modified` AS `t1_c10`, `SurveysGroups`.`created_by` AS `t1_c11` FROM `lime_surveys_groupsettings` `t`  LEFT OUTER JOIN `lime_surveys_groups` `SurveysGroups` ON (`SurveysGroups`.`gsid`=`t`.`gsid`) WHERE (`t`.`gsid`=1)
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] User.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] SurveysGroupsettings.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_surveys_groupsettings` `t` WHERE `t`.`gsid`=0 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] SurveyLanguageSetting.findByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_surveys_languagesettings` `t` WHERE `t`.`surveyls_survey_id`=:yp0 AND `t`.`surveyls_language`=:yp1 LIMIT 1
2023/05/26 11:26:22 [trace] [system.CModule] Loading "log" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "ETwigViewRenderer" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "request" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "urlManager" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "cache" application component
2023/05/26 11:26:22 [trace] [application] Route "admin/remotecontrol passed without CSRF validation
2023/05/26 11:26:22 [trace] [system.CModule] Loading "session" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "db" application component
2023/05/26 11:26:22 [trace] [system.db.CDbConnection] Opening DB connection
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_settings_global`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_settings_global`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] SettingGlobal.findAll()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_settings_global` `t`
2023/05/26 11:26:22 [trace] [system.CModule] Loading "assetManager" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "bootstrap" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "user" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "messages" application component
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation`
FROM `lime_source_message` `t1`, `lime_message` `t2`
WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language
2023/05/26 11:26:22 [trace] [system.CModule] Loading "clientScript" application component
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_surveys`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_surveys`
2023/05/26 11:26:22 [trace] [system.CModule] Loading "pluginManager" application component
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] SettingGlobal.find()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_settings_global` `t` WHERE stg_name=:name LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_plugins`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_plugins`
2023/05/26 11:26:22 [trace] [system.CModule] Loading "sodium" application component
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findAllByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0 ORDER BY priority DESC
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Session.deleteAll()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_sessions`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_sessions`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Executing SQL: DELETE FROM `lime_sessions` WHERE expire < 1685093182
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Session.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_sessions` `t` WHERE `t`.`id`='6W9RlJT7fWmV01grsmH_GiYkOp_vIURE' LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_users`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_users`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] User.findByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_users` `t` WHERE `t`.`users_name`=:yp0 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Survey.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=925344 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_permissions`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_permissions`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Permission.findByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_permissions` `t` WHERE `t`.`entity_id`=:yp0 AND `t`.`entity`=:yp1 AND `t`.`uid`=:yp2 AND `t`.`permission`=:yp3 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] User.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_surveys_groupsettings`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_surveys_groupsettings`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] SurveysGroupsettings.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_surveys_groups`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_surveys_groups`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT `t`.`gsid` AS `t0_c0`, `t`.`owner_id` AS `t0_c1`, `t`.`admin` AS `t0_c2`, `t`.`adminemail` AS `t0_c3`, `t`.`anonymized` AS `t0_c4`, `t`.`format` AS `t0_c5`, `t`.`savetimings` AS `t0_c6`, `t`.`template` AS `t0_c7`, `t`.`datestamp` AS `t0_c8`, `t`.`usecookie` AS `t0_c9`, `t`.`allowregister` AS `t0_c10`, `t`.`allowsave` AS `t0_c11`, `t`.`autonumber_start` AS `t0_c12`, `t`.`autoredirect` AS `t0_c13`, `t`.`allowprev` AS `t0_c14`, `t`.`printanswers` AS `t0_c15`, `t`.`ipaddr` AS `t0_c16`, `t`.`ipanonymize` AS `t0_c17`, `t`.`refurl` AS `t0_c18`, `t`.`showsurveypolicynotice` AS `t0_c19`, `t`.`publicstatistics` AS `t0_c20`, `t`.`publicgraphs` AS `t0_c21`, `t`.`listpublic` AS `t0_c22`, `t`.`htmlemail` AS `t0_c23`, `t`.`sendconfirmation` AS `t0_c24`, `t`.`tokenanswerspersistence` AS `t0_c25`, `t`.`assessments` AS `t0_c26`, `t`.`usecaptcha` AS `t0_c27`, `t`.`bounce_email` AS `t0_c28`, `t`.`attributedescriptions` AS `t0_c29`, `t`.`emailresponseto` AS `t0_c30`, `t`.`emailnotificationto` AS `t0_c31`, `t`.`tokenlength` AS `t0_c32`, `t`.`showxquestions` AS `t0_c33`, `t`.`showgroupinfo` AS `t0_c34`, `t`.`shownoanswer` AS `t0_c35`, `t`.`showqnumcode` AS `t0_c36`, `t`.`showwelcome` AS `t0_c37`, `t`.`showprogress` AS `t0_c38`, `t`.`questionindex` AS `t0_c39`, `t`.`navigationdelay` AS `t0_c40`, `t`.`nokeyboard` AS `t0_c41`, `t`.`alloweditaftercompletion` AS `t0_c42`, `SurveysGroups`.`gsid` AS `t1_c0`, `SurveysGroups`.`name` AS `t1_c1`, `SurveysGroups`.`title` AS `t1_c2`, `SurveysGroups`.`template` AS `t1_c3`, `SurveysGroups`.`description` AS `t1_c4`, `SurveysGroups`.`sortorder` AS `t1_c5`, `SurveysGroups`.`owner_id` AS `t1_c6`, `SurveysGroups`.`parent_id` AS `t1_c7`, `SurveysGroups`.`alwaysavailable` AS `t1_c8`, `SurveysGroups`.`created` AS `t1_c9`, `SurveysGroups`.`modified` AS `t1_c10`, `SurveysGroups`.`created_by` AS `t1_c11` FROM `lime_surveys_groupsettings` `t`  LEFT OUTER JOIN `lime_surveys_groups` `SurveysGroups` ON (`SurveysGroups`.`gsid`=`t`.`gsid`) WHERE (`t`.`gsid`=1)
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] User.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] SurveysGroupsettings.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_surveys_groupsettings` `t` WHERE `t`.`gsid`=0 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_questions`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_questions`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Question.findAll()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_groups`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_groups`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT `t`.`qid` AS `t0_c0`, `t`.`parent_qid` AS `t0_c1`, `t`.`sid` AS `t0_c2`, `t`.`gid` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`title` AS `t0_c5`, `t`.`preg` AS `t0_c6`, `t`.`other` AS `t0_c7`, `t`.`mandatory` AS `t0_c8`, `t`.`encrypted` AS `t0_c9`, `t`.`question_order` AS `t0_c10`, `t`.`scale_id` AS `t0_c11`, `t`.`same_default` AS `t0_c12`, `t`.`relevance` AS `t0_c13`, `t`.`question_theme_name` AS `t0_c14`, `t`.`modulename` AS `t0_c15`, `t`.`same_script` AS `t0_c16`, `group`.`gid` AS `t1_c0`, `group`.`sid` AS `t1_c1`, `group`.`group_order` AS `t1_c2`, `group`.`randomization_group` AS `t1_c3`, `group`.`grelevance` AS `t1_c4` FROM `lime_questions` `t`  LEFT OUTER JOIN `lime_groups` `group` ON (`t`.`gid`=`group`.`gid`) WHERE (t.sid=:sid) ORDER BY group_order,question_order
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW TABLES
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT a.qid, a.sqid, a.scale_id, a.specialtype, al10.defaultvalue FROM lime_defaultvalues as a  JOIN lime_defaultvalue_l10ns as al10 ON a.dvid = al10.dvid  JOIN lime_questions as b ON a.qid = b.qid  AND al10.language = 'de' AND b.same_default=0 AND b.sid = 925344
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT a.qid, a.sqid, a.scale_id, a.specialtype, al10.defaultvalue FROM lime_defaultvalues as a  JOIN lime_defaultvalue_l10ns as al10 ON a.dvid = al10.dvid  JOIN lime_questions as b ON a.qid = b.qid  AND al10.language = 'de' AND b.same_default=1 AND b.sid = 925344
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT g.*, q.*, gls.*, qls.* FROM `lime_groups` g JOIN lime_questions q on q.gid=g.gid  JOIN lime_group_l10ns gls on gls.gid=g.gid  JOIN lime_question_l10ns qls on qls.qid=q.qid  WHERE qls.language='de' and gls.language='de' AND g.sid=925344 AND q.parent_qid=0 ORDER BY group_order, question_order
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_question_themes`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_question_themes`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] QuestionTheme.findAllByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_question_themes` `t` WHERE `t`.`extends`=:yp0
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_survey_925344`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_survey_925344`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT count(*) FROM lime_survey_925344
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT count(*) FROM lime_survey_925344
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Question.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_questions` `t` WHERE `t`.`qid`=1 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] lazy loading Question.questionl10ns
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_question_l10ns`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_question_l10ns`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT `questionl10ns`.`id` AS `t1_c0`, `questionl10ns`.`qid` AS `t1_c1`, `questionl10ns`.`question` AS `t1_c2`, `questionl10ns`.`help` AS `t1_c3`, `questionl10ns`.`script` AS `t1_c4`, `questionl10ns`.`language` AS `t1_c5` FROM `lime_question_l10ns` `questionl10ns`  WHERE (`questionl10ns`.`qid`=:ypl0)
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Response_925344.findAll()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_survey_925344` `t`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation`
FROM `lime_source_message` `t1`, `lime_message` `t2`
WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_question_attributes`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_question_attributes`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Question.find()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_questions` `t` WHERE qid=:qid LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] QuestionTheme.findByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] QuestionTheme.findByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] lazy loading Question.survey
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT `survey`.`sid` AS `t1_c0`, `survey`.`owner_id` AS `t1_c1`, `survey`.`gsid` AS `t1_c2`, `survey`.`admin` AS `t1_c3`, `survey`.`active` AS `t1_c4`, `survey`.`expires` AS `t1_c5`, `survey`.`startdate` AS `t1_c6`, `survey`.`adminemail` AS `t1_c7`, `survey`.`anonymized` AS `t1_c8`, `survey`.`format` AS `t1_c9`, `survey`.`savetimings` AS `t1_c10`, `survey`.`template` AS `t1_c11`, `survey`.`language` AS `t1_c12`, `survey`.`additional_languages` AS `t1_c13`, `survey`.`datestamp` AS `t1_c14`, `survey`.`usecookie` AS `t1_c15`, `survey`.`allowregister` AS `t1_c16`, `survey`.`allowsave` AS `t1_c17`, `survey`.`autonumber_start` AS `t1_c18`, `survey`.`autoredirect` AS `t1_c19`, `survey`.`allowprev` AS `t1_c20`, `survey`.`printanswers` AS `t1_c21`, `survey`.`ipaddr` AS `t1_c22`, `survey`.`ipanonymize` AS `t1_c23`, `survey`.`refurl` AS `t1_c24`, `survey`.`datecreated` AS `t1_c25`, `survey`.`showsurveypolicynotice` AS `t1_c26`, `survey`.`publicstatistics` AS `t1_c27`, `survey`.`publicgraphs` AS `t1_c28`, `survey`.`listpublic` AS `t1_c29`, `survey`.`htmlemail` AS `t1_c30`, `survey`.`sendconfirmation` AS `t1_c31`, `survey`.`tokenanswerspersistence` AS `t1_c32`, `survey`.`assessments` AS `t1_c33`, `survey`.`usecaptcha` AS `t1_c34`, `survey`.`usetokens` AS `t1_c35`, `survey`.`bounce_email` AS `t1_c36`, `survey`.`attributedescriptions` AS `t1_c37`, `survey`.`emailresponseto` AS `t1_c38`, `survey`.`emailnotificationto` AS `t1_c39`, `survey`.`tokenlength` AS `t1_c40`, `survey`.`showxquestions` AS `t1_c41`, `survey`.`showgroupinfo` AS `t1_c42`, `survey`.`shownoanswer` AS `t1_c43`, `survey`.`showqnumcode` AS `t1_c44`, `survey`.`bouncetime` AS `t1_c45`, `survey`.`bounceprocessing` AS `t1_c46`, `survey`.`bounceaccounttype` AS `t1_c47`, `survey`.`bounceaccounthost` AS `t1_c48`, `survey`.`bounceaccountpass` AS `t1_c49`, `survey`.`bounceaccountencryption` AS `t1_c50`, `survey`.`bounceaccountuser` AS `t1_c51`, `survey`.`showwelcome` AS `t1_c52`, `survey`.`showprogress` AS `t1_c53`, `survey`.`questionindex` AS `t1_c54`, `survey`.`navigationdelay` AS `t1_c55`, `survey`.`nokeyboard` AS `t1_c56`, `survey`.`alloweditaftercompletion` AS `t1_c57`, `survey`.`googleanalyticsstyle` AS `t1_c58`, `survey`.`googleanalyticsapikey` AS `t1_c59`, `survey`.`tokenencryptionoptions` AS `t1_c60` FROM `lime_surveys` `survey`  WHERE (`survey`.`sid`=:ypl0)
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] User.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] SurveysGroupsettings.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT `t`.`gsid` AS `t0_c0`, `t`.`owner_id` AS `t0_c1`, `t`.`admin` AS `t0_c2`, `t`.`adminemail` AS `t0_c3`, `t`.`anonymized` AS `t0_c4`, `t`.`format` AS `t0_c5`, `t`.`savetimings` AS `t0_c6`, `t`.`template` AS `t0_c7`, `t`.`datestamp` AS `t0_c8`, `t`.`usecookie` AS `t0_c9`, `t`.`allowregister` AS `t0_c10`, `t`.`allowsave` AS `t0_c11`, `t`.`autonumber_start` AS `t0_c12`, `t`.`autoredirect` AS `t0_c13`, `t`.`allowprev` AS `t0_c14`, `t`.`printanswers` AS `t0_c15`, `t`.`ipaddr` AS `t0_c16`, `t`.`ipanonymize` AS `t0_c17`, `t`.`refurl` AS `t0_c18`, `t`.`showsurveypolicynotice` AS `t0_c19`, `t`.`publicstatistics` AS `t0_c20`, `t`.`publicgraphs` AS `t0_c21`, `t`.`listpublic` AS `t0_c22`, `t`.`htmlemail` AS `t0_c23`, `t`.`sendconfirmation` AS `t0_c24`, `t`.`tokenanswerspersistence` AS `t0_c25`, `t`.`assessments` AS `t0_c26`, `t`.`usecaptcha` AS `t0_c27`, `t`.`bounce_email` AS `t0_c28`, `t`.`attributedescriptions` AS `t0_c29`, `t`.`emailresponseto` AS `t0_c30`, `t`.`emailnotificationto` AS `t0_c31`, `t`.`tokenlength` AS `t0_c32`, `t`.`showxquestions` AS `t0_c33`, `t`.`showgroupinfo` AS `t0_c34`, `t`.`shownoanswer` AS `t0_c35`, `t`.`showqnumcode` AS `t0_c36`, `t`.`showwelcome` AS `t0_c37`, `t`.`showprogress` AS `t0_c38`, `t`.`questionindex` AS `t0_c39`, `t`.`navigationdelay` AS `t0_c40`, `t`.`nokeyboard` AS `t0_c41`, `t`.`alloweditaftercompletion` AS `t0_c42`, `SurveysGroups`.`gsid` AS `t1_c0`, `SurveysGroups`.`name` AS `t1_c1`, `SurveysGroups`.`title` AS `t1_c2`, `SurveysGroups`.`template` AS `t1_c3`, `SurveysGroups`.`description` AS `t1_c4`, `SurveysGroups`.`sortorder` AS `t1_c5`, `SurveysGroups`.`owner_id` AS `t1_c6`, `SurveysGroups`.`parent_id` AS `t1_c7`, `SurveysGroups`.`alwaysavailable` AS `t1_c8`, `SurveysGroups`.`created` AS `t1_c9`, `SurveysGroups`.`modified` AS `t1_c10`, `SurveysGroups`.`created_by` AS `t1_c11` FROM `lime_surveys_groupsettings` `t`  LEFT OUTER JOIN `lime_surveys_groups` `SurveysGroups` ON (`SurveysGroups`.`gsid`=`t`.`gsid`) WHERE (`t`.`gsid`=1)
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] User.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] SurveysGroupsettings.findByPk()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_surveys_groupsettings` `t` WHERE `t`.`gsid`=0 LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] QuestionAttribute.findAll()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid
2023/05/26 11:26:22 [trace] [system.CModule] Loading "log" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "ETwigViewRenderer" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "request" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "urlManager" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "cache" application component
2023/05/26 11:26:22 [trace] [application] Route "admin/remotecontrol passed without CSRF validation
2023/05/26 11:26:22 [trace] [system.CModule] Loading "session" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "db" application component
2023/05/26 11:26:22 [trace] [system.db.CDbConnection] Opening DB connection
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_settings_global`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_settings_global`
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] SettingGlobal.findAll()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_settings_global` `t`
2023/05/26 11:26:22 [trace] [system.CModule] Loading "assetManager" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "bootstrap" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "user" application component
2023/05/26 11:26:22 [trace] [system.CModule] Loading "messages" application component
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation`
FROM `lime_source_message` `t1`, `lime_message` `t2`
WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language
2023/05/26 11:26:22 [trace] [system.CModule] Loading "clientScript" application component
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_surveys`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_surveys`
2023/05/26 11:26:22 [trace] [system.CModule] Loading "pluginManager" application component
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] SettingGlobal.find()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_settings_global` `t` WHERE stg_name=:name LIMIT 1
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_plugins`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_plugins`
2023/05/26 11:26:22 [trace] [system.CModule] Loading "sodium" application component
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Plugin.findAllByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0 ORDER BY priority DESC
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Session.deleteAllByAttributes()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW FULL COLUMNS FROM `lime_sessions`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Querying SQL: SHOW CREATE TABLE `lime_sessions`
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Executing SQL: DELETE FROM `lime_sessions` WHERE `lime_sessions`.`id`=:yp0
2023/05/26 11:26:22 [trace] [system.db.ar.CActiveRecord] Session.deleteAll()
2023/05/26 11:26:22 [trace] [system.db.CDbCommand] Executing SQL: DELETE FROM `lime_sessions` WHERE expire < 1685093182