| 0.0006 |
select * from basic.post_type where 0=0 and num='15' and nationcode='HK'
|
| 0.0006 |
select * from basic.post_category where nationcode='HK' and code = 15 order by num
|
| 0.0021 |
SELECT COUNT(a.num) AS cnt
FROM basic.post_board a
LEFT JOIN basic.post_category b ON a.categorycode=b.num and a.nationcode=b.nationcode
LEFT JOIN basic.post_movie e ON a.num=e.post_board_no
WHERE a.isuse='Y' AND ( a.code = 15 AND a.nationcode = 'HK' )
|
| 0.0105 |
SELECT
ca.*
, (SELECT basic.rate_calc(ca.ppd_avg, ca.mpr_avg, ca.ppd_cnt, ca.mpr_cnt, '')) AS webrate
, (SELECT basic.rate_calc(ca.ppd_avg, ca.mpr_avg, ca.ppd_cnt, ca.mpr_cnt, 'class_num')) AS class_num_30
, 0 AS isnew_flag
FROM (
SELECT
a.*
, COALESCE(b.categoryname,'') categoryname
, a.code as codes
, a.board_move
, e.movie_url
, e.image_url
, f.status
, ca.ppd_avg, ca.mpr_avg, ca.ppd_cnt, ca.mpr_cnt, a.view_dt
FROM basic.post_board a
LEFT JOIN basic.post_category b ON a.categorycode=b.num and a.nationcode=b.nationcode
LEFT JOIN basic.post_movie e ON a.num=e.post_board_no
LEFT JOIN basic.cardinfo f ON a.c_seq=f.c_seq
LEFT JOIN basic.card_avg ca ON a.c_seq = ca.c_seq
WHERE
a.isuse='Y' AND ( a.code = 15 AND a.nationcode = 'HK' )
ORDER BY
a.isautolist DESC, a.ord_num ASC, a.create_dt DESC
LIMIT 5 OFFSET 25
) ca
|
| 0.0004 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'HK'
AND post_board_no='2049'
order by num asc
|
| 0.0004 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'HK'
AND post_board_no='2047'
order by num asc
|
| 0.0003 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'HK'
AND post_board_no='2044'
order by num asc
|
| 0.0003 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'HK'
AND post_board_no='2043'
order by num asc
|
| 0.0003 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'HK'
AND post_board_no='2039'
order by num asc
|
| 0.0013 |
SELECT COUNT(a.num) AS cnt
FROM basic.post_board a
LEFT JOIN basic.post_category b ON a.categorycode=b.num and a.nationcode=b.nationcode
LEFT JOIN basic.post_movie e ON a.num=e.post_board_no
WHERE a.isuse='Y' AND ( a.code = 15 AND a.nationcode = 'HK' ) AND isnotice='1'
|
| 0.0023 |
SELECT
ca.*
, (SELECT basic.rate_calc(ca.ppd_avg, ca.mpr_avg, ca.ppd_cnt, ca.mpr_cnt, '')) AS webrate
, (SELECT basic.rate_calc(ca.ppd_avg, ca.mpr_avg, ca.ppd_cnt, ca.mpr_cnt, 'class_num')) AS class_num_30
, 0 AS isnew_flag
FROM (
SELECT
a.*
, COALESCE(b.categoryname,'') categoryname
, a.code as codes
, a.board_move
, e.movie_url
, e.image_url
, f.status
, ca.ppd_avg, ca.mpr_avg, ca.ppd_cnt, ca.mpr_cnt, a.view_dt
FROM basic.post_board a
LEFT JOIN basic.post_category b ON a.categorycode=b.num and a.nationcode=b.nationcode
LEFT JOIN basic.post_movie e ON a.num=e.post_board_no
LEFT JOIN basic.cardinfo f ON a.c_seq=f.c_seq
LEFT JOIN basic.card_avg ca ON a.c_seq = ca.c_seq
WHERE
a.isuse='Y' AND ( a.code = 15 AND a.nationcode = 'HK' ) AND isnotice='1'
ORDER BY
a.isautolist DESC, a.ord_num ASC, a.create_dt DESC
LIMIT 3 OFFSET 15
) ca
|
| 0.0004 |
SELECT * FROM basic.logofooter WHERE nationcode = 'HK'
|
| 0.0003 |
SELECT "timezone"
FROM "basic"."nation_code"
WHERE "nationcode" = 'HK'
|
| 0.0003 |
SET TIMEZONE='Asia/Hong_Kong'
|
| 0.0006 |
SELECT
TO_CHAR(isnew_dt, 'YYYY-MM-DD') c_date
FROM
basic.post_board a
LEFT JOIN basic.post_category b ON a.categorycode = b.num AND a.nationcode = b.nationcode
WHERE isnotice = 0 AND a.isuse = 'Y' AND a.code = 1000161 AND a.nationcode = 'HK' ORDER BY a.num DESC LIMIT 1
|
1551
0
