performance log

no query time rows -
1
/shop/_header.php @ 187 line
select count(*) from mini_counter where day=20210922
0.001340 0 Analyze
2
/shop/_header.php @ 187 line
select count(*) from mini_ip where idx_date=20210922 and ip='34.239.160.86'
0.001000 0 Analyze
3
/shop/_header.php @ 187 line
update mini_counter set pageviews=pageviews+1 where day=curdate()+0 or day=0
0.004270 0 Analyze
4
/shop/mypage/mypage_qna.php @ 3 line
select use_only_adult from gd_goods where goodsno=''
0.000970 0 Analyze
5
/shop/mypage/mypage_qna.php @ 3 line
select font_code,`use` from gd_webfont where now() between expire_start and expire_end and LENGTH(`use`)
0.000950 0 Analyze
6
/shop/lib/config.class.php @ 35 line
select name,value from gd_env where category="godofont"
0.000880 0 Analyze
7
/shop/lib/config.class.php @ 35 line
select name,value from gd_env where category="aboutcoupon"
0.000880 0 Analyze
8
/shop/lib/config.class.php @ 35 line
select name,value from gd_env where category="ghostbanker"
0.000880 0 Analyze
9
/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.001160 0 Analyze
total 0.012335