Query Metrics
9
Database Queries
6
Different statements
10.23 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.40 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.45 ms |
"START TRANSACTION"
Parameters:
[] |
3 | 0.78 ms |
UPDATE xero_storage SET access_token = ?, expires = ?, refresh_token = ?, id_token = ? WHERE id = ?
Parameters:
[ "eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NTI3NjU1ODIsImV4cCI6MTc1Mjc2NzM4MiwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiOTQ5NjRGMDI5MDkxNDI0NUI1OTdDNkFDNEQ0MTU4MDIiLCJzdWIiOiIyYjZhN2M2YjJlZTE1M2Y1YTA0ODdkMGNmOGJjM2VlOSIsImF1dGhfdGltZSI6MTY5MTk5MjU5NywieGVyb191c2VyaWQiOiJhYjg4ZTU1My0yNDZlLTQ4ZDMtOTJkYy0wYTFmNmVmMzkxY2UiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6IjY3NjYxMWEwZDM5MDRhZGVhMmIzMmVmNTA0ODU4YWExIiwic2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJqdGkiOiIwMzA2RDFBMkQ4QUY3Qzc3OThGNEI1REQxRjlCOTZBOCIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiYzk3YTI4ZTktNDU4YS00MzZjLWJkZTMtZDZjZWExNWI0ZDJmIiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5yZXBvcnRzLnJlYWQiLCJhY2NvdW50aW5nLnNldHRpbmdzIiwiYWNjb3VudGluZy5hdHRhY2htZW50cyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5qb3VybmFscy5yZWFkIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.SjNfORnkslMhCXIu_UMJ-86m3J7bmn4AftinSIoz7YCt5GrruKDqR2LAsROnQsuCKTSvIhCPpGbOHYh04j8pcXKZjpsC_PTd8XeKXbmxAcozRX7N9uyvmJq-bqKAougJhUjlGM11wyqA19mOEEuUIeIrNu4zU1I6NlQHRMmaqpevJrlUjVSssv-xePvawrMlmt9HIRxfdr-bj7JTyzpp37myqtFjvkf_SIoevfcdvCGVpyhkPk5ZEDYaT7f-seTJzudls8y9kjwyJF_GupczAghiWhHfEy-Zmjiar-hDJG63r_fbUpieeXwb7-Vync4JpTmccK857T2bqnQpeBEflw" "1752767382" "_-_Etgd9PfNiREBGxf8i8L-fAHBV4WiDoGcoN36KKow" "eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NTI3NjU1ODIsImV4cCI6MTc1Mjc2NTg4MiwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Ijk0OTY0RjAyOTA5MTQyNDVCNTk3QzZBQzRENDE1ODAyIiwiaWF0IjoxNzUyNzY1NTgyLCJhdF9oYXNoIjoiLTRYb05MS0hLYWxmd1hDVnNwWFo0QSIsInN1YiI6IjJiNmE3YzZiMmVlMTUzZjVhMDQ4N2QwY2Y4YmMzZWU5IiwiYXV0aF90aW1lIjoxNjkxOTkyNTk3LCJ4ZXJvX3VzZXJpZCI6ImFiODhlNTUzLTI0NmUtNDhkMy05MmRjLTBhMWY2ZWYzOTFjZSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJzaWQiOiI2NzY2MTFhMGQzOTA0YWRlYTJiMzJlZjUwNDg1OGFhMSIsInByZWZlcnJlZF91c2VybmFtZSI6ImtldmluQHdoaXRldG93ZXIuY29tLmF1IiwiZW1haWwiOiJrZXZpbkB3aGl0ZXRvd2VyLmNvbS5hdSIsImdpdmVuX25hbWUiOiJLZXZpbiIsImZhbWlseV9uYW1lIjoiS2V2aW4iLCJuYW1lIjoiS2V2aW4gS2V2aW4iLCJhbXIiOlsicHdkIl19.oM_gSJwNt17OuHCvmBC8skJfrB406Po0q_7p_HZML5HYhfrlg0_0orGUIkoDIbKWkEFawKSzLMK-veH1HVAfz3wGGxvhilXfQ7mlt5OT7h7-_-SKk-80ohcWVTMxMmB5_x_BgLaKEadhVSpDx1NTnJZjhZh8FWAGJfaaWaJdi0e7Ecj3PGp5OAwVSISLpu3zvBiyv3VUeekx-4smWulcM_pc4ZtzELr2aTFX5A8Jx8um4wQT0rEfp8-58thsJDF90zlQuCbcZdJJeVjF5deOIybqQYddmwY1-KIRvk3B5IaUQgsSND_iz1yUPFJPlNZAjpf0mP7nVvWFweSojD3aQw" 1 ] |
4 | 1.52 ms |
"COMMIT"
Parameters:
[] |
5 | 0.37 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.74 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.51 ms |
SELECT DATABASE()
Parameters:
[] |
8 | 3.14 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.32 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. |