Symfony Profiler

SELECT
  i0_.id_ind AS id_ind_0,
  i0_.title AS title_1,
  i0_.fname AS fname_2,
  i0_.mname AS mname_3,
  i0_.sname AS sname_4,
  i0_.identifier AS identifier_5,
  i0_.reg_type AS reg_type_6,
  i0_.use_inst_addr AS use_inst_addr_7,
  i0_.private_address AS private_address_8,
  i0_.addr_1 AS addr_1_9,
  i0_.addr_2 AS addr_2_10,
  i0_.city AS city_11,
  i0_.state AS state_12,
  i0_.postcode AS postcode_13,
  i0_.country_code AS country_code_14,
  i0_.id_nationality AS id_nationality_15,
  i0_.gender AS gender_16,
  i0_.tel AS tel_17,
  i0_.fax AS fax_18,
  i0_.email1 AS email1_19,
  i0_.email2 AS email2_20,
  i0_.email3 AS email3_21,
  i0_.emailtouse AS emailtouse_22,
  i0_.url1 AS url1_23,
  i0_.url1Valid AS url1Valid_24,
  i0_.url2 AS url2_25,
  i0_.url2Valid AS url2Valid_26,
  i0_.url3 AS url3_27,
  i0_.url3Valid AS url3Valid_28,
  i0_.urlsChecked AS urlsChecked_29,
  i0_.linkedin AS linkedin_30,
  i0_.facebook AS facebook_31,
  i0_.twitter AS twitter_32,
  i0_.flickr AS flickr_33,
  i0_.other AS other_34,
  i0_.degree AS degree_35,
  i0_.activeng AS activeng_36,
  i0_.activother AS activother_37,
  i0_.jobtitle AS jobtitle_38,
  i0_.dept AS dept_39,
  i0_.studyregion AS studyregion_40,
  i0_.languages AS languages_41,
  i0_.skills AS skills_42,
  i0_.comments AS comments_43,
  i0_.do_not_invite AS do_not_invite_44,
  i0_.do_no_invite_by AS do_no_invite_by_45,
  i0_.do_no_invite_on AS do_no_invite_on_46,
  i0_.admin_comments AS admin_comments_47,
  i0_.id_imagefile AS id_imagefile_48,
  i0_.id_imagefile_full AS id_imagefile_full_49,
  i0_.receive_mail AS receive_mail_50,
  i0_.member_alert AS member_alert_51,
  i0_.cit_alert AS cit_alert_52,
  i0_.f_date_ent AS f_date_ent_53,
  i0_.l_date_upd AS l_date_upd_54,
  i0_.created_by AS created_by_55,
  i0_.last_edit_by AS last_edit_by_56,
  i0_.quality_checked_by AS quality_checked_by_57,
  i0_.quality_checked_date AS quality_checked_date_58,
  i0_.quality_checked AS quality_checked_59,
  i0_.is_global AS is_global_60,
  i0_.status AS status_61,
  i0_.statusLastChanged AS statusLastChanged_62,
  i0_.deceased AS deceased_63,
  i0_.deceased_date AS deceased_date_64,
  i0_.retired AS retired_65,
  i0_.retired_date AS retired_date_66,
  i0_.id AS id_67,
  p1_.name AS name_68,
  p1_.path AS path_69,
  i2_.id_inst AS id_inst_70,
  i2_.inst_name AS inst_name_71,
  i2_.country_code AS country_code_72,
  i2_.state AS state_73,
  i2_.city AS city_74,
  i2_.postcode AS postcode_75,
  i2_.inst_address AS inst_address_76,
  i2_.addr_2 AS addr_2_77
FROM
  indiv i0_
  LEFT JOIN profile_images p1_ ON (p1_.id_ind = i0_.id_ind)
  LEFT JOIN indiv_institution i3_ ON (i0_.id_ind = i3_.id_ind)
  LEFT JOIN institutions i2_ ON (i3_.id_inst = i2_.id_inst)
WHERE
  i0_.id_ind = ?
  AND i0_.status = 1

