Symfony Profiler

SELECT
  *
FROM
  SECUREPAGE
WHERE
  SEPA_PAGE = 'Public/Home/ihc.php'

SELECT * FROM SECUREPAGE WHERE SEPA_PAGE='Public/Home/ihc.php';

SELECT
  POSI.POSI_ID
FROM
  POSITION AS POSI
  LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
  LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
WHERE
  POSI.POSI_NAME = 'Emperor'
  AND BRAN.BRAN_NAME = 'Imperial Throne'

SELECT POSI.POSI_ID FROM POSITION AS POSI
              LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
              LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
              WHERE POSI.POSI_NAME = 'Emperor' AND BRAN.BRAN_NAME = 'Imperial Throne';

SELECT
  POSI.POSI_ID
FROM
  POSITION AS POSI
  LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
  LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
WHERE
  POSI.POSI_NAME = 'High Moff'
  AND BRAN.BRAN_NAME = 'Regional Government'
  AND UNIT.UNIT_NAME = 'Council of Moffs'

SELECT POSI.POSI_ID FROM POSITION AS POSI
              LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
              LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
              WHERE POSI.POSI_NAME = 'High Moff' AND BRAN.BRAN_NAME = 'Regional Government' AND UNIT.UNIT_NAME = 'Council of Moffs';

SELECT
  POSI.POSI_ID
FROM
  POSITION AS POSI
  LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
  LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
WHERE
  POSI.POSI_NAME = 'Executor'
  AND BRAN.BRAN_NAME = 'Imperial Throne'

SELECT POSI.POSI_ID FROM POSITION AS POSI
              LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
              LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
              WHERE POSI.POSI_NAME = 'Executor' AND BRAN.BRAN_NAME = 'Imperial Throne';

SELECT
  POSI.POSI_ID
FROM
  POSITION AS POSI
  LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
  LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
WHERE
  POSI.POSI_NAME = 'Army Commanding Officer'
  AND BRAN.BRAN_NAME = 'Imperial Army'

SELECT POSI.POSI_ID FROM POSITION AS POSI
              LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
              LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
              WHERE POSI.POSI_NAME = 'Army Commanding Officer' AND BRAN.BRAN_NAME = 'Imperial Army';

SELECT
  POSI.POSI_ID
FROM
  POSITION AS POSI
  LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
  LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
WHERE
  POSI.POSI_NAME = 'Dark Lord of the Sith'
  AND BRAN.BRAN_NAME = 'Order of the Sith'

SELECT POSI.POSI_ID FROM POSITION AS POSI
              LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
              LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
              WHERE POSI.POSI_NAME = 'Dark Lord of the Sith' AND BRAN.BRAN_NAME = 'Order of the Sith';

SELECT
  POSI.POSI_ID
FROM
  POSITION AS POSI
  LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
  LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
WHERE
  POSI.POSI_NAME = 'Director'
  AND BRAN.BRAN_NAME = 'Imperial Intelligence'

SELECT POSI.POSI_ID FROM POSITION AS POSI
              LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
              LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
              WHERE POSI.POSI_NAME = 'Director' AND BRAN.BRAN_NAME = 'Imperial Intelligence';

SELECT
  POSI.POSI_ID
FROM
  POSITION AS POSI
  LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
  LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
WHERE
  POSI.POSI_NAME = 'Navy Commanding Officer'
  AND BRAN.BRAN_NAME = 'Imperial Navy'

SELECT POSI.POSI_ID FROM POSITION AS POSI
              LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
              LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
              WHERE POSI.POSI_NAME = 'Navy Commanding Officer' AND BRAN.BRAN_NAME = 'Imperial Navy';

SELECT
  POSI.POSI_ID
FROM
  POSITION AS POSI
  LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
  LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
WHERE
  POSI.POSI_NAME = 'Minister'
  AND BRAN.BRAN_NAME = 'Ministry of Industry'

SELECT POSI.POSI_ID FROM POSITION AS POSI
              LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
              LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
              WHERE POSI.POSI_NAME = 'Minister' AND BRAN.BRAN_NAME = 'Ministry of Industry';

SELECT
  POSI.POSI_ID
FROM
  POSITION AS POSI
  LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
  LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
WHERE
  POSI.POSI_NAME = 'Grand Vizier'
  AND BRAN.BRAN_NAME = 'Commission for the Preservation of the New Order'

SELECT POSI.POSI_ID FROM POSITION AS POSI
              LEFT JOIN BRANCH AS BRAN ON POSI.BRAN_ID = BRAN.BRAN_ID
              LEFT JOIN UNIT ON POSI.UNIT_ID = UNIT.UNIT_ID
              WHERE POSI.POSI_NAME = 'Grand Vizier' AND BRAN.BRAN_NAME = 'Commission for the Preservation of the New Order';