Attention : l’exécution de JavaScript est désactivée dans votre navigateur ou sur ce site. Vous risquez de ne pas pouvoir répondre à toutes les questions. Veuillez vérifier les paramètres de votre navigateur.

G_NIUS : Demande de création d'un(e) actualité / évènement

Bienvenue cher partenaire ! Complétez ce formulaire afin d'envoyer une demande de création d'actualité ou d'évènement sur G_NIUS, le Guichet National Innovation et Usage e-Santé.

Sommaire du rapport de profilage (Durée: 0.28211s, Memoire: 7,972KB)
Fonction	Nb	Total (s)	Moy. (s)	Min. (s)	Max. (s)
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys`)	1	0.00104	0.00104	0.00104	0.00104
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_settings_global`)	1	0.00087	0.00087	0.00087	0.00087
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t`)	1	0.00079	0.00079	0.00079	0.00079
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugins`)	1	0.00076	0.00076	0.00076	0.00076
system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0 ORDER BY priority DESC. Bound with :yp0=1)	1	0.00014	0.00014	0.00014	0.00014
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugins`)	1	0.00013	0.00013	0.00013	0.00013
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion')	1	0.00012	0.00012	0.00012	0.00012
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys`)	1	0.00021	0.00021	0.00021	0.00021
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=781528 LIMIT 1)	1	0.00020	0.00020	0.00020	0.00020
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_templates`)	1	0.00065	0.00065	0.00065	0.00065
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groupsettings`)	1	0.00113	0.00113	0.00113	0.00113
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groups`)	1	0.00068	0.00068	0.00068	0.00068
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='ANS_minimal' LIMIT 1)	3	0.00030	0.00010	0.00009	0.00011
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='fr')	1	0.00020	0.00020	0.00020	0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groupsettings`)	1	0.00018	0.00018	0.00018	0.00018
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groups`)	1	0.00018	0.00018	0.00018	0.00018
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='theme_ans' LIMIT 1)	2	0.00016	0.00008	0.00006	0.00010
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_templates`)	1	0.00013	0.00013	0.00013	0.00013
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`.`template` AS `t1_c3`, `SurveysGroups`.`description` AS `t1_c4`, `SurveysGroups`.`sortorder` AS `t1_c5`, `SurveysGroups`.`owner_id` AS `t1_c6`, `SurveysGroups`.`parent_id` AS `t1_c7`, `SurveysGroups`.`created` AS `t1_c8`, `SurveysGroups`.`modified` AS `t1_c9`, `SurveysGroups`.`created_by` 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.00016	0.00016	0.00016	0.00016
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_users`)	1	0.00060	0.00060	0.00060	0.00060
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_languagesettings`)	1	0.00066	0.00066	0.00066	0.00066
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_template_configuration`)	1	0.00055	0.00055	0.00055	0.00055
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_template_configuration`)	1	0.00016	0.00016	0.00016	0.00016
system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=68 LIMIT 1)	1	0.00016	0.00016	0.00016	0.00016
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groupsettings` `t` WHERE `t`.`gsid`=0 LIMIT 1)	1	0.00013	0.00013	0.00013	0.00013
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.00012	0.00012	0.00012	0.00012
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_languagesettings`)	1	0.00017	0.00017	0.00017	0.00017
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`, `t`.`surveyls_alias` AS `t0_c27`, `survey`.`sid` AS `t1_c0`, `survey`.`owner_id` AS `t1_c1`, `survey`.`gsid` AS `t1_c2`, `survey`.`admin` AS `t1_c3`, `survey`.`active` AS `t1_c4`, `survey`.`expires` AS `t1_c5`, `survey`.`startdate` AS `t1_c6`, `survey`.`adminemail` AS `t1_c7`, `survey`.`anonymized` AS `t1_c8`, `survey`.`format` AS `t1_c9`, `survey`.`savetimings` AS `t1_c10`, `survey`.`template` AS `t1_c11`, `survey`.`language` AS `t1_c12`, `survey`.`additional_languages` AS `t1_c13`, `survey`.`datestamp` AS `t1_c14`, `survey`.`usecookie` AS `t1_c15`, `survey`.`allowregister` AS `t1_c16`, `survey`.`allowsave` AS `t1_c17`, `survey`.`autonumber_start` AS `t1_c18`, `survey`.`autoredirect` AS `t1_c19`, `survey`.`allowprev` AS `t1_c20`, `survey`.`printanswers` AS `t1_c21`, `survey`.`ipaddr` AS `t1_c22`, `survey`.`refurl` AS `t1_c23`, `survey`.`datecreated` AS `t1_c24`, `survey`.`showsurveypolicynotice` AS `t1_c25`, `survey`.`publicstatistics` AS `t1_c26`, `survey`.`publicgraphs` AS `t1_c27`, `survey`.`listpublic` AS `t1_c28`, `survey`.`htmlemail` AS `t1_c29`, `survey`.`sendconfirmation` AS `t1_c30`, `survey`.`tokenanswerspersistence` AS `t1_c31`, `survey`.`assessments` AS `t1_c32`, `survey`.`usecaptcha` AS `t1_c33`, `survey`.`usetokens` AS `t1_c34`, `survey`.`bounce_email` AS `t1_c35`, `survey`.`attributedescriptions` AS `t1_c36`, `survey`.`emailresponseto` AS `t1_c37`, `survey`.`emailnotificationto` AS `t1_c38`, `survey`.`tokenlength` AS `t1_c39`, `survey`.`showxquestions` AS `t1_c40`, `survey`.`showgroupinfo` AS `t1_c41`, `survey`.`shownoanswer` AS `t1_c42`, `survey`.`showqnumcode` AS `t1_c43`, `survey`.`bouncetime` AS `t1_c44`, `survey`.`bounceprocessing` AS `t1_c45`, `survey`.`bounceaccounttype` AS `t1_c46`, `survey`.`bounceaccounthost` AS `t1_c47`, `survey`.`bounceaccountpass` AS `t1_c48`, `survey`.`bounceaccountencryption` AS `t1_c49`, `survey`.`bounceaccountuser` AS `t1_c50`, `survey`.`showwelcome` AS `t1_c51`, `survey`.`showprogress` AS `t1_c52`, `survey`.`questionindex` AS `t1_c53`, `survey`.`navigationdelay` AS `t1_c54`, `survey`.`nokeyboard` AS `t1_c55`, `survey`.`alloweditaftercompletion` AS `t1_c56`, `survey`.`googleanalyticsstyle` AS `t1_c57`, `survey`.`googleanalyticsapikey` AS `t1_c58`, `survey`.`tokenencryptionoptions` AS `t1_c59`, `survey`.`ipanonymize` AS `t1_c60`, `survey`.`access_mode` AS `t1_c61`, `survey`.`lastmodified` AS `t1_c62` FROM `lime_surveys_languagesettings` `t` LEFT OUTER JOIN `lime_surveys` `survey` ON (t.surveyls_survey_id = survey.sid) WHERE (`t`.`surveyls_survey_id`=781528 AND `t`.`surveyls_language`='fr'))	2	0.00045	0.00023	0.00021	0.00024
system.db.CDbCommand.query(SHOW TABLES)	1	0.00264	0.00264	0.00264	0.00264
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_group_l10ns`)	1	0.00083	0.00083	0.00083	0.00083
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_permissions`)	1	0.00063	0.00063	0.00063	0.00063
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_groups`)	1	0.00082	0.00082	0.00082	0.00082
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_settings_global`)	1	0.00042	0.00042	0.00042	0.00042
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groups` `t` WHERE `t`.`gsid`=1 LIMIT 1)	3	0.00034	0.00011	0.00009	0.00013
system.db.CDbCommand.query(SELECT * FROM `lime_groups` `t` WHERE `t`.`sid`=:yp0 ORDER BY group_order ASC. Bound with :yp0=781528)	2	0.00025	0.00012	0.00011	0.00013
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_groups`)	1	0.00017	0.00017	0.00017	0.00017
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`, `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=68)	1	0.00012	0.00012	0.00012	0.00012
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_permissions`)	1	0.00012	0.00012	0.00012	0.00012
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_group_l10ns`)	1	0.00017	0.00017	0.00017	0.00017
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=269)	3	0.00045	0.00015	0.00007	0.00025
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=270)	3	0.00033	0.00011	0.00007	0.00017
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_survey_url_parameters`)	1	0.00066	0.00066	0.00066	0.00066
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_users`)	1	0.00015	0.00015	0.00015	0.00015
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=271)	3	0.00020	0.00007	0.00006	0.00008
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='theme_ans')	3	0.00031	0.00010	0.00008	0.00014
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=273)	3	0.00020	0.00007	0.00006	0.00008
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_questions`)	1	0.00085	0.00085	0.00085	0.00085
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=274)	3	0.00017	0.00006	0.00005	0.00006
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=279)	3	0.00019	0.00006	0.00004	0.00009
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='bootswatch' LIMIT 1)	2	0.00019	0.00010	0.00006	0.00013
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=275)	3	0.00019	0.00006	0.00004	0.00009
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=280)	3	0.00017	0.00006	0.00004	0.00007
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=278)	3	0.00017	0.00006	0.00004	0.00007
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=276)	3	0.00017	0.00006	0.00004	0.00007
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=277)	3	0.00015	0.00005	0.00004	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='vanilla' LIMIT 1)	2	0.00015	0.00008	0.00006	0.00009
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='bootswatch')	1	0.00011	0.00011	0.00011	0.00011
system.db.CDbCommand.query(SELECT * FROM `lime_template_configuration` `t` WHERE (sid=:sid) AND (template_name=:template_name) LIMIT 1. Bound with :sid=781528, :template_name='theme_ans')	1	0.00009	0.00009	0.00009	0.00009
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='vanilla')	1	0.00008	0.00008	0.00008	0.00008
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='vanilla')	1	0.00008	0.00008	0.00008	0.00008
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='theme_ans')	1	0.00008	0.00008	0.00008	0.00008
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='theme_ans')	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_questions`)	1	0.00014	0.00014	0.00014	0.00014
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='bootswatch')	1	0.00010	0.00010	0.00010	0.00010
system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`parent_qid`=:yp1. Bound with :yp0=781528, :yp1=0)	2	0.00019	0.00010	0.00009	0.00010
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='\|', :extends='')	18	0.00151	0.00008	0.00006	0.00012
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='file_upload', :extends='\|')	18	0.00158	0.00009	0.00007	0.00012
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=272)	3	0.00019	0.00006	0.00005	0.00007
system.db.CDbCommand.query(select count(*) from `lime_groups` left join lime_questions on `lime_groups`.gid=lime_questions.gid where `lime_groups`.sid=781528 and qid is null)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT g., q., gls., qls. FROM `lime_groups` g JOIN lime_questions q on q.gid=g.gid JOIN lime_group_l10ns gls on gls.gid=g.gid JOIN lime_question_l10ns qls on qls.qid=q.qid WHERE qls.language='fr' and gls.language='fr' AND g.sid=781528 AND q.parent_qid=0 ORDER BY group_order, question_order)	2	0.00092	0.00046	0.00045	0.00047
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_question_themes`)	1	0.00077	0.00077	0.00077	0.00077
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE `t`.`qid` IN (0, 5284, 5285, 6199, 5286, 5287, 5288, 5289, 5290, 5291, 5292, 5293, 5294, 5295, 5296, 5297, 5298, 5299, 5300, 5301, 5302, 5303, 5304, 5305, 5306, 5307, 5308, 5309, 5310, 5311, 5312, 5313, 5314, 5315, 5316, 5317, 5318, 5319, 5320, 5321, 5322, 5323, 5324, 5325, 5326, 5327, 5328, 5329, 5330, 5331, 5332, 5333, 5334, 5335, 5336, 5337, 5338))	2	0.00060	0.00030	0.00027	0.00034
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE `t`.`extends`=:yp0. Bound with :yp0='')	2	0.00049	0.00025	0.00020	0.00029
system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, a.specialtype, al10.defaultvalue FROM lime_defaultvalues as a JOIN lime_defaultvalue_l10ns as al10 ON a.dvid = al10.dvid JOIN lime_questions as b ON a.qid = b.qid AND al10.language = 'fr' AND b.same_default=1 AND b.sid = 781528)	2	0.00028	0.00014	0.00006	0.00023
system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, a.specialtype, al10.defaultvalue FROM lime_defaultvalues as a JOIN lime_defaultvalue_l10ns as al10 ON a.dvid = al10.dvid JOIN lime_questions as b ON a.qid = b.qid AND al10.language = 'fr' AND b.same_default=0 AND b.sid = 781528)	2	0.00021	0.00010	0.00010	0.00011
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5297)	3	0.00020	0.00007	0.00006	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5289)	3	0.00018	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5295)	3	0.00017	0.00006	0.00005	0.00006
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_question_themes`)	1	0.00014	0.00014	0.00014	0.00014
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_question_attributes`)	1	0.00061	0.00061	0.00061	0.00061
system.db.CDbCommand.query(SELECT sq.*, ls.question, q.other FROM lime_questions as sq JOIN lime_questions as q on sq.parent_qid=q.qid JOIN lime_question_l10ns as ls on ls.qid=sq.qid WHERE sq.parent_qid=q.qid AND ls.language='fr' AND q.sid=781528 ORDER BY sq.parent_qid, q.question_order,sq.scale_id, sq.question_order)	1	0.00016	0.00016	0.00016	0.00016
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5302)	3	0.00021	0.00007	0.00006	0.00008
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_question_attributes`)	1	0.00010	0.00010	0.00010	0.00010
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5325)	3	0.00017	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT COUNT(DISTINCT t.qid) as count FROM `lime_questions` `t` LEFT JOIN `lime_question_attributes` `qa` ON qa.qid = t.qid AND qa.attribute = :hidden WHERE (t.sid = :sid AND t.parent_qid = 0) AND (qa.value IS NULL OR qa.value != :hidden_value). Bound with :hidden='hidden', :sid=781528, :hidden_value='1')	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5314)	3	0.00017	0.00006	0.00005	0.00006
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_survey_781528`)	1	0.00139	0.00139	0.00139	0.00139
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_survey_781528`)	1	0.00039	0.00039	0.00039	0.00039
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='list_dropdown', :extends='!')	7	0.00067	0.00010	0.00007	0.00011
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_survey_url_parameters`)	1	0.00012	0.00012	0.00012	0.00012
system.db.CDbCommand.query(select count(DISTINCT `lime_groups`.gid) from `lime_groups` left join lime_questions on `lime_groups`.gid=lime_questions.gid where `lime_groups`.sid =781528 and qid is not null)	2	0.00014	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='L', :extends='')	6	0.00047	0.00008	0.00006	0.00012
system.db.CDbCommand.query(SELECT * FROM `lime_groups` `t` WHERE (sid=:ycp0) AND (randomization_group != ''). Bound with :ycp0=781528)	1	0.00011	0.00011	0.00011	0.00011
system.db.CDbCommand.query(SELECT `t`.`qid` AS `t0_c0`, `t`.`parent_qid` AS `t0_c1`, `t`.`sid` AS `t0_c2`, `t`.`gid` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`title` AS `t0_c5`, `t`.`preg` AS `t0_c6`, `t`.`other` AS `t0_c7`, `t`.`mandatory` AS `t0_c8`, `t`.`question_order` AS `t0_c9`, `t`.`scale_id` AS `t0_c10`, `t`.`same_default` AS `t0_c11`, `t`.`relevance` AS `t0_c12`, `t`.`modulename` AS `t0_c13`, `t`.`encrypted` AS `t0_c14`, `t`.`question_theme_name` AS `t0_c15`, `t`.`same_script` AS `t0_c16`, `questionattributes`.`qaid` AS `t1_c0`, `questionattributes`.`qid` AS `t1_c1`, `questionattributes`.`attribute` AS `t1_c2`, `questionattributes`.`value` AS `t1_c3`, `questionattributes`.`language` AS `t1_c4` FROM `lime_questions` `t` LEFT OUTER JOIN `lime_question_attributes` `questionattributes` ON (`questionattributes`.`qid`=`t`.`qid`) WHERE (attribute='random_group' and value <>'' and sid=781528))	1	0.00018	0.00018	0.00018	0.00018
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='shortfreetext', :extends='S')	25	0.00317	0.00013	0.00008	0.00019
system.db.CDbCommand.query(select '' as act, up.*,q.title, sq.title as sqtitle from lime_survey_url_parameters up left join lime_questions q on q.qid=up.targetqid left join lime_questions sq on q.qid=up.targetsqid where up.sid=:surveyid. Bound with :surveyid=781528)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='S', :extends='')	25	0.00188	0.00008	0.00006	0.00012
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='listradio', :extends='L')	6	0.00061	0.00010	0.00008	0.00012
system.db.CDbCommand.query(SELECT `groups`.`gid` AS `t1_c0`, `groups`.`sid` AS `t1_c1`, `groups`.`group_order` AS `t1_c2`, `groups`.`randomization_group` AS `t1_c3`, `groups`.`grelevance` AS `t1_c4` FROM `lime_groups` `groups` WHERE (`groups`.`sid`=:ypl0) ORDER BY groups.group_order ASC. Bound with :ypl0=781528)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='date', :extends='D')	6	0.00051	0.00009	0.00007	0.00010
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE sid=:sid and parent_qid=0. Bound with :sid=781528)	1	0.00016	0.00016	0.00016	0.00016
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='D', :extends='')	6	0.00050	0.00008	0.00006	0.00017
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='T', :extends='')	2	0.00013	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5285)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='!', :extends='')	7	0.00050	0.00007	0.00006	0.00010
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='multiplechoice', :extends='M')	2	0.00018	0.00009	0.00009	0.00009
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='longfreetext', :extends='T')	2	0.00029	0.00015	0.00013	0.00016
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5309)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5310)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5303)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5304)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5299)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5284)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5306)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='M', :extends='')	2	0.00014	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5298)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5307)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='yesno', :extends='Y')	2	0.00015	0.00008	0.00007	0.00008
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5300)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='Y', :extends='')	2	0.00014	0.00007	0.00006	0.00008
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5308)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5294)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5305)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5296)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5293)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5301)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5292)	1	0.00011	0.00011	0.00011	0.00011
system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/var/www/limesurvey/upload/themes/survey/theme_ans/files/LOGO_ANS_2020_Principal.png')	1	0.00009	0.00009	0.00009	0.00009
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5291)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5286)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5287)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5288)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5316)	1	0.00016	0.00016	0.00016	0.00016
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5319)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5315)	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/var/www/limesurvey/node_modules/decimal.js')	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5320)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5322)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5324)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5311)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5313)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5323)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5312)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5317)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5321)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5318)	1	0.00005	0.00005	0.00005	0.00005
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5326)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5328)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5290)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_asset_version`)	1	0.00013	0.00013	0.00013	0.00013
system.db.CDbCommand.query(SELECT a.qid, a.code, l.answer, a.scale_id, a.assessment_value FROM lime_answers AS a JOIN lime_questions q on a.qid=q.qid JOIN lime_answer_l10ns l on l.aid=a.aid WHERE 1=1 and a.qid = q.qid and q.sid = 781528 and l.language='fr' ORDER BY a.qid, a.scale_id, a.sortorder)	1	0.00009	0.00009	0.00009	0.00009
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_asset_version`)	1	0.00084	0.00084	0.00084	0.00084
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5336)	1	0.00009	0.00009	0.00009	0.00009
system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/var/www/limesurvey/themes/survey/vanilla/files/favicon.ico')	1	0.00008	0.00008	0.00008	0.00008
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5337)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=6199)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5334)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5331)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5335)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5333)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5338)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5330)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5332)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5329)	1	0.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/var/www/limesurvey/vendor/yiisoft/yii/framework/web/js/source')	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=5327)	1	0.00006	0.00006	0.00006	0.00006

Sommaire du rapport de profilage (Durée: 0.28211s, Memoire: 7,972KB)

Fonction

Total (s)

Moy. (s)

Min. (s)

Max. (s)

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

0.00104

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

0.00087

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

0.00079

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

0.00076

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

0.00014

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

0.00013

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

0.00012

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

0.00021

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

0.00020

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

0.00065

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

0.00113

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

0.00068

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

0.00030

0.00010

0.00009

0.00011

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='fr')

0.00020

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

0.00018

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

0.00018

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

0.00016

0.00008

0.00006

0.00010

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

0.00013

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`.`template` AS `t1_c3`, `SurveysGroups`.`description` AS `t1_c4`, `SurveysGroups`.`sortorder` AS `t1_c5`, `SurveysGroups`.`owner_id` AS `t1_c6`, `SurveysGroups`.`parent_id` AS `t1_c7`, `SurveysGroups`.`created` AS `t1_c8`, `SurveysGroups`.`modified` AS `t1_c9`, `SurveysGroups`.`created_by` 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.00016

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

