ReachOut Surveys

Warning: Please read this carefully before proceeding!

You should only activate a survey when you are absolutely certain that your survey setup is finished and will not need changing.

Once a survey is activated you can no longer:

Add or delete groups
Add or delete questions
Add or delete subquestions or change their codes

Anonymized responses?

Date stamp?

Please note that once responses have collected with this survey and you want to add or remove groups/questions or change one of the settings above, you will need to deactivate this survey, which will move all data that has already been entered into a separate archived table.

Cancel

Profiling Summary Report (Time: 0.31265s, Memory: 7,715KB)
Procedure	Count	Total (s)	Avg. (s)	Min. (s)	Max. (s)
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_templates`)	1	0.00618	0.00618	0.00618	0.00618
system.db.CDbCommand.query(SHOW TABLES)	1	0.00176	0.00176	0.00176	0.00176
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_surveys`)	1	0.00144	0.00144	0.00144	0.00144
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_surveys_languagesettings`)	1	0.00132	0.00132	0.00132	0.00132
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_template_configuration`)	1	0.00109	0.00109	0.00109	0.00109
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_settings_global`)	1	0.00107	0.00107	0.00107	0.00107
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_permissions`)	1	0.00099	0.00099	0.00099	0.00099
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_users`)	1	0.00098	0.00098	0.00098	0.00098
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_plugins`)	1	0.00081	0.00081	0.00081	0.00081
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_questions`)	1	0.00079	0.00079	0.00079	0.00079
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_plugin_settings`)	1	0.00077	0.00077	0.00077	0.00077
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_groups`)	1	0.00077	0.00077	0.00077	0.00077
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_question_attributes`)	1	0.00075	0.00075	0.00075	0.00075
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_asset_version`)	1	0.00069	0.00069	0.00069	0.00069
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_surveymenu`)	1	0.00066	0.00066	0.00066	0.00066
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_surveymenu_entries`)	1	0.00055	0.00055	0.00055	0.00055
system.db.CDbCommand.query(SELECT * FROM `ls_settings_global` `t`)	2	0.00049	0.00025	0.00024	0.00025
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_tutorials`)	1	0.00048	0.00048	0.00048	0.00048
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_notifications`)	1	0.00047	0.00047	0.00047	0.00047
system.db.CDbCommand.query(SELECT * FROM `ls_templates` `t` WHERE `t`.`name`='vanilla' LIMIT 1)	3	0.00043	0.00014	0.00009	0.00020
system.db.CDbCommand.query(SELECT * FROM `ls_users` `t` WHERE `t`.`uid`=1 LIMIT 1)	4	0.00043	0.00011	0.00006	0.00016
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_surveys`)	1	0.00031	0.00031	0.00031	0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_templates`)	1	0.00029	0.00029	0.00029	0.00029
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`.`email_admin_notification_subj` AS `t0_c21`, `t`.`email_admin_notification` AS `t0_c22`, `t`.`email_admin_responses_subj` AS `t0_c23`, `t`.`email_admin_responses` AS `t0_c24`, `t`.`surveyls_numberformat` AS `t0_c25`, `t`.`attachments` AS `t0_c26`, `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`.`faxto` AS `t1_c9`, `survey`.`format` AS `t1_c10`, `survey`.`savetimings` AS `t1_c11`, `survey`.`template` AS `t1_c12`, `survey`.`language` AS `t1_c13`, `survey`.`additional_languages` AS `t1_c14`, `survey`.`datestamp` AS `t1_c15`, `survey`.`usecookie` AS `t1_c16`, `survey`.`allowregister` AS `t1_c17`, `survey`.`allowsave` AS `t1_c18`, `survey`.`autonumber_start` AS `t1_c19`, `survey`.`autoredirect` AS `t1_c20`, `survey`.`allowprev` AS `t1_c21`, `survey`.`printanswers` AS `t1_c22`, `survey`.`ipaddr` 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` FROM `ls_surveys_languagesettings` `t` LEFT OUTER JOIN `ls_surveys` `survey` ON (t.surveyls_survey_id = survey.sid) WHERE (`t`.`surveyls_survey_id`=72986 AND `t`.`surveyls_language`='en'))	1	0.00029	0.00029	0.00029	0.00029
system.db.CDbCommand.query(SELECT * FROM ls_questions as questions, `ls_groups` as question_groups WHERE questions.gid=question_groups.gid AND questions.sid=72986 AND questions.language='en' AND questions.parent_qid=0 AND question_groups.language='en' ORDER BY group_order, question_order)	1	0.00027	0.00027	0.00027	0.00027
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_surveys_languagesettings`)	1	0.00026	0.00026	0.00026	0.00026
system.db.CDbCommand.query(SELECT `surveymenuEntries`.`id` AS `t1_c0`, `surveymenuEntries`.`menu_id` AS `t1_c1`, `surveymenuEntries`.`user_id` AS `t1_c2`, `surveymenuEntries`.`ordering` AS `t1_c3`, `surveymenuEntries`.`name` AS `t1_c4`, `surveymenuEntries`.`title` AS `t1_c5`, `surveymenuEntries`.`menu_title` AS `t1_c6`, `surveymenuEntries`.`menu_description` AS `t1_c7`, `surveymenuEntries`.`menu_icon` AS `t1_c8`, `surveymenuEntries`.`menu_icon_type` AS `t1_c9`, `surveymenuEntries`.`menu_class` AS `t1_c10`, `surveymenuEntries`.`menu_link` AS `t1_c11`, `surveymenuEntries`.`action` AS `t1_c12`, `surveymenuEntries`.`template` AS `t1_c13`, `surveymenuEntries`.`partial` AS `t1_c14`, `surveymenuEntries`.`classes` AS `t1_c15`, `surveymenuEntries`.`permission` AS `t1_c16`, `surveymenuEntries`.`permission_grade` AS `t1_c17`, `surveymenuEntries`.`data` AS `t1_c18`, `surveymenuEntries`.`getdatamethod` AS `t1_c19`, `surveymenuEntries`.`language` AS `t1_c20`, `surveymenuEntries`.`showincollapse` AS `t1_c21`, `surveymenuEntries`.`active` AS `t1_c22`, `surveymenuEntries`.`changed_at` AS `t1_c23`, `surveymenuEntries`.`changed_by` AS `t1_c24`, `surveymenuEntries`.`created_at` AS `t1_c25`, `surveymenuEntries`.`created_by` AS `t1_c26` FROM `ls_surveymenu_entries` `surveymenuEntries` WHERE (`surveymenuEntries`.`menu_id`=:ypl0). Bound with :ypl0='2')	2	0.00022	0.00011	0.00011	0.00011
system.db.CDbCommand.query(SELECT g.gid,g.group_name,count(q.qid) as count from ls_questions as q RIGHT JOIN `ls_groups` as g ON q.gid=g.gid AND g.language=q.language WHERE g.sid=72986 AND g.language='en' group by g.gid,g.group_name;)	1	0.00021	0.00021	0.00021	0.00021
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`.`email_admin_notification_subj` AS `t1_c21`, `defaultlanguage`.`email_admin_notification` AS `t1_c22`, `defaultlanguage`.`email_admin_responses_subj` AS `t1_c23`, `defaultlanguage`.`email_admin_responses` AS `t1_c24`, `defaultlanguage`.`surveyls_numberformat` AS `t1_c25`, `defaultlanguage`.`attachments` AS `t1_c26` FROM `ls_surveys_languagesettings` `defaultlanguage` WHERE (`defaultlanguage`.`surveyls_language`=:ypl0) AND (`defaultlanguage`.`surveyls_survey_id`=:ypl1). Bound with :ypl0='en', :ypl1='72986')	2	0.00019	0.00010	0.00009	0.00010
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_questions`)	1	0.00019	0.00019	0.00019	0.00019
system.db.CDbCommand.query(SELECT * FROM `ls_surveys` `t` WHERE `t`.`sid`=72986 LIMIT 1)	1	0.00019	0.00019	0.00019	0.00019
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7935)	1	0.00019	0.00019	0.00019	0.00019
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`.`email_admin_notification_subj` AS `t1_c21`, `languagesettings`.`email_admin_notification` AS `t1_c22`, `languagesettings`.`email_admin_responses_subj` AS `t1_c23`, `languagesettings`.`email_admin_responses` AS `t1_c24`, `languagesettings`.`surveyls_numberformat` AS `t1_c25`, `languagesettings`.`attachments` AS `t1_c26` FROM `ls_surveys_languagesettings` `languagesettings` WHERE (`languagesettings`.`surveyls_survey_id`=:ypl0). Bound with :ypl0='72986')	1	0.00018	0.00018	0.00018	0.00018
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_plugins`)	1	0.00018	0.00018	0.00018	0.00018
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_permissions`)	1	0.00018	0.00018	0.00018	0.00018
system.db.CDbCommand.query(SELECT * FROM `ls_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.00018	0.00018	0.00018	0.00018
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_users`)	1	0.00017	0.00017	0.00017	0.00017
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_template_configuration`)	1	0.00017	0.00017	0.00017	0.00017
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_question_attributes`)	1	0.00017	0.00017	0.00017	0.00017
system.db.CDbCommand.query(SELECT * FROM `ls_settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion')	1	0.00017	0.00017	0.00017	0.00017
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_settings_global`)	1	0.00016	0.00016	0.00016	0.00016
system.db.CDbCommand.query(SELECT a.qid, a.code, a.answer, a.scale_id, a.assessment_value FROM ls_answers AS a, ls_questions as q WHERE a.qid = q.qid and q.sid = 72986 and a.language='en' and q.language='en' ORDER BY a.qid, a.scale_id, a.sortorder)	1	0.00016	0.00016	0.00016	0.00016
system.db.CDbCommand.query(SELECT * FROM `ls_templates` `t` WHERE `t`.`name`='fruity' LIMIT 1)	1	0.00016	0.00016	0.00016	0.00016
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_groups`)	1	0.00016	0.00016	0.00016	0.00016
system.db.CDbCommand.query(SELECT * FROM `ls_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/application/core/plugins/ComfortUpdateChecker/assets')	1	0.00015	0.00015	0.00015	0.00015
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`.`created` AS `t1_c12`, `owner`.`modified` AS `t1_c13` FROM `ls_users` `owner` WHERE (`owner`.`uid`=:ypl0). Bound with :ypl0='97')	1	0.00014	0.00014	0.00014	0.00014
system.db.CDbCommand.query(SELECT qid, question, gid, type FROM ls_questions WHERE sid=72986 and parent_qid=0)	1	0.00013	0.00013	0.00013	0.00013
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`.`faxto` AS `t0_c9`, `t`.`format` AS `t0_c10`, `t`.`savetimings` AS `t0_c11`, `t`.`template` AS `t0_c12`, `t`.`language` AS `t0_c13`, `t`.`additional_languages` AS `t0_c14`, `t`.`datestamp` AS `t0_c15`, `t`.`usecookie` AS `t0_c16`, `t`.`allowregister` AS `t0_c17`, `t`.`allowsave` AS `t0_c18`, `t`.`autonumber_start` AS `t0_c19`, `t`.`autoredirect` AS `t0_c20`, `t`.`allowprev` AS `t0_c21`, `t`.`printanswers` AS `t0_c22`, `t`.`ipaddr` 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`, `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`.`email_admin_notification_subj` AS `t1_c21`, `languagesettings`.`email_admin_notification` AS `t1_c22`, `languagesettings`.`email_admin_responses_subj` AS `t1_c23`, `languagesettings`.`email_admin_responses` AS `t1_c24`, `languagesettings`.`surveyls_numberformat` AS `t1_c25`, `languagesettings`.`attachments` AS `t1_c26` FROM `ls_surveys` `t` LEFT OUTER JOIN `ls_surveys_languagesettings` `languagesettings` ON (`languagesettings`.`surveyls_survey_id`=`t`.`sid`) WHERE (sid = :surveyid) AND (surveyls_language=language). Bound with :surveyid='72986')	1	0.00013	0.00013	0.00013	0.00013
system.db.CDbCommand.query(SELECT * FROM `ls_groups` `t` WHERE sid=:sid and language=:language ORDER BY group_order. Bound with :sid='72986', :language='en')	1	0.00013	0.00013	0.00013	0.00013
system.db.CDbCommand.query(SELECT * FROM `ls_plugins` `t` WHERE `t`.`active`=:yp0. Bound with :yp0=1)	1	0.00013	0.00013	0.00013	0.00013
system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `ls_templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='vanilla')	1	0.00012	0.00012	0.00012	0.00012
system.db.CDbCommand.query(SELECT DISTINCT qid FROM `ls_questions` `t` WHERE sid=:sid and parent_qid=0 GROUP BY qid. Bound with :sid='72986')	1	0.00012	0.00012	0.00012	0.00012
system.db.CDbCommand.query(SELECT COUNT(*) FROM `ls_surveys` `t` WHERE active = 'Y')	1	0.00012	0.00012	0.00012	0.00012
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_asset_version`)	1	0.00012	0.00012	0.00012	0.00012
system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7926 and scale_id=0 ORDER BY sortorder, answer)	1	0.00012	0.00012	0.00012	0.00012
system.db.CDbCommand.query(SELECT * FROM `ls_template_configuration` `t` WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY `t`.`template_name` LIMIT 1. Bound with :template_name='vanilla')	1	0.00011	0.00011	0.00011	0.00011
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_surveymenu_entries`)	1	0.00011	0.00011	0.00011	0.00011
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_surveymenu`)	1	0.00011	0.00011	0.00011	0.00011
system.db.CDbCommand.query(select count(DISTINCT g.gid) from `ls_groups` g left join ls_questions q on g.gid=q.gid where g.sid=72986 and qid is not null)	1	0.00011	0.00011	0.00011	0.00011
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_notifications`)	1	0.00010	0.00010	0.00010	0.00010
system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7925 and scale_id=0 ORDER BY sortorder, answer)	1	0.00010	0.00010	0.00010	0.00010
system.db.CDbCommand.query(SELECT * FROM `ls_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/application/extensions/FlashMessage/assets')	1	0.00010	0.00010	0.00010	0.00010
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7902)	1	0.00010	0.00010	0.00010	0.00010
system.db.CDbCommand.query(SELECT * FROM `ls_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='8', :yp1='only_security_update')	2	0.00010	0.00005	0.00004	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7916)	1	0.00010	0.00010	0.00010	0.00010
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7902)	1	0.00010	0.00010	0.00010	0.00010
system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7930 and scale_id=0 ORDER BY sortorder, answer)	1	0.00010	0.00010	0.00010	0.00010
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7904)	1	0.00010	0.00010	0.00010	0.00010
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_plugin_settings`)	1	0.00010	0.00010	0.00010	0.00010
system.db.CDbCommand.query(SELECT sq.*, q.other FROM ls_questions as sq, ls_questions as q WHERE sq.parent_qid=q.qid AND q.sid=72986 AND sq.language='en' AND q.language='en' ORDER BY sq.parent_qid, q.question_order,sq.scale_id , sq.question_order)	1	0.00009	0.00009	0.00009	0.00009
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_tutorials`)	1	0.00009	0.00009	0.00009	0.00009
system.db.CDbCommand.query(SELECT * FROM `ls_tutorials` `t` WHERE active=1)	1	0.00009	0.00009	0.00009	0.00009
system.db.CDbCommand.query(SELECT `surveymenuEntries`.`id` AS `t1_c0`, `surveymenuEntries`.`menu_id` AS `t1_c1`, `surveymenuEntries`.`user_id` AS `t1_c2`, `surveymenuEntries`.`ordering` AS `t1_c3`, `surveymenuEntries`.`name` AS `t1_c4`, `surveymenuEntries`.`title` AS `t1_c5`, `surveymenuEntries`.`menu_title` AS `t1_c6`, `surveymenuEntries`.`menu_description` AS `t1_c7`, `surveymenuEntries`.`menu_icon` AS `t1_c8`, `surveymenuEntries`.`menu_icon_type` AS `t1_c9`, `surveymenuEntries`.`menu_class` AS `t1_c10`, `surveymenuEntries`.`menu_link` AS `t1_c11`, `surveymenuEntries`.`action` AS `t1_c12`, `surveymenuEntries`.`template` AS `t1_c13`, `surveymenuEntries`.`partial` AS `t1_c14`, `surveymenuEntries`.`classes` AS `t1_c15`, `surveymenuEntries`.`permission` AS `t1_c16`, `surveymenuEntries`.`permission_grade` AS `t1_c17`, `surveymenuEntries`.`data` AS `t1_c18`, `surveymenuEntries`.`getdatamethod` AS `t1_c19`, `surveymenuEntries`.`language` AS `t1_c20`, `surveymenuEntries`.`showincollapse` AS `t1_c21`, `surveymenuEntries`.`active` AS `t1_c22`, `surveymenuEntries`.`changed_at` AS `t1_c23`, `surveymenuEntries`.`changed_by` AS `t1_c24`, `surveymenuEntries`.`created_at` AS `t1_c25`, `surveymenuEntries`.`created_by` AS `t1_c26` FROM `ls_surveymenu_entries` `surveymenuEntries` WHERE (`surveymenuEntries`.`menu_id`=:ypl0). Bound with :ypl0='3')	1	0.00009	0.00009	0.00009	0.00009
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7904)	1	0.00009	0.00009	0.00009	0.00009
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY question_order ASC. Bound with :yp0='72986', :yp1='1249', :yp2='en')	1	0.00009	0.00009	0.00009	0.00009
system.db.CDbCommand.query(SELECT * FROM `ls_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/application/extensions/LimeScript/assets/script.js')	1	0.00009	0.00009	0.00009	0.00009
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY question_order ASC. Bound with :yp0='72986', :yp1='1250', :yp2='en')	1	0.00009	0.00009	0.00009	0.00009
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7905)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY question_order ASC. Bound with :yp0='72986', :yp1='1251', :yp2='en')	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7932)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY question_order ASC. Bound with :yp0='72986', :yp1='1253', :yp2='en')	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7914)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7914)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7911)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7903)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM ls_questions WHERE sid=72986 AND type not in ('S', 'D', 'T', 'Q'))	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY question_order ASC. Bound with :yp0='72986', :yp1='1252', :yp2='en')	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7924 and scale_id=0 ORDER BY sortorder, answer)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7925)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7913)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7924)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7915)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM ls_defaultvalues as a, ls_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 = 72986)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7906)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT ls_conditions.qid, cqid, ls_questions.question, ls_questions.gid FROM ls_conditions, ls_questions, `ls_groups` g WHERE ls_questions.sid=72986 AND ls_conditions.qid=ls_questions.qid AND ls_questions.gid=g.gid ORDER BY ls_conditions.qid)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7921)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT `surveymenus`.`id` AS `t1_c0`, `surveymenus`.`parent_id` AS `t1_c1`, `surveymenus`.`survey_id` AS `t1_c2`, `surveymenus`.`user_id` AS `t1_c3`, `surveymenus`.`name` AS `t1_c4`, `surveymenus`.`ordering` AS `t1_c5`, `surveymenus`.`level` AS `t1_c6`, `surveymenus`.`title` AS `t1_c7`, `surveymenus`.`position` AS `t1_c8`, `surveymenus`.`description` AS `t1_c9`, `surveymenus`.`showincollapse` AS `t1_c10`, `surveymenus`.`active` AS `t1_c11`, `surveymenus`.`changed_at` AS `t1_c12`, `surveymenus`.`changed_by` AS `t1_c13`, `surveymenus`.`created_at` AS `t1_c14`, `surveymenus`.`created_by` AS `t1_c15` FROM `ls_surveymenu` `surveymenus` WHERE (`surveymenus`.`survey_id`=:ypl0). Bound with :ypl0='72986')	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7919)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7934)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7909)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7935 and scale_id=0 ORDER BY sortorder, answer)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM ls_questions WHERE parent_qid = 7935 and scale_id=0 ORDER BY question_order)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7908)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7929)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7905)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT q.qid, question, gid FROM ls_questions as q WHERE (select count(*) from ls_answers as a where a.qid=q.qid and scale_id=0)=0 and sid=72986 AND type IN ('F', 'H', 'W', 'Z', '1') and q.parent_qid=0)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7926)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT COUNT(*) FROM `ls_surveys` `t`)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7923)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7903)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM ls_questions WHERE parent_qid = 7923 and scale_id=0 ORDER BY question_order)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7934)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7906)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_groups` `t` WHERE `t`.`sid`=:yp0 AND `t`.`language`=:yp1 ORDER BY group_order ASC. Bound with :yp0='72986', :yp1='en')	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7915)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7918 and scale_id=0 ORDER BY sortorder, answer)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7909)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7929)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_surveymenu` `t` WHERE survey_id IS NULL AND parent_id IS NULL AND position=:position. Bound with :position='side')	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY question_order ASC. Bound with :yp0='72986', :yp1='1248', :yp2='en')	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7916 and scale_id=0 ORDER BY sortorder, answer)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_surveymenu` `t` WHERE survey_id IS NULL AND parent_id IS NULL AND position=:position. Bound with :position='top')	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7926)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_surveymenu` `t` WHERE ((survey_id=:surveyid OR survey_id IS NULL) AND (parent_id=:parentid)) AND (level=:level). Bound with :surveyid=NULL, :parentid='2', :level=1)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7925)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT COUNT(*) FROM `ls_users` `t`)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7913)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7933)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7933)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_surveymenu` `t` WHERE (((survey_id=:surveyid OR survey_id IS NULL) AND (parent_id=:parentid)) AND (level=:level)) AND (showincollapse=1). Bound with :surveyid=NULL, :parentid='3', :level=1)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_surveymenu` `t` WHERE (((survey_id=:surveyid OR survey_id IS NULL) AND (parent_id=:parentid)) AND (level=:level)) AND (showincollapse=1). Bound with :surveyid=NULL, :parentid='2', :level=1)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT qid, question, gid FROM ls_questions WHERE sid=72986 AND type = '')	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7912)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/third_party/js-cookie')	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7910)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `ls_surveymenu` `t` WHERE survey_id IS NULL AND parent_id IS NULL AND (position=:position OR showincollapse=1 ). Bound with :position='collapsed')	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT COUNT(*) FROM `ls_notifications` `t` WHERE ((entity =:sentity AND entity_id=:sentity_id) OR (entity =:uentity AND entity_id=:uentity_id)) AND (status = 'new'). Bound with :sentity='survey', :sentity_id='72986', :uentity='user', :uentity_id='1')	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7908)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7916)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_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='8', :yp1='animate_icon')	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7920)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7907)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7935)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7930)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7924)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7917)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7928)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7927)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM ls_defaultvalues as a, ls_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 = 72986)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7912)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7920)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7922)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7929 and scale_id=0 ORDER BY sortorder, answer)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7918)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7913 and scale_id=0 ORDER BY sortorder, answer)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7931)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7923)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7932)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7919)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7910)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7909 and scale_id=0 ORDER BY sortorder, answer)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_surveymenu` `t` WHERE survey_id IS NULL AND parent_id IS NULL AND position=:position. Bound with :position='bottom')	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7911)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7907)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT q.qid, question, gid FROM ls_questions as q WHERE (select count(*) from ls_answers as a where a.qid=q.qid and scale_id=1)=0 and sid=72986 AND type='1' and q.parent_qid=0)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7921)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT COUNT(*) FROM `ls_notifications` `t` WHERE (entity =:sentity AND entity_id=:sentity_id) OR (entity =:uentity AND entity_id=:uentity_id). Bound with :sentity='survey', :sentity_id='72986', :uentity='user', :uentity_id='1')	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7917)	1	0.00004	0.00004	0.00004	0.00004
system.db.CDbCommand.query(SELECT COUNT(*) FROM `ls_notifications` `t` WHERE ((entity =:sentity AND entity_id=:sentity_id) OR (entity =:uentity AND entity_id=:uentity_id)) AND (importance = 3). Bound with :sentity='survey', :sentity_id='72986', :uentity='user', :uentity_id='1')	1	0.00004	0.00004	0.00004	0.00004
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7922)	1	0.00004	0.00004	0.00004	0.00004
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7927)	1	0.00004	0.00004	0.00004	0.00004
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7918)	1	0.00004	0.00004	0.00004	0.00004
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7928)	1	0.00004	0.00004	0.00004	0.00004
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7930)	1	0.00004	0.00004	0.00004	0.00004
system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7931)	1	0.00004	0.00004	0.00004	0.00004

