[ DB ] CONNECT:[ UseTime:0.025623s ] mysql:host=127.0.0.1;dbname=www_chinakingsta;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tp_type` [ RunTime:0.005830s ]
[ SQL ] SELECT * FROM `tp_type` WHERE `language` = 'en' AND `state` = 0 AND `type` = 'info' ORDER BY `sort` ASC LIMIT 16 [ RunTime:0.000547s ]
[ SQL ] SHOW COLUMNS FROM `tp_info` [ RunTime:0.002415s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_info` WHERE `language` = 'en' AND `state` = 1 AND `typeId` = 146 LIMIT 1 [ RunTime:0.000300s ]
[ SQL ] SELECT * FROM `tp_info` WHERE `language` = 'en' AND `state` = 1 AND `typeId` = 146 ORDER BY `sort` DESC LIMIT 0,7 [ RunTime:0.000358s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods` [ RunTime:0.000840s ]
[ SQL ] SELECT *,g.id as cid FROM `tp_goods` `g` INNER JOIN `tp_type` `t` ON `g`.`typeId`=`t`.`id` WHERE `typeId` = 204 ORDER BY `g`.`sort` ASC LIMIT 20 [ RunTime:0.000423s ]
[ SQL ] SELECT *,g.id as cid FROM `tp_goods` `g` INNER JOIN `tp_type` `t` ON `g`.`typeId`=`t`.`id` WHERE `typeId` = 203 ORDER BY `g`.`sort` ASC LIMIT 20 [ RunTime:0.000376s ]
[ SQL ] SELECT *,g.id as cid FROM `tp_goods` `g` INNER JOIN `tp_type` `t` ON `g`.`typeId`=`t`.`id` WHERE `typeId` = 202 ORDER BY `g`.`sort` ASC LIMIT 20 [ RunTime:0.000352s ]
[ SQL ] SELECT *,g.id as cid FROM `tp_goods` `g` INNER JOIN `tp_type` `t` ON `g`.`typeId`=`t`.`id` WHERE `typeId` = 201 ORDER BY `g`.`sort` ASC LIMIT 20 [ RunTime:0.000363s ]
[ SQL ] SELECT *,g.id as cid FROM `tp_goods` `g` INNER JOIN `tp_type` `t` ON `g`.`typeId`=`t`.`id` WHERE `typeId` = 200 ORDER BY `g`.`sort` ASC LIMIT 20 [ RunTime:0.000323s ]
[ SQL ] SELECT * FROM `tp_type` WHERE `language` = 'en' AND `state` = 0 AND `type` = 'goods' ORDER BY `sort` ASC LIMIT 6 [ RunTime:0.000275s ]
[ SQL ] SELECT * FROM `tp_type` WHERE `language` = 'en' AND `state` = 0 AND `type` = 'news' ORDER BY `sort` ASC LIMIT 7 [ RunTime:0.000270s ]
[ SQL ] SELECT * FROM `tp_type` WHERE `language` = 'en' AND `state` = 0 AND `type` = 'goods' ORDER BY `sort` ASC LIMIT 16 [ RunTime:0.000245s ]
[ SQL ] SELECT * FROM `tp_type` WHERE `language` = 'en' AND `state` = 0 AND `type` = 'news' ORDER BY `sort` ASC [ RunTime:0.000258s ]
[ SQL ] SHOW COLUMNS FROM `tp_config` [ RunTime:0.000807s ]
[ SQL ] SELECT * FROM `tp_config` WHERE `language` = 'en' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000267s ]
[ SQL ] SHOW COLUMNS FROM `tp_banner` [ RunTime:0.000723s ]
[ SQL ] SELECT * FROM `tp_banner` WHERE `language` = 'en' AND `typeId` IN (17,105) ORDER BY `id` ASC LIMIT 6 [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `tp_banner` WHERE `language` = 'en' AND `typeId` IN (169) ORDER BY `id` ASC LIMIT 6 [ RunTime:0.000247s ]
[ SQL ] SELECT * FROM `tp_type` WHERE `language` = 'en' AND `type` = 'goods' AND `isIndex` = 1 ORDER BY `sort` DESC LIMIT 3 [ RunTime:0.000258s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_goods` WHERE `language` = 'en' AND `isNew` = 1 AND `pid` = 0 LIMIT 1 [ RunTime:0.000225s ]
[ SQL ] SELECT * FROM `tp_goods` WHERE `language` = 'en' AND `isNew` = 1 AND `pid` = 0 ORDER BY `id` DESC LIMIT 0,8 [ RunTime:0.000307s ]
[ SQL ] SELECT * FROM `tp_goods` WHERE `language` = 'en' AND `state` = 1 AND `isIndex` = 1 AND `pid` = 0 ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000330s ]
[ SQL ] SHOW COLUMNS FROM `tp_case` [ RunTime:0.000799s ]
[ SQL ] SELECT * FROM `tp_case` WHERE `language` = 'en' AND `state` = 1 ORDER BY `id` DESC LIMIT 8 [ RunTime:0.000261s ]
[ SQL ] SHOW COLUMNS FROM `tp_news` [ RunTime:0.000780s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_news` WHERE `language` = 'en' AND `state` = 1 LIMIT 1 [ RunTime:0.000248s ]
[ SQL ] SELECT * FROM `tp_news` WHERE `language` = 'en' AND `state` = 1 ORDER BY `id` DESC LIMIT 0,4 [ RunTime:0.000257s ]
[ SQL ] SHOW COLUMNS FROM `tp_index` [ RunTime:0.000760s ]
[ SQL ] SELECT * FROM `tp_index` WHERE `type` = 'index' AND `language` = 'en' LIMIT 1 [ RunTime:0.000234s ]