Query Metrics
59
Database Queries
3
Different statements
320.07 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 29.90 ms |
SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.phone_number AS phone_number_2, a0_.password AS password_3, a0_.roles AS roles_4, a0_.lastname AS lastname_5, a0_.firstname AS firstname_6, a0_.created_at AS created_at_7, a0_.registration_source AS registration_source_8, a0_.honorific_prefix AS honorific_prefix_9, a0_.reset_token AS reset_token_10, a0_.reset_token_expiration_date AS reset_token_expiration_date_11, a0_.uniq_id AS uniq_id_12, a0_.code_confirmation AS code_confirmation_13, a0_.updated_at AS updated_at_14, a0_.is_active AS is_active_15 FROM app_users a0_ WHERE a0_.email = ? OR a0_.phone_number = ?
Parameters:
[ "florian@digidom.pro" "florian@digidom.pro" ] |
2 | 1.27 ms |
SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.code AS code_2, a0_.final_code AS final_code_3, a0_.activity_domain_id AS activity_domain_id_4 FROM activity_subdomain a0_ WHERE a0_.label LIKE ? ORDER BY a0_.id DESC
Parameters:
[
"%%"
]
|
3 | 1.13 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
196
]
|
4 | 1.61 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
195
]
|
5 | 1.16 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
194
]
|
6 | 1.50 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
193
]
|
7 | 1.20 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
192
]
|
8 | 1.15 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
191
]
|
9 | 1.11 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
190
]
|
10 | 1.68 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
189
]
|
11 | 1.16 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
188
]
|
12 | 1.07 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
187
]
|
13 | 2.88 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
186
]
|
14 | 2.25 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
185
]
|
15 | 1.34 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
184
]
|
16 | 1.45 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
183
]
|
17 | 2.93 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
182
]
|
18 | 5.48 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
181
]
|
19 | 5.82 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
180
]
|
20 | 3.90 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
179
]
|
21 | 8.26 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
178
]
|
22 | 3.43 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
177
]
|
23 | 3.72 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
176
]
|
24 | 5.89 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
175
]
|
25 | 4.46 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
174
]
|
26 | 6.26 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
173
]
|
27 | 1.10 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
172
]
|
28 | 4.42 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
171
]
|
29 | 6.79 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
170
]
|
30 | 3.99 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
169
]
|
31 | 4.84 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
168
]
|
32 | 10.20 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
167
]
|
33 | 2.07 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
166
]
|
34 | 3.51 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
165
]
|
35 | 9.85 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
164
]
|
36 | 8.85 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
163
]
|
37 | 9.26 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
162
]
|
38 | 7.20 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
161
]
|
39 | 15.99 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
160
]
|
40 | 31.55 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
159
]
|
41 | 22.64 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
158
]
|
42 | 13.33 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
157
]
|
43 | 5.78 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
156
]
|
44 | 2.55 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
155
]
|
45 | 7.13 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
154
]
|
46 | 1.66 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
153
]
|
47 | 3.02 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
152
]
|
48 | 3.76 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
151
]
|
49 | 3.07 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
150
]
|
50 | 6.15 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
149
]
|
51 | 1.56 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
148
]
|
52 | 5.85 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
147
]
|
53 | 1.37 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
146
]
|
54 | 3.30 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
145
]
|
55 | 12.01 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
144
]
|
56 | 1.15 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
143
]
|
57 | 1.33 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
142
]
|
58 | 1.31 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
141
]
|
59 | 1.46 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.final_code AS final_code_4, t0.activity_subdomain_id AS activity_subdomain_id_5 FROM profession_type t0 WHERE t0.activity_subdomain_id = ?
Parameters:
[
140
]
|
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 |
---|---|
Evo\Infrastructure\MappingORM\Product | No errors. |
Evo\Infrastructure\MappingORM\Invoice | No errors. |
Evo\Infrastructure\MappingORM\Subscription | No errors. |
Evo\Infrastructure\MappingORM\SubscriptionModel | No errors. |
Evo\Infrastructure\MappingORM\ActivitySubdomain | No errors. |
Evo\Infrastructure\MappingORM\ActivityDomain | No errors. |
Evo\Infrastructure\MappingORM\User | No errors. |
Evo\Infrastructure\MappingORM\PappersActivityLogWrapper | No errors. |
Evo\Infrastructure\MappingORM\CreditNote | No errors. |
Evo\Infrastructure\MappingORM\Quote | No errors. |
Evo\Infrastructure\MappingORM\Organization | No errors. |
Evo\Infrastructure\MappingORM\Store | No errors. |
Evo\Infrastructure\MappingORM\UserUTM | No errors. |
Evo\Infrastructure\MappingORM\Lead | No errors. |
Evo\Infrastructure\MappingORM\ActivityLog | No errors. |
Evo\Infrastructure\MappingORM\CommercialGesture | No errors. |
Evo\Infrastructure\MappingORM\ProfessionType | No errors. |
Evo\Infrastructure\MappingORM\ProfessionDetail | No errors. |