Symfony Profiler

SELECT
  *
FROM
  CONTENT
  LEFT JOIN CONTENT_CATEGORIES ON CONTENT.CCAT_ID = CONTENT_CATEGORIES.CCAT_ID
WHERE
  CCAT_NAME = 'rgov'
  AND CONT_PAGE = 'emerald'

SELECT * FROM CONTENT LEFT JOIN CONTENT_CATEGORIES ON CONTENT.CCAT_ID = CONTENT_CATEGORIES.CCAT_ID WHERE CCAT_NAME = 'rgov' AND CONT_PAGE = 'emerald';

SELECT
  *
FROM
  PAGE_CATEGORY
WHERE
  PACA_SECURE = 0
ORDER BY
  PACA_ORDER ASC

SELECT * FROM PAGE_CATEGORY WHERE PACA_SECURE = 0 ORDER BY PACA_ORDER ASC;

SELECT
  *
FROM
  SECUREPAGE
WHERE
  PACA_ID = 1
  AND SCAT_ID = 1
ORDER BY
  SEPA_ORDER ASC

SELECT * FROM SECUREPAGE WHERE PACA_ID = 1 AND SCAT_ID = 1 ORDER BY SEPA_ORDER ASC;

SELECT
  *
FROM
  PAGE_CATEGORY
WHERE
  PACA_ID IN (?)

SELECT * FROM PAGE_CATEGORY WHERE PACA_ID IN ('1');

SELECT
  *
FROM
  PAGE_SUBCATEGORY
WHERE
  SCAT_ID IN (?)

SELECT * FROM PAGE_SUBCATEGORY WHERE SCAT_ID IN ('1');

SELECT
  *
FROM
  CONTENT_CATEGORIES
WHERE
  CCAT_ID IN (?)

SELECT * FROM CONTENT_CATEGORIES WHERE CCAT_ID IN ('4');

SELECT
  *
FROM
  PAGE_SUBCATEGORY
WHERE
  PACA_ID = 1
ORDER BY
  SCAT_ORDER

SELECT * FROM PAGE_SUBCATEGORY WHERE PACA_ID = 1 ORDER BY SCAT_ORDER;

SELECT
  *
FROM
  SECUREPAGE
WHERE
  PACA_ID = 1
  AND SCAT_ID = 11
ORDER BY
  SEPA_ORDER ASC

SELECT * FROM SECUREPAGE WHERE PACA_ID = 1 AND SCAT_ID = 11 ORDER BY SEPA_ORDER ASC;

SELECT
  *
FROM
  SECUREPAGE
WHERE
  PACA_ID = 1
  AND SCAT_ID = 2
ORDER BY
  SEPA_ORDER ASC

SELECT * FROM SECUREPAGE WHERE PACA_ID = 1 AND SCAT_ID = 2 ORDER BY SEPA_ORDER ASC;

SELECT
  *
FROM
  `CONTENT_PARTS`
WHERE
  `CONT_ID` = 8
ORDER BY
  `CPAR_ORDER` ASC

SELECT * FROM `CONTENT_PARTS` WHERE `CONT_ID` = 8 ORDER BY `CPAR_ORDER` ASC;

SELECT
  *
FROM
  SECUREPAGE
WHERE
  PACA_ID = 1
  AND SCAT_ID = 10
ORDER BY
  SEPA_ORDER ASC

SELECT * FROM SECUREPAGE WHERE PACA_ID = 1 AND SCAT_ID = 10 ORDER BY SEPA_ORDER ASC;

SELECT
  *
FROM
  SECUREPAGE
WHERE
  PACA_ID = 1
  AND SCAT_ID = 9
ORDER BY
  SEPA_ORDER ASC

SELECT * FROM SECUREPAGE WHERE PACA_ID = 1 AND SCAT_ID = 9 ORDER BY SEPA_ORDER ASC;

SELECT
  *
FROM
  SECUREPAGE
WHERE
  PACA_ID = 1
  AND SCAT_ID = 64
ORDER BY
  SEPA_ORDER ASC

SELECT * FROM SECUREPAGE WHERE PACA_ID = 1 AND SCAT_ID = 64 ORDER BY SEPA_ORDER ASC;

SELECT
  *
FROM
  SECUREPAGE
WHERE
  PACA_ID = 1
  AND SCAT_ID = 65
ORDER BY
  SEPA_ORDER ASC

SELECT * FROM SECUREPAGE WHERE PACA_ID = 1 AND SCAT_ID = 65 ORDER BY SEPA_ORDER ASC;

SELECT
  *
FROM
  SECUREPAGE
WHERE
  PACA_ID = 1
  AND SCAT_ID = 62
ORDER BY
  SEPA_ORDER ASC

SELECT * FROM SECUREPAGE WHERE PACA_ID = 1 AND SCAT_ID = 62 ORDER BY SEPA_ORDER ASC;

SELECT
  *
FROM
  SECUREPAGE
WHERE
  PACA_ID = 1
  AND SCAT_ID = 63
ORDER BY
  SEPA_ORDER ASC

SELECT * FROM SECUREPAGE WHERE PACA_ID = 1 AND SCAT_ID = 63 ORDER BY SEPA_ORDER ASC;