2024 Sustainability Questionnaire: Portfolio Hotel

Please enter your access code to participate in this survey.

If you have been issued an access code, please enter it in the box below and click continue.

Profiling Summary Report (Time: 0.83437s, Memory: 5,242KB)
Procedure	Count	Total (s)	Avg. (s)	Min. (s)	Max. (s)
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t`)	1	0.00219	0.00219	0.00219	0.00219
system.db.CDbCommand.query(SHOW TABLES)	1	0.00630	0.00630	0.00630	0.00630
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_settings_global`)	1	0.00167	0.00167	0.00167	0.00167
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_tokens_697649`)	1	0.00171	0.00171	0.00171	0.00171
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion')	1	0.00114	0.00114	0.00114	0.00114
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys`)	1	0.00269	0.00269	0.00269	0.00269
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groupsettings`)	1	0.00218	0.00218	0.00218	0.00218
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugins`)	1	0.00172	0.00172	0.00172	0.00172
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_templates`)	1	0.00172	0.00172	0.00172	0.00172
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groups`)	1	0.00165	0.00165	0.00165	0.00165
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='fruity_twentythree' LIMIT 1)	2	0.00162	0.00081	0.00080	0.00082
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='default' LIMIT 1)	2	0.00157	0.00079	0.00077	0.00080
system.db.CDbCommand.query(SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `lime_source_message` `t1`, `lime_message` `t2` WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language. Bound with :category='', :language='en')	1	0.00131	0.00131	0.00131	0.00131
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys`)	1	0.00096	0.00096	0.00096	0.00096
system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0 ORDER BY priority DESC. Bound with :yp0=1)	1	0.00095	0.00095	0.00095	0.00095
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=697649 LIMIT 1)	1	0.00090	0.00090	0.00090	0.00090
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groupsettings`)	1	0.00089	0.00089	0.00089	0.00089
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_templates`)	1	0.00081	0.00081	0.00081	0.00081
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groups`)	1	0.00114	0.00114	0.00114	0.00114
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_settings_global`)	1	0.00078	0.00078	0.00078	0.00078
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugins`)	1	0.00096	0.00096	0.00096	0.00096
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_template_configuration`)	1	0.00196	0.00196	0.00196	0.00196
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_languagesettings`)	1	0.00193	0.00193	0.00193	0.00193
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_users`)	1	0.00161	0.00161	0.00161	0.00161
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`, `t`.`surveyls_policy_notice` AS `t0_c24`, `t`.`surveyls_policy_error` AS `t0_c25`, `t`.`surveyls_policy_notice_label` AS `t0_c26`, `t`.`surveyls_alias` AS `t0_c27`, `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`.`format` AS `t1_c8`, `survey`.`savetimings` AS `t1_c9`, `survey`.`template` AS `t1_c10`, `survey`.`language` AS `t1_c11`, `survey`.`additional_languages` AS `t1_c12`, `survey`.`datestamp` AS `t1_c13`, `survey`.`usecookie` AS `t1_c14`, `survey`.`allowregister` AS `t1_c15`, `survey`.`allowsave` AS `t1_c16`, `survey`.`autonumber_start` AS `t1_c17`, `survey`.`autoredirect` AS `t1_c18`, `survey`.`allowprev` AS `t1_c19`, `survey`.`printanswers` AS `t1_c20`, `survey`.`ipaddr` AS `t1_c21`, `survey`.`refurl` AS `t1_c22`, `survey`.`datecreated` AS `t1_c23`, `survey`.`publicstatistics` AS `t1_c24`, `survey`.`publicgraphs` AS `t1_c25`, `survey`.`listpublic` AS `t1_c26`, `survey`.`htmlemail` AS `t1_c27`, `survey`.`sendconfirmation` AS `t1_c28`, `survey`.`tokenanswerspersistence` AS `t1_c29`, `survey`.`assessments` AS `t1_c30`, `survey`.`usecaptcha` AS `t1_c31`, `survey`.`usetokens` AS `t1_c32`, `survey`.`bounce_email` AS `t1_c33`, `survey`.`attributedescriptions` AS `t1_c34`, `survey`.`emailresponseto` AS `t1_c35`, `survey`.`emailnotificationto` AS `t1_c36`, `survey`.`tokenlength` AS `t1_c37`, `survey`.`showxquestions` AS `t1_c38`, `survey`.`showgroupinfo` AS `t1_c39`, `survey`.`shownoanswer` AS `t1_c40`, `survey`.`showqnumcode` AS `t1_c41`, `survey`.`bouncetime` AS `t1_c42`, `survey`.`bounceprocessing` AS `t1_c43`, `survey`.`bounceaccounttype` AS `t1_c44`, `survey`.`bounceaccounthost` AS `t1_c45`, `survey`.`bounceaccountpass` AS `t1_c46`, `survey`.`bounceaccountencryption` AS `t1_c47`, `survey`.`bounceaccountuser` AS `t1_c48`, `survey`.`showwelcome` AS `t1_c49`, `survey`.`showprogress` AS `t1_c50`, `survey`.`questionindex` AS `t1_c51`, `survey`.`navigationdelay` AS `t1_c52`, `survey`.`nokeyboard` AS `t1_c53`, `survey`.`alloweditaftercompletion` AS `t1_c54`, `survey`.`googleanalyticsstyle` AS `t1_c55`, `survey`.`googleanalyticsapikey` AS `t1_c56`, `survey`.`gsid` AS `t1_c57`, `survey`.`showsurveypolicynotice` AS `t1_c58`, `survey`.`tokenencryptionoptions` AS `t1_c59`, `survey`.`ipanonymize` AS `t1_c60` FROM `lime_surveys_languagesettings` `t` LEFT OUTER JOIN `lime_surveys` `survey` ON (t.surveyls_survey_id = survey.sid) WHERE (`t`.`surveyls_survey_id`=697649 AND `t`.`surveyls_language`='en'))	1	0.00107	0.00107	0.00107	0.00107
system.db.CDbCommand.query(SELECT `t`.`gsid` AS `t0_c0`, `t`.`owner_id` AS `t0_c1`, `t`.`admin` AS `t0_c2`, `t`.`adminemail` AS `t0_c3`, `t`.`anonymized` AS `t0_c4`, `t`.`format` AS `t0_c5`, `t`.`savetimings` AS `t0_c6`, `t`.`template` AS `t0_c7`, `t`.`datestamp` AS `t0_c8`, `t`.`usecookie` AS `t0_c9`, `t`.`allowregister` AS `t0_c10`, `t`.`allowsave` AS `t0_c11`, `t`.`autonumber_start` AS `t0_c12`, `t`.`autoredirect` AS `t0_c13`, `t`.`allowprev` AS `t0_c14`, `t`.`printanswers` AS `t0_c15`, `t`.`ipaddr` AS `t0_c16`, `t`.`refurl` AS `t0_c17`, `t`.`showsurveypolicynotice` AS `t0_c18`, `t`.`publicstatistics` AS `t0_c19`, `t`.`publicgraphs` AS `t0_c20`, `t`.`listpublic` AS `t0_c21`, `t`.`htmlemail` AS `t0_c22`, `t`.`sendconfirmation` AS `t0_c23`, `t`.`tokenanswerspersistence` AS `t0_c24`, `t`.`assessments` AS `t0_c25`, `t`.`usecaptcha` AS `t0_c26`, `t`.`bounce_email` AS `t0_c27`, `t`.`attributedescriptions` AS `t0_c28`, `t`.`emailresponseto` AS `t0_c29`, `t`.`emailnotificationto` AS `t0_c30`, `t`.`tokenlength` AS `t0_c31`, `t`.`showxquestions` AS `t0_c32`, `t`.`showgroupinfo` AS `t0_c33`, `t`.`shownoanswer` AS `t0_c34`, `t`.`showqnumcode` AS `t0_c35`, `t`.`showwelcome` AS `t0_c36`, `t`.`showprogress` AS `t0_c37`, `t`.`questionindex` AS `t0_c38`, `t`.`navigationdelay` AS `t0_c39`, `t`.`nokeyboard` AS `t0_c40`, `t`.`alloweditaftercompletion` AS `t0_c41`, `t`.`ipanonymize` AS `t0_c42`, `SurveysGroups`.`gsid` AS `t1_c0`, `SurveysGroups`.`name` AS `t1_c1`, `SurveysGroups`.`title` AS `t1_c2`, `SurveysGroups`.`description` AS `t1_c3`, `SurveysGroups`.`sortorder` AS `t1_c4`, `SurveysGroups`.`owner_id` AS `t1_c5`, `SurveysGroups`.`parent_id` AS `t1_c6`, `SurveysGroups`.`created` AS `t1_c7`, `SurveysGroups`.`modified` AS `t1_c8`, `SurveysGroups`.`created_by` AS `t1_c9`, `SurveysGroups`.`template` AS `t1_c10`, `SurveysGroups`.`alwaysavailable` AS `t1_c11` FROM `lime_surveys_groupsettings` `t` LEFT OUTER JOIN `lime_surveys_groups` `SurveysGroups` ON (`SurveysGroups`.`gsid`=`t`.`gsid`) WHERE (`t`.`gsid`=1))	1	0.00097	0.00097	0.00097	0.00097
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groupsettings` `t` WHERE `t`.`gsid`=0 LIMIT 1)	1	0.00095	0.00095	0.00095	0.00095
system.db.CDbCommand.query(SELECT `t`.`template_name` AS `t0_c1`, `t`.`id` AS `t0_c0`, `template`.`id` AS `t1_c0`, `template`.`folder` AS `t1_c2`, `template`.`name` AS `t1_c1` FROM `lime_template_configuration` `t` LEFT OUTER JOIN `lime_templates` `template` ON (`template`.`name`=`t`.`template_name`) WHERE (sid IS NULL AND gsid IS NULL AND template.folder IS NOT NULL))	1	0.00090	0.00090	0.00090	0.00090
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_template_configuration`)	1	0.00085	0.00085	0.00085	0.00085
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_users`)	1	0.00082	0.00082	0.00082	0.00082
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_languagesettings`)	1	0.00082	0.00082	0.00082	0.00082
system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=53 LIMIT 1)	1	0.00081	0.00081	0.00081	0.00081
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_tokens_697649`)	1	0.00079	0.00079	0.00079	0.00079
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groups` `t` WHERE `t`.`gsid`=1 LIMIT 1)	2	0.00194	0.00097	0.00071	0.00123
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_groups`)	1	0.00177	0.00177	0.00177	0.00177
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_group_l10ns`)	1	0.00147	0.00147	0.00147	0.00147
system.db.CDbCommand.query(SELECT `questiongroupl10ns`.`id` AS `t1_c0`, `questiongroupl10ns`.`gid` AS `t1_c1`, `questiongroupl10ns`.`group_name` AS `t1_c2`, `questiongroupl10ns`.`description` AS `t1_c3`, `questiongroupl10ns`.`language` AS `t1_c4` FROM `lime_group_l10ns` `questiongroupl10ns` WHERE (`questiongroupl10ns`.`gid`=:ypl0). Bound with :ypl0=667)	1	0.00090	0.00090	0.00090	0.00090
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_groups`)	1	0.00079	0.00079	0.00079	0.00079
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_permissions`)	1	0.00079	0.00079	0.00079	0.00079
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_group_l10ns`)	1	0.00077	0.00077	0.00077	0.00077
system.db.CDbCommand.query(SELECT * FROM `lime_groups` `t` WHERE `t`.`sid`=:yp0 ORDER BY group_order ASC. Bound with :yp0=697649)	1	0.00077	0.00077	0.00077	0.00077
system.db.CDbCommand.query(SELECT `questiongroupl10ns`.`id` AS `t1_c0`, `questiongroupl10ns`.`gid` AS `t1_c1`, `questiongroupl10ns`.`group_name` AS `t1_c2`, `questiongroupl10ns`.`description` AS `t1_c3`, `questiongroupl10ns`.`language` AS `t1_c4` FROM `lime_group_l10ns` `questiongroupl10ns` WHERE (`questiongroupl10ns`.`gid`=:ypl0). Bound with :ypl0=668)	1	0.00077	0.00077	0.00077	0.00077
system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/home/site/wwwroot/vendor/yiisoft/yii/framework/web/js/source')	1	0.00078	0.00078	0.00078	0.00078
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`.`dateformat` AS `t1_c10`, `owner`.`created` AS `t1_c11`, `owner`.`modified` AS `t1_c12`, `owner`.`one_time_pw` AS `t1_c13`, `owner`.`last_login` AS `t1_c14`, `owner`.`validation_key` AS `t1_c15`, `owner`.`validation_key_expiration` AS `t1_c16`, `owner`.`last_forgot_email_password` AS `t1_c17`, `owner`.`expires` AS `t1_c18`, `owner`.`user_status` AS `t1_c19` FROM `lime_users` `owner` WHERE (`owner`.`uid`=:ypl0). Bound with :ypl0=53)	1	0.00076	0.00076	0.00076	0.00076
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 `lime_templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='fruity_twentythree')	3	0.00266	0.00089	0.00076	0.00098
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_asset_version`)	1	0.00201	0.00201	0.00201	0.00201
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_permissions`)	1	0.00176	0.00176	0.00176	0.00176
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_failed_login_attempts`)	1	0.00174	0.00174	0.00174	0.00174
system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/home/site/wwwroot/node_modules/decimal.js')	1	0.00100	0.00100	0.00100	0.00100
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_failed_login_attempts`)	1	0.00086	0.00086	0.00086	0.00086
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_asset_version`)	1	0.00083	0.00083	0.00083	0.00083
system.db.CDbCommand.query(SELECT * FROM `lime_template_configuration` `t` WHERE (sid=:sid) AND (template_name=:template_name) LIMIT 1. Bound with :sid=697649, :template_name='fruity_twentythree')	1	0.00079	0.00079	0.00079	0.00079
system.db.CDbCommand.query(SELECT * FROM `lime_template_configuration` `t` WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL LIMIT 1. Bound with :template_name='fruity_twentythree')	1	0.00077	0.00077	0.00077	0.00077
system.db.CDbCommand.query(SELECT * FROM `lime_failed_login_attempts` `t` WHERE number_attempts >= :attempts AND ip = :ip AND is_frontend = :is_frontend LIMIT 1. Bound with :attempts=3, :ip='169.254.129.5', :is_frontend=true)	1	0.00077	0.00077	0.00077	0.00077
system.db.CDbCommand.query(SELECT * FROM `lime_template_configuration` `t` WHERE (gsid=:gsid) AND (template_name=:template_name) LIMIT 1. Bound with :gsid=1, :template_name='fruity_twentythree')	1	0.00076	0.00076	0.00076	0.00076
system.db.CDbCommand.query(SELECT * FROM `lime_tokens_697649` `t` WHERE `t`.`token`=:yp0 LIMIT 1. Bound with :yp0='')	1	0.00075	0.00075	0.00075	0.00075
system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/home/site/wwwroot/themes/survey/fruity_twentythree/files/favicon.ico')	1	0.00075	0.00075	0.00075	0.00075
system.db.CDbCommand.query(SELECT `questiongroupl10ns`.`id` AS `t1_c0`, `questiongroupl10ns`.`gid` AS `t1_c1`, `questiongroupl10ns`.`group_name` AS `t1_c2`, `questiongroupl10ns`.`description` AS `t1_c3`, `questiongroupl10ns`.`language` AS `t1_c4` FROM `lime_group_l10ns` `questiongroupl10ns` WHERE (`questiongroupl10ns`.`gid`=:ypl0). Bound with :ypl0=669)	1	0.00072	0.00072	0.00072	0.00072
system.db.CDbCommand.query(SELECT `questiongroupl10ns`.`id` AS `t1_c0`, `questiongroupl10ns`.`gid` AS `t1_c1`, `questiongroupl10ns`.`group_name` AS `t1_c2`, `questiongroupl10ns`.`description` AS `t1_c3`, `questiongroupl10ns`.`language` AS `t1_c4` FROM `lime_group_l10ns` `questiongroupl10ns` WHERE (`questiongroupl10ns`.`gid`=:ypl0). Bound with :ypl0=671)	1	0.00071	0.00071	0.00071	0.00071
system.db.CDbCommand.query(SELECT `questiongroupl10ns`.`id` AS `t1_c0`, `questiongroupl10ns`.`gid` AS `t1_c1`, `questiongroupl10ns`.`group_name` AS `t1_c2`, `questiongroupl10ns`.`description` AS `t1_c3`, `questiongroupl10ns`.`language` AS `t1_c4` FROM `lime_group_l10ns` `questiongroupl10ns` WHERE (`questiongroupl10ns`.`gid`=:ypl0). Bound with :ypl0=670)	1	0.00066	0.00066	0.00066	0.00066

