GET https://kinkyclub.e-world-france.fr/categories

Query Metrics

9 Database Queries
5 Different statements
4.62 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.69 ms
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.image AS image_2, c0_.is_active AS is_active_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.sort_order AS sort_order_6, c1_.id AS id_7, c1_.locale AS locale_8, c1_.title AS title_9, c1_.description AS description_10, c1_.created_at AS created_at_11, c1_.updated_at AS updated_at_12, c1_.category_id AS category_id_13 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id AND (c1_.locale = ?) WHERE c0_.is_active = 1 ORDER BY c0_.sort_order ASC, c0_.title ASC
Parameters:
[
  "fr"
]
2 0.98 ms
SELECT COUNT(v0_.id) AS sclr_0 FROM video v0_ INNER JOIN video_categories v2_ ON v0_.id = v2_.video_id INNER JOIN category c1_ ON c1_.id = v2_.category_id WHERE c1_.id = ? AND v0_.is_active = 1
Parameters:
[
  1
]
3 0.73 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ INNER JOIN photo_categories p2_ ON p0_.id = p2_.photo_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id = ? AND p0_.is_active = 1
Parameters:
[
  1
]
4 0.34 ms
SELECT COUNT(v0_.id) AS sclr_0 FROM video v0_ INNER JOIN video_categories v2_ ON v0_.id = v2_.video_id INNER JOIN category c1_ ON c1_.id = v2_.category_id WHERE c1_.id = ? AND v0_.is_active = 1
Parameters:
[
  2
]
5 0.59 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ INNER JOIN photo_categories p2_ ON p0_.id = p2_.photo_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id = ? AND p0_.is_active = 1
Parameters:
[
  2
]
6 0.31 ms
SELECT COUNT(v0_.id) AS sclr_0 FROM video v0_ INNER JOIN video_categories v2_ ON v0_.id = v2_.video_id INNER JOIN category c1_ ON c1_.id = v2_.category_id WHERE c1_.id = ? AND v0_.is_active = 1
Parameters:
[
  3
]
7 0.30 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM photo p0_ INNER JOIN photo_categories p2_ ON p0_.id = p2_.photo_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id = ? AND p0_.is_active = 1
Parameters:
[
  3
]
8 0.43 ms
SELECT COUNT(c0_.id) AS sclr_0 FROM comments c0_ WHERE c0_.created_at >= ?
Parameters:
[
  "2026-01-22 00:00:00"
]
9 0.24 ms
SELECT COUNT(c0_.id) AS sclr_0 FROM contact_message c0_ WHERE c0_.is_read = ?
Parameters:
[
  0
]

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\Category No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\Video No errors.
App\Entity\Photo No errors.
App\Entity\Comment No errors.
App\Entity\ContactMessage No errors.