Profiling Summary Report (Time: 0.31265s, Memory: 7,715KB)

Procedure

Count

Total (s)

Avg. (s)

Min. (s)

Max. (s)

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_templates`)

0.00618

system.db.CDbCommand.query(SHOW TABLES)

0.00176

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_surveys`)

0.00144

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_surveys_languagesettings`)

0.00132

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_template_configuration`)

0.00109

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_settings_global`)

0.00107

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_permissions`)

0.00099

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_users`)

0.00098

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_plugins`)

0.00081

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_questions`)

0.00079

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_plugin_settings`)

0.00077

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_groups`)

0.00077

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_question_attributes`)

0.00075

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_asset_version`)

0.00069

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_surveymenu`)

0.00066

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_surveymenu_entries`)

0.00055

system.db.CDbCommand.query(SELECT * FROM `ls_settings_global` `t`)

0.00049

0.00025

0.00024

0.00025

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_tutorials`)

0.00048

system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_notifications`)

0.00047

system.db.CDbCommand.query(SELECT * FROM `ls_templates` `t` WHERE `t`.`name`='vanilla' LIMIT 1)

0.00043

0.00014

0.00009

0.00020

system.db.CDbCommand.query(SELECT * FROM `ls_users` `t` WHERE `t`.`uid`=1 LIMIT 1)

0.00043

0.00011

0.00006

0.00016

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_surveys`)

