18474: Survey summary multiple call of same request - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

18474	Bug reports	Survey editing	public	2022-11-09 10:15	2024-11-14 10:38

Reporter	DenisChenu	Assigned To	DenisChenu
Priority	normal	Severity	tweak
Status	closed	Resolution	fixed
Product Version	5.4.x
Fixed in Version	6.4.x

Summary	18474: 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
Tags	No tags attached.
Attached Files	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 3X_bunchofplugins_ls3_sample_summary_partial.txt (9,332 bytes) 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 5X_ls3_sample_summary_partial.txt (11,837 bytes)

Bug heat	0
Complete LimeSurvey version number (& build)	5.4.10
I will donate to the project if issue is resolved	No
Browser	not relevant
Database type & version	mariadb
Server OS (if known)	debian
Webserver software & version (if known)	nginx
PHP Version	7.4

User List	There are no users monitoring this issue.

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
2024-11-14 10:38	DenisChenu	Assigned To	=> DenisChenu
2024-11-14 10:38	DenisChenu	Status	new => closed
2024-11-14 10:38	DenisChenu	Resolution	open => fixed
2024-11-14 10:38	DenisChenu	Fixed in Version	=> 6.4.x

View Issue Details

Steps to reproduce

Expected result

Actual result

Users monitoring this issue

Activities

Issue History