Symfony Profiler

SELECT
  mpm.id
from
  materials_pill_material mpm
  JOIN materials_pill_version mpv on mpm.version_id = mpv.id
  JOIN materials_course_chapter_pill_version mccpv on mccpv.pill_version_id = mpv.id
  JOIN materials_course_chapter mcc on mccpv.chapter_id = mcc.id
  JOIN materials_course_module mcm on mcc.module_id = mcm.id
  JOIN materials_course_pass_criterion mcpc on mcc.type = mcpc.type
  and mcm.course_id = mcpc.course_id
WHERE
  mcm.course_id = :courseId
  AND mpm.quiz_id = :quizId

SELECT mpm.id
from materials_pill_material mpm
    JOIN materials_pill_version mpv on mpm.version_id = mpv.id
    JOIN materials_course_chapter_pill_version mccpv on mccpv.pill_version_id = mpv.id
    JOIN materials_course_chapter mcc on mccpv.chapter_id = mcc.id
    JOIN materials_course_module mcm on mcc.module_id = mcm.id
    JOIN materials_course_pass_criterion mcpc on mcc.type = mcpc.type and mcm.course_id = mcpc.course_id
WHERE mcm.course_id = 'b5fb1435-06fc-4945-9fa8-777042a08a0e' AND mpm.quiz_id = '092718c5-2aa6-44c4-b9fd-0449e64ccd3a';

SELECT
  id,
  url,
  auth_token
FROM
  credential_settings
WHERE
  type = :type
  AND (
    DATE(limit_date) < NOW()
    OR limit_date IS NULL
  )
ORDER BY
  RAND()
LIMIT
  1;

SELECT id, url, auth_token FROM credential_settings
    WHERE type = 'surveymonkey_proxy' AND (DATE(limit_date) < NOW() OR limit_date IS NULL)
    ORDER BY RAND() LIMIT 1;;

SELECT
  t0.id AS id_1,
  t0.provider_id AS provider_id_2,
  t0.url AS url_3,
  t0.state AS state_4,
  t0.provider_settings AS provider_settings_5
FROM
  materials_quiz t0
WHERE
  t0.provider_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.provider_id AS provider_id_2, t0.url AS url_3, t0.state AS state_4, t0.provider_settings AS provider_settings_5 FROM materials_quiz t0 WHERE t0.provider_id = '414019956' LIMIT 1;

SELECT
  count(id) as cnt
FROM
  credential_settings
WHERE
  type = :type
  AND limit_date < NOW()

SELECT count(id) as cnt FROM credential_settings WHERE type = 'surveymonkey_proxy' AND limit_date < NOW();