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