Symfony Profiler

SELECT
  MELO_STAMP
FROM
  MEMBER_LOGIN
WHERE
  MEMB_ID = ?
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
  SKILLS SK
  LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID = SC.SKCA_ID
  LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID
  AND SPEC_ID = ?
ORDER BY
  SKCA_ORDER,
  SKIL_ORDER

SELECT * FROM SKILLS SK LEFT JOIN SKILL_CATEGORY SC ON SK.SKCA_ID=SC.SKCA_ID LEFT JOIN SPECIALITY_SKILLS SS on SK.SKIL_ID = SS.SKIL_ID AND SPEC_ID = 12 ORDER BY SKCA_ORDER, SKIL_ORDER;

SELECT
  MEMB_ID
FROM
  COOKIE
WHERE
  COOK_TOKEN = '7868ea4a49709df3f996ea04e877bbd53b2ee52c08f672e6bb75b58b90c8a827';

SELECT MEMB_ID FROM COOKIE WHERE COOK_TOKEN = '7868ea4a49709df3f996ea04e877bbd53b2ee52c08f672e6bb75b58b90c8a827';;

SELECT
  *
FROM
  FORWARD_RELATION

SELECT * FROM FORWARD_RELATION;

SELECT
  *
FROM
  UNIT
WHERE
  UNIT_ID IN (?)

SELECT * FROM UNIT WHERE UNIT_ID IN (25);

SELECT
  *
FROM
  MEMBER_POSITION
WHERE
  POSI_ID = ?
  AND MEMB_ID = ?

SELECT * FROM MEMBER_POSITION WHERE POSI_ID=42 AND MEMB_ID=41;

SELECT
  *
FROM
  MEMBER
WHERE
  MEMB_ID = ?

SELECT * FROM MEMBER WHERE MEMB_ID = 41;

SELECT
  *
FROM
  SPECIALITY
WHERE
  SPEC_ID IN (?)

SELECT * FROM SPECIALITY WHERE SPEC_ID IN (10);

SELECT
  *
FROM
  BRANCH

SELECT * FROM BRANCH;

SELECT
  *
FROM
  CLEARANCE
WHERE
  CLEA_ID IN (?)

SELECT * FROM CLEARANCE WHERE CLEA_ID IN (4);

SELECT
  *
FROM
  QUALIFICATION
WHERE
  QUAL_TYPE = ?

SELECT * FROM QUALIFICATION WHERE QUAL_TYPE = 1;

INSERT INTO EXCEPTION (
  EXCE_MESSAGE, EXCE_CONTEXT, EXCE_TRACE,
  EXCE_DATE
)
VALUES
  (?, ?, ?, ?)

