[ DB ] CONNECT:[ UseTime:0.005977s ] mysql:host=127.0.0.1;port=3306;dbname=shop;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `m_config` [ RunTime:0.001343s ]
[ SQL ] SELECT * FROM `m_config` WHERE `inc_type` = 'shop_info' [ RunTime:0.000560s ]
[ SQL ] SHOW COLUMNS FROM `m_navigation` [ RunTime:0.000965s ]
[ SQL ] SELECT `id` FROM `m_navigation` WHERE `url` = '/index.php?m=Home&c=Goods&a=goodsList' AND `is_show` = 1 LIMIT 1 [ RunTime:0.000344s ]
[ SQL ] SELECT * FROM `m_config` [ RunTime:0.000559s ]
[ SQL ] SHOW COLUMNS FROM `m_goods` [ RunTime:0.001734s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `m_goods` WHERE `market_price` BETWEEN 1652 AND 2065 AND `cat_id` IN (544,545,557,564,624,632,633,640) AND `brand_id` = 92 AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 LIMIT 1 [ RunTime:0.000473s ]
[ SQL ] SELECT `goods_id` FROM `m_goods` WHERE `market_price` BETWEEN 1652 AND 2065 AND `cat_id` IN (544,545,557,564,624,632,633,640) AND `brand_id` = 92 AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 ORDER BY sort desc LIMIT 0,20 [ RunTime:0.000444s ]
[ 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 `goods_id` IN (24815,24816,25153,25154,24736,24786,24793,24802,25165,24799,25166,24801,24803,24696,25189) ORDER BY sort desc [ RunTime:0.000434s ]
[ SQL ] SHOW COLUMNS FROM `m_brand` [ RunTime:0.000913s ]
[ SQL ] SELECT `id`,`name` FROM `m_brand` [ RunTime:0.000217s ]
[ 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.000371s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24696 LIMIT 1 [ RunTime:0.000223s ]
[ SQL ] SHOW COLUMNS FROM `m_goods_images` [ RunTime:0.000763s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24696 ORDER BY `img_id` [ RunTime:0.000265s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24736 LIMIT 1 [ RunTime:0.000221s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24736 ORDER BY `img_id` [ RunTime:0.000244s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24786 LIMIT 1 [ RunTime:0.000225s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24786 ORDER BY `img_id` [ RunTime:0.000234s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24793 LIMIT 1 [ RunTime:0.000203s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24793 ORDER BY `img_id` [ RunTime:0.000285s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24799 LIMIT 1 [ RunTime:0.000244s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24799 ORDER BY `img_id` [ RunTime:0.000234s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24801 LIMIT 1 [ RunTime:0.000208s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24801 ORDER BY `img_id` [ RunTime:0.000262s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24802 LIMIT 1 [ RunTime:0.000222s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24802 ORDER BY `img_id` [ RunTime:0.000224s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24803 LIMIT 1 [ RunTime:0.000210s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24803 ORDER BY `img_id` [ RunTime:0.000250s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24815 LIMIT 1 [ RunTime:0.000217s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24815 ORDER BY `img_id` [ RunTime:0.000227s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 24816 LIMIT 1 [ RunTime:0.000234s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 24816 ORDER BY `img_id` [ RunTime:0.000250s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 25153 LIMIT 1 [ RunTime:0.000222s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 25153 ORDER BY `img_id` [ RunTime:0.000226s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 25154 LIMIT 1 [ RunTime:0.000221s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 25154 ORDER BY `img_id` [ RunTime:0.000227s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 25165 LIMIT 1 [ RunTime:0.000224s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 25165 ORDER BY `img_id` [ RunTime:0.000266s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 25166 LIMIT 1 [ RunTime:0.000219s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 25166 ORDER BY `img_id` [ RunTime:0.000246s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 25189 LIMIT 1 [ RunTime:0.000214s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 25189 ORDER BY `img_id` [ RunTime:0.000239s ]
[ SQL ] select * from `m_friend_link` where is_show=1 [ RunTime:0.000195s ]
[ SQL ] SELECT * FROM `m_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.000206s ]
粤公网安备 44031102000815号
