✕

DB connection (class: Sqlite) [sqlite:app/data/vadimkor.sqlite]: (0 msec) OK

SQL#1 (0 msec) [OK 0] [pragma foreign_keys = ON]

get current page...

SQL#2 (1 msec) [OK 0] [select sec.*, (case when sec.pub_dt<=:t then 0 else 1 end) future_is, coalesce(dst.url, sec.url) rurl from sec left join sec dst on (sec.dst_sec_id=dst.id) where sec.e=1 and sec.pub_dt<=:t and sec.id=:id order by sec.seq_int, sec.id limit 1 offset 0] {Array ( [pid] => 0 [zon] => [id] => 42 [t] => 1715909049 ) }

ROW: Array ( [id] => 42 [sec_id] => 3 [dst_sec_id] => [url] => [e] => 1 [zon_id] => nav [nm] => vadimkor [excerpt_tx] => [body_ht] => - Разработка веб-сайтов, приложений, интерфейсов - Онлайн базы данных - Серверные скрипты --- [GitHub](https://github.com/vvvkor) [prs_id] => md [seq_int] => 1 [h1] => [title] => [pub_dt] => 0 [fn] => [prm] => [] [icon] => [lay] => [tpl] => [subtpl] => [future_is] => 0 [rurl] => )

get menu...

SQL#3 (1 msec) [OK 0] [select sec.id, sec.sec_id, sec.dst_sec_id, sec.url, sec.e, sec.zon_id, sec.nm, sec.prs_id, sec.seq_int, sec.h1, sec.title, sec.icon, sec.pub_dt, sec.fn, sec.excerpt_tx subtitle, (case when sec.pub_dt<=:t then 0 else 1 end) future_is, coalesce(dst.url, sec.url) rurl from sec left join sec dst on (sec.dst_sec_id=dst.id) where sec.e=1 and sec.pub_dt<=:t and sec.zon_id=:zon order by sec.seq_int, sec.id] {Array ( [pid] => 0 [zon] => nav [id] => 0 [t] => 1715909049 ) }

ROWS: 54

get breadcrumbs...

get subsections...

SQL#4 (0 msec) [OK 0] [select sec.id, sec.sec_id, sec.dst_sec_id, sec.url, sec.e, sec.zon_id, sec.nm, sec.prs_id, sec.seq_int, sec.h1, sec.title, sec.icon, sec.pub_dt, sec.fn, sec.excerpt_tx subtitle, (case when sec.pub_dt<=:t then 0 else 1 end) future_is, coalesce(dst.url, sec.url) rurl from sec left join sec dst on (sec.dst_sec_id=dst.id) where sec.e=1 and sec.pub_dt<=:t and sec.sec_id=:pid order by substr(sec.zon_id, 2), sec.seq_int, sec.id] {Array ( [pid] => 42 [zon] => [id] => 0 [t] => 1715909049 ) }

ROWS: 0

get articles...

SQL#5 (0 msec) [OK 0] [select sec.*, (case when sec.pub_dt<=:t then 0 else 1 end) future_is, coalesce(dst.url, sec.url) rurl from sec left join sec dst on (sec.dst_sec_id=dst.id) where sec.e=1 and sec.pub_dt<=:t and sec.sec_id=:pid and sec.zon_id=:zon order by sec.seq_int, sec.id] {Array ( [pid] => 42 [zon] => content [id] => 0 [t] => 1715909049 ) }

ROWS: 0