Symfony Profiler

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
  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(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 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(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 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';

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
  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 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
  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.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
  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
  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(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 = 796;

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 = 22;

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 = 22 ORDER BY t0.position ASC;

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 = 4 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 = 795;

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 = 794;

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 = 788;

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 = 23;

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 = 23 ORDER BY t0.position ASC;

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 = 8 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 = ?
  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 = 6 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 = 722;

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 = 707;

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 = 11;

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 = 11 ORDER BY t0.position ASC;

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);