| 0.0007 |
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.0029 |
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.0067 |
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 0
) ca
|
| 0.0004 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'HK'
AND post_board_no='2163'
order by num asc
|
| 0.0004 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'HK'
AND post_board_no='2162'
order by num asc
|
| 0.0004 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'HK'
AND post_board_no='2154'
order by num asc
|
| 0.0004 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'HK'
AND post_board_no='2152'
order by num asc
|
| 0.0004 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'HK'
AND post_board_no='2149'
order by num asc
|
| 0.0012 |
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.0027 |
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 0
) ca
|
| 0.0004 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'HK'
AND post_board_no='2163'
order by num asc
|
| 0.0004 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'HK'
AND post_board_no='2149'
order by num asc
|
| 0.0003 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'HK'
AND post_board_no='2024'
order by num asc
|
| 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
|
857
0
