Query Metrics
6
Database Queries
5
Different statements
3.64 ms
Query time
0
Invalid entities
94
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.46 ms (40.02%) |
1 |
SELECT a0_.id AS id_0, a0_.ajuste_horas AS ajuste_horas_1, a0_.ajuste_precio AS ajuste_precio_2, a0_.capacidad AS capacidad_3, a0_.fecha AS fecha_4, a0_.precio_especial AS precio_especial_5, a0_.slug AS slug_6, a1_.id AS id_7, a1_.fecha_sometida AS fecha_sometida_8, a1_.fecha_inicial AS fecha_inicial_9, a1_.codigo_asignado AS codigo_asignado_10, a1_.horas_sometidas AS horas_sometidas_11, a1_.precio_regular AS precio_regular_12, a1_.duracion AS duracion_13, a1_.codigo_inicial AS codigo_inicial_14, a1_.codigo_final AS codigo_final_15, a1_.is_active AS is_active_16, a1_.aprobacion_status AS aprobacion_status_17, a1_.added_juntas AS added_juntas_18, a1_.fecha_aprobada AS fecha_aprobada_19, a2_.id AS id_20, a2_.title AS title_21, a2_.is_modulo AS is_modulo_22, a2_.is_active AS is_active_23, a2_.image_name AS image_name_24, a2_.image_size AS image_size_25, a2_.pdf_name AS pdf_name_26, a2_.pdf_size AS pdf_size_27, a2_.updated_at AS updated_at_28, a2_.description AS description_29, a3_.id AS id_30, a3_.status AS status_31, a3_.orden AS orden_32, a3_.label_color AS label_color_33, j4_.id AS id_34, j4_.horas_aprobadas AS horas_aprobadas_35, j4_.fecha_aprobada AS fecha_aprobada_36, j4_.fecha_sometida AS fecha_sometida_37, j4_.fecha_no_aprobada AS fecha_no_aprobada_38, j4_.horas_sometidas AS horas_sometidas_39, j4_.horas_aprobadas_override AS horas_aprobadas_override_40, p5_.id AS id_41, p5_.profesion AS profesion_42, p5_.siglas AS siglas_43, p5_.codigo_profesion AS codigo_profesion_44, p5_.horas_requeridas_total AS horas_requeridas_total_45, p5_.horas_requeridas_presencial AS horas_requeridas_presencial_46, p5_.is_default AS is_default_47, p5_.is_featured AS is_featured_48, p5_.slug AS slug_49, p5_.is_public AS is_public_50, p5_.icon AS icon_51, a0_.aprobacion_id AS aprobacion_id_52, a0_.actividad_status_id AS actividad_status_id_53, a0_.codigo_id AS codigo_id_54, a0_.actividad_class_id AS actividad_class_id_55, a1_.aprobacion_name_id AS aprobacion_name_id_56, a1_.aprobacion_class_id AS aprobacion_class_id_57, j4_.aprobacion_id AS aprobacion_id_58, j4_.profesion_id AS profesion_id_59, j4_.junta_status_id AS junta_status_id_60 FROM actividad a0_ LEFT JOIN aprobacion a1_ ON a0_.aprobacion_id = a1_.id LEFT JOIN aprobacion_name a2_ ON a1_.aprobacion_name_id = a2_.id LEFT JOIN actividad_status a3_ ON a0_.actividad_status_id = a3_.id LEFT JOIN junta j4_ ON a1_.id = j4_.aprobacion_id LEFT JOIN profesion p5_ ON j4_.profesion_id = p5_.id WHERE a0_.fecha > ? AND j4_.horas_aprobadas > 0 AND j4_.junta_status_id = 3 ORDER BY a0_.fecha ASC, a2_.title ASC
Parameters:
[
"2026-02-25 15:39:26"
]
|
||||||||||||||||||||||||||||||||
|
0.89 ms (24.50%) |
2 |
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.is_archivada AS is_archivada_3, t0.actividad_id AS actividad_id_4, t0.estudiante_id AS estudiante_id_5, t0.cart_item_id AS cart_item_id_6, t0.matricula_status_id AS matricula_status_id_7 FROM matricula t0 WHERE t0.actividad_id = ?
Parameters:
[
6
]
|
||||||||||||||||||||||||||||||||
|
0.48 ms (13.27%) |
1 |
SELECT t0.id AS id_1, t0.profesion AS profesion_2, t0.siglas AS siglas_3, t0.codigo_profesion AS codigo_profesion_4, t0.horas_requeridas_total AS horas_requeridas_total_5, t0.horas_requeridas_presencial AS horas_requeridas_presencial_6, t0.is_default AS is_default_7, t0.is_featured AS is_featured_8, t0.slug AS slug_9, t0.is_public AS is_public_10, t0.icon AS icon_11 FROM profesion t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"terapeutas-de-masaje"
]
|
||||||||||||||||||||||||||||||||
|
0.43 ms (11.89%) |
1 |
SELECT p0_.id AS id_0, p0_.profesion AS profesion_1, p0_.siglas AS siglas_2, p0_.codigo_profesion AS codigo_profesion_3, p0_.horas_requeridas_total AS horas_requeridas_total_4, p0_.horas_requeridas_presencial AS horas_requeridas_presencial_5, p0_.is_default AS is_default_6, p0_.is_featured AS is_featured_7, p0_.slug AS slug_8, p0_.is_public AS is_public_9, p0_.icon AS icon_10 FROM profesion p0_ WHERE p0_.id NOT IN (?, ?) ORDER BY p0_.profesion ASC
Parameters:
[ 1 55 ] |
||||||||||||||||||||||||||||||||
|
0.38 ms (10.33%) |
1 |
SELECT t0.id AS id_1, t0.profesion AS profesion_2, t0.siglas AS siglas_3, t0.codigo_profesion AS codigo_profesion_4, t0.horas_requeridas_total AS horas_requeridas_total_5, t0.horas_requeridas_presencial AS horas_requeridas_presencial_6, t0.is_default AS is_default_7, t0.is_featured AS is_featured_8, t0.slug AS slug_9, t0.is_public AS is_public_10, t0.icon AS icon_11 FROM profesion t0 WHERE t0.is_default = ? ORDER BY t0.profesion ASC
Parameters:
[
1
]
|
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\Entity\Profesion | 49 |
| App\Entity\Junta | 23 |
| App\Entity\Actividad | 6 |
| App\Entity\Codigo | 6 |
| App\Entity\Aprobacion | 4 |
| App\Entity\AprobacionName | 4 |
| App\Entity\ActividadStatus | 1 |
| App\Entity\JuntaStatus | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Profesion | No errors. |
| App\Entity\UserProfesion | No errors. |
| App\Entity\Junta | No errors. |
| App\Entity\Actividad | No errors. |
| App\Entity\Aprobacion | No errors. |
| App\Entity\AprobacionName | No errors. |
| App\Entity\ActividadStatus | No errors. |
| App\Entity\Codigo | No errors. |
| App\Entity\ActividadClass | No errors. |
| App\Entity\AprobacionClass | No errors. |
| App\Entity\JuntaStatus | No errors. |
| App\Entity\Seccion | No errors. |
| App\Entity\Matricula | No errors. |
| App\Entity\User | No errors. |
| App\Entity\CartItem | No errors. |
| App\Entity\MatriculaStatus | No errors. |