[ DB ] CONNECT:[ UseTime:0.000611s ] mysql:dbname=www_rotarykilnch;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `bmkj_field` [ RunTime:0.000740s ]
[ SQL ] SELECT * FROM `bmkj_field` WHERE `lang` = 'en' [ RunTime:0.000424s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_siteinfo` [ RunTime:0.000704s ]
[ SQL ] SELECT * FROM `bmkj_siteinfo` WHERE `lang` = 'en' LIMIT 1 [ RunTime:0.000345s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_navigation` [ RunTime:0.000536s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 0 AND `lang` = 'en' ORDER BY sequence desc,id desc [ RunTime:0.000388s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 86 ORDER BY sequence desc,id desc [ RunTime:0.000291s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 87 ORDER BY sequence desc,id desc [ RunTime:0.000318s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 94 ORDER BY sequence desc,id desc [ RunTime:0.000277s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 99 ORDER BY sequence desc,id desc [ RunTime:0.000267s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 95 ORDER BY sequence desc,id desc [ RunTime:0.000269s ]
[ 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.000269s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 98 ORDER BY sequence desc,id desc [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 88 ORDER BY sequence desc,id desc [ RunTime:0.000280s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 101 ORDER BY sequence desc,id desc [ RunTime:0.000272s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 102 ORDER BY sequence desc,id desc [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 103 ORDER BY sequence desc,id desc [ RunTime:0.000267s ]
[ 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.000272s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 89 ORDER BY sequence desc,id desc [ RunTime:0.000298s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 107 ORDER BY sequence desc,id desc [ RunTime:0.000272s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 108 ORDER BY sequence desc,id desc [ RunTime:0.000298s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 109 ORDER BY sequence desc,id desc [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 110 ORDER BY sequence desc,id desc [ RunTime:0.000292s ]
[ 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.000346s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 112 ORDER BY sequence desc,id desc [ RunTime:0.000265s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 113 ORDER BY sequence desc,id desc [ RunTime:0.000299s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 114 ORDER BY sequence desc,id desc [ RunTime:0.000270s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 91 ORDER BY sequence desc,id desc [ RunTime:0.000279s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 115 ORDER BY sequence desc,id desc [ RunTime:0.000268s ]
[ 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.000273s ]
[ SQL ] SELECT * FROM `bmkj_navigation` WHERE `parentid` = 92 ORDER BY sequence desc,id desc [ RunTime:0.000268s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_sort` [ RunTime:0.000610s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `moduleid` = 1 AND `parentid` = 0 AND `lang` = 'en' ORDER BY sequence asc,id asc [ RunTime:0.000380s ]
[ 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.000294s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 238 ORDER BY sequence asc,id asc [ RunTime:0.000314s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 239 ORDER BY sequence asc,id asc [ RunTime:0.000300s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `parentid` = 240 ORDER BY sequence asc,id asc [ RunTime:0.000292s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_ad` [ RunTime:0.000495s ]
[ SQL ] SELECT * FROM `bmkj_ad` WHERE `position` = 'product' AND `typeid` = 1 AND `lang` = 'en' LIMIT 1 [ RunTime:0.000258s ]
[ SQL ] SELECT * FROM `bmkj_siteinfo` WHERE `lang` = 'en' LIMIT 1 [ RunTime:0.000304s ]
[ SQL ] SELECT * FROM `bmkj_sort` WHERE `lang` = 'en' AND `moduleid` = 1 [ RunTime:0.000308s ]
[ SQL ] SELECT * FROM `bmkj_sort` [ RunTime:0.000349s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_module` [ RunTime:0.000602s ]
[ SQL ] SELECT * FROM `bmkj_module` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000246s ]
[ SQL ] SHOW COLUMNS FROM `bmkj_product` [ RunTime:0.000610s ]
[ 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.001715s ]
[ 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.001504s ]
[ DB ] CONNECT:[ UseTime:0.000865s ] 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.000644s ]
[ DB ] CONNECT:[ UseTime:0.000820s ] 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.001847s ]
[ DB ] CONNECT:[ UseTime:0.000660s ] 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.001525s ]
[ DB ] CONNECT:[ UseTime:0.000319s ] 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.001395s ]
[ DB ] CONNECT:[ UseTime:0.000319s ] 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.001212s ]
[ DB ] CONNECT:[ UseTime:0.000302s ] 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.002534s ]
[ DB ] CONNECT:[ UseTime:0.000327s ] 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.001013s ]
[ DB ] CONNECT:[ UseTime:0.000423s ] 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.000508s ]
[ DB ] CONNECT:[ UseTime:0.000342s ] 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.000483s ]
[ DB ] CONNECT:[ UseTime:0.000339s ] 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.000480s ]
[ DB ] CONNECT:[ UseTime:0.000346s ] 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.000479s ]
[ DB ] CONNECT:[ UseTime:0.000332s ] 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.001265s ]
[ DB ] CONNECT:[ UseTime:0.000523s ] 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.000544s ]
[ DB ] CONNECT:[ UseTime:0.000691s ] 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.001657s ]
[ DB ] CONNECT:[ UseTime:0.000389s ] 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.002119s ]
[ DB ] CONNECT:[ UseTime:0.000459s ] 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.002603s ]
[ DB ] CONNECT:[ UseTime:0.000422s ] 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.001158s ]
[ DB ] CONNECT:[ UseTime:0.000340s ] 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.001454s ]
[ DB ] CONNECT:[ UseTime:0.000368s ] 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.001356s ]