Profiling Summary Report (Time: 0.83437s, Memory: 5,242KB)

Procedure

Count

Total (s)

Avg. (s)

Min. (s)

Max. (s)

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

0.00219

system.db.CDbCommand.query(SHOW TABLES)

0.00630

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

0.00167

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

0.00171

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

0.00114

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

0.00269

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

0.00218

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

0.00172

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

0.00172

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

0.00165

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

0.00162

0.00081

0.00080

0.00082

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

0.00157

0.00079

0.00077

0.00080

system.db.CDbCommand.query(SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `lime_source_message` `t1`, `lime_message` `t2` WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language. Bound with :category='', :language='en')

0.00131

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

0.00096

system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0 ORDER BY priority DESC. Bound with :yp0=1)

0.00095

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

0.00090

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

0.00089

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

0.00081

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

0.00114

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

0.00078

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

0.00096

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

0.00196

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

0.00193

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

0.00161

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`, `t`.`surveyls_policy_notice` AS `t0_c24`, `t`.`surveyls_policy_error` AS `t0_c25`, `t`.`surveyls_policy_notice_label` AS `t0_c26`, `t`.`surveyls_alias` AS `t0_c27`, `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`.`format` AS `t1_c8`, `survey`.`savetimings` AS `t1_c9`, `survey`.`template` AS `t1_c10`, `survey`.`language` AS `t1_c11`, `survey`.`additional_languages` AS `t1_c12`, `survey`.`datestamp` AS `t1_c13`, `survey`.`usecookie` AS `t1_c14`, `survey`.`allowregister` AS `t1_c15`, `survey`.`allowsave` AS `t1_c16`, `survey`.`autonumber_start` AS `t1_c17`, `survey`.`autoredirect` AS `t1_c18`, `survey`.`allowprev` AS `t1_c19`, `survey`.`printanswers` AS `t1_c20`, `survey`.`ipaddr` AS `t1_c21`, `survey`.`refurl` AS `t1_c22`, `survey`.`datecreated` AS `t1_c23`, `survey`.`publicstatistics` AS `t1_c24`, `survey`.`publicgraphs` AS `t1_c25`, `survey`.`listpublic` AS `t1_c26`, `survey`.`htmlemail` AS `t1_c27`, `survey`.`sendconfirmation` AS `t1_c28`, `survey`.`tokenanswerspersistence` AS `t1_c29`, `survey`.`assessments` AS `t1_c30`, `survey`.`usecaptcha` AS `t1_c31`, `survey`.`usetokens` AS `t1_c32`, `survey`.`bounce_email` AS `t1_c33`, `survey`.`attributedescriptions` AS `t1_c34`, `survey`.`emailresponseto` AS `t1_c35`, `survey`.`emailnotificationto` AS `t1_c36`, `survey`.`tokenlength` AS `t1_c37`, `survey`.`showxquestions` AS `t1_c38`, `survey`.`showgroupinfo` AS `t1_c39`, `survey`.`shownoanswer` AS `t1_c40`, `survey`.`showqnumcode` AS `t1_c41`, `survey`.`bouncetime` AS `t1_c42`, `survey`.`bounceprocessing` AS `t1_c43`, `survey`.`bounceaccounttype` AS `t1_c44`, `survey`.`bounceaccounthost` AS `t1_c45`, `survey`.`bounceaccountpass` AS `t1_c46`, `survey`.`bounceaccountencryption` AS `t1_c47`, `survey`.`bounceaccountuser` AS `t1_c48`, `survey`.`showwelcome` AS `t1_c49`, `survey`.`showprogress` AS `t1_c50`, `survey`.`questionindex` AS `t1_c51`, `survey`.`navigationdelay` AS `t1_c52`, `survey`.`nokeyboard` AS `t1_c53`, `survey`.`alloweditaftercompletion` AS `t1_c54`, `survey`.`googleanalyticsstyle` AS `t1_c55`, `survey`.`googleanalyticsapikey` AS `t1_c56`, `survey`.`gsid` AS `t1_c57`, `survey`.`showsurveypolicynotice` AS `t1_c58`, `survey`.`tokenencryptionoptions` AS `t1_c59`, `survey`.`ipanonymize` AS `t1_c60` FROM `lime_surveys_languagesettings` `t` LEFT OUTER JOIN `lime_surveys` `survey` ON (t.surveyls_survey_id = survey.sid) WHERE (`t`.`surveyls_survey_id`=697649 AND `t`.`surveyls_language`='en'))

0.00107

system.db.CDbCommand.query(SELECT `t`.`gsid` AS `t0_c0`, `t`.`owner_id` AS `t0_c1`, `t`.`admin` AS `t0_c2`, `t`.`adminemail` AS `t0_c3`, `t`.`anonymized` AS `t0_c4`, `t`.`format` AS `t0_c5`, `t`.`savetimings` AS `t0_c6`, `t`.`template` AS `t0_c7`, `t`.`datestamp` AS `t0_c8`, `t`.`usecookie` AS `t0_c9`, `t`.`allowregister` AS `t0_c10`, `t`.`allowsave` AS `t0_c11`, `t`.`autonumber_start` AS `t0_c12`, `t`.`autoredirect` AS `t0_c13`, `t`.`allowprev` AS `t0_c14`, `t`.`printanswers` AS `t0_c15`, `t`.`ipaddr` AS `t0_c16`, `t`.`refurl` AS `t0_c17`, `t`.`showsurveypolicynotice` AS `t0_c18`, `t`.`publicstatistics` AS `t0_c19`, `t`.`publicgraphs` AS `t0_c20`, `t`.`listpublic` AS `t0_c21`, `t`.`htmlemail` AS `t0_c22`, `t`.`sendconfirmation` AS `t0_c23`, `t`.`tokenanswerspersistence` AS `t0_c24`, `t`.`assessments` AS `t0_c25`, `t`.`usecaptcha` AS `t0_c26`, `t`.`bounce_email` AS `t0_c27`, `t`.`attributedescriptions` AS `t0_c28`, `t`.`emailresponseto` AS `t0_c29`, `t`.`emailnotificationto` AS `t0_c30`, `t`.`tokenlength` AS `t0_c31`, `t`.`showxquestions` AS `t0_c32`, `t`.`showgroupinfo` AS `t0_c33`, `t`.`shownoanswer` AS `t0_c34`, `t`.`showqnumcode` AS `t0_c35`, `t`.`showwelcome` AS `t0_c36`, `t`.`showprogress` AS `t0_c37`, `t`.`questionindex` AS `t0_c38`, `t`.`navigationdelay` AS `t0_c39`, `t`.`nokeyboard` AS `t0_c40`, `t`.`alloweditaftercompletion` AS `t0_c41`, `t`.`ipanonymize` AS `t0_c42`, `SurveysGroups`.`gsid` AS `t1_c0`, `SurveysGroups`.`name` AS `t1_c1`, `SurveysGroups`.`title` AS `t1_c2`, `SurveysGroups`.`description` AS `t1_c3`, `SurveysGroups`.`sortorder` AS `t1_c4`, `SurveysGroups`.`owner_id` AS `t1_c5`, `SurveysGroups`.`parent_id` AS `t1_c6`, `SurveysGroups`.`created` AS `t1_c7`, `SurveysGroups`.`modified` AS `t1_c8`, `SurveysGroups`.`created_by` AS `t1_c9`, `SurveysGroups`.`template` AS `t1_c10`, `SurveysGroups`.`alwaysavailable` AS `t1_c11` FROM `lime_surveys_groupsettings` `t` LEFT OUTER JOIN `lime_surveys_groups` `SurveysGroups` ON (`SurveysGroups`.`gsid`=`t`.`gsid`) WHERE (`t`.`gsid`=1))

0.00097

system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groupsettings` `t` WHERE `t`.`gsid`=0 LIMIT 1)