SELECT i0_.id_ind AS id_ind_0, i0_.title AS title_1, i0_.fname AS fname_2, i0_.mname AS mname_3, i0_.sname AS sname_4, i0_.identifier AS identifier_5, i0_.reg_type AS reg_type_6, i0_.use_inst_addr AS use_inst_addr_7, i0_.private_address AS private_address_8, i0_.addr_1 AS addr_1_9, i0_.addr_2 AS addr_2_10, i0_.city AS city_11, i0_.state AS state_12, i0_.postcode AS postcode_13, i0_.country_code AS country_code_14, i0_.id_nationality AS id_nationality_15, i0_.gender AS gender_16, i0_.tel AS tel_17, i0_.fax AS fax_18, i0_.email1 AS email1_19, i0_.email2 AS email2_20, i0_.email3 AS email3_21, i0_.emailtouse AS emailtouse_22, i0_.url1 AS url1_23, i0_.url1Valid AS url1Valid_24, i0_.url2 AS url2_25, i0_.url2Valid AS url2Valid_26, i0_.url3 AS url3_27, i0_.url3Valid AS url3Valid_28, i0_.urlsChecked AS urlsChecked_29, i0_.linkedin AS linkedin_30, i0_.facebook AS facebook_31, i0_.twitter AS twitter_32, i0_.flickr AS flickr_33, i0_.other AS other_34, i0_.degree AS degree_35, i0_.activeng AS activeng_36, i0_.activother AS activother_37, i0_.jobtitle AS jobtitle_38, i0_.dept AS dept_39, i0_.studyregion AS studyregion_40, i0_.languages AS languages_41, i0_.skills AS skills_42, i0_.comments AS comments_43, i0_.do_not_invite AS do_not_invite_44, i0_.do_no_invite_by AS do_no_invite_by_45, i0_.do_no_invite_on AS do_no_invite_on_46, i0_.admin_comments AS admin_comments_47, i0_.id_imagefile AS id_imagefile_48, i0_.id_imagefile_full AS id_imagefile_full_49, i0_.receive_mail AS receive_mail_50, i0_.member_alert AS member_alert_51, i0_.cit_alert AS cit_alert_52, i0_.f_date_ent AS f_date_ent_53, i0_.l_date_upd AS l_date_upd_54, i0_.created_by AS created_by_55, i0_.last_edit_by AS last_edit_by_56, i0_.quality_checked_by AS quality_checked_by_57, i0_.quality_checked_date AS quality_checked_date_58, i0_.quality_checked AS quality_checked_59, i0_.is_global AS is_global_60, i0_.status AS status_61, i0_.statusLastChanged AS statusLastChanged_62, i0_.deceased AS deceased_63, i0_.deceased_date AS deceased_date_64, i0_.retired AS retired_65, i0_.retired_date AS retired_date_66, i0_.id AS id_67, p1_.name AS name_68, p1_.path AS path_69, i2_.id_inst AS id_inst_70, i2_.inst_name AS inst_name_71, i2_.country_code AS country_code_72, i2_.state AS state_73, i2_.city AS city_74, i2_.postcode AS postcode_75, i2_.inst_address AS inst_address_76, i2_.addr_2 AS addr_2_77 FROM indiv i0_ LEFT JOIN profile_images p1_ ON (p1_.id_ind = i0_.id_ind) LEFT JOIN indiv_institution i3_ ON (i0_.id_ind = i3_.id_ind) LEFT JOIN institutions i2_ ON (i3_.id_inst = i2_.id_inst) WHERE i0_.id_ind = '3450' AND i0_.status = 1;

SELECT
  i0_.meta_option AS meta_option_0,
  i0_.meta_value AS meta_value_1
FROM
  indiv_meta i0_
WHERE
  i0_.indiv_id = ?

SELECT i0_.meta_option AS meta_option_0, i0_.meta_value AS meta_value_1 FROM indiv_meta i0_ WHERE i0_.indiv_id = 3450;

SELECT
  j0_.jobname AS jobname_0,
  j0_.id_job AS id_job_1
FROM
  indiv_jobtype i1_
  LEFT JOIN jobtypes j0_ ON (j0_.id_job = i1_.id_job)
WHERE
  i1_.id_ind = ?

SELECT j0_.jobname AS jobname_0, j0_.id_job AS id_job_1 FROM indiv_jobtype i1_ LEFT JOIN jobtypes j0_ ON (j0_.id_job = i1_.id_job) WHERE i1_.id_ind = 3450;