INSERT INTO EXCEPTION (EXCE_MESSAGE, EXCE_CONTEXT, EXCE_TRACE, EXCE_DATE) VALUES ('Impossible to access an attribute (\"id\") on a null variable in \"irms/profile.twig\" at line 279.', '/home/empire/public_html/dev/application/templates/irms/profile.twig L279', '#0 /home/empire/public_html/dev/application/var/cache/dev/twig/1b/1b665fe48b595e6dd48ef0dcc4ecfd92.php(733): Twig\\Extension\\CoreExtension::getAttribute(Object(Twig\\Environment), Object(Twig\\Source), NULL, \'id\', Array, \'any\', false, false, false, 279)
#1 /home/empire/public_html/dev/application/vendor/twig/twig/src/Template.php(446): __TwigTemplate_bb45fb2527abe5b3caa552a1187a9777->block_content(Array, Array)
#2 /home/empire/public_html/dev/application/var/cache/dev/twig/e5/e50238017428ce0a1087b2f0af1da4a5.php(252): Twig\\Template->yieldBlock(\'content\', Array, Array)
#3 /home/empire/public_html/dev/application/vendor/twig/twig/src/Template.php(402): __TwigTemplate_035fc62eb7d90b6abd4834f1bb342155->doDisplay(Array, Array)
#4 /home/empire/public_html/dev/application/var/cache/dev/twig/1a/1a7817790505379372e152b862a1c228.php(53): Twig\\Template->yield(Array, Array)
#5 /home/empire/public_html/dev/application/vendor/twig/twig/src/Template.php(402): __TwigTemplate_79dcf6ae96f2063b78d04a9ae3e60bb3->doDisplay(Array, Array)
#6 /home/empire/public_html/dev/application/var/cache/dev/twig/1b/1b665fe48b595e6dd48ef0dcc4ecfd92.php(56): Twig\\Template->yield(Array, Array)
#7 /home/empire/public_html/dev/application/vendor/twig/twig/src/Template.php(402): __TwigTemplate_bb45fb2527abe5b3caa552a1187a9777->doDisplay(Array, Array)
#8 /home/empire/public_html/dev/application/vendor/twig/twig/src/Template.php(358): Twig\\Template->yield(Array, Array)
#9 /home/empire/public_html/dev/application/vendor/twig/twig/src/Template.php(373): Twig\\Template->display(Array)
#10 /home/empire/public_html/dev/application/vendor/twig/twig/src/TemplateWrapper.php(51): Twig\\Template->render(Array)
#11 /home/empire/public_html/dev/application/vendor/twig/twig/src/Environment.php(333): Twig\\TemplateWrapper->render(Array)
#12 /home/empire/public_html/dev/application/vendor/symfony/framework-bundle/Controller/AbstractController.php(448): Twig\\Environment->render(\'irms/profile.tw...\', Array)
#13 /home/empire/public_html/dev/application/vendor/symfony/framework-bundle/Controller/AbstractController.php(453): Symfony\\Bundle\\FrameworkBundle\\Controller\\AbstractController->doRenderView(\'irms/profile.tw...\', NULL, Array, \'render\')
#14 /home/empire/public_html/dev/application/vendor/symfony/framework-bundle/Controller/AbstractController.php(253): Symfony\\Bundle\\FrameworkBundle\\Controller\\AbstractController->doRender(\'irms/profile.tw...\', NULL, Array, NULL, \'render\')
#15 /home/empire/public_html/dev/application/src/Controller/IRMS/ProfileController.php(49): Symfony\\Bundle\\FrameworkBundle\\Controller\\AbstractController->render(\'irms/profile.tw...\', Array)
#16 /home/empire/public_html/dev/application/vendor/symfony/http-kernel/HttpKernel.php(181): App\\Controller\\IRMS\\ProfileController->profile(0, 0)
#17 /home/empire/public_html/dev/application/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1)
#18 /home/empire/public_html/dev/application/vendor/symfony/http-kernel/Kernel.php(197): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)
#19 /home/empire/public_html/dev/index.php(33): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))
#20 {main}', 1751921168);

SELECT
  *
FROM
  SPECIALITY
ORDER BY
  BRAN_ID ASC,
  SPEC_NAME ASC

SELECT * FROM SPECIALITY ORDER BY BRAN_ID ASC, SPEC_NAME ASC;

SELECT
  *
FROM
  MEMBER
WHERE
  MEMB_ID = '41';

SELECT * FROM MEMBER WHERE MEMB_ID = '41';;

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

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

SELECT
  *
FROM
  PAGE_SUBCATEGORY
WHERE
  PACA_ID = ?
ORDER BY
  SCAT_ORDER

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

SELECT
  *
FROM
  PAGE_SUBCATEGORY
WHERE
  SCAT_ID IN (?)

SELECT * FROM PAGE_SUBCATEGORY WHERE SCAT_ID IN (12);

SELECT
  *
FROM
  PAGE_CATEGORY
WHERE
  PACA_ID IN (?)

SELECT * FROM PAGE_CATEGORY WHERE PACA_ID IN (9);

SELECT
  *,
  COUNT(*) AS COUNT
FROM
  MEMBER_AWARD MA
  LEFT JOIN AWARD AW ON MA.AWAR_ID = AW.AWAR_ID
WHERE
  MEMB_ID = ?
GROUP BY
  AW.AWAR_HIERARCHY
ORDER BY
  AW.AWAR_HIERARCHY

SELECT *, COUNT(*) AS COUNT FROM MEMBER_AWARD MA LEFT JOIN AWARD AW ON MA.AWAR_ID=AW.AWAR_ID WHERE MEMB_ID=41 GROUP BY AW.AWAR_HIERARCHY ORDER BY AW.AWAR_HIERARCHY;

SELECT
  *
FROM
  BRANCH
WHERE
  BRAN_ID IN (?)

SELECT * FROM BRANCH WHERE BRAN_ID IN (2);

SELECT
  *
FROM
  IMM_ATTENDANCE
WHERE
  MEMB_ID = ?

SELECT * FROM IMM_ATTENDANCE WHERE MEMB_ID = 41;

SELECT
  *
FROM
  RANK_MEMBER
WHERE
  RANK_ID = ?
  AND MEMB_ID = ?

SELECT * FROM RANK_MEMBER WHERE RANK_ID=153 AND MEMB_ID=41;

SELECT
  *
FROM
  RANK_MEMBER
WHERE
  MEMB_ID = ?
  AND RAME_PRIMARY = 1

SELECT * FROM RANK_MEMBER WHERE MEMB_ID = 41 AND RAME_PRIMARY=1;

SELECT
  ACCESS.ACKY_ID AS ACKY_ID,
  ACKY_DESC,
  ACKY_KEY,
  ACCS_VALUE,
  ACKY_CATEGORY,
  ACKY_MAXVAL,
  POSI_ID
FROM
  ACCESS
  LEFT JOIN ACCESS_KEY ON ACCESS.ACKY_ID = ACCESS_KEY.ACKY_ID
WHERE
  POSI_ID IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT ACCESS.ACKY_ID AS ACKY_ID, ACKY_DESC, ACKY_KEY, ACCS_VALUE, ACKY_CATEGORY, ACKY_MAXVAL, POSI_ID FROM ACCESS 
                                                   LEFT JOIN ACCESS_KEY ON ACCESS.ACKY_ID = ACCESS_KEY.ACKY_ID 
                                                   WHERE POSI_ID IN (40, 43, 41, 60, 24, 42, 65, 63, 48, 59);

SELECT
  *
FROM
  SECUREPAGE
WHERE
  SEPA_PAGE = ?

SELECT * FROM SECUREPAGE WHERE SEPA_PAGE = 'irms/profile';

SELECT
  COUNT(*) as count
FROM
  `NOTIFICATION`
WHERE
  `NOTI_TARGET` = ?
  AND `NOTI_UNREAD` = ?

SELECT COUNT(*) as count FROM `NOTIFICATION` WHERE `NOTI_TARGET` = 41 AND `NOTI_UNREAD` = 1;

SELECT
  *
FROM
  UNIT

SELECT * FROM UNIT;

SELECT
  *
FROM
  STATUS_CHANGE
WHERE
  MEMB_ID = ?

SELECT * FROM STATUS_CHANGE WHERE MEMB_ID=41;

/* Username */
SELECT
  *
FROM
  MEMBER
WHERE
  MEMB_ID = ?

/* Username */ SELECT * FROM MEMBER WHERE MEMB_ID = '41';

SELECT
  *
FROM
  MEMBER_POSITION MP
  LEFT JOIN POSITION P ON MP.POSI_ID = P.POSI_ID
WHERE
  MEMB_ID = ?

SELECT * FROM MEMBER_POSITION MP LEFT JOIN POSITION P ON MP.POSI_ID = P.POSI_ID WHERE MEMB_ID = 41;

SELECT
  *
FROM
  MEMBER_AWARD
WHERE
  AWAR_ID = ?
  AND MEMB_ID = ?

SELECT * FROM MEMBER_AWARD WHERE AWAR_ID=123 AND MEMB_ID=41;

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

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

SELECT
  *
FROM
  BRANCH_SERVICE_HISTORY
WHERE
  MEMB_ID = ?
ORDER BY
  BRSE_START_DATE DESC

SELECT * FROM BRANCH_SERVICE_HISTORY WHERE MEMB_ID = 41 ORDER BY BRSE_START_DATE DESC;

SELECT
  *
FROM
  RANK_MEMBER
WHERE
  MEMB_ID = ?

SELECT * FROM RANK_MEMBER WHERE MEMB_ID = 41;

SELECT
  *
FROM
  STATUS
WHERE
  STAT_ID IN (?)

SELECT * FROM STATUS WHERE STAT_ID IN (1);

SELECT
  *
FROM
  RANK
WHERE
  RANK_ID IN (?, ?)

SELECT * FROM RANK WHERE RANK_ID IN (153, 177);

SELECT
  *
FROM
  MEMBER
WHERE
  MEMB_ID IN (?)

SELECT * FROM MEMBER WHERE MEMB_ID IN (41);

SELECT
  *
FROM
  RANK
WHERE
  RANK_ID IN (?)

SELECT * FROM RANK WHERE RANK_ID IN (153);

SELECT
  *
FROM
  LEAVE_GRANTS
WHERE
  MEMB_ID = ?

SELECT * FROM LEAVE_GRANTS WHERE MEMB_ID=41;

SELECT
  *
FROM
  MEMBER_LEAVE
WHERE
  MEMB_ID = ?
  AND MELE_STATUS < 2

SELECT * FROM MEMBER_LEAVE WHERE MEMB_ID=41 AND MELE_STATUS<2;

SELECT
  *
FROM
  RACE
WHERE
  RACE_ID IN (?)

SELECT * FROM RACE WHERE RACE_ID IN (33);