0.00095

system.db.CDbCommand.query(SELECT `t`.`template_name` AS `t0_c1`, `t`.`id` AS `t0_c0`, `template`.`id` AS `t1_c0`, `template`.`folder` AS `t1_c2`, `template`.`name` AS `t1_c1` FROM `lime_template_configuration` `t` LEFT OUTER JOIN `lime_templates` `template` ON (`template`.`name`=`t`.`template_name`) WHERE (sid IS NULL AND gsid IS NULL AND template.folder IS NOT NULL))

0.00090

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

0.00085

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

0.00082

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

0.00082

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

0.00081

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

0.00079

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

0.00194

0.00097

0.00071

0.00123

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

0.00177

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

0.00147

system.db.CDbCommand.query(SELECT `questiongroupl10ns`.`id` AS `t1_c0`, `questiongroupl10ns`.`gid` AS `t1_c1`, `questiongroupl10ns`.`group_name` AS `t1_c2`, `questiongroupl10ns`.`description` AS `t1_c3`, `questiongroupl10ns`.`language` AS `t1_c4` FROM `lime_group_l10ns` `questiongroupl10ns` WHERE (`questiongroupl10ns`.`gid`=:ypl0). Bound with :ypl0=667)

0.00090

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

0.00079

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

0.00079

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