0.00031

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_templates`)

0.00029

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`.`email_admin_notification_subj` AS `t0_c21`, `t`.`email_admin_notification` AS `t0_c22`, `t`.`email_admin_responses_subj` AS `t0_c23`, `t`.`email_admin_responses` AS `t0_c24`, `t`.`surveyls_numberformat` AS `t0_c25`, `t`.`attachments` AS `t0_c26`, `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`.`faxto` AS `t1_c9`, `survey`.`format` AS `t1_c10`, `survey`.`savetimings` AS `t1_c11`, `survey`.`template` AS `t1_c12`, `survey`.`language` AS `t1_c13`, `survey`.`additional_languages` AS `t1_c14`, `survey`.`datestamp` AS `t1_c15`, `survey`.`usecookie` AS `t1_c16`, `survey`.`allowregister` AS `t1_c17`, `survey`.`allowsave` AS `t1_c18`, `survey`.`autonumber_start` AS `t1_c19`, `survey`.`autoredirect` AS `t1_c20`, `survey`.`allowprev` AS `t1_c21`, `survey`.`printanswers` AS `t1_c22`, `survey`.`ipaddr` 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` FROM `ls_surveys_languagesettings` `t` LEFT OUTER JOIN `ls_surveys` `survey` ON (t.surveyls_survey_id = survey.sid) WHERE (`t`.`surveyls_survey_id`=72986 AND `t`.`surveyls_language`='en'))

0.00029

system.db.CDbCommand.query(SELECT * FROM ls_questions as questions, `ls_groups` as question_groups WHERE questions.gid=question_groups.gid AND questions.sid=72986 AND questions.language='en' AND questions.parent_qid=0 AND question_groups.language='en' ORDER BY group_order, question_order)

0.00027

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_surveys_languagesettings`)

