Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2661.32 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2661.32 ms
(100.00%)

SELECT DISTINCT
 'AGREEMENT' LIST_TYPE,
 H.AGREEMENT_ID AGREEMENT_ID,
 C2.DECODE_VALUE STATUS,
 TO_CHAR(H.LAST_UPDATE_DATE, 'YYYYMMDD') LAST_UPDATE_DATE,
 TO_CHAR(H.LAST_UPDATE_DATE, 'Mon DD, YYYY') FORMATTED_LAST_UPDATE_DATE,
 '' LAND_SYSTEM_ID,
 '' LAND_SYSTEM_STATUS,
 TO_CHAR(MAX(DN.DEFAULT_NOTICE_DATE), 'YYYYMMDD') LAST_DEFAULT_NOTICE_DATE,
 TO_CHAR(MAX(DN.DEFAULT_NOTICE_DATE), 'Mon DD, YYYY') FORMATTED_LAST_DEFAULT_NOTICE_DATE,
 CD.AMI_CURRENT_DATE
 FROM
 ONE_ENERGY.AMI_AGREEMENTS_HEADER H,
 ONE_ENERGY.AMI_AGREEMENTS_DESIGNATED_REPRESENTATIVE DREP,
 ONE_ENERGY.AMI_AGREEMENTS_PARTICIPANTS PAR,
 ONE_ENERGY.AMI_AGREEMENTS_DEFAULT_NOTICE DN,
 ONE_ENERGY.AMI_AGREEMENTS_LAND_ATTRIBUTES L,
 ONE_ENERGY.AMI_CODETABLES_TABLE_RECORDS C1,
 ONE_ENERGY.AMI_CODETABLES_TABLE_RECORDS C2,
 ONE_ENERGY.AMI_CURRENT_DATE CD,
 ONE_ENERGY.AMI_CLIENTUPDATES_RELATED_MINERAL_CLIENTS CL1
 WHERE
 DREP.AGREEMENT_ID (+) = H.AGREEMENT_ID
 AND PAR.AGREEMENT_ID (+) = H.AGREEMENT_ID
 AND DN.AGREEMENT_ID (+) = H.AGREEMENT_ID
 AND L.AGREEMENT_ID (+) = H.AGREEMENT_ID
 AND CL1.CLIENT_ID (+) = DREP.CLIENT_ID
 AND CL1.ADDRESS_ID (+) = DREP.ADDRESS_ID
 AND C1.CODE (+) = H.AGREEMENT_TYPE_CODE
 AND C1.CODE_TABLE_NAME (+) = 'AGRTYPE'
 AND C2.CODE (+) = H.AGREEMENT_STATUS_CODE
 AND C2.CODE_TABLE_NAME (+) = 'ENSTATS'
 GROUP BY 
 H.AGREEMENT_ID,
 H.LAST_UPDATE_DATE,
 H.AGREEMENT_TYPE_CODE,
 DREP.CLIENT_ID,
 CL1.NAME,
 CD.AMI_CURRENT_DATE,
 C1.DECODE_VALUE,
 C2.DECODE_VALUE
 ORDER BY 
 AGREEMENT_ID
OFFSET :cr ROWS FETCH NEXT :rl ROWS ONLY

Parameters:

