GET https://clinical-talent.isdeveloping.com/en/questionnaire/ortodoncia

Query Metrics

44 Database Queries
16 Different statements
10.19 ms Query time
0 Invalid entities
138 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.30 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.area AS area_2, c0_.image_key AS image_key_3, c0_.estimated_minutes AS estimated_minutes_4, c0_.duration_minutes_min AS duration_minutes_min_5, c0_.duration_minutes_max AS duration_minutes_max_6, c0_.require_all_answers AS require_all_answers_7, c0_.is_active AS is_active_8, c0_.position AS position_9, c0_.texts AS texts_10, c0_.professional_profile_id AS professional_profile_id_11, c0_.recommended_specialty_id AS recommended_specialty_id_12 FROM content_questionnaires c0_ WHERE c0_.slug = ?
Parameters:
[
  "ortodoncia"
]
2 0.37 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_blocks t0 WHERE t0.questionnaire_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%rÌ—Ä!wFÄnæ"
]
3 0.33 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"""
    \x01 úH„%sì—Ä!wK@\n
    \x03
    """
]
4 0.26 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%uˆ—Ä!wK¯­Á"
]
5 0.20 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%v —Ä!wK¼Ÿ\x14"
]
6 0.16 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%vˆ—Ä!wKäæ\x03"
]
7 0.16 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%vì—Ä!wL\rï\r"
]
8 0.16 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%wP—Ä!wL+€ô"
]
9 0.34 ms
SELECT t0.id AS id_1 FROM training_professional_profiles t0 WHERE t0.id = ?
Parameters:
[
  b"\x01 úHƒ*qi€PˆÇþý@E"
]
10 0.37 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.profile_id AS profile_id_4 FROM training_professional_profile_translations t0 WHERE t0.profile_id = ?
Parameters:
[
  b"\x01 úHƒ*qi€PˆÇþý@E"
]
11 0.23 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_sections t0 WHERE t0.questionnaire_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%rÌ—Ä!wFÄnæ"
]
12 0.19 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.section_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%sX—Ä!wG¶±ì"
]
13 0.17 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.section_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%sˆ—Ä!wH\x16V"
]
14 0.16 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.section_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%sœ—Ä!wI[Р"
]
15 0.32 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.section_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%s¬—Ä!wIá’¤"
]
16 0.17 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.section_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%sÀ—Ä!wJ\x0E\x12"
]
17 0.20 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.section_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%sЗÄ!wJA¯ú"
]
18 0.18 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%yŒ—Ä!wNî#Â"
]
19 0.16 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%z\x04—Ä!wQwÈ3"
]
20 0.15 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%zX—Ä!wS\x00Æü"
]
21 0.18 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%z¨—Ä!wU±íÁ"
]
22 0.16 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%{\x08—Ä!wX&8l"
]
23 0.18 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%{`—Ä!wZ\x08Ó¤"
]
24 0.16 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%{°—Ä!w\ ¯¨"
]
25 0.18 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%|\x00—Ä!w_GŠ‘"
]
26 0.15 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%|L—Ä!wbS\x00—"
]
27 0.17 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%}0—Ä!wdÆ…¤"
]
28 0.15 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%}„—Ä!wgŽ\x06¿"
]
29 0.16 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%}Ô—Ä!wh†3b"
]
30 0.16 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%~$—Ä!wk|Kµ"
]
31 0.21 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%~ˆ—Ä!wn›\x179"
]
32 0.21 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%~Ø—Ä!wp!ÄÔ"
]
33 0.23 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%\x7F(—Ä!wr§òê"
]
34 0.23 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score AS score_3, t0.texts AS texts_4, t0.question_id AS question_id_5 FROM content_question_options t0 WHERE t0.question_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%\x7Ft—Ä!wu\x0F­C"
]
35 0.39 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.score_min AS score_min_3, t0.score_max AS score_max_4, t0.texts AS texts_5, t0.questionnaire_id AS questionnaire_id_6 FROM content_questionnaire_result_profiles t0 WHERE t0.questionnaire_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%rÌ—Ä!wFÄnæ"
]
36 0.36 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_competences t0 WHERE t0.questionnaire_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH„%rÌ—Ä!wFÄnæ"
]
37 0.21 ms
SELECT t0.id AS id_1, t0.color AS color_2 FROM training_specialties t0 WHERE t0.id = ?
Parameters:
[
  b"\x01 úHƒ\x11xÄ“\r\x1AJðº6ß"
]
38 0.23 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.specialty_id AS specialty_id_4 FROM training_specialty_translations t0 WHERE t0.specialty_id = ?
Parameters:
[
  b"\x01 úHƒ\x11xÄ“\r\x1AJðº6ß"
]
39 0.34 ms
SELECT t0.id AS id_1, t0.texts AS texts_2, t0.contact_email AS contact_email_3, t0.contact_phone AS contact_phone_4 FROM content_footer_settings t0 LIMIT 1
Parameters:
[]
40 0.47 ms
SELECT c0_.id AS id_0, c0_.texts AS texts_1, c0_.position AS position_2, c1_.id AS id_3, c1_.texts AS texts_4, c1_.position AS position_5, c1_.destination AS destination_6, c1_.route_name AS route_name_7, c1_.external_url AS external_url_8, c1_.fragment AS fragment_9, c0_.footer_id AS footer_id_10, c1_.column_id AS column_id_11 FROM content_footer_columns c0_ LEFT JOIN content_footer_links c1_ ON c0_.id = c1_.column_id ORDER BY c0_.position ASC, c1_.position ASC
Parameters:
[]
41 0.30 ms
SELECT t0.id AS id_1, t0.icon_key AS icon_key_2, t0.url AS url_3, t0.label AS label_4, t0.position AS position_5, t0.footer_id AS footer_id_6 FROM content_footer_social_links t0 WHERE t0.footer_id = ? ORDER BY t0.position ASC
Parameters:
[
  b"\x01 úH…–wà¶\x01Ç\x07?£hè"
]
42 0.35 ms
SELECT c0_.id AS id_0, c0_.document_key AS document_key_1, c0_.is_active AS is_active_2, c0_.texts AS texts_3 FROM content_legal_documents c0_ WHERE c0_.document_key = ? AND c0_.is_active = 1
Parameters:
[
  "legal_notice"
]
43 0.24 ms
SELECT c0_.id AS id_0, c0_.document_key AS document_key_1, c0_.is_active AS is_active_2, c0_.texts AS texts_3 FROM content_legal_documents c0_ WHERE c0_.document_key = ? AND c0_.is_active = 1
Parameters:
[
  "privacy_policy"
]
44 0.18 ms
SELECT c0_.id AS id_0, c0_.document_key AS document_key_1, c0_.is_active AS is_active_2, c0_.texts AS texts_3 FROM content_legal_documents c0_ WHERE c0_.document_key = ? AND c0_.is_active = 1
Parameters:
[
  "cookies_policy"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Content\Domain\QuestionOption 68
App\Content\Domain\Question 17
App\Content\Domain\FooterLink 15
App\Content\Domain\QuestionBlock 6
App\Content\Domain\QuestionnaireSection 6
App\Content\Domain\FooterColumn 5
App\Content\Domain\Competence 3
App\Training\Domain\ProfessionalProfileTranslation 3
App\Content\Domain\ResultProfile 3
App\Training\Domain\SpecialtyTranslation 3
App\Content\Domain\FooterSocialLink 3
App\Content\Domain\LegalDocument 2
App\Content\Domain\Questionnaire 1
App\Training\Domain\ProfessionalProfile 1
App\Training\Domain\Specialty 1
App\Content\Domain\FooterSettings 1