POST https://v2.louqman.fr/api/track/category/list

Query Metrics

14 Database Queries
5 Different statements
9.78 ms Query time
0 Invalid entities
12 Managed entities

Queries

Group similar statements

# Time Info
1 1.11 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.created_at AS created_at_5, t0.roles AS roles_6, t0.password AS password_7, t0.enabled AS enabled_8, t0.username AS username_9, t0.reset_code AS reset_code_10, t0.reset_requested_at AS reset_requested_at_11, t0.register_code AS register_code_12, t0.register_requested_at AS register_requested_at_13, t0.logged_at_least_one_time AS logged_at_least_one_time_14, t0.parent_id AS parent_id_15, t0.avatar_id AS avatar_id_16, t0.level_id AS level_id_17 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  939
]
2 1.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 WHERE t0.id = ?
Parameters:
[
  2
]
3 3.13 ms
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.image AS image_4, t0_.image_path AS image_path_5, t0_.audio_path AS audio_path_6, t0_.enabled AS enabled_7, t0_.image_player_path AS image_player_path_8, t0_.starred AS starred_9 FROM track t0_ INNER JOIN categories_tracks c2_ ON t0_.id = c2_.track_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE t0_.enabled = ? AND c1_.id = ? AND (t0_.name LIKE ? OR t0_.description LIKE ?) ORDER BY t0_.id ASC
Parameters:
[
  1
  2
  "%%"
  "%%"
]
4 0.35 ms
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.created_at AS created_at_3, t0_.image AS image_4, t0_.image_path AS image_path_5, t0_.audio_path AS audio_path_6, t0_.enabled AS enabled_7, t0_.image_player_path AS image_player_path_8, t0_.starred AS starred_9 FROM track t0_ INNER JOIN categories_tracks c2_ ON t0_.id = c2_.track_id INNER JOIN category c1_ ON c1_.id = c2_.category_id WHERE t0_.enabled = ? AND c1_.id = ? AND (t0_.name LIKE ? OR t0_.description LIKE ?) ORDER BY t0_.id ASC LIMIT 10
Parameters:
[
  1
  2
  "%%"
  "%%"
]
5 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
Parameters:
[
  8
]
6 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
Parameters:
[
  9
]
7 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
Parameters:
[
  10
]
8 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
Parameters:
[
  11
]
9 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
Parameters:
[
  12
]
10 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
Parameters:
[
  13
]
11 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
Parameters:
[
  14
]
12 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
Parameters:
[
  15
]
13 0.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
Parameters:
[
  16
]
14 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.enabled AS enabled_6 FROM category t0 INNER JOIN categories_tracks ON t0.id = categories_tracks.category_id WHERE categories_tracks.track_id = ?
Parameters:
[
  17
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Track 10
App\Entity\User 1
App\Entity\Category 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Avatar No errors.
App\Entity\Level No errors.
App\Entity\Playlist No errors.
App\Entity\Notification No errors.
App\Entity\Track No errors.
App\Entity\Membership No errors.
App\Entity\Message No errors.
App\Entity\Category No errors.