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.38866s, Memoire: 6,447KB)
Fonction	Nb	Total (s)	Moy. (s)	Min. (s)	Max. (s)
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugins`)	1	0.00109	0.00109	0.00109	0.00109
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_settings_global`)	1	0.00105	0.00105	0.00105	0.00105
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys`)	1	0.00102	0.00102	0.00102	0.00102
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t`)	1	0.00100	0.00100	0.00100	0.00100
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugins`)	1	0.00020	0.00020	0.00020	0.00020
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion')	1	0.00016	0.00016	0.00016	0.00016
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_surveys`)	1	0.00036	0.00036	0.00036	0.00036
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=677977 LIMIT 1)	1	0.00024	0.00024	0.00024	0.00024
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groupsettings`)	1	0.00109	0.00109	0.00109	0.00109
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_templates`)	1	0.00107	0.00107	0.00107	0.00107
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groups`)	1	0.00065	0.00065	0.00065	0.00065
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.00026	0.00026	0.00026	0.00026
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='theme_ans' LIMIT 1)	2	0.00026	0.00013	0.00011	0.00015
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_templates`)	1	0.00022	0.00022	0.00022	0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groupsettings`)	1	0.00021	0.00021	0.00021	0.00021
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groups`)	1	0.00019	0.00019	0.00019	0.00019
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.00021	0.00021	0.00021	0.00021
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_users`)	1	0.00082	0.00082	0.00082	0.00082
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_languagesettings`)	1	0.00084	0.00084	0.00084	0.00084
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_template_configuration`)	1	0.00074	0.00074	0.00074	0.00074
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.00030	0.00030	0.00030	0.00030
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groupsettings` `t` WHERE `t`.`gsid`=0 LIMIT 1)	1	0.00017	0.00017	0.00017	0.00017
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`=91 LIMIT 1)	1	0.00013	0.00013	0.00013	0.00013
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_languagesettings`)	1	0.00026	0.00026	0.00026	0.00026
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`=677977 AND `t`.`surveyls_language`='fr'))	2	0.00044	0.00022	0.00021	0.00023
system.db.CDbCommand.query(SHOW TABLES)	1	0.00315	0.00315	0.00315	0.00315
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_permissions`)	1	0.00087	0.00087	0.00087	0.00087
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_groups`)	1	0.00068	0.00068	0.00068	0.00068
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groups` `t` WHERE `t`.`gsid`=1 LIMIT 1)	3	0.00040	0.00013	0.00007	0.00018
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_groups`)	1	0.00034	0.00034	0.00034	0.00034
system.db.CDbCommand.query(SELECT * FROM `lime_groups` `t` WHERE `t`.`sid`=:yp0 ORDER BY group_order ASC. Bound with :yp0=677977)	2	0.00030	0.00015	0.00015	0.00015
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_permissions`)	1	0.00028	0.00028	0.00028	0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_users`)	1	0.00020	0.00020	0.00020	0.00020
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=91)	1	0.00012	0.00012	0.00012	0.00012
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_group_l10ns`)	1	0.00076	0.00076	0.00076	0.00076
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_group_l10ns`)	1	0.00020	0.00020	0.00020	0.00020
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=544)	3	0.00027	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=545)	3	0.00035	0.00012	0.00008	0.00019
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.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_question_themes`)	1	0.00128	0.00128	0.00128	0.00128
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.00217	0.00012	0.00008	0.00020
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE `t`.`qid` IN (0, 8217, 8218, 8272, 8219, 8220, 8221, 8222, 8223, 8224, 8225, 8226, 8227, 8228, 8229, 8230, 8231, 8232, 8233, 8234, 8235, 8236, 8237, 8238, 8239, 8240, 8241, 8242, 8243, 8244, 8245, 8246, 8247, 8248, 8249, 8250, 8251, 8252, 8253, 8254, 8255, 8256, 8257, 8258, 8259, 8260, 8261, 8262, 8263, 8264, 8265, 8266, 8267, 8268, 8269, 8270, 8271))	2	0.00064	0.00032	0.00023	0.00041
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=548)	3	0.00021	0.00007	0.00004	0.00011
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_settings_global`)	1	0.00018	0.00018	0.00018	0.00018
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_questions`)	1	0.00084	0.00084	0.00084	0.00084
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.00026	0.00009	0.00006	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=549)	3	0.00023	0.00008	0.00004	0.00010
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=553)	3	0.00022	0.00007	0.00004	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=552)	3	0.00021	0.00007	0.00004	0.00010
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=551)	3	0.00021	0.00007	0.00004	0.00011
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=550)	3	0.00020	0.00007	0.00004	0.00010
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=555)	3	0.00020	0.00007	0.00004	0.00010
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=554)	3	0.00018	0.00006	0.00004	0.00009
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='bootswatch' LIMIT 1)	2	0.00014	0.00007	0.00006	0.00008
system.db.CDbCommand.query(SELECT * FROM `lime_template_configuration` `t` WHERE (sid=:sid) AND (template_name=:template_name) LIMIT 1. Bound with :sid=677977, :template_name='theme_ans')	1	0.00010	0.00010	0.00010	0.00010
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 * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='file_upload', :extends='\|')	18	0.00203	0.00011	0.00008	0.00015
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.00009	0.00009	0.00009	0.00009
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 = 677977)	2	0.00023	0.00011	0.00009	0.00014
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=677977 AND q.parent_qid=0 ORDER BY group_order, question_order)	2	0.00097	0.00049	0.00044	0.00053
system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`parent_qid`=:yp1. Bound with :yp0=677977, :yp1=0)	2	0.00020	0.00010	0.00009	0.00010
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_questions`)	1	0.00017	0.00017	0.00017	0.00017
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=677977, :hidden_value='1')	1	0.00014	0.00014	0.00014	0.00014
system.db.CDbCommand.query(select count(*) from `lime_groups` left join lime_questions on `lime_groups`.gid=lime_questions.gid where `lime_groups`.sid=677977 and qid is null)	1	0.00008	0.00008	0.00008	0.00008
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 = 677977)	2	0.00016	0.00008	0.00008	0.00009
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_question_themes`)	1	0.00021	0.00021	0.00021	0.00021
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_question_attributes`)	1	0.00092	0.00092	0.00092	0.00092
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.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_survey_url_parameters`)	1	0.00116	0.00116	0.00116	0.00116
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE `t`.`extends`=:yp0. Bound with :yp0='')	2	0.00050	0.00025	0.00024	0.00026
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='vanilla' LIMIT 1)	2	0.00014	0.00007	0.00006	0.00008
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_question_attributes`)	1	0.00017	0.00017	0.00017	0.00017
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(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8222)	3	0.00028	0.00009	0.00007	0.00012
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.00006	0.00006	0.00006	0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8228)	3	0.00024	0.00008	0.00007	0.00009
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8230)	3	0.00030	0.00010	0.00007	0.00013
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=677977 ORDER BY sq.parent_qid, q.question_order,sq.scale_id, sq.question_order)	1	0.00023	0.00023	0.00023	0.00023
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8235)	3	0.00024	0.00008	0.00007	0.00010
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=546)	3	0.00021	0.00007	0.00005	0.00009
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8258)	3	0.00028	0.00009	0.00009	0.00010
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=547)	3	0.00027	0.00009	0.00005	0.00012
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8247)	3	0.00026	0.00009	0.00007	0.00010
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_survey_677977`)	1	0.00197	0.00197	0.00197	0.00197
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_survey_677977`)	1	0.00053	0.00053	0.00053	0.00053
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.00073	0.00012	0.00009	0.00014
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_survey_url_parameters`)	1	0.00020	0.00020	0.00020	0.00020
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.00361	0.00014	0.00007	0.00130
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE sid=:sid and parent_qid=0. Bound with :sid=677977)	1	0.00029	0.00029	0.00029	0.00029
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=677977)	1	0.00015	0.00015	0.00015	0.00015
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 =677977 and qid is not null)	2	0.00019	0.00010	0.00007	0.00013
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.00332	0.00013	0.00010	0.00017
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.00024	0.00012	0.00010	0.00014
system.db.CDbCommand.query(SELECT * FROM `lime_groups` `t` WHERE (sid=:ycp0) AND (randomization_group != ''). Bound with :ycp0=677977)	1	0.00012	0.00012	0.00012	0.00012
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=677977))	1	0.00013	0.00013	0.00013	0.00013
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.00092	0.00015	0.00010	0.00024
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.00104	0.00015	0.00011	0.00024
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.00073	0.00010	0.00008	0.00013
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.00073	0.00012	0.00009	0.00019
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8219)	1	0.00030	0.00030	0.00030	0.00030
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8221)	1	0.00017	0.00017	0.00017	0.00017
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8220)	1	0.00013	0.00013	0.00013	0.00013
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8224)	1	0.00013	0.00013	0.00013	0.00013
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8223)	1	0.00010	0.00010	0.00010	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='T', :extends='')	2	0.00020	0.00010	0.00009	0.00011
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.00016	0.00008	0.00007	0.00009
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=677977)	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=8231)	1	0.00013	0.00013	0.00013	0.00013
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8217)	1	0.00012	0.00012	0.00012	0.00012
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.00059	0.00010	0.00008	0.00013
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8218)	1	0.00026	0.00026	0.00026	0.00026
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8225)	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=8226)	1	0.00010	0.00010	0.00010	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.00023	0.00012	0.00011	0.00012
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8229)	1	0.00022	0.00022	0.00022	0.00022
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.00021	0.00010	0.00009	0.00011
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.00019	0.00009	0.00009	0.00010
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8232)	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=8236)	1	0.00011	0.00011	0.00011	0.00011
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8234)	1	0.00011	0.00011	0.00011	0.00011
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8233)	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=8238)	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=8237)	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=8239)	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=8242)	1	0.00012	0.00012	0.00012	0.00012
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8241)	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=8227)	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=8243)	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=8240)	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=8248)	1	0.00014	0.00014	0.00014	0.00014
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8251)	1	0.00022	0.00022	0.00022	0.00022
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8246)	1	0.00012	0.00012	0.00012	0.00012
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8249)	1	0.00011	0.00011	0.00011	0.00011
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8250)	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=8252)	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=8253)	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=8254)	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=8255)	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=8257)	1	0.00019	0.00019	0.00019	0.00019
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8245)	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=8259)	1	0.00011	0.00011	0.00011	0.00011
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8260)	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=8265)	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=8262)	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=8267)	1	0.00015	0.00015	0.00015	0.00015
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8256)	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=8264)	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=8261)	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=8266)	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=8269)	1	0.00012	0.00012	0.00012	0.00012
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8268)	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=8244)	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=8270)	1	0.00011	0.00011	0.00011	0.00011
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8263)	1	0.00007	0.00007	0.00007	0.00007
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_asset_version`)	1	0.00112	0.00112	0.00112	0.00112
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.00019	0.00019	0.00019	0.00019
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.00017	0.00017	0.00017	0.00017
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_asset_version`)	1	0.00015	0.00015	0.00015	0.00015
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.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 = 677977 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(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8271)	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=8272)	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.00006	0.00006	0.00006	0.00006

