Query Metrics
2
Database Queries
2
Different statements
1.50 ms
Query time
0
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.76 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.is_enabled AS is_enabled_4, t0.config AS config_5, t0.currency AS currency_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.church_id AS church_id_9 FROM institution t0 WHERE t0.type = ? AND t0.name = ? LIMIT 1
Parameters:
[ "integrator" "YengaPay" ]
|
||||||||||||||||||||||
| 2 | 0.75 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.display_code AS display_code_3, t0.status AS status_4, t0.type AS type_5, t0.mode AS mode_6, t0.amount AS amount_7, t0.gateway_response AS gateway_response_8, t0.transaction_token AS transaction_token_9, t0.checkout_url AS checkout_url_10, t0.external_id AS external_id_11, t0.currency AS currency_12, t0.payment_fees AS payment_fees_13, t0.base_amount AS base_amount_14, t0.payment_source AS payment_source_15, t0.customer_number AS customer_number_16, t0.contry_origin AS contry_origin_17, t0.payment_source_transaction_id AS payment_source_transaction_id_18, t0.payment_intent_id AS payment_intent_id_19, t0.is_compensated AS is_compensated_20, t0.compensated_at AS compensated_at_21, t0.receiver_balance_before AS receiver_balance_before_22, t0.receiver_balance_after AS receiver_balance_after_23, t0.receiver_fees_balance_before AS receiver_fees_balance_before_24, t0.receiver_fees_balance_after AS receiver_fees_balance_after_25, t0.collection_mode AS collection_mode_26, t0.service_type AS service_type_27, t0.fee_amount AS fee_amount_28, t0.request_count AS request_count_29, t0.partner_commission_amount AS partner_commission_amount_30, t0.receipt_number AS receipt_number_31, t0.confirmed_at AS confirmed_at_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.channel_id AS channel_id_35, t0.confirmed_by_id AS confirmed_by_id_36, t0.mass_id AS mass_id_37, t0.institution_id AS institution_id_38, t0.integrator_id AS integrator_id_39 FROM payment t0 WHERE t0.reference = ? LIMIT 1
Parameters:
[
"AOUAG-PCRPI-MASS-202609281125-E472"
]
|
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\Institution | 2 |
| App\Entity\Payment | 1 |
| App\Entity\PaymentChannel | 1 |
| App\Entity\Mass | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Church | No errors. |
| App\Entity\Institution | No errors. |
| App\Entity\Wallet | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\CommissionRate | No errors. |
| App\Entity\PaymentChannel | No errors. |
| App\Entity\FeePolicy | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Mass | No errors. |
| App\Entity\ChurchCategory | No errors. |
| App\Entity\MassPrice | No errors. |
| App\Entity\ChurchFeature | No errors. |
| App\Entity\MassSchedule | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Announcement\Announcement | No errors. |
| App\Entity\UserFavoriteChurch | No errors. |
| App\Entity\UserNotification | No errors. |
| App\Entity\Accounting\FinancialOperation | No errors. |
| App\Entity\FeeTier | No errors. |
| App\Entity\UserSession | No errors. |
| App\Entity\NotificationPush | No errors. |
| App\Entity\Announcement\AnnouncementRead | No errors. |
| App\Entity\MassIntentionReview | No errors. |
| App\Entity\MassCategory | No errors. |
| App\Entity\MassRequest | No errors. |