[ DB ] CONNECT:[ UseTime:0.000427s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `bmkj_field` [ RunTime:0.000596s ]
[ SQL ] SELECT * FROM `bmkj_field` WHERE `lang` = 'en' [ RunTime:0.000334s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_siteinfo` [ RunTime:0.000485s ]
[ SQL ] SELECT * FROM `bmkj_siteinfo` WHERE `lang` = 'en' LIMIT 1 [ RunTime:0.000321s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_navigation` [ RunTime:0.000447s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 0 AND `lang` = 'en' ORDER BY sequence desc,id desc [ RunTime:0.000306s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 86 ORDER BY sequence desc,id desc [ RunTime:0.000264s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 87 ORDER BY sequence desc,id desc [ RunTime:0.000277s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 94 ORDER BY sequence desc,id desc [ RunTime:0.000262s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 99 ORDER BY sequence desc,id desc [ RunTime:0.000251s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 95 ORDER BY sequence desc,id desc [ RunTime:0.000266s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 96 ORDER BY sequence desc,id desc [ RunTime:0.000272s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 97 ORDER BY sequence desc,id desc [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 98 ORDER BY sequence desc,id desc [ RunTime:0.000271s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 88 ORDER BY sequence desc,id desc [ RunTime:0.000259s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 101 ORDER BY sequence desc,id desc [ RunTime:0.000247s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 102 ORDER BY sequence desc,id desc [ RunTime:0.000238s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 103 ORDER BY sequence desc,id desc [ RunTime:0.000270s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 104 ORDER BY sequence desc,id desc [ RunTime:0.000270s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 105 ORDER BY sequence desc,id desc [ RunTime:0.000241s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 89 ORDER BY sequence desc,id desc [ RunTime:0.000264s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 107 ORDER BY sequence desc,id desc [ RunTime:0.000239s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 108 ORDER BY sequence desc,id desc [ RunTime:0.000260s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 109 ORDER BY sequence desc,id desc [ RunTime:0.000243s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 110 ORDER BY sequence desc,id desc [ RunTime:0.000255s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 90 ORDER BY sequence desc,id desc [ RunTime:0.000273s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 111 ORDER BY sequence desc,id desc [ RunTime:0.000238s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 112 ORDER BY sequence desc,id desc [ RunTime:0.000255s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 113 ORDER BY sequence desc,id desc [ RunTime:0.000248s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 114 ORDER BY sequence desc,id desc [ RunTime:0.000253s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 91 ORDER BY sequence desc,id desc [ RunTime:0.000263s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 115 ORDER BY sequence desc,id desc [ RunTime:0.000248s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 116 ORDER BY sequence desc,id desc [ RunTime:0.000255s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 117 ORDER BY sequence desc,id desc [ RunTime:0.000260s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 92 ORDER BY sequence desc,id desc [ RunTime:0.000249s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_sort` [ RunTime:0.000438s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `moduleid` = 4 AND `parentid` = 0 AND `lang` = 'en' ORDER BY sequence asc,id asc [ RunTime:0.000326s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 245 ORDER BY sequence asc,id asc [ RunTime:0.000277s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 244 ORDER BY sequence asc,id asc [ RunTime:0.000273s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 243 ORDER BY sequence asc,id asc [ RunTime:0.000254s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 242 ORDER BY sequence asc,id asc [ RunTime:0.000277s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 241 ORDER BY sequence asc,id asc [ RunTime:0.000249s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_ad` [ RunTime:0.000424s ]
[ SQL ] SELECT * FROM `bmkj_ad` WHERE `position` = 'project' AND `typeid` = 1 AND `lang` = 'en' LIMIT 1 [ RunTime:0.000254s ]
[ SQL ] SELECT * FROM `bmkj_siteinfo` WHERE `lang` = 'en' LIMIT 1 [ RunTime:0.000304s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `id` = 243 LIMIT 1 [ RunTime:0.000266s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `lang` = 'en' AND `moduleid` = 4 [ RunTime:0.000277s ]
[ SQL ] SELECT * FROM `bmkj_sort` [ RunTime:0.000344s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_module` [ RunTime:0.000594s ]
[ SQL ] SELECT * FROM `bmkj_module` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000231s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_project` [ RunTime:0.000581s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `bmkj_project` `project` INNER JOIN `bmkj_sort` `sort` ON `project`.`sortid`=`sort`.`id` INNER JOIN `bmkj_area` `area` ON `project`.`areaid`=`area`.`id` WHERE ( find_in_set("view",status) ) AND ( `project`.`title` LIKE '%%' OR `project`.`seotitle` LIKE '%%' OR `project`.`keyword` LIKE '%%' OR `project`.`description` LIKE '%%' OR `project`.`content1` LIKE '%%' OR `sort`.`title` LIKE '%%' OR `sort`.`seotitle` LIKE '%%' OR `sort`.`keyword` LIKE '%%' OR `sort`.`description` LIKE '%%' OR `area`.`title` LIKE '%%' ) AND `project`.`lang` = 'en' AND `project`.`sortid` = '243' LIMIT 1 [ RunTime:0.000614s ]
[ SQL ] SELECT `project`.`id`,`project`.`sortid`,`project`.`areaid`,`project`.`lang`,`project`.`sequence`,`project`.`thumb`,`project`.`urlroute`,`project`.`title`,`project`.`seotitle`,`project`.`keyword`,`project`.`description`,`project`.`content1`,`project`.`addtime`,`project`.`hits`,`sort`.`title` AS `s_title`,`sort`.`seotitle` AS `s_seotitle`,`sort`.`keyword` AS `s_keyword`,`sort`.`description` AS `s_description`,`area`.`title` AS `a_title` FROM `bmkj_project` `project` INNER JOIN `bmkj_sort` `sort` ON `project`.`sortid`=`sort`.`id` INNER JOIN `bmkj_area` `area` ON `project`.`areaid`=`area`.`id` WHERE ( find_in_set("view",status) ) AND ( `project`.`title` LIKE '%%' OR `project`.`seotitle` LIKE '%%' OR `project`.`keyword` LIKE '%%' OR `project`.`description` LIKE '%%' OR `project`.`content1` LIKE '%%' OR `sort`.`title` LIKE '%%' OR `sort`.`seotitle` LIKE '%%' OR `sort`.`keyword` LIKE '%%' OR `sort`.`description` LIKE '%%' OR `area`.`title` LIKE '%%' ) AND `project`.`lang` = 'en' AND `project`.`sortid` = '243' ORDER BY `project`.`sequence` asc,`project`.`id` asc LIMIT 0,6 [ RunTime:0.000464s ]
[ DB ] CONNECT:[ UseTime:0.000359s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `bmkj_sort` WHERE ( lang='en' and moduleid=1 ) ORDER BY sequence asc, id asc LIMIT 10 [ RunTime:0.000364s ]
[ DB ] CONNECT:[ UseTime:0.000308s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `bmkj_product` [ RunTime:0.000668s ]
[ SQL ] SELECT * FROM `bmkj_product` WHERE ( lang='en' and sortid= 236 ) ORDER BY sequence asc, id asc LIMIT 10 [ RunTime:0.001570s ]
[ DB ] CONNECT:[ UseTime:0.000311s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `bmkj_product` WHERE ( lang='en' and sortid= 237 ) ORDER BY sequence asc, id asc LIMIT 10 [ RunTime:0.001305s ]
[ DB ] CONNECT:[ UseTime:0.000317s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `bmkj_product` WHERE ( lang='en' and sortid= 238 ) ORDER BY sequence asc, id asc LIMIT 10 [ RunTime:0.001171s ]
[ DB ] CONNECT:[ UseTime:0.000312s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `bmkj_product` WHERE ( lang='en' and sortid= 239 ) ORDER BY sequence asc, id asc LIMIT 10 [ RunTime:0.001093s ]
[ DB ] CONNECT:[ UseTime:0.000295s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `bmkj_product` WHERE ( lang='en' and sortid= 240 ) ORDER BY sequence asc, id asc LIMIT 10 [ RunTime:0.001027s ]
[ DB ] CONNECT:[ UseTime:0.000312s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `bmkj_sort` WHERE ( lang='en' and moduleid=4 ) ORDER BY sequence desc,id desc LIMIT 10 [ RunTime:0.000386s ]
[ DB ] CONNECT:[ UseTime:0.000304s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `bmkj_sort` WHERE ( lang='en' and moduleid=2 ) ORDER BY sequence desc,id desc LIMIT 10 [ RunTime:0.000370s ]
[ DB ] CONNECT:[ UseTime:0.000274s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `bmkj_sort` WHERE ( lang='en' and moduleid=1 ) ORDER BY sequence desc,id desc LIMIT 10 [ RunTime:0.000389s ]
[ DB ] CONNECT:[ UseTime:0.000292s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `bmkj_sort` WHERE ( lang='en' and moduleid=4 ) ORDER BY sequence desc,id desc LIMIT 10 [ RunTime:0.000375s ]
[ DB ] CONNECT:[ UseTime:0.000289s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `bmkj_sort` WHERE ( lang='en' and moduleid=2 ) ORDER BY sequence desc,id desc LIMIT 10 [ RunTime:0.000361s ]
[ DB ] CONNECT:[ UseTime:0.000292s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `bmkj_ad` WHERE ( lang='en' and typeid=1 and position='project' ) ORDER BY sequence desc LIMIT 1 [ RunTime:0.000324s ]
[ DB ] CONNECT:[ UseTime:0.000316s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `bmkj_sort` WHERE ( lang='en' and moduleid=4 ) ORDER BY id asc LIMIT 10 [ RunTime:0.000498s ]
English
