| Profiling Summary Report (Time: 0.09445s, Memory: 7,294KB) | |||||
|---|---|---|---|---|---|
| Procedure | Count | Total (s) | Avg. (s) | Min. (s) | Max. (s) |
| system.db.CDbCommand.query(SHOW TABLES) | 1 | 0.00700 | 0.00700 | 0.00700 | 0.00700 |
| system.db.CDbCommand.execute(UPDATE `lime_surveys` SET `template`=:yp0, `language`=:yp1, `sid`=:yp2, `owner_id`=:yp3, `admin`=:yp4, `active`=:yp5, `expires`=:yp6, `startdate`=:yp7, `adminemail`=:yp8, `anonymized`=:yp9, `faxto`=:yp10, `savetimings`=:yp11, `additional_languages`=:yp12, `datestamp`=:yp13, `usecookie`=:yp14, `allowregister`=:yp15, `allowsave`=:yp16, `autonumber_start`=:yp17, `autoredirect`=:yp18, `allowprev`=:yp19, `printanswers`=:yp20, `ipaddr`=:yp21, `refurl`=:yp22, `datecreated`=:yp23, `publicstatistics`=:yp24, `publicgraphs`=:yp25, `listpublic`=:yp26, `htmlemail`=:yp27, `sendconfirmation`=:yp28, `tokenanswerspersistence`=:yp29, `assessments`=:yp30, `usecaptcha`=:yp31, `usetokens`=:yp32, `bounce_email`=:yp33, `attributedescriptions`=:yp34, `emailresponseto`=:yp35, `emailnotificationto`=:yp36, `tokenlength`=:yp37, `showxquestions`=:yp38, `showgroupinfo`=:yp39, `shownoanswer`=:yp40, `showqnumcode`=:yp41, `bouncetime`=:yp42, `bounceprocessing`=:yp43, `bounceaccounttype`=:yp44, `bounceaccounthost`=:yp45, `bounceaccountpass`=:yp46, `bounceaccountencryption`=:yp47, `bounceaccountuser`=:yp48, `showwelcome`=:yp49, `showprogress`=:yp50, `questionindex`=:yp51, `navigationdelay`=:yp52, `nokeyboard`=:yp53, `alloweditaftercompletion`=:yp54, `googleanalyticsstyle`=:yp55, `googleanalyticsapikey`=:yp56, `format`=:yp57 WHERE `lime_surveys`.`sid`=597566. Bound with :yp0='default', :yp1='en', :yp2=597566, :yp3=1, :yp4='Doris Rittmannsberger', :yp5='N', :yp6=NULL, :yp7=NULL, :yp8='doris.rittmannsberger@univie.ac.at', :yp9='N', :yp10='', :yp11='N', :yp12='', :yp13='Y', :yp14='N', :yp15='N', :yp16='Y', :yp17=0, :yp18='N', :yp19='N', :yp20='N', :yp21='N', :yp22='Y', :yp23='2016-03-21', :yp24='N', :yp25='N', :yp26='N', :yp27='N', :yp28='Y', :yp29='N', :yp30='N', :yp31='N', :yp32='N', :yp33='doris.rittmannsberger@univie.ac.at', :yp34=NULL, :yp35='', :yp36='', :yp37=15, :yp38='Y', :yp39='B', :yp40='Y', :yp41='X', :yp42=NULL, :yp43='N', :yp44=NULL, :yp45=NULL, :yp46=NULL, :yp47=NULL, :yp48=NULL, :yp49='Y', :yp50='Y', :yp51=0, :yp52=0, :yp53='N', :yp54='N', :yp55=NULL, :yp56=NULL, :yp57='G') | 1 | 0.00419 | 0.00419 | 0.00419 | 0.00419 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys`) | 1 | 0.00222 | 0.00222 | 0.00222 | 0.00222 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_questions`) | 1 | 0.00163 | 0.00163 | 0.00163 | 0.00163 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_languagesettings`) | 1 | 0.00152 | 0.00152 | 0.00152 | 0.00152 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_settings_global`) | 1 | 0.00150 | 0.00150 | 0.00150 | 0.00150 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_groups`) | 1 | 0.00132 | 0.00132 | 0.00132 | 0.00132 |
| 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_url` AS `t1_c6`, `defaultlanguage`.`surveyls_urldescription` AS `t1_c7`, `defaultlanguage`.`surveyls_email_invite_subj` AS `t1_c8`, `defaultlanguage`.`surveyls_email_invite` AS `t1_c9`, `defaultlanguage`.`surveyls_email_remind_subj` AS `t1_c10`, `defaultlanguage`.`surveyls_email_remind` AS `t1_c11`, `defaultlanguage`.`surveyls_email_register_subj` AS `t1_c12`, `defaultlanguage`.`surveyls_email_register` AS `t1_c13`, `defaultlanguage`.`surveyls_email_confirm_subj` AS `t1_c14`, `defaultlanguage`.`surveyls_email_confirm` AS `t1_c15`, `defaultlanguage`.`surveyls_dateformat` AS `t1_c16`, `defaultlanguage`.`surveyls_attributecaptions` AS `t1_c17`, `defaultlanguage`.`email_admin_notification_subj` AS `t1_c18`, `defaultlanguage`.`email_admin_notification` AS `t1_c19`, `defaultlanguage`.`email_admin_responses_subj` AS `t1_c20`, `defaultlanguage`.`email_admin_responses` AS `t1_c21`, `defaultlanguage`.`surveyls_numberformat` AS `t1_c22`, `defaultlanguage`.`attachments` AS `t1_c23` FROM `lime_surveys_languagesettings` `defaultlanguage` WHERE (`defaultlanguage`.`surveyls_language`=:ypl0) AND (`defaultlanguage`.`surveyls_survey_id`=:ypl1). Bound with :ypl0='en', :ypl1='597566') | 2 | 0.00128 | 0.00064 | 0.00064 | 0.00064 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_users`) | 1 | 0.00127 | 0.00127 | 0.00127 | 0.00127 |
| system.db.CDbCommand.query(SELECT `t`.`sid` AS `t0_c0`, `t`.`owner_id` AS `t0_c1`, `t`.`admin` AS `t0_c2`, `t`.`active` AS `t0_c3`, `t`.`expires` AS `t0_c4`, `t`.`startdate` AS `t0_c5`, `t`.`adminemail` AS `t0_c6`, `t`.`anonymized` AS `t0_c7`, `t`.`faxto` 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`.`refurl` AS `t0_c23`, `t`.`datecreated` AS `t0_c24`, `t`.`publicstatistics` AS `t0_c25`, `t`.`publicgraphs` AS `t0_c26`, `t`.`listpublic` AS `t0_c27`, `t`.`htmlemail` AS `t0_c28`, `t`.`sendconfirmation` AS `t0_c29`, `t`.`tokenanswerspersistence` AS `t0_c30`, `t`.`assessments` AS `t0_c31`, `t`.`usecaptcha` AS `t0_c32`, `t`.`usetokens` AS `t0_c33`, `t`.`bounce_email` AS `t0_c34`, `t`.`attributedescriptions` AS `t0_c35`, `t`.`emailresponseto` AS `t0_c36`, `t`.`emailnotificationto` AS `t0_c37`, `t`.`tokenlength` AS `t0_c38`, `t`.`showxquestions` AS `t0_c39`, `t`.`showgroupinfo` AS `t0_c40`, `t`.`shownoanswer` AS `t0_c41`, `t`.`showqnumcode` AS `t0_c42`, `t`.`bouncetime` AS `t0_c43`, `t`.`bounceprocessing` AS `t0_c44`, `t`.`bounceaccounttype` AS `t0_c45`, `t`.`bounceaccounthost` AS `t0_c46`, `t`.`bounceaccountpass` AS `t0_c47`, `t`.`bounceaccountencryption` AS `t0_c48`, `t`.`bounceaccountuser` AS `t0_c49`, `t`.`showwelcome` AS `t0_c50`, `t`.`showprogress` AS `t0_c51`, `t`.`questionindex` AS `t0_c52`, `t`.`navigationdelay` AS `t0_c53`, `t`.`nokeyboard` AS `t0_c54`, `t`.`alloweditaftercompletion` AS `t0_c55`, `t`.`googleanalyticsstyle` AS `t0_c56`, `t`.`googleanalyticsapikey` AS `t0_c57`, `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_url` AS `t1_c6`, `languagesettings`.`surveyls_urldescription` AS `t1_c7`, `languagesettings`.`surveyls_email_invite_subj` AS `t1_c8`, `languagesettings`.`surveyls_email_invite` AS `t1_c9`, `languagesettings`.`surveyls_email_remind_subj` AS `t1_c10`, `languagesettings`.`surveyls_email_remind` AS `t1_c11`, `languagesettings`.`surveyls_email_register_subj` AS `t1_c12`, `languagesettings`.`surveyls_email_register` AS `t1_c13`, `languagesettings`.`surveyls_email_confirm_subj` AS `t1_c14`, `languagesettings`.`surveyls_email_confirm` AS `t1_c15`, `languagesettings`.`surveyls_dateformat` AS `t1_c16`, `languagesettings`.`surveyls_attributecaptions` AS `t1_c17`, `languagesettings`.`email_admin_notification_subj` AS `t1_c18`, `languagesettings`.`email_admin_notification` AS `t1_c19`, `languagesettings`.`email_admin_responses_subj` AS `t1_c20`, `languagesettings`.`email_admin_responses` AS `t1_c21`, `languagesettings`.`surveyls_numberformat` AS `t1_c22`, `languagesettings`.`attachments` AS `t1_c23` FROM `lime_surveys` `t` LEFT OUTER JOIN `lime_surveys_languagesettings` `languagesettings` ON (`languagesettings`.`surveyls_survey_id`=`t`.`sid`) WHERE (sid = :surveyid) AND (surveyls_language=language). Bound with :surveyid=597566) | 1 | 0.00121 | 0.00121 | 0.00121 | 0.00121 |
| system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=:yp0 LIMIT 1. Bound with :yp0=597566) | 2 | 0.00113 | 0.00057 | 0.00048 | 0.00065 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_permissions`) | 1 | 0.00110 | 0.00110 | 0.00110 | 0.00110 |
| system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=597566 LIMIT 1) | 2 | 0.00103 | 0.00051 | 0.00050 | 0.00052 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_templates`) | 1 | 0.00097 | 0.00097 | 0.00097 | 0.00097 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugins`) | 1 | 0.00093 | 0.00093 | 0.00093 | 0.00093 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys`) | 1 | 0.00070 | 0.00070 | 0.00070 | 0.00070 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `lime_permissions`) | 1 | 0.00067 | 0.00067 | 0.00067 | 0.00067 |
| 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_url` AS `t0_c6`, `t`.`surveyls_urldescription` AS `t0_c7`, `t`.`surveyls_email_invite_subj` AS `t0_c8`, `t`.`surveyls_email_invite` AS `t0_c9`, `t`.`surveyls_email_remind_subj` AS `t0_c10`, `t`.`surveyls_email_remind` AS `t0_c11`, `t`.`surveyls_email_register_subj` AS `t0_c12`, `t`.`surveyls_email_register` AS `t0_c13`, `t`.`surveyls_email_confirm_subj` AS `t0_c14`, `t`.`surveyls_email_confirm` AS `t0_c15`, `t`.`surveyls_dateformat` AS `t0_c16`, `t`.`surveyls_attributecaptions` AS `t0_c17`, `t`.`email_admin_notification_subj` AS `t0_c18`, `t`.`email_admin_notification` AS `t0_c19`, `t`.`email_admin_responses_subj` AS `t0_c20`, `t`.`email_admin_responses` AS `t0_c21`, `t`.`surveyls_numberformat` AS `t0_c22`, `t`.`attachments` AS `t0_c23`, `survey`.`sid` AS `t1_c0`, `survey`.`owner_id` AS `t1_c1`, `survey`.`admin` AS `t1_c2`, `survey`.`active` AS `t1_c3`, `survey`.`expires` AS `t1_c4`, `survey`.`startdate` AS `t1_c5`, `survey`.`adminemail` AS `t1_c6`, `survey`.`anonymized` AS `t1_c7`, `survey`.`faxto` 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`.`refurl` AS `t1_c23`, `survey`.`datecreated` AS `t1_c24`, `survey`.`publicstatistics` AS `t1_c25`, `survey`.`publicgraphs` AS `t1_c26`, `survey`.`listpublic` AS `t1_c27`, `survey`.`htmlemail` AS `t1_c28`, `survey`.`sendconfirmation` AS `t1_c29`, `survey`.`tokenanswerspersistence` AS `t1_c30`, `survey`.`assessments` AS `t1_c31`, `survey`.`usecaptcha` AS `t1_c32`, `survey`.`usetokens` AS `t1_c33`, `survey`.`bounce_email` AS `t1_c34`, `survey`.`attributedescriptions` AS `t1_c35`, `survey`.`emailresponseto` AS `t1_c36`, `survey`.`emailnotificationto` AS `t1_c37`, `survey`.`tokenlength` AS `t1_c38`, `survey`.`showxquestions` AS `t1_c39`, `survey`.`showgroupinfo` AS `t1_c40`, `survey`.`shownoanswer` AS `t1_c41`, `survey`.`showqnumcode` AS `t1_c42`, `survey`.`bouncetime` AS `t1_c43`, `survey`.`bounceprocessing` AS `t1_c44`, `survey`.`bounceaccounttype` AS `t1_c45`, `survey`.`bounceaccounthost` AS `t1_c46`, `survey`.`bounceaccountpass` AS `t1_c47`, `survey`.`bounceaccountencryption` AS `t1_c48`, `survey`.`bounceaccountuser` AS `t1_c49`, `survey`.`showwelcome` AS `t1_c50`, `survey`.`showprogress` AS `t1_c51`, `survey`.`questionindex` AS `t1_c52`, `survey`.`navigationdelay` AS `t1_c53`, `survey`.`nokeyboard` AS `t1_c54`, `survey`.`alloweditaftercompletion` AS `t1_c55`, `survey`.`googleanalyticsstyle` AS `t1_c56`, `survey`.`googleanalyticsapikey` AS `t1_c57` FROM `lime_surveys_languagesettings` `t` LEFT OUTER JOIN `lime_surveys` `survey` ON (t.surveyls_survey_id = survey.sid) WHERE (`t`.`surveyls_survey_id`=597566 AND `t`.`surveyls_language`='en')) | 1 | 0.00067 | 0.00067 | 0.00067 | 0.00067 |
| system.db.CDbCommand.query(SELECT * FROM `lime_groups` `t` WHERE `t`.`sid`=:yp0 AND `t`.`language`=:yp1. Bound with :yp0=597566, :yp1='en') | 1 | 0.00066 | 0.00066 | 0.00066 | 0.00066 |
| system.db.CDbCommand.query(SELECT `t`.`sid` AS `t0_c0`, `t`.`owner_id` AS `t0_c1`, `t`.`admin` AS `t0_c2`, `t`.`active` AS `t0_c3`, `t`.`expires` AS `t0_c4`, `t`.`startdate` AS `t0_c5`, `t`.`adminemail` AS `t0_c6`, `t`.`anonymized` AS `t0_c7`, `t`.`faxto` 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`.`refurl` AS `t0_c23`, `t`.`datecreated` AS `t0_c24`, `t`.`publicstatistics` AS `t0_c25`, `t`.`publicgraphs` AS `t0_c26`, `t`.`listpublic` AS `t0_c27`, `t`.`htmlemail` AS `t0_c28`, `t`.`sendconfirmation` AS `t0_c29`, `t`.`tokenanswerspersistence` AS `t0_c30`, `t`.`assessments` AS `t0_c31`, `t`.`usecaptcha` AS `t0_c32`, `t`.`usetokens` AS `t0_c33`, `t`.`bounce_email` AS `t0_c34`, `t`.`attributedescriptions` AS `t0_c35`, `t`.`emailresponseto` AS `t0_c36`, `t`.`emailnotificationto` AS `t0_c37`, `t`.`tokenlength` AS `t0_c38`, `t`.`showxquestions` AS `t0_c39`, `t`.`showgroupinfo` AS `t0_c40`, `t`.`shownoanswer` AS `t0_c41`, `t`.`showqnumcode` AS `t0_c42`, `t`.`bouncetime` AS `t0_c43`, `t`.`bounceprocessing` AS `t0_c44`, `t`.`bounceaccounttype` AS `t0_c45`, `t`.`bounceaccounthost` AS `t0_c46`, `t`.`bounceaccountpass` AS `t0_c47`, `t`.`bounceaccountencryption` AS `t0_c48`, `t`.`bounceaccountuser` AS `t0_c49`, `t`.`showwelcome` AS `t0_c50`, `t`.`showprogress` AS `t0_c51`, `t`.`questionindex` AS `t0_c52`, `t`.`navigationdelay` AS `t0_c53`, `t`.`nokeyboard` AS `t0_c54`, `t`.`alloweditaftercompletion` AS `t0_c55`, `t`.`googleanalyticsstyle` AS `t0_c56`, `t`.`googleanalyticsapikey` AS `t0_c57`, `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_url` AS `t1_c6`, `languagesettings`.`surveyls_urldescription` AS `t1_c7`, `languagesettings`.`surveyls_email_invite_subj` AS `t1_c8`, `languagesettings`.`surveyls_email_invite` AS `t1_c9`, `languagesettings`.`surveyls_email_remind_subj` AS `t1_c10`, `languagesettings`.`surveyls_email_remind` AS `t1_c11`, `languagesettings`.`surveyls_email_register_subj` AS `t1_c12`, `languagesettings`.`surveyls_email_register` AS `t1_c13`, `languagesettings`.`surveyls_email_confirm_subj` AS `t1_c14`, `languagesettings`.`surveyls_email_confirm` AS `t1_c15`, `languagesettings`.`surveyls_dateformat` AS `t1_c16`, `languagesettings`.`surveyls_attributecaptions` AS `t1_c17`, `languagesettings`.`email_admin_notification_subj` AS `t1_c18`, `languagesettings`.`email_admin_notification` AS `t1_c19`, `languagesettings`.`email_admin_responses_subj` AS `t1_c20`, `languagesettings`.`email_admin_responses` AS `t1_c21`, `languagesettings`.`surveyls_numberformat` AS `t1_c22`, `languagesettings`.`attachments` AS `t1_c23` FROM `lime_surveys` `t` LEFT OUTER JOIN `lime_surveys_languagesettings` `languagesettings` ON (`languagesettings`.`surveyls_survey_id`=`t`.`sid`) WHERE (sid = :surveyid) AND (surveyls_language=language). Bound with :surveyid='597566') | 1 | 0.00064 | 0.00064 | 0.00064 | 0.00064 |
| system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t`) | 1 | 0.00064 | 0.00064 | 0.00064 | 0.00064 |
| system.db.CDbCommand.query(SELECT * FROM lime_questions as questions, lime_groups as groups WHERE questions.gid=groups.gid AND questions.sid=597566 AND questions.language='en' AND questions.parent_qid=0 AND groups.language='en' ORDER BY group_order, question_order) | 1 | 0.00063 | 0.00063 | 0.00063 | 0.00063 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_languagesettings`) | 1 | 0.00054 | 0.00054 | 0.00054 | 0.00054 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `lime_groups`) | 1 | 0.00050 | 0.00050 | 0.00050 | 0.00050 |
| system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_surveys` `t`) | 1 | 0.00050 | 0.00050 | 0.00050 | 0.00050 |
| system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_surveys` `t` WHERE active = 'Y') | 1 | 0.00048 | 0.00048 | 0.00048 | 0.00048 |
| system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY question_order ASC. Bound with :yp0=597566, :yp1='18', :yp2='en') | 1 | 0.00048 | 0.00048 | 0.00048 | 0.00048 |
| system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM lime_defaultvalues as a, lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND a.language = 'en' AND b.same_default=0 AND b.sid = 597566) | 1 | 0.00047 | 0.00047 | 0.00047 | 0.00047 |
| system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_users` `t`) | 1 | 0.00044 | 0.00044 | 0.00044 | 0.00044 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `lime_templates`) | 1 | 0.00043 | 0.00043 | 0.00043 | 0.00043 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `lime_settings_global`) | 1 | 0.00043 | 0.00043 | 0.00043 | 0.00043 |
| 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.00042 | 0.00042 | 0.00042 | 0.00042 |
| system.db.CDbCommand.execute(CREATE TABLE `lime_survey_597566` ( `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `token` varchar(35) , `submitdate` datetime, `lastpage` int(11), `startlanguage` varchar(20) NOT NULL, `startdate` datetime NOT NULL, `datestamp` datetime NOT NULL, `refurl` text, `597566X18X516` varchar(1) , `597566X18X517` text, `597566X19X518` varchar(1) , `597566X19X519` text ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci) | 1 | 0.00042 | 0.00042 | 0.00042 | 0.00042 |
| system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0. Bound with :yp0=1) | 1 | 0.00040 | 0.00040 | 0.00040 | 0.00040 |
| system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY question_order ASC. Bound with :yp0=597566, :yp1='19', :yp2='en') | 1 | 0.00040 | 0.00040 | 0.00040 | 0.00040 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugins`) | 1 | 0.00038 | 0.00038 | 0.00038 | 0.00038 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `lime_questions`) | 1 | 0.00037 | 0.00037 | 0.00037 | 0.00037 |
| system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM lime_defaultvalues as a, lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND a.language = 'en' AND b.same_default=1 AND b.sid = 597566) | 1 | 0.00036 | 0.00036 | 0.00036 | 0.00036 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `lime_users`) | 1 | 0.00036 | 0.00036 | 0.00036 | 0.00036 |