Symfony Profiler

SELECT
  COUNT(q0_.id) AS sclr_0
FROM
  quiz_question q0_
WHERE
  q0_.is_active = ?
  AND (
    (
      SELECT
        COUNT(q1_.id) AS sclr_1
      FROM
        quiz_answer_bool q1_
      WHERE
        q1_.quiz_question_id = q0_.id
    ) >= 2
    OR (
      SELECT
        COUNT(q2_.id) AS sclr_2
      FROM
        quiz_answer_correspondence q2_
      WHERE
        q2_.quiz_question_id = q0_.id
    ) >= 2
  )

SELECT COUNT(q0_.id) AS sclr_0 FROM quiz_question q0_ WHERE q0_.is_active = 1 AND ((SELECT COUNT(q1_.id) AS sclr_1 FROM quiz_answer_bool q1_ WHERE q1_.quiz_question_id = q0_.id) >= 2 OR (SELECT COUNT(q2_.id) AS sclr_2 FROM quiz_answer_correspondence q2_ WHERE q2_.quiz_question_id = q0_.id) >= 2);

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  tuto_user_log t1_
  INNER JOIN tuto_tutorial t0_ ON t1_.tutorial_id = t0_.id
  INNER JOIN tuto_course t2_ ON t0_.course_id = t2_.id
  LEFT JOIN subscription_course_disabled s3_ ON t2_.id = s3_.disabled_course_id
  AND (s3_.subscription_id = ?)
WHERE
  t1_.user_id = ?
  AND t0_.is_active = 1
  AND t2_.is_active = 1
  AND (
    t2_.subscription_id IS NULL
    OR t2_.subscription_id = ?
  )
  AND s3_.id IS NULL

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM tuto_user_log t1_ INNER JOIN tuto_tutorial t0_ ON t1_.tutorial_id = t0_.id INNER JOIN tuto_course t2_ ON t0_.course_id = t2_.id LEFT JOIN subscription_course_disabled s3_ ON t2_.id = s3_.disabled_course_id AND (s3_.subscription_id = 'COP10020767') WHERE t1_.user_id = 11 AND t0_.is_active = 1 AND t2_.is_active = 1 AND (t2_.subscription_id IS NULL OR t2_.subscription_id = 'COP10020767') AND s3_.id IS NULL;

SELECT
  COUNT(q0_.id) AS sclr_0
FROM
  quiz_question q0_
WHERE
  q0_.is_active = ?
  AND q0_.learning_sub_category_id = ?
  AND (
    (
      SELECT
        COUNT(q1_.id) AS sclr_1
      FROM
        quiz_answer_bool q1_
      WHERE
        q1_.quiz_question_id = q0_.id
    ) >= 2
    OR (
      SELECT
        COUNT(q2_.id) AS sclr_2
      FROM
        quiz_answer_correspondence q2_
      WHERE
        q2_.quiz_question_id = q0_.id
    ) >= 2
  )

SELECT COUNT(q0_.id) AS sclr_0 FROM quiz_question q0_ WHERE q0_.is_active = 1 AND q0_.learning_sub_category_id = 1 AND ((SELECT COUNT(q1_.id) AS sclr_1 FROM quiz_answer_bool q1_ WHERE q1_.quiz_question_id = q0_.id) >= 2 OR (SELECT COUNT(q2_.id) AS sclr_2 FROM quiz_answer_correspondence q2_ WHERE q2_.quiz_question_id = q0_.id) >= 2);

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.questions_id AS questions_id_3,
  t0.ended_at AS ended_at_4,
  t0.answers AS answers_5,
  t0.scores AS scores_6,
  t0.canceled_at AS canceled_at_7,
  t0.model_id AS model_id_8,
  t0.quiz_user_registration_id AS quiz_user_registration_id_9
FROM
  quiz_user t0
