Query Metrics
26
Database Queries
6
Different statements
23.38 ms
Query time
1
Invalid entities
109
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
13.30 ms (56.87%) |
2 |
SELECT p0_.id AS id_0, p0_.starts_on AS starts_on_1, p0_.ends_on AS ends_on_2, p0_.duration AS duration_3, p0_.duration_hours AS duration_hours_4, p0_.title AS title_5, p0_.description AS description_6, p0_.address AS address_7, p0_.latitude AS latitude_8, p0_.longitude AS longitude_9, p0_.featured_image AS featured_image_10, p0_.featured_image_thumb AS featured_image_thumb_11, p0_.rendezvous_time AS rendezvous_time_12, p0_.visible AS visible_13, p0_.canceled AS canceled_14, p0_.deleted AS deleted_15, p0_.payment_by_account AS payment_by_account_16, p0_.payment_by_other AS payment_by_other_17, p0_.payment_amount AS payment_amount_18, p0_.payment_other_amount AS payment_other_amount_19, p0_.advance_payment_amount AS advance_payment_amount_20, p0_.debit_on AS debit_on_21, p0_.registration_required AS registration_required_22, p0_.registration_start AS registration_start_23, p0_.registration_end AS registration_end_24, p0_.maximum_registrations AS maximum_registrations_25, p0_.registrations_cancellable AS registrations_cancellable_26, p0_.withdrawal_deadline AS withdrawal_deadline_27, p0_.accounting_code AS accounting_code_28, p0_.accounting_ana_code AS accounting_ana_code_29, p0_.total_cost AS total_cost_30, p0_.validated AS validated_31, p0_.legal_validated AS legal_validated_32, p0_.validated_at AS validated_at_33, p0_.legal_validated_at AS legal_validated_at_34, p0_.validation_email_sent AS validation_email_sent_35, p0_.validation_email_sent_at AS validation_email_sent_at_36, p0_.created_at AS created_at_37, p0_.updated_at AS updated_at_38, p0_.registration_by_organizer AS registration_by_organizer_39, p0_.elevation AS elevation_40, p0_.distance AS distance_41, p0_.training AS training_42, p0_.activity_id AS activity_id_43, p0_.section_id AS section_id_44, p0_.creator_id AS creator_id_45, p0_.supervisor_id AS supervisor_id_46, p0_.localisation_id AS localisation_id_47, p0_.canceled_by_id AS canceled_by_id_48, p0_.deleted_by_id AS deleted_by_id_49, p0_.validated_by_id AS validated_by_id_50, p0_.legal_validated_by_id AS legal_validated_by_id_51, p0_.level_id AS level_id_52 FROM program p0_ WHERE (p0_.visible = 1 AND p0_.deleted = 0 AND p0_.validated = 1 AND p0_.starts_on >= ?) AND p0_.training IN ('0') ORDER BY p0_.starts_on ASC LIMIT 8
Parameters:
[
"2025-12-12 00:00:00"
]
|
|
4.24 ms (18.15%) |
8 |
SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0')
Parameters:
[
16134
]
|
|
2.71 ms (11.61%) |
12 |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ?
Parameters:
[
26
]
|
|
1.85 ms (7.89%) |
1 |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.status AS status_3, a0_.moderation_comment AS moderation_comment_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.published_at AS published_at_7, a0_.archived_at AS archived_at_8, a0_.views AS views_9, a0_.author_id AS author_id_10, a0_.program_id AS program_id_11, a0_.category_id AS category_id_12, a0_.published_by_id AS published_by_id_13 FROM article a0_ WHERE a0_.status = ? ORDER BY a0_.published_at DESC LIMIT 12
Parameters:
[
"PUBLISHED"
]
|
|
0.78 ms (3.34%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.visible AS visible_4 FROM article_category t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.50 ms (2.13%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.activity_code AS activity_code_4, t0.person_in_charge AS person_in_charge_5, t0.color AS color_6, t0.visible AS visible_7, t0.validation_required AS validation_required_8 FROM caf2_section t0 WHERE t0.id = ?
Parameters:
[
7
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| refuge | doctrine.dbal.refuge_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| refuge | doctrine.orm.refuge_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\ArticleImage | 35 |
| App\Entity\Article | 12 |
| App\Entity\BaseProgram | 10 |
| App\Entity\Supervisor | 9 |
| App\Entity\Member | 8 |
| App\Entity\AdminUser | 8 |
| App\Entity\ActivityLevel | 8 |
| App\Entity\Activity | 6 |
| App\Entity\Section | 6 |
| App\Entity\Localisation | 5 |
| App\Entity\ArticleCategory | 2 |
refuge entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Article | No errors. |
| App\Entity\Member | No errors. |
| App\Entity\BaseProgram | No errors. |
| App\Entity\ArticleCategory |
|
| App\Entity\AdminUser | No errors. |
| App\Entity\Activity | No errors. |
| App\Entity\Section | No errors. |
| App\Entity\Supervisor | No errors. |
| App\Entity\Localisation | No errors. |
| App\Entity\Program | No errors. |
| App\Entity\ActivityLevel | No errors. |
| App\Entity\ProgramRegistration | No errors. |
| App\Entity\MonetaryAccountMovement | No errors. |
| App\Entity\Retex | No errors. |
| App\Entity\Equipment | No errors. |
| App\Entity\ArticleImage | No errors. |
| App\Entity\ArticleComment | No errors. |
refuge entity manager
No loaded entities.