0.00026

system.db.CDbCommand.query(SELECT `surveymenuEntries`.`id` AS `t1_c0`, `surveymenuEntries`.`menu_id` AS `t1_c1`, `surveymenuEntries`.`user_id` AS `t1_c2`, `surveymenuEntries`.`ordering` AS `t1_c3`, `surveymenuEntries`.`name` AS `t1_c4`, `surveymenuEntries`.`title` AS `t1_c5`, `surveymenuEntries`.`menu_title` AS `t1_c6`, `surveymenuEntries`.`menu_description` AS `t1_c7`, `surveymenuEntries`.`menu_icon` AS `t1_c8`, `surveymenuEntries`.`menu_icon_type` AS `t1_c9`, `surveymenuEntries`.`menu_class` AS `t1_c10`, `surveymenuEntries`.`menu_link` AS `t1_c11`, `surveymenuEntries`.`action` AS `t1_c12`, `surveymenuEntries`.`template` AS `t1_c13`, `surveymenuEntries`.`partial` AS `t1_c14`, `surveymenuEntries`.`classes` AS `t1_c15`, `surveymenuEntries`.`permission` AS `t1_c16`, `surveymenuEntries`.`permission_grade` AS `t1_c17`, `surveymenuEntries`.`data` AS `t1_c18`, `surveymenuEntries`.`getdatamethod` AS `t1_c19`, `surveymenuEntries`.`language` AS `t1_c20`, `surveymenuEntries`.`showincollapse` AS `t1_c21`, `surveymenuEntries`.`active` AS `t1_c22`, `surveymenuEntries`.`changed_at` AS `t1_c23`, `surveymenuEntries`.`changed_by` AS `t1_c24`, `surveymenuEntries`.`created_at` AS `t1_c25`, `surveymenuEntries`.`created_by` AS `t1_c26` FROM `ls_surveymenu_entries` `surveymenuEntries` WHERE (`surveymenuEntries`.`menu_id`=:ypl0). Bound with :ypl0='2')

