Query Metrics
7
Database Queries
5
Different statements
18.45 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 7.22 ms |
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"
]
|
2 | 0.28 ms |
"START TRANSACTION"
Parameters:
[] |
3 | 1.27 ms |
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 ] |
4 | 1.46 ms |
"COMMIT"
Parameters:
[] |
5 | 0.61 ms |
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 | 0.62 ms |
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"
]
|
7 | 6.99 ms |
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"
]
|
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. |