Query Metrics
1
Database Queries
1
Different statements
4.94 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4.94 ms (100.00%) |
1 |
SELECT p0_.ParticipantOrgId AS ParticipantOrgId_0, p0_.Name AS Name_1, p0_.Description AS Description_2, p0_.City AS City_3, p0_.state AS state_4, p0_.Adderess AS Adderess_5, p0_.ActiveOrNotActive AS ActiveOrNotActive_6, p0_.SfContactId AS SfContactId_7, p0_.CreatedDate AS CreatedDate_8, p0_.LastUpdatedDateTime AS LastUpdatedDateTime_9, p0_.SFLastUpdatedDateTime AS SFLastUpdatedDateTime_10, p0_.SFId AS SFId_11, p0_.FRPMPerc AS FRPMPerc_12, p0_.IncomeDemographic AS IncomeDemographic_13, p0_.RecruitmentStatus AS RecruitmentStatus_14, p0_.ZoneRegionMapId AS ZoneRegionMapId_15, p0_.ParticipantOrgTypeId AS ParticipantOrgTypeId_16 FROM ProgramParticipantOrg p1_ INNER JOIN ParticipantOrg p0_ ON (p0_.ParticipantOrgId = p1_.ParticipantOrgId) INNER JOIN MasterSettings m2_ ON (m2_.ProgramYear = p1_.ProgramYear) WHERE p0_.ParticipantOrgTypeId IN (1, 2) ORDER BY p0_.ParticipantOrgTypeId ASC, p0_.Name ASC
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\Programparticipantorg | No errors. |
App\Entity\Participantorg | No errors. |
App\Entity\Mastersettings | No errors. |
App\Entity\Zoneregionmap | No errors. |
App\Entity\Participantorgtype | No errors. |
App\Entity\Participant |
|