0.00022

0.00011

system.db.CDbCommand.query(SELECT g.gid,g.group_name,count(q.qid) as count from ls_questions as q RIGHT JOIN `ls_groups` as g ON q.gid=g.gid AND g.language=q.language WHERE g.sid=72986 AND g.language='en' group by g.gid,g.group_name;)

0.00021

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`.`email_admin_notification_subj` AS `t1_c21`, `defaultlanguage`.`email_admin_notification` AS `t1_c22`, `defaultlanguage`.`email_admin_responses_subj` AS `t1_c23`, `defaultlanguage`.`email_admin_responses` AS `t1_c24`, `defaultlanguage`.`surveyls_numberformat` AS `t1_c25`, `defaultlanguage`.`attachments` AS `t1_c26` FROM `ls_surveys_languagesettings` `defaultlanguage` WHERE (`defaultlanguage`.`surveyls_language`=:ypl0) AND (`defaultlanguage`.`surveyls_survey_id`=:ypl1). Bound with :ypl0='en', :ypl1='72986')

0.00019

0.00010

0.00009

0.00010

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_questions`)

0.00019

system.db.CDbCommand.query(SELECT * FROM `ls_surveys` `t` WHERE `t`.`sid`=72986 LIMIT 1)

0.00019

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7935)

0.00019

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`.`email_admin_notification_subj` AS `t1_c21`, `languagesettings`.`email_admin_notification` AS `t1_c22`, `languagesettings`.`email_admin_responses_subj` AS `t1_c23`, `languagesettings`.`email_admin_responses` AS `t1_c24`, `languagesettings`.`surveyls_numberformat` AS `t1_c25`, `languagesettings`.`attachments` AS `t1_c26` FROM `ls_surveys_languagesettings` `languagesettings` WHERE (`languagesettings`.`surveyls_survey_id`=:ypl0). Bound with :ypl0='72986')

0.00018

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_plugins`)

