GET https://clinical-talent.isdeveloping.com/en/questionnaire/flujo-digital-laboratorios

Query Metrics

41 Database Queries
16 Different statements
10.79 ms Query time
0 Invalid entities
123 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
3.08 ms
(28.51%)
14
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„\x05yI¥\x04†Šª>¦i"
]
1.38 ms
(12.80%)
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„\x05tq¥\x04†Š¢\x11ˆi"
]
1.30 ms
(12.02%)
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„\x05u-¥\x04†Š¤ï†E"
]
0.97 ms
(9.04%)
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.52 ms
(4.87%)
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„\x05så¥\x04†Š¡k_$"
]
0.51 ms
(4.74%)
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.38 ms
(3.52%)
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„\x05så¥\x04†Š¡k_$"
]
0.38 ms
(3.50%)
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.33 ms
(3.07%)
1
SELECT t0.id AS id_1 FROM training_professional_profiles t0 WHERE t0.id = ?
Parameters:
[
  b"\x01 úHƒ7p%¨ƒ‡«sË™O"
]
0.33 ms
(3.07%)
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.31 ms
(2.83%)
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ƒ7p%¨ƒ‡«sË™O"
]
0.30 ms
(2.81%)
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:
[
  "flujo-digital-laboratorios"
]
0.28 ms
(2.64%)
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„\x05så¥\x04†Š¡k_$"
]
0.24 ms
(2.25%)
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„\x05så¥\x04†Š¡k_$"
]
0.24 ms
(2.22%)
1
SELECT t0.id AS id_1, t0.color AS color_2 FROM training_specialties t0 WHERE t0.id = ?
Parameters:
[
  b"\x01 úHƒ"}^-‹P|Ñ\x0E~"
]
0.23 ms
(2.11%)
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ƒ"}^-‹P|Ñ\x0E~"
]

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 56
App\Content\Domain\FooterLink 15
App\Content\Domain\Question 14
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