Symfony Profiler

SELECT
  *
FROM
  NEWS
WHERE
  NEWS_ID IN (?)

SELECT * FROM NEWS WHERE NEWS_ID IN ('21');

SELECT
  *
FROM
  MEMBER
WHERE
  MEMB_ID IN (?)

SELECT * FROM MEMBER WHERE MEMB_ID IN ('41');

SELECT
  MELO_STAMP
FROM
  MEMBER_LOGIN
WHERE
  MEMB_ID = 41
ORDER BY
  MELO_STAMP DESC
LIMIT
  1

SELECT MELO_STAMP FROM MEMBER_LOGIN WHERE MEMB_ID = 41 ORDER BY MELO_STAMP DESC LIMIT 1;

SELECT
  *
FROM
  NEWS
WHERE
  NEWS_TYPE = 1
ORDER BY
  NEWS_STAMP DESC
LIMIT
  3

SELECT * FROM NEWS WHERE NEWS_TYPE = 1 ORDER BY NEWS_STAMP DESC LIMIT 3 ;

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
  PAGE_SUBCATEGORY
WHERE
  PACA_ID = 1
ORDER BY
  SCAT_ORDER

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

SELECT
  *
FROM
  PAGE_CATEGORY
WHERE
  PACA_ID IN (?)

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

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_SUBCATEGORY
WHERE
  SCAT_ID IN (?)

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

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
  PAGE_SUBCATEGORY
WHERE
  SCAT_ID IN (?)

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

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
  PAGE_SUBCATEGORY
WHERE
  SCAT_ID IN (?)

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

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;

SELECT
  *
FROM
  PAGE_SUBCATEGORY
WHERE
  SCAT_ID IN (?)

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

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

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

SELECT
  *
FROM
  PAGE_SUBCATEGORY
WHERE
  SCAT_ID IN (?)

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

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

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

SELECT
  *
FROM
  PAGE_SUBCATEGORY
WHERE
  SCAT_ID IN (?)

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

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
  PAGE_SUBCATEGORY
WHERE
  SCAT_ID IN (?)

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

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
  PAGE_SUBCATEGORY
WHERE
  SCAT_ID IN (?)

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

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

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

SELECT
  *
FROM
  PAGE_SUBCATEGORY
WHERE
  SCAT_ID IN (?)

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