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

Query Metrics

39 Database Queries
16 Different statements
9.86 ms Query time
0 Invalid entities
113 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
2.75 ms
(27.85%)
12
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„KsX©ñü:ô%tL"
]
1.41 ms
(14.26%)
6
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„J~,¢öÓ\x03E±‚¯"
]
1.24 ms
(12.54%)
6
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„J~è¢öÓ\x03Ižå›"
]
0.64 ms
(6.53%)
3
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"
]
0.54 ms
(5.50%)
1
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:
[]
0.44 ms
(4.46%)
1
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:
[]
0.37 ms
(3.75%)
1
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„J}¬¢öÓ\x03Däî"
]
0.36 ms
(3.60%)
1
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è"
]
0.34 ms
(3.44%)
1
SELECT t0.id AS id_1 FROM training_professional_profiles t0 WHERE t0.id = ?
Parameters:
[
  b"\x01 úHƒ:q\t­\fC†Š\x07ŠÇ"
]
0.32 ms
(3.26%)
1
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ƒ:q\t­\fC†Š\x07ŠÇ"
]
0.31 ms
(3.15%)
1
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:
[
  "implantes-subperiosticos"
]
0.28 ms
(2.82%)
1
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„J}¬¢öÓ\x03Däî"
]
0.27 ms
(2.73%)
1
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„J}¬¢öÓ\x03Däî"
]
0.24 ms
(2.45%)
1
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„J}¬¢öÓ\x03Däî"
]
0.19 ms
(1.92%)
1
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ƒ\x15q\x08§OßÕ¿s†É"
]
0.17 ms
(1.74%)
1
SELECT t0.id AS id_1, t0.color AS color_2 FROM training_specialties t0 WHERE t0.id = ?
Parameters:
[
  b"\x01 úHƒ\x15q\x08§OßÕ¿s†É"
]

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 48
App\Content\Domain\FooterLink 15
App\Content\Domain\Question 12
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