2023 ESG Questionnaire: OP Residential

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.81161s, Memory: 5,240KB)
Procedure	Count	Total (s)	Avg. (s)	Min. (s)	Max. (s)
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion')	1	0.00716	0.00716	0.00716	0.00716
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t`)	1	0.00205	0.00205	0.00205	0.00205
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugins`)	1	0.00197	0.00197	0.00197	0.00197
system.db.CDbCommand.query(SHOW TABLES)	1	0.00615	0.00615	0.00615	0.00615
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_surveys`)	1	0.00247	0.00247	0.00247	0.00247
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys`)	1	0.00079	0.00079	0.00079	0.00079
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_tokens_818397`)	1	0.00085	0.00085	0.00085	0.00085
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugins`)	1	0.00079	0.00079	0.00079	0.00079
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='fruity_twentythree' LIMIT 1)	2	0.00143	0.00072	0.00068	0.00075
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_settings_global`)	1	0.00072	0.00072	0.00072	0.00072
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groupsettings`)	1	0.00208	0.00208	0.00208	0.00208
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groups`)	1	0.00170	0.00170	0.00170	0.00170
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='default' LIMIT 1)	2	0.00140	0.00070	0.00070	0.00070
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.00098	0.00098	0.00098	0.00098
system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0 ORDER BY priority DESC. Bound with :yp0=1)	1	0.00093	0.00093	0.00093	0.00093
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groups`)	1	0.00078	0.00078	0.00078	0.00078
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groupsettings`)	1	0.00076	0.00076	0.00076	0.00076
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_templates`)	1	0.00070	0.00070	0.00070	0.00070
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.00090	0.00090	0.00090	0.00090
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_users`)	1	0.00277	0.00277	0.00277	0.00277
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_template_configuration`)	1	0.00168	0.00168	0.00168	0.00168
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_languagesettings`)	1	0.00214	0.00214	0.00214	0.00214
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groupsettings` `t` WHERE `t`.`gsid`=0 LIMIT 1)	1	0.00108	0.00108	0.00108	0.00108
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`=818397 AND `t`.`surveyls_language`='en'))	1	0.00103	0.00103	0.00103	0.00103
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.00100	0.00100	0.00100	0.00100
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_users`)	1	0.00086	0.00086	0.00086	0.00086
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_surveys_languagesettings`)	1	0.00078	0.00078	0.00078	0.00078
system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=4 LIMIT 1)	1	0.00078	0.00078	0.00078	0.00078
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_tokens_818397`)	1	0.00175	0.00175	0.00175	0.00175
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=4)	1	0.00086	0.00086	0.00086	0.00086
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_permissions`)	1	0.00246	0.00246	0.00246	0.00246
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_groups`)	1	0.00208	0.00208	0.00208	0.00208
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_templates`)	1	0.00175	0.00175	0.00175	0.00175
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groups` `t` WHERE `t`.`gsid`=1 LIMIT 1)	2	0.00156	0.00078	0.00062	0.00095
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_group_l10ns`)	1	0.00148	0.00148	0.00148	0.00148
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_group_l10ns`)	1	0.00091	0.00091	0.00091	0.00091
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_permissions`)	1	0.00076	0.00076	0.00076	0.00076
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_groups`)	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=395)	1	0.00072	0.00072	0.00072	0.00072
system.db.CDbCommand.query(SELECT * FROM `lime_groups` `t` WHERE `t`.`sid`=:yp0 ORDER BY group_order ASC. Bound with :yp0=818397)	1	0.00071	0.00071	0.00071	0.00071
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_asset_version`)	1	0.00183	0.00183	0.00183	0.00183
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=397)	1	0.00068	0.00068	0.00068	0.00068
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=398)	1	0.00077	0.00077	0.00077	0.00077
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.00213	0.00071	0.00067	0.00074
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_failed_login_attempts`)	1	0.00154	0.00154	0.00154	0.00154
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.00107	0.00107	0.00107	0.00107
system.db.CDbCommand.query(SELECT * FROM `lime_tokens_818397` `t` WHERE `t`.`token`=:yp0 LIMIT 1. Bound with :yp0='')	1	0.00082	0.00082	0.00082	0.00082
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_failed_login_attempts`)	1	0.00075	0.00075	0.00075	0.00075
system.db.CDbCommand.query(SELECT * FROM `lime_template_configuration` `t` WHERE (sid=:sid) AND (template_name=:template_name) LIMIT 1. Bound with :sid=818397, :template_name='fruity_twentythree')	1	0.00075	0.00075	0.00075	0.00075
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.00073	0.00073	0.00073	0.00073
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=396)	1	0.00070	0.00070	0.00070	0.00070
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.00069	0.00069	0.00069	0.00069
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_asset_version`)	1	0.00170	0.00170	0.00170	0.00170
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=399)	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.00071	0.00071	0.00071	0.00071
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.00082	0.00082	0.00082	0.00082
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 * FROM `lime_surveys` `t` WHERE `t`.`sid`=818397 LIMIT 1)	1	0.00071	0.00071	0.00071	0.00071

Profiling Summary Report (Time: 0.81161s, Memory: 5,240KB)

Procedure

Count

Total (s)

Avg. (s)

Min. (s)

Max. (s)

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

0.00716

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

0.00205

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

0.00197

system.db.CDbCommand.query(SHOW TABLES)

0.00615

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

0.00167

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

0.00247

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

0.00079

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

0.00085

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

0.00079

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

0.00143

0.00072

0.00068

0.00075

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

0.00072

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

0.00208

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

0.00170

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

0.00140

0.00070

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.00098

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

0.00093

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

0.00078

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

0.00076

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

0.00070

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.00090

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

0.00277

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

0.00168

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

0.00214

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

0.00108

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`=818397 AND `t`.`surveyls_language`='en'))

0.00103

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.00100

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

0.00086

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

0.00085

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

0.00078

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

0.00078

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

0.00175

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=4)

0.00086

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

0.00246

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

0.00208

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

0.00175

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

0.00156

0.00078

0.00062

0.00095

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

0.00148

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

0.00091

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

0.00076

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

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=395)

0.00072

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

0.00071

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

0.00183

0.00068

0.00077

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.00213

0.00071

0.00067

0.00074

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

0.00154

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.00107

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

0.00082

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

0.00075

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

0.00075

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.00073

0.00070

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.00069

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

0.00170

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.00071

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.00082

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 * FROM `lime_surveys` `t` WHERE `t`.`sid`=818397 LIMIT 1)

0.00071

Exit and clear survey