GET http://street-fighter-6.anagraph.org/en/news/index?page=66

Query Metrics

4 Database Queries
4 Different statements
45.07 ms Query time
0 Invalid entities
23 Managed entities

Grouped Statements

Show all queries

Time Count Info
30.17 ms
(66.95%)
1
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_3 FROM (SELECT p0_.id AS id_0, p0_.link AS link_1, p0_.title AS title_2, p0_.published_at AS published_at_3, p0_.heading AS heading_4, p0_.language AS language_5, p0_.banner_link AS banner_link_6, p0_.tags AS tags_7 FROM post p0_) dctrn_result_inner ORDER BY published_at_3 DESC) dctrn_result LIMIT 20 OFFSET 1300
Parameters:
[]
12.40 ms
(27.52%)
1
SELECT DISTINCT p0_.language AS language_0 FROM post p0_ WHERE p0_.language IS NOT NULL
Parameters:
[]
2.11 ms
(4.68%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.link AS link_1, p0_.title AS title_2, p0_.published_at AS published_at_3, p0_.heading AS heading_4, p0_.language AS language_5, p0_.banner_link AS banner_link_6, p0_.tags AS tags_7 FROM post p0_ ORDER BY p0_.published_at DESC) dctrn_result) dctrn_table
Parameters:
[]
0.38 ms
(0.85%)
1
SELECT p0_.id AS id_0, p0_.link AS link_1, p0_.title AS title_2, p0_.published_at AS published_at_3, p0_.heading AS heading_4, p0_.language AS language_5, p0_.banner_link AS banner_link_6, p0_.tags AS tags_7, p0_.source_id AS source_id_8 FROM post p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.published_at DESC
Parameters:
[
  1078
  1079
  1096
  1121
  1080
  1082
  1085
  1088
  1097
  1091
  1093
  1094
  1055
  1058
  1059
  1071
  1072
  1067
  1073
  1074
]

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\news\Post 20
App\Entity\news\Feed 3

Entities Mapping

Class Mapping errors
App\Entity\news\Post No errors.
App\Entity\news\Feed No errors.