SELECT
  g0_.groupname AS groupname_0,
  g0_.id_group AS id_group_1
FROM
  member_groups m1_
  LEFT JOIN
groups
  g0_ ON (m1_.id_group = g0_.id_group)
WHERE
  m1_.id_ind = ?
ORDER BY
  g0_.groupname ASC

SELECT g0_.groupname AS groupname_0, g0_.id_group AS id_group_1 FROM member_groups m1_ LEFT JOIN groups g0_ ON (m1_.id_group = g0_.id_group) WHERE m1_.id_ind = '3450' ORDER BY g0_.groupname ASC;

SELECT
  t0.country AS country_1,
  t0.postcode_pos AS postcode_pos_2,
  t0.postcode_spacer AS postcode_spacer_3,
  t0.country_code AS country_code_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.unesco_member AS unesco_member_7,
  t0.ioc_member AS ioc_member_8,
  t0.is_executive AS is_executive_9,
  t0.id_country AS id_country_10
FROM
  countries t0
WHERE
  t0.id_country = ?
LIMIT
  1

SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.unesco_member AS unesco_member_7, t0.ioc_member AS ioc_member_8, t0.is_executive AS is_executive_9, t0.id_country AS id_country_10 FROM countries t0 WHERE t0.id_country = 21 LIMIT 1;

SELECT
  c0_.country AS country_0,
  c0_.country_code AS country_code_1,
  c0_.longitude AS longitude_2,
  c0_.latitude AS latitude_3
FROM
  countries c0_
WHERE
  c0_.id_country IN (?)
  OR c0_.country_code IN (?)

SELECT c0_.country AS country_0, c0_.country_code AS country_code_1, c0_.longitude AS longitude_2, c0_.latitude AS latitude_3 FROM countries c0_ WHERE c0_.id_country IN ('BE') OR c0_.country_code IN ('BE');

SELECT
  t0.languagename AS languagename_1,
  t0.languagecode AS languagecode_2,
  t0.id_language AS id_language_3
FROM
  languages t0

SELECT t0.languagename AS languagename_1, t0.languagecode AS languagecode_2, t0.id_language AS id_language_3 FROM languages t0;

SELECT
  j0_.jobname AS jobname_0
FROM
  jobtypes j0_
WHERE
  j0_.id_job IN (?)

SELECT j0_.jobname AS jobname_0 FROM jobtypes j0_ WHERE j0_.id_job IN ('IOC consultant');

SELECT
  s0_.subname AS subname_0,
  s0_.id_sub AS id_sub_1
FROM
  indiv_subjects i1_
  LEFT JOIN subjects s0_ ON (s0_.id_sub = i1_.id_sub)
WHERE
  i1_.id_ind = ?

SELECT s0_.subname AS subname_0, s0_.id_sub AS id_sub_1 FROM indiv_subjects i1_ LEFT JOIN subjects s0_ ON (s0_.id_sub = i1_.id_sub) WHERE i1_.id_ind = 3450;

SELECT
  i0_.id_sub AS id_sub_0
FROM
  indiv_subjects i0_
WHERE
  i0_.id_ind = ?

SELECT i0_.id_sub AS id_sub_0 FROM indiv_subjects i0_ WHERE i0_.id_ind = 3450;

SELECT
  c0_.country AS country_0,
  c0_.country_code AS country_code_1,
  c0_.longitude AS longitude_2,
  c0_.latitude AS latitude_3
FROM
  countries c0_
WHERE
  c0_.id_country IN (?)
  OR c0_.country_code IN (?)

SELECT c0_.country AS country_0, c0_.country_code AS country_code_1, c0_.longitude AS longitude_2, c0_.latitude AS latitude_3 FROM countries c0_ WHERE c0_.id_country IN ('13') OR c0_.country_code IN ('13');

SELECT
  s0_.name AS name_0
FROM
  searegions s0_
WHERE
  s0_.id_searegion IN (?)

SELECT s0_.name AS name_0 FROM searegions s0_ WHERE s0_.id_searegion IN ('');