0.00060

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

0.00066

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

0.00055

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

0.00016

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

0.00016

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

0.00013

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

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

0.00017

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

0.00045

0.00023

0.00021

0.00024

system.db.CDbCommand.query(SHOW TABLES)

0.00264

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

0.00083

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

0.00063

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

0.00082

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

0.00042

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

0.00034

0.00011

0.00009

0.00013

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

0.00025

0.00012

0.00011

0.00013

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

0.00017

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`, `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=68)

0.00012

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

0.00012

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

0.00017

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

0.00045

0.00015

0.00007

0.00025

0.00033

0.00011

0.00007

0.00017

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

0.00066

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

0.00015

0.00020

0.00007

0.00006

0.00008

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='theme_ans')

0.00031

0.00010

0.00008

0.00014

0.00020

0.00007

0.00006

0.00008

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

0.00085

0.00017

0.00006

0.00005

0.00006

0.00019

0.00006

0.00004

0.00009

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

0.00019

0.00010

0.00006

0.00013

0.00019

0.00006

0.00004

0.00009

0.00017

0.00006

0.00004

0.00007

0.00017

0.00006

0.00004

0.00007

0.00017

0.00006

0.00004

0.00007

0.00015

0.00005

0.00004

0.00007

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

0.00015

0.00008