WHERE
  t0.quiz_user_registration_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.questions_id AS questions_id_3, t0.ended_at AS ended_at_4, t0.answers AS answers_5, t0.scores AS scores_6, t0.canceled_at AS canceled_at_7, t0.model_id AS model_id_8, t0.quiz_user_registration_id AS quiz_user_registration_id_9 FROM quiz_user t0 WHERE t0.quiz_user_registration_id = 797;

SELECT
  m0_.id AS id_0,
  m0_.is_active AS is_active_1,
  m0_.label AS label_2,
  m0_.short_description AS short_description_3,
  m0_.image_name AS image_name_4,
  m0_.image_size AS image_size_5,
  m0_.image_updated_at AS image_updated_at_6,
  m0_.created_at AS created_at_7,
  m0_.created_by AS created_by_8,
  m0_.updated_at AS updated_at_9,
  m0_.updated_by AS updated_by_10,
  m0_.learning_sub_category_id AS learning_sub_category_id_11
FROM
  mission m0_
WHERE
  m0_.is_active = ?
  AND (
    NOT (
      EXISTS (
        SELECT
          m1_.id
        FROM
          mission_objective m1_
          LEFT JOIN fact_sheet f2_ ON m1_.fact_sheet_id = f2_.id
        WHERE
          (
            m1_.mission_id = m0_.id
            AND (
              f2_.id IS NULL
              OR f2_.is_active = 0
              OR NOT (
                EXISTS (
                  SELECT
                    f3_.id
                  FROM
                    fact_sheet_step f3_
                  WHERE
                    f3_.fact_sheet_id = f2_.id
                )
              )
            )
          )
          AND m1_.type IN ('fact_sheet')
      )
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          m4_.id
        FROM
          mission_objective m4_
          INNER JOIN tuto_course t5_ ON m4_.course_id = t5_.id
        WHERE
          (
            m4_.mission_id = m0_.id
            AND m4_.mode = ?
            AND (
              t5_.id IS NULL
              OR t5_.is_active = 0
              OR (
                NOT (
                  EXISTS (
                    SELECT
                      t6_.id
                    FROM
                      tuto_tutorial t6_
                    WHERE
                      t6_.course_id = t5_.id
                      AND t6_.is_active = 1
                  )
                )
              )
            )
          )
          AND m4_.type IN ('tuto')
      )
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          m7_.id
        FROM
          mission_objective m7_
          INNER JOIN tuto_tutorial t8_ ON m7_.tutorial_id = t8_.id
          LEFT JOIN tuto_course t9_ ON t8_.course_id = t9_.id
        WHERE
          (
            m7_.mission_id = m0_.id
            AND m7_.mode = ?
            AND (
              t8_.id IS NULL
              OR t8_.is_active = 0
              OR t9_.id IS NULL
              OR t9_.is_active = 0
            )
          )
          AND m7_.type IN ('tuto')
      )
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          m10_.id
        FROM
          mission_objective m10_
          LEFT JOIN quiz_model q11_ ON m10_.quiz_model_id = q11_.id
        WHERE
          (
            m10_.mission_id = m0_.id
            AND (
              q11_.id IS NULL
              OR q11_.is_active = 0
              OR (
                NOT (
                  EXISTS (
                    SELECT
                      q12_.id
                    FROM
                      quiz_model_part q12_
                    WHERE
                      q12_.quiz_model_id = q11_.id
                      AND q12_.is_active = 1
                  )
                )
              )
              OR (
                EXISTS (
                  SELECT
                    q13_.id
                  FROM
                    quiz_model_part q13_
                  WHERE
                    q13_.quiz_model_id = q11_.id
                    AND q13_.is_active = 1
                    AND (
                      q13_.nb_questions < 1
                      OR (
                        q13_.learning_sub_category_id IS NOT NULL
                        AND (
                          SELECT
                            COUNT(q14_.id) AS sclr_12
                          FROM
                            quiz_question q14_
                          WHERE
                            q14_.is_active = 1
                            AND q14_.learning_sub_category_id = q13_.learning_sub_category_id
                            AND (
                              (
                                SELECT
                                  COUNT(q15_.id) AS sclr_13
                                FROM
                                  quiz_answer_bool q15_
                                WHERE
                                  q15_.quiz_question_id = q14_.id
                              ) >= 2
                              OR (
                                SELECT
                                  COUNT(q16_.id) AS sclr_14
                                FROM
                                  quiz_answer_correspondence q16_
                                WHERE
                                  q16_.quiz_question_id = q14_.id
                              ) >= 2
                            )
                        ) < q13_.nb_questions
                      )
                      OR (
                        q13_.learning_sub_category_id IS NULL
                        AND q13_.learning_category_id IS NOT NULL
                        AND (
                          SELECT
                            COUNT(q17_.id) AS sclr_15
                          FROM
                            quiz_question q17_
                            INNER JOIN learning_sub_category l18_ ON q17_.learning_sub_category_id = l18_.id
                          WHERE
                            q17_.is_active = 1
                            AND l18_.learning_category_id = q13_.learning_category_id
                            AND (
                              (
                                SELECT
                                  COUNT(q19_.id) AS sclr_16
                                FROM
                                  quiz_answer_bool q19_
                                WHERE
                                  q19_.quiz_question_id = q17_.id
                              ) >= 2
                              OR (
                                SELECT
                                  COUNT(q20_.id) AS sclr_17
                                FROM
                                  quiz_answer_correspondence q20_
                                WHERE
                                  q20_.quiz_question_id = q17_.id
                              ) >= 2
                            )
                        ) < q13_.nb_questions
                      )
                      OR (
                        q13_.learning_sub_category_id IS NULL
                        AND q13_.learning_category_id IS NULL
                        AND (
                          SELECT
                            COUNT(q21_.id) AS sclr_18
                          FROM
                            quiz_question q21_
                          WHERE
                            q21_.is_active = 1
                            AND (
                              (
                                SELECT
                                  COUNT(q22_.id) AS sclr_19
                                FROM
                                  quiz_answer_bool q22_
                                WHERE
                                  q22_.quiz_question_id = q21_.id
                              ) >= 2
                              OR (
                                SELECT
                                  COUNT(q23_.id) AS sclr_20
                                FROM
                                  quiz_answer_correspondence q23_
                                WHERE
                                  q23_.quiz_question_id = q21_.id
                              ) >= 2
                            )
                        ) < q13_.nb_questions
                      )
                    )
                )
              )
            )
          )
          AND m10_.type IN ('quiz')
      )
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          m24_.id
        FROM
          mission_objective m24_
          INNER JOIN tuto_course t25_ ON m24_.course_id = t25_.id
        WHERE
          (
            m24_.mission_id = m0_.id
            AND m24_.mode = ?
            AND (
              EXISTS (
                SELECT
                  s26_.id
                FROM
                  subscription_course_disabled s26_
                WHERE
                  s26_.disabled_course_id = t25_.id
                  AND s26_.subscription_id = ?
              )
            )
          )
          AND m24_.type IN ('tuto')
      )
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          m27_.id
        FROM
          mission_objective m27_
          INNER JOIN tuto_tutorial t28_ ON m27_.tutorial_id = t28_.id
          LEFT JOIN tuto_course t29_ ON t28_.course_id = t29_.id
        WHERE
          (
            m27_.mission_id = m0_.id
            AND m27_.mode = ?
            AND (
              EXISTS (
                SELECT
                  s30_.id
                FROM
                  subscription_course_disabled s30_
                WHERE
                  s30_.disabled_course_id = t29_.id
                  AND s30_.subscription_id = ?
              )
            )
          )
          AND m27_.type IN ('tuto')
      )
    )
  )
  AND (
    NOT (
      EXISTS (
        SELECT
          m31_.id
        FROM
          mission_objective m31_
          LEFT JOIN quiz_model q32_ ON m31_.quiz_model_id = q32_.id
        WHERE
          (
            m31_.mission_id = m0_.id
            AND q32_.id NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
          )
          AND m31_.type IN ('quiz')
      )
    )
  )
