[ DB ] CONNECT:[ UseTime:0.010581s ] mysql:host=127.0.0.1;port=3306;dbname=shop;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `m_navigation` [ RunTime:0.001454s ]
[ SQL ] SELECT `id` FROM `m_navigation` WHERE `url` = '/index.php?m=Home&c=Goods&a=goodsList' AND `is_show` = 1 LIMIT 1 [ RunTime:0.000375s ]
[ SQL ] SHOW COLUMNS FROM `m_config` [ RunTime:0.001032s ]
[ SQL ] SELECT * FROM `m_config` [ RunTime:0.000624s ]
[ SQL ] SHOW COLUMNS FROM `m_goods_category` [ RunTime:0.001202s ]
[ 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.001593s ]
[ SQL ] SHOW COLUMNS FROM `m_goods` [ RunTime:0.001863s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `m_goods` WHERE `market_price` BETWEEN 13307 AND 15208 AND `cat_id` = 701 AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 LIMIT 1 [ RunTime:0.008249s ]
[ SQL ] SELECT `goods_id` FROM `m_goods` WHERE `market_price` BETWEEN 13307 AND 15208 AND `cat_id` = 701 AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 ORDER BY sort desc LIMIT 420,20 [ RunTime:0.025620s ]
[ 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 (11342,11315,11300,11297,11288,11285,11276,11267,11261,11258,11252,11243,11240,11231,11222,11216,11213,11210,11207,11204) ORDER BY sort desc [ RunTime:0.000695s ]
[ SQL ] SELECT `brand_id` FROM `m_goods` WHERE `market_price` BETWEEN 13307 AND 15208 AND `cat_id` = 701 AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 GROUP BY `brand_id` [ RunTime:0.008602s ]
[ SQL ] SHOW COLUMNS FROM `m_brand` [ RunTime:0.001239s ]
[ SQL ] SELECT * FROM `m_brand` WHERE `id` IN (69) ORDER BY `sort` desc,`id` desc LIMIT 30 [ RunTime:0.000397s ]
[ 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.000429s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 55 LIMIT 1 [ RunTime:0.000293s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11258 LIMIT 1 [ RunTime:0.000271s ]
[ SQL ] SHOW COLUMNS FROM `m_goods_images` [ RunTime:0.001459s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11258 ORDER BY `img_id` [ RunTime:0.000312s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11342 LIMIT 1 [ RunTime:0.000270s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11342 ORDER BY `img_id` [ RunTime:0.000280s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11315 LIMIT 1 [ RunTime:0.000249s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11315 ORDER BY `img_id` [ RunTime:0.000300s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11300 LIMIT 1 [ RunTime:0.000227s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11300 ORDER BY `img_id` [ RunTime:0.000240s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11297 LIMIT 1 [ RunTime:0.000244s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11297 ORDER BY `img_id` [ RunTime:0.000326s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11288 LIMIT 1 [ RunTime:0.000223s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11288 ORDER BY `img_id` [ RunTime:0.000257s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11285 LIMIT 1 [ RunTime:0.000251s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11285 ORDER BY `img_id` [ RunTime:0.000257s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11276 LIMIT 1 [ RunTime:0.000217s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11276 ORDER BY `img_id` [ RunTime:0.000247s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11267 LIMIT 1 [ RunTime:0.000213s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11267 ORDER BY `img_id` [ RunTime:0.000243s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11261 LIMIT 1 [ RunTime:0.000253s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11261 ORDER BY `img_id` [ RunTime:0.000238s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11204 LIMIT 1 [ RunTime:0.000218s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11204 ORDER BY `img_id` [ RunTime:0.000256s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11252 LIMIT 1 [ RunTime:0.000217s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11252 ORDER BY `img_id` [ RunTime:0.000270s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11243 LIMIT 1 [ RunTime:0.000228s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11243 ORDER BY `img_id` [ RunTime:0.000243s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11240 LIMIT 1 [ RunTime:0.000287s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11240 ORDER BY `img_id` [ RunTime:0.000243s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11231 LIMIT 1 [ RunTime:0.000232s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11231 ORDER BY `img_id` [ RunTime:0.000274s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11222 LIMIT 1 [ RunTime:0.000246s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11222 ORDER BY `img_id` [ RunTime:0.000261s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11216 LIMIT 1 [ RunTime:0.000212s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11216 ORDER BY `img_id` [ RunTime:0.000239s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11213 LIMIT 1 [ RunTime:0.000232s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11213 ORDER BY `img_id` [ RunTime:0.000254s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11210 LIMIT 1 [ RunTime:0.000246s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11210 ORDER BY `img_id` [ RunTime:0.000269s ]
[ SQL ] SELECT `original_img` FROM `m_goods` WHERE `goods_id` = 11207 LIMIT 1 [ RunTime:0.000269s ]
[ SQL ] SELECT * FROM `m_goods_images` WHERE `goods_id` = 11207 ORDER BY `img_id` [ RunTime:0.000252s ]
[ SQL ] select * from `m_friend_link` where is_show=1 [ RunTime:0.000185s ]
[ SQL ] SELECT * FROM `m_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.000263s ]
粤公网安备 44031102000815号