0.00006

0.00009

0.00011

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

0.00009

0.00008

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='vanilla')

0.00008

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='theme_ans')

0.00008

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='theme_ans')

0.00006

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

0.00014

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='bootswatch')

0.00010

system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`parent_qid`=:yp1. Bound with :yp0=781528, :yp1=0)

0.00019

0.00010

0.00009

0.00010

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='|', :extends='')

0.00151

0.00008

0.00006

0.00012

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='file_upload', :extends='|')

0.00158

0.00009

0.00007

0.00012

0.00019

0.00006

0.00005

0.00007

system.db.CDbCommand.query(select count(*) from `lime_groups` left join lime_questions on `lime_groups`.gid=lime_questions.gid where `lime_groups`.sid=781528 and qid is null)

0.00008

system.db.CDbCommand.query(SELECT g.*, q.*, gls.*, qls.* FROM `lime_groups` g JOIN lime_questions q on q.gid=g.gid JOIN lime_group_l10ns gls on gls.gid=g.gid JOIN lime_question_l10ns qls on qls.qid=q.qid WHERE qls.language='fr' and gls.language='fr' AND g.sid=781528 AND q.parent_qid=0 ORDER BY group_order, question_order)

0.00092

0.00046

0.00045

0.00047

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

0.00077

system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE `t`.`qid` IN (0, 5284, 5285, 6199, 5286, 5287, 5288, 5289, 5290, 5291, 5292, 5293, 5294, 5295, 5296, 5297, 5298, 5299, 5300, 5301, 5302, 5303, 5304, 5305, 5306, 5307, 5308, 5309, 5310, 5311, 5312, 5313, 5314, 5315, 5316, 5317, 5318, 5319, 5320, 5321, 5322, 5323, 5324, 5325, 5326, 5327, 5328, 5329, 5330, 5331, 5332, 5333, 5334, 5335, 5336, 5337, 5338))

