Symfony Profiler

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'service_gc2'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  system_module_config_global s0_
WHERE
  s0_.id > ?
  AND s0_.bundlekey = ?
  AND s0_.name = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM system_module_config_global s0_ WHERE s0_.id > 0 AND s0_.bundlekey = 'badiu.system.packge' AND s0_.name = 'badiu.system.packge.version';

SELECT
  s0_.id AS id_0,
  s0_.entity AS entity_1,
  s0_.firstname AS firstname_2,
  s0_.lastname AS lastname_3,
  s0_.alternatename AS alternatename_4,
  s0_.enablealternatename AS enablealternatename_5,
  s0_.email AS email_6,
  s0_.auth AS auth_7,
  s0_.username AS username_8,
  s0_.idnumber AS idnumber_9,
  s0_.shortname AS shortname_10,
  s0_.doctype AS doctype_11,
  s0_.docnumber AS docnumber_12,
  s0_.ukey AS ukey_13,
  s0_.idnumber AS idnumber_14,
  s0_.dconfig AS dconfig_15,
  s0_.param AS param_16,
  s0_.marker AS marker_17,
  s0_.lang AS lang_18,
  s0_.passwordstatus AS passwordstatus_19
FROM
  system_user s0_
WHERE
  s0_.id > ?
  AND s0_.entity = ?
  AND s0_.shortname = ?

SELECT s0_.id AS id_0, s0_.entity AS entity_1, s0_.firstname AS firstname_2, s0_.lastname AS lastname_3, s0_.alternatename AS alternatename_4, s0_.enablealternatename AS enablealternatename_5, s0_.email AS email_6, s0_.auth AS auth_7, s0_.username AS username_8, s0_.idnumber AS idnumber_9, s0_.shortname AS shortname_10, s0_.doctype AS doctype_11, s0_.docnumber AS docnumber_12, s0_.ukey AS ukey_13, s0_.idnumber AS idnumber_14, s0_.dconfig AS dconfig_15, s0_.param AS param_16, s0_.marker AS marker_17, s0_.lang AS lang_18, s0_.passwordstatus AS passwordstatus_19 FROM system_user s0_ WHERE s0_.id > 0 AND s0_.entity = 1 AND s0_.shortname = 'guest';

SELECT
  s0_.pemissionkey AS pemissionkey_0
FROM
  system_access_role_permission s0_
  INNER JOIN system_access_role_user s1_ ON (s0_.roleid = s1_.roleid)
WHERE
  s0_.entity = ?
  AND s1_.userid = ?

SELECT s0_.pemissionkey AS pemissionkey_0 FROM system_access_role_permission s0_ INNER JOIN system_access_role_user s1_ ON (s0_.roleid = s1_.roleid) WHERE s0_.entity = 1 AND s1_.userid = '2';

SELECT
  s0_.shortname AS shortname_0
FROM
  system_access_role_user s1_
  INNER JOIN system_access_role s0_ ON s1_.roleid = s0_.id
WHERE
  s1_.entity = ?
  AND s1_.userid = ?

SELECT s0_.shortname AS shortname_0 FROM system_access_role_user s1_ INNER JOIN system_access_role s0_ ON s1_.roleid = s0_.id WHERE s1_.entity = 1 AND s1_.userid = '2';

SELECT
  s0_.shortname AS shortname_0,
  s0_.defaultroute AS defaultroute_1
FROM
  system_access_role_user s1_
  INNER JOIN system_access_role s0_ ON s1_.roleid = s0_.id
WHERE
  s1_.entity = ?
  AND s1_.userid = ?

SELECT s0_.shortname AS shortname_0, s0_.defaultroute AS defaultroute_1 FROM system_access_role_user s1_ INNER JOIN system_access_role s0_ ON s1_.roleid = s0_.id WHERE s1_.entity = 1 AND s1_.userid = '2';

SELECT
  s0_.id AS id_0,
  s0_.modulekey AS modulekey_1,
  s0_.moduleinstance AS moduleinstance_2
FROM
  system_access_user_record s0_
WHERE
  s0_.entity = ?
  AND s0_.userid = ?

SELECT s0_.id AS id_0, s0_.modulekey AS modulekey_1, s0_.moduleinstance AS moduleinstance_2 FROM system_access_user_record s0_ WHERE s0_.entity = 1 AND s0_.userid = '2';

SELECT
  s0_.name AS name_0
FROM
  sync_freport s0_
WHERE
  s0_.id > ?
  AND s0_.id = ?

SELECT s0_.name AS name_0 FROM sync_freport s0_ WHERE s0_.id > 0 AND s0_.id = NULL;

SELECT
  s0_.dkey AS dkey_0,
  s0_.dconfig AS dconfig_1,
  s0_.customtext1 AS customtext1_2
FROM
  sync_freport s0_
WHERE
  s0_.id > ?
  AND s0_.id = ?

SELECT s0_.dkey AS dkey_0, s0_.dconfig AS dconfig_1, s0_.customtext1 AS customtext1_2 FROM sync_freport s0_ WHERE s0_.id > 0 AND s0_.id = NULL;