SELECT
  t0.id_ind AS id_ind_1,
  t0.title AS title_2,
  t0.fname AS fname_3,
  t0.mname AS mname_4,
  t0.sname AS sname_5,
  t0.identifier AS identifier_6,
  t0.reg_type AS reg_type_7,
  t0.use_inst_addr AS use_inst_addr_8,
  t0.private_address AS private_address_9,
  t0.addr_1 AS addr_1_10,
  t0.addr_2 AS addr_2_11,
  t0.city AS city_12,
  t0.state AS state_13,
  t0.postcode AS postcode_14,
  t0.country_code AS country_code_15,
  t0.id_nationality AS id_nationality_16,
  t0.gender AS gender_17,
  t0.tel AS tel_18,
  t0.fax AS fax_19,
  t0.email1 AS email1_20,
  t0.email2 AS email2_21,
  t0.email3 AS email3_22,
  t0.emailtouse AS emailtouse_23,
  t0.url1 AS url1_24,
  t0.url1Valid AS url1Valid_25,
  t0.url2 AS url2_26,
  t0.url2Valid AS url2Valid_27,
  t0.url3 AS url3_28,
  t0.url3Valid AS url3Valid_29,
  t0.urlsChecked AS urlsChecked_30,
  t0.linkedin AS linkedin_31,
  t0.facebook AS facebook_32,
  t0.twitter AS twitter_33,
  t0.flickr AS flickr_34,
  t0.other AS other_35,
  t0.degree AS degree_36,
  t0.activeng AS activeng_37,
  t0.activother AS activother_38,
  t0.jobtitle AS jobtitle_39,
  t0.dept AS dept_40,
  t0.studyregion AS studyregion_41,
  t0.languages AS languages_42,
  t0.skills AS skills_43,
  t0.comments AS comments_44,
  t0.do_not_invite AS do_not_invite_45,
  t0.do_no_invite_by AS do_no_invite_by_46,
  t0.do_no_invite_on AS do_no_invite_on_47,
  t0.admin_comments AS admin_comments_48,
  t0.id_imagefile AS id_imagefile_49,
  t0.id_imagefile_full AS id_imagefile_full_50,
  t0.receive_mail AS receive_mail_51,
  t0.member_alert AS member_alert_52,
  t0.cit_alert AS cit_alert_53,
  t0.f_date_ent AS f_date_ent_54,
  t0.l_date_upd AS l_date_upd_55,
  t0.created_by AS created_by_56,
  t0.last_edit_by AS last_edit_by_57,
  t0.quality_checked_by AS quality_checked_by_58,
  t0.quality_checked_date AS quality_checked_date_59,
  t0.quality_checked AS quality_checked_60,
  t0.is_global AS is_global_61,
  t0.status AS status_62,
  t0.statusLastChanged AS statusLastChanged_63,
  t0.deceased AS deceased_64,
  t0.deceased_date AS deceased_date_65,
  t0.retired AS retired_66,
  t0.retired_date AS retired_date_67,
  t0.id AS id_68
FROM
  indiv t0
WHERE
  t0.id_ind = ?
LIMIT
  1

