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