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 a0_
  LEFT JOIN admin_selection_project a1_ ON (
    (
      a0_.id = a1_.moduleinstance
      AND a1_.modulekey = 'badiu.tms.offer.offer'
      AND a1_.ttype = 'default'
      AND a1_.deleted = 0
    )
  )
WHERE
  a0_.dtype = 'training'
  AND a0_.shortname <> 'tmsdefaultcourseoffer'
  AND a0_.entity = ?
  AND a0_.deleted = 0

SELECT COUNT(a0_.id) AS sclr_0 FROM ams_offer a0_ LEFT JOIN admin_selection_project a1_ ON ((a0_.id = a1_.moduleinstance AND a1_.modulekey = 'badiu.tms.offer.offer' AND a1_.ttype = 'default' AND a1_.deleted = 0)) WHERE a0_.dtype = 'training' AND a0_.shortname <> 'tmsdefaultcourseoffer' AND a0_.entity = 1 AND a0_.deleted = 0;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.shortname AS shortname_2,
  a0_.description AS description_3,
  a0_.defaultimage AS defaultimage_4,
  (
    SELECT
      COUNT(a1_.id) AS sclr_6
    FROM
      ams_offer_discipline a1_
    WHERE
      a1_.offerid = a0_.id
      AND a1_.deleted = 0
  ) AS sclr_5,
  (
    SELECT
      SUM(a2_.dhour) AS sclr_8
    FROM
      ams_offer_discipline a3_
      INNER JOIN ams_discipline a2_ ON a3_.disciplineid = a2_.id
    WHERE
      a3_.offerid = a0_.id
      AND a3_.deleted = 0
  ) AS sclr_7,
  a0_.dconfig AS dconfig_9,
  a4_.skey AS skey_10,
  a4_.analysiscriteria AS analysiscriteria_11
FROM
  ams_offer a0_
  LEFT JOIN admin_selection_project a4_ ON (
    (
      a0_.id = a4_.moduleinstance
      AND a4_.modulekey = 'badiu.tms.offer.offer'
      AND a4_.ttype = 'default'
      AND a4_.deleted = 0
    )
  )
WHERE
  a0_.dtype = 'training'
  AND a0_.shortname <> 'tmsdefaultcourseoffer'
  AND a0_.entity = ?
  AND a0_.deleted = 0
ORDER BY
  a0_.timecreated DESC
LIMIT
  10

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.shortname AS shortname_2, a0_.description AS description_3, a0_.defaultimage AS defaultimage_4, (SELECT COUNT(a1_.id) AS sclr_6 FROM ams_offer_discipline a1_ WHERE a1_.offerid = a0_.id AND a1_.deleted = 0) AS sclr_5, (SELECT SUM(a2_.dhour) AS sclr_8 FROM ams_offer_discipline a3_ INNER JOIN ams_discipline a2_ ON a3_.disciplineid = a2_.id WHERE a3_.offerid = a0_.id AND a3_.deleted = 0) AS sclr_7, a0_.dconfig AS dconfig_9, a4_.skey AS skey_10, a4_.analysiscriteria AS analysiscriteria_11 FROM ams_offer a0_ LEFT JOIN admin_selection_project a4_ ON ((a0_.id = a4_.moduleinstance AND a4_.modulekey = 'badiu.tms.offer.offer' AND a4_.ttype = 'default' AND a4_.deleted = 0)) WHERE a0_.dtype = 'training' AND a0_.shortname <> 'tmsdefaultcourseoffer' AND a0_.entity = 1 AND a0_.deleted = 0 ORDER BY a0_.timecreated DESC LIMIT 10;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a1_.drequired AS drequired_2,
  a0_.dhour AS dhour_3,
  a0_.shortname AS shortname_4,
  a2_.id AS id_5
FROM
  ams_offer_discipline a1_
  INNER JOIN ams_discipline a0_ ON a1_.disciplineid = a0_.id
  INNER JOIN ams_offer a2_ ON a1_.offerid = a2_.id
WHERE
  a0_.dtype = 'training'
  AND a2_.shortname <> 'tmsdefaultcourseoffer'
  AND a1_.entity = ?
LIMIT
  20000

SELECT a0_.id AS id_0, a0_.name AS name_1, a1_.drequired AS drequired_2, a0_.dhour AS dhour_3, a0_.shortname AS shortname_4, a2_.id AS id_5 FROM ams_offer_discipline a1_ INNER JOIN ams_discipline a0_ ON a1_.disciplineid = a0_.id INNER JOIN ams_offer a2_ ON a1_.offerid = a2_.id WHERE a0_.dtype = 'training' AND a2_.shortname <> 'tmsdefaultcourseoffer' AND a1_.entity = 1 LIMIT 20000;

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.studentofferavailableflist.index';

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 );