[ DB ] CONNECT:[ UseTime:0.000654s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `bmkj_field` [ RunTime:0.000784s ]
[ SQL ] SELECT * FROM `bmkj_field` WHERE `lang` = 'en' [ RunTime:0.000430s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_siteinfo` [ RunTime:0.000618s ]
[ SQL ] SELECT * FROM `bmkj_siteinfo` WHERE `lang` = 'en' LIMIT 1 [ RunTime:0.000397s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_navigation` [ RunTime:0.000549s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 0 AND `lang` = 'en' ORDER BY sequence desc,id desc [ RunTime:0.000454s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 86 ORDER BY sequence desc,id desc [ RunTime:0.000415s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 87 ORDER BY sequence desc,id desc [ RunTime:0.000383s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 94 ORDER BY sequence desc,id desc [ RunTime:0.000366s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 99 ORDER BY sequence desc,id desc [ RunTime:0.000343s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 95 ORDER BY sequence desc,id desc [ RunTime:0.000358s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 96 ORDER BY sequence desc,id desc [ RunTime:0.000327s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 97 ORDER BY sequence desc,id desc [ RunTime:0.000347s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 98 ORDER BY sequence desc,id desc [ RunTime:0.000280s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 88 ORDER BY sequence desc,id desc [ RunTime:0.000384s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 101 ORDER BY sequence desc,id desc [ RunTime:0.000286s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 102 ORDER BY sequence desc,id desc [ RunTime:0.000395s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 103 ORDER BY sequence desc,id desc [ RunTime:0.000265s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 104 ORDER BY sequence desc,id desc [ RunTime:0.000345s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 105 ORDER BY sequence desc,id desc [ RunTime:0.000264s ]
[ 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.000295s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 108 ORDER BY sequence desc,id desc [ RunTime:0.000287s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 109 ORDER BY sequence desc,id desc [ RunTime:0.000324s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 110 ORDER BY sequence desc,id desc [ RunTime:0.000271s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 90 ORDER BY sequence desc,id desc [ RunTime:0.000387s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 111 ORDER BY sequence desc,id desc [ RunTime:0.000348s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 112 ORDER BY sequence desc,id desc [ RunTime:0.000326s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 113 ORDER BY sequence desc,id desc [ RunTime:0.000295s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 114 ORDER BY sequence desc,id desc [ RunTime:0.000286s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 91 ORDER BY sequence desc,id desc [ RunTime:0.000303s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 115 ORDER BY sequence desc,id desc [ RunTime:0.000287s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 116 ORDER BY sequence desc,id desc [ RunTime:0.000352s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 117 ORDER BY sequence desc,id desc [ RunTime:0.000265s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 92 ORDER BY sequence desc,id desc [ RunTime:0.000418s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_sort` [ RunTime:0.000642s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `moduleid` = 1 AND `parentid` = 0 AND `lang` = 'en' ORDER BY sequence asc,id asc [ RunTime:0.000382s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 236 ORDER BY sequence asc,id asc [ RunTime:0.000429s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 237 ORDER BY sequence asc,id asc [ RunTime:0.000332s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 238 ORDER BY sequence asc,id asc [ RunTime:0.000322s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 239 ORDER BY sequence asc,id asc [ RunTime:0.000347s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 240 ORDER BY sequence asc,id asc [ RunTime:0.000350s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_ad` [ RunTime:0.000534s ]
[ SQL ] SELECT * FROM `bmkj_ad` WHERE `position` = 'product' AND `typeid` = 1 AND `lang` = 'en' LIMIT 1 [ RunTime:0.000401s ]
[ SQL ] SELECT * FROM `bmkj_siteinfo` WHERE `lang` = 'en' LIMIT 1 [ RunTime:0.000387s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `lang` = 'en' AND `moduleid` = 1 [ RunTime:0.000361s ]
[ SQL ] SELECT * FROM `bmkj_sort` [ RunTime:0.000399s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_module` [ RunTime:0.000555s ]
[ SQL ] SELECT * FROM `bmkj_module` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000338s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_product` [ RunTime:0.000680s ]
[ 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.001359s ]
[ 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.001449s ]
[ DB ] CONNECT:[ UseTime:0.000415s ] 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.000513s ]
[ 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 10 [ RunTime:0.001863s ]
[ DB ] CONNECT:[ UseTime:0.000560s ] 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.001545s ]
[ DB ] CONNECT:[ UseTime:0.000403s ] 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.001308s ]
[ DB ] CONNECT:[ UseTime:0.000423s ] 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.001297s ]
[ DB ] CONNECT:[ UseTime:0.000392s ] 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.001213s ]
[ DB ] CONNECT:[ UseTime:0.000382s ] 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.000452s ]
[ DB ] CONNECT:[ UseTime:0.000337s ] 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.000427s ]
[ DB ] CONNECT:[ UseTime:0.000330s ] 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.000472s ]
[ DB ] CONNECT:[ UseTime:0.000334s ] 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.000493s ]
[ DB ] CONNECT:[ UseTime:0.000360s ] 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.000512s ]
[ DB ] CONNECT:[ UseTime:0.000347s ] 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.000607s ]
[ DB ] CONNECT:[ UseTime:0.000356s ] 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.000451s ]
[ DB ] CONNECT:[ UseTime:0.000398s ] 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.000486s ]
[ DB ] CONNECT:[ UseTime:0.000463s ] 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.001451s ]
[ DB ] CONNECT:[ UseTime:0.000460s ] 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.001485s ]
[ DB ] CONNECT:[ UseTime:0.000423s ] 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.001269s ]
[ DB ] CONNECT:[ UseTime:0.000381s ] 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.001192s ]
[ DB ] CONNECT:[ UseTime:0.000402s ] 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.001109s ]