Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

1.37 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
0.72 ms (52.52%)	1	SELECT count(DISTINCT f0_.id) AS sclr_0 FROM fossildb_fossil f0_ WHERE f0_.approved = 1 AND f0_.taxanomy_id IN (?) Parameters: [`[ 74 ]`] View formatted query View runnable query Explain query SELECT count(DISTINCT f0_.id) AS sclr_0 FROM fossildb_fossil f0_ WHERE f0_.approved = 1 AND f0_.taxanomy_id IN (?) SELECT count(DISTINCT f0_.id) AS sclr_0 FROM fossildb_fossil f0_ WHERE f0_.approved = 1 AND f0_.taxanomy_id IN (74);
0.65 ms (47.48%)	1	SELECT DISTINCT f0_.id AS id_0, f0_.id AS id_1 FROM fossildb_fossil f0_ WHERE f0_.approved = 1 AND f0_.taxanomy_id IN (?) ORDER BY f0_.id DESC LIMIT 10 Parameters: [`[ 74 ]`] View formatted query View runnable query Explain query SELECT DISTINCT f0_.id AS id_0, f0_.id AS id_1 FROM fossildb_fossil f0_ WHERE f0_.approved = 1 AND f0_.taxanomy_id IN (?) ORDER BY f0_.id DESC LIMIT 10 SELECT DISTINCT f0_.id AS id_0, f0_.id AS id_1 FROM fossildb_fossil f0_ WHERE f0_.approved = 1 AND f0_.taxanomy_id IN (74) ORDER BY f0_.id DESC LIMIT 10;

Time▼

Count

Info

0.72 ms
(52.52%)

SELECT count(DISTINCT f0_.id) AS sclr_0 FROM fossildb_fossil f0_ WHERE f0_.approved = 1 AND f0_.taxanomy_id IN (?)

Parameters:

[
  [
    74
  ]
]

View formatted query View runnable query Explain query

SELECT
  count(DISTINCT f0_.id) AS sclr_0
FROM
  fossildb_fossil f0_
WHERE
  f0_.approved = 1
  AND f0_.taxanomy_id IN (?)

SELECT count(DISTINCT f0_.id) AS sclr_0 FROM fossildb_fossil f0_ WHERE f0_.approved = 1 AND f0_.taxanomy_id IN (74);

0.65 ms
(47.48%)

SELECT DISTINCT f0_.id AS id_0, f0_.id AS id_1 FROM fossildb_fossil f0_ WHERE f0_.approved = 1 AND f0_.taxanomy_id IN (?) ORDER BY f0_.id DESC LIMIT 10

Parameters:

[
  [
    74
  ]
]

View formatted query View runnable query Explain query

SELECT
  DISTINCT f0_.id AS id_0,
  f0_.id AS id_1
FROM
  fossildb_fossil f0_
WHERE
  f0_.approved = 1
  AND f0_.taxanomy_id IN (?)
ORDER BY
  f0_.id DESC
LIMIT
  10

SELECT DISTINCT f0_.id AS id_0, f0_.id AS id_1 FROM fossildb_fossil f0_ WHERE f0_.approved = 1 AND f0_.taxanomy_id IN (74) ORDER BY f0_.id DESC LIMIT 10;

forumdb connection

No database queries were performed.

Database Connections

Name	Service
default	doctrine.dbal.default_connection
forumdb	doctrine.dbal.forumdb_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
forumdb	doctrine.orm.forumdb_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\FossildbFossil	No errors.

forumdb entity manager

No loaded entities.