SELECT t0.id_ind AS id_ind_1, t0.title AS title_2, t0.fname AS fname_3, t0.mname AS mname_4, t0.sname AS sname_5, t0.identifier AS identifier_6, t0.reg_type AS reg_type_7, t0.use_inst_addr AS use_inst_addr_8, t0.private_address AS private_address_9, t0.addr_1 AS addr_1_10, t0.addr_2 AS addr_2_11, t0.city AS city_12, t0.state AS state_13, t0.postcode AS postcode_14, t0.country_code AS country_code_15, t0.id_nationality AS id_nationality_16, t0.gender AS gender_17, t0.tel AS tel_18, t0.fax AS fax_19, t0.email1 AS email1_20, t0.email2 AS email2_21, t0.email3 AS email3_22, t0.emailtouse AS emailtouse_23, t0.url1 AS url1_24, t0.url1Valid AS url1Valid_25, t0.url2 AS url2_26, t0.url2Valid AS url2Valid_27, t0.url3 AS url3_28, t0.url3Valid AS url3Valid_29, t0.urlsChecked AS urlsChecked_30, t0.linkedin AS linkedin_31, t0.facebook AS facebook_32, t0.twitter AS twitter_33, t0.flickr AS flickr_34, t0.other AS other_35, t0.degree AS degree_36, t0.activeng AS activeng_37, t0.activother AS activother_38, t0.jobtitle AS jobtitle_39, t0.dept AS dept_40, t0.studyregion AS studyregion_41, t0.languages AS languages_42, t0.skills AS skills_43, t0.comments AS comments_44, t0.do_not_invite AS do_not_invite_45, t0.do_no_invite_by AS do_no_invite_by_46, t0.do_no_invite_on AS do_no_invite_on_47, t0.admin_comments AS admin_comments_48, t0.id_imagefile AS id_imagefile_49, t0.id_imagefile_full AS id_imagefile_full_50, t0.receive_mail AS receive_mail_51, t0.member_alert AS member_alert_52, t0.cit_alert AS cit_alert_53, t0.f_date_ent AS f_date_ent_54, t0.l_date_upd AS l_date_upd_55, t0.created_by AS created_by_56, t0.last_edit_by AS last_edit_by_57, t0.quality_checked_by AS quality_checked_by_58, t0.quality_checked_date AS quality_checked_date_59, t0.quality_checked AS quality_checked_60, t0.is_global AS is_global_61, t0.status AS status_62, t0.statusLastChanged AS statusLastChanged_63, t0.deceased AS deceased_64, t0.deceased_date AS deceased_date_65, t0.retired AS retired_66, t0.retired_date AS retired_date_67, t0.id AS id_68 FROM indiv t0 WHERE t0.id_ind = 0 LIMIT 1;

SELECT
  m0_.id_group AS id_group_0
FROM
  member_groups m0_
WHERE
  m0_.id_ind = ?

SELECT m0_.id_group AS id_group_0 FROM member_groups m0_ WHERE m0_.id_ind = '3450';

SELECT
  m0_.id_country AS id_country_0
FROM
  member_edits_country m0_
WHERE
  m0_.id_ind = ?

SELECT m0_.id_country AS id_country_0 FROM member_edits_country m0_ WHERE m0_.id_ind = '3450';

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.email_canonical AS email_canonical_3,
  t0.username AS username_4,
  t0.username_canonical AS username_canonical_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.enabled AS enabled_10,
  t0.confirmation_token AS confirmation_token_11,
  t0.password_requested_at AS password_requested_at_12,
  t0.salt AS salt_13,
  t0.locked AS locked_14,
  t0.expired AS expired_15,
  t0.credentials_expired AS credentials_expired_16
FROM
  fos_user t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.email_canonical AS email_canonical_3, t0.username AS username_4, t0.username_canonical AS username_canonical_5, t0.roles AS roles_6, t0.password AS password_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.enabled AS enabled_10, t0.confirmation_token AS confirmation_token_11, t0.password_requested_at AS password_requested_at_12, t0.salt AS salt_13, t0.locked AS locked_14, t0.expired AS expired_15, t0.credentials_expired AS credentials_expired_16 FROM fos_user t0 WHERE t0.id = '3450' LIMIT 1;

SELECT
  t0.country AS country_1,
  t0.postcode_pos AS postcode_pos_2,
  t0.postcode_spacer AS postcode_spacer_3,
  t0.country_code AS country_code_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.unesco_member AS unesco_member_7,
  t0.ioc_member AS ioc_member_8,
  t0.is_executive AS is_executive_9,
  t0.id_country AS id_country_10
FROM
  countries t0
ORDER BY
  t0.country ASC

SELECT t0.country AS country_1, t0.postcode_pos AS postcode_pos_2, t0.postcode_spacer AS postcode_spacer_3, t0.country_code AS country_code_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.unesco_member AS unesco_member_7, t0.ioc_member AS ioc_member_8, t0.is_executive AS is_executive_9, t0.id_country AS id_country_10 FROM countries t0 ORDER BY t0.country ASC;

SELECT
  t0.groupname AS groupname_1,
  t0.description AS description_2,
  t0.id_parentgroup AS id_parentgroup_3,
  t0.group_order AS group_order_4,
  t0.has_site AS has_site_5,
  t0.url AS url_6,
  t0.official_body AS official_body_7,
  t0.id_mstemplate AS id_mstemplate_8,
  t0.id_group AS id_group_9
FROM
groups
  t0
