Query Metrics
9
Database Queries
6
Different statements
7.61 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.60 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 | 0.87 ms |
UPDATE xero_storage SET access_token = ?, expires = ?, refresh_token = ?, id_token = ? WHERE id = ?
Parameters:
[ "eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NTE5NzcyNTMsImV4cCI6MTc1MTk3OTA1MywiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiOTQ5NjRGMDI5MDkxNDI0NUI1OTdDNkFDNEQ0MTU4MDIiLCJzdWIiOiIyYjZhN2M2YjJlZTE1M2Y1YTA0ODdkMGNmOGJjM2VlOSIsImF1dGhfdGltZSI6MTY5MTk5MjU5NywieGVyb191c2VyaWQiOiJhYjg4ZTU1My0yNDZlLTQ4ZDMtOTJkYy0wYTFmNmVmMzkxY2UiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6IjY3NjYxMWEwZDM5MDRhZGVhMmIzMmVmNTA0ODU4YWExIiwic2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJqdGkiOiIwMzA2RDFBMkQ4QUY3Qzc3OThGNEI1REQxRjlCOTZBOCIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiYzk3YTI4ZTktNDU4YS00MzZjLWJkZTMtZDZjZWExNWI0ZDJmIiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5yZXBvcnRzLnJlYWQiLCJhY2NvdW50aW5nLnNldHRpbmdzIiwiYWNjb3VudGluZy5hdHRhY2htZW50cyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5qb3VybmFscy5yZWFkIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.fMK67AsLksf2IPs-vVFICxpPDKdXsumBK5-w4m32z93RKFKBPEHB08zzUYHW9Dyj9C6MOhY8241eFHLEW12Vqx6CGqlHsPeR0J2kxPC1Pfxly7rbRMhe73hjyZUj5LMQs36mrVXqQ95EGooKC6FujZi0n0IK-i4bM8aia11B75y700iALFLJ1OutDuW7uul3ueMt33i5uMc9vzUJ-4kWHRA7hAxdldckMAz2xQRPEN-jlMyx64WCc8no_bWuN6dzKchW6gM7mK0e3Z3M6Ms9HrZRxmQ4vR04PeWXPreNxyQImeEQ04v-FU4cUBLDJkbYwYYyv4xjK_RJq8L59v7Vbw" "1751979053" "WCr6BUMwXRAGIHYMNMbTt0rqmPd9yVqcrgI2LS9V6Mk" "eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NTE5NzcyNTMsImV4cCI6MTc1MTk3NzU1MywiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Ijk0OTY0RjAyOTA5MTQyNDVCNTk3QzZBQzRENDE1ODAyIiwiaWF0IjoxNzUxOTc3MjUzLCJhdF9oYXNoIjoiWW9CendhOGVWaUNONGNrSmJ0VWprQSIsInN1YiI6IjJiNmE3YzZiMmVlMTUzZjVhMDQ4N2QwY2Y4YmMzZWU5IiwiYXV0aF90aW1lIjoxNjkxOTkyNTk3LCJ4ZXJvX3VzZXJpZCI6ImFiODhlNTUzLTI0NmUtNDhkMy05MmRjLTBhMWY2ZWYzOTFjZSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJzaWQiOiI2NzY2MTFhMGQzOTA0YWRlYTJiMzJlZjUwNDg1OGFhMSIsInByZWZlcnJlZF91c2VybmFtZSI6ImtldmluQHdoaXRldG93ZXIuY29tLmF1IiwiZW1haWwiOiJrZXZpbkB3aGl0ZXRvd2VyLmNvbS5hdSIsImdpdmVuX25hbWUiOiJLZXZpbiIsImZhbWlseV9uYW1lIjoiS2V2aW4iLCJuYW1lIjoiS2V2aW4gS2V2aW4iLCJhbXIiOlsicHdkIl19.ALn-aqvM4ZEC650U_GeltgrRj2jT9uShyCuXLH_bjkwMCmu7YCXlBxoFLK9MX9yztOdWlyiL6fkt3w_qXaJAsJ2sxFj2YFIIKMmCnCvj7dnD6KzT9AtLnFw4mOmv9TEajf1ifNuHtOr63Gwuwegu8JB9gj4CYfaaDvla4ltEZd_9xnLnmE5oHTznUL5SmmNrXDBoYCds2GpE3Z0hFivdAyp7LbnLCVELaYOucb-HJGvfIU4Rp2FdbPJIPa2lYnWRd69FlphtKHfV_RZAbr_kTPUtMa15I7cVkGQS4oXG217L7LzhirXp3pD-CDr2rd5uGeYWu_OmafYUlz0VFXN_vA" 1 ] |
4 | 1.53 ms |
"COMMIT"
Parameters:
[] |
5 | 0.52 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.59 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 | 0.38 ms |
SELECT DATABASE()
Parameters:
[] |
8 | 2.63 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"daf_portal_staging"
]
|
9 | 0.22 ms |
SELECT DATABASE()
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\User | No errors. |
App\Entity\UserBilling | No errors. |
App\Entity\EmailTemplate | No errors. |
App\Entity\XeroStorage | No errors. |
App\Entity\FilmProjectMember |
|
App\Entity\FilmProjectProgressReport | No errors. |
App\Entity\UserProfile | No errors. |
App\Entity\UserAddress | No errors. |
App\Entity\UserInformation | No errors. |
App\Entity\OrderDetails |
|
App\Entity\FilmProject | No errors. |
App\Entity\UserCategory | No errors. |
App\Entity\ProjectNotification | No errors. |
App\Entity\FilmProjectProgressReportFile | No errors. |
App\Entity\FilmProjectUpdate | No errors. |
App\Entity\OrderItems | No errors. |
App\Entity\OrderBillingDetails | No errors. |
App\Entity\PaymentDetails | No errors. |
App\Entity\Donation | No errors. |
App\Entity\FilmProjectDetails | No errors. |
App\Entity\FilmProjectStoryImpact | No errors. |
App\Entity\FilmProjectTimeline | No errors. |
App\Entity\FilmProjectFunding | No errors. |
App\Entity\Product | No errors. |
App\Entity\FilmProjectOriginal | No errors. |
App\Entity\FilmProjectImage | No errors. |
App\Entity\FilmProjectSponsor | No errors. |
App\Entity\FilmProjectChangeHistory | No errors. |
App\Entity\ProjectUpdateTypeNomination | No errors. |
App\Entity\ProductPercentageSplit | No errors. |
App\Entity\Event | No errors. |
App\Entity\XeroTrackingOption | No errors. |
App\Entity\XeroTrackingCategory | No errors. |
App\Entity\Setting | No errors. |
App\Entity\ResetPasswordRequest | No errors. |
App\Entity\RecurringDonation | No errors. |
App\Entity\XeroBrandingThemes | No errors. |
App\Entity\IssueTopic | No errors. |
App\Entity\IssueArea | No errors. |
Vich\UploaderBundle\Entity\File | No errors. |