0.00060

0.00030

0.00027

0.00034

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE `t`.`extends`=:yp0. Bound with :yp0='')

0.00049

0.00025

0.00020

0.00029

system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, a.specialtype, al10.defaultvalue FROM lime_defaultvalues as a JOIN lime_defaultvalue_l10ns as al10 ON a.dvid = al10.dvid JOIN lime_questions as b ON a.qid = b.qid AND al10.language = 'fr' AND b.same_default=1 AND b.sid = 781528)

0.00028

0.00014

0.00006

0.00023

0.00021

0.00010

0.00011

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

0.00020

0.00007

0.00006

0.00007

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

0.00018

0.00006

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

0.00017

0.00006

0.00005

0.00006

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

0.00014

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

0.00061

system.db.CDbCommand.query(SELECT sq.*, ls.question, q.other FROM lime_questions as sq JOIN lime_questions as q on sq.parent_qid=q.qid JOIN lime_question_l10ns as ls on ls.qid=sq.qid WHERE sq.parent_qid=q.qid AND ls.language='fr' AND q.sid=781528 ORDER BY sq.parent_qid, q.question_order,sq.scale_id, sq.question_order)

0.00016

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

0.00021

0.00007

0.00006

0.00008

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

0.00010

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

0.00017

0.00006

system.db.CDbCommand.query(SELECT COUNT(DISTINCT t.qid) as count FROM `lime_questions` `t` LEFT JOIN `lime_question_attributes` `qa` ON qa.qid = t.qid AND qa.attribute = :hidden WHERE (t.sid = :sid AND t.parent_qid = 0) AND (qa.value IS NULL OR qa.value != :hidden_value). Bound with :hidden='hidden', :sid=781528, :hidden_value='1')

