Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

4 Database Queries

3 Different statements

1.48 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.54 ms (36.11%)	1	SELECT COUNT(b0_.id) AS sclr_0 FROM blog_article b0_ INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id AND (b1_.locale LIKE ?) WHERE b0_.is_active = 1 AND b1_.slug IS NOT NULL ORDER BY b0_.date_publication DESC Parameters: [`"de"`] View formatted query View runnable query Explain query SELECT COUNT(b0_.id) AS sclr_0 FROM blog_article b0_ INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id AND (b1_.locale LIKE ?) WHERE b0_.is_active = 1 AND b1_.slug IS NOT NULL ORDER BY b0_.date_publication DESC SELECT COUNT(b0_.id) AS sclr_0 FROM blog_article b0_ INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id AND (b1_.locale LIKE 'de') WHERE b0_.is_active = 1 AND b1_.slug IS NOT NULL ORDER BY b0_.date_publication DESC;
0.49 ms (33.29%)	2	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
0.45 ms (30.60%)	1	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"c1dr"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'c1dr' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;

Time▼

Count

Info

0.54 ms
(36.11%)

SELECT COUNT(b0_.id) AS sclr_0 FROM blog_article b0_ INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id AND (b1_.locale LIKE ?) WHERE b0_.is_active = 1 AND b1_.slug IS NOT NULL ORDER BY b0_.date_publication DESC

Parameters:

[
  "de"
]

View formatted query View runnable query Explain query

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  blog_article b0_
  INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id
  AND (b1_.locale LIKE ?)
WHERE
  b0_.is_active = 1
  AND b1_.slug IS NOT NULL
ORDER BY
  b0_.date_publication DESC

SELECT COUNT(b0_.id) AS sclr_0 FROM blog_article b0_ INNER JOIN blog_article_translation b1_ ON b0_.id = b1_.translatable_id AND (b1_.locale LIKE 'de') WHERE b0_.is_active = 1 AND b1_.slug IS NOT NULL ORDER BY b0_.date_publication DESC;

0.49 ms
(33.29%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

0.45 ms
(30.60%)

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "c1dr"
]

View formatted query View runnable query Explain query

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'c1dr'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

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.

Entities Mapping

Class	Mapping errors
App\Entity\BlogArticle	No errors.
App\Entity\BlogArticleTranslation	No errors.
App\Entity\User	No errors.
App\Entity\BlogCategorie	No errors.

Symfony Profiler

http://dr.espai-web.com/de/blog/page/0

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping