Symfony Profiler

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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.status AS status_5,
  t0.reference AS reference_6,
  t0.customer_reference AS customer_reference_7,
  t0.parsing_success_rate AS parsing_success_rate_8,
  t0.parsed_documents_count AS parsed_documents_count_9,
  t0.created_by_id AS created_by_id_10,
  t0.domain_id AS domain_id_11,
  t0.type_id AS type_id_12,
  t0.pathology_id AS pathology_id_13
FROM
  project t0
WHERE
  t0.reference = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.status AS status_5, t0.reference AS reference_6, t0.customer_reference AS customer_reference_7, t0.parsing_success_rate AS parsing_success_rate_8, t0.parsed_documents_count AS parsed_documents_count_9, t0.created_by_id AS created_by_id_10, t0.domain_id AS domain_id_11, t0.type_id AS type_id_12, t0.pathology_id AS pathology_id_13 FROM project t0 WHERE t0.reference = 'f51b649d92dc4ee09ab7fb02041648e0' LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.content_left AS content_left_1,
  m0_.content_right AS content_right_2,
  m0_.status AS status_3,
  m0_.severity AS severity_4,
  m0_.category AS category_5,
  m0_.explanation AS explanation_6,
  m0_.suggestion AS suggestion_7,
  m0_.created_at AS created_at_8,
  m0_.line_number_right AS line_number_right_9,
  m0_.line_number_left AS line_number_left_10,
  d1_.id AS id_11,
  d1_.llm_name AS llm_name_12,
  d1_.llm_version AS llm_version_13,
  d1_.llm_result AS llm_result_14,
  d1_.status AS status_15,
  d1_.updated_at AS updated_at_16,
  d1_.finished_at AS finished_at_17,
  d1_.comparison_strategy AS comparison_strategy_18,
  d2_.id AS id_19,
  d2_.name AS name_20,
  d2_.original_name AS original_name_21,
  d2_.mime_type AS mime_type_22,
  d2_.size AS size_23,
  d2_.uploaded_at AS uploaded_at_24,
  d2_.type AS type_25,
  d2_.reference AS reference_26,
  d2_.hash AS hash_27,
  d2_.status AS status_28,
  d2_.ocr_name AS ocr_name_29,
  d2_.ocr_version AS ocr_version_30,
  d2_.ocr_result AS ocr_result_31,
  d3_.id AS id_32,
  d3_.name AS name_33,
  d3_.original_name AS original_name_34,
  d3_.mime_type AS mime_type_35,
  d3_.size AS size_36,
  d3_.uploaded_at AS uploaded_at_37,
  d3_.type AS type_38,
  d3_.reference AS reference_39,
  d3_.hash AS hash_40,
  d3_.status AS status_41,
  d3_.ocr_name AS ocr_name_42,
  d3_.ocr_version AS ocr_version_43,
  d3_.ocr_result AS ocr_result_44,
  m0_.document_review_id AS document_review_id_45,
  m0_.reference_document_id AS reference_document_id_46,
  d1_.document_id AS document_id_47,
  d1_.proofreading_type_id AS proofreading_type_id_48,
  d1_.regulation_id AS regulation_id_49,
  d1_.updated_by_id AS updated_by_id_50,
  d2_.uploaded_by_id AS uploaded_by_id_51,
  d2_.project_id AS project_id_52,
  d2_.category_id AS category_id_53,
  d3_.uploaded_by_id AS uploaded_by_id_54,
  d3_.project_id AS project_id_55,
  d3_.category_id AS category_id_56
FROM
  mismatch m0_
  LEFT JOIN document_review d1_ ON m0_.document_review_id = d1_.id
  LEFT JOIN document d2_ ON d1_.document_id = d2_.id
  LEFT JOIN document d3_ ON m0_.reference_document_id = d3_.id
WHERE
  d2_.project_id = ?
  AND (
    m0_.status IN (?, ?)
    OR m0_.status IS NULL
  )
ORDER BY
  CASE WHEN m0_.status = ?
  OR m0_.status IS NULL THEN
    1
  WHEN m0_.status = ? THEN
    2
  WHEN m0_.status = ? THEN
    3
  ELSE
    5
  END ASC,
  CASE WHEN m0_.severity = ? THEN
    1
  WHEN m0_.severity = ? THEN
    2
  WHEN m0_.severity = ? THEN
    3
  ELSE
    4
  END ASC,
  m0_.created_at DESC

