GET https://spmvc.saalahmed.me/posts

Query Metrics

9 Database Queries
4 Different statements
2.81 ms Query time
0 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 0.90 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM post p0_ WHERE p0_.is_published = ? AND p0_.post_at <= ?
Parameters:
[
  1
  "2026-01-10 05:06:12"
]
2 0.38 ms
SELECT DISTINCT p0_.id AS id_0, p0_.post_at AS post_at_1 FROM post p0_ WHERE p0_.is_published = ? AND p0_.post_at <= ? ORDER BY p0_.post_at DESC LIMIT 6
Parameters:
[
  1
  "2026-01-10 05:06:12"
]
3 0.62 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.featured_image AS featured_image_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.post_at AS post_at_6, p0_.is_published AS is_published_7, p0_.author_id AS author_id_8, p0_.updated_by_id AS updated_by_id_9 FROM post p0_ WHERE p0_.is_published = ? AND p0_.post_at <= ? AND p0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY p0_.post_at DESC
Parameters:
[
  1
  "2026-01-10 05:06:12"
  14
  12
  11
  10
  9
  8
]
4 0.26 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_approved AS is_approved_5, t0.author_id AS author_id_6, t0.post_id AS post_id_7, t0.updated_by_id AS updated_by_id_8 FROM comment t0 WHERE t0.post_id = ?
Parameters:
[
  14
]
5 0.14 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_approved AS is_approved_5, t0.author_id AS author_id_6, t0.post_id AS post_id_7, t0.updated_by_id AS updated_by_id_8 FROM comment t0 WHERE t0.post_id = ?
Parameters:
[
  12
]
6 0.15 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_approved AS is_approved_5, t0.author_id AS author_id_6, t0.post_id AS post_id_7, t0.updated_by_id AS updated_by_id_8 FROM comment t0 WHERE t0.post_id = ?
Parameters:
[
  11
]
7 0.12 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_approved AS is_approved_5, t0.author_id AS author_id_6, t0.post_id AS post_id_7, t0.updated_by_id AS updated_by_id_8 FROM comment t0 WHERE t0.post_id = ?
Parameters:
[
  10
]
8 0.11 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_approved AS is_approved_5, t0.author_id AS author_id_6, t0.post_id AS post_id_7, t0.updated_by_id AS updated_by_id_8 FROM comment t0 WHERE t0.post_id = ?
Parameters:
[
  9
]
9 0.11 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_approved AS is_approved_5, t0.author_id AS author_id_6, t0.post_id AS post_id_7, t0.updated_by_id AS updated_by_id_8 FROM comment t0 WHERE t0.post_id = ?
Parameters:
[
  8
]

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\Post 6
App\Entity\User 2
App\Entity\Comment 1

Entities Mapping

Class Mapping errors
App\Entity\Post No errors.
App\Entity\User No errors.
App\Entity\Comment No errors.