0.00018

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_permissions`)

0.00018

system.db.CDbCommand.query(SELECT * FROM `ls_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')

0.00018

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_users`)

0.00017

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_template_configuration`)

0.00017

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_question_attributes`)

0.00017

system.db.CDbCommand.query(SELECT * FROM `ls_settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion')

0.00017

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_settings_global`)

0.00016

system.db.CDbCommand.query(SELECT a.qid, a.code, a.answer, a.scale_id, a.assessment_value FROM ls_answers AS a, ls_questions as q WHERE a.qid = q.qid and q.sid = 72986 and a.language='en' and q.language='en' ORDER BY a.qid, a.scale_id, a.sortorder)

0.00016

system.db.CDbCommand.query(SELECT * FROM `ls_templates` `t` WHERE `t`.`name`='fruity' LIMIT 1)

0.00016

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_groups`)

0.00016

system.db.CDbCommand.query(SELECT * FROM `ls_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/application/core/plugins/ComfortUpdateChecker/assets')

0.00015

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`.`created` AS `t1_c12`, `owner`.`modified` AS `t1_c13` FROM `ls_users` `owner` WHERE (`owner`.`uid`=:ypl0). Bound with :ypl0='97')

0.00014

system.db.CDbCommand.query(SELECT qid, question, gid, type FROM ls_questions WHERE sid=72986 and parent_qid=0)

