TypeError

fwrite(): Argument #1 ($stream) must be of type resource, bool given

application/helpers/admin/export/CsvWriter.php(56)

44     protected function outputRecord($headers, $values, FormattingOptions $oOptions, $fieldNames = [])
45     {
46         $sRecord = '';
47         if (!empty($oOptions->csvFieldSeparator)) {
48             $this->separator = $oOptions->csvFieldSeparator;
49         }
50         if (!$this->hasOutputHeader) {
51             if ($oOptions->output == 'display') {
52                 header("Content-Disposition: attachment; filename=" . $this->csvFilename);
53                 header("Content-type: text/comma-separated-values; charset=UTF-8");
54                 echo chr(239) . chr(187) . chr(191);
55             } else {
56                 fwrite($this->file, chr(239) . chr(187) . chr(191)); // Write UTF-8 Byte Order Mark (BOM)
57             }
58 
59             // If we don't want headers in our csv, for example in exports like r/spss etc. we suppress the header by setting this switch in the init
60             if ($this->doHeaders === true) {
61                 $index = 0;
62                 foreach ($headers as $header) {
63                     $headers[$index] = $this->csvEscape($header);
64                     $index++;
65                 }
66                 //Output the header...once and only once.
67                 $sRecord .= implode($this->separator, $headers) . "\r\n";
68             }

Stack Trace

#0
+
–
 application/helpers/admin/export/CsvWriter.php(56): fwrite()
51             if ($oOptions->output == 'display') {
52                 header("Content-Disposition: attachment; filename=" . $this->csvFilename);
53                 header("Content-type: text/comma-separated-values; charset=UTF-8");
54                 echo chr(239) . chr(187) . chr(191);
55             } else {
56                 fwrite($this->file, chr(239) . chr(187) . chr(191)); // Write UTF-8 Byte Order Mark (BOM)
57             }
58 
59             // If we don't want headers in our csv, for example in exports like r/spss etc. we suppress the header by setting this switch in the init
60             if ($this->doHeaders === true) {
61                 $index = 0;
#1
+
–
 application/helpers/admin/export/Writer.php(341): CsvWriter->outputRecord()
336                 }
337             }
338             if ($oOptions->output == 'display') {
339                 $this->outputRecord($headers, $elementArray, $oOptions, $fieldNames);
340             } else {
341                 $sFile .= $this->outputRecord($headers, $elementArray, $oOptions, $fieldNames);
342             }
343         }
344         return $sFile;
345     }
346 
#2
+
–
 application/helpers/admin/exportresults_helper.php(119): Writer->write()
