Query Metrics
9
Database Queries
6
Different statements
9.67 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.80 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.35 ms |
"START TRANSACTION"
Parameters:
[] |
3 | 0.92 ms |
UPDATE xero_storage SET access_token = ?, expires = ?, refresh_token = ?, id_token = ? WHERE id = ?
Parameters:
[ "eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NTIxMzU5MTEsImV4cCI6MTc1MjEzNzcxMSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiOTQ5NjRGMDI5MDkxNDI0NUI1OTdDNkFDNEQ0MTU4MDIiLCJzdWIiOiIyYjZhN2M2YjJlZTE1M2Y1YTA0ODdkMGNmOGJjM2VlOSIsImF1dGhfdGltZSI6MTY5MTk5MjU5NywieGVyb191c2VyaWQiOiJhYjg4ZTU1My0yNDZlLTQ4ZDMtOTJkYy0wYTFmNmVmMzkxY2UiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6IjY3NjYxMWEwZDM5MDRhZGVhMmIzMmVmNTA0ODU4YWExIiwic2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJqdGkiOiIwMzA2RDFBMkQ4QUY3Qzc3OThGNEI1REQxRjlCOTZBOCIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiYzk3YTI4ZTktNDU4YS00MzZjLWJkZTMtZDZjZWExNWI0ZDJmIiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5yZXBvcnRzLnJlYWQiLCJhY2NvdW50aW5nLnNldHRpbmdzIiwiYWNjb3VudGluZy5hdHRhY2htZW50cyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5qb3VybmFscy5yZWFkIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.gchBskC4nop-MSGNLz-P72BhsMDFVviVyZwOyKlO0X_gxYraprvWmtZWyjPrMv6Mu0EDan8Qu-GAOcmlLjM4riu6s-reGKtqWhPZ4VN4nuUAAdAjPuw8UDmOkyfG53nWnso1sKqlxX3D2JXzNMKHRR6lE20TIzT1_2VxU8-YDT5H4BiQiRIjx4_DqLCoUs47JRKZyte4XbpZt0VZUBnXfnRACu8cpVPM8SK4c_90XQWZY8Enwmrw_bwFAYrYUgO1TDpsCNC9S3BucT2UR7OlijnAKRRq6fvI4jGGrIFuN1vnWCloLF9gv6dXuhuTDoKRG5uq5KrefkpkaxNGCVHnyQ" "1752137711" "57_9n3T3WsXEiH9xhTeYirSt7OrT8AIzyVBMWBjDxDc" "eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NTIxMzU5MTEsImV4cCI6MTc1MjEzNjIxMSwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Ijk0OTY0RjAyOTA5MTQyNDVCNTk3QzZBQzRENDE1ODAyIiwiaWF0IjoxNzUyMTM1OTExLCJhdF9oYXNoIjoiRUpmWW9RNGVpMnM1ZTEzS2c0U0ZHQSIsInN1YiI6IjJiNmE3YzZiMmVlMTUzZjVhMDQ4N2QwY2Y4YmMzZWU5IiwiYXV0aF90aW1lIjoxNjkxOTkyNTk3LCJ4ZXJvX3VzZXJpZCI6ImFiODhlNTUzLTI0NmUtNDhkMy05MmRjLTBhMWY2ZWYzOTFjZSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJzaWQiOiI2NzY2MTFhMGQzOTA0YWRlYTJiMzJlZjUwNDg1OGFhMSIsInByZWZlcnJlZF91c2VybmFtZSI6ImtldmluQHdoaXRldG93ZXIuY29tLmF1IiwiZW1haWwiOiJrZXZpbkB3aGl0ZXRvd2VyLmNvbS5hdSIsImdpdmVuX25hbWUiOiJLZXZpbiIsImZhbWlseV9uYW1lIjoiS2V2aW4iLCJuYW1lIjoiS2V2aW4gS2V2aW4iLCJhbXIiOlsicHdkIl19.BKKlfRR1CigfhahLHBxP92-nPpJViKsIzDDifj4Xf2yII0N7CtOnGoIN9A5shAV4AAnGC8zPaId1Wqw8eNIccS1W-pW6nTk9Sezt3gEUE_Z6IBrrzGTekg0BecF3mld9X2ugh5OfTOpXjOHn4UbEJ4u2ycv2UxqLJ_Ltnhklfosj8sq_8S8A005QF61j5Uzc4PRw706Npum9sABFRhaLafQFU-JCyT8d28lE2p80zv-y78--ST_6xA4_lONwIFXvqI4ztCJ3grGNBnunG4U0H9A4WeD4DF76AHlbyd8Ax5GXG_bYDdOWwps28Y8lwDdTbotZDTH7Dk6HzxgpJptMhg" 1 ] |
4 | 1.63 ms |
"COMMIT"
Parameters:
[] |
5 | 0.42 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.90 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.55 ms |
SELECT DATABASE()
Parameters:
[] |
8 | 3.70 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.41 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. |