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_.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
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.content AS content_2,
  a0_.defaultimage AS defaultimage_3,
  a0_.shortname AS shortname_4,
  a0_.description AS description_5,
  a0_.defaulturl AS defaulturl_6,
  a0_.customcss AS customcss_7,
  a0_.customjs AS customjs_8,
  a1_.id AS id_9,
  a1_.name AS name_10,
  a1_.content AS content_11,
  a1_.customcss AS customcss_12,
  a1_.customjs AS customjs_13,
  a0_.dtype AS dtype_14,
  a0_.btype AS btype_15
FROM
  admin_cms_resource a0_
  INNER JOIN admin_cms_resource_repository a2_ ON a0_.repositoryid = a2_.id
  INNER JOIN admin_cms_resource_status a3_ ON a0_.statusid = a3_.id
  LEFT JOIN admin_cms_resource_template a1_ ON a0_.templateid = a1_.id
  LEFT JOIN admin_cms_resource_structure a4_ ON a0_.structureid = a4_.id
WHERE
  a0_.entity = ?
  AND a2_.shortname = 'badiutmscorestudentfviewdefault'
  AND a3_.shortname = 'approval'
  AND a0_.dtype = 'content'
  AND a0_.btype = 'page'
  AND a0_.shortname = 'privatepolicecookies'
  AND a0_.deleted = 0

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.content AS content_2, a0_.defaultimage AS defaultimage_3, a0_.shortname AS shortname_4, a0_.description AS description_5, a0_.defaulturl AS defaulturl_6, a0_.customcss AS customcss_7, a0_.customjs AS customjs_8, a1_.id AS id_9, a1_.name AS name_10, a1_.content AS content_11, a1_.customcss AS customcss_12, a1_.customjs AS customjs_13, a0_.dtype AS dtype_14, a0_.btype AS btype_15 FROM admin_cms_resource a0_ INNER JOIN admin_cms_resource_repository a2_ ON a0_.repositoryid = a2_.id INNER JOIN admin_cms_resource_status a3_ ON a0_.statusid = a3_.id LEFT JOIN admin_cms_resource_template a1_ ON a0_.templateid = a1_.id LEFT JOIN admin_cms_resource_structure a4_ ON a0_.structureid = a4_.id WHERE a0_.entity = '1' AND a2_.shortname = 'badiutmscorestudentfviewdefault' AND a3_.shortname = 'approval' AND a0_.dtype = 'content' AND a0_.btype = 'page' AND a0_.shortname = 'privatepolicecookies' AND a0_.deleted = 0;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.content AS content_2,
  a0_.defaultimage AS defaultimage_3,
  a0_.shortname AS shortname_4,
  a0_.description AS description_5,
  a0_.defaulturl AS defaulturl_6,
  a0_.customcss AS customcss_7,
  a0_.customjs AS customjs_8,
  a1_.id AS id_9,
  a1_.name AS name_10,
  a1_.content AS content_11,
  a1_.customcss AS customcss_12,
  a1_.customjs AS customjs_13,
  a0_.dtype AS dtype_14,
  a0_.btype AS btype_15
FROM
  admin_cms_resource a0_
  INNER JOIN admin_cms_resource_repository a2_ ON a0_.repositoryid = a2_.id
  INNER JOIN admin_cms_resource_status a3_ ON a0_.statusid = a3_.id
  INNER JOIN admin_cms_resource_template a1_ ON a0_.templateid = a1_.id
  INNER JOIN admin_cms_resource_structure a4_ ON a0_.structureid = a4_.id
WHERE
  a0_.entity = ?
  AND a2_.shortname = 'badiutmscorestudentfviewdefault'
  AND a3_.shortname = 'approval'
  AND a0_.dtype = 'content'
  AND a0_.btype = 'card'
  AND a4_.shortname = 'news'
  AND a0_.deleted = 0
ORDER BY
  a0_.sortorder ASC