ORDER BY
  m0_.created_at ASC

SELECT m0_.id AS id_0, m0_.is_active AS is_active_1, m0_.label AS label_2, m0_.short_description AS short_description_3, m0_.image_name AS image_name_4, m0_.image_size AS image_size_5, m0_.image_updated_at AS image_updated_at_6, m0_.created_at AS created_at_7, m0_.created_by AS created_by_8, m0_.updated_at AS updated_at_9, m0_.updated_by AS updated_by_10, m0_.learning_sub_category_id AS learning_sub_category_id_11 FROM mission m0_ WHERE m0_.is_active = 1 AND (NOT (EXISTS (SELECT m1_.id FROM mission_objective m1_ LEFT JOIN fact_sheet f2_ ON m1_.fact_sheet_id = f2_.id WHERE (m1_.mission_id = m0_.id AND (f2_.id IS NULL OR f2_.is_active = 0 OR NOT (EXISTS (SELECT f3_.id FROM fact_sheet_step f3_ WHERE f3_.fact_sheet_id = f2_.id)))) AND m1_.type IN ('fact_sheet')))) AND (NOT (EXISTS (SELECT m4_.id FROM mission_objective m4_ INNER JOIN tuto_course t5_ ON m4_.course_id = t5_.id WHERE (m4_.mission_id = m0_.id AND m4_.mode = 'course' AND (t5_.id IS NULL OR t5_.is_active = 0 OR (NOT (EXISTS (SELECT t6_.id FROM tuto_tutorial t6_ WHERE t6_.course_id = t5_.id AND t6_.is_active = 1))))) AND m4_.type IN ('tuto')))) AND (NOT (EXISTS (SELECT m7_.id FROM mission_objective m7_ INNER JOIN tuto_tutorial t8_ ON m7_.tutorial_id = t8_.id LEFT JOIN tuto_course t9_ ON t8_.course_id = t9_.id WHERE (m7_.mission_id = m0_.id AND m7_.mode = 'tutorial' AND (t8_.id IS NULL OR t8_.is_active = 0 OR t9_.id IS NULL OR t9_.is_active = 0)) AND m7_.type IN ('tuto')))) AND (NOT (EXISTS (SELECT m10_.id FROM mission_objective m10_ LEFT JOIN quiz_model q11_ ON m10_.quiz_model_id = q11_.id WHERE (m10_.mission_id = m0_.id AND (q11_.id IS NULL OR q11_.is_active = 0 OR (NOT (EXISTS (SELECT q12_.id FROM quiz_model_part q12_ WHERE q12_.quiz_model_id = q11_.id AND q12_.is_active = 1))) OR (EXISTS (SELECT q13_.id FROM quiz_model_part q13_ WHERE q13_.quiz_model_id = q11_.id AND q13_.is_active = 1 AND (q13_.nb_questions < 1 OR (q13_.learning_sub_category_id IS NOT NULL AND (SELECT COUNT(q14_.id) AS sclr_12 FROM quiz_question q14_ WHERE q14_.is_active = 1 AND q14_.learning_sub_category_id = q13_.learning_sub_category_id AND ((SELECT COUNT(q15_.id) AS sclr_13 FROM quiz_answer_bool q15_ WHERE q15_.quiz_question_id = q14_.id) >= 2 OR (SELECT COUNT(q16_.id) AS sclr_14 FROM quiz_answer_correspondence q16_ WHERE q16_.quiz_question_id = q14_.id) >= 2)) < q13_.nb_questions) OR (q13_.learning_sub_category_id IS NULL AND q13_.learning_category_id IS NOT NULL AND (SELECT COUNT(q17_.id) AS sclr_15 FROM quiz_question q17_ INNER JOIN learning_sub_category l18_ ON q17_.learning_sub_category_id = l18_.id WHERE q17_.is_active = 1 AND l18_.learning_category_id = q13_.learning_category_id AND ((SELECT COUNT(q19_.id) AS sclr_16 FROM quiz_answer_bool q19_ WHERE q19_.quiz_question_id = q17_.id) >= 2 OR (SELECT COUNT(q20_.id) AS sclr_17 FROM quiz_answer_correspondence q20_ WHERE q20_.quiz_question_id = q17_.id) >= 2)) < q13_.nb_questions) OR (q13_.learning_sub_category_id IS NULL AND q13_.learning_category_id IS NULL AND (SELECT COUNT(q21_.id) AS sclr_18 FROM quiz_question q21_ WHERE q21_.is_active = 1 AND ((SELECT COUNT(q22_.id) AS sclr_19 FROM quiz_answer_bool q22_ WHERE q22_.quiz_question_id = q21_.id) >= 2 OR (SELECT COUNT(q23_.id) AS sclr_20 FROM quiz_answer_correspondence q23_ WHERE q23_.quiz_question_id = q21_.id) >= 2)) < q13_.nb_questions)))))) AND m10_.type IN ('quiz')))) AND (NOT (EXISTS (SELECT m24_.id FROM mission_objective m24_ INNER JOIN tuto_course t25_ ON m24_.course_id = t25_.id WHERE (m24_.mission_id = m0_.id AND m24_.mode = 'course' AND (EXISTS (SELECT s26_.id FROM subscription_course_disabled s26_ WHERE s26_.disabled_course_id = t25_.id AND s26_.subscription_id = 'COP10020767'))) AND m24_.type IN ('tuto')))) AND (NOT (EXISTS (SELECT m27_.id FROM mission_objective m27_ INNER JOIN tuto_tutorial t28_ ON m27_.tutorial_id = t28_.id LEFT JOIN tuto_course t29_ ON t28_.course_id = t29_.id WHERE (m27_.mission_id = m0_.id AND m27_.mode = 'tutorial' AND (EXISTS (SELECT s30_.id FROM subscription_course_disabled s30_ WHERE s30_.disabled_course_id = t29_.id AND s30_.subscription_id = 'COP10020767'))) AND m27_.type IN ('tuto')))) AND (NOT (EXISTS (SELECT m31_.id FROM mission_objective m31_ LEFT JOIN quiz_model q32_ ON m31_.quiz_model_id = q32_.id WHERE (m31_.mission_id = m0_.id AND q32_.id NOT IN (19, 20, 21, 22, 23, 24, 25, 26, 27, 28)) AND m31_.type IN ('quiz')))) ORDER BY m0_.created_at ASC;

