[ DB ] CONNECT:[ UseTime:0.000417s ] mysql:host=127.0.0.1;dbname=www_chinakingsta;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tp_type` [ RunTime:0.003474s ]
[ SQL ] SELECT * FROM `tp_type` WHERE `language` = 'en' AND `state` = 0 AND `type` = 'info' ORDER BY `sort` ASC LIMIT 16 [ RunTime:0.000436s ]
[ SQL ] SHOW COLUMNS FROM `tp_info` [ RunTime:0.000773s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_info` WHERE `language` = 'en' AND `state` = 1 AND `typeId` = 146 LIMIT 1 [ RunTime:0.000261s ]
[ SQL ] SELECT * FROM `tp_info` WHERE `language` = 'en' AND `state` = 1 AND `typeId` = 146 ORDER BY `sort` DESC LIMIT 0,7 [ RunTime:0.000360s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods` [ RunTime:0.000754s ]
[ 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.000407s ]
[ 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.000359s ]
[ 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.000394s ]
[ 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.000375s ]
[ 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.000321s ]
[ SQL ] SELECT * FROM `tp_type` WHERE `language` = 'en' AND `state` = 0 AND `type` = 'goods' ORDER BY `sort` ASC LIMIT 6 [ RunTime:0.000283s ]
[ SQL ] SELECT * FROM `tp_type` WHERE `language` = 'en' AND `state` = 0 AND `type` = 'news' ORDER BY `sort` ASC LIMIT 7 [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `tp_type` WHERE `language` = 'en' AND `state` = 0 AND `type` = 'goods' ORDER BY `sort` ASC LIMIT 16 [ RunTime:0.000275s ]
[ SQL ] SELECT * FROM `tp_type` WHERE `language` = 'en' AND `state` = 0 AND `type` = 'news' ORDER BY `sort` ASC [ RunTime:0.000273s ]
[ SQL ] SHOW COLUMNS FROM `tp_config` [ RunTime:0.000715s ]
[ SQL ] SELECT * FROM `tp_config` WHERE `language` = 'en' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000287s ]
[ SQL ] SHOW COLUMNS FROM `tp_banner` [ RunTime:0.000622s ]
[ SQL ] SELECT * FROM `tp_banner` WHERE `language` = 'en' AND `typeId` IN (153) ORDER BY `id` ASC LIMIT 6 [ RunTime:0.000255s ]
[ SQL ] SELECT * FROM `tp_banner` WHERE `language` = 'en' AND `typeId` IN (154) ORDER BY `id` ASC LIMIT 6 [ RunTime:0.000256s ]
[ SQL ] SELECT * FROM `tp_type` WHERE `language` = 'en' AND `state` = 0 AND `type` = 'goods' ORDER BY `sort` ASC LIMIT 16 [ RunTime:0.000262s ]
[ SQL ] SELECT * FROM `tp_goods` WHERE `language` = 'en' AND `id` = 297 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000272s ]
[ SQL ] SELECT * FROM `tp_type` WHERE `id` = 202 LIMIT 1 [ RunTime:0.000233s ]
[ SQL ] SELECT * FROM `tp_goods` WHERE `language` = 'en' AND `id` < 297 AND `typeId` = 202 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
[ SQL ] SELECT * FROM `tp_goods` WHERE `language` = 'en' AND `id` > 297 AND `typeId` = 202 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000332s ]