|
I see reference to 'vanilla' at bottom.
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_questions ) 1 0.02983 0.02983 0.02983 0.02983
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_groups ) 1 0.02941 0.02941 0.02941 0.02941
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_settings_global ) 1 0.02019 0.02019 0.02019 0.02019
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_templates ) 1 0.01952 0.01952 0.01952 0.01952
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_surveymenu_entries ) 1 0.01763 0.01763 0.01763 0.01763
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_conditions ) 1 0.01638 0.01638 0.01638 0.01638
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_users ) 1 0.01427 0.01427 0.01427 0.01427
system.db.CDbCommand.query(SHOW CREATE TABLE lime_surveys ) 1 0.00868 0.00868 0.00868 0.00868
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_surveys ) 1 0.00829 0.00829 0.00829 0.00829
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_permissions ) 1 0.00709 0.00709 0.00709 0.00709
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_surveys_groups ) 1 0.00703 0.00703 0.00703 0.00703
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_plugins ) 1 0.00675 0.00675 0.00675 0.00675
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_surveys_languagesettings ) 1 0.00674 0.00674 0.00674 0.00674
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_notifications ) 1 0.00577 0.00577 0.00577 0.00577
system.db.CDbCommand.query(SHOW TABLES) 1 0.00485 0.00485 0.00485 0.00485
system.db.CDbCommand.query(SELECT FROM lime_groups t WHERE sid=:surveyid AND language=:language ORDER BY group_order. Bound with :surveyid='922181', :language='en') 2 0.00097 0.00049 0.00022 0.00076
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_url AS t0_c6 , t .surveyls_urldescription AS t0_c7 , t .surveyls_email_invite_subj AS t0_c8 , t .surveyls_email_invite AS t0_c9 , t .surveyls_email_remind_subj AS t0_c10 , t .surveyls_email_remind AS t0_c11 , t .surveyls_email_register_subj AS t0_c12 , t .surveyls_email_register AS t0_c13 , t .surveyls_email_confirm_subj AS t0_c14 , t .surveyls_email_confirm AS t0_c15 , t .surveyls_dateformat AS t0_c16 , t .surveyls_attributecaptions AS t0_c17 , t .email_admin_notification_subj AS t0_c18 , t .email_admin_notification AS t0_c19 , t .email_admin_responses_subj AS t0_c20 , t .email_admin_responses AS t0_c21 , t .surveyls_numberformat AS t0_c22 , t .attachments AS t0_c23 , 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 .faxto AS t1_c9 , survey .format AS t1_c10 , survey .savetimings AS t1_c11 , survey .template AS t1_c12 , survey .language AS t1_c13 , survey .additional_languages AS t1_c14 , survey .datestamp AS t1_c15 , survey .usecookie AS t1_c16 , survey .allowregister AS t1_c17 , survey .allowsave AS t1_c18 , survey .autonumber_start AS t1_c19 , survey .autoredirect AS t1_c20 , survey .allowprev AS t1_c21 , survey .printanswers AS t1_c22 , survey .ipaddr AS t1_c23 , survey .refurl AS t1_c24 , survey .datecreated 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 FROM lime_surveys_languagesettings t LEFT OUTER JOIN lime_surveys survey ON (t.surveyls_survey_id = survey.sid) WHERE (t .surveyls_survey_id =922181 AND t .surveyls_language ='en')) 1 0.00095 0.00095 0.00095 0.00095
system.db.CDbCommand.query(SELECT FROM lime_settings_global t WHERE t .stg_name ='googleanalyticsapikey' LIMIT 1) 3 0.00089 0.00030 0.00020 0.00037
system.db.CDbCommand.query(SELECT defaultlanguage .surveyls_survey_id AS t1_c0 , defaultlanguage .surveyls_language AS t1_c1 , defaultlanguage .surveyls_title AS t1_c2 , defaultlanguage .surveyls_description AS t1_c3 , defaultlanguage .surveyls_welcometext AS t1_c4 , defaultlanguage .surveyls_endtext AS t1_c5 , defaultlanguage .surveyls_url AS t1_c6 , defaultlanguage .surveyls_urldescription AS t1_c7 , defaultlanguage .surveyls_email_invite_subj AS t1_c8 , defaultlanguage .surveyls_email_invite AS t1_c9 , defaultlanguage .surveyls_email_remind_subj AS t1_c10 , defaultlanguage .surveyls_email_remind AS t1_c11 , defaultlanguage .surveyls_email_register_subj AS t1_c12 , defaultlanguage .surveyls_email_register AS t1_c13 , defaultlanguage .surveyls_email_confirm_subj AS t1_c14 , defaultlanguage .surveyls_email_confirm AS t1_c15 , defaultlanguage .surveyls_dateformat AS t1_c16 , defaultlanguage .surveyls_attributecaptions AS t1_c17 , defaultlanguage .email_admin_notification_subj AS t1_c18 , defaultlanguage .email_admin_notification AS t1_c19 , defaultlanguage .email_admin_responses_subj AS t1_c20 , defaultlanguage .email_admin_responses AS t1_c21 , defaultlanguage .surveyls_numberformat AS t1_c22 , defaultlanguage .attachments AS t1_c23 FROM lime_surveys_languagesettings defaultlanguage WHERE (defaultlanguage .surveyls_language =:ypl0) AND (defaultlanguage .surveyls_survey_id =:ypl1). Bound with :ypl0='en', :ypl1='922181') 2 0.00079 0.00039 0.00032 0.00046
system.db.CDbCommand.query(SELECT FROM lime_templates t WHERE t .name ='monochrome' LIMIT 1) 2 0.00078 0.00039 0.00032 0.00045
system.db.CDbCommand.query(SELECT t .sid AS t0_c0 , t .owner_id AS t0_c1 , t .gsid AS t0_c2 , t .admin AS t0_c3 , t .active AS t0_c4 , t .expires AS t0_c5 , t .startdate AS t0_c6 , t .adminemail AS t0_c7 , t .anonymized AS t0_c8 , t .faxto AS t0_c9 , t .format AS t0_c10 , t .savetimings AS t0_c11 , t .template AS t0_c12 , t .language AS t0_c13 , t .additional_languages AS t0_c14 , t .datestamp AS t0_c15 , t .usecookie AS t0_c16 , t .allowregister AS t0_c17 , t .allowsave AS t0_c18 , t .autonumber_start AS t0_c19 , t .autoredirect AS t0_c20 , t .allowprev AS t0_c21 , t .printanswers AS t0_c22 , t .ipaddr AS t0_c23 , t .refurl AS t0_c24 , t .datecreated AS t0_c25 , t .publicstatistics AS t0_c26 , t .publicgraphs AS t0_c27 , t .listpublic AS t0_c28 , t .htmlemail AS t0_c29 , t .sendconfirmation AS t0_c30 , t .tokenanswerspersistence AS t0_c31 , t .assessments AS t0_c32 , t .usecaptcha AS t0_c33 , t .usetokens AS t0_c34 , t .bounce_email AS t0_c35 , t .attributedescriptions AS t0_c36 , t .emailresponseto AS t0_c37 , t .emailnotificationto AS t0_c38 , t .tokenlength AS t0_c39 , t .showxquestions AS t0_c40 , t .showgroupinfo AS t0_c41 , t .shownoanswer AS t0_c42 , t .showqnumcode AS t0_c43 , t .bouncetime AS t0_c44 , t .bounceprocessing AS t0_c45 , t .bounceaccounttype AS t0_c46 , t .bounceaccounthost AS t0_c47 , t .bounceaccountpass AS t0_c48 , t .bounceaccountencryption AS t0_c49 , t .bounceaccountuser AS t0_c50 , t .showwelcome AS t0_c51 , t .showprogress AS t0_c52 , t .questionindex AS t0_c53 , t .navigationdelay AS t0_c54 , t .nokeyboard AS t0_c55 , t .alloweditaftercompletion AS t0_c56 , t .googleanalyticsstyle AS t0_c57 , t .googleanalyticsapikey AS t0_c58 , languagesettings .surveyls_survey_id AS t1_c0 , languagesettings .surveyls_language AS t1_c1 , languagesettings .surveyls_title AS t1_c2 , languagesettings .surveyls_description AS t1_c3 , languagesettings .surveyls_welcometext AS t1_c4 , languagesettings .surveyls_endtext AS t1_c5 , languagesettings .surveyls_url AS t1_c6 , languagesettings .surveyls_urldescription AS t1_c7 , languagesettings .surveyls_email_invite_subj AS t1_c8 , languagesettings .surveyls_email_invite AS t1_c9 , languagesettings .surveyls_email_remind_subj AS t1_c10 , languagesettings .surveyls_email_remind AS t1_c11 , languagesettings .surveyls_email_register_subj AS t1_c12 , languagesettings .surveyls_email_register AS t1_c13 , languagesettings .surveyls_email_confirm_subj AS t1_c14 , languagesettings .surveyls_email_confirm AS t1_c15 , languagesettings .surveyls_dateformat AS t1_c16 , languagesettings .surveyls_attributecaptions AS t1_c17 , languagesettings .email_admin_notification_subj AS t1_c18 , languagesettings .email_admin_notification AS t1_c19 , languagesettings .email_admin_responses_subj AS t1_c20 , languagesettings .email_admin_responses AS t1_c21 , languagesettings .surveyls_numberformat AS t1_c22 , languagesettings .attachments AS t1_c23 FROM lime_surveys t LEFT OUTER JOIN lime_surveys_languagesettings languagesettings ON (languagesettings .surveyls_survey_id =t .sid ) WHERE (sid = :surveyid) AND (surveyls_language=language). Bound with :surveyid='922181') 1 0.00076 0.00076 0.00076 0.00076
system.db.CDbCommand.query(SELECT FROM lime_surveys t WHERE t .sid =922181 LIMIT 1) 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SHOW CREATE TABLE lime_surveys_languagesettings ) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW CREATE TABLE lime_surveymenu_entries ) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SELECT FROM lime_permissions t WHERE t .entity_id =:yp0 AND t .entity =:yp1 AND t .uid =:yp2 AND t .permission =:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=1, :yp3='superadmin') 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SELECT COUNT() FROM lime_notifications t WHERE ((entity =:sentity AND entity_id=:sentity_id) OR (entity =:uentity AND entity_id=:uentity_id)) AND (importance = 3). Bound with :sentity='survey', :sentity_id='922181', :uentity='user', :uentity_id='1') 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SELECT languagesettings .surveyls_survey_id AS t1_c0 , languagesettings .surveyls_language AS t1_c1 , languagesettings .surveyls_title AS t1_c2 , languagesettings .surveyls_description AS t1_c3 , languagesettings .surveyls_welcometext AS t1_c4 , languagesettings .surveyls_endtext AS t1_c5 , languagesettings .surveyls_url AS t1_c6 , languagesettings .surveyls_urldescription AS t1_c7 , languagesettings .surveyls_email_invite_subj AS t1_c8 , languagesettings .surveyls_email_invite AS t1_c9 , languagesettings .surveyls_email_remind_subj AS t1_c10 , languagesettings .surveyls_email_remind AS t1_c11 , languagesettings .surveyls_email_register_subj AS t1_c12 , languagesettings .surveyls_email_register AS t1_c13 , languagesettings .surveyls_email_confirm_subj AS t1_c14 , languagesettings .surveyls_email_confirm AS t1_c15 , languagesettings .surveyls_dateformat AS t1_c16 , languagesettings .surveyls_attributecaptions AS t1_c17 , languagesettings .email_admin_notification_subj AS t1_c18 , languagesettings .email_admin_notification AS t1_c19 , languagesettings .email_admin_responses_subj AS t1_c20 , languagesettings .email_admin_responses AS t1_c21 , languagesettings .surveyls_numberformat AS t1_c22 , languagesettings .attachments AS t1_c23 FROM lime_surveys_languagesettings languagesettings WHERE (languagesettings .surveyls_survey_id =:ypl0). Bound with :ypl0='922181') 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SELECT FROM lime_surveys_groups t ) 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SELECT FROM lime_settings_global t ) 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SELECT t .uid , t .users_name , t .password , t .full_name , t .parent_id , t .lang , t .email , t .htmleditormode , t .templateeditormode , t .questionselectormode , t .one_time_pw , t .dateformat , t .created , t .modified FROM lime_users t JOIN lime_permissions AS p ON p.uid = t.uid WHERE p.permission = 'superadmin') 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SELECT COUNT() FROM lime_groups t WHERE t .sid =:yp0 AND t .language =:yp1. Bound with :yp0='922181', :yp1='en') 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SELECT FROM lime_surveymenu_entries t WHERE name=:name LIMIT 1. Bound with :name='generalsettings') 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE lime_notifications ) 1 0.00043 0.00043 0.00043 0.00043
system.db.CDbCommand.query(SELECT FROM lime_users ORDER BY uid) 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SHOW CREATE TABLE lime_templates ) 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SELECT FROM lime_groups t WHERE t .sid =:yp0 AND t .language =:yp1 ORDER BY group_order. Bound with :yp0='922181', :yp1='en') 2 0.00042 0.00021 0.00018 0.00023
system.db.CDbCommand.query(SHOW CREATE TABLE lime_settings_global ) 1 0.00041 0.00041 0.00041 0.00041
system.db.CDbCommand.query(SHOW CREATE TABLE lime_plugins ) 1 0.00040 0.00040 0.00040 0.00040
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='922181', :yp1=0, :yp2='en') 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT FROM lime_templates t WHERE t .name ='default' LIMIT 1) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT FROM lime_plugins t WHERE t .active =:yp0. Bound with :yp0=1) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT COUNT() FROM lime_notifications t WHERE ((entity =:sentity AND entity_id=:sentity_id) OR (entity =:uentity AND entity_id=:uentity_id)) AND (status = 'new'). Bound with :sentity='survey', :sentity_id='922181', :uentity='user', :uentity_id='1') 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE lime_questions ) 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SELECT FROM lime_settings_global t WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion') 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT COUNT() FROM lime_surveys t WHERE active = 'Y') 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE lime_permissions ) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE lime_users ) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE lime_surveys_groups ) 1 0.00032 0.00032 0.00032 0.00032
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='922181', :yp1='1', :yp2='en') 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE lime_conditions ) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE lime_groups ) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT FROM lime_templates t WHERE t .name ='no_bootstrap' LIMIT 1) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT FROM lime_groups t WHERE t .sid =:yp0 AND t .language =:yp1 ORDER BY group_order ASC. Bound with :yp0='922181', :yp1='en') 1 0.00028 0.00028 0.00028 0.00028
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 =922181)) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SELECT COUNT() FROM lime_notifications t WHERE (entity =:sentity AND entity_id=:sentity_id) OR (entity =:uentity AND entity_id=:uentity_id). Bound with :sentity='survey', :sentity_id='922181', :uentity='user', :uentity_id='1') 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT FROM lime_templates t WHERE t .name ='material' LIMIT 1) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT FROM lime_templates t WHERE t .name ='vanilla' LIMIT 1) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT COUNT() FROM lime_users t ) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SELECT COUNT() FROM lime_surveys t ) 1 0.00015 0.00015 0.00015 0.00015 |