Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

43.20 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
43.20 ms (100.00%)	1	SELECT DISTINCT categorie.id, categorie.title FROM categorie WHERE categorie.id IN ( SELECT DISTINCT article_categorie.id_categorie_id FROM article_categorie, article WHERE article.id = article_categorie.id_article_id AND article.etat = 0 AND article.is_pro = 0 OR article.is_pro = 2); Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT categorie.id, categorie.title FROM categorie WHERE categorie.id IN ( SELECT DISTINCT article_categorie.id_categorie_id FROM article_categorie, article WHERE article.id = article_categorie.id_article_id AND article.etat = 0 AND article.is_pro = 0 OR article.is_pro = 2 ); SELECT DISTINCT categorie.id, categorie.title FROM categorie WHERE categorie.id IN ( SELECT DISTINCT article_categorie.id_categorie_id FROM article_categorie, article WHERE article.id = article_categorie.id_article_id AND article.etat = 0 AND article.is_pro = 0 OR article.is_pro = 2);;

Time▼

Count

Info

43.20 ms
(100.00%)

SELECT  DISTINCT categorie.id, categorie.title
        FROM categorie
        WHERE categorie.id IN ( SELECT DISTINCT article_categorie.id_categorie_id
        FROM article_categorie, article
       WHERE article.id = article_categorie.id_article_id
       AND article.etat = 0
       AND article.is_pro = 0
       OR article.is_pro = 2);

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT categorie.id,
  categorie.title
FROM
  categorie
WHERE
  categorie.id IN (
    SELECT
      DISTINCT article_categorie.id_categorie_id
    FROM
      article_categorie,
      article
    WHERE
      article.id = article_categorie.id_article_id
      AND article.etat = 0
      AND article.is_pro = 0
      OR article.is_pro = 2
  );

SELECT  DISTINCT categorie.id, categorie.title
        FROM categorie
        WHERE categorie.id IN ( SELECT DISTINCT article_categorie.id_categorie_id
        FROM article_categorie, article
       WHERE article.id = article_categorie.id_article_id
       AND article.etat = 0
       AND article.is_pro = 0
       OR article.is_pro = 2);;

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\Categorie	No errors.

Symfony Profiler

https://my-audio-api.server-preprod.ovh/articles/categories/withArticle

Configuration Settings

Theme