GET https://flyspa-api.dvpt.pulsweb.ch/api/client/domaines?limit=10&page=0

Query Metrics

21 Database Queries
5 Different statements
57.68 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 16.76 ms
SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.logo AS logo_2, d0_.description AS description_3, d0_.is_active AS is_active_4 FROM domain d0_ ORDER BY d0_.id DESC
Parameters:
[]
2 5.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.domaine_id AS domaine_id_6 FROM category t0 WHERE t0.domaine_id = ?
Parameters:
[
  11
]
3 0.41 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.domaine_id AS domaine_id_6 FROM category t0 WHERE t0.domaine_id = ?
Parameters:
[
  10
]
4 0.34 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.domaine_id AS domaine_id_6 FROM category t0 WHERE t0.domaine_id = ?
Parameters:
[
  9
]
5 7.03 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.domaine_id AS domaine_id_6 FROM category t0 WHERE t0.domaine_id = ?
Parameters:
[
  8
]
6 7.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.logo AS logo_4, t0.price AS price_5, t0.is_active AS is_active_6, t0.duration AS duration_7, t0.subcategory_id AS subcategory_id_8, t0.category_id AS category_id_9 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
  8
]
7 6.09 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.category_id AS category_id_6 FROM sub_category t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 9.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.price AS price_5, t0.duration AS duration_6, t0.is_active AS is_active_7, t0.product_id AS product_id_8 FROM sub_product t0 WHERE t0.product_id = ?
Parameters:
[
  3
]
9 0.41 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.price AS price_5, t0.duration AS duration_6, t0.is_active AS is_active_7, t0.product_id AS product_id_8 FROM sub_product t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
10 0.36 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.price AS price_5, t0.duration AS duration_6, t0.is_active AS is_active_7, t0.product_id AS product_id_8 FROM sub_product t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
11 0.39 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.domaine_id AS domaine_id_6 FROM category t0 WHERE t0.domaine_id = ?
Parameters:
[
  7
]
12 0.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.domaine_id AS domaine_id_6 FROM category t0 WHERE t0.domaine_id = ?
Parameters:
[
  6
]
13 0.41 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.domaine_id AS domaine_id_6 FROM category t0 WHERE t0.domaine_id = ?
Parameters:
[
  5
]
14 0.42 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.domaine_id AS domaine_id_6 FROM category t0 WHERE t0.domaine_id = ?
Parameters:
[
  4
]
15 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.domaine_id AS domaine_id_6 FROM category t0 WHERE t0.domaine_id = ?
Parameters:
[
  3
]
16 0.35 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.domaine_id AS domaine_id_6 FROM category t0 WHERE t0.domaine_id = ?
Parameters:
[
  2
]
17 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.logo AS logo_4, t0.price AS price_5, t0.is_active AS is_active_6, t0.duration AS duration_7, t0.subcategory_id AS subcategory_id_8, t0.category_id AS category_id_9 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
  9
]
18 0.36 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.price AS price_5, t0.duration AS duration_6, t0.is_active AS is_active_7, t0.product_id AS product_id_8 FROM sub_product t0 WHERE t0.product_id = ?
Parameters:
[
  5
]
19 0.34 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.domaine_id AS domaine_id_6 FROM category t0 WHERE t0.domaine_id = ?
Parameters:
[
  1
]
20 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.logo AS logo_4, t0.price AS price_5, t0.is_active AS is_active_6, t0.duration AS duration_7, t0.subcategory_id AS subcategory_id_8, t0.category_id AS category_id_9 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
  7
]
21 0.39 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.price AS price_5, t0.duration AS duration_6, t0.is_active AS is_active_7, t0.product_id AS product_id_8 FROM sub_product t0 WHERE t0.product_id = ?
Parameters:
[
  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