Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

2.64 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	2.64 ms	SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.icon AS icon_3, a0_.article_count AS article_count_4, a0_.modified AS modified_5, a0_.created AS created_6, a0_.is_multi AS is_multi_7, a1_.id AS id_8, a1_.name AS name_9, a1_.description AS description_10, a1_.copy AS copy_11, a1_.modified AS modified_12, a1_.created AS created_13, a0_.page_id AS page_id_14, a1_.user_id AS user_id_15, a1_.article_id AS article_id_16 FROM articles a0_ INNER JOIN article_details a1_ ON a0_.id = a1_.article_id WHERE a0_.page_id = ? ORDER BY a0_.name ASC Parameters: [`"4"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.icon AS icon_3, a0_.article_count AS article_count_4, a0_.modified AS modified_5, a0_.created AS created_6, a0_.is_multi AS is_multi_7, a1_.id AS id_8, a1_.name AS name_9, a1_.description AS description_10, a1_.copy AS copy_11, a1_.modified AS modified_12, a1_.created AS created_13, a0_.page_id AS page_id_14, a1_.user_id AS user_id_15, a1_.article_id AS article_id_16 FROM articles a0_ INNER JOIN article_details a1_ ON a0_.id = a1_.article_id WHERE a0_.page_id = ? ORDER BY a0_.name ASC SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.icon AS icon_3, a0_.article_count AS article_count_4, a0_.modified AS modified_5, a0_.created AS created_6, a0_.is_multi AS is_multi_7, a1_.id AS id_8, a1_.name AS name_9, a1_.description AS description_10, a1_.copy AS copy_11, a1_.modified AS modified_12, a1_.created AS created_13, a0_.page_id AS page_id_14, a1_.user_id AS user_id_15, a1_.article_id AS article_id_16 FROM articles a0_ INNER JOIN article_details a1_ ON a0_.id = a1_.article_id WHERE a0_.page_id = '4' ORDER BY a0_.name ASC;

#▲

Time

Info

2.64 ms

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.icon AS icon_3, a0_.article_count AS article_count_4, a0_.modified AS modified_5, a0_.created AS created_6, a0_.is_multi AS is_multi_7, a1_.id AS id_8, a1_.name AS name_9, a1_.description AS description_10, a1_.copy AS copy_11, a1_.modified AS modified_12, a1_.created AS created_13, a0_.page_id AS page_id_14, a1_.user_id AS user_id_15, a1_.article_id AS article_id_16 FROM articles a0_ INNER JOIN article_details a1_ ON a0_.id = a1_.article_id WHERE a0_.page_id = ? ORDER BY a0_.name ASC

Parameters:

[
  "4"
]

View formatted query View runnable query Explain query

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.icon AS icon_3,
  a0_.article_count AS article_count_4,
  a0_.modified AS modified_5,
  a0_.created AS created_6,
  a0_.is_multi AS is_multi_7,
  a1_.id AS id_8,
  a1_.name AS name_9,
  a1_.description AS description_10,
  a1_.copy AS copy_11,
  a1_.modified AS modified_12,
  a1_.created AS created_13,
  a0_.page_id AS page_id_14,
  a1_.user_id AS user_id_15,
  a1_.article_id AS article_id_16
FROM
  articles a0_
  INNER JOIN article_details a1_ ON a0_.id = a1_.article_id
WHERE
  a0_.page_id = ?
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.icon AS icon_3, a0_.article_count AS article_count_4, a0_.modified AS modified_5, a0_.created AS created_6, a0_.is_multi AS is_multi_7, a1_.id AS id_8, a1_.name AS name_9, a1_.description AS description_10, a1_.copy AS copy_11, a1_.modified AS modified_12, a1_.created AS created_13, a0_.page_id AS page_id_14, a1_.user_id AS user_id_15, a1_.article_id AS article_id_16 FROM articles a0_ INNER JOIN article_details a1_ ON a0_.id = a1_.article_id WHERE a0_.page_id = '4' ORDER BY a0_.name ASC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
remote	doctrine.dbal.remote_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
remote	doctrine.orm.remote_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Articles	No errors.
App\Entity\ArticleDetails	No errors.
App\Entity\Pages	No errors.
App\Entity\User	No errors.

remote entity manager

No loaded entities.