GET http://cultrhea.wwwnl1-ss5.a2hosted.com/test/public/index.php/register-gift-list

Query Metrics

189 Database Queries
5 Different statements
55.59 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
44.55 ms
(80.14%)
152
SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = ? AND t0.category3_id = ?) ORDER BY t0.sort ASC
Parameters:
[
  1
  1
]
8.19 ms
(14.73%)
31
SELECT t0.id AS id_1, t0.label AS label_2, t0.updated AS updated_3, t0.sort AS sort_4, t0.category2_id AS category2_id_5 FROM category3 t0 WHERE t0.category2_id = ? ORDER BY t0.sort ASC
Parameters:
[
  1
]
1.32 ms
(2.38%)
4
SELECT t0.id AS id_1, t0.label AS label_2, t0.updated AS updated_3, t0.sort AS sort_4, t0.category1_id AS category1_id_5 FROM category2 t0 WHERE t0.category1_id = ? ORDER BY t0.sort ASC
Parameters:
[
  1
]
0.97 ms
(1.74%)
1
SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.label AS label_2, t0_.active AS active_3, t0_.sort AS sort_4 FROM type_event t0_ WHERE t0_.active = 1 ORDER BY t0_.sort ASC
Parameters:
[]
0.56 ms
(1.01%)
1
SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.updated AS updated_2, c0_.sort AS sort_3 FROM category1 c0_ WHERE c0_.sort <> 50 ORDER BY c0_.sort ASC LIMIT 7
Parameters:
[]

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