0.00013

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`.`faxto` AS `t0_c9`, `t`.`format` AS `t0_c10`, `t`.`savetimings` AS `t0_c11`, `t`.`template` AS `t0_c12`, `t`.`language` AS `t0_c13`, `t`.`additional_languages` AS `t0_c14`, `t`.`datestamp` AS `t0_c15`, `t`.`usecookie` AS `t0_c16`, `t`.`allowregister` AS `t0_c17`, `t`.`allowsave` AS `t0_c18`, `t`.`autonumber_start` AS `t0_c19`, `t`.`autoredirect` AS `t0_c20`, `t`.`allowprev` AS `t0_c21`, `t`.`printanswers` AS `t0_c22`, `t`.`ipaddr` 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`, `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`.`email_admin_notification_subj` AS `t1_c21`, `languagesettings`.`email_admin_notification` AS `t1_c22`, `languagesettings`.`email_admin_responses_subj` AS `t1_c23`, `languagesettings`.`email_admin_responses` AS `t1_c24`, `languagesettings`.`surveyls_numberformat` AS `t1_c25`, `languagesettings`.`attachments` AS `t1_c26` FROM `ls_surveys` `t` LEFT OUTER JOIN `ls_surveys_languagesettings` `languagesettings` ON (`languagesettings`.`surveyls_survey_id`=`t`.`sid`) WHERE (sid = :surveyid) AND (surveyls_language=language). Bound with :surveyid='72986')

0.00013

system.db.CDbCommand.query(SELECT * FROM `ls_groups` `t` WHERE sid=:sid and language=:language ORDER BY group_order. Bound with :sid='72986', :language='en')

0.00013

system.db.CDbCommand.query(SELECT * FROM `ls_plugins` `t` WHERE `t`.`active`=:yp0. Bound with :yp0=1)

0.00013

system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `ls_templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='vanilla')

0.00012

system.db.CDbCommand.query(SELECT DISTINCT qid FROM `ls_questions` `t` WHERE sid=:sid and parent_qid=0 GROUP BY qid. Bound with :sid='72986')

0.00012

system.db.CDbCommand.query(SELECT COUNT(*) FROM `ls_surveys` `t` WHERE active = 'Y')

0.00012

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_asset_version`)

0.00012

system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7926 and scale_id=0 ORDER BY sortorder, answer)

0.00012

system.db.CDbCommand.query(SELECT * FROM `ls_template_configuration` `t` WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY `t`.`template_name` LIMIT 1. Bound with :template_name='vanilla')

0.00011

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_surveymenu_entries`)

0.00011

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_surveymenu`)

0.00011

system.db.CDbCommand.query(select count(DISTINCT g.gid) from `ls_groups` g left join ls_questions q on g.gid=q.gid where g.sid=72986 and qid is not null)

0.00011

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_notifications`)

0.00010

system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7925 and scale_id=0 ORDER BY sortorder, answer)

0.00010

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7902)

0.00010

system.db.CDbCommand.query(SELECT * FROM `ls_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='8', :yp1='only_security_update')

0.00010

0.00005

0.00004

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7916)

0.00010

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7902)

0.00010

system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7930 and scale_id=0 ORDER BY sortorder, answer)

0.00010

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7904)

0.00010

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_plugin_settings`)

0.00010

system.db.CDbCommand.query(SELECT sq.*, q.other FROM ls_questions as sq, ls_questions as q WHERE sq.parent_qid=q.qid AND q.sid=72986 AND sq.language='en' AND q.language='en' ORDER BY sq.parent_qid, q.question_order,sq.scale_id , sq.question_order)

0.00009

system.db.CDbCommand.query(SHOW CREATE TABLE `ls_tutorials`)

0.00009

system.db.CDbCommand.query(SELECT * FROM `ls_tutorials` `t` WHERE active=1)

0.00009

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7904)

0.00009

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY question_order ASC. Bound with :yp0='72986', :yp1='1249', :yp2='en')

0.00009

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7905)

0.00008

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7932)

0.00008

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7914)

0.00008

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7914)

0.00008

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7911)

0.00008

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7903)

0.00008

system.db.CDbCommand.query(SELECT * FROM ls_questions WHERE sid=72986 AND type not in ('S', 'D', 'T', 'Q'))

0.00008

0.00007

system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7924 and scale_id=0 ORDER BY sortorder, answer)

0.00007

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7925)

0.00007

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7913)

0.00007

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7924)

0.00007

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7915)

0.00007

system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM ls_defaultvalues as a, ls_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 = 72986)

0.00007

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7906)

0.00007

system.db.CDbCommand.query(SELECT ls_conditions.qid, cqid, ls_questions.question, ls_questions.gid FROM ls_conditions, ls_questions, `ls_groups` g WHERE ls_questions.sid=72986 AND ls_conditions.qid=ls_questions.qid AND ls_questions.gid=g.gid ORDER BY ls_conditions.qid)

0.00007

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7921)

0.00007

system.db.CDbCommand.query(SELECT `surveymenus`.`id` AS `t1_c0`, `surveymenus`.`parent_id` AS `t1_c1`, `surveymenus`.`survey_id` AS `t1_c2`, `surveymenus`.`user_id` AS `t1_c3`, `surveymenus`.`name` AS `t1_c4`, `surveymenus`.`ordering` AS `t1_c5`, `surveymenus`.`level` AS `t1_c6`, `surveymenus`.`title` AS `t1_c7`, `surveymenus`.`position` AS `t1_c8`, `surveymenus`.`description` AS `t1_c9`, `surveymenus`.`showincollapse` AS `t1_c10`, `surveymenus`.`active` AS `t1_c11`, `surveymenus`.`changed_at` AS `t1_c12`, `surveymenus`.`changed_by` AS `t1_c13`, `surveymenus`.`created_at` AS `t1_c14`, `surveymenus`.`created_by` AS `t1_c15` FROM `ls_surveymenu` `surveymenus` WHERE (`surveymenus`.`survey_id`=:ypl0). Bound with :ypl0='72986')

0.00007

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7919)

0.00007

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7934)

0.00007

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7909)

0.00007

system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7935 and scale_id=0 ORDER BY sortorder, answer)

0.00007

system.db.CDbCommand.query(SELECT * FROM ls_questions WHERE parent_qid = 7935 and scale_id=0 ORDER BY question_order)

0.00007

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7908)

0.00007

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7929)

0.00007

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7905)

0.00007

system.db.CDbCommand.query(SELECT q.qid, question, gid FROM ls_questions as q WHERE (select count(*) from ls_answers as a where a.qid=q.qid and scale_id=0)=0 and sid=72986 AND type IN ('F', 'H', 'W', 'Z', '1') and q.parent_qid=0)

0.00007

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7926)

0.00007

system.db.CDbCommand.query(SELECT COUNT(*) FROM `ls_surveys` `t`)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7923)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7903)

0.00006

system.db.CDbCommand.query(SELECT * FROM ls_questions WHERE parent_qid = 7923 and scale_id=0 ORDER BY question_order)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7934)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7906)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_groups` `t` WHERE `t`.`sid`=:yp0 AND `t`.`language`=:yp1 ORDER BY group_order ASC. Bound with :yp0='72986', :yp1='en')

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7915)