SELECT
  s0_.dkey AS dkey_0,
  s0_.dconfig AS dconfig_1,
  s0_.customtext1 AS customtext1_2
FROM
  sync_freport s0_
WHERE
  s0_.id > ?
  AND s0_.id = ?

SELECT s0_.dkey AS dkey_0, s0_.dconfig AS dconfig_1, s0_.customtext1 AS customtext1_2 FROM sync_freport s0_ WHERE s0_.id > 0 AND s0_.id = NULL;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  ams_offer_classe a0_
  INNER JOIN ams_offer_classe_status a1_ ON a0_.statusid = a1_.id
  INNER JOIN ams_offer_discipline a2_ ON a0_.odisciplineid = a2_.id
  INNER JOIN ams_discipline a3_ ON a2_.disciplineid = a3_.id
  INNER JOIN ams_discipline_cetegory a4_ ON a3_.categoryid = a4_.id
  INNER JOIN ams_offer a5_ ON a2_.offerid = a5_.id
  LEFT JOIN ams_course a6_ ON a5_.courseid = a6_.id
  LEFT JOIN admin_selection_project a7_ ON (
    (
      a0_.id = a7_.moduleinstance
      AND a7_.modulekey = 'badiu.tms.offer.classe'
      AND a7_.ttype = 'default'
      AND a7_.deleted = 0
    )
  )
WHERE
  a5_.shortname = 'tmsdefaultcourseoffer'
  AND a3_.dtype = 'training'
  AND a0_.entity = ?
  AND a0_.deleted = 0
  AND a2_.deleted = 0
  AND a5_.deleted = 0
  AND a3_.deleted = 0
  AND a4_.deleted = 0
  AND a1_.shortname = 'classeongoing'
  AND (
    a0_.timestart IS NULL
    OR a0_.timestart <= ?
  )
  AND (
    a0_.timeend IS NULL
    OR a0_.timeend >= ?
  )

SELECT COUNT(a0_.id) AS sclr_0 FROM ams_offer_classe a0_ INNER JOIN ams_offer_classe_status a1_ ON a0_.statusid = a1_.id INNER JOIN ams_offer_discipline a2_ ON a0_.odisciplineid = a2_.id INNER JOIN ams_discipline a3_ ON a2_.disciplineid = a3_.id INNER JOIN ams_discipline_cetegory a4_ ON a3_.categoryid = a4_.id INNER JOIN ams_offer a5_ ON a2_.offerid = a5_.id LEFT JOIN ams_course a6_ ON a5_.courseid = a6_.id LEFT JOIN admin_selection_project a7_ ON ((a0_.id = a7_.moduleinstance AND a7_.modulekey = 'badiu.tms.offer.classe' AND a7_.ttype = 'default' AND a7_.deleted = 0)) WHERE a5_.shortname = 'tmsdefaultcourseoffer' AND a3_.dtype = 'training' AND a0_.entity = 1 AND a0_.deleted = 0 AND a2_.deleted = 0 AND a5_.deleted = 0 AND a3_.deleted = 0 AND a4_.deleted = 0 AND a1_.shortname = 'classeongoing' AND (a0_.timestart IS NULL OR a0_.timestart <= '2025-07-30 23:06:26') AND (a0_.timeend IS NULL OR a0_.timeend >= '2025-07-30 23:06:26');

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.defaultimage AS defaultimage_3,
  a0_.dconfig AS dconfig_4,
  a1_.name AS name_5,
  a1_.id AS id_6,
  a1_.dhour AS dhour_7,
  a1_.defaultimage AS defaultimage_8,
  a1_.summary AS summary_9,
  a1_.usertarget AS usertarget_10,
  a2_.name AS name_11,
  a2_.id AS id_12,
  a3_.skey AS skey_13,
  a3_.analysiscriteria AS analysiscriteria_14,
  a4_.id AS id_15
FROM
  ams_offer_classe a0_
  INNER JOIN ams_offer_classe_status a5_ ON a0_.statusid = a5_.id
  INNER JOIN ams_offer_discipline a4_ ON a0_.odisciplineid = a4_.id
  INNER JOIN ams_discipline a1_ ON a4_.disciplineid = a1_.id
  INNER JOIN ams_discipline_cetegory a2_ ON a1_.categoryid = a2_.id
  INNER JOIN ams_offer a6_ ON a4_.offerid = a6_.id
  LEFT JOIN ams_course a7_ ON a6_.courseid = a7_.id
  LEFT JOIN admin_selection_project a3_ ON (
    (
      a0_.id = a3_.moduleinstance
      AND a3_.modulekey = 'badiu.tms.offer.classe'
      AND a3_.ttype = 'default'
      AND a3_.deleted = 0
    )
  )
