Query Metrics
9
Database Queries
6
Different statements
10.04 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.24 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.60 ms |
"START TRANSACTION"
Parameters:
[] |
3 | 0.82 ms |
UPDATE xero_storage SET access_token = ?, expires = ?, refresh_token = ?, id_token = ? WHERE id = ?
Parameters:
[ "eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NTI0MTYzNDEsImV4cCI6MTc1MjQxODE0MSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiOTQ5NjRGMDI5MDkxNDI0NUI1OTdDNkFDNEQ0MTU4MDIiLCJzdWIiOiIyYjZhN2M2YjJlZTE1M2Y1YTA0ODdkMGNmOGJjM2VlOSIsImF1dGhfdGltZSI6MTY5MTk5MjU5NywieGVyb191c2VyaWQiOiJhYjg4ZTU1My0yNDZlLTQ4ZDMtOTJkYy0wYTFmNmVmMzkxY2UiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6IjY3NjYxMWEwZDM5MDRhZGVhMmIzMmVmNTA0ODU4YWExIiwic2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJqdGkiOiIwMzA2RDFBMkQ4QUY3Qzc3OThGNEI1REQxRjlCOTZBOCIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiYzk3YTI4ZTktNDU4YS00MzZjLWJkZTMtZDZjZWExNWI0ZDJmIiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5yZXBvcnRzLnJlYWQiLCJhY2NvdW50aW5nLnNldHRpbmdzIiwiYWNjb3VudGluZy5hdHRhY2htZW50cyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5qb3VybmFscy5yZWFkIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.LhWoKFMNz3B8POhuatmppoY2LaUUcoCFsIeCKqqdGnCgupndC4MNKrcFXJX7RyAh69SwDdl64GXXr-t6z_OHLXkNHOIcnrwGPz8LDXi1Qq-yvBVUVbVKDadNJwAtnyFplSJAlwPfc-aaV6StEa0pcN4BW1fKeGzNtsjgYi23Dpxs6-r2NmulJc96VYuuDvNPegDzElIV3vYgfOg20kb6x_bFSkIrj70vcrWvN3cWjTTGlYTFY9XBPpdgsgk4rojP6rIzyU2iI4CIQHWrpaKrTi7Sa96_UwAm9YFaLC3AI4hwanRJU4DqpSnaaEblknIWIUplubYb1lUIaoTqo0-mIQ" "1752418141" "OwraJGGcNKJ4iS8YUGeG5sYP8llkFhudZ-C-OhHj1Do" "eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NTI0MTYzNDEsImV4cCI6MTc1MjQxNjY0MSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Ijk0OTY0RjAyOTA5MTQyNDVCNTk3QzZBQzRENDE1ODAyIiwiaWF0IjoxNzUyNDE2MzQxLCJhdF9oYXNoIjoibENoa3VZT0lKMm41WE01TFFGRWFkZyIsInN1YiI6IjJiNmE3YzZiMmVlMTUzZjVhMDQ4N2QwY2Y4YmMzZWU5IiwiYXV0aF90aW1lIjoxNjkxOTkyNTk3LCJ4ZXJvX3VzZXJpZCI6ImFiODhlNTUzLTI0NmUtNDhkMy05MmRjLTBhMWY2ZWYzOTFjZSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJzaWQiOiI2NzY2MTFhMGQzOTA0YWRlYTJiMzJlZjUwNDg1OGFhMSIsInByZWZlcnJlZF91c2VybmFtZSI6ImtldmluQHdoaXRldG93ZXIuY29tLmF1IiwiZW1haWwiOiJrZXZpbkB3aGl0ZXRvd2VyLmNvbS5hdSIsImdpdmVuX25hbWUiOiJLZXZpbiIsImZhbWlseV9uYW1lIjoiS2V2aW4iLCJuYW1lIjoiS2V2aW4gS2V2aW4iLCJhbXIiOlsicHdkIl19.PZh72bVSPx9nZmGEbeUndPo3rwdx7iGz6Iih_10BWRlhRn0yDVjl8sEZvb8mpqIA2ii7E5a-GC0C_lQrnBXB0k_xBCUGDpK1TpRGfq_RGlcP-CidJLKX7MCmbiYvdkJ0hwgHsmqN3nh4MQQLg-6Nsww9EnX7k7yBtSrCdOTM6243ncas7i-bZ3odjPRMhdNzLS58iKVht4JJcjsitiBuiNbGFQUnThPJVnw6HlK92WVQDkyC86VjoykBmol5DRQA3n1W7UJMM0yxbw3MLme_rSj4QRN8TkuPWOIwFgCm7WiU9gkRjKgNRq1qS6IyOmqtsqpgpX0rIaCAOfgEy_Ye5w" 1 ] |
4 | 2.64 ms |
"COMMIT"
Parameters:
[] |
5 | 0.89 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.41 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.56 ms |
SELECT DATABASE()
Parameters:
[] |
8 | 2.61 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.27 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. |