SELECT
  t0.id AS id_1,
  t0.nb_questions AS nb_questions_2,
  t0.is_active AS is_active_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.created_by AS created_by_6,
  t0.updated_at AS updated_at_7,
  t0.updated_by AS updated_by_8,
  t0.quiz_model_id AS quiz_model_id_9,
  t0.learning_category_id AS learning_category_id_10,
  t0.learning_sub_category_id AS learning_sub_category_id_11
FROM
  quiz_model_part t0
WHERE
  t0.quiz_model_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.nb_questions AS nb_questions_2, t0.is_active AS is_active_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.created_by AS created_by_6, t0.updated_at AS updated_at_7, t0.updated_by AS updated_by_8, t0.quiz_model_id AS quiz_model_id_9, t0.learning_category_id AS learning_category_id_10, t0.learning_sub_category_id AS learning_sub_category_id_11 FROM quiz_model_part t0 WHERE t0.quiz_model_id = 26 ORDER BY t0.position ASC;

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  tuto_course t0_
  INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id
  LEFT JOIN subscription_course_disabled s2_ ON t0_.id = s2_.disabled_course_id
  AND (s2_.subscription_id = ?)
WHERE
  t0_.is_active = 1
  AND t1_.is_active = 1
  AND (
    t0_.subscription_id IS NULL
    OR t0_.subscription_id = ?
  )
  AND s2_.id IS NULL
  AND (
    NOT EXISTS (
      SELECT
        1 AS sclr_1
      FROM
        tuto_tutorial t3_
      WHERE
        t3_.course_id = t0_.id
        AND t3_.is_active = 1
        AND NOT EXISTS (
          SELECT
            1 AS sclr_2
          FROM
            tuto_user_log t4_
          WHERE
            t4_.tutorial_id = t3_.id
            AND t4_.user_id = ?
        )
    )
  )

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM tuto_course t0_ INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id LEFT JOIN subscription_course_disabled s2_ ON t0_.id = s2_.disabled_course_id AND (s2_.subscription_id = 'COP10020767') WHERE t0_.is_active = 1 AND t1_.is_active = 1 AND (t0_.subscription_id IS NULL OR t0_.subscription_id = 'COP10020767') AND s2_.id IS NULL AND (NOT EXISTS (SELECT 1 AS sclr_1 FROM tuto_tutorial t3_ WHERE t3_.course_id = t0_.id AND t3_.is_active = 1 AND NOT EXISTS (SELECT 1 AS sclr_2 FROM tuto_user_log t4_ WHERE t4_.tutorial_id = t3_.id AND t4_.user_id = 11)));

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.image_name AS image_name_5,
  t0.image_size AS image_size_6,
  t0.image_updated_at AS image_updated_at_7,
  t0.created_at AS created_at_8,
  t0.created_by AS created_by_9,
  t0.updated_at AS updated_at_10,
  t0.updated_by AS updated_by_11
