PHP notice

Undefined index:

/media/shnoulle/data/webdev/ls5/application/core/plugins/ComfortUpdateChecker/ComfortUpdateChecker.php(66)

54         $oEvent = $this->getEvent();
55 
56         //Register css and js script
57         $this->registerAssets();
58 
59         $update = (array)$this->getUpdate();
60 
61         if (true) {
62             //Default icon class
63             $iconClass = "";
64             $NotificationText = "V5 is out of support - " . gT("Upgrade now!");
65 
66             if ($update[key($update)]->security_update) {
67                 $NotificationText = "V5 is out of support - " . gT("Upgrade now!");
68             }
69             //Append cu-checker class to icon when animate option is true in plugin settings
70             if ($this->get('animate_icon', null, null, false)) {
71                 $iconClass = "cu-checker";
72             }
73 
74             //Display update notification only for superadmin user
75             if (Permission::model()->hasGlobalPermission('superadmin')) {
76                 $aMenuItemAdminOptions = [
77                     'isDivider' => false,
78                     'isSmallText' => false,

Stack Trace

#1
+
 /media/shnoulle/data/webdev/ls5/application/libraries/PluginManager/PluginManager.php(269): call_user_func(array(ComfortUpdateChecker, "beforeAdminMenuRender"))
264                 if (
265                     !$event->isStopped()
266                     && (empty($target) || in_array(get_class($subscription[0]), $target))
267                 ) {
268                     $subscription[0]->setEvent($event);
269                     call_user_func($subscription);
270                 }
271             }
272         }
273 
274         return $event;
#2
+
 /media/shnoulle/data/webdev/ls5/application/core/SurveyCommonAction.php(1159): LimeSurvey\PluginManager\PluginManager->dispatchEvent(PluginEvent)
1154      */
1155     protected function fetchExtraMenus(array $aData)
1156     {
1157         $event = new PluginEvent('beforeAdminMenuRender', $this);
1158         $event->set('data', $aData);
1159         $result = App()->getPluginManager()->dispatchEvent($event);
1160 
1161         $extraMenus = $result->get('extraMenus');
1162 
1163         if ($extraMenus === null) {
1164             $extraMenus = array();
#3
+
 /media/shnoulle/data/webdev/ls5/application/core/SurveyCommonAction.php(503): SurveyCommonAction->fetchExtraMenus(array("issuperadmin" => true, "showLastSurvey" => true, "surveyTitle" => " Database on Policy Instruments for the Environment (ID:717526)", "surveyUrl" => "/ls5/index.php?r=surveyAdministration/view/surveyid/717526", ...))
498             }
499 
500             $aData['sitename'] = Yii::app()->getConfig("sitename");
501 
502             // Fetch extra menus from plugins, e.g. last visited surveys
503             $aData['extraMenus'] = $this->fetchExtraMenus($aData);
504 
505             // Get notification menu
506             $surveyId = $aData['surveyid'] ?? null;
507             Yii::import('application.controllers.admin.NotificationController');
508             $aData['adminNotifications'] = NotificationController::getMenuWidget($surveyId, true /* show spinner */);
2024-06-07 08:47:04 nginx/1.22.1 Yii Framework/1.1.28
Profiling Summary Report (Time: 0.03511s, Memory: 6,196KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT * FROM `lime_plugin_settings` `t` WHERE `t`.`plugin_id`=:yp0 AND `t`.`model` IS NULL AND `t`.`model_id` IS NULL AND `t`.`key`=:yp1. Bound with :yp0='114', :yp1='storage_base') 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(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`, `correct_relation_defaultlanguage`.`surveyls_survey_id` AS `t1_c0`, `correct_relation_defaultlanguage`.`surveyls_language` AS `t1_c1`, `correct_relation_defaultlanguage`.`surveyls_title` AS `t1_c2`, `correct_relation_defaultlanguage`.`surveyls_description` AS `t1_c3`, `correct_relation_defaultlanguage`.`surveyls_welcometext` AS `t1_c4`, `correct_relation_defaultlanguage`.`surveyls_endtext` AS `t1_c5`, `correct_relation_defaultlanguage`.`surveyls_policy_notice` AS `t1_c6`, `correct_relation_defaultlanguage`.`surveyls_policy_error` AS `t1_c7`, `correct_relation_defaultlanguage`.`surveyls_policy_notice_label` AS `t1_c8`, `correct_relation_defaultlanguage`.`surveyls_url` AS `t1_c9`, `correct_relation_defaultlanguage`.`surveyls_urldescription` AS `t1_c10`, `correct_relation_defaultlanguage`.`surveyls_email_invite_subj` AS `t1_c11`, `correct_relation_defaultlanguage`.`surveyls_email_invite` AS `t1_c12`, `correct_relation_defaultlanguage`.`surveyls_email_remind_subj` AS `t1_c13`, `correct_relation_defaultlanguage`.`surveyls_email_remind` AS `t1_c14`, `correct_relation_defaultlanguage`.`surveyls_email_register_subj` AS `t1_c15`, `correct_relation_defaultlanguage`.`surveyls_email_register` AS `t1_c16`, `correct_relation_defaultlanguage`.`surveyls_email_confirm_subj` AS `t1_c17`, `correct_relation_defaultlanguage`.`surveyls_email_confirm` AS `t1_c18`, `correct_relation_defaultlanguage`.`surveyls_dateformat` AS `t1_c19`, `correct_relation_defaultlanguage`.`surveyls_attributecaptions` AS `t1_c20`, `correct_relation_defaultlanguage`.`surveyls_alias` AS `t1_c21`, `correct_relation_defaultlanguage`.`email_admin_notification_subj` AS `t1_c22`, `correct_relation_defaultlanguage`.`email_admin_notification` AS `t1_c23`, `correct_relation_defaultlanguage`.`email_admin_responses_subj` AS `t1_c24`, `correct_relation_defaultlanguage`.`email_admin_responses` AS `t1_c25`, `correct_relation_defaultlanguage`.`surveyls_numberformat` AS `t1_c26`, `correct_relation_defaultlanguage`.`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`, `owner`.`user_status` AS `t2_c19`, `surveygroup`.`gsid` AS `t3_c0`, `surveygroup`.`name` AS `t3_c1`, `surveygroup`.`title` AS `t3_c2`, `surveygroup`.`template` AS `t3_c3`, `surveygroup`.`description` AS `t3_c4`, `surveygroup`.`sortorder` AS `t3_c5`, `surveygroup`.`owner_id` AS `t3_c6`, `surveygroup`.`parent_id` AS `t3_c7`, `surveygroup`.`alwaysavailable` AS `t3_c8`, `surveygroup`.`created` AS `t3_c9`, `surveygroup`.`modified` AS `t3_c10`, `surveygroup`.`created_by` AS `t3_c11` FROM `lime_surveys` `t` LEFT OUTER JOIN `lime_surveys_languagesettings` `correct_relation_defaultlanguage` ON (`correct_relation_defaultlanguage`.`surveyls_language`=`t`.`language`) AND (`correct_relation_defaultlanguage`.`surveyls_survey_id`=`t`.`sid`) LEFT OUTER JOIN `lime_users` `owner` ON (`t`.`owner_id`=`owner`.`uid`) LEFT OUTER JOIN `lime_surveys_groups` `surveygroup` ON (`t`.`gsid`=`surveygroup`.`gsid`) ORDER BY t.datecreated desc LIMIT 10) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT * FROM `lime_plugin_settings` `t` WHERE `t`.`plugin_id`=:yp0 AND `t`.`model` IS NULL AND `t`.`model_id` IS NULL AND `t`.`key`=:yp1. Bound with :yp0='114', :yp1='force_saml_login') 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_users`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groupsettings`) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_settings_global`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW TABLES) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugin_settings`) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT * FROM `lime_plugin_settings` `t` WHERE `t`.`plugin_id`=:yp0 AND `t`.`model` IS NULL AND `t`.`model_id` IS NULL AND `t`.`key`=:yp1. Bound with :yp0='54', :yp1='dbVersion') 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT * FROM `lime_plugin_settings` `t` WHERE `t`.`plugin_id`=:yp0 AND `t`.`model` IS NULL AND `t`.`model_id` IS NULL AND `t`.`key`=:yp1. Bound with :yp0='89', :yp1='dbVersion') 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT * FROM `lime_plugin_settings` `t` WHERE `t`.`plugin_id`=:yp0 AND `t`.`model` IS NULL AND `t`.`model_id` IS NULL AND `t`.`key`=:yp1. Bound with :yp0='54', :yp1='multiAccessTime') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT * FROM `lime_plugin_settings` `t` WHERE `t`.`plugin_id`=:yp0 AND `t`.`model` IS NULL AND `t`.`model_id` IS NULL AND `t`.`key`=:yp1. Bound with :yp0='71', :yp1='dbVersion') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT * FROM `lime_plugin_settings` `t` WHERE `t`.`plugin_id`=:yp0 AND `t`.`model` IS NULL AND `t`.`model_id` IS NULL AND `t`.`key`=:yp1. Bound with :yp0='66', :yp1='dbversion') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0 ORDER BY priority DESC. Bound with :yp0=1) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_languagesettings`) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT count(*) FROM `lime_survey_528738` WHERE submitdate IS NULL) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT count(*) FROM `lime_survey_528738` WHERE submitdate IS NOT NULL) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_template_configuration`) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_templates`) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_notifications`) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_permissions`) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_groups`) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugins`) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groups`) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_boxes`) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT `t`.`template_name` AS `t0_c1`, `t`.`id` AS `t0_c0`, `template`.`id` AS `t1_c0`, `template`.`folder` AS `t1_c2`, `template`.`name` AS `t1_c1` FROM `lime_template_configuration` `t` LEFT OUTER JOIN `lime_templates` `template` ON (`template`.`name`=`t`.`template_name`) WHERE (sid IS NULL AND gsid IS NULL AND template.folder IS NOT NULL) ORDER BY `t`.`template_name`) 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_asset_version`) 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT COUNT(DISTINCT `t`.`sid`) FROM `lime_surveys` `t` LEFT OUTER JOIN `lime_surveys_languagesettings` `correct_relation_defaultlanguage` ON (`correct_relation_defaultlanguage`.`surveyls_language`=`t`.`language`) AND (`correct_relation_defaultlanguage`.`surveyls_survey_id`=`t`.`sid`) LEFT OUTER JOIN `lime_users` `owner` ON (`t`.`owner_id`=`owner`.`uid`) LEFT OUTER JOIN `lime_surveys_groups` `surveygroup` ON (`t`.`gsid`=`surveygroup`.`gsid`)) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(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)) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t`) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(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`=2)) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE (expires > :now OR expires IS NULL) AND (`t`.`uid`=1) LIMIT 1. Bound with :now='2024-06-07 08:47:04') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='vanilla' LIMIT 1) 2 0.00008 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='uppercase' LIMIT 1) 2 0.00008 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT `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` FROM `lime_surveys_languagesettings` `languagesettings` WHERE (`languagesettings`.`surveyls_survey_id`=:ypl0). Bound with :ypl0='717526') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1) 2 0.00008 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groups` `t` ORDER BY title ASC) 2 0.00007 0.00004 0.00003 0.00004
system.db.CDbCommand.query(SELECT `defaultlanguage`.`surveyls_survey_id` AS `t1_c0`, `defaultlanguage`.`surveyls_language` AS `t1_c1`, `defaultlanguage`.`surveyls_title` AS `t1_c2`, `defaultlanguage`.`surveyls_description` AS `t1_c3`, `defaultlanguage`.`surveyls_welcometext` AS `t1_c4`, `defaultlanguage`.`surveyls_endtext` AS `t1_c5`, `defaultlanguage`.`surveyls_policy_notice` AS `t1_c6`, `defaultlanguage`.`surveyls_policy_error` AS `t1_c7`, `defaultlanguage`.`surveyls_policy_notice_label` AS `t1_c8`, `defaultlanguage`.`surveyls_url` AS `t1_c9`, `defaultlanguage`.`surveyls_urldescription` AS `t1_c10`, `defaultlanguage`.`surveyls_email_invite_subj` AS `t1_c11`, `defaultlanguage`.`surveyls_email_invite` AS `t1_c12`, `defaultlanguage`.`surveyls_email_remind_subj` AS `t1_c13`, `defaultlanguage`.`surveyls_email_remind` AS `t1_c14`, `defaultlanguage`.`surveyls_email_register_subj` AS `t1_c15`, `defaultlanguage`.`surveyls_email_register` AS `t1_c16`, `defaultlanguage`.`surveyls_email_confirm_subj` AS `t1_c17`, `defaultlanguage`.`surveyls_email_confirm` AS `t1_c18`, `defaultlanguage`.`surveyls_dateformat` AS `t1_c19`, `defaultlanguage`.`surveyls_attributecaptions` AS `t1_c20`, `defaultlanguage`.`surveyls_alias` AS `t1_c21`, `defaultlanguage`.`email_admin_notification_subj` AS `t1_c22`, `defaultlanguage`.`email_admin_notification` AS `t1_c23`, `defaultlanguage`.`email_admin_responses_subj` AS `t1_c24`, `defaultlanguage`.`email_admin_responses` AS `t1_c25`, `defaultlanguage`.`surveyls_numberformat` AS `t1_c26`, `defaultlanguage`.`attachments` AS `t1_c27` FROM `lime_surveys_languagesettings` `defaultlanguage` WHERE (`defaultlanguage`.`surveyls_language`=:ypl0) AND (`defaultlanguage`.`surveyls_survey_id`=:ypl1). Bound with :ypl0='en', :ypl1='183746') 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/media/shnoulle/data/webdev/ls5/vendor/yiisoft/yii/framework/zii/widgets/assets') 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE name = :name LIMIT 1. Bound with :name='renderMessage') 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=717526 LIMIT 1) 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT `defaultlanguage`.`surveyls_survey_id` AS `t1_c0`, `defaultlanguage`.`surveyls_language` AS `t1_c1`, `defaultlanguage`.`surveyls_title` AS `t1_c2`, `defaultlanguage`.`surveyls_description` AS `t1_c3`, `defaultlanguage`.`surveyls_welcometext` AS `t1_c4`, `defaultlanguage`.`surveyls_endtext` AS `t1_c5`, `defaultlanguage`.`surveyls_policy_notice` AS `t1_c6`, `defaultlanguage`.`surveyls_policy_error` AS `t1_c7`, `defaultlanguage`.`surveyls_policy_notice_label` AS `t1_c8`, `defaultlanguage`.`surveyls_url` AS `t1_c9`, `defaultlanguage`.`surveyls_urldescription` AS `t1_c10`, `defaultlanguage`.`surveyls_email_invite_subj` AS `t1_c11`, `defaultlanguage`.`surveyls_email_invite` AS `t1_c12`, `defaultlanguage`.`surveyls_email_remind_subj` AS `t1_c13`, `defaultlanguage`.`surveyls_email_remind` AS `t1_c14`, `defaultlanguage`.`surveyls_email_register_subj` AS `t1_c15`, `defaultlanguage`.`surveyls_email_register` AS `t1_c16`, `defaultlanguage`.`surveyls_email_confirm_subj` AS `t1_c17`, `defaultlanguage`.`surveyls_email_confirm` AS `t1_c18`, `defaultlanguage`.`surveyls_dateformat` AS `t1_c19`, `defaultlanguage`.`surveyls_attributecaptions` AS `t1_c20`, `defaultlanguage`.`surveyls_alias` AS `t1_c21`, `defaultlanguage`.`email_admin_notification_subj` AS `t1_c22`, `defaultlanguage`.`email_admin_notification` AS `t1_c23`, `defaultlanguage`.`email_admin_responses_subj` AS `t1_c24`, `defaultlanguage`.`email_admin_responses` AS `t1_c25`, `defaultlanguage`.`surveyls_numberformat` AS `t1_c26`, `defaultlanguage`.`attachments` AS `t1_c27` FROM `lime_surveys_languagesettings` `defaultlanguage` WHERE (`defaultlanguage`.`surveyls_language`=:ypl0) AND (`defaultlanguage`.`surveyls_survey_id`=:ypl1). Bound with :ypl0='en', :ypl1='559559') 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT `defaultlanguage`.`surveyls_survey_id` AS `t1_c0`, `defaultlanguage`.`surveyls_language` AS `t1_c1`, `defaultlanguage`.`surveyls_title` AS `t1_c2`, `defaultlanguage`.`surveyls_description` AS `t1_c3`, `defaultlanguage`.`surveyls_welcometext` AS `t1_c4`, `defaultlanguage`.`surveyls_endtext` AS `t1_c5`, `defaultlanguage`.`surveyls_policy_notice` AS `t1_c6`, `defaultlanguage`.`surveyls_policy_error` AS `t1_c7`, `defaultlanguage`.`surveyls_policy_notice_label` AS `t1_c8`, `defaultlanguage`.`surveyls_url` AS `t1_c9`, `defaultlanguage`.`surveyls_urldescription` AS `t1_c10`, `defaultlanguage`.`surveyls_email_invite_subj` AS `t1_c11`, `defaultlanguage`.`surveyls_email_invite` AS `t1_c12`, `defaultlanguage`.`surveyls_email_remind_subj` AS `t1_c13`, `defaultlanguage`.`surveyls_email_remind` AS `t1_c14`, `defaultlanguage`.`surveyls_email_register_subj` AS `t1_c15`, `defaultlanguage`.`surveyls_email_register` AS `t1_c16`, `defaultlanguage`.`surveyls_email_confirm_subj` AS `t1_c17`, `defaultlanguage`.`surveyls_email_confirm` AS `t1_c18`, `defaultlanguage`.`surveyls_dateformat` AS `t1_c19`, `defaultlanguage`.`surveyls_attributecaptions` AS `t1_c20`, `defaultlanguage`.`surveyls_alias` AS `t1_c21`, `defaultlanguage`.`email_admin_notification_subj` AS `t1_c22`, `defaultlanguage`.`email_admin_notification` AS `t1_c23`, `defaultlanguage`.`email_admin_responses_subj` AS `t1_c24`, `defaultlanguage`.`email_admin_responses` AS `t1_c25`, `defaultlanguage`.`surveyls_numberformat` AS `t1_c26`, `defaultlanguage`.`attachments` AS `t1_c27` FROM `lime_surveys_languagesettings` `defaultlanguage` WHERE (`defaultlanguage`.`surveyls_language`=:ypl0) AND (`defaultlanguage`.`surveyls_survey_id`=:ypl1). Bound with :ypl0='fr', :ypl1='616743') 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='extends_vanilla' LIMIT 1) 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=183746 LIMIT 1) 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT `defaultlanguage`.`surveyls_survey_id` AS `t1_c0`, `defaultlanguage`.`surveyls_language` AS `t1_c1`, `defaultlanguage`.`surveyls_title` AS `t1_c2`, `defaultlanguage`.`surveyls_description` AS `t1_c3`, `defaultlanguage`.`surveyls_welcometext` AS `t1_c4`, `defaultlanguage`.`surveyls_endtext` AS `t1_c5`, `defaultlanguage`.`surveyls_policy_notice` AS `t1_c6`, `defaultlanguage`.`surveyls_policy_error` AS `t1_c7`, `defaultlanguage`.`surveyls_policy_notice_label` AS `t1_c8`, `defaultlanguage`.`surveyls_url` AS `t1_c9`, `defaultlanguage`.`surveyls_urldescription` AS `t1_c10`, `defaultlanguage`.`surveyls_email_invite_subj` AS `t1_c11`, `defaultlanguage`.`surveyls_email_invite` AS `t1_c12`, `defaultlanguage`.`surveyls_email_remind_subj` AS `t1_c13`, `defaultlanguage`.`surveyls_email_remind` AS `t1_c14`, `defaultlanguage`.`surveyls_email_register_subj` AS `t1_c15`, `defaultlanguage`.`surveyls_email_register` AS `t1_c16`, `defaultlanguage`.`surveyls_email_confirm_subj` AS `t1_c17`, `defaultlanguage`.`surveyls_email_confirm` AS `t1_c18`, `defaultlanguage`.`surveyls_dateformat` AS `t1_c19`, `defaultlanguage`.`surveyls_attributecaptions` AS `t1_c20`, `defaultlanguage`.`surveyls_alias` AS `t1_c21`, `defaultlanguage`.`email_admin_notification_subj` AS `t1_c22`, `defaultlanguage`.`email_admin_notification` AS `t1_c23`, `defaultlanguage`.`email_admin_responses_subj` AS `t1_c24`, `defaultlanguage`.`email_admin_responses` AS `t1_c25`, `defaultlanguage`.`surveyls_numberformat` AS `t1_c26`, `defaultlanguage`.`attachments` AS `t1_c27` FROM `lime_surveys_languagesettings` `defaultlanguage` WHERE (`defaultlanguage`.`surveyls_language`=:ypl0) AND (`defaultlanguage`.`surveyls_survey_id`=:ypl1). Bound with :ypl0='de', :ypl1='893992') 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_surveys` `t` WHERE active = 'Y') 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(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. Bound with :category='', :language='en') 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT `defaultlanguage`.`surveyls_survey_id` AS `t1_c0`, `defaultlanguage`.`surveyls_language` AS `t1_c1`, `defaultlanguage`.`surveyls_title` AS `t1_c2`, `defaultlanguage`.`surveyls_description` AS `t1_c3`, `defaultlanguage`.`surveyls_welcometext` AS `t1_c4`, `defaultlanguage`.`surveyls_endtext` AS `t1_c5`, `defaultlanguage`.`surveyls_policy_notice` AS `t1_c6`, `defaultlanguage`.`surveyls_policy_error` AS `t1_c7`, `defaultlanguage`.`surveyls_policy_notice_label` AS `t1_c8`, `defaultlanguage`.`surveyls_url` AS `t1_c9`, `defaultlanguage`.`surveyls_urldescription` AS `t1_c10`, `defaultlanguage`.`surveyls_email_invite_subj` AS `t1_c11`, `defaultlanguage`.`surveyls_email_invite` AS `t1_c12`, `defaultlanguage`.`surveyls_email_remind_subj` AS `t1_c13`, `defaultlanguage`.`surveyls_email_remind` AS `t1_c14`, `defaultlanguage`.`surveyls_email_register_subj` AS `t1_c15`, `defaultlanguage`.`surveyls_email_register` AS `t1_c16`, `defaultlanguage`.`surveyls_email_confirm_subj` AS `t1_c17`, `defaultlanguage`.`surveyls_email_confirm` AS `t1_c18`, `defaultlanguage`.`surveyls_dateformat` AS `t1_c19`, `defaultlanguage`.`surveyls_attributecaptions` AS `t1_c20`, `defaultlanguage`.`surveyls_alias` AS `t1_c21`, `defaultlanguage`.`email_admin_notification_subj` AS `t1_c22`, `defaultlanguage`.`email_admin_notification` AS `t1_c23`, `defaultlanguage`.`email_admin_responses_subj` AS `t1_c24`, `defaultlanguage`.`email_admin_responses` AS `t1_c25`, `defaultlanguage`.`surveyls_numberformat` AS `t1_c26`, `defaultlanguage`.`attachments` AS `t1_c27` FROM `lime_surveys_languagesettings` `defaultlanguage` WHERE (`defaultlanguage`.`surveyls_language`=:ypl0) AND (`defaultlanguage`.`surveyls_survey_id`=:ypl1). Bound with :ypl0='fr', :ypl1='859885') 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT `defaultlanguage`.`surveyls_survey_id` AS `t1_c0`, `defaultlanguage`.`surveyls_language` AS `t1_c1`, `defaultlanguage`.`surveyls_title` AS `t1_c2`, `defaultlanguage`.`surveyls_description` AS `t1_c3`, `defaultlanguage`.`surveyls_welcometext` AS `t1_c4`, `defaultlanguage`.`surveyls_endtext` AS `t1_c5`, `defaultlanguage`.`surveyls_policy_notice` AS `t1_c6`, `defaultlanguage`.`surveyls_policy_error` AS `t1_c7`, `defaultlanguage`.`surveyls_policy_notice_label` AS `t1_c8`, `defaultlanguage`.`surveyls_url` AS `t1_c9`, `defaultlanguage`.`surveyls_urldescription` AS `t1_c10`, `defaultlanguage`.`surveyls_email_invite_subj` AS `t1_c11`, `defaultlanguage`.`surveyls_email_invite` AS `t1_c12`, `defaultlanguage`.`surveyls_email_remind_subj` AS `t1_c13`, `defaultlanguage`.`surveyls_email_remind` AS `t1_c14`, `defaultlanguage`.`surveyls_email_register_subj` AS `t1_c15`, `defaultlanguage`.`surveyls_email_register` AS `t1_c16`, `defaultlanguage`.`surveyls_email_confirm_subj` AS `t1_c17`, `defaultlanguage`.`surveyls_email_confirm` AS `t1_c18`, `defaultlanguage`.`surveyls_dateformat` AS `t1_c19`, `defaultlanguage`.`surveyls_attributecaptions` AS `t1_c20`, `defaultlanguage`.`surveyls_alias` AS `t1_c21`, `defaultlanguage`.`email_admin_notification_subj` AS `t1_c22`, `defaultlanguage`.`email_admin_notification` AS `t1_c23`, `defaultlanguage`.`email_admin_responses_subj` AS `t1_c24`, `defaultlanguage`.`email_admin_responses` AS `t1_c25`, `defaultlanguage`.`surveyls_numberformat` AS `t1_c26`, `defaultlanguage`.`attachments` AS `t1_c27` FROM `lime_surveys_languagesettings` `defaultlanguage` WHERE (`defaultlanguage`.`surveyls_language`=:ypl0) AND (`defaultlanguage`.`surveyls_survey_id`=:ypl1). Bound with :ypl0='en', :ypl1='899143') 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT `defaultlanguage`.`surveyls_survey_id` AS `t1_c0`, `defaultlanguage`.`surveyls_language` AS `t1_c1`, `defaultlanguage`.`surveyls_title` AS `t1_c2`, `defaultlanguage`.`surveyls_description` AS `t1_c3`, `defaultlanguage`.`surveyls_welcometext` AS `t1_c4`, `defaultlanguage`.`surveyls_endtext` AS `t1_c5`, `defaultlanguage`.`surveyls_policy_notice` AS `t1_c6`, `defaultlanguage`.`surveyls_policy_error` AS `t1_c7`, `defaultlanguage`.`surveyls_policy_notice_label` AS `t1_c8`, `defaultlanguage`.`surveyls_url` AS `t1_c9`, `defaultlanguage`.`surveyls_urldescription` AS `t1_c10`, `defaultlanguage`.`surveyls_email_invite_subj` AS `t1_c11`, `defaultlanguage`.`surveyls_email_invite` AS `t1_c12`, `defaultlanguage`.`surveyls_email_remind_subj` AS `t1_c13`, `defaultlanguage`.`surveyls_email_remind` AS `t1_c14`, `defaultlanguage`.`surveyls_email_register_subj` AS `t1_c15`, `defaultlanguage`.`surveyls_email_register` AS `t1_c16`, `defaultlanguage`.`surveyls_email_confirm_subj` AS `t1_c17`, `defaultlanguage`.`surveyls_email_confirm` AS `t1_c18`, `defaultlanguage`.`surveyls_dateformat` AS `t1_c19`, `defaultlanguage`.`surveyls_attributecaptions` AS `t1_c20`, `defaultlanguage`.`surveyls_alias` AS `t1_c21`, `defaultlanguage`.`email_admin_notification_subj` AS `t1_c22`, `defaultlanguage`.`email_admin_notification` AS `t1_c23`, `defaultlanguage`.`email_admin_responses_subj` AS `t1_c24`, `defaultlanguage`.`email_admin_responses` AS `t1_c25`, `defaultlanguage`.`surveyls_numberformat` AS `t1_c26`, `defaultlanguage`.`attachments` AS `t1_c27` FROM `lime_surveys_languagesettings` `defaultlanguage` WHERE (`defaultlanguage`.`surveyls_language`=:ypl0) AND (`defaultlanguage`.`surveyls_survey_id`=:ypl1). Bound with :ypl0='en', :ypl1='528738') 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT `defaultlanguage`.`surveyls_survey_id` AS `t1_c0`, `defaultlanguage`.`surveyls_language` AS `t1_c1`, `defaultlanguage`.`surveyls_title` AS `t1_c2`, `defaultlanguage`.`surveyls_description` AS `t1_c3`, `defaultlanguage`.`surveyls_welcometext` AS `t1_c4`, `defaultlanguage`.`surveyls_endtext` AS `t1_c5`, `defaultlanguage`.`surveyls_policy_notice` AS `t1_c6`, `defaultlanguage`.`surveyls_policy_error` AS `t1_c7`, `defaultlanguage`.`surveyls_policy_notice_label` AS `t1_c8`, `defaultlanguage`.`surveyls_url` AS `t1_c9`, `defaultlanguage`.`surveyls_urldescription` AS `t1_c10`, `defaultlanguage`.`surveyls_email_invite_subj` AS `t1_c11`, `defaultlanguage`.`surveyls_email_invite` AS `t1_c12`, `defaultlanguage`.`surveyls_email_remind_subj` AS `t1_c13`, `defaultlanguage`.`surveyls_email_remind` AS `t1_c14`, `defaultlanguage`.`surveyls_email_register_subj` AS `t1_c15`, `defaultlanguage`.`surveyls_email_register` AS `t1_c16`, `defaultlanguage`.`surveyls_email_confirm_subj` AS `t1_c17`, `defaultlanguage`.`surveyls_email_confirm` AS `t1_c18`, `defaultlanguage`.`surveyls_dateformat` AS `t1_c19`, `defaultlanguage`.`surveyls_attributecaptions` AS `t1_c20`, `defaultlanguage`.`surveyls_alias` AS `t1_c21`, `defaultlanguage`.`email_admin_notification_subj` AS `t1_c22`, `defaultlanguage`.`email_admin_notification` AS `t1_c23`, `defaultlanguage`.`email_admin_responses_subj` AS `t1_c24`, `defaultlanguage`.`email_admin_responses` AS `t1_c25`, `defaultlanguage`.`surveyls_numberformat` AS `t1_c26`, `defaultlanguage`.`attachments` AS `t1_c27` FROM `lime_surveys_languagesettings` `defaultlanguage` WHERE (`defaultlanguage`.`surveyls_language`=:ypl0) AND (`defaultlanguage`.`surveyls_survey_id`=:ypl1). Bound with :ypl0='en', :ypl1='684739') 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT `defaultlanguage`.`surveyls_survey_id` AS `t1_c0`, `defaultlanguage`.`surveyls_language` AS `t1_c1`, `defaultlanguage`.`surveyls_title` AS `t1_c2`, `defaultlanguage`.`surveyls_description` AS `t1_c3`, `defaultlanguage`.`surveyls_welcometext` AS `t1_c4`, `defaultlanguage`.`surveyls_endtext` AS `t1_c5`, `defaultlanguage`.`surveyls_policy_notice` AS `t1_c6`, `defaultlanguage`.`surveyls_policy_error` AS `t1_c7`, `defaultlanguage`.`surveyls_policy_notice_label` AS `t1_c8`, `defaultlanguage`.`surveyls_url` AS `t1_c9`, `defaultlanguage`.`surveyls_urldescription` AS `t1_c10`, `defaultlanguage`.`surveyls_email_invite_subj` AS `t1_c11`, `defaultlanguage`.`surveyls_email_invite` AS `t1_c12`, `defaultlanguage`.`surveyls_email_remind_subj` AS `t1_c13`, `defaultlanguage`.`surveyls_email_remind` AS `t1_c14`, `defaultlanguage`.`surveyls_email_register_subj` AS `t1_c15`, `defaultlanguage`.`surveyls_email_register` AS `t1_c16`, `defaultlanguage`.`surveyls_email_confirm_subj` AS `t1_c17`, `defaultlanguage`.`surveyls_email_confirm` AS `t1_c18`, `defaultlanguage`.`surveyls_dateformat` AS `t1_c19`, `defaultlanguage`.`surveyls_attributecaptions` AS `t1_c20`, `defaultlanguage`.`surveyls_alias` AS `t1_c21`, `defaultlanguage`.`email_admin_notification_subj` AS `t1_c22`, `defaultlanguage`.`email_admin_notification` AS `t1_c23`, `defaultlanguage`.`email_admin_responses_subj` AS `t1_c24`, `defaultlanguage`.`email_admin_responses` AS `t1_c25`, `defaultlanguage`.`surveyls_numberformat` AS `t1_c26`, `defaultlanguage`.`attachments` AS `t1_c27` FROM `lime_surveys_languagesettings` `defaultlanguage` WHERE (`defaultlanguage`.`surveyls_language`=:ypl0) AND (`defaultlanguage`.`surveyls_survey_id`=:ypl1). Bound with :ypl0='en', :ypl1='563179') 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=616743 LIMIT 1) 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT `defaultlanguage`.`surveyls_survey_id` AS `t1_c0`, `defaultlanguage`.`surveyls_language` AS `t1_c1`, `defaultlanguage`.`surveyls_title` AS `t1_c2`, `defaultlanguage`.`surveyls_description` AS `t1_c3`, `defaultlanguage`.`surveyls_welcometext` AS `t1_c4`, `defaultlanguage`.`surveyls_endtext` AS `t1_c5`, `defaultlanguage`.`surveyls_policy_notice` AS `t1_c6`, `defaultlanguage`.`surveyls_policy_error` AS `t1_c7`, `defaultlanguage`.`surveyls_policy_notice_label` AS `t1_c8`, `defaultlanguage`.`surveyls_url` AS `t1_c9`, `defaultlanguage`.`surveyls_urldescription` AS `t1_c10`, `defaultlanguage`.`surveyls_email_invite_subj` AS `t1_c11`, `defaultlanguage`.`surveyls_email_invite` AS `t1_c12`, `defaultlanguage`.`surveyls_email_remind_subj` AS `t1_c13`, `defaultlanguage`.`surveyls_email_remind` AS `t1_c14`, `defaultlanguage`.`surveyls_email_register_subj` AS `t1_c15`, `defaultlanguage`.`surveyls_email_register` AS `t1_c16`, `defaultlanguage`.`surveyls_email_confirm_subj` AS `t1_c17`, `defaultlanguage`.`surveyls_email_confirm` AS `t1_c18`, `defaultlanguage`.`surveyls_dateformat` AS `t1_c19`, `defaultlanguage`.`surveyls_attributecaptions` AS `t1_c20`, `defaultlanguage`.`surveyls_alias` AS `t1_c21`, `defaultlanguage`.`email_admin_notification_subj` AS `t1_c22`, `defaultlanguage`.`email_admin_notification` AS `t1_c23`, `defaultlanguage`.`email_admin_responses_subj` AS `t1_c24`, `defaultlanguage`.`email_admin_responses` AS `t1_c25`, `defaultlanguage`.`surveyls_numberformat` AS `t1_c26`, `defaultlanguage`.`attachments` AS `t1_c27` FROM `lime_surveys_languagesettings` `defaultlanguage` WHERE (`defaultlanguage`.`surveyls_language`=:ypl0) AND (`defaultlanguage`.`surveyls_survey_id`=:ypl1). Bound with :ypl0='en', :ypl1='336187') 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_permissions` `t` WHERE `t`.`entity_id`=:yp0 AND `t`.`entity`=:yp1 AND `t`.`uid`=:yp2 AND `t`.`permission`=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=1, :yp3='superadmin') 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=563179 LIMIT 1) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='skelvanilla' LIMIT 1) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `lime_notifications` `t` WHERE `t`.`hash`=:yp0 LIMIT 1. Bound with :yp0='72d109bee95d1381831c7f2e8eade340a523f9702f5ec2c7cc2d25726bec3e9a') 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=336187 LIMIT 1) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=684739 LIMIT 1) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.execute(UPDATE `lime_notifications` SET `id`=:yp0, `entity`=:yp1, `entity_id`=:yp2, `title`=:yp3, `message`=:yp4, `status`=:yp5, `importance`=:yp6, `display_class`=:yp7, `hash`=:yp8, `created`=:yp9, `first_read`=:yp10 WHERE `lime_notifications`.`id`=52. Bound with :yp0=52, :yp1='user', :yp2=1, :yp3='SSL not enforced', :yp4='<span class="fa fa-exclamation-circle text-warning"></span>&nbsp;Warning: Please enforce SSL encrpytion in Global settings/Security after SSL is properly configured for your webserver.', :yp5='new', :yp6=1, :yp7='default', :yp8='72d109bee95d1381831c7f2e8eade340a523f9702f5ec2c7cc2d25726bec3e9a', :yp9='2024-04-02 16:32:01', :yp10='2024-04-02 16:32:03') 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `lime_boxes` `t` ORDER BY position ASC) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_surveys` `t`) 2 0.00005 0.00002 0.00002 0.00003
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=559559 LIMIT 1) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys`) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=893992 LIMIT 1) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion') 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=899143 LIMIT 1) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=528738 LIMIT 1) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=859885 LIMIT 1) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_groups` `t` WHERE `t`.`sid`=:yp0. Bound with :yp0='183746') 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_settings_global`) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE name = :name LIMIT 1. Bound with :name='LimeSAML') 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groups` `t`) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groupsettings` `t` WHERE `t`.`gsid`=0 LIMIT 1) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugin_settings`) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT count(*) FROM `lime_survey_899143` WHERE submitdate IS NULL) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/media/shnoulle/data/webdev/ls5/application/extensions/admin/survey/ListSurveysWidget/assets/reload.js') 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/media/shnoulle/data/webdev/ls5/application/extensions/LimeScript/assets/script.js') 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_groups` `t` WHERE `t`.`sid`=:yp0. Bound with :yp0='893992') 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groupsettings`) 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT count(*) FROM `lime_survey_336187` WHERE submitdate IS NULL) 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_languagesettings`) 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_users`) 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_groups` `t` WHERE `t`.`sid`=:yp0. Bound with :yp0='563179') 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT count(*) FROM `lime_survey_684739` WHERE submitdate IS NULL) 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT * FROM `lime_boxes` `t` WHERE position=:positionId LIMIT 1. Bound with :positionId='1') 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT * FROM `lime_boxes` `t` WHERE position=:positionId LIMIT 1. Bound with :positionId='2') 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_groups` `t` WHERE `t`.`sid`=:yp0. Bound with :yp0='559559') 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT count(*) FROM `lime_survey_616743` WHERE submitdate IS NULL) 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/media/shnoulle/data/webdev/ls5/application/extensions/FlashMessage/assets') 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_groups` `t` WHERE `t`.`sid`=:yp0. Bound with :yp0='859885') 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_notifications`) 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_templates`) 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT count(*) FROM `lime_survey_899143` WHERE submitdate IS NOT NULL) 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_template_configuration`) 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/media/shnoulle/data/webdev/ls5/application/core/plugins/ComfortUpdateChecker/assets') 1 0.00003 0.00003 0.00003 0.00003
system.db.CDbCommand.query(SELECT * FROM `lime_boxes` `t` WHERE position=:positionId LIMIT 1. Bound with :positionId='6') 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SELECT * FROM `lime_boxes` `t` WHERE position=:positionId LIMIT 1. Bound with :positionId='3') 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_permissions`) 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groups`) 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_boxes`) 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_groups`) 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugins`) 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SELECT * FROM `lime_boxes` `t` WHERE position=:positionId LIMIT 1. Bound with :positionId='5') 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SELECT * FROM `lime_boxes` `t` WHERE position=:positionId LIMIT 1. Bound with :positionId='4') 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SELECT count(*) FROM `lime_survey_336187` WHERE submitdate IS NOT NULL) 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SELECT count(*) FROM `lime_survey_684739` WHERE submitdate IS NOT NULL) 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SELECT count(*) FROM `lime_survey_616743` WHERE submitdate IS NOT NULL) 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_asset_version`) 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SELECT count(*) FROM `lime_survey_528738`) 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SELECT count(*) FROM `lime_survey_899143`) 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SELECT count(*) FROM `lime_survey_336187`) 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SELECT count(*) FROM `lime_survey_616743`) 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SELECT count(*) FROM `lime_survey_684739`) 1 0.00002 0.00002 0.00002 0.00002
system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_users` `t`) 1 0.00001 0.00001 0.00001 0.00001