0.00077

system.db.CDbCommand.query(SELECT * FROM `lime_groups` `t` WHERE `t`.`sid`=:yp0 ORDER BY group_order ASC. Bound with :yp0=697649)

0.00077

system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/home/site/wwwroot/vendor/yiisoft/yii/framework/web/js/source')

0.00078

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`.`dateformat` AS `t1_c10`, `owner`.`created` AS `t1_c11`, `owner`.`modified` AS `t1_c12`, `owner`.`one_time_pw` AS `t1_c13`, `owner`.`last_login` AS `t1_c14`, `owner`.`validation_key` AS `t1_c15`, `owner`.`validation_key_expiration` AS `t1_c16`, `owner`.`last_forgot_email_password` AS `t1_c17`, `owner`.`expires` AS `t1_c18`, `owner`.`user_status` AS `t1_c19` FROM `lime_users` `owner` WHERE (`owner`.`uid`=:ypl0). Bound with :ypl0=53)

0.00076

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 `lime_templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='fruity_twentythree')

0.00266

0.00089

0.00076

0.00098

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

0.00201

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

0.00176

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

0.00174

system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/home/site/wwwroot/node_modules/decimal.js')

0.00100

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

0.00086

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

0.00083

system.db.CDbCommand.query(SELECT * FROM `lime_template_configuration` `t` WHERE (sid=:sid) AND (template_name=:template_name) LIMIT 1. Bound with :sid=697649, :template_name='fruity_twentythree')

0.00079

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

0.00077

system.db.CDbCommand.query(SELECT * FROM `lime_failed_login_attempts` `t` WHERE number_attempts >= :attempts AND ip = :ip AND is_frontend = :is_frontend LIMIT 1. Bound with :attempts=3, :ip='169.254.129.5', :is_frontend=true)

0.00077

system.db.CDbCommand.query(SELECT * FROM `lime_template_configuration` `t` WHERE (gsid=:gsid) AND (template_name=:template_name) LIMIT 1. Bound with :gsid=1, :template_name='fruity_twentythree')

0.00076

system.db.CDbCommand.query(SELECT * FROM `lime_tokens_697649` `t` WHERE `t`.`token`=:yp0 LIMIT 1. Bound with :yp0='')

0.00075

system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/home/site/wwwroot/themes/survey/fruity_twentythree/files/favicon.ico')

0.00075

0.00072

0.00071

0.00066

Exit and clear survey