WHERE
  a6_.shortname = 'tmsdefaultcourseoffer'
  AND a1_.dtype = 'training'
  AND a0_.entity = ?
  AND a0_.deleted = 0
  AND a4_.deleted = 0
  AND a6_.deleted = 0
  AND a1_.deleted = 0
  AND a2_.deleted = 0
  AND a5_.shortname = 'classeongoing'
  AND (
    a0_.timestart IS NULL
    OR a0_.timestart <= ?
  )
  AND (
    a0_.timeend IS NULL
    OR a0_.timeend >= ?
  )
ORDER BY
  a0_.timestart DESC
LIMIT
  10

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.defaultimage AS defaultimage_3, a0_.dconfig AS dconfig_4, a1_.name AS name_5, a1_.id AS id_6, a1_.dhour AS dhour_7, a1_.defaultimage AS defaultimage_8, a1_.summary AS summary_9, a1_.usertarget AS usertarget_10, a2_.name AS name_11, a2_.id AS id_12, a3_.skey AS skey_13, a3_.analysiscriteria AS analysiscriteria_14, a4_.id AS id_15 FROM ams_offer_classe a0_ INNER JOIN ams_offer_classe_status a5_ ON a0_.statusid = a5_.id INNER JOIN ams_offer_discipline a4_ ON a0_.odisciplineid = a4_.id INNER JOIN ams_discipline a1_ ON a4_.disciplineid = a1_.id INNER JOIN ams_discipline_cetegory a2_ ON a1_.categoryid = a2_.id INNER JOIN ams_offer a6_ ON a4_.offerid = a6_.id LEFT JOIN ams_course a7_ ON a6_.courseid = a7_.id LEFT JOIN admin_selection_project a3_ ON ((a0_.id = a3_.moduleinstance AND a3_.modulekey = 'badiu.tms.offer.classe' AND a3_.ttype = 'default' AND a3_.deleted = 0)) WHERE a6_.shortname = 'tmsdefaultcourseoffer' AND a1_.dtype = 'training' AND a0_.entity = 1 AND a0_.deleted = 0 AND a4_.deleted = 0 AND a6_.deleted = 0 AND a1_.deleted = 0 AND a2_.deleted = 0 AND a5_.shortname = 'classeongoing' AND (a0_.timestart IS NULL OR a0_.timestart <= '2025-07-30 23:06:26') AND (a0_.timeend IS NULL OR a0_.timeend >= '2025-07-30 23:06:26') ORDER BY a0_.timestart DESC LIMIT 10;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  system_scheduler_task s0_
WHERE
  s0_.id > ?
  AND s0_.entity = ?
  AND s0_.deleted = ?
  AND s0_.functionalitykey = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM system_scheduler_task s0_ WHERE s0_.id > 0 AND s0_.entity = 1 AND s0_.deleted = 0 AND s0_.functionalitykey = 'badiu.tms.my.studentclasseavailableflist.index';

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.idpath AS idpath_2,
  a0_.path AS path_3
FROM
  ams_discipline_cetegory a0_
WHERE
  a0_.entity = ?
  AND a0_.deleted = ?
  AND a0_.dtype = ?
ORDER BY
  a0_.orderidpath ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.idpath AS idpath_2, a0_.path AS path_3 FROM ams_discipline_cetegory a0_ WHERE a0_.entity = 1 AND a0_.deleted = 0 AND a0_.dtype = 'training' ORDER BY a0_.orderidpath ASC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.url AS url_2
FROM
  admin_server_service a0_
WHERE
  a0_.id > ?
  AND a0_.entity = ?
  AND a0_.dtype = ?

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.url AS url_2 FROM admin_server_service a0_ WHERE a0_.id > 0 AND a0_.entity = 1 AND a0_.dtype = 'site_moodle';

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1
FROM
  system_module_param s0_
WHERE
  s0_.id > ?
  AND s0_.entity = ?
  AND s0_.dtype = ?
  AND s0_.modulekey = ?
  AND s0_.bundlekey = ?

SELECT s0_.id AS id_0, s0_.name AS name_1 FROM system_module_param s0_ WHERE s0_.id > 0 AND s0_.entity = 1 AND s0_.dtype = 'clientwsschedulerdelivery' AND s0_.modulekey = 'badiu.system.module.clientwebserverschedulerdelivery' AND s0_.bundlekey = 'badiu.system.module';

INSERT INTO system_log (
  timeexec, dtype, clientdevice, modulekey,
  moduleinstance, functionalitykey,
  ACTION, rkey, ip, param, entity, userid,
  timecreated
)
VALUES
  (
    :timeexec, :dtype, :clientdevice,
    :modulekey, :moduleinstance, :functionalitykey,
    :action, :rkey, :ip, :param, :entity,
    :userid, :timecreated
  )

INSERT INTO system_log ( timeexec,dtype,clientdevice,modulekey,moduleinstance,functionalitykey,ACTION,rkey,ip,param,entity,userid,timecreated)  VALUES (:timeexec ,:dtype ,:clientdevice ,:modulekey ,:moduleinstance ,:functionalitykey ,:action ,:rkey ,:ip ,:param ,:entity ,:userid ,:timecreated );