FROM
  quiz_model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.label AS label_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.image_size AS image_size_6, t0.image_updated_at AS image_updated_at_7, t0.created_at AS created_at_8, t0.created_by AS created_by_9, t0.updated_at AS updated_at_10, t0.updated_by AS updated_by_11 FROM quiz_model t0 WHERE t0.id = 26;

SELECT
  q0_.id AS id_0,
  q0_.user_id AS user_id_1,
  q0_.lastname AS lastname_2,
  q0_.firstname AS firstname_3,
  q0_.email AS email_4,
  q0_.demo_code AS demo_code_5,
  q0_.created_at AS created_at_6,
  q1_.id AS id_7,
  q1_.label AS label_8,
  q1_.subscription AS subscription_9,
  q1_.sent_at AS sent_at_10,
  q1_.sent_by AS sent_by_11,
  q1_.show_live_result AS show_live_result_12,
  q1_.show_final_result AS show_final_result_13,
  q1_.duration AS duration_14,
  q1_.max_attempts AS max_attempts_15,
  q1_.end_date AS end_date_16,
  q1_.type_mission AS type_mission_17,
  q1_.mission_quiz_mode AS mission_quiz_mode_18,
  q0_.quiz_campaign_id AS quiz_campaign_id_19,
  q1_.quiz_model_id AS quiz_model_id_20,
  q1_.mission_campaign_id AS mission_campaign_id_21
