GET https://news.cpn.qa.x86lab.com/tag/Optio

Query Metrics

3 Database Queries
3 Different statements
27.31 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
12.54 ms
(45.91%)
1
SELECT n0_.id AS id_0, n0_.is_hidden AS is_hidden_1, n0_.slug AS slug_2, n0_.title AS title_3, n0_.description AS description_4, n0_.content AS content_5, n0_.created_at AS created_at_6, n0_.updated_at AS updated_at_7, n0_.published_at AS published_at_8, n0_.city_id AS city_id_9, n0_.source_id AS source_id_10, n0_.created_by_id AS created_by_id_11, n0_.updated_by_id AS updated_by_id_12 FROM news_post n0_ WHERE EXISTS (SELECT 1 FROM news_post_tag n1_ WHERE n1_.post_id = n0_.id AND n1_.tag_id IN (?)) ORDER BY n0_.id DESC LIMIT 12
Parameters:
[
  387
]
10.70 ms
(39.20%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM news_tag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Optio"
]
4.07 ms
(14.89%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.is_hidden AS is_hidden_1, n0_.slug AS slug_2, n0_.title AS title_3, n0_.description AS description_4, n0_.content AS content_5, n0_.created_at AS created_at_6, n0_.updated_at AS updated_at_7, n0_.published_at AS published_at_8 FROM news_post n0_ WHERE EXISTS (SELECT 1 FROM news_post_tag n1_ WHERE n1_.post_id = n0_.id AND n1_.tag_id IN (?)) ORDER BY n0_.id DESC) dctrn_result) dctrn_table
Parameters:
[
  387
]

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.