Query Metrics
29
Database Queries
8
Different statements
16.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.45 ms (27.15%) |
18 |
SELECT t0.id AS id_1, t0.param AS param_2, t0.value AS value_3, t0.section AS section_4, t0.info AS info_5 FROM params t0 WHERE t0.param = ? LIMIT 1
Parameters:
[
"LOGO_MENU"
]
|
|
4.42 ms (26.93%) |
2 |
SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.label AS label_2, t0_.taxonomy_id AS taxonomy_id_3 FROM taxonomy_value t0_ INNER JOIN taxonomy t1_ ON t0_.taxonomy_id = t1_.id WHERE t1_.name = ? ORDER BY t0_.label ASC
Parameters:
[
"Modalidad"
]
|
|
2.49 ms (15.18%) |
1 |
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM events e0_ WHERE e0_.published = 1
Parameters:
[] |
|
2.00 ms (12.23%) |
4 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.taxonomy_id AS taxonomy_id_4 FROM taxonomy_value t0 INNER JOIN events_taxonomy_value ON t0.id = events_taxonomy_value.taxonomy_value_id WHERE events_taxonomy_value.events_id = ?
Parameters:
[
27
]
|
|
1.62 ms (9.90%) |
1 |
SELECT h0_.id AS id_0, h0_.position AS position_1, h0_.enabled AS enabled_2, h0_.event_id AS event_id_3 FROM home_slider h0_ WHERE h0_.enabled = 1 ORDER BY h0_.position ASC
Parameters:
[] |
|
0.74 ms (4.49%) |
1 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.ext_code AS ext_code_2, e0_.published AS published_3, e0_.start_date AS start_date_4, e0_.end_date AS end_date_5, e0_.inscripciones_inicio AS inscripciones_inicio_6, e0_.inscripciones_fin AS inscripciones_fin_7, e0_.start_time AS start_time_8, e0_.end_time AS end_time_9, e0_.max_registrations AS max_registrations_10, e0_.created AS created_11, e0_.updated AS updated_12, e0_.generation_qr AS generation_qr_13, e0_.status AS status_14, e0_.hours AS hours_15, e0_.participants AS participants_16, e0_.target_groups AS target_groups_17, e0_.target_admin AS target_admin_18, e0_.total_days AS total_days_19, e0_.shift AS shift_20, e0_.number_checkings AS number_checkings_21, e0_.min_compliance AS min_compliance_22, e0_.image AS image_23, e0_.description AS description_24, e0_.objetives AS objetives_25, e0_.skills AS skills_26, e0_.contents AS contents_27, e0_.planned_materials AS planned_materials_28, e0_.internal_observations AS internal_observations_29, e0_.control_asistencias AS control_asistencias_30, e0_.cuestionario_conocimiento AS cuestionario_conocimiento_31, e0_.actividades_practicas AS actividades_practicas_32, e0_.evaluacion_certificacion_interna AS evaluacion_certificacion_interna_33, e0_.prerequisites AS prerequisites_34, e0_.technical_requirements AS technical_requirements_35, e0_.date_and_time AS date_and_time_36, e0_.location AS location_37, e0_.center_id AS center_id_38, e0_.modality_id AS modality_id_39 FROM events e0_ WHERE e0_.published = 1 AND e0_.id IN (?, ?, ?, ?) ORDER BY e0_.start_date ASC
Parameters:
[ 27 26 29 30 ] |
|
0.34 ms (2.09%) |
1 |
SELECT DISTINCT e0_.id AS id_0, e0_.start_date AS start_date_1 FROM events e0_ WHERE e0_.published = 1 ORDER BY e0_.start_date ASC LIMIT 6
Parameters:
[] |
|
0.33 ms (2.04%) |
1 |
SELECT MIN(e0_.hours) AS sclr_0, MAX(e0_.hours) AS sclr_1 FROM events e0_ WHERE e0_.hours IS NOT NULL
Parameters:
[] |
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Events | No errors. |
| App\Entity\Centers | No errors. |
| App\Entity\TaxonomyValue | No errors. |
| App\Entity\Registrations | No errors. |
| App\Entity\User | No errors. |
| App\Entity\EventRequest | No errors. |
| App\Entity\RegistrationQualification | No errors. |
| App\Entity\Taxonomy | No errors. |
| App\Entity\HomeSlider | No errors. |
| App\Entity\Params | No errors. |