Query Metrics

6 Database Queries
3 Different statements
3.23 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.72 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.thumbnail AS thumbnail_6, t0.document AS document_7, t0.promoted AS promoted_8, t0.theme AS theme_9, t0.published_at AS published_at_10, t0.slug AS slug_11, t0.type AS type_12, t0.price AS price_13, t0.is_purchasable AS is_purchasable_14, t0.additional_infos AS additional_infos_15, t0.position_on_home AS position_on_home_16, t0.main_pdf AS main_pdf_17, t0.bonus_docs AS bonus_docs_18, t0.available_on_premium AS available_on_premium_19, t0.deleted_at AS deleted_at_20, t0.customer_id AS customer_id_21, t0.parent_id AS parent_id_22 FROM infographic t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "la-procedure-d-instruction-en-cas-de-rechute-ou-de-nouvelles-lesions"
]
2 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4 FROM category t0 INNER JOIN infographic_category ON t0.id = infographic_category.category_id WHERE infographic_category.infographic_id = ?
Parameters:
[
  72
]
3 1.01 ms
SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.description AS description_2, i0_.created_at AS created_at_3, i0_.updated_at AS updated_at_4, i0_.thumbnail AS thumbnail_5, i0_.document AS document_6, i0_.promoted AS promoted_7, i0_.theme AS theme_8, i0_.published_at AS published_at_9, i0_.slug AS slug_10, i0_.type AS type_11, i0_.price AS price_12, i0_.is_purchasable AS is_purchasable_13, i0_.additional_infos AS additional_infos_14, i0_.position_on_home AS position_on_home_15, i0_.main_pdf AS main_pdf_16, i0_.bonus_docs AS bonus_docs_17, i0_.available_on_premium AS available_on_premium_18, i0_.deleted_at AS deleted_at_19, i0_.customer_id AS customer_id_20, i0_.parent_id AS parent_id_21 FROM infographic i0_ WHERE i0_.deleted_at IS NULL AND EXISTS (SELECT 1 FROM infographic_category i1_ WHERE i1_.infographic_id = i0_.id AND i1_.category_id IN (?)) AND i0_.type IN (?, ?, ?, ?) ORDER BY RAND() ASC LIMIT 3
Parameters:
[
  6
  "credits"
  "hors_pack"
  "freemium"
  "book"
]
4 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4 FROM category t0 INNER JOIN infographic_category ON t0.id = infographic_category.category_id WHERE infographic_category.infographic_id = ?
Parameters:
[
  70
]
5 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4 FROM category t0 INNER JOIN infographic_category ON t0.id = infographic_category.category_id WHERE infographic_category.infographic_id = ?
Parameters:
[
  95
]
6 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4 FROM category t0 INNER JOIN infographic_category ON t0.id = infographic_category.category_id WHERE infographic_category.infographic_id = ?
Parameters:
[
  65
]

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\Infographics\Infographic No errors.
App\Entity\Customer\Profile No errors.
App\Entity\Category No errors.