[ DB ] CONNECT:[ UseTime:0.007048s ] mysql:host=sdm708282177.my3w.com;port=3306;dbname=sdm708282177_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tp5_web` [ RunTime:0.003791s ]
[ SQL ] SELECT * FROM `tp5_web` WHERE `default` = 1 LIMIT 1 [ RunTime:0.003258s ]
[ SQL ] SELECT * FROM `tp5_web` WHERE `default` = 0 LIMIT 1 [ RunTime:0.003126s ]
[ SQL ] SHOW COLUMNS FROM `tp5_webclass` [ RunTime:0.003520s ]
[ SQL ] SELECT * FROM `tp5_webclass` [ RunTime:0.003363s ]
[ SQL ] SELECT * FROM `tp5_web` WHERE `default` = 0 LIMIT 1 [ RunTime:0.003177s ]
[ SQL ] SELECT * FROM `tp5_web` WHERE `default` = 0 LIMIT 1 [ RunTime:0.003122s ]
[ SQL ] SELECT * FROM `tp5_web` WHERE `default` = 1 LIMIT 1 [ RunTime:0.003092s ]
[ SQL ] SELECT * FROM `tp5_web` WHERE `sign` = 'cn' LIMIT 1 [ RunTime:0.003118s ]
[ SQL ] SELECT * FROM `tp5_web` WHERE `default` = 0 LIMIT 1 [ RunTime:0.003073s ]
[ SQL ] SELECT * FROM `tp5_web` WHERE `default` = 0 LIMIT 1 [ RunTime:0.003020s ]
[ SQL ] SELECT * FROM `tp5_web` WHERE `default` = 1 LIMIT 1 [ RunTime:0.003015s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `web_id` = 1 AND `status` = 1 ORDER BY `rank` ASC [ RunTime:0.003378s ]
[ SQL ] SHOW COLUMNS FROM `tp5_field` [ RunTime:0.003638s ]
[ SQL ] SELECT * FROM `tp5_field` [ RunTime:0.003147s ]
[ SQL ] SHOW COLUMNS FROM `tp5_inner_keywords` [ RunTime:0.003457s ]
[ SQL ] SELECT * FROM `tp5_inner_keywords` WHERE `status` = 1 ORDER BY `weight` ASC [ RunTime:0.003123s ]
[ SQL ] SHOW COLUMNS FROM `tp5_config` [ RunTime:0.003586s ]
[ SQL ] SELECT `config_value` FROM `tp5_config` WHERE `web_id` = 1 AND `config_name` = 'goods_page_number' LIMIT 1 [ RunTime:0.003217s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `urlname` = 'goods' AND `web_id` = 1 LIMIT 1 [ RunTime:0.003272s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 12 [ RunTime:0.003325s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 14 [ RunTime:0.003185s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 15 [ RunTime:0.003243s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 16 [ RunTime:0.003226s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 17 [ RunTime:0.003265s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 18 [ RunTime:0.003246s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 19 [ RunTime:0.003213s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 20 [ RunTime:0.003223s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 21 [ RunTime:0.003198s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 22 [ RunTime:0.003233s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 23 [ RunTime:0.003388s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 24 [ RunTime:0.003190s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 43 [ RunTime:0.003167s ]
[ SQL ] SHOW COLUMNS FROM `tp5_goods` [ RunTime:0.003812s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp5_goods` `a` INNER JOIN `tp5_webclass` `b` ON `a`.`class`=`b`.`id` WHERE `class` IN (12,14,15,16,17,18,19,20,21,22,23,24,43,0) AND `a`.`status` = 1 AND `b`.`web_id` = 1 LIMIT 1 [ RunTime:0.003642s ]
[ SQL ] SELECT b.urlname as urlname,a.id as id,a.isrecommend as isrecommend,a.name as name,`a`.`price`,a.add_time as add_time,b.name as classname,b.urlname as classurl,a.picurl as picurl FROM `tp5_goods` `a` INNER JOIN `tp5_webclass` `b` ON `a`.`class`=`b`.`id` WHERE `class` IN (12,14,15,16,17,18,19,20,21,22,23,24,43,0) AND `a`.`status` = 1 AND `b`.`web_id` = 1 ORDER BY `a`.`rank` DESC,`a`.`id` DESC LIMIT 54,9 [ RunTime:0.003920s ]
[ SQL ] SELECT * FROM `tp5_config` WHERE `web_id` = 1 [ RunTime:0.003271s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `id` = 12 LIMIT 1 [ RunTime:0.003170s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `status` = 1 AND `web_id` = 1 AND `nav1` = 1 ORDER BY `rank` ASC [ RunTime:0.003340s ]
[ SQL ] SELECT * FROM `tp5_web` WHERE `default` = 1 LIMIT 1 [ RunTime:0.003100s ]
[ SQL ] SHOW COLUMNS FROM `tp5_ads` [ RunTime:0.003831s ]
[ SQL ] SELECT * FROM `tp5_ads` WHERE `status` = 1 AND `start_time` < '1660971315' AND `end_time` > '1660971315' AND `pid` = 1 ORDER BY `rank` DESC LIMIT 3 [ RunTime:0.003333s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `id` = 19 LIMIT 1 [ RunTime:0.003162s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `id` = 12 LIMIT 1 [ RunTime:0.003063s ]
[ SQL ] SELECT * FROM `tp5_web` WHERE `default` = 1 LIMIT 1 [ RunTime:0.003017s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 12 ORDER BY `rank` ASC [ RunTime:0.003260s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 16 ORDER BY `rank` ASC [ RunTime:0.003270s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 14 ORDER BY `rank` ASC [ RunTime:0.003183s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 15 ORDER BY `rank` ASC [ RunTime:0.003271s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 17 ORDER BY `rank` ASC [ RunTime:0.003220s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 18 ORDER BY `rank` ASC [ RunTime:0.003221s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 19 ORDER BY `rank` ASC [ RunTime:0.003213s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 20 ORDER BY `rank` ASC [ RunTime:0.003166s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 21 ORDER BY `rank` ASC [ RunTime:0.003142s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 22 ORDER BY `rank` ASC [ RunTime:0.003158s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 23 ORDER BY `rank` ASC [ RunTime:0.003204s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 24 ORDER BY `rank` ASC [ RunTime:0.003203s ]
[ SQL ] SELECT * FROM `tp5_webclass` WHERE `pid` = 43 ORDER BY `rank` ASC [ RunTime:0.003155s ]