SELECT m0_.id AS id_0, m0_.content_left AS content_left_1, m0_.content_right AS content_right_2, m0_.status AS status_3, m0_.severity AS severity_4, m0_.category AS category_5, m0_.explanation AS explanation_6, m0_.suggestion AS suggestion_7, m0_.created_at AS created_at_8, m0_.line_number_right AS line_number_right_9, m0_.line_number_left AS line_number_left_10, d1_.id AS id_11, d1_.llm_name AS llm_name_12, d1_.llm_version AS llm_version_13, d1_.llm_result AS llm_result_14, d1_.status AS status_15, d1_.updated_at AS updated_at_16, d1_.finished_at AS finished_at_17, d1_.comparison_strategy AS comparison_strategy_18, d2_.id AS id_19, d2_.name AS name_20, d2_.original_name AS original_name_21, d2_.mime_type AS mime_type_22, d2_.size AS size_23, d2_.uploaded_at AS uploaded_at_24, d2_.type AS type_25, d2_.reference AS reference_26, d2_.hash AS hash_27, d2_.status AS status_28, d2_.ocr_name AS ocr_name_29, d2_.ocr_version AS ocr_version_30, d2_.ocr_result AS ocr_result_31, d3_.id AS id_32, d3_.name AS name_33, d3_.original_name AS original_name_34, d3_.mime_type AS mime_type_35, d3_.size AS size_36, d3_.uploaded_at AS uploaded_at_37, d3_.type AS type_38, d3_.reference AS reference_39, d3_.hash AS hash_40, d3_.status AS status_41, d3_.ocr_name AS ocr_name_42, d3_.ocr_version AS ocr_version_43, d3_.ocr_result AS ocr_result_44, m0_.document_review_id AS document_review_id_45, m0_.reference_document_id AS reference_document_id_46, d1_.document_id AS document_id_47, d1_.proofreading_type_id AS proofreading_type_id_48, d1_.regulation_id AS regulation_id_49, d1_.updated_by_id AS updated_by_id_50, d2_.uploaded_by_id AS uploaded_by_id_51, d2_.project_id AS project_id_52, d2_.category_id AS category_id_53, d3_.uploaded_by_id AS uploaded_by_id_54, d3_.project_id AS project_id_55, d3_.category_id AS category_id_56 FROM mismatch m0_ LEFT JOIN document_review d1_ ON m0_.document_review_id = d1_.id LEFT JOIN document d2_ ON d1_.document_id = d2_.id LEFT JOIN document d3_ ON m0_.reference_document_id = d3_.id WHERE d2_.project_id = 7 AND (m0_.status IN ('pending', 'failed') OR m0_.status IS NULL) ORDER BY CASE WHEN m0_.status = 'pending' OR m0_.status IS NULL THEN 1 WHEN m0_.status = 'finished' THEN 2 WHEN m0_.status = 'failed' THEN 3 ELSE 5 END ASC, CASE WHEN m0_.severity = 'high' THEN 1 WHEN m0_.severity = 'medium' THEN 2 WHEN m0_.severity = 'low' THEN 3 ELSE 4 END ASC, m0_.created_at DESC;

SELECT
  m0_.id AS id_0,
  m0_.content_left AS content_left_1,
  m0_.content_right AS content_right_2,
  m0_.status AS status_3,
  m0_.severity AS severity_4,
  m0_.category AS category_5,
  m0_.explanation AS explanation_6,
  m0_.suggestion AS suggestion_7,
  m0_.created_at AS created_at_8,
  m0_.line_number_right AS line_number_right_9,
  m0_.line_number_left AS line_number_left_10,
  d1_.id AS id_11,
  d1_.llm_name AS llm_name_12,
  d1_.llm_version AS llm_version_13,
  d1_.llm_result AS llm_result_14,
  d1_.status AS status_15,
  d1_.updated_at AS updated_at_16,
  d1_.finished_at AS finished_at_17,
  d1_.comparison_strategy AS comparison_strategy_18,
  d2_.id AS id_19,
  d2_.name AS name_20,
  d2_.original_name AS original_name_21,
  d2_.mime_type AS mime_type_22,
  d2_.size AS size_23,
  d2_.uploaded_at AS uploaded_at_24,
  d2_.type AS type_25,
  d2_.reference AS reference_26,
  d2_.hash AS hash_27,
  d2_.status AS status_28,
  d2_.ocr_name AS ocr_name_29,
  d2_.ocr_version AS ocr_version_30,
  d2_.ocr_result AS ocr_result_31,
  d3_.id AS id_32,
  d3_.name AS name_33,
  d3_.original_name AS original_name_34,
  d3_.mime_type AS mime_type_35,
  d3_.size AS size_36,
  d3_.uploaded_at AS uploaded_at_37,
  d3_.type AS type_38,
  d3_.reference AS reference_39,
  d3_.hash AS hash_40,
  d3_.status AS status_41,
  d3_.ocr_name AS ocr_name_42,
  d3_.ocr_version AS ocr_version_43,
  d3_.ocr_result AS ocr_result_44,
  m0_.document_review_id AS document_review_id_45,
  m0_.reference_document_id AS reference_document_id_46,
  d1_.document_id AS document_id_47,
  d1_.proofreading_type_id AS proofreading_type_id_48,
  d1_.regulation_id AS regulation_id_49,
  d1_.updated_by_id AS updated_by_id_50,
  d2_.uploaded_by_id AS uploaded_by_id_51,
  d2_.project_id AS project_id_52,
  d2_.category_id AS category_id_53,
  d3_.uploaded_by_id AS uploaded_by_id_54,
  d3_.project_id AS project_id_55,
  d3_.category_id AS category_id_56