0.00007

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

0.00017

0.00006

0.00005

0.00006

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

0.00139

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

0.00039

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='list_dropdown', :extends='!')

0.00067

0.00010

0.00007

0.00011

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

0.00012

system.db.CDbCommand.query(select count(DISTINCT `lime_groups`.gid) from `lime_groups` left join lime_questions on `lime_groups`.gid=lime_questions.gid where `lime_groups`.sid =781528 and qid is not null)

0.00014

0.00007

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='L', :extends='')

0.00047

0.00008

0.00006

0.00012

system.db.CDbCommand.query(SELECT * FROM `lime_groups` `t` WHERE (sid=:ycp0) AND (randomization_group != ''). Bound with :ycp0=781528)

0.00011

system.db.CDbCommand.query(SELECT `t`.`qid` AS `t0_c0`, `t`.`parent_qid` AS `t0_c1`, `t`.`sid` AS `t0_c2`, `t`.`gid` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`title` AS `t0_c5`, `t`.`preg` AS `t0_c6`, `t`.`other` AS `t0_c7`, `t`.`mandatory` AS `t0_c8`, `t`.`question_order` AS `t0_c9`, `t`.`scale_id` AS `t0_c10`, `t`.`same_default` AS `t0_c11`, `t`.`relevance` AS `t0_c12`, `t`.`modulename` AS `t0_c13`, `t`.`encrypted` AS `t0_c14`, `t`.`question_theme_name` AS `t0_c15`, `t`.`same_script` AS `t0_c16`, `questionattributes`.`qaid` AS `t1_c0`, `questionattributes`.`qid` AS `t1_c1`, `questionattributes`.`attribute` AS `t1_c2`, `questionattributes`.`value` AS `t1_c3`, `questionattributes`.`language` AS `t1_c4` FROM `lime_questions` `t` LEFT OUTER JOIN `lime_question_attributes` `questionattributes` ON (`questionattributes`.`qid`=`t`.`qid`) WHERE (attribute='random_group' and value <>'' and sid=781528))