ORDER BY
  t0.groupname ASC

SELECT t0.groupname AS groupname_1, t0.description AS description_2, t0.id_parentgroup AS id_parentgroup_3, t0.group_order AS group_order_4, t0.has_site AS has_site_5, t0.url AS url_6, t0.official_body AS official_body_7, t0.id_mstemplate AS id_mstemplate_8, t0.id_group AS id_group_9 FROM groups t0 ORDER BY t0.groupname ASC;

SELECT
  e0_.id_event AS id_event_0
FROM
  event_participants e0_
WHERE
  e0_.id_ind = ?

SELECT e0_.id_event AS id_event_0 FROM event_participants e0_ WHERE e0_.id_ind = 3450;

SELECT
  e0_.id_event AS id_event_0
FROM
  event_contacts e0_
WHERE
  e0_.id_ind = ?

SELECT e0_.id_event AS id_event_0 FROM event_contacts e0_ WHERE e0_.id_ind = 3450;

SELECT
  e0_.id_event AS id_event_0
FROM
  event_staff e0_
WHERE
  e0_.id_ind = ?

SELECT e0_.id_event AS id_event_0 FROM event_staff e0_ WHERE e0_.id_ind = 3450;

SELECT
  e0_.id_event AS id_event_0,
  e0_.title AS title_1,
  e0_.id_eventtype AS id_eventtype_2,
  e0_.start_on AS start_on_3,
  e0_.end_on AS end_on_4,
  e0_.address AS address_5,
  e0_.city AS city_6,
  e0_.state AS state_7,
  e0_.postcode AS postcode_8,
  c1_.country AS country_9
FROM
  events e0_
  LEFT JOIN countries c1_ ON (e0_.id_country = c1_.id_country)
WHERE
  e0_.id_event IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
  AND e0_.status = 1
ORDER BY
  e0_.start_on DESC

SELECT e0_.id_event AS id_event_0, e0_.title AS title_1, e0_.id_eventtype AS id_eventtype_2, e0_.start_on AS start_on_3, e0_.end_on AS end_on_4, e0_.address AS address_5, e0_.city AS city_6, e0_.state AS state_7, e0_.postcode AS postcode_8, c1_.country AS country_9 FROM events e0_ LEFT JOIN countries c1_ ON (e0_.id_country = c1_.id_country) WHERE e0_.id_event IN (73, 81, 153, 155, 162, 175, 181, 187, 191, 241, 254, 267, 326, 336, 345, 357, 392, 415, 429, 455, 463, 464, 468, 492, 493, 502, 531, 557, 566, 584, 587, 594, 595, 596, 599, 622, 625, 626, 627, 645, 713, 838, 873, 896, 1018, 1019, 1020, 1022, 1023, 1054, 1074, 1085, 1087, 1090, 1134, 1165, 1198, 1217, 1229, 1233, 1270, 1271, 1276, 1311, 1331, 1332, 1357, 1381, 1396, 1415, 1473, 1488, 1494, 1495, 1542, 1579, 1612, 1623, 1625, 1670, 1684, 1703, 1715, 1727, 1730, 1785, 1809, 1889, 1916, 1941, 1875, 2021, 1982, 416, 592, 582, 583, 823, 1524, 1986, 2002, 2105, 1823, 2095, 2077, 2131, 1879, 2239, 2106, 2166, 2099, 2110, 2312, 2296, 2139, 2136, 2134, 2357, 2287, 2247, 2444, 2141, 2423, 2506, 2143, 2135, 2544, 2138, 2524, 2523, 2551, 2374, 2608, 2627, 2754, 2813, 2757, 2641, 2694, 2849, 2915, 2924, 2912, 2913, 2844, 3268, 3260, 3394, 3406, 3424, 3565, 3571, 3615, 3647, 3606, 3614, 3569, 3819, 3967, 3974, 3929, 3991, 3990, 3877, 4208, 4209, 4224, 4225, 4258, 4257, 4056, 15, 86, 266, 278, 281, 1862, 1905, 1929, 1930, 1931, 1944, 3386, 10, 42, 45, 46, 48, 51, 55, 69, 90, 92, 97, 151, 164, 340, 342, 601, 4664) AND e0_.status = 1 ORDER BY e0_.start_on DESC;