Sommaire du rapport de profilage (Durée: 0.38866s, Memoire: 6,447KB)

Fonction

Total (s)

Moy. (s)

Min. (s)

Max. (s)

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

0.00109

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

0.00105

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

0.00102

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

0.00100

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

0.00020

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

0.00016

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_surveys`)

0.00036

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

0.00024

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

0.00109

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

0.00107

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

0.00065

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

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

0.00026

0.00013

0.00011

0.00015

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

0.00022

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

0.00021

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

0.00019

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

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

0.00082

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

0.00084

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

0.00074

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

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

0.00017

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

0.00016

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

0.00013

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

0.00026

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

0.00044

0.00022

0.00021

0.00023

system.db.CDbCommand.query(SHOW TABLES)

0.00315

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

0.00087

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

0.00068

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

0.00040

0.00013

0.00007

0.00018

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

0.00034

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

0.00030

0.00015

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

0.00028

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

0.00020

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

0.00012

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

0.00076

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

0.00020

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

0.00027

0.00009

0.00007

0.00012

0.00035

0.00012

0.00008

0.00019

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

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

0.00128

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

0.00012

0.00008

0.00020

system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE `t`.`qid` IN (0, 8217, 8218, 8272, 8219, 8220, 8221, 8222, 8223, 8224, 8225, 8226, 8227, 8228, 8229, 8230, 8231, 8232, 8233, 8234, 8235, 8236, 8237, 8238, 8239, 8240, 8241, 8242, 8243, 8244, 8245, 8246, 8247, 8248, 8249, 8250, 8251, 8252, 8253, 8254, 8255, 8256, 8257, 8258, 8259, 8260, 8261, 8262, 8263, 8264, 8265, 8266, 8267, 8268, 8269, 8270, 8271))

0.00064

0.00032

0.00023

0.00041

0.00021

0.00007

0.00004

0.00011

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

0.00018

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

0.00084

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

0.00009

0.00006

0.00012

0.00023

0.00008

0.00004

0.00010

0.00022

0.00007

0.00004

0.00012

0.00021

0.00007

0.00004

0.00010

0.00021

0.00007

0.00004

0.00011

0.00020

0.00007

0.00004

0.00010

0.00020

0.00007

0.00004

0.00010

0.00018

0.00006

0.00004

0.00009

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

0.00014

0.00007

0.00006

0.00008

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

0.00010

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 * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='file_upload', :extends='|')

0.00203

0.00011

0.00008

0.00015

0.00009

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

0.00023

0.00011

0.00009

0.00014

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=677977 AND q.parent_qid=0 ORDER BY group_order, question_order)

0.00097

0.00049

0.00044

0.00053

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

0.00020

0.00010

0.00009

0.00010

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

0.00017

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=677977, :hidden_value='1')

0.00014

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

0.00008

0.00016

0.00008

0.00009

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

0.00021

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

0.00092

0.00007

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

0.00116

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

0.00050

0.00025

0.00024

0.00026

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

0.00014

0.00007

0.00006

0.00008

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

0.00017

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(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=8222)

0.00028

0.00009

0.00007

0.00012

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

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

0.00024

0.00008

0.00007

0.00009

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

0.00030

0.00010

0.00007

0.00013

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=677977 ORDER BY sq.parent_qid, q.question_order,sq.scale_id, sq.question_order)

0.00023

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

0.00024

0.00008

0.00007

0.00010

0.00021

0.00007

0.00005

0.00009

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

0.00028

0.00009

0.00010

0.00027

0.00009

0.00005

0.00012

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

0.00026

0.00009

0.00007

0.00010

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

0.00197

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

0.00053

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

0.00012

0.00009

0.00014

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

0.00020

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

0.00014

0.00007

0.00130

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

0.00029

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

0.00015

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 =677977 and qid is not null)

0.00019

0.00010

0.00007

0.00013

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

0.00013

0.00010

0.00017

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

0.00012

0.00010

0.00014

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

0.00012

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

0.00013

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

0.00015

0.00010

0.00024

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

0.00015

0.00011

0.00024

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

0.00010

0.00008

0.00013

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

0.00012

0.00009

0.00019

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

0.00030

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

0.00017

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

0.00013

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

0.00013

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

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='T', :extends='')

0.00020

0.00010

0.00009

0.00011

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

0.00008

0.00007

0.00009

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

0.00010

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

0.00013

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

0.00012

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

0.00010

0.00008

0.00013

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

0.00026

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

0.00008

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

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

0.00012

0.00011

0.00012

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

0.00022

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

0.00010

0.00009

0.00011

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

0.00009

0.00010

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

0.00016

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

0.00011

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

0.00011

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

0.00009

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

0.00008

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

0.00007

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

0.00009

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

0.00012

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

0.00009

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

0.00007

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

0.00008

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

0.00007

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

0.00014

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

0.00022

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

0.00012

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

0.00011

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

0.00009

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

0.00009

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

0.00008

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

0.00010

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

0.00009

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

0.00019

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

0.00008

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

0.00011

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

0.00010

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

0.00010

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

0.00009

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

0.00015

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

0.00007

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

0.00007

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

0.00007

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

0.00008

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

0.00012

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

0.00009

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

0.00007

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

0.00011

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

0.00007

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

0.00112

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

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

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

0.00015

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.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 = 677977 and l.language='fr' ORDER BY a.qid, a.scale_id, a.sortorder)

0.00009

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

0.00006

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

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