FROM
  mismatch m0_
  LEFT JOIN document_review d1_ ON m0_.document_review_id = d1_.id
  LEFT JOIN document d2_ ON d1_.document_id = d2_.id
  LEFT JOIN document d3_ ON m0_.reference_document_id = d3_.id
WHERE
  d2_.project_id = ?
  AND m0_.status IN (?)
ORDER BY
  CASE WHEN m0_.status = ?
  OR m0_.status IS NULL THEN
    1
  WHEN m0_.status = ? THEN
    2
  WHEN m0_.status = ? THEN
    3
  ELSE
    5
  END ASC,
  CASE WHEN m0_.severity = ? THEN
    1
  WHEN m0_.severity = ? THEN
    2
  WHEN m0_.severity = ? THEN
    3
  ELSE
    4
  END ASC,
  m0_.created_at DESC

SELECT m0_.id AS id_0, m0_.content_left AS content_left_1, m0_.content_right AS content_right_2, m0_.status AS status_3, m0_.severity AS severity_4, m0_.category AS category_5, m0_.explanation AS explanation_6, m0_.suggestion AS suggestion_7, m0_.created_at AS created_at_8, m0_.line_number_right AS line_number_right_9, m0_.line_number_left AS line_number_left_10, d1_.id AS id_11, d1_.llm_name AS llm_name_12, d1_.llm_version AS llm_version_13, d1_.llm_result AS llm_result_14, d1_.status AS status_15, d1_.updated_at AS updated_at_16, d1_.finished_at AS finished_at_17, d1_.comparison_strategy AS comparison_strategy_18, d2_.id AS id_19, d2_.name AS name_20, d2_.original_name AS original_name_21, d2_.mime_type AS mime_type_22, d2_.size AS size_23, d2_.uploaded_at AS uploaded_at_24, d2_.type AS type_25, d2_.reference AS reference_26, d2_.hash AS hash_27, d2_.status AS status_28, d2_.ocr_name AS ocr_name_29, d2_.ocr_version AS ocr_version_30, d2_.ocr_result AS ocr_result_31, d3_.id AS id_32, d3_.name AS name_33, d3_.original_name AS original_name_34, d3_.mime_type AS mime_type_35, d3_.size AS size_36, d3_.uploaded_at AS uploaded_at_37, d3_.type AS type_38, d3_.reference AS reference_39, d3_.hash AS hash_40, d3_.status AS status_41, d3_.ocr_name AS ocr_name_42, d3_.ocr_version AS ocr_version_43, d3_.ocr_result AS ocr_result_44, m0_.document_review_id AS document_review_id_45, m0_.reference_document_id AS reference_document_id_46, d1_.document_id AS document_id_47, d1_.proofreading_type_id AS proofreading_type_id_48, d1_.regulation_id AS regulation_id_49, d1_.updated_by_id AS updated_by_id_50, d2_.uploaded_by_id AS uploaded_by_id_51, d2_.project_id AS project_id_52, d2_.category_id AS category_id_53, d3_.uploaded_by_id AS uploaded_by_id_54, d3_.project_id AS project_id_55, d3_.category_id AS category_id_56 FROM mismatch m0_ LEFT JOIN document_review d1_ ON m0_.document_review_id = d1_.id LEFT JOIN document d2_ ON d1_.document_id = d2_.id LEFT JOIN document d3_ ON m0_.reference_document_id = d3_.id WHERE d2_.project_id = 7 AND m0_.status IN ('finished') ORDER BY CASE WHEN m0_.status = 'pending' OR m0_.status IS NULL THEN 1 WHEN m0_.status = 'finished' THEN 2 WHEN m0_.status = 'failed' THEN 3 ELSE 5 END ASC, CASE WHEN m0_.severity = 'high' THEN 1 WHEN m0_.severity = 'medium' THEN 2 WHEN m0_.severity = 'low' THEN 3 ELSE 4 END ASC, m0_.created_at DESC;

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;

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

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;