| 1 |
0.73 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.email_auth_code AS email_auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile_phone AS mobile_phone_9, t0.totp_secret AS totp_secret_10, t0.status AS status_11, t0.reference AS reference_12, t0.token AS token_13 FROM `user` t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.email_auth_code AS email_auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile_phone AS mobile_phone_9, t0.totp_secret AS totp_secret_10, t0.status AS status_11, t0.reference AS reference_12, t0.token AS token_13 FROM `user` t0 WHERE t0.id = 1;
|
| 2 |
0.81 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.status AS status_4, p0_.reference AS reference_5, p0_.customer_reference AS customer_reference_6, p0_.parsing_success_rate AS parsing_success_rate_7, p0_.parsed_documents_count AS parsed_documents_count_8, p0_.created_by_id AS created_by_id_9, p0_.domain_id AS domain_id_10, p0_.type_id AS type_id_11, p0_.pathology_id AS pathology_id_12 FROM project p0_ WHERE p0_.status <> ? ORDER BY p0_.created_at DESC
Parameters: [
"finished"
]
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.status AS status_4, p0_.reference AS reference_5, p0_.customer_reference AS customer_reference_6, p0_.parsing_success_rate AS parsing_success_rate_7, p0_.parsed_documents_count AS parsed_documents_count_8, p0_.created_by_id AS created_by_id_9, p0_.domain_id AS domain_id_10, p0_.type_id AS type_id_11, p0_.pathology_id AS pathology_id_12 FROM project p0_ WHERE p0_.status <> 'finished' ORDER BY p0_.created_at DESC;
|
| 3 |
0.65 ms |
SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.reference AS reference_2, n0_.content AS content_3, n0_.target_id AS target_id_4, n0_.created_at AS created_at_5, n0_.status AS status_6, n0_.recipient_id AS recipient_id_7, n0_.created_by_id AS created_by_id_8 FROM notification n0_ WHERE n0_.recipient_id = ? ORDER BY n0_.created_at DESC LIMIT 2
SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.reference AS reference_2, n0_.content AS content_3, n0_.target_id AS target_id_4, n0_.created_at AS created_at_5, n0_.status AS status_6, n0_.recipient_id AS recipient_id_7, n0_.created_by_id AS created_by_id_8 FROM notification n0_ WHERE n0_.recipient_id = 1 ORDER BY n0_.created_at DESC LIMIT 2;
|
| 4 |
0.36 ms |
SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.reference AS reference_2, n0_.content AS content_3, n0_.target_id AS target_id_4, n0_.created_at AS created_at_5, n0_.status AS status_6, n0_.recipient_id AS recipient_id_7, n0_.created_by_id AS created_by_id_8 FROM notification n0_ WHERE n0_.recipient_id = ? AND n0_.status = ? ORDER BY n0_.created_at DESC
Parameters: [
1
"unread"
]
SELECT n0_.id AS id_0, n0_.type AS type_1, n0_.reference AS reference_2, n0_.content AS content_3, n0_.target_id AS target_id_4, n0_.created_at AS created_at_5, n0_.status AS status_6, n0_.recipient_id AS recipient_id_7, n0_.created_by_id AS created_by_id_8 FROM notification n0_ WHERE n0_.recipient_id = 1 AND n0_.status = 'unread' ORDER BY n0_.created_at DESC;
|
| 5 |
0.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.reference AS reference_3, t0.status AS status_4, t0.description AS description_5 FROM project_type t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.reference AS reference_3, t0.status AS status_4, t0.description AS description_5 FROM project_type t0 WHERE t0.id = 1;
|
| 6 |
0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = 7;
|
| 7 |
0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.reference AS reference_3, t0.status AS status_4, t0.description AS description_5 FROM project_type t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.reference AS reference_3, t0.status AS status_4, t0.description AS description_5 FROM project_type t0 WHERE t0.id = 5;
|
| 8 |
0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = 1;
|
| 9 |
0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.reference AS reference_3, t0.status AS status_4, t0.description AS description_5 FROM project_type t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.reference AS reference_3, t0.status AS status_4, t0.description AS description_5 FROM project_type t0 WHERE t0.id = 8;
|
| 10 |
0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = 2;
|
| 11 |
0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = 3;
|
| 12 |
0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = 4;
|
| 13 |
0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.type AS type_7, t0.reference AS reference_8, t0.hash AS hash_9, t0.status AS status_10, t0.ocr_name AS ocr_name_11, t0.ocr_version AS ocr_version_12, t0.ocr_result AS ocr_result_13, t0.uploaded_by_id AS uploaded_by_id_14, t0.project_id AS project_id_15, t0.category_id AS category_id_16 FROM document t0 WHERE t0.project_id = 5;
|