The Great Wall.
Location: China
2006-04-19 10:27:54.0
of China
<- previous |
Back to Contents
| struct |
|---|
| ENTRYLIST |
1,2,3,4
|
| NEXTID |
0
|
| PREVID |
3
|
| query |
| query |
| RESULTSET |
| query |
| |
CID |
EID |
| 1 |
2
|
1
|
| 2 |
2
|
2
|
| 3 |
3
|
3
|
| 4 |
6
|
4
|
|
| CACHED |
false
|
| EXECUTIONTIME |
15
|
| SQL |
SELECT
e.id AS eid
,c.id AS cid
FROM b_entry AS e
LEFT JOIN b_category AS c ON c.id = e.category_id
WHERE e.live = 1 AND c.live = 1
ORDER BY c.sort ASC, e.sort ASC
|
|
| struct |
|---|
| NEXTID |
1
|
| PREVID |
3
|
| getNextEntry |
| struct |
|---|
| result |
| struct |
|---|
| CACHED |
false
|
| COLUMNLIST |
FIRSTID,NEXTID
|
| EXECUTIONTIME |
0
|
| RECORDCOUNT |
1
|
| SQL |
SELECT MIN(id) AS NextID
,(SELECT MIN(id) FROM b_entry) AS FirstID
FROM b_entry
WHERE id > 4 ORDER BY sort ASC LIMIT 1
|
|
|
| getPrevEntry |
| struct |
|---|
| result |
| struct |
|---|
| CACHED |
false
|
| COLUMNLIST |
LASTID,PREVID
|
| EXECUTIONTIME |
0
|
| RECORDCOUNT |
1
|
| SQL |
SELECT MAX(id) AS PrevID
,(SELECT MAX(id) FROM b_entry) AS lastID
FROM b_entry
WHERE id <4 ORDER BY sort ASC LIMIT 1
|
|
|
| query |
| query |
| RESULTSET |
| query |
| |
CID |
CLIVE |
CONTENT |
CTITLE |
EID |
ELIVE |
ENTRY_DATE |
ETITLE |
LOCATION |
NAME |
PREVIEW |
UID |
| 1 |
6
|
1
|
of China
|
China
|
4
|
1
|
2006-04-19 10:27:54.0
|
The Great Wall.
|
China
|
[empty string]
|
[empty string]
|
[empty string]
|
|
| CACHED |
false
|
| EXECUTIONTIME |
0
|
| SQL |
select e.title as etitle,e.id as eid,e.location,e.entry_date,e.preview,e.content,e.live as elive,
c.title as ctitle,c.id as cid,c.live as clive,
u.name,u.id as uid
from b_entry as e
left join b_category as c on c.id = e.category_id
left join b_users as u on u.id = e.user_id
where e.id = 4
and c.live = 1 and e.live = 1
|
|
| result |
| struct |
|---|
| CACHED |
false
|
| COLUMNLIST |
CID,CLIVE,CONTENT,CTITLE,EID,ELIVE,ENTRY_DATE,ETITLE,LOCATION,NAME,PREVIEW,UID
|
| EXECUTIONTIME |
0
|
| RECORDCOUNT |
1
|
| SQL |
select e.title as etitle,e.id as eid,e.location,e.entry_date,e.preview,e.content,e.live as elive,
c.title as ctitle,c.id as cid,c.live as clive,
u.name,u.id as uid
from b_entry as e
left join b_category as c on c.id = e.category_id
left join b_users as u on u.id = e.user_id
where e.id = 4
and c.live = 1 and e.live = 1
|
|