Symfony Profiler

• Request / Response
• Performance
• Exception 1
• Logs 1
• Events
• Routing
• Cache
• Twig
• Doctrine
• Debug
• Configuration

Query Metrics

SELECT PI_MESSAGE FROM PAGEINFO 
                                                WHERE 
                                                ((CURDATE() BETWEEN DATE(PI_FROM) AND DATE(PI_TO)) OR 
                                                (CURDATE() > DATE(PI_FROM) AND PI_TO IS NULL) OR 
                                                (CURDATE() < DATE(PI_FROM) AND PI_FROM IS NULL) OR 
                                                (PI_TO IS NULL AND PI_FROM IS NULL)) AND PI_ACTIVE = 1 AND (PI_URI = '*' OR PI_URI=:uri)

[
  "uri" => "/login"
]

SELECT
  PI_MESSAGE
FROM
  PAGEINFO
WHERE
  (
    (
      CURDATE() BETWEEN DATE(PI_FROM)
      AND DATE(PI_TO)
    )
    OR (
      CURDATE() > DATE(PI_FROM)
      AND PI_TO IS NULL
    )
    OR (
      CURDATE() < DATE(PI_FROM)
      AND PI_FROM IS NULL
    )
    OR (
      PI_TO IS NULL
      AND PI_FROM IS NULL
    )
  )
  AND PI_ACTIVE = 1
  AND (
    PI_URI = '*'
    OR PI_URI = :uri
  )

SELECT PI_MESSAGE FROM PAGEINFO 
                                                WHERE 
                                                ((CURDATE() BETWEEN DATE(PI_FROM) AND DATE(PI_TO)) OR 
                                                (CURDATE() > DATE(PI_FROM) AND PI_TO IS NULL) OR 
                                                (CURDATE() < DATE(PI_FROM) AND PI_FROM IS NULL) OR 
                                                (PI_TO IS NULL AND PI_FROM IS NULL)) AND PI_ACTIVE = 1 AND (PI_URI = '*' OR PI_URI='/login');

SELECT LINK_FROM, LINK_TO FROM HOPLINKS WHERE LINK_ACTIVE = 1

[]

SELECT
  LINK_FROM,
  LINK_TO
FROM
  HOPLINKS
WHERE
  LINK_ACTIVE = 1

SELECT LINK_FROM, LINK_TO FROM HOPLINKS WHERE LINK_ACTIVE = 1;

SELECT WP_ICON, WP_NAME, WP_LINK FROM WEBPAGES WHERE WP_FOOTER = 1 AND WP_ACTIVE = 1 ORDER BY WP_NAME

[]

SELECT
  WP_ICON,
  WP_NAME,
  WP_LINK
FROM
  WEBPAGES
WHERE
  WP_FOOTER = 1
  AND WP_ACTIVE = 1
ORDER BY
  WP_NAME

SELECT WP_ICON, WP_NAME, WP_LINK FROM WEBPAGES WHERE WP_FOOTER = 1 AND WP_ACTIVE = 1 ORDER BY WP_NAME;