[ DB ] CONNECT:[ UseTime:0.011997s ] mysql:host=127.0.0.1;port=3306;dbname=shop;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `m_navigation` [ RunTime:0.009561s ]
[ SQL ] SELECT `id` FROM `m_navigation` WHERE `url` = '/index.php?m=Home&c=Goods&a=goodsList' AND `is_show` = 1 LIMIT 1 [ RunTime:0.008024s ]
[ SQL ] SHOW COLUMNS FROM `m_brand` [ RunTime:0.023457s ]
[ SQL ] SELECT `id`,`name`,`logo`,`is_hot` FROM `m_brand` WHERE `is_show` = 1 ORDER BY `sort` desc,`id` desc [ RunTime:0.008416s ]
[ SQL ] SHOW COLUMNS FROM `m_brand_region` [ RunTime:0.032651s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 103 [ RunTime:0.004623s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 116 [ RunTime:0.015236s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 238 [ RunTime:0.015178s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 237 [ RunTime:0.003397s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 236 [ RunTime:0.014977s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 235 [ RunTime:0.003531s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 234 [ RunTime:0.002558s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 233 [ RunTime:0.014059s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 232 [ RunTime:0.010124s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 231 [ RunTime:0.002163s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 230 [ RunTime:0.008733s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 229 [ RunTime:0.002313s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 228 [ RunTime:0.002165s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 200 [ RunTime:0.006680s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 199 [ RunTime:0.001996s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 198 [ RunTime:0.001869s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 197 [ RunTime:0.006278s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 196 [ RunTime:0.001988s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 195 [ RunTime:0.001732s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 194 [ RunTime:0.016265s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 193 [ RunTime:0.002219s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 192 [ RunTime:0.002154s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 191 [ RunTime:0.001666s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 190 [ RunTime:0.003307s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 158 [ RunTime:0.003762s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 157 [ RunTime:0.004432s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 109 [ RunTime:0.003342s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 108 [ RunTime:0.003866s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 107 [ RunTime:0.003294s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 106 [ RunTime:0.003541s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 105 [ RunTime:0.006175s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 104 [ RunTime:0.004137s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 102 [ RunTime:0.003484s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 101 [ RunTime:0.004535s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 100 [ RunTime:0.002112s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 99 [ RunTime:0.002452s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 98 [ RunTime:0.004894s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 97 [ RunTime:0.002861s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 96 [ RunTime:0.002416s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 95 [ RunTime:0.002796s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 94 [ RunTime:0.002157s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 93 [ RunTime:0.000858s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 92 [ RunTime:0.002682s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 91 [ RunTime:0.002342s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 80 [ RunTime:0.001404s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 70 [ RunTime:0.002809s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 69 [ RunTime:0.001126s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 63 [ RunTime:0.006488s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 61 [ RunTime:0.002115s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 58 [ RunTime:0.002131s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 57 [ RunTime:0.001838s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 56 [ RunTime:0.001702s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 55 [ RunTime:0.001607s ]
[ SQL ] SELECT a.name as province,b.name as city FROM `m_brand_region` `br` LEFT JOIN `m_region` `a` ON `a`.`id`=`br`.`provinceId` LEFT JOIN `m_region` `b` ON `b`.`id`=`br`.`cityId` WHERE `br`.`brandId` = 54 [ RunTime:0.004483s ]
[ SQL ] SHOW COLUMNS FROM `m_users` [ RunTime:0.004868s ]
[ SQL ] SELECT * FROM `m_users` WHERE `user_id` = 0 LIMIT 1 [ RunTime:0.002617s ]
[ SQL ] SHOW COLUMNS FROM `m_wx_user` [ RunTime:0.005472s ]
[ SQL ] SHOW COLUMNS FROM `m_goods` [ RunTime:0.005449s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `m_goods` WHERE `cat_id` IN (676,677) AND `brand_id` = 96 AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 LIMIT 1 [ RunTime:0.005420s ]
[ SQL ] SELECT `id`,`name` FROM `m_brand` [ RunTime:0.004943s ]
[ SQL ] SELECT `market_price` FROM `m_goods` WHERE `cat_id` IN (676,677) AND `brand_id` = 96 AND `exchange_integral` = 0 AND `is_on_sale` = 1 AND `is_virtual` <> 2 GROUP BY `market_price` [ RunTime:0.004064s ]
[ 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.002511s ]
[ SQL ] select * from `m_friend_link` where is_show=1 [ RunTime:0.005938s ]
[ SQL ] SELECT * FROM `m_navigation` where is_show = 1 AND position = 'bottom' ORDER BY `sort` DESC [ RunTime:0.009924s ]
粤公网安备 44031102000815号
