[ DB ] CONNECT:[ UseTime:0.002149s ] mysql:host=127.0.0.1;port=3306;dbname=shop;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `m_navigation` [ RunTime:0.001852s ]
[ SQL ] SELECT `id` FROM `m_navigation` WHERE `url` = '/index.php?m=Home&c=Goods&a=goodsList' AND `is_show` = 1 LIMIT 1 [ RunTime:0.000616s ]
[ SQL ] SHOW COLUMNS FROM `m_goods_category` [ RunTime:0.001295s ]
[ SQL ] SELECT `c`.*,count(s.id) as has_children FROM `m_goods_category` `c` LEFT JOIN `m_goods_category` `s` ON `s`.`parent_id`=`c`.`id` WHERE `c`.`is_show` = 1 GROUP BY `c`.`id` ORDER BY parent_id asc,sort_order asc [ RunTime:0.001663s ]
[ SQL ] SHOW COLUMNS FROM `m_goods` [ RunTime:0.005099s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `m_goods` WHERE `market_price` <= 772 AND `cat_id` = 618 AND `brand_id` = 103 AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 LIMIT 1 [ RunTime:0.004096s ]
[ SQL ] SHOW COLUMNS FROM `m_brand` [ RunTime:0.002208s ]
[ SQL ] SELECT `id`,`name` FROM `m_brand` [ RunTime:0.002596s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`cat_id`,`brand_id`,`goods_name`,`prom_type`,`prom_id`,`store_count`,`sort`,`exchange_integral`,`is_hot`,`is_new`,`is_on_sale`,`is_virtual`,`enquiry`,`market_price`,`generalMemberPrice`,`agentPrice` FROM `m_goods` WHERE `is_hot` = 1 AND `is_on_sale` = 1 AND `exchange_integral` = 0 AND `is_virtual` <> 2 LIMIT 0,5 [ RunTime:0.001297s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 55 LIMIT 1 [ RunTime:0.000839s ]
[ SQL ] SHOW COLUMNS FROM `m_config` [ RunTime:0.001591s ]
[ SQL ] SELECT * FROM `m_config` WHERE `inc_type` = 'oss' [ RunTime:0.005080s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 56 LIMIT 1 [ RunTime:0.000797s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 69 LIMIT 1 [ RunTime:0.000744s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 3051 LIMIT 1 [ RunTime:0.000763s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 3054 LIMIT 1 [ RunTime:0.000759s ]
[ SQL ] select * from `m_article_cat` where id<6 and show_in_nav=1 order by sort_order asc [ RunTime:0.000780s ]
[ SQL ] select * from `m_article` where cat_id=5 and is_open=1 limit 5 [ RunTime:0.000733s ]
[ SQL ] select * from `m_friend_link` where is_show=1 [ RunTime:0.000610s ]
[ SQL ] SELECT * FROM `m_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.000691s ]
[ SQL ] select * from `m_article` where cat_id = 5 and is_open=1 [ RunTime:0.000744s ]
粤公网安备 44031102000815号