114             $offset = $i * $maxRows;
115             $responsesQuery = $surveyDao->loadSurveyResults($survey, $oOptions->responseMinRecord, $oOptions->responseMaxRecord, $sFilter, $oOptions->responseCompletionState, $oOptions->selectedColumns, $oOptions->aResponses);
116             $responsesQuery->offset($offset);
117             $responsesQuery->limit($maxRows);
118             $survey->responses = $responsesQuery->query();
119             $writer->write($survey, $sLanguageCode, $oOptions, true);
120         }
121         $result = $writer->close();
122 
123         // Close resultset if needed
124         if ($survey->responses instanceof CDbDataReader) {
2026-09-30 06:09:08 LiteSpeed Yii Framework/1.1.32
Profilēšanas kopsavilkums (Laiks: 0.18062s, Atmiņa: 17,163KB)
Procedūra Izsaukumu skaits Kopējais (s) Vidējais (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys`) 1 0.00251 0.00251 0.00251 0.00251
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groupsettings`) 1 0.00250 0.00250 0.00250 0.00250
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys`) 1 0.00196 0.00196 0.00196 0.00196
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.00166 0.00166 0.00166 0.00166
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugins`) 1 0.00159 0.00159 0.00159 0.00159
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugins`) 1 0.00058 0.00058 0.00058 0.00058
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_settings_user`) 1 0.00052 0.00052 0.00052 0.00052
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t`) 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion') 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0 ORDER BY priority DESC. Bound with :yp0=1) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_settings_user`) 1 0.00197 0.00197 0.00197 0.00197
system.db.CDbCommand.query(SELECT * FROM `lime_settings_user` `t` WHERE (((uid=:uid) AND (stg_name=:stg_name)) AND (entity IS NULL)) AND (entity_id IS NULL) LIMIT 1. Bound with :uid=NULL, :stg_name='editorEnabled') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=755261 LIMIT 1) 1 0.00050 0.00050 0.00050 0.00050
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_users`) 1 0.00205 0.00205 0.00205 0.00205
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_settings_global`) 1 0.00176 0.00176 0.00176 0.00176
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_settings_global`) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groups`) 1 0.00183 0.00183 0.00183 0.00183
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_permissions`) 1 0.00182 0.00182 0.00182 0.00182
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groupsettings`) 1 0.00138 0.00138 0.00138 0.00138
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_users`) 1 0.00088 0.00088 0.00088 0.00088
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groups`) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid` IS NULL LIMIT 1) 15 0.00296 0.00020 0.00016 0.00032
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_template_configuration`) 1 0.00191 0.00191 0.00191 0.00191
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_templates`) 1 0.00170 0.00170 0.00170 0.00170
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_sessions`) 1 0.00138 0.00138 0.00138 0.00138
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_templates`) 1 0.00095 0.00095 0.00095 0.00095
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_template_configuration`) 1 0.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_sessions`) 1 0.00046 0.00046 0.00046 0.00046
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)) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.execute(DELETE `lime_sessions` FROM `lime_sessions` WHERE expire < 1790748548) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE `t`.`users_name`=:yp0 LIMIT 1. Bound with :yp0='limer') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groupsettings` `t` WHERE `t`.`gsid`=0 LIMIT 1) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT * FROM `lime_sessions` `t` WHERE `t`.`id`='nDo0T8NMndL8cgwWK0E4mEjIwElk2c~0' LIMIT 1) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_permissions`) 1 0.00064 0.00064 0.00064 0.00064
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`.`showregisterpolicy` AS `t0_c20`, `t`.`showtokenpolicy` AS `t0_c21`, `t`.`publicstatistics` AS `t0_c22`, `t`.`publicgraphs` AS `t0_c23`, `t`.`listpublic` AS `t0_c24`, `t`.`htmlemail` AS `t0_c25`, `t`.`sendconfirmation` AS `t0_c26`, `t`.`tokenanswerspersistence` AS `t0_c27`, `t`.`assessments` AS `t0_c28`, `t`.`usecaptcha` AS `t0_c29`, `t`.`bounce_email` AS `t0_c30`, `t`.`attributedescriptions` AS `t0_c31`, `t`.`emailresponseto` AS `t0_c32`, `t`.`emailnotificationto` AS `t0_c33`, `t`.`tokenlength` AS `t0_c34`, `t`.`showxquestions` AS `t0_c35`, `t`.`showgroupinfo` AS `t0_c36`, `t`.`shownoanswer` AS `t0_c37`, `t`.`showqnumcode` AS `t0_c38`, `t`.`showwelcome` AS `t0_c39`, `t`.`showprogress` AS `t0_c40`, `t`.`questionindex` AS `t0_c41`, `t`.`navigationdelay` AS `t0_c42`, `t`.`alloweditaftercompletion` AS `t0_c43`, `t`.`preselectnoanswer` AS `t0_c44`, `t`.`savequotaexit` AS `t0_c45`, `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`=3)) 1 0.00041 0.00041 0.00041 0.00041
system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE ((expires > :now OR expires IS NULL) AND (user_status = :active)) AND (`t`.`uid`=3) LIMIT 1. Bound with :now='2026-09-30 06:09:08', :active='1') 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_responses_755261`) 1 0.00163 0.00163 0.00163 0.00163
system.db.CDbCommand.query(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 = 'lv' AND b.same_default=0 AND b.sid = 755261) 2 0.00247 0.00123 0.00033 0.00213
system.db.CDbCommand.query(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='lv' and gls.language='lv' AND g.sid=755261 AND q.parent_qid=0 ORDER BY group_order, question_order) 2 0.00242 0.00121 0.00043 0.00199
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_questions`) 1 0.00151 0.00151 0.00151 0.00151
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_user_in_permissionrole`) 1 0.00132 0.00132 0.00132 0.00132
system.db.CDbCommand.query(SHOW TABLES) 1 0.00142 0.00142 0.00142 0.00142
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_user_in_permissionrole`) 1 0.00041 0.00041 0.00041 0.00041
system.db.CDbCommand.query(SELECT * FROM `lime_user_in_permissionrole` `t` WHERE `t`.`uid`=:yp0. Bound with :yp0=3) 2 0.00033 0.00016 0.00013 0.00020
system.db.CDbCommand.query(SELECT `lime_surveys`.`sid` FROM `lime_surveys` WHERE lime_surveys.sid = :sid. Bound with :sid=755261) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT * FROM `lime_permissions` `t` WHERE `t`.`entity_id`=:yp0 AND `t`.`uid`=:yp1 AND `t`.`entity`=:yp2 AND `t`.`permission`=:yp3 LIMIT 1. Bound with :yp0=0, :yp1=3, :yp2='global', :yp3='surveys') 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_responses_755261`) 1 0.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(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 = 'lv' AND b.same_default=1 AND b.sid = 755261) 2 0.00048 0.00024 0.00023 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_questions`) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT MAX(`id`) FROM `lime_responses_755261`) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE `t`.`qid` IN (0, 441)) 2 0.00047 0.00024 0.00021 0.00026
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_question_themes`) 1 0.00222 0.00222 0.00222 0.00222
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_question_themes`) 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE `t`.`extends`=:yp0. Bound with :yp0='') 2 0.00071 0.00036 0.00034 0.00038
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_languagesettings`) 1 0.00219 0.00219 0.00219 0.00219
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_answers`) 1 0.00137 0.00137 0.00137 0.00137
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_answer_l10ns`) 1 0.00133 0.00133 0.00133 0.00133
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_groups`) 1 0.00112 0.00112 0.00112 0.00112
system.db.CDbCommand.query(SELECT `t`.`surveyls_survey_id` AS `t0_c0`, `t`.`surveyls_language` AS `t0_c1`, `t`.`surveyls_title` AS `t0_c2`, `t`.`surveyls_description` AS `t0_c3`, `t`.`surveyls_welcometext` AS `t0_c4`, `t`.`surveyls_endtext` AS `t0_c5`, `t`.`surveyls_policy_notice` AS `t0_c6`, `t`.`surveyls_policy_error` AS `t0_c7`, `t`.`surveyls_policy_notice_label` AS `t0_c8`, `t`.`surveyls_url` AS `t0_c9`, `t`.`surveyls_urldescription` AS `t0_c10`, `t`.`surveyls_email_invite_subj` AS `t0_c11`, `t`.`surveyls_email_invite` AS `t0_c12`, `t`.`surveyls_email_remind_subj` AS `t0_c13`, `t`.`surveyls_email_remind` AS `t0_c14`, `t`.`surveyls_email_register_subj` AS `t0_c15`, `t`.`surveyls_email_register` AS `t0_c16`, `t`.`surveyls_email_confirm_subj` AS `t0_c17`, `t`.`surveyls_email_confirm` AS `t0_c18`, `t`.`surveyls_dateformat` AS `t0_c19`, `t`.`surveyls_attributecaptions` AS `t0_c20`, `t`.`surveyls_alias` AS `t0_c21`, `t`.`email_admin_notification_subj` AS `t0_c22`, `t`.`email_admin_notification` AS `t0_c23`, `t`.`email_admin_responses_subj` AS `t0_c24`, `t`.`email_admin_responses` AS `t0_c25`, `t`.`surveyls_numberformat` AS `t0_c26`, `t`.`attachments` AS `t0_c27`, `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`.`showregisterpolicy` AS `t1_c27`, `survey`.`showtokenpolicy` AS `t1_c28`, `survey`.`publicstatistics` AS `t1_c29`, `survey`.`publicgraphs` AS `t1_c30`, `survey`.`listpublic` AS `t1_c31`, `survey`.`htmlemail` AS `t1_c32`, `survey`.`sendconfirmation` AS `t1_c33`, `survey`.`tokenanswerspersistence` AS `t1_c34`, `survey`.`assessments` AS `t1_c35`, `survey`.`usecaptcha` AS `t1_c36`, `survey`.`usetokens` AS `t1_c37`, `survey`.`bounce_email` AS `t1_c38`, `survey`.`attributedescriptions` AS `t1_c39`, `survey`.`emailresponseto` AS `t1_c40`, `survey`.`emailnotificationto` AS `t1_c41`, `survey`.`tokenlength` AS `t1_c42`, `survey`.`showxquestions` AS `t1_c43`, `survey`.`showgroupinfo` AS `t1_c44`, `survey`.`shownoanswer` AS `t1_c45`, `survey`.`showqnumcode` AS `t1_c46`, `survey`.`bouncetime` AS `t1_c47`, `survey`.`bounceprocessing` AS `t1_c48`, `survey`.`bounceaccounttype` AS `t1_c49`, `survey`.`bounceaccounthost` AS `t1_c50`, `survey`.`bounceaccountpass` AS `t1_c51`, `survey`.`bounceaccountencryption` AS `t1_c52`, `survey`.`bounceaccountuser` AS `t1_c53`, `survey`.`showwelcome` AS `t1_c54`, `survey`.`showprogress` AS `t1_c55`, `survey`.`questionindex` AS `t1_c56`, `survey`.`navigationdelay` AS `t1_c57`, `survey`.`alloweditaftercompletion` AS `t1_c58`, `survey`.`googleanalyticsstyle` AS `t1_c59`, `survey`.`googleanalyticsapikey` AS `t1_c60`, `survey`.`tokenencryptionoptions` AS `t1_c61`, `survey`.`access_mode` AS `t1_c62`, `survey`.`lastmodified` AS `t1_c63`, `survey`.`preselectnoanswer` AS `t1_c64`, `survey`.`savequotaexit` AS `t1_c65` FROM `lime_surveys_languagesettings` `t` LEFT OUTER JOIN `lime_surveys` `survey` ON (t.surveyls_survey_id = survey.sid) WHERE (`t`.`surveyls_survey_id`=755261 AND `t`.`surveyls_language`='lv')) 2 0.00097 0.00049 0.00045 0.00052
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_languagesettings`) 1 0.00097 0.00097 0.00097 0.00097
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_answers`) 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SELECT * FROM lime_surveys_languagesettings WHERE surveyls_survey_id = 755261 AND surveyls_language = 'lv';) 1 0.00044 0.00044 0.00044 0.00044
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='lv') 1 0.00043 0.00043 0.00043 0.00043
system.db.CDbCommand.query(SELECT `t`.`aid` AS `t0_c0`, `t`.`qid` AS `t0_c1`, `t`.`code` AS `t0_c2`, `t`.`sortorder` AS `t0_c3`, `t`.`assessment_value` AS `t0_c4`, `t`.`scale_id` AS `t0_c5`, `answerl10ns`.`id` AS `t1_c0`, `answerl10ns`.`aid` AS `t1_c1`, `answerl10ns`.`answer` AS `t1_c2`, `answerl10ns`.`language` AS `t1_c3`, `question`.`qid` AS `t2_c0`, `question`.`parent_qid` AS `t2_c1`, `question`.`sid` AS `t2_c2`, `question`.`gid` AS `t2_c3`, `question`.`type` AS `t2_c4`, `question`.`title` AS `t2_c5`, `question`.`preg` AS `t2_c6`, `question`.`other` AS `t2_c7`, `question`.`mandatory` AS `t2_c8`, `question`.`encrypted` AS `t2_c9`, `question`.`question_order` AS `t2_c10`, `question`.`scale_id` AS `t2_c11`, `question`.`same_default` AS `t2_c12`, `question`.`relevance` AS `t2_c13`, `question`.`question_theme_name` AS `t2_c14`, `question`.`modulename` AS `t2_c15`, `question`.`same_script` AS `t2_c16` FROM `lime_answers` `t` LEFT OUTER JOIN `lime_answer_l10ns` `answerl10ns` ON (`answerl10ns`.`aid`=`t`.`aid`) LEFT OUTER JOIN `lime_questions` `question` ON (t.qid = question.qid) WHERE (question.sid=755261 AND `answerl10ns`.language = 'lv') ORDER BY question.question_order, t.scale_id, sortorder, code) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_answer_l10ns`) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT `owner`.`uid` AS `t1_c0`, `owner`.`users_name` AS `t1_c1`, `owner`.`password` AS `t1_c2`, `owner`.`full_name` AS `t1_c3`, `owner`.`parent_id` AS `t1_c4`, `owner`.`lang` AS `t1_c5`, `owner`.`email` AS `t1_c6`, `owner`.`htmleditormode` AS `t1_c7`, `owner`.`templateeditormode` AS `t1_c8`, `owner`.`questionselectormode` AS `t1_c9`, `owner`.`one_time_pw` AS `t1_c10`, `owner`.`dateformat` AS `t1_c11`, `owner`.`last_login` AS `t1_c12`, `owner`.`created` AS `t1_c13`, `owner`.`modified` AS `t1_c14`, `owner`.`validation_key` AS `t1_c15`, `owner`.`validation_key_expiration` AS `t1_c16`, `owner`.`last_forgot_email_password` AS `t1_c17`, `owner`.`expires` AS `t1_c18`, `owner`.`user_status` AS `t1_c19`, `owner`.`session_token` AS `t1_c20` FROM `lime_users` `owner` WHERE (`owner`.`uid`=:ypl0). Bound with :ypl0=1) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE sid=755261 ORDER BY question_order) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SELECT * FROM `lime_groups` `t` WHERE sid=755261 ORDER BY group_order) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_groups`) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT count(*) FROM `lime_responses_755261` WHERE lime_responses_755261.id >= :min AND lime_responses_755261.id <= :max. Bound with min=1, max=2) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SELECT `lime_responses_755261`.`id`, `lime_responses_755261`.`submitdate`, `lime_responses_755261`.`lastpage`, `lime_responses_755261`.`startlanguage`, `lime_responses_755261`.`seed`, `lime_responses_755261`.`startdate`, `lime_responses_755261`.`datestamp`, `lime_responses_755261`.`quota_exit`, `lime_responses_755261`.`Q441` FROM `lime_responses_755261` WHERE lime_responses_755261.id >= :min AND lime_responses_755261.id <= :max ORDER BY `lime_responses_755261`.`id` ASC LIMIT 100. Bound with min=1, max=2) 1 0.00024 0.00024 0.00024 0.00024
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=3, :yp3='superadmin') 1 0.00023 0.00023 0.00023 0.00023