0.00006

system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7918 and scale_id=0 ORDER BY sortorder, answer)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7909)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7929)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_surveymenu` `t` WHERE survey_id IS NULL AND parent_id IS NULL AND position=:position. Bound with :position='side')

0.00006

system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7916 and scale_id=0 ORDER BY sortorder, answer)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_surveymenu` `t` WHERE survey_id IS NULL AND parent_id IS NULL AND position=:position. Bound with :position='top')

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7926)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_surveymenu` `t` WHERE ((survey_id=:surveyid OR survey_id IS NULL) AND (parent_id=:parentid)) AND (level=:level). Bound with :surveyid=NULL, :parentid='2', :level=1)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7925)

0.00006

system.db.CDbCommand.query(SELECT COUNT(*) FROM `ls_users` `t`)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7913)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7933)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7933)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_surveymenu` `t` WHERE (((survey_id=:surveyid OR survey_id IS NULL) AND (parent_id=:parentid)) AND (level=:level)) AND (showincollapse=1). Bound with :surveyid=NULL, :parentid='3', :level=1)

0.00006

system.db.CDbCommand.query(SELECT qid, question, gid FROM ls_questions WHERE sid=72986 AND type = '')

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7912)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7910)

0.00006

system.db.CDbCommand.query(SELECT * FROM `ls_surveymenu` `t` WHERE survey_id IS NULL AND parent_id IS NULL AND (position=:position OR showincollapse=1 ). Bound with :position='collapsed')

0.00005

system.db.CDbCommand.query(SELECT COUNT(*) FROM `ls_notifications` `t` WHERE ((entity =:sentity AND entity_id=:sentity_id) OR (entity =:uentity AND entity_id=:uentity_id)) AND (status = 'new'). Bound with :sentity='survey', :sentity_id='72986', :uentity='user', :uentity_id='1')

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7908)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7916)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7920)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7907)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7935)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7930)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7924)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7917)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7928)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7927)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7912)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7920)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7922)

0.00005

system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7929 and scale_id=0 ORDER BY sortorder, answer)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7918)

0.00005

system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7913 and scale_id=0 ORDER BY sortorder, answer)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7931)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7923)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7932)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=7919)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7910)

0.00005

system.db.CDbCommand.query(SELECT * FROM ls_answers WHERE qid = 7909 and scale_id=0 ORDER BY sortorder, answer)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_surveymenu` `t` WHERE survey_id IS NULL AND parent_id IS NULL AND position=:position. Bound with :position='bottom')

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7911)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7907)

0.00005

system.db.CDbCommand.query(SELECT q.qid, question, gid FROM ls_questions as q WHERE (select count(*) from ls_answers as a where a.qid=q.qid and scale_id=1)=0 and sid=72986 AND type='1' and q.parent_qid=0)

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7921)

0.00005

system.db.CDbCommand.query(SELECT COUNT(*) FROM `ls_notifications` `t` WHERE (entity =:sentity AND entity_id=:sentity_id) OR (entity =:uentity AND entity_id=:uentity_id). Bound with :sentity='survey', :sentity_id='72986', :uentity='user', :uentity_id='1')

0.00005

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7917)

0.00004

system.db.CDbCommand.query(SELECT COUNT(*) FROM `ls_notifications` `t` WHERE ((entity =:sentity AND entity_id=:sentity_id) OR (entity =:uentity AND entity_id=:uentity_id)) AND (importance = 3). Bound with :sentity='survey', :sentity_id='72986', :uentity='user', :uentity_id='1')

0.00004

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7922)

0.00004

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7927)

0.00004

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7918)

0.00004

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7928)

0.00004

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7930)

0.00004

system.db.CDbCommand.query(SELECT * FROM `ls_question_attributes` `t` WHERE qid=:qid. Bound with :qid=7931)

0.00004