GET https://clinical-talent.isdeveloping.com/ca/questionari/flujo-digital-odontologos

Query Metrics

37 Database Queries
16 Different statements
10.70 ms Query time
0 Invalid entities
110 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
2.96 ms
(27.69%)
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ƒæq#µ\x13Ø1hq|"
]
1.35 ms
(12.63%)
5
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ƒå|\x13“jZ‘fé÷"
]
1.14 ms
(10.65%)
5
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ƒå};“jZ“­¾O"
]
0.96 ms
(8.94%)
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.49 ms
(4.55%)
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.43 ms
(4.02%)
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ƒå{““jZ‘\x03\x18""
]
0.41 ms
(3.85%)
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.48%)
1
SELECT t0.id AS id_1 FROM training_professional_profiles t0 WHERE t0.id = ?
Parameters:
[
  b"\x01 úHƒ*qi€PˆÇþý@E"
]
0.36 ms
(3.35%)
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.22%)
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ƒ*qi€PˆÇþý@E"
]
0.34 ms
(3.15%)
1
SELECT t0.id AS id_1, t0.color AS color_2 FROM training_specialties t0 WHERE t0.id = ?
Parameters:
[
  b"\x01 úHƒ\rzTŠ²tRå3Õ"
]
0.33 ms
(3.06%)
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ƒ\rzTŠ²tRå3Õ"
]
0.32 ms
(3.00%)
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ƒå{““jZ‘\x03\x18""
]
0.30 ms
(2.84%)
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ƒå{““jZ‘\x03\x18""
]
0.30 ms
(2.80%)
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ƒå{““jZ‘\x03\x18""
]
0.30 ms
(2.78%)
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-odontologos"
]

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 5
App\Content\Domain\QuestionnaireSection 5
App\Content\Domain\FooterColumn 5
App\Training\Domain\ProfessionalProfileTranslation 3
App\Content\Domain\ResultProfile 3
App\Training\Domain\SpecialtyTranslation 3
App\Content\Domain\FooterSocialLink 3
App\Content\Domain\Competence 2
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