OMHSAS
Sub-topics
Articles (0)
No articles in this topic yet.
No articles in this topic yet.
| # | Time | SQL | Params | Trace |
|---|---|---|---|---|
| 1 | 1.40ms | /* PDO CONNECT to 127.0.0.1:3306/knowledgebase */ | — | /var/www/html/kb/public/inc/db.php:29 DB::get() → /var/www/html/kb/public/inc/db.php:42 DB::query() → /var/www/html/kb/public/topic.php:7 DB::row() |
| 2 | 2.17ms | SELECT * FROM topics WHERE slug = ? | ["omhsas"] | /var/www/html/kb/public/inc/db.php:42 DB::query() → /var/www/html/kb/public/topic.php:7 DB::row() |
| 3 | 0.89ms | SELECT t.*, COUNT(at2.article_id) as article_count FROM topics t LEFT JOIN article_topics at2 ON at2.topic_id = t.id WHERE t.parent_id = ? GROUP BY t.id ORDER BY t.sort_order, t.title | [3] | /var/www/html/kb/public/inc/db.php:38 DB::query() → /var/www/html/kb/public/topic.php:16 DB::all() |
| 4 | 0.74ms | SELECT COUNT(*) FROM articles a JOIN article_topics at2 ON at2.article_id = a.id WHERE at2.topic_id = ? AND a.status = 'published' | [3] | /var/www/html/kb/public/inc/db.php:47 DB::query() → /var/www/html/kb/public/topic.php:31 DB::val() |
| 5 | 0.75ms | SELECT a.id, a.slug, a.title, a.status, a.created_at, a.views, u.username FROM articles a JOIN users u ON u.id = a.created_by JOIN article_topics at2 ON at2.article_id = a.id WHERE at2.topic_id = ? AND a.status = 'published' ORDER BY a.created_at DESC LIMIT ? OFFSET ? | [3,20,0] | /var/www/html/kb/public/inc/db.php:38 DB::query() → /var/www/html/kb/public/topic.php:37 DB::all() |
| 6 | 0.62ms | SELECT id, parent_id, slug, title FROM topics WHERE id = ? | [3] | /var/www/html/kb/public/inc/db.php:42 DB::query() → /var/www/html/kb/public/inc/functions.php:99 DB::row() → /var/www/html/kb/public/topic.php:49 topic_breadcrumb() |
| 7 | 0.60ms | SELECT id, parent_id, slug, title FROM topics WHERE id = ? | [1] | /var/www/html/kb/public/inc/db.php:42 DB::query() → /var/www/html/kb/public/inc/functions.php:99 DB::row() → /var/www/html/kb/public/topic.php:49 topic_breadcrumb() |
| # | Op | Hit | Time | Key |
|---|---|---|---|---|
| 1 | GET | HIT | 0.68ms | topic_tree |