FROM
  quiz_user_registration q0_
  LEFT JOIN quiz_campaign q1_ ON q0_.quiz_campaign_id = q1_.id
WHERE
  q0_.user_id = ?
  AND q1_.type_mission = 0
ORDER BY
  q0_.created_at DESC

SELECT q0_.id AS id_0, q0_.user_id AS user_id_1, q0_.lastname AS lastname_2, q0_.firstname AS firstname_3, q0_.email AS email_4, q0_.demo_code AS demo_code_5, q0_.created_at AS created_at_6, q1_.id AS id_7, q1_.label AS label_8, q1_.subscription AS subscription_9, q1_.sent_at AS sent_at_10, q1_.sent_by AS sent_by_11, q1_.show_live_result AS show_live_result_12, q1_.show_final_result AS show_final_result_13, q1_.duration AS duration_14, q1_.max_attempts AS max_attempts_15, q1_.end_date AS end_date_16, q1_.type_mission AS type_mission_17, q1_.mission_quiz_mode AS mission_quiz_mode_18, q0_.quiz_campaign_id AS quiz_campaign_id_19, q1_.quiz_model_id AS quiz_model_id_20, q1_.mission_campaign_id AS mission_campaign_id_21 FROM quiz_user_registration q0_ LEFT JOIN quiz_campaign q1_ ON q0_.quiz_campaign_id = q1_.id WHERE q0_.user_id = 11 AND q1_.type_mission = 0 ORDER BY q0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.connected_at AS connected_at_3,
  t0.subscription_id AS subscription_id_4
