GET http://feutech.edu.ph/ftic/ftic/view_program/2

Query Metrics

8 Database Queries
7 Different statements
7.87 ms Query time
0 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 1.05 ms
SELECT t0.id AS id_1, t0.progname AS progname_2, t0.progdesc AS progdesc_3, t0.image AS image_4, t0.status AS status_5 FROM programs t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
2 1.21 ms
SELECT t0.id AS id_1, t0.program AS program_2, t0.title AS title_3, t0.content AS content_4, t0.date AS date_5 FROM prog_article t0 WHERE t0.program = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "2"
]
3 0.82 ms
SELECT t0.id AS id_1, t0.progarticle AS progarticle_2, t0.image AS image_3 FROM article_image t0 WHERE t0.progarticle = ?
Parameters:
[
  9
]
4 0.91 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prog_article p0_ WHERE p0_.program = ?
Parameters:
[
  "2"
]
5 0.79 ms
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM prog_article p0_ WHERE p0_.program = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[
  "2"
]
6 1.19 ms
SELECT p0_.id AS id_0, p0_.program AS program_1, p0_.title AS title_2, p0_.content AS content_3, p0_.date AS date_4 FROM prog_article p0_ WHERE p0_.program = ? AND p0_.id IN (?) ORDER BY p0_.id DESC
Parameters:
[
  "2"
  9
]
7 0.85 ms
SELECT t0.id AS id_1, t0.progarticle AS progarticle_2, t0.image AS image_3 FROM article_image t0 WHERE t0.progarticle = ?
Parameters:
[
  9
]
8 1.05 ms
SELECT p0_.id AS id_0, p0_.progname AS progname_1, p0_.progdesc AS progdesc_2, p0_.image AS image_3, p0_.status AS status_4 FROM programs p0_ WHERE p0_.status = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Programs 7
App\Entity\ProgArticle 1
App\Entity\ArticleImage 1

Entities Mapping

Class Mapping errors
App\Entity\Programs No errors.
App\Entity\ProgArticle No errors.
App\Entity\ArticleImage No errors.