0.00018

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='shortfreetext', :extends='S')

0.00317

0.00013

0.00008

0.00019

system.db.CDbCommand.query(select '' as act, up.*,q.title, sq.title as sqtitle from lime_survey_url_parameters up left join lime_questions q on q.qid=up.targetqid left join lime_questions sq on q.qid=up.targetsqid where up.sid=:surveyid. Bound with :surveyid=781528)

0.00008

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='S', :extends='')

0.00188

0.00008

0.00006

0.00012

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='listradio', :extends='L')

0.00061

0.00010

0.00008

0.00012

system.db.CDbCommand.query(SELECT `groups`.`gid` AS `t1_c0`, `groups`.`sid` AS `t1_c1`, `groups`.`group_order` AS `t1_c2`, `groups`.`randomization_group` AS `t1_c3`, `groups`.`grelevance` AS `t1_c4` FROM `lime_groups` `groups` WHERE (`groups`.`sid`=:ypl0) ORDER BY groups.group_order ASC. Bound with :ypl0=781528)

0.00008

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='date', :extends='D')

0.00051

0.00009

0.00007

0.00010

system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE sid=:sid and parent_qid=0. Bound with :sid=781528)

0.00016

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='D', :extends='')

0.00050

0.00008

0.00006

0.00017

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='T', :extends='')