LIMIT
  6

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.content AS content_2, a0_.defaultimage AS defaultimage_3, a0_.shortname AS shortname_4, a0_.description AS description_5, a0_.defaulturl AS defaulturl_6, a0_.customcss AS customcss_7, a0_.customjs AS customjs_8, a1_.id AS id_9, a1_.name AS name_10, a1_.content AS content_11, a1_.customcss AS customcss_12, a1_.customjs AS customjs_13, a0_.dtype AS dtype_14, a0_.btype AS btype_15 FROM admin_cms_resource a0_ INNER JOIN admin_cms_resource_repository a2_ ON a0_.repositoryid = a2_.id INNER JOIN admin_cms_resource_status a3_ ON a0_.statusid = a3_.id INNER JOIN admin_cms_resource_template a1_ ON a0_.templateid = a1_.id INNER JOIN admin_cms_resource_structure a4_ ON a0_.structureid = a4_.id WHERE a0_.entity = '1' AND a2_.shortname = 'badiutmscorestudentfviewdefault' AND a3_.shortname = 'approval' AND a0_.dtype = 'content' AND a0_.btype = 'card' AND a4_.shortname = 'news' AND a0_.deleted = 0 ORDER BY a0_.sortorder ASC LIMIT 6;

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
  500

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 13:53:22') AND (a0_.timeend IS NULL OR a0_.timeend >= '2025-07-30 13:53:22') ORDER BY a0_.timestart DESC LIMIT 500;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.defaultimage AS defaultimage_3,
  a0_.timestart AS timestart_4,
  a0_.timeend AS timeend_5,
  a1_.shortname AS shortname_6,
  a0_.enablecertificate AS enablecertificate_7,
  a0_.certificatetempleid AS certificatetempleid_8,
  a0_.dconfig AS dconfig_9,
  a2_.name AS name_10,
  a2_.id AS id_11,
  a2_.dhour AS dhour_12,
  a2_.defaultimage AS defaultimage_13,
  a2_.summary AS summary_14,
  a2_.usertarget AS usertarget_15,
  a3_.name AS name_16,
  a3_.id AS id_17,
  a4_.shortname AS shortname_18,
  a4_.name AS name_19,
  a4_.enable AS enable_20,
  a4_.lmssyncenable AS lmssyncenable_21,
  a4_.enableaccesslms AS enableaccesslms_22,
  a5_.name AS name_23,
  a6_.timestart AS timestart_24,
  a6_.timeend AS timeend_25,
  a6_.lmssync AS lmssync_26,
  a6_.id AS id_27,
  a7_.id AS id_28,
  a0_.lmsaccesstimestart AS lmsaccesstimestart_29,
  a0_.lmsaccesstimeend AS lmsaccesstimeend_30,
  a6_.lmsaccesstimestart AS lmsaccesstimestart_31,
  a6_.lmsaccesstimeend AS lmsaccesstimeend_32,
  a7_.lmsaccesstimestart AS lmsaccesstimestart_33,
  a7_.lmsaccesstimeend AS lmsaccesstimeend_34,
  (
    SELECT
      a8_.grade
    FROM
      admin_grade a8_
      INNER JOIN admin_grade_item a9_ ON a8_.itemid = a9_.id
    WHERE
      a9_.moduleinstance = a0_.id
      AND a9_.modulekey = 'badiu.ams.offer.classe'
      AND a9_.itemtype = 'progress'
      AND a6_.userid = a8_.userid
  ) AS sclr_35,
  (
    SELECT
      a10_.dconfig
    FROM
      admin_grade a10_
      INNER JOIN admin_grade_item a11_ ON a10_.itemid = a11_.id
    WHERE
      a11_.moduleinstance = a0_.id
      AND a11_.modulekey = 'badiu.ams.offer.classe'
      AND a11_.itemtype = 'progress'
      AND a6_.userid = a10_.userid
  ) AS sclr_36,
  (
    SELECT
      a12_.grade
    FROM
      admin_grade a12_
      INNER JOIN admin_grade_item a13_ ON a12_.itemid = a13_.id
    WHERE
      a13_.moduleinstance = a0_.id
      AND a13_.modulekey = 'badiu.ams.offer.classe'
      AND a13_.itemtype = 'finalgrade'
      AND a6_.userid = a12_.userid
  ) AS sclr_37,
  (
    SELECT
      a14_.skey
    FROM
      admin_certificate a14_
    WHERE
      a14_.moduleinstance = a0_.id
      AND a14_.modulekey = 'badiu.ams.enrol.classe'
      AND a14_.dtype = 'default'
      AND a6_.userid = a14_.userid
  ) AS sclr_38
FROM
  ams_enrol_classe a6_
  INNER JOIN ams_role a5_ ON a6_.roleid = a5_.id
  INNER JOIN ams_enrol_status a4_ ON a6_.statusid = a4_.id
  INNER JOIN ams_offer_classe a0_ ON a6_.classeid = a0_.id
  INNER JOIN ams_offer_classe_status a1_ ON a0_.statusid = a1_.id
  INNER JOIN ams_offer_discipline a7_ ON a0_.odisciplineid = a7_.id
  INNER JOIN ams_discipline a2_ ON a7_.disciplineid = a2_.id
  INNER JOIN ams_discipline_cetegory a3_ ON a2_.categoryid = a3_.id
  INNER JOIN ams_offer a15_ ON a7_.offerid = a15_.id
  LEFT JOIN ams_course a16_ ON a15_.courseid = a16_.id
WHERE
  a15_.shortname = 'tmsdefaultcourseoffer'
  AND a2_.dtype = 'training'
  AND a6_.entity = ?
  AND a6_.userid = ?
  AND a6_.deleted = 0
  AND a0_.deleted = 0
  AND a7_.deleted = 0
  AND a15_.deleted = 0
  AND a2_.deleted = 0
  AND a3_.deleted = 0
