|
|
Import locally (big workstation) with debian + nginx+7.4+ local mariadb
SQL log :
system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1) 931 0.23036 0.00025 0.00013 0.00059
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)) 465 0.18179 0.00039 0.00027 0.00121
system.db.CDbCommand.query(SELECT `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`.`ipanonymize` AS `t1_c24`, `survey`.`refurl` AS `t1_c25`, `survey`.`datecreated` AS `t1_c26`, `survey`.`showsurveypolicynotice` AS `t1_c27`, `survey`.`publicstatistics` AS `t1_c28`, `survey`.`publicgraphs` AS `t1_c29`, `survey`.`listpublic` AS `t1_c30`, `survey`.`htmlemail` AS `t1_c31`, `survey`.`sendconfirmation` AS `t1_c32`, `survey`.`tokenanswerspersistence` AS `t1_c33`, `survey`.`assessments` AS `t1_c34`, `survey`.`usecaptcha` AS `t1_c35`, `survey`.`usetokens` AS `t1_c36`, `survey`.`bounce_email` AS `t1_c37`, `survey`.`attributedescriptions` AS `t1_c38`, `survey`.`emailresponseto` AS `t1_c39`, `survey`.`emailnotificationto` AS `t1_c40`, `survey`.`tokenlength` AS `t1_c41`, `survey`.`showxquestions` AS `t1_c42`, `survey`.`showgroupinfo` AS `t1_c43`, `survey`.`shownoanswer` AS `t1_c44`, `survey`.`showqnumcode` AS `t1_c45`, `survey`.`bouncetime` AS `t1_c46`, `survey`.`bounceprocessing` AS `t1_c47`, `survey`.`bounceaccounttype` AS `t1_c48`, `survey`.`bounceaccounthost` AS `t1_c49`, `survey`.`bounceaccountpass` AS `t1_c50`, `survey`.`bounceaccountencryption` AS `t1_c51`, `survey`.`bounceaccountuser` AS `t1_c52`, `survey`.`showwelcome` AS `t1_c53`, `survey`.`showprogress` AS `t1_c54`, `survey`.`questionindex` AS `t1_c55`, `survey`.`navigationdelay` AS `t1_c56`, `survey`.`nokeyboard` AS `t1_c57`, `survey`.`alloweditaftercompletion` AS `t1_c58`, `survey`.`googleanalyticsstyle` AS `t1_c59`, `survey`.`googleanalyticsapikey` AS `t1_c60`, `survey`.`tokenencryptionoptions` AS `t1_c61` FROM `lime_surveys` `survey` WHERE (`survey`.`sid`=:ypl0). Bound with :ypl0='379676') 406 0.15690 0.00039 0.00028 0.00060
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groupsettings` `t` WHERE `t`.`gsid`=0 LIMIT 1) 465 0.13426 0.00029 0.00017 0.00056
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='boilerplate', :extends='X') 77 0.02456 0.00032 0.00018 0.00051
system.db.CDbCommand.execute(INSERT INTO `lime_question_l10ns` (`question`, `help`, `language`, `qid`) VALUES (:yp0, :yp1, :yp2, :yp3). Bound with :yp0='LimeSurvey is best than ', :yp1='', :yp2='en', :yp3=10508) 1 0.02247 0.02247 0.02247 0.02247
system.db.CDbCommand.query(SELECT `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`.`ipanonymize` AS `t1_c24`, `survey`.`refurl` AS `t1_c25`, `survey`.`datecreated` AS `t1_c26`, `survey`.`showsurveypolicynotice` AS `t1_c27`, `survey`.`publicstatistics` AS `t1_c28`, `survey`.`publicgraphs` AS `t1_c29`, `survey`.`listpublic` AS `t1_c30`, `survey`.`htmlemail` AS `t1_c31`, `survey`.`sendconfirmation` AS `t1_c32`, `survey`.`tokenanswerspersistence` AS `t1_c33`, `survey`.`assessments` AS `t1_c34`, `survey`.`usecaptcha` AS `t1_c35`, `survey`.`usetokens` AS `t1_c36`, `survey`.`bounce_email` AS `t1_c37`, `survey`.`attributedescriptions` AS `t1_c38`, `survey`.`emailresponseto` AS `t1_c39`, `survey`.`emailnotificationto` AS `t1_c40`, `survey`.`tokenlength` AS `t1_c41`, `survey`.`showxquestions` AS `t1_c42`, `survey`.`showgroupinfo` AS `t1_c43`, `survey`.`shownoanswer` AS `t1_c44`, `survey`.`showqnumcode` AS `t1_c45`, `survey`.`bouncetime` AS `t1_c46`, `survey`.`bounceprocessing` AS `t1_c47`, `survey`.`bounceaccounttype` AS `t1_c48`, `survey`.`bounceaccounthost` AS `t1_c49`, `survey`.`bounceaccountpass` AS `t1_c50`, `survey`.`bounceaccountencryption` AS `t1_c51`, `survey`.`bounceaccountuser` AS `t1_c52`, `survey`.`showwelcome` AS `t1_c53`, `survey`.`showprogress` AS `t1_c54`, `survey`.`questionindex` AS `t1_c55`, `survey`.`navigationdelay` AS `t1_c56`, `survey`.`nokeyboard` AS `t1_c57`, `survey`.`alloweditaftercompletion` AS `t1_c58`, `survey`.`googleanalyticsstyle` AS `t1_c59`, `survey`.`googleanalyticsapikey` AS `t1_c60`, `survey`.`tokenencryptionoptions` AS `t1_c61` FROM `lime_surveys` `survey` WHERE (`survey`.`sid`=:ypl0). Bound with :ypl0=379676)
|
