[ DB ] CONNECT:[ UseTime:0.000373s ] mysql:host=127.0.0.1;port=3306;dbname=huiyunding;charset=utf8
[ SQL ] SHOW COLUMNS FROM `hui_goods_category` [ RunTime:0.000773s ]
[ SQL ] SELECT `id`,`parent_id`,`poster`,`category_name`,`sort` FROM `hui_goods_category` WHERE ( is_del=0 AND parent_id=0 ) ORDER BY sort ASC LIMIT 10 [ RunTime:0.000338s ]
[ SQL ] SELECT `id`,`parent_id`,`poster`,`category_name`,`sort` FROM `hui_goods_category` WHERE ( is_del=0 ) AND `parent_id` IN (70,1,4,3,33,13,104,14) ORDER BY sort ASC [ RunTime:0.000366s ]
[ SQL ] SELECT `id`,`parent_id`,`poster`,`category_name`,`sort` FROM `hui_goods_category` WHERE ( is_del=0 ) AND `parent_id` IN (56,51,52,55,54,2,57,60,65,71,96,50,28,6,18,46,15,34,26,72,58,66,30,37,53,47,73,67,49,59,48,62,61,74,63,68,69,99,105) ORDER BY sort ASC [ RunTime:0.000451s ]
[ SQL ] SHOW COLUMNS FROM `hui_ad` [ RunTime:0.000570s ]
[ SQL ] SELECT `poster`,`url` FROM `hui_ad` WHERE `code` = 'HEAD_BANNER' AND `status` = 1 LIMIT 1 [ RunTime:0.000205s ]
[ SQL ] SELECT `id`,`category_name` FROM `hui_goods_category` WHERE ( is_hot=1 AND is_del=0 ) ORDER BY id DESC LIMIT 5 [ RunTime:0.000190s ]
[ SQL ] SHOW COLUMNS FROM `hui_about` [ RunTime:0.000431s ]
[ SQL ] SELECT `id`,`title` FROM `hui_about` WHERE `is_del` = 0 AND `type` = 0 [ RunTime:0.000182s ]
[ SQL ] SHOW COLUMNS FROM `hui_config` [ RunTime:0.000385s ]
[ SQL ] SELECT `content` FROM `hui_config` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000224s ]
[ SQL ] SHOW COLUMNS FROM `hui_message` [ RunTime:0.000472s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hui_message` WHERE ( user_id=0 OR user_id=0 ) AND ( is_del=0 AND is_read=0 ) AND `type` IN (0,2) LIMIT 1 [ RunTime:0.000336s ]
[ SQL ] SHOW COLUMNS FROM `hui_goods` [ RunTime:0.000694s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hui_goods` WHERE ( one_category_id=147 OR two_category_id=147 OR three_category_id=147 ) AND ( is_del=0 AND status=1 AND is_pass=1 ) LIMIT 1 [ RunTime:0.000765s ]
[ SQL ] SELECT `id`,`price`,`name`,`poster`,`sales_volume`,`city_id` FROM `hui_goods` WHERE ( one_category_id=147 OR two_category_id=147 OR three_category_id=147 ) AND ( is_del=0 AND status=1 AND is_pass=1 ) ORDER BY id DESC LIMIT 0,50 [ RunTime:0.001003s ]
[ SQL ] SHOW COLUMNS FROM `hui_area` [ RunTime:0.000479s ]
[ SQL ] SELECT `id`,`name` FROM `hui_area` WHERE `id` IN ('') [ RunTime:0.000164s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hui_goods` WHERE ( one_category_id=147 OR two_category_id=147 OR three_category_id=147 ) AND `name` LIKE '%%' AND ( is_del=0 AND status=1 AND is_pass=1 ) LIMIT 1 [ RunTime:0.000734s ]
[ SQL ] SELECT `id`,`price`,`name`,`poster`,`sales_volume` FROM `hui_goods` WHERE ( one_category_id=147 OR two_category_id=147 OR three_category_id=147 ) AND `name` LIKE '%%' AND ( is_del=0 AND status=1 AND is_pass=1 ) ORDER BY id DESC LIMIT 0,50 [ RunTime:0.000974s ]
[ SQL ] SELECT `parent_id`,`category_name` FROM `hui_goods_category` WHERE ( id=147 ) LIMIT 1 [ RunTime:0.000277s ]
[ SQL ] SELECT `id`,`category_name` FROM `hui_goods_category` WHERE ( is_del=0 AND parent_id=147 ) [ RunTime:0.000174s ]
特色食材
肉禽蛋类
新鲜蔬果
水产海鲜
干货调料
米面粮油
办公用品
酒水茶饮
