| 0.0007 |
select * from basic.post_type where 0=0 and num='15' and nationcode='TW'
|
| 0.0005 |
select * from basic.post_category where nationcode='TW' and code = 15 order by num
|
| 0.0015 |
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 = 'TW' )
|
| 0.0041 |
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 = 'TW' )
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 = 'TW'
AND post_board_no='1003794'
order by num asc
|
| 0.0004 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'TW'
AND post_board_no='860'
order by num asc
|
| 0.0003 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'TW'
AND post_board_no='859'
order by num asc
|
| 0.0004 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'TW'
AND post_board_no='858'
order by num asc
|
| 0.0003 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'TW'
AND post_board_no='853'
order by num asc
|
| 0.0009 |
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 = 'TW' ) 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 = 'TW' ) 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 = 'TW'
AND post_board_no='860'
order by num asc
|
| 0.0003 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'TW'
AND post_board_no='859'
order by num asc
|
| 0.0003 |
SELECT
* , url as fileurl
FROM
basic.post_pds
WHERE
nationcode = 'TW'
AND post_board_no='852'
order by num asc
|
| 0.0004 |
SELECT * FROM basic.logofooter WHERE nationcode = 'TW'
|
| 0.0003 |
SELECT "timezone"
FROM "basic"."nation_code"
WHERE "nationcode" = 'TW'
|
| 0.0004 |
SET TIMEZONE='Asia/Taipei'
|
| 0.0005 |
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 = 'TW' ORDER BY a.num DESC LIMIT 1
|
81
0