FROM
  connection_log t0
WHERE
  t0.user_id = ?
ORDER BY
  t0.connected_at DESC
LIMIT
  2

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.connected_at AS connected_at_3, t0.subscription_id AS subscription_id_4 FROM connection_log t0 WHERE t0.user_id = 11 ORDER BY t0.connected_at DESC LIMIT 2;

SELECT
  a0_.id AS id_0,
  a0_.is_active AS is_active_1,
  a0_.slug AS slug_2,
  a0_.title AS title_3,
  a0_.summary AS summary_4,
  a0_.content AS content_5,
  a0_.image_name AS image_name_6,
  a0_.image_size AS image_size_7,
  a0_.image_updated_at AS image_updated_at_8,
  a0_.created_at AS created_at_9,
  a0_.created_by AS created_by_10,
  a0_.updated_at AS updated_at_11,
  a0_.updated_by AS updated_by_12
FROM
  actuality a0_
WHERE
  a0_.is_active = 1
  AND a0_.created_at > ?
  AND a0_.created_at <= ?
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.is_active AS is_active_1, a0_.slug AS slug_2, a0_.title AS title_3, a0_.summary AS summary_4, a0_.content AS content_5, a0_.image_name AS image_name_6, a0_.image_size AS image_size_7, a0_.image_updated_at AS image_updated_at_8, a0_.created_at AS created_at_9, a0_.created_by AS created_by_10, a0_.updated_at AS updated_at_11, a0_.updated_by AS updated_by_12 FROM actuality a0_ WHERE a0_.is_active = 1 AND a0_.created_at > '2026-03-24 14:06:48' AND a0_.created_at <= '2026-03-24 17:24:20' ORDER BY a0_.created_at DESC;

SELECT
  COUNT(DISTINCT f0_.id) AS sclr_0
FROM
  fact_sheet_user_log f1_
  INNER JOIN fact_sheet f0_ ON f1_.fact_sheet_id = f0_.id
  INNER JOIN fact_sheet_step f2_ ON f0_.id = f2_.fact_sheet_id
WHERE
  f1_.user_id = ?
  AND f0_.is_active = 1
  AND (
    f0_.subscription_id IS NULL
    OR f0_.subscription_id = ?
  )

SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM fact_sheet_user_log f1_ INNER JOIN fact_sheet f0_ ON f1_.fact_sheet_id = f0_.id INNER JOIN fact_sheet_step f2_ ON f0_.id = f2_.fact_sheet_id WHERE f1_.user_id = 11 AND f0_.is_active = 1 AND (f0_.subscription_id IS NULL OR f0_.subscription_id = 'COP10020767');

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  mission_user_registration m0_
  INNER JOIN mission_campaign m1_ ON m0_.mission_campaign_id = m1_.id
  INNER JOIN mission m2_ ON m1_.mission_id = m2_.id
  LEFT JOIN mission_user m3_ ON m0_.id = m3_.mission_user_registration_id
WHERE
  m0_.user_id = ?
  AND m3_.id IS NULL
  AND m2_.id IN (?, ?, ?, ?)

SELECT COUNT(m0_.id) AS sclr_0 FROM mission_user_registration m0_ INNER JOIN mission_campaign m1_ ON m0_.mission_campaign_id = m1_.id INNER JOIN mission m2_ ON m1_.mission_id = m2_.id LEFT JOIN mission_user m3_ ON m0_.id = m3_.mission_user_registration_id WHERE m0_.user_id = 11 AND m3_.id IS NULL AND m2_.id IN (1, 2, 3, 4);

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  tuto_course t1_
  INNER JOIN tuto_tutorial t0_ ON t1_.id = t0_.course_id
