[ DB ] CONNECT:[ UseTime:0.000489s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `bmkj_field` [ RunTime:0.000802s ]
[ SQL ] SELECT * FROM `bmkj_field` WHERE `lang` = 'en' [ RunTime:0.000405s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_siteinfo` [ RunTime:0.000705s ]
[ SQL ] SELECT * FROM `bmkj_siteinfo` WHERE `lang` = 'en' LIMIT 1 [ RunTime:0.000343s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_navigation` [ RunTime:0.000647s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 0 AND `lang` = 'en' ORDER BY sequence desc,id desc [ RunTime:0.000377s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 86 ORDER BY sequence desc,id desc [ RunTime:0.000267s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 87 ORDER BY sequence desc,id desc [ RunTime:0.000371s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 94 ORDER BY sequence desc,id desc [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 99 ORDER BY sequence desc,id desc [ RunTime:0.000298s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 95 ORDER BY sequence desc,id desc [ RunTime:0.000263s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 96 ORDER BY sequence desc,id desc [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 97 ORDER BY sequence desc,id desc [ RunTime:0.000307s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 98 ORDER BY sequence desc,id desc [ RunTime:0.000270s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 88 ORDER BY sequence desc,id desc [ RunTime:0.000369s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 101 ORDER BY sequence desc,id desc [ RunTime:0.000290s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 102 ORDER BY sequence desc,id desc [ RunTime:0.000316s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 103 ORDER BY sequence desc,id desc [ RunTime:0.000279s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 104 ORDER BY sequence desc,id desc [ RunTime:0.000370s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 105 ORDER BY sequence desc,id desc [ RunTime:0.000278s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 89 ORDER BY sequence desc,id desc [ RunTime:0.000294s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 107 ORDER BY sequence desc,id desc [ RunTime:0.000281s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 108 ORDER BY sequence desc,id desc [ RunTime:0.000283s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 109 ORDER BY sequence desc,id desc [ RunTime:0.000391s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 110 ORDER BY sequence desc,id desc [ RunTime:0.000297s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 90 ORDER BY sequence desc,id desc [ RunTime:0.000354s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 111 ORDER BY sequence desc,id desc [ RunTime:0.000300s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 112 ORDER BY sequence desc,id desc [ RunTime:0.000365s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 113 ORDER BY sequence desc,id desc [ RunTime:0.000379s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 114 ORDER BY sequence desc,id desc [ RunTime:0.000373s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 91 ORDER BY sequence desc,id desc [ RunTime:0.000290s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 115 ORDER BY sequence desc,id desc [ RunTime:0.000340s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 116 ORDER BY sequence desc,id desc [ RunTime:0.000266s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 117 ORDER BY sequence desc,id desc [ RunTime:0.000342s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 92 ORDER BY sequence desc,id desc [ RunTime:0.000278s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_sort` [ RunTime:0.000549s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `moduleid` = 1 AND `parentid` = 0 AND `lang` = 'en' ORDER BY sequence asc,id asc [ RunTime:0.000350s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 236 ORDER BY sequence asc,id asc [ RunTime:0.000284s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 237 ORDER BY sequence asc,id asc [ RunTime:0.000287s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 238 ORDER BY sequence asc,id asc [ RunTime:0.000352s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 239 ORDER BY sequence asc,id asc [ RunTime:0.000320s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 240 ORDER BY sequence asc,id asc [ RunTime:0.000336s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_ad` [ RunTime:0.000488s ]
[ SQL ] SELECT * FROM `bmkj_ad` WHERE `position` = 'product' AND `typeid` = 1 AND `lang` = 'en' LIMIT 1 [ RunTime:0.000292s ]
[ SQL ] SELECT * FROM `bmkj_siteinfo` WHERE `lang` = 'en' LIMIT 1 [ RunTime:0.000367s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `lang` = 'en' AND `moduleid` = 1 [ RunTime:0.000407s ]
[ SQL ] SELECT * FROM `bmkj_sort` [ RunTime:0.000384s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_module` [ RunTime:0.000602s ]
[ SQL ] SELECT * FROM `bmkj_module` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000272s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_product` [ RunTime:0.000559s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `bmkj_product` `product` INNER JOIN `bmkj_sort` `sort` ON `product`.`sortid`=`sort`.`id` INNER JOIN `bmkj_area` `area` ON `product`.`areaid`=`area`.`id` WHERE ( find_in_set("view",status) ) AND ( `product`.`title` LIKE '%%' OR `product`.`seotitle` LIKE '%%' OR `product`.`keyword` LIKE '%%' OR `product`.`description` LIKE '%%' OR `product`.`content1` LIKE '%%' ) AND `product`.`lang` = 'en' AND `product`.`sortid` IN ('','76','241','168','169','170','171','172','136','92','236','237','234','235','242','162','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','238','239','240','243','244','245','') LIMIT 1 [ RunTime:0.001600s ]
[ SQL ] SELECT `product`.`id`,`product`.`sortid`,`product`.`areaid`,`product`.`lang`,`product`.`sequence`,`product`.`thumb`,`product`.`price`,`product`.`marketprice`,`product`.`quantity`,`product`.`urlroute`,`product`.`status`,`product`.`title`,`product`.`seotitle`,`product`.`keyword`,`product`.`description`,`product`.`content1`,`product`.`content2`,`product`.`content3`,`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_product` `product` INNER JOIN `bmkj_sort` `sort` ON `product`.`sortid`=`sort`.`id` INNER JOIN `bmkj_area` `area` ON `product`.`areaid`=`area`.`id` WHERE ( find_in_set("view",status) ) AND ( `product`.`title` LIKE '%%' OR `product`.`seotitle` LIKE '%%' OR `product`.`keyword` LIKE '%%' OR `product`.`description` LIKE '%%' OR `product`.`content1` LIKE '%%' ) AND `product`.`lang` = 'en' AND `product`.`sortid` IN ('','76','241','168','169','170','171','172','136','92','236','237','234','235','242','162','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','238','239','240','243','244','245','') ORDER BY `product`.`sequence` asc,`product`.`id` asc LIMIT 0,6 [ RunTime:0.001400s ]
[ DB ] CONNECT:[ UseTime:0.000445s ] 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.000425s ]
[ DB ] CONNECT:[ UseTime:0.000413s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `bmkj_product` WHERE ( lang='en' and sortid= 236 ) ORDER BY sequence asc, id asc LIMIT 10 [ RunTime:0.001712s ]
[ DB ] CONNECT:[ UseTime:0.000332s ] 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.001690s ]
[ DB ] CONNECT:[ UseTime:0.000456s ] 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.001176s ]
[ DB ] CONNECT:[ UseTime:0.000408s ] 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.001170s ]
[ DB ] CONNECT:[ UseTime:0.000343s ] 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.001139s ]
[ DB ] CONNECT:[ UseTime:0.000324s ] 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.000560s ]
[ DB ] CONNECT:[ UseTime:0.000370s ] 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.000564s ]
[ DB ] CONNECT:[ UseTime:0.000345s ] 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.000404s ]
[ DB ] CONNECT:[ UseTime:0.000332s ] 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.000406s ]
[ DB ] CONNECT:[ UseTime:0.000369s ] 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.000436s ]
[ DB ] CONNECT:[ UseTime:0.000376s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `bmkj_ad` WHERE ( lang='en' and find_in_set('pc',client) and typeid=1 and position='product' ) ORDER BY id asc LIMIT 6 [ RunTime:0.000724s ]
[ DB ] CONNECT:[ UseTime:0.000324s ] 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 5 [ RunTime:0.000391s ]
[ DB ] CONNECT:[ UseTime:0.000406s ] 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.000379s ]
[ DB ] CONNECT:[ UseTime:0.000382s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `bmkj_product` WHERE ( lang='en' and sortid= 236 ) ORDER BY sequence asc, id asc LIMIT 6 [ RunTime:0.001532s ]
[ DB ] CONNECT:[ UseTime:0.000401s ] 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 6 [ RunTime:0.001392s ]
[ DB ] CONNECT:[ UseTime:0.000415s ] 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 6 [ RunTime:0.001231s ]
[ DB ] CONNECT:[ UseTime:0.000425s ] 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 6 [ RunTime:0.001421s ]
[ DB ] CONNECT:[ UseTime:0.000414s ] 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 6 [ RunTime:0.001072s ]