Query Metrics
14
Database Queries
6
Different statements
9.61 ms
Query time
0
Invalid entities
Queries
| #▲ | 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. |