performance log

no query time rows -
1
/shop/_header.php @ 187 line
select count(*) from mini_counter where day=20210922
0.001450 0 Analyze
2
/shop/_header.php @ 187 line
select count(*) from mini_ip where idx_date=20210922 and ip='34.239.160.86'
0.001010 0 Analyze
3
/shop/_header.php @ 187 line
update mini_counter set uniques=uniques+1,h13=h13+1 where day=20210922 or day=0
0.005100 0 Analyze
4
/shop/_header.php @ 187 line
insert into mini_ip set ip = '34.239.160.86', referer = 'Direct Contact (Typing or Bookmark)', os = 'Search Robot', browser = 'commoncrawl.org', idx_date = left(now()+0,8), reg_date = UNIX_TIMESTAMP()
0.003710 0 Analyze
5
/shop/_header.php @ 187 line
select count(*) from mini_referer where day=20210922 and referer='Direct Contact (Typing or Bookmark)'
0.002500 0 Analyze
6
/shop/_header.php @ 187 line
update mini_referer set hit=hit+1 where day='20210922' and referer='Direct Contact (Typing or Bookmark)'
0.005870 0 Analyze
7
/shop/_header.php @ 187 line
update mini_counter set pageviews=pageviews+1 where day=curdate()+0 or day=0
0.005810 0 Analyze
8
/shop/mypage/mypage_orderlist.php @ 5 line
select use_only_adult from gd_goods where goodsno=''
0.001010 0 Analyze
9
/shop/mypage/mypage_orderlist.php @ 5 line
select font_code,`use` from gd_webfont where now() between expire_start and expire_end and LENGTH(`use`)
0.000970 0 Analyze
10
/shop/lib/config.class.php @ 35 line
select name,value from gd_env where category="godofont"
0.000900 0 Analyze
11
/shop/lib/config.class.php @ 35 line
select name,value from gd_env where category="aboutcoupon"
0.000890 0 Analyze
12
/shop/lib/config.class.php @ 35 line
select name,value from gd_env where category="ghostbanker"
0.000910 0 Analyze
13
/shop/lib/populate.class.php @ 91 line
SELECT OI.goodsno, OI.goodsnm, COUNT(OI.goodsno) AS `goods_cnt` FROM gd_order as O FORCE INDEX (PRIMARY, orddt) STRAIGHT_JOIN gd_order_item AS OI FORCE INDEX (idx) ON O.ordno = OI.ordno INNER JOIN gd_goods AS G ON OI.goodsno = G.goodsno WHERE O.orddt >= DATE_SUB(NOW(), INTERVAL 1 HOUR) AND G.open = 1 GROUP BY OI.goodsno ORDER BY `goods_cnt` DESC LIMIT 20
0.001230 0 Analyze
total 0.031352