https://manager.mindpulse.online/notification/unread

Query Metrics

14 Database Queries
6 Different statements
9.61 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.42 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.is_default AS is_default_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 3.09 ms
SELECT u0_.id AS id_0, u0_.is_read AS is_read_1, u0_.read_at AS read_at_2, u0_.user_id AS user_id_3, u0_.notification_id AS notification_id_4 FROM user_notification u0_ INNER JOIN notification n1_ ON (u0_.notification_id = n1_.id) WHERE u0_.user_id = ? AND u0_.is_read = 0 ORDER BY n1_.created_at DESC LIMIT 5
Parameters:
[
  3
]
3 1.53 ms
SELECT COUNT(*) FROM user_notification t0 WHERE t0.user_id = ? AND t0.is_read = ?
Parameters:
[
  3
  0
]
4 0.49 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.level AS level_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.uid AS uid_7, t0.is_treated AS is_treated_8, t0.step AS step_9, t0.treated_by_id AS treated_by_id_10, t0.job_id AS job_id_11 FROM notification t0 WHERE t0.id = ?
Parameters:
[
  3047
]
5 0.56 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.step AS step_3, t0.step_status AS step_status_4, t0.step_message AS step_message_5, t0.uuid AS uuid_6, t0.from_address AS from_address_7, t0.bin_path AS bin_path_8, t0.json_path AS json_path_9, t0.pdf_path AS pdf_path_10, t0.context AS context_11, t0.treatment_version AS treatment_version_12, t0.failed_message_id AS failed_message_id_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.test_created_at AS test_created_at_16, t0.key_search_axonaut AS key_search_axonaut_17, t0.filegetter_document_id AS filegetter_document_id_18, t0.error_message AS error_message_19, t0.filegetter_download_counter AS filegetter_download_counter_20, t0.delay AS delay_21, t0.code_patient AS code_patient_22, t0.mode AS mode_23, t0.mindpulse_version AS mindpulse_version_24, t0.filegetter_document_url AS filegetter_document_url_25, t0.attachment_filename AS attachment_filename_26, t0.type AS type_27, t0.technical_version_id AS technical_version_id_28, t0.contact_id AS contact_id_29 FROM job t0 WHERE t0.id = ?
Parameters:
[
  10067
]
6 0.55 ms
SELECT t0.id AS id_1, t0.axonaut_id AS axonaut_id_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.email AS email_5, t0.phone_number AS phone_number_6, t0.cellphone_number AS cellphone_number_7, t0.job AS job_8, t0.filegetter_id AS filegetter_id_9, t0.credits AS credits_10, t0.send_code_by_sms AS send_code_by_sms_11, t0.axonaut_custom_fields AS axonaut_custom_fields_12, t0.axonaut_firm_id AS axonaut_firm_id_13, t0.firm_id AS firm_id_14 FROM contact t0 WHERE t0.id = ?
Parameters:
[
  616
]
7 0.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.level AS level_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.uid AS uid_7, t0.is_treated AS is_treated_8, t0.step AS step_9, t0.treated_by_id AS treated_by_id_10, t0.job_id AS job_id_11 FROM notification t0 WHERE t0.id = ?
Parameters:
[
  3046
]
8 0.56 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.step AS step_3, t0.step_status AS step_status_4, t0.step_message AS step_message_5, t0.uuid AS uuid_6, t0.from_address AS from_address_7, t0.bin_path AS bin_path_8, t0.json_path AS json_path_9, t0.pdf_path AS pdf_path_10, t0.context AS context_11, t0.treatment_version AS treatment_version_12, t0.failed_message_id AS failed_message_id_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.test_created_at AS test_created_at_16, t0.key_search_axonaut AS key_search_axonaut_17, t0.filegetter_document_id AS filegetter_document_id_18, t0.error_message AS error_message_19, t0.filegetter_download_counter AS filegetter_download_counter_20, t0.delay AS delay_21, t0.code_patient AS code_patient_22, t0.mode AS mode_23, t0.mindpulse_version AS mindpulse_version_24, t0.filegetter_document_url AS filegetter_document_url_25, t0.attachment_filename AS attachment_filename_26, t0.type AS type_27, t0.technical_version_id AS technical_version_id_28, t0.contact_id AS contact_id_29 FROM job t0 WHERE t0.id = ?
Parameters:
[
  10058
]
9 0.25 ms
SELECT t0.id AS id_1, t0.axonaut_id AS axonaut_id_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.email AS email_5, t0.phone_number AS phone_number_6, t0.cellphone_number AS cellphone_number_7, t0.job AS job_8, t0.filegetter_id AS filegetter_id_9, t0.credits AS credits_10, t0.send_code_by_sms AS send_code_by_sms_11, t0.axonaut_custom_fields AS axonaut_custom_fields_12, t0.axonaut_firm_id AS axonaut_firm_id_13, t0.firm_id AS firm_id_14 FROM contact t0 WHERE t0.id = ?
Parameters:
[
  602
]
10 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.level AS level_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.uid AS uid_7, t0.is_treated AS is_treated_8, t0.step AS step_9, t0.treated_by_id AS treated_by_id_10, t0.job_id AS job_id_11 FROM notification t0 WHERE t0.id = ?
Parameters:
[
  3045
]
11 0.48 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.step AS step_3, t0.step_status AS step_status_4, t0.step_message AS step_message_5, t0.uuid AS uuid_6, t0.from_address AS from_address_7, t0.bin_path AS bin_path_8, t0.json_path AS json_path_9, t0.pdf_path AS pdf_path_10, t0.context AS context_11, t0.treatment_version AS treatment_version_12, t0.failed_message_id AS failed_message_id_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.test_created_at AS test_created_at_16, t0.key_search_axonaut AS key_search_axonaut_17, t0.filegetter_document_id AS filegetter_document_id_18, t0.error_message AS error_message_19, t0.filegetter_download_counter AS filegetter_download_counter_20, t0.delay AS delay_21, t0.code_patient AS code_patient_22, t0.mode AS mode_23, t0.mindpulse_version AS mindpulse_version_24, t0.filegetter_document_url AS filegetter_document_url_25, t0.attachment_filename AS attachment_filename_26, t0.type AS type_27, t0.technical_version_id AS technical_version_id_28, t0.contact_id AS contact_id_29 FROM job t0 WHERE t0.id = ?
Parameters:
[
  10057
]
12 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.level AS level_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.uid AS uid_7, t0.is_treated AS is_treated_8, t0.step AS step_9, t0.treated_by_id AS treated_by_id_10, t0.job_id AS job_id_11 FROM notification t0 WHERE t0.id = ?
Parameters:
[
  3043
]
13 0.45 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.step AS step_3, t0.step_status AS step_status_4, t0.step_message AS step_message_5, t0.uuid AS uuid_6, t0.from_address AS from_address_7, t0.bin_path AS bin_path_8, t0.json_path AS json_path_9, t0.pdf_path AS pdf_path_10, t0.context AS context_11, t0.treatment_version AS treatment_version_12, t0.failed_message_id AS failed_message_id_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.test_created_at AS test_created_at_16, t0.key_search_axonaut AS key_search_axonaut_17, t0.filegetter_document_id AS filegetter_document_id_18, t0.error_message AS error_message_19, t0.filegetter_download_counter AS filegetter_download_counter_20, t0.delay AS delay_21, t0.code_patient AS code_patient_22, t0.mode AS mode_23, t0.mindpulse_version AS mindpulse_version_24, t0.filegetter_document_url AS filegetter_document_url_25, t0.attachment_filename AS attachment_filename_26, t0.type AS type_27, t0.technical_version_id AS technical_version_id_28, t0.contact_id AS contact_id_29 FROM job t0 WHERE t0.id = ?
Parameters:
[
  10047
]
14 0.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.level AS level_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.uid AS uid_7, t0.is_treated AS is_treated_8, t0.step AS step_9, t0.treated_by_id AS treated_by_id_10, t0.job_id AS job_id_11 FROM notification t0 WHERE t0.id = ?
Parameters:
[
  3044
]

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
App\Entity\User No errors.
App\Entity\UserNotification No errors.
App\Entity\Notification No errors.
App\Entity\Job No errors.
App\Entity\MindpulseAnalyser No errors.
App\Entity\Contact No errors.
App\Entity\JobEvents No errors.
App\Entity\Firm No errors.