Query Metrics
21
Database Queries
11
Different statements
8.26 ms
Query time
1
Invalid entities
40
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
2.13 ms (25.77%) |
5 |
SELECT t0.license AS license_1, t0.license_key AS license_key_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.member_since AS member_since_5, t0.birthday AS birthday_6, t0.ffcam_membership_since AS ffcam_membership_since_7, t0.ffcam_last_sync_on AS ffcam_last_sync_on_8, t0.renewed_membership AS renewed_membership_9, t0.closed_account AS closed_account_10, t0.email AS email_11, t0.invalid_email AS invalid_email_12, t0.mobile_phone_number AS mobile_phone_number_13, t0.home_phone_number AS home_phone_number_14, t0.emergency_phone_number AS emergency_phone_number_15, t0.has_cm AS has_cm_16, t0.terms_agreed_at AS terms_agreed_at_17, t0.newsletter_subscribed_at AS newsletter_subscribed_at_18, t0.comment AS comment_19, t0.newsletter_subscriptions AS newsletter_subscriptions_20, t0.negative_balance_email_counter AS negative_balance_email_counter_21, t0.id AS id_22, t0.username AS username_23, t0.password AS password_24, t0.active AS active_25, t0.locked AS locked_26, t0.failed_login AS failed_login_27, t0.expires_at AS expires_at_28, t0.credentials_expire_at AS credentials_expire_at_29, t0.roles AS roles_30, t0.last_login AS last_login_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.token AS token_34, t35.first_name AS first_name_36, t35.last_name AS last_name_37, t35.email AS email_38, t35.phone_number AS phone_number_39, t35.email_receipt AS email_receipt_40, t35.rights AS rights_41, t35.id AS id_42, t35.username AS username_43, t35.password AS password_44, t35.active AS active_45, t35.locked AS locked_46, t35.failed_login AS failed_login_47, t35.expires_at AS expires_at_48, t35.credentials_expire_at AS credentials_expire_at_49, t35.roles AS roles_50, t35.last_login AS last_login_51, t35.created_at AS created_at_52, t35.updated_at AS updated_at_53, t35.token AS token_54, t35.member_id AS member_id_55 FROM caf2_member t0 LEFT JOIN caf2_admin_user t35 ON t35.member_id = t0.id WHERE t0.id = ?
Parameters:
[
15
]
|
|
1.54 ms (18.59%) |
3 |
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:
[
16138
]
|
|
1.14 ms (13.79%) |
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, RAND() AS sclr_10, a0_.author_id AS author_id_11, a0_.program_id AS program_id_12, a0_.category_id AS category_id_13, a0_.published_by_id AS published_by_id_14 FROM article a0_ WHERE a0_.status = ? AND a0_.id <> ? ORDER BY sclr_10 ASC LIMIT 3
Parameters:
[ "PUBLISHED" 14 ] |
|
0.86 ms (10.42%) |
4 |
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:
[
14
]
|
|
0.66 ms (7.94%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.status AS status_4, t0.moderation_comment AS moderation_comment_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.published_at AS published_at_8, t0.archived_at AS archived_at_9, t0.views AS views_10, t0.author_id AS author_id_11, t0.program_id AS program_id_12, t0.category_id AS category_id_13, t0.published_by_id AS published_by_id_14 FROM article t0 WHERE t0.id = ?
Parameters:
[
14
]
|
|
0.51 ms (6.13%) |
1 |
SELECT t0.license AS license_1, t0.license_key AS license_key_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.member_since AS member_since_5, t0.birthday AS birthday_6, t0.ffcam_membership_since AS ffcam_membership_since_7, t0.ffcam_last_sync_on AS ffcam_last_sync_on_8, t0.renewed_membership AS renewed_membership_9, t0.closed_account AS closed_account_10, t0.email AS email_11, t0.invalid_email AS invalid_email_12, t0.mobile_phone_number AS mobile_phone_number_13, t0.home_phone_number AS home_phone_number_14, t0.emergency_phone_number AS emergency_phone_number_15, t0.has_cm AS has_cm_16, t0.terms_agreed_at AS terms_agreed_at_17, t0.newsletter_subscribed_at AS newsletter_subscribed_at_18, t0.comment AS comment_19, t0.newsletter_subscriptions AS newsletter_subscriptions_20, t0.negative_balance_email_counter AS negative_balance_email_counter_21, t0.id AS id_22, t0.username AS username_23, t0.password AS password_24, t0.active AS active_25, t0.locked AS locked_26, t0.failed_login AS failed_login_27, t0.expires_at AS expires_at_28, t0.credentials_expire_at AS credentials_expire_at_29, t0.roles AS roles_30, t0.last_login AS last_login_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.token AS token_34, t35.first_name AS first_name_36, t35.last_name AS last_name_37, t35.email AS email_38, t35.phone_number AS phone_number_39, t35.email_receipt AS email_receipt_40, t35.rights AS rights_41, t35.id AS id_42, t35.username AS username_43, t35.password AS password_44, t35.active AS active_45, t35.locked AS locked_46, t35.failed_login AS failed_login_47, t35.expires_at AS expires_at_48, t35.credentials_expire_at AS credentials_expire_at_49, t35.roles AS roles_50, t35.last_login AS last_login_51, t35.created_at AS created_at_52, t35.updated_at AS updated_at_53, t35.token AS token_54, t35.member_id AS member_id_55 FROM caf2_member t0 LEFT JOIN caf2_admin_user t35 ON t35.member_id = t0.id INNER JOIN caf2_article_comment_like ON t0.id = caf2_article_comment_like.member_id WHERE caf2_article_comment_like.article_comment_id = ?
Parameters:
[
7
]
|
|
0.42 ms (5.04%) |
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.35 ms (4.29%) |
1 |
UPDATE article SET views = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "2025-12-12 10:28:05" 14 ] |
|
0.26 ms (3.12%) |
1 |
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.article_id AS article_id_4, t0.author_id AS author_id_5 FROM article_comment t0 WHERE t0.article_id = ?
Parameters:
[
14
]
|
|
0.25 ms (3.03%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.16 ms (1.89%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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 | 8 |
| App\Entity\Member | 6 |
| App\Entity\AdminUser | 5 |
| App\Entity\Article | 4 |
| App\Entity\BaseProgram | 3 |
| App\Entity\Supervisor | 3 |
| App\Entity\Activity | 2 |
| App\Entity\Section | 2 |
| App\Entity\Localisation | 2 |
| App\Entity\ActivityLevel | 2 |
| App\Entity\ArticleCategory | 2 |
| App\Entity\ArticleComment | 1 |
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. |
| App\Entity\MonetaryAccountTransaction | No errors. |
| App\Entity\PhotoAlbum | No errors. |
| App\Entity\MemberDVATraining | No errors. |
| App\Entity\MailerEmail | No errors. |
refuge entity manager
No loaded entities.