2020-03-31 21:41:34.950 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.ShopCategoryDao.queryShopCategory - ==>  Preparing: SELECT shop_category_id, shop_category_name, shop_category_desc, shop_category_img, priority, create_time, last_edit_time, parent_id FROM tb_shop_category WHERE parent_id is null ORDER BY priority DESC 
2020-03-31 21:41:35.003 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.ShopCategoryDao.queryShopCategory - ==> Parameters: 
2020-03-31 21:41:35.043 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.ShopCategoryDao.queryShopCategory - <==      Total: 6
2020-03-31 21:41:35.074 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.HeadLineDao.queryHeadLine - ==>  Preparing: SELECT line_id, line_name, line_link, line_img, priority, enable_status, create_time, last_edit_time FROM tb_head_line WHERE enable_status = ? ORDER BY priority DESC 
2020-03-31 21:41:35.075 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.HeadLineDao.queryHeadLine - ==> Parameters: 1(Integer)
2020-03-31 21:41:35.080 [http-nio-8080-exec-5] DEBUG com.chj.o2o.dao.HeadLineDao.queryHeadLine - <==      Total: 4
2020-03-31 21:41:39.807 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.ShopCategoryDao.queryShopCategory - ==>  Preparing: SELECT shop_category_id, shop_category_name, shop_category_desc, shop_category_img, priority, create_time, last_edit_time, parent_id FROM tb_shop_category WHERE parent_id is not null and parent_id = ? ORDER BY priority DESC 
2020-03-31 21:41:39.807 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.ShopCategoryDao.queryShopCategory - ==> Parameters: 14(Long)
2020-03-31 21:41:39.814 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.ShopCategoryDao.queryShopCategory - <==      Total: 3
2020-03-31 21:41:39.815 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.AreaDao.queryArea - ==>  Preparing: SELECT area_id,area_name,priority,create_time,last_edit_time FROM tb_area ORDER BY priority DESC 
2020-03-31 21:41:39.816 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.AreaDao.queryArea - ==> Parameters: 
2020-03-31 21:41:39.818 [http-nio-8080-exec-10] DEBUG com.chj.o2o.dao.AreaDao.queryArea - <==      Total: 2
2020-03-31 21:41:39.837 [http-nio-8080-exec-9] DEBUG com.chj.o2o.dao.ShopDao.queryShopList - ==>  Preparing: SELECT s.shop_id, s.shop_name, s.shop_desc, s.shop_addr, s.phone, s.shop_img, s.priority, s.create_time, s.last_edit_time, s.enable_status, s.advice, a.area_id, a.area_name, sc.shop_category_id, sc.shop_category_name FROM tb_shop s, tb_area a, tb_shop_category sc WHERE s.shop_category_id in (select shop_category_id from tb_shop_category WHERE parent_id = ?) and s.enable_status = ? AND s.area_id=a.area_id AND s.shop_category_id = sc.shop_category_id ORDER BY s.priority DESC LIMIT ?,?; 
2020-03-31 21:41:39.838 [http-nio-8080-exec-9] DEBUG com.chj.o2o.dao.ShopDao.queryShopList - ==> Parameters: 14(Long), 1(Integer), 0(Integer), 3(Integer)
2020-03-31 21:41:39.850 [http-nio-8080-exec-9] DEBUG com.chj.o2o.dao.ShopDao.queryShopList - <==      Total: 3
2020-03-31 21:41:39.852 [http-nio-8080-exec-9] DEBUG com.chj.o2o.dao.ShopDao.queryShopCount - ==>  Preparing: SELECT count(1) FROM tb_shop s, tb_area a, tb_shop_category sc WHERE s.shop_category_id in (select shop_category_id from tb_shop_category WHERE parent_id = ?) and s.enable_status = ? AND s.area_id=a.area_id AND s.shop_category_id = sc.shop_category_id 
2020-03-31 21:41:39.853 [http-nio-8080-exec-9] DEBUG com.chj.o2o.dao.ShopDao.queryShopCount - ==> Parameters: 14(Long), 1(Integer)
2020-03-31 21:41:39.858 [http-nio-8080-exec-9] DEBUG com.chj.o2o.dao.ShopDao.queryShopCount - <==      Total: 1
2020-03-31 21:41:47.340 [http-nio-8080-exec-8] DEBUG com.chj.o2o.dao.ShopDao.queryShopList - ==>  Preparing: SELECT s.shop_id, s.shop_name, s.shop_desc, s.shop_addr, s.phone, s.shop_img, s.priority, s.create_time, s.last_edit_time, s.enable_status, s.advice, a.area_id, a.area_name, sc.shop_category_id, sc.shop_category_name FROM tb_shop s, tb_area a, tb_shop_category sc WHERE s.area_id=a.area_id AND s.shop_category_id = sc.shop_category_id ORDER BY s.priority DESC LIMIT ?,?; 
2020-03-31 21:41:47.341 [http-nio-8080-exec-8] DEBUG com.chj.o2o.dao.ShopDao.queryShopList - ==> Parameters: 0(Integer), 100(Integer)
2020-03-31 21:41:47.378 [http-nio-8080-exec-8] DEBUG com.chj.o2o.dao.ShopDao.queryShopList - <==      Total: 17
2020-03-31 21:41:47.379 [http-nio-8080-exec-8] DEBUG com.chj.o2o.dao.ShopDao.queryShopCount - ==>  Preparing: SELECT count(1) FROM tb_shop s, tb_area a, tb_shop_category sc WHERE s.area_id=a.area_id AND s.shop_category_id = sc.shop_category_id 
2020-03-31 21:41:47.379 [http-nio-8080-exec-8] DEBUG com.chj.o2o.dao.ShopDao.queryShopCount - ==> Parameters: 
2020-03-31 21:41:47.380 [http-nio-8080-exec-8] DEBUG com.chj.o2o.dao.ShopDao.queryShopCount - <==      Total: 1

显示图

数据库图片



纠结好久了