https://daf-middleware.wtdevsite.com/donation/recurring-payment

Query Metrics

7 Database Queries
5 Different statements
18.45 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.45 ms
(45.83%)
3
SELECT t0.id AS id_1, t0.access_token AS access_token_2, t0.expires AS expires_3, t0.tenant_id AS tenant_id_4, t0.refresh_token AS refresh_token_5, t0.id_token AS id_token_6, t0.tag AS tag_7 FROM xero_storage t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
  "primary"
]
6.99 ms
(37.91%)
1
SELECT r0_.id AS id_0, r0_.frequency AS frequency_1, r0_.next_payment_date AS next_payment_date_2, r0_.current_payment_count AS current_payment_count_3, r0_.total_payment_count AS total_payment_count_4, r0_.card_id AS card_id_5, r0_.is_cancel AS is_cancel_6, r0_.start_payment_date AS start_payment_date_7 FROM recurring_donation r0_ WHERE r0_.current_payment_count < r0_.total_payment_count AND r0_.next_payment_date = ? AND r0_.is_cancel IS NULL ORDER BY r0_.id ASC
Parameters:
[
  "2025-10-02 00:00:00"
]
1.46 ms
(7.90%)
1
"COMMIT"
Parameters:
[]
1.27 ms
(6.86%)
1
UPDATE xero_storage SET access_token = ?, expires = ?, refresh_token = ?, id_token = ? WHERE id = ?
Parameters:
[
  "eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NTkzNTg1NjAsImV4cCI6MTc1OTM2MDM2MCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiOTQ5NjRGMDI5MDkxNDI0NUI1OTdDNkFDNEQ0MTU4MDIiLCJzdWIiOiIyYjZhN2M2YjJlZTE1M2Y1YTA0ODdkMGNmOGJjM2VlOSIsImF1dGhfdGltZSI6MTY5MTk5MjU5NywieGVyb191c2VyaWQiOiJhYjg4ZTU1My0yNDZlLTQ4ZDMtOTJkYy0wYTFmNmVmMzkxY2UiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6IjY3NjYxMWEwZDM5MDRhZGVhMmIzMmVmNTA0ODU4YWExIiwic2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJqdGkiOiIwMzA2RDFBMkQ4QUY3Qzc3OThGNEI1REQxRjlCOTZBOCIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiYzk3YTI4ZTktNDU4YS00MzZjLWJkZTMtZDZjZWExNWI0ZDJmIiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5yZXBvcnRzLnJlYWQiLCJhY2NvdW50aW5nLnNldHRpbmdzIiwiYWNjb3VudGluZy5hdHRhY2htZW50cyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5qb3VybmFscy5yZWFkIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.KBNsbgEhxi9Va9yvkwJSQjlnFO8wR2ey61GbXNRK_XJJDIGzvLJ66ENV0QWjaN5BlDHAgMGPCjtl2jqI5SI_-Jk2MQbKwFSGwwtVrVn3B7euR5J34f3Qwfht6S1kmhSHAvfVqZzcoPx9ahAGwEL7yAu4eUm1Y34URRPhThEK6ZPaoy5POUqC_DnTNYiDQf_-_MwjYI-ImcKV6WGFf66TN5C4asoeOWaYSWXOgggDrQVWll8Jc3OXG9mjlGSd2vCYvlk2G5t5q00EVUDDmdEhYYEBXsPmmL6PIyylhL2Sz4F4nitgBS-KZ8LRszFF8uXqH9bvheNi4p-BNkKL0r8b5A"
  "1759360360"
  "wing5zMfKUKPxTeVyYmcTNlTAqHgaXKNdbylGN94JRY"
  "eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NTkzNTg1NjAsImV4cCI6MTc1OTM1ODg2MCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Ijk0OTY0RjAyOTA5MTQyNDVCNTk3QzZBQzRENDE1ODAyIiwiaWF0IjoxNzU5MzU4NTYwLCJhdF9oYXNoIjoieHlpQU03d2JKN0lUVDJNbzlYcDNHZyIsInN1YiI6IjJiNmE3YzZiMmVlMTUzZjVhMDQ4N2QwY2Y4YmMzZWU5IiwiYXV0aF90aW1lIjoxNjkxOTkyNTk3LCJ4ZXJvX3VzZXJpZCI6ImFiODhlNTUzLTI0NmUtNDhkMy05MmRjLTBhMWY2ZWYzOTFjZSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJzaWQiOiI2NzY2MTFhMGQzOTA0YWRlYTJiMzJlZjUwNDg1OGFhMSIsInByZWZlcnJlZF91c2VybmFtZSI6ImtldmluQHdoaXRldG93ZXIuY29tLmF1IiwiZW1haWwiOiJrZXZpbkB3aGl0ZXRvd2VyLmNvbS5hdSIsImdpdmVuX25hbWUiOiJLZXZpbiIsImZhbWlseV9uYW1lIjoiS2V2aW4iLCJuYW1lIjoiS2V2aW4gS2V2aW4iLCJhbXIiOlsicHdkIl19.kW5TiR7YTQFEd1SfCVNIfuscul6SLj0n9WUipYcFQYeBAsD_HkD7HnGuwvkJ4fgPZIe8PaV1voXq-MbJYGYcKsqsRLbhzcN19QGQf4s7ASnV0zKXWYlaWoIOgcjB7WPbcDELWTGc1ebT92pwg7y41ZmnzQj804Ry5PDz9U7gfjk0YYKT82ZgVI1lw5tnM974bt3NBV8yznIRWJGijObQCiP1eTrguBUcfan4ExfWnkOB7AkZmSonybxY3e2Ycp4pImz_-bcZr0h60VyXR1vbabsO1TgyMAtfHVqEQKJY-8ndnJ1SJszBSyXup8FoafYD0sPfwDyOIAWAvC3gy4Crfg"
  1
]
0.28 ms
(1.50%)
1
"START TRANSACTION"
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\XeroStorage No errors.
App\Entity\User No errors.
App\Entity\UserBilling No errors.
App\Entity\EmailTemplate No errors.
App\Entity\Donation No errors.
App\Entity\RecurringDonation No errors.