0.00013

0.00007

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

0.00007

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='!', :extends='')

0.00050

0.00007

0.00006

0.00010

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='multiplechoice', :extends='M')

0.00018

0.00009

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='longfreetext', :extends='T')

0.00029

0.00015

0.00013

0.00016

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

0.00007

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

0.00006

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

0.00008

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

0.00007

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

0.00007

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

0.00006

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

0.00005

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='M', :extends='')

0.00014

0.00007

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

0.00008

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

0.00006

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='yesno', :extends='Y')

0.00015

0.00008

0.00007

0.00008

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

0.00006

system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='Y', :extends='')

0.00014

0.00007

0.00006

0.00008

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

0.00007

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

0.00006

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

0.00006

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

0.00005

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

0.00007

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

0.00006

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

0.00011

system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/var/www/limesurvey/upload/themes/survey/theme_ans/files/LOGO_ANS_2020_Principal.png')

0.00009

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

0.00008

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

0.00008

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

0.00008

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

0.00006

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

0.00016

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

0.00008

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

0.00008

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

0.00007

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

0.00007

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

0.00007

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

0.00007

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

0.00006

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

0.00006

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

0.00006

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

0.00006

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

0.00006

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

0.00006

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

0.00005

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

0.00007

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

0.00006

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

0.00006

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

0.00013

system.db.CDbCommand.query(SELECT a.qid, a.code, l.answer, a.scale_id, a.assessment_value FROM lime_answers AS a JOIN lime_questions q on a.qid=q.qid JOIN lime_answer_l10ns l on l.aid=a.aid WHERE 1=1 and a.qid = q.qid and q.sid = 781528 and l.language='fr' ORDER BY a.qid, a.scale_id, a.sortorder)

0.00009

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

0.00084

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

0.00009

system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/var/www/limesurvey/themes/survey/vanilla/files/favicon.ico')

0.00008

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

0.00007

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

0.00007

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

0.00006

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

0.00006

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

0.00006

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

0.00006

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

0.00006

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

0.00006

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

0.00006

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

0.00006

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

0.00007

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

0.00006