[ DB ] CONNECT:[ UseTime:0.000466s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `bmkj_field` [ RunTime:0.000737s ]
[ SQL ] SELECT * FROM `bmkj_field` WHERE `lang` = 'en' [ RunTime:0.000354s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_siteinfo` [ RunTime:0.000525s ]
[ SQL ] SELECT * FROM `bmkj_siteinfo` WHERE `lang` = 'en' LIMIT 1 [ RunTime:0.000314s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_navigation` [ RunTime:0.000562s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 0 AND `lang` = 'en' ORDER BY sequence desc,id desc [ RunTime:0.000324s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 86 ORDER BY sequence desc,id desc [ RunTime:0.000253s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 87 ORDER BY sequence desc,id desc [ RunTime:0.000285s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 94 ORDER BY sequence desc,id desc [ RunTime:0.000250s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 99 ORDER BY sequence desc,id desc [ RunTime:0.000266s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 95 ORDER BY sequence desc,id desc [ RunTime:0.000260s ]
[ 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.000258s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 98 ORDER BY sequence desc,id desc [ RunTime:0.000226s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 88 ORDER BY sequence desc,id desc [ RunTime:0.000253s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 101 ORDER BY sequence desc,id desc [ RunTime:0.000238s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 102 ORDER BY sequence desc,id desc [ RunTime:0.000247s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 103 ORDER BY sequence desc,id desc [ RunTime:0.000262s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 104 ORDER BY sequence desc,id desc [ RunTime:0.000244s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 105 ORDER BY sequence desc,id desc [ RunTime:0.000318s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 89 ORDER BY sequence desc,id desc [ RunTime:0.000252s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 107 ORDER BY sequence desc,id desc [ RunTime:0.000245s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 108 ORDER BY sequence desc,id desc [ RunTime:0.000243s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 109 ORDER BY sequence desc,id desc [ RunTime:0.000280s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 110 ORDER BY sequence desc,id desc [ RunTime:0.000256s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 90 ORDER BY sequence desc,id desc [ RunTime:0.000253s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 111 ORDER BY sequence desc,id desc [ RunTime:0.000257s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 112 ORDER BY sequence desc,id desc [ RunTime:0.000238s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 113 ORDER BY sequence desc,id desc [ RunTime:0.000265s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 114 ORDER BY sequence desc,id desc [ RunTime:0.000243s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 91 ORDER BY sequence desc,id desc [ RunTime:0.000262s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 115 ORDER BY sequence desc,id desc [ RunTime:0.000254s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 116 ORDER BY sequence desc,id desc [ RunTime:0.000240s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 117 ORDER BY sequence desc,id desc [ RunTime:0.000258s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 92 ORDER BY sequence desc,id desc [ RunTime:0.000243s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_sort` [ RunTime:0.000463s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `moduleid` = 1 AND `parentid` = 0 AND `lang` = 'en' ORDER BY sequence asc,id asc [ RunTime:0.000315s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 236 ORDER BY sequence asc,id asc [ RunTime:0.000271s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 237 ORDER BY sequence asc,id asc [ RunTime:0.000255s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 238 ORDER BY sequence asc,id asc [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 239 ORDER BY sequence asc,id asc [ RunTime:0.000251s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 240 ORDER BY sequence asc,id asc [ RunTime:0.000266s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_ad` [ RunTime:0.000588s ]
[ SQL ] SELECT * FROM `bmkj_ad` WHERE `position` = 'product' AND `typeid` = 1 AND `lang` = 'en' LIMIT 1 [ RunTime:0.000277s ]
[ SQL ] SELECT * FROM `bmkj_siteinfo` WHERE `lang` = 'en' LIMIT 1 [ RunTime:0.000322s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `lang` = 'en' AND `moduleid` = 1 [ RunTime:0.000275s ]
[ SQL ] SELECT * FROM `bmkj_sort` [ RunTime:0.000344s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_module` [ RunTime:0.000570s ]
[ SQL ] SELECT * FROM `bmkj_module` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000234s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_product` [ RunTime:0.000494s ]
[ 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.001364s ]
[ 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.001251s ]
[ DB ] CONNECT:[ UseTime:0.000385s ] 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.000377s ]
[ DB ] CONNECT:[ UseTime:0.000327s ] 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.001501s ]
[ DB ] CONNECT:[ UseTime:0.000308s ] 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.001245s ]
[ DB ] CONNECT:[ UseTime:0.000300s ] 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.001392s ]
[ DB ] CONNECT:[ UseTime:0.000289s ] 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.001058s ]
[ DB ] CONNECT:[ UseTime:0.000275s ] 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.001013s ]
[ DB ] CONNECT:[ UseTime:0.000313s ] 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.000373s ]
[ DB ] CONNECT:[ UseTime:0.000301s ] 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.000375s ]
[ DB ] CONNECT:[ UseTime:0.000295s ] 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.000401s ]
[ DB ] CONNECT:[ UseTime:0.000291s ] 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.000415s ]
[ DB ] CONNECT:[ UseTime:0.000293s ] 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.000362s ]
[ DB ] CONNECT:[ UseTime:0.000308s ] 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.000460s ]
[ 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=1 ) ORDER BY sequence asc, id asc LIMIT 5 [ RunTime:0.000371s ]
[ DB ] CONNECT:[ UseTime:0.000307s ] 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.000372s ]
[ DB ] CONNECT:[ UseTime:0.000305s ] 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.001256s ]
[ DB ] CONNECT:[ UseTime:0.000394s ] 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.001220s ]
[ DB ] CONNECT:[ UseTime:0.000374s ] 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.001058s ]
[ DB ] CONNECT:[ UseTime:0.000328s ] 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.000982s ]
[ DB ] CONNECT:[ UseTime:0.000363s ] 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.000961s ]