Query Metrics
41
Database Queries
9
Different statements
3.26 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.10 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.type AS type_7, t0.is_verified AS is_verified_8, t0.is_active AS is_active_9, t0.added_at AS added_at_10 FROM user t0 WHERE t0.id = ?
Parameters:
[
38
]
|
2 | 0.08 ms |
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.id_added_by_user AS id_added_by_user_2 FROM health_well_being h0_ WHERE h0_.id_added_by_user = ? ORDER BY h0_.name ASC
Parameters:
[
38
]
|
3 | 0.09 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_health"
]
|
4 | 0.07 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_dashboard"
]
|
5 | 0.09 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_spolecznosc_przyjaciele"
]
|
6 | 0.08 ms |
SELECT COUNT(u0_.id) AS sclr_0 FROM user_notification u0_ WHERE u0_.id_user = ?
Parameters:
[
38
]
|
7 | 0.07 ms |
SELECT u0_.name AS name_0, u0_.value AS value_1, u0_.id_user AS id_user_2 FROM user_settings u0_ WHERE u0_.id_user = ? AND u0_.name = ?
Parameters:
[ 38 "tasks.completed" ] |
8 | 0.09 ms |
SELECT t0.id AS id_1, t0.nickname AS nickname_2, t0.company_name AS company_name_3, t0.street AS street_4, t0.building_number AS building_number_5, t0.apartment_number AS apartment_number_6, t0.postal_code AS postal_code_7, t0.city AS city_8, t0.phone AS phone_9, t0.intro AS intro_10, t0.description AS description_11, t0.supplier_intro AS supplier_intro_12, t0.supplier_description AS supplier_description_13, t0.website_url AS website_url_14, t0.image AS image_15, t0.twitter_username AS twitter_username_16, t0.knowledge_base_access AS knowledge_base_access_17, t0.referral_id AS referral_id_18, t0.reflink_view_count AS reflink_view_count_19, t0.reflink_register_count AS reflink_register_count_20, t0.is_consultant AS is_consultant_21, t0.is_supplier AS is_supplier_22, t0.selected_lang AS selected_lang_23, t0.updated_at AS updated_at_24, t0.id_user AS id_user_25, t0.id_referral_user AS id_referral_user_26 FROM user_profile t0 WHERE t0.id_user = ?
Parameters:
[
38
]
|
9 | 0.07 ms |
SELECT u0_.name AS name_0, u0_.value AS value_1, u0_.id_user AS id_user_2 FROM user_settings u0_ WHERE u0_.id_user = ? AND u0_.name = ?
Parameters:
[ 38 "poll.completed" ] |
10 | 0.08 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_powiadomienia_masz_niedokonczone_zadania"
]
|
11 | 0.07 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_notifications"
]
|
12 | 0.09 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_spolecznosc_uzytkownicy"
]
|
13 | 0.07 ms |
SELECT u0_.name AS name_0, u0_.value AS value_1, u0_.id_user AS id_user_2 FROM user_settings u0_ WHERE u0_.id_user = ? AND u0_.name = ?
Parameters:
[ 38 "hints_enabled" ] |
14 | 0.07 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_hint"
]
|
15 | 0.07 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"link_faq"
]
|
16 | 0.06 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_zglos_blad"
]
|
17 | 0.09 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_my_village"
]
|
18 | 0.07 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_go_to_village"
]
|
19 | 0.08 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_go_to_health"
]
|
20 | 0.06 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_go_to_xbooster"
]
|
21 | 0.06 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"link_village"
]
|
22 | 0.06 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_village"
]
|
23 | 0.06 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"link_produkty"
]
|
24 | 0.06 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_produkty"
]
|
25 | 0.07 ms |
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.description AS description_2, g0_.market_access AS market_access_3, g0_.knowledge_base_access AS knowledge_base_access_4, g0_.added_at AS added_at_5, g0_.id_added_by_user AS id_added_by_user_6 FROM GROUPS g0_ INNER JOIN groups_member g1_ ON g0_.id = g1_.id_group WHERE g1_.id_user = ? AND g0_.market_access = 1 LIMIT 1
Parameters:
[
38
]
|
26 | 0.06 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_market"
]
|
27 | 0.07 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_strefa_dostawcy"
]
|
28 | 0.06 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_baza_wiedzy"
]
|
29 | 0.06 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_site_map"
]
|
30 | 0.06 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_profil"
]
|
31 | 0.06 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_log_out"
]
|
32 | 0.07 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_zdrowie_zarzadzaj_zdrowiem"
]
|
33 | 0.06 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_zdrowie_mapa_ciala"
]
|
34 | 0.06 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_zdrowie_zalecenia"
]
|
35 | 0.06 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_zdrowie_samopoczucie"
]
|
36 | 0.07 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_zdrowie_protokoly"
]
|
37 | 0.06 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_zdrowie_dodaj_parametr"
]
|
38 | 0.07 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_zdrowie_dni"
]
|
39 | 0.39 ms |
SELECT h0_.id AS id_0, h0_.rate AS rate_1, h0_.date AS date_2, h0_.id_health_well_being AS id_health_well_being_3 FROM health_well_being_history h0_ WHERE h0_.id_health_well_being = ? AND h0_.date >= ? AND h0_.date <= ?
Parameters:
[ "2" "2024-12-24 00:00:00" "2025-01-22 00:00:00" ] |
40 | 0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.id_added_by_user AS id_added_by_user_4 FROM health_thread t0 INNER JOIN health_well_being_thread ON t0.id = health_well_being_thread.id_health_thread WHERE health_well_being_thread.id_health_well_being = ?
Parameters:
[
"2"
]
|
41 | 0.07 ms |
SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1
Parameters:
[
"panel_zdrowie_czy_na_pewno_usunac_wybrany_parametr"
]
|
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.