ORDER BY
  a0_.timestart DESC
LIMIT
  500

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.defaultimage AS defaultimage_3, a0_.timestart AS timestart_4, a0_.timeend AS timeend_5, a1_.shortname AS shortname_6, a0_.enablecertificate AS enablecertificate_7, a0_.certificatetempleid AS certificatetempleid_8, a0_.dconfig AS dconfig_9, a2_.name AS name_10, a2_.id AS id_11, a2_.dhour AS dhour_12, a2_.defaultimage AS defaultimage_13, a2_.summary AS summary_14, a2_.usertarget AS usertarget_15, a3_.name AS name_16, a3_.id AS id_17, a4_.shortname AS shortname_18, a4_.name AS name_19, a4_.enable AS enable_20, a4_.lmssyncenable AS lmssyncenable_21, a4_.enableaccesslms AS enableaccesslms_22, a5_.name AS name_23, a6_.timestart AS timestart_24, a6_.timeend AS timeend_25, a6_.lmssync AS lmssync_26, a6_.id AS id_27, a7_.id AS id_28, a0_.lmsaccesstimestart AS lmsaccesstimestart_29, a0_.lmsaccesstimeend AS lmsaccesstimeend_30, a6_.lmsaccesstimestart AS lmsaccesstimestart_31, a6_.lmsaccesstimeend AS lmsaccesstimeend_32, a7_.lmsaccesstimestart AS lmsaccesstimestart_33, a7_.lmsaccesstimeend AS lmsaccesstimeend_34, (SELECT a8_.grade FROM admin_grade a8_ INNER JOIN admin_grade_item a9_ ON a8_.itemid = a9_.id WHERE a9_.moduleinstance = a0_.id AND a9_.modulekey = 'badiu.ams.offer.classe' AND a9_.itemtype = 'progress' AND a6_.userid = a8_.userid) AS sclr_35, (SELECT a10_.dconfig FROM admin_grade a10_ INNER JOIN admin_grade_item a11_ ON a10_.itemid = a11_.id WHERE a11_.moduleinstance = a0_.id AND a11_.modulekey = 'badiu.ams.offer.classe' AND a11_.itemtype = 'progress' AND a6_.userid = a10_.userid) AS sclr_36, (SELECT a12_.grade FROM admin_grade a12_ INNER JOIN admin_grade_item a13_ ON a12_.itemid = a13_.id WHERE a13_.moduleinstance = a0_.id AND a13_.modulekey = 'badiu.ams.offer.classe' AND a13_.itemtype = 'finalgrade' AND a6_.userid = a12_.userid) AS sclr_37, (SELECT a14_.skey FROM admin_certificate a14_ WHERE a14_.moduleinstance = a0_.id AND a14_.modulekey = 'badiu.ams.enrol.classe' AND a14_.dtype = 'default' AND a6_.userid = a14_.userid) AS sclr_38 FROM ams_enrol_classe a6_ INNER JOIN ams_role a5_ ON a6_.roleid = a5_.id INNER JOIN ams_enrol_status a4_ ON a6_.statusid = a4_.id INNER JOIN ams_offer_classe a0_ ON a6_.classeid = a0_.id INNER JOIN ams_offer_classe_status a1_ ON a0_.statusid = a1_.id INNER JOIN ams_offer_discipline a7_ ON a0_.odisciplineid = a7_.id INNER JOIN ams_discipline a2_ ON a7_.disciplineid = a2_.id INNER JOIN ams_discipline_cetegory a3_ ON a2_.categoryid = a3_.id INNER JOIN ams_offer a15_ ON a7_.offerid = a15_.id LEFT JOIN ams_course a16_ ON a15_.courseid = a16_.id WHERE a15_.shortname = 'tmsdefaultcourseoffer' AND a2_.dtype = 'training' AND a6_.entity = '1' AND a6_.userid = '2' AND a6_.deleted = 0 AND a0_.deleted = 0 AND a7_.deleted = 0 AND a15_.deleted = 0 AND a2_.deleted = 0 AND a3_.deleted = 0 ORDER BY a0_.timestart DESC LIMIT 500;

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 ams_offer_status a5_ ON a0_.statusid = a5_.id
  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 a5_.shortname = 'active'
  AND a0_.entity = ?
  AND a0_.deleted = 0
ORDER BY
  a0_.timecreated DESC
LIMIT
  500

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 ams_offer_status a5_ ON a0_.statusid = a5_.id 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 a5_.shortname = 'active' AND a0_.entity = '1' AND a0_.deleted = 0 ORDER BY a0_.timecreated DESC LIMIT 500;

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 = ?
  AND a1_.deleted = 0
  AND a2_.deleted = 0
LIMIT
  1