[
  "cr" => 0
  "rl" => 30
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT 'AGREEMENT' LIST_TYPE,
  H.AGREEMENT_ID AGREEMENT_ID,
  C2.DECODE_VALUE STATUS,
  TO_CHAR(H.LAST_UPDATE_DATE, 'YYYYMMDD') LAST_UPDATE_DATE,
  TO_CHAR(
    H.LAST_UPDATE_DATE, 'Mon DD, YYYY'
  ) FORMATTED_LAST_UPDATE_DATE,
  '' LAND_SYSTEM_ID,
  '' LAND_SYSTEM_STATUS,
  TO_CHAR(
    MAX(DN.DEFAULT_NOTICE_DATE),
    'YYYYMMDD'
  ) LAST_DEFAULT_NOTICE_DATE,
  TO_CHAR(
    MAX(DN.DEFAULT_NOTICE_DATE),
    'Mon DD, YYYY'
  ) FORMATTED_LAST_DEFAULT_NOTICE_DATE,
  CD.AMI_CURRENT_DATE
FROM
  ONE_ENERGY.AMI_AGREEMENTS_HEADER H,
  ONE_ENERGY.AMI_AGREEMENTS_DESIGNATED_REPRESENTATIVE DREP,
  ONE_ENERGY.AMI_AGREEMENTS_PARTICIPANTS PAR,
  ONE_ENERGY.AMI_AGREEMENTS_DEFAULT_NOTICE DN,
  ONE_ENERGY.AMI_AGREEMENTS_LAND_ATTRIBUTES L,
  ONE_ENERGY.AMI_CODETABLES_TABLE_RECORDS C1,
  ONE_ENERGY.AMI_CODETABLES_TABLE_RECORDS C2,
  ONE_ENERGY.AMI_CURRENT_DATE CD,
  ONE_ENERGY.AMI_CLIENTUPDATES_RELATED_MINERAL_CLIENTS CL1
WHERE
  DREP.AGREEMENT_ID (+) = H.AGREEMENT_ID
  AND PAR.AGREEMENT_ID (+) = H.AGREEMENT_ID
  AND DN.AGREEMENT_ID (+) = H.AGREEMENT_ID
  AND L.AGREEMENT_ID (+) = H.AGREEMENT_ID
  AND CL1.CLIENT_ID (+) = DREP.CLIENT_ID
  AND CL1.ADDRESS_ID (+) = DREP.ADDRESS_ID
  AND C1.CODE (+) = H.AGREEMENT_TYPE_CODE
  AND C1.CODE_TABLE_NAME (+) = 'AGRTYPE'
  AND C2.CODE (+) = H.AGREEMENT_STATUS_CODE
  AND C2.CODE_TABLE_NAME (+) = 'ENSTATS'
GROUP BY
  H.AGREEMENT_ID,
  H.LAST_UPDATE_DATE,
  H.AGREEMENT_TYPE_CODE,
  DREP.CLIENT_ID,
  CL1.NAME,
  CD.AMI_CURRENT_DATE,
  C1.DECODE_VALUE,
  C2.DECODE_VALUE
ORDER BY
  AGREEMENT_ID
OFFSET
  :cr
ROWS
FETCH
  NEXT :rl
ROWS
  ONLY

SELECT DISTINCT
 'AGREEMENT' LIST_TYPE,
 H.AGREEMENT_ID AGREEMENT_ID,
 C2.DECODE_VALUE STATUS,
 TO_CHAR(H.LAST_UPDATE_DATE, 'YYYYMMDD') LAST_UPDATE_DATE,
 TO_CHAR(H.LAST_UPDATE_DATE, 'Mon DD, YYYY') FORMATTED_LAST_UPDATE_DATE,
 '' LAND_SYSTEM_ID,
 '' LAND_SYSTEM_STATUS,
 TO_CHAR(MAX(DN.DEFAULT_NOTICE_DATE), 'YYYYMMDD') LAST_DEFAULT_NOTICE_DATE,
 TO_CHAR(MAX(DN.DEFAULT_NOTICE_DATE), 'Mon DD, YYYY') FORMATTED_LAST_DEFAULT_NOTICE_DATE,
 CD.AMI_CURRENT_DATE
 FROM
 ONE_ENERGY.AMI_AGREEMENTS_HEADER H,
 ONE_ENERGY.AMI_AGREEMENTS_DESIGNATED_REPRESENTATIVE DREP,
 ONE_ENERGY.AMI_AGREEMENTS_PARTICIPANTS PAR,
 ONE_ENERGY.AMI_AGREEMENTS_DEFAULT_NOTICE DN,
 ONE_ENERGY.AMI_AGREEMENTS_LAND_ATTRIBUTES L,
 ONE_ENERGY.AMI_CODETABLES_TABLE_RECORDS C1,
 ONE_ENERGY.AMI_CODETABLES_TABLE_RECORDS C2,
 ONE_ENERGY.AMI_CURRENT_DATE CD,
 ONE_ENERGY.AMI_CLIENTUPDATES_RELATED_MINERAL_CLIENTS CL1
 WHERE
 DREP.AGREEMENT_ID (+) = H.AGREEMENT_ID
 AND PAR.AGREEMENT_ID (+) = H.AGREEMENT_ID
 AND DN.AGREEMENT_ID (+) = H.AGREEMENT_ID
 AND L.AGREEMENT_ID (+) = H.AGREEMENT_ID
 AND CL1.CLIENT_ID (+) = DREP.CLIENT_ID
 AND CL1.ADDRESS_ID (+) = DREP.ADDRESS_ID
 AND C1.CODE (+) = H.AGREEMENT_TYPE_CODE
 AND C1.CODE_TABLE_NAME (+) = 'AGRTYPE'
 AND C2.CODE (+) = H.AGREEMENT_STATUS_CODE
 AND C2.CODE_TABLE_NAME (+) = 'ENSTATS'
 GROUP BY 
 H.AGREEMENT_ID,
 H.LAST_UPDATE_DATE,
 H.AGREEMENT_TYPE_CODE,
 DREP.CLIENT_ID,
 CL1.NAME,
 CD.AMI_CURRENT_DATE,
 C1.DECODE_VALUE,
 C2.DECODE_VALUE
 ORDER BY 
 AGREEMENT_ID
OFFSET 0 ROWS FETCH NEXT 30 ROWS ONLY;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 354)
3	App\Repository\ReportRepository->agreementQuery (line 32)
4	App\Controller\ReportController->index (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

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\Report	No errors.

Symfony Profiler

GET https://cardtradeshop.com/reports

Configuration Settings

Theme