WHERE
  t1_.is_active = 1
  AND t0_.is_active = 1
  AND t1_.subscription_id IS NULL
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_1
        FROM
          subscription_course_disabled s2_
        WHERE
          s2_.disabled_course_id = t1_.id
          AND s2_.subscription_id = ?
      )
    )
  )

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM tuto_course t1_ INNER JOIN tuto_tutorial t0_ ON t1_.id = t0_.course_id WHERE t1_.is_active = 1 AND t0_.is_active = 1 AND t1_.subscription_id IS NULL AND (NOT (EXISTS (SELECT 1 AS sclr_1 FROM subscription_course_disabled s2_ WHERE s2_.disabled_course_id = t1_.id AND s2_.subscription_id = 'COP10020767')));

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  tuto_course t0_
  INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id
WHERE
  t0_.is_active = 1
  AND t1_.is_active = 1
  AND t0_.subscription_id IS NULL
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_1
        FROM
          subscription_course_disabled s2_
        WHERE
          s2_.disabled_course_id = t0_.id
          AND s2_.subscription_id = ?
      )
    )
  )

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM tuto_course t0_ INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id WHERE t0_.is_active = 1 AND t1_.is_active = 1 AND t0_.subscription_id IS NULL AND (NOT (EXISTS (SELECT 1 AS sclr_1 FROM subscription_course_disabled s2_ WHERE s2_.disabled_course_id = t0_.id AND s2_.subscription_id = 'COP10020767')));

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  mission_user_registration m0_
  INNER JOIN mission_user m1_ ON m0_.id = m1_.mission_user_registration_id
WHERE
  m0_.user_id = ?

SELECT COUNT(m0_.id) AS sclr_0 FROM mission_user_registration m0_ INNER JOIN mission_user m1_ ON m0_.id = m1_.mission_user_registration_id WHERE m0_.user_id = 11;

SELECT
  COUNT(DISTINCT f0_.id) AS sclr_0
FROM
  fact_sheet f0_
  INNER JOIN fact_sheet_step f1_ ON f0_.id = f1_.fact_sheet_id
WHERE
  f0_.is_active = 1
  AND f0_.subscription_id IS NULL

SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM fact_sheet f0_ INNER JOIN fact_sheet_step f1_ ON f0_.id = f1_.fact_sheet_id WHERE f0_.is_active = 1 AND f0_.subscription_id IS NULL;

SELECT
  t0.id AS id_1,
  t0.subscription_id AS subscription_id_2,
  t0.quiz_models AS quiz_models_3
FROM
  subscription_quiz_assignment t0
WHERE
  t0.subscription_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.subscription_id AS subscription_id_2, t0.quiz_models AS quiz_models_3 FROM subscription_quiz_assignment t0 WHERE t0.subscription_id = 'COP10020767' LIMIT 1;

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  tuto_course t0_
  INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id
WHERE
  t0_.subscription_id = ?
  AND t0_.is_active = 1
  AND t1_.is_active = 1

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM tuto_course t0_ INNER JOIN tuto_tutorial t1_ ON t0_.id = t1_.course_id WHERE t0_.subscription_id = 'COP10020767' AND t0_.is_active = 1 AND t1_.is_active = 1;

SELECT
  COUNT(DISTINCT f0_.id) AS sclr_0
FROM
  fact_sheet f0_
  INNER JOIN fact_sheet_step f1_ ON f0_.id = f1_.fact_sheet_id
WHERE
  f0_.subscription_id = ?
  AND f0_.is_active = 1

SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM fact_sheet f0_ INNER JOIN fact_sheet_step f1_ ON f0_.id = f1_.fact_sheet_id WHERE f0_.subscription_id = 'COP10020767' AND f0_.is_active = 1;

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  tuto_course t1_
  INNER JOIN tuto_tutorial t0_ ON t1_.id = t0_.course_id
WHERE
  t1_.is_active = 1
  AND t0_.is_active = 1
  AND t1_.subscription_id = ?

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM tuto_course t1_ INNER JOIN tuto_tutorial t0_ ON t1_.id = t0_.course_id WHERE t1_.is_active = 1 AND t0_.is_active = 1 AND t1_.subscription_id = 'COP10020767';