Query Metrics
13
Database Queries
13
Different statements
19.33 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 8.16 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.token AS token_3, t0.expire_at AS expire_at_4, t0.is_active AS is_active_5, t0.refresh_token AS refresh_token_6, t0.rt_expire_at AS rt_expire_at_7, t0.short_token AS short_token_8, t0.user_id AS user_id_9, t0.container_id AS container_id_10 FROM access_token t0 WHERE t0.token = ? AND t0.container_id = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NjEyMDQ5OTIsImV4cCI6MTc2MTI5MTM5Miwicm9sZXMiOlsiUk9MRV9TVVBFUl9BRE1JTiJdLCJ1c2VybmFtZSI6ImFkYW0ubGFpYkBleHBlcnRzaGFyZS5saXZlIiwiaXAiOiIxODUuMTM3LjE3Mi4xMiIsImNpZCI6NTksImNudGlkIjo4M30.aW2JsVLw5MJB-un7rIbwX7_sLLk-LRtIUWk_gjxPel9XqJUHK_RkjaNpWBvB3w-FqdxdN7NzflTFfcZszGXKVbeWqzhCSOTGl0C_pemws6U-V7H9mBgmAQ-nFAVjpEWUZ-YO7nsDyUT1AfQ7W-Z0ix3f-LjPIiCwFXrchYAlyAMPTx4AqSX2DI0E1F_3m7tTXp7tP_3Agl3bYlBkMG2GT7tipvToqMhwLxRBYZRiGnHZO47PSEXvS1ORdZU6M5t9r-ziY6pCwwXGRjxrEC3zkbuiMsadbwfzr9qZ3px7s9sCN7eDr-kKxNAWPjvwx1gd5zLGd97snUA-Rfqs7JFB-g" 83 1 ] |
2 | 1.39 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.locale AS locale_5, u0_.status AS status_6, u0_.company AS company_7, u0_.job_title AS job_title_8, u0_.image_name AS image_name_9, u0_.source AS source_10, u0_.is_onboarded AS is_onboarded_11, u0_.is_blocked AS is_blocked_12, u0_.onboarded_at AS onboarded_at_13, u0_.last_login_at AS last_login_at_14, u0_.is_display_as_guest AS is_display_as_guest_15, u0_.is_expose_email AS is_expose_email_16, u0_.is_allow_communication AS is_allow_communication_17, u0_.timezone AS timezone_18, u0_.is_pwd_generated AS is_pwd_generated_19, u0_.is_online AS is_online_20, u0_.is_show_disclaimer AS is_show_disclaimer_21, u0_.sa_linkedin AS sa_linkedin_22, u0_.sa_twitter AS sa_twitter_23, u0_.sa_facebook AS sa_facebook_24, u0_.sa_instagram AS sa_instagram_25, u0_.sa_youtube AS sa_youtube_26, u0_.country AS country_27, u0_.fail_attempt_count AS fail_attempt_count_28, u0_.last_fail_attempt_at AS last_fail_attempt_at_29, u0_.login_block_until_at AS login_block_until_at_30, u0_.is_consider_speaker AS is_consider_speaker_31, u0_.is_consider_moderator AS is_consider_moderator_32, u0_.is_show_public AS is_show_public_33, u0_.is_notification_assign AS is_notification_assign_34, u0_.is_notification_chat AS is_notification_chat_35, u0_.is_notification_follow AS is_notification_follow_36, u0_.gln_number AS gln_number_37, u0_.ord AS ord_38, u0_.ord_state AS ord_state_39, u0_.is_notification_chat_group AS is_notification_chat_group_40, u0_.invite_code AS invite_code_41, u0_.headline AS headline_42, u0_.user_container_domain AS user_container_domain_43, u0_.is_unsubscribed_invite AS is_unsubscribed_invite_44, u0_.is_email_off AS is_email_off_45, u0_.created_at AS created_at_46, u0_.updated_at AS updated_at_47, r1_.id AS id_48, r1_.role AS role_49, u0_.client_id AS client_id_50, u0_.relation_manager_id AS relation_manager_id_51, u0_.user_container_id AS user_container_id_52, u0_.organization_id AS organization_id_53, r1_.container_id AS container_id_54, r1_.user_id AS user_id_55 FROM user u0_ LEFT JOIN role_container r1_ ON u0_.id = r1_.user_id WHERE u0_.client_id = ? AND u0_.email = ? AND r1_.container_id = ?
Parameters:
[ 59 "adam.laib@expertshare.live" 83 ] |
3 | 1.52 ms |
SELECT c0_.id AS id_0, c0_.domain AS domain_1, c0_.name AS name_2, c0_.container_group AS container_group_3, c0_.storage AS storage_4, c0_.bucket_key AS bucket_key_5, c0_.bucket_secret AS bucket_secret_6, c0_.bucket_name AS bucket_name_7, c0_.bucket_region AS bucket_region_8, c0_.bucket_endpoint AS bucket_endpoint_9, c0_.is_active AS is_active_10, c0_.configuration AS configuration_11, c0_.design_configuration AS design_configuration_12, c0_.description AS description_13, c0_.image_name AS image_name_14, c0_.navigation AS navigation_15, c0_.is_live_now AS is_live_now_16, c0_.video_gallery_ids AS video_gallery_ids_17, c0_.user_static_fields AS user_static_fields_18, c0_.logo_image_name AS logo_image_name_19, c0_.is_show_public AS is_show_public_20, c0_.is_main_container AS is_main_container_21, c0_.is_show_public_container AS is_show_public_container_22, c0_.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_23, c0_.old_id AS old_id_24, c0_.is_login_container AS is_login_container_25, c0_.course_commission AS course_commission_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, u1_.id AS id_29, u1_.name AS name_30, u1_.is_generated AS is_generated_31, u1_.created_at AS created_at_32, u1_.updated_at AS updated_at_33, c0_.client_id AS client_id_34, c0_.container_category_id AS container_category_id_35, u1_.client_id AS client_id_36 FROM container c0_ LEFT JOIN container_user_group c2_ ON c0_.id = c2_.container_id LEFT JOIN user_group u1_ ON u1_.id = c2_.user_group_id WHERE c0_.domain = ? OR c0_.domain = ?
Parameters:
[ "bethesda.doclift.com" "www.bethesda.doclift.com" ] |
4 | 0.79 ms |
SELECT c0_.id AS id_0, c0_.domain AS domain_1, c0_.name AS name_2, c0_.container_group AS container_group_3, c0_.storage AS storage_4, c0_.bucket_key AS bucket_key_5, c0_.bucket_secret AS bucket_secret_6, c0_.bucket_name AS bucket_name_7, c0_.bucket_region AS bucket_region_8, c0_.bucket_endpoint AS bucket_endpoint_9, c0_.is_active AS is_active_10, c0_.configuration AS configuration_11, c0_.design_configuration AS design_configuration_12, c0_.description AS description_13, c0_.image_name AS image_name_14, c0_.navigation AS navigation_15, c0_.is_live_now AS is_live_now_16, c0_.video_gallery_ids AS video_gallery_ids_17, c0_.user_static_fields AS user_static_fields_18, c0_.logo_image_name AS logo_image_name_19, c0_.is_show_public AS is_show_public_20, c0_.is_main_container AS is_main_container_21, c0_.is_show_public_container AS is_show_public_container_22, c0_.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_23, c0_.old_id AS old_id_24, c0_.is_login_container AS is_login_container_25, c0_.course_commission AS course_commission_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, c0_.client_id AS client_id_29, c0_.container_category_id AS container_category_id_30 FROM container c0_ WHERE c0_.id = ?
Parameters:
[
83
]
|
5 | 0.39 ms |
"START TRANSACTION"
Parameters:
[] |
6 | 2.25 ms |
INSERT INTO access_log (url, page_title, created_at, updated_at, container_id, user_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ "https://bethesda.doclift.com/public-event" "Eventübersicht" "2025-10-23 10:35:21" "2025-10-23 10:35:21" 83 99397 ] |
7 | 1.23 ms |
"COMMIT"
Parameters:
[] |
8 | 0.53 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.page_title AS page_title_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.container_id AS container_id_6, t0.user_id AS user_id_7 FROM access_log t0 WHERE t0.id = ?
Parameters:
[
1880911
]
|
9 | 0.70 ms |
SELECT t0.id AS id_1, t0.color AS color_2, t0.text_color AS text_color_3, t0.ord AS ord_4, t0.type AS type_5, t0.image_name AS image_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.client_id AS client_id_9, t0.parent_id AS parent_id_10 FROM common_category t0 INNER JOIN user_common_category ON t0.id = user_common_category.common_category_id WHERE user_common_category.user_id = ?
Parameters:
[
99397
]
|
10 | 0.65 ms |
SELECT t0.id AS id_1, t0.country AS country_2, t0.color AS color_3, t0.text_color AS text_color_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.client_id AS client_id_7, t0.newsfeed_category_id AS newsfeed_category_id_8 FROM special_title t0 INNER JOIN user_special_title ON t0.id = user_special_title.special_title_id WHERE user_special_title.user_id = ?
Parameters:
[
99397
]
|
11 | 0.59 ms |
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM special_title_translation t0 WHERE (t0.locale = ? AND t0.translatable_id = ?)
Parameters:
[ "en" 25 ] |
12 | 0.59 ms |
SELECT t0.id AS id_1, t0.ord AS ord_2, t0.academic_title_id AS academic_title_id_3, t0.user_id AS user_id_4 FROM rel_user_academic_title t0 WHERE t0.user_id = ?
Parameters:
[
99397
]
|
13 | 0.56 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.client_id AS client_id_4 FROM email_chanel t0 INNER JOIN user_email_chanel ON t0.id = user_email_chanel.email_chanel_id WHERE user_email_chanel.user_id = ?
Parameters:
[
99397
]
|
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.