View Issue Details

This bug affects 1 person(s).
 0
IDProjectCategoryView StatusLast Update
18474Bug reportsSurvey editingpublic2022-11-09 13:39
ReporterDenisChenu Assigned To 
PrioritynormalSeveritytweak 
Status newResolutionopen 
Product Version5.4.x 
Summary18474: Survey summary multiple call of same request
Description

Survey sumary show a lot of CDbCommand with same request call

Steps To Reproduce

Steps to reproduce

Activate SQL debug mode
Import https://github.com/LimeSurvey/LimeSurvey/blob/3.x-LTS/docs/demosurveys/ls3_sample_survey_multilingual_fr_de_en_it.lss
Check SQL request at bottom on survey summary

Expected result

Some request call 2/3 times

Actual result

Lot of request call related to theme

TagsNo tags attached.
Bug heat0
Complete LimeSurvey version number (& build)5.4.10
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionmariadb
Server OS (if known)debian
Webserver software & version (if known)nginx
PHP Version7.4

Users monitoring this issue

User List There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2022-11-09 10:15

developer  

3X_summary.png (539,164 bytes)
5x_summary.png (597,086 bytes)
3X_bunchofplugins_ls3_sample_summary_partial.txt (9,332 bytes)   
system.db.CDbCommand.query(select count(DISTINCT g.gid) from `lime_groups` g left join lime_questions q on g.gid=q.gid where g.sid=513678 and qid is not null) 	3 	0.04597 	0.01532 	0.01511 	0.01547
system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`parent_qid`=:yp1 AND `t`.`language`=:yp2. Bound with :yp0='513678', :yp1=0, :yp2='en') 	2 	0.00503 	0.00251 	0.00247 	0.00256
system.db.CDbCommand.query(SELECT COUNT(DISTINCT `t`.`cid`) FROM `lime_conditions` `t` LEFT OUTER JOIN `lime_questions` `questions` ON (t.cqid = questions.qid) WHERE (sid =513678)) 	1 	0.00484 	0.00484 	0.00484 	0.00484
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY question_order ASC. Bound with :yp0='513678', :yp1='993', :yp2='en') 	1 	0.00220 	0.00220 	0.00220 	0.00220
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY question_order ASC. Bound with :yp0='513678', :yp1='994', :yp2='en') 	1 	0.00136 	0.00136 	0.00136 	0.00136
system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`template_name`, `t`.`sid`, `t`.`gsid`, `t`.`uid`, `t`.`files_css`, `t`.`files_js`, `t`.`files_print_css`, `t`.`options`, `t`.`cssframework_name`, `t`.`cssframework_css`, `t`.`cssframework_js`, `t`.`packages_to_load`, `t`.`packages_ltr`, `t`.`packages_rtl` FROM `lime_template_configuration` `t` INNER JOIN lime_templates AS template ON `t`.`template_name` = template.name WHERE ((t.sid IS NULL) AND (t.gsid IS NULL)) AND (template.name IS NOT NULL) ORDER BY `t`.`template_name`) 	1 	0.00134 	0.00134 	0.00134 	0.00134
system.db.CDbCommand.query(SELECT * FROM `lime_groups` `t` WHERE sid=:surveyid AND language=:language ORDER BY group_order. Bound with :surveyid='513678', :language='en') 	2 	0.00125 	0.00063 	0.00063 	0.00063
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='copie_fruity' LIMIT 1) 	3 	0.00123 	0.00041 	0.00035 	0.00046
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY question_order ASC. Bound with :yp0='513678', :yp1='992', :yp2='en') 	1 	0.00119 	0.00119 	0.00119 	0.00119
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY question_order ASC. Bound with :yp0='513678', :yp1='991', :yp2='en') 	1 	0.00119 	0.00119 	0.00119 	0.00119
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='vanilla' LIMIT 1) 	4 	0.00114 	0.00028 	0.00024 	0.00034
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY question_order ASC. Bound with :yp0='513678', :yp1='995', :yp2='en') 	1 	0.00114 	0.00114 	0.00114 	0.00114
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_permissions`) 	1 	0.00110 	0.00110 	0.00110 	0.00110
system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_groups` `t` WHERE `t`.`sid`=:yp0 AND `t`.`language`=:yp1. Bound with :yp0='513678', :yp1='en') 	2 	0.00109 	0.00055 	0.00054 	0.00056
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY question_order ASC. Bound with :yp0='513678', :yp1='996', :yp2='en') 	1 	0.00101 	0.00101 	0.00101 	0.00101
system.db.CDbCommand.query(SELECT * FROM `lime_groups` `t` WHERE `t`.`sid`=:yp0 AND `t`.`language`=:yp1 ORDER BY group_order. Bound with :yp0=513678, :yp1='en') 	2 	0.00100 	0.00050 	0.00046 	0.00054
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='advantages' LIMIT 1) 	4 	0.00094 	0.00024 	0.00019 	0.00031
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='pasteur' LIMIT 1) 	3 	0.00093 	0.00031 	0.00028 	0.00034
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='copie_vanilla' LIMIT 1) 	3 	0.00093 	0.00031 	0.00028 	0.00035
system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1) 	4 	0.00091 	0.00023 	0.00015 	0.00031
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='skelvanilla' LIMIT 1) 	4 	0.00091 	0.00023 	0.00019 	0.00027
system.db.CDbCommand.query(SELECT `surveymenuEntries`.`id` AS `t1_c0`, `surveymenuEntries`.`menu_id` AS `t1_c1`, `surveymenuEntries`.`user_id` AS `t1_c2`, `surveymenuEntries`.`ordering` AS `t1_c3`, `surveymenuEntries`.`name` AS `t1_c4`, `surveymenuEntries`.`title` AS `t1_c5`, `surveymenuEntries`.`menu_title` AS `t1_c6`, `surveymenuEntries`.`menu_description` AS `t1_c7`, `surveymenuEntries`.`menu_icon` AS `t1_c8`, `surveymenuEntries`.`menu_icon_type` AS `t1_c9`, `surveymenuEntries`.`menu_class` AS `t1_c10`, `surveymenuEntries`.`menu_link` AS `t1_c11`, `surveymenuEntries`.`action` AS `t1_c12`, `surveymenuEntries`.`template` AS `t1_c13`, `surveymenuEntries`.`partial` AS `t1_c14`, `surveymenuEntries`.`classes` AS `t1_c15`, `surveymenuEntries`.`permission` AS `t1_c16`, `surveymenuEntries`.`permission_grade` AS `t1_c17`, `surveymenuEntries`.`data` AS `t1_c18`, `surveymenuEntries`.`getdatamethod` AS `t1_c19`, `surveymenuEntries`.`language` AS `t1_c20`, `surveymenuEntries`.`showincollapse` AS `t1_c21`, `surveymenuEntries`.`active` AS `t1_c22`, `surveymenuEntries`.`changed_at` AS `t1_c23`, `surveymenuEntries`.`changed_by` AS `t1_c24`, `surveymenuEntries`.`created_at` AS `t1_c25`, `surveymenuEntries`.`created_by` AS `t1_c26` FROM `lime_surveymenu_entries` `surveymenuEntries` WHERE (`surveymenuEntries`.`menu_id`=:ypl0). Bound with :ypl0='1') 	2 	0.00089 	0.00045 	0.00032 	0.00058
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='ofdt' LIMIT 1) 	3 	0.00088 	0.00029 	0.00023 	0.00037
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='èè vanilla -- -ù' LIMIT 1) 	3 	0.00087 	0.00029 	0.00028 	0.00030
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') 	3 	0.00082 	0.00027 	0.00024 	0.00031
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='VINCI_CooHA' LIMIT 1) 	3 	0.00082 	0.00027 	0.00024 	0.00029
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='edg_2016' LIMIT 1) 	3 	0.00082 	0.00027 	0.00025 	0.00030
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='oecd_CTP_TaxCrime' LIMIT 1) 	3 	0.00082 	0.00027 	0.00023 	0.00031
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='PINE_skelvanilla' LIMIT 1) 	3 	0.00080 	0.00027 	0.00027 	0.00027
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='PINE_menu_skelvanilla' LIMIT 1) 	3 	0.00080 	0.00027 	0.00024 	0.00029
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='bootswatch' LIMIT 1) 	3 	0.00080 	0.00027 	0.00019 	0.00032
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='fruity' LIMIT 1) 	3 	0.00079 	0.00026 	0.00021 	0.00029
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='ut3' LIMIT 1) 	3 	0.00078 	0.00026 	0.00024 	0.00029
system.db.CDbCommand.query(SELECT `surveymenuEntries`.`id` AS `t1_c0`, `surveymenuEntries`.`menu_id` AS `t1_c1`, `surveymenuEntries`.`user_id` AS `t1_c2`, `surveymenuEntries`.`ordering` AS `t1_c3`, `surveymenuEntries`.`name` AS `t1_c4`, `surveymenuEntries`.`title` AS `t1_c5`, `surveymenuEntries`.`menu_title` AS `t1_c6`, `surveymenuEntries`.`menu_description` AS `t1_c7`, `surveymenuEntries`.`menu_icon` AS `t1_c8`, `surveymenuEntries`.`menu_icon_type` AS `t1_c9`, `surveymenuEntries`.`menu_class` AS `t1_c10`, `surveymenuEntries`.`menu_link` AS `t1_c11`, `surveymenuEntries`.`action` AS `t1_c12`, `surveymenuEntries`.`template` AS `t1_c13`, `surveymenuEntries`.`partial` AS `t1_c14`, `surveymenuEntries`.`classes` AS `t1_c15`, `surveymenuEntries`.`permission` AS `t1_c16`, `surveymenuEntries`.`permission_grade` AS `t1_c17`, `surveymenuEntries`.`data` AS `t1_c18`, `surveymenuEntries`.`getdatamethod` AS `t1_c19`, `surveymenuEntries`.`language` AS `t1_c20`, `surveymenuEntries`.`showincollapse` AS `t1_c21`, `surveymenuEntries`.`active` AS `t1_c22`, `surveymenuEntries`.`changed_at` AS `t1_c23`, `surveymenuEntries`.`changed_by` AS `t1_c24`, `surveymenuEntries`.`created_at` AS `t1_c25`, `surveymenuEntries`.`created_by` AS `t1_c26` FROM `lime_surveymenu_entries` `surveymenuEntries` WHERE (`surveymenuEntries`.`menu_id`=:ypl0). Bound with :ypl0='2') 	2 	0.00077 	0.00038 	0.00037 	0.00040
5X_ls3_sample_summary_partial.txt (11,837 bytes)   
ystem.db.CDbCommand.query(SELECT `t`.`id`, `t`.`template_name`, `t`.`sid`, `t`.`gsid`, `t`.`uid`, `t`.`files_css`, `t`.`files_js`, `t`.`files_print_css`, `t`.`options`, `t`.`cssframework_name`, `t`.`cssframework_css`, `t`.`cssframework_js`, `t`.`packages_to_load`, `t`.`packages_ltr`, `t`.`packages_rtl` FROM `lime_template_configuration` `t` INNER JOIN lime_templates AS template ON `t`.`template_name` = template.name WHERE ((t.sid IS NULL) AND (t.gsid IS NULL)) AND (template.name IS NOT NULL) ORDER BY `t`.`template_name`) 	28 	0.03189 	0.00114 	0.00094 	0.00138
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='skelvanilla') 	30 	0.00934 	0.00031 	0.00020 	0.00046
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='fruity2') 	28 	0.00919 	0.00033 	0.00023 	0.00050
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='extends_extends_skelvanilla_accessibility') 	28 	0.00901 	0.00032 	0.00025 	0.00051
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='extends_bootswatch') 	28 	0.00890 	0.00032 	0.00020 	0.00051
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') 	28 	0.00869 	0.00031 	0.00016 	0.00043
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='copie_vanilla') 	28 	0.00865 	0.00031 	0.00019 	0.00049
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') 	29 	0.00848 	0.00029 	0.00018 	0.00043
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='skelvanilla_fixedtable') 	28 	0.00843 	0.00030 	0.00020 	0.00039
system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `lime_templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='fruity') 	28 	0.00833 	0.00030 	0.00020 	0.00044
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='extends_skelvanilla') 	28 	0.00833 	0.00030 	0.00020 	0.00048
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='extends_vanilla') 	28 	0.00817 	0.00029 	0.00019 	0.00050
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 =282267 and qid is not null) 	3 	0.00378 	0.00126 	0.00124 	0.00128
system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1) 	11 	0.00253 	0.00023 	0.00012 	0.00033
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`.`ipanonymize` AS `t0_c17`, `t`.`refurl` AS `t0_c18`, `t`.`showsurveypolicynotice` AS `t0_c19`, `t`.`publicstatistics` AS `t0_c20`, `t`.`publicgraphs` AS `t0_c21`, `t`.`listpublic` AS `t0_c22`, `t`.`htmlemail` AS `t0_c23`, `t`.`sendconfirmation` AS `t0_c24`, `t`.`tokenanswerspersistence` AS `t0_c25`, `t`.`assessments` AS `t0_c26`, `t`.`usecaptcha` AS `t0_c27`, `t`.`bounce_email` AS `t0_c28`, `t`.`attributedescriptions` AS `t0_c29`, `t`.`emailresponseto` AS `t0_c30`, `t`.`emailnotificationto` AS `t0_c31`, `t`.`tokenlength` AS `t0_c32`, `t`.`showxquestions` AS `t0_c33`, `t`.`showgroupinfo` AS `t0_c34`, `t`.`shownoanswer` AS `t0_c35`, `t`.`showqnumcode` AS `t0_c36`, `t`.`showwelcome` AS `t0_c37`, `t`.`showprogress` AS `t0_c38`, `t`.`questionindex` AS `t0_c39`, `t`.`navigationdelay` AS `t0_c40`, `t`.`nokeyboard` AS `t0_c41`, `t`.`alloweditaftercompletion` 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`.`alwaysavailable` AS `t1_c8`, `SurveysGroups`.`created` AS `t1_c9`, `SurveysGroups`.`modified` AS `t1_c10`, `SurveysGroups`.`created_by` AS `t1_c11` FROM `lime_surveys_groupsettings` `t` LEFT OUTER JOIN `lime_surveys_groups` `SurveysGroups` ON (`SurveysGroups`.`gsid`=`t`.`gsid`) WHERE (`t`.`gsid`=1)) 	5 	0.00203 	0.00041 	0.00038 	0.00046

Issue History

Date Modified Username Field Change
2022-11-09 10:15 DenisChenu New Issue
2022-11-09 10:15 DenisChenu File Added: 3X_summary.png
2022-11-09 10:15 DenisChenu File Added: 5x_summary.png
2022-11-09 10:15 DenisChenu File Added: 3X_bunchofplugins_ls3_sample_summary_partial.txt
2022-11-09 10:15 DenisChenu File Added: 5X_ls3_sample_summary_partial.txt
2022-11-09 13:39 ollehar Priority none => normal
2022-11-09 13:39 ollehar Severity partial_block => tweak