Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.topic_name AS topic_name_1,
  e0_.parent_topic_id AS parent_topic_id_2,
  e0_.consultancy_types AS consultancy_types_3,
  e0_.country_id AS country_id_4,
  e0_.coin_multiplier_value AS coin_multiplier_value_5,
  e0_.time_slot_multipliers AS time_slot_multipliers_6,
  e0_.min_lifetime_coins_balance AS min_lifetime_coins_balance_7,
  e0_.document_data AS document_data_8,
  e0_.course_plan_data AS course_plan_data_9,
  e0_.other_data AS other_data_10,
  e0_.session_data AS session_data_11,
  e0_.routine_data AS routine_data_12,
  e0_.topic_marker AS topic_marker_13,
  e0_.map_embed_iframe AS map_embed_iframe_14,
  e0_.benefits AS benefits_15,
  e0_.courses AS courses_16,
  e0_.departments AS departments_17,
  e0_.topic_summary_image AS topic_summary_image_18,
  e0_.is_event AS is_event_19,
  e0_.event_expired AS event_expired_20,
  e0_.is_parent AS is_parent_21,
  e0_.consultancy_enabled AS consultancy_enabled_22,
  e0_.only_bookable_by_admin AS only_bookable_by_admin_23,
  e0_.is_active AS is_active_24,
  e0_.meeting_type AS meeting_type_25,
  e0_.consultant_can_upload AS consultant_can_upload_26,
  e0_.primary_blog_id AS primary_blog_id_27,
  e0_.event_start_date AS event_start_date_28,
  e0_.event_start_date_ts AS event_start_date_ts_29,
  e0_.event_end_date AS event_end_date_30,
  e0_.event_end_date_ts AS event_end_date_ts_31,
  e0_.event_desc AS event_desc_32,
  e0_.topic_summary AS topic_summary_33,
  e0_.address AS address_34,
  e0_.location_string AS location_string_35,
  e0_.location_lat AS location_lat_36,
  e0_.location_long AS location_long_37,
  e0_.university_ranking AS university_ranking_38,
  e0_.topic_image AS topic_image_39,
  e0_.edit_login_id AS edit_login_id_40,
  e0_.edit_flag AS edit_flag_41,
  e0_.delete_flag AS delete_flag_42,
  e0_.lock_flag AS lock_flag_43,
  e0_.refresh_flag AS refresh_flag_44,
  e0_.disabled_flag AS disabled_flag_45,
  e0_.created_login_id AS created_login_id_46,
  e0_.edited_login_id AS edited_login_id_47,
  e0_.created_sig_id AS created_sig_id_48,
  e0_.edited_sig_id AS edited_sig_id_49,
  e0_.last_modified_date AS last_modified_date_50,
  e0_.created_at AS created_at_51,
  e0_.updated_at AS updated_at_52,
  e0_.doc_booked_flag AS doc_booked_flag_53,
  e0_.time_stamp_of_form AS time_stamp_of_form_54
FROM
  entity_create_topic e0_
WHERE
  (
    (
      e0_.is_event = 0
      OR e0_.is_event IS NULL
    )
  )
  AND (
    e0_.topic_marker LIKE '%_country_%'
    OR e0_.topic_marker LIKE '%_university_%'
  )
  AND e0_.consultancy_enabled = 1
LIMIT
  100

SELECT e0_.id AS id_0, e0_.topic_name AS topic_name_1, e0_.parent_topic_id AS parent_topic_id_2, e0_.consultancy_types AS consultancy_types_3, e0_.country_id AS country_id_4, e0_.coin_multiplier_value AS coin_multiplier_value_5, e0_.time_slot_multipliers AS time_slot_multipliers_6, e0_.min_lifetime_coins_balance AS min_lifetime_coins_balance_7, e0_.document_data AS document_data_8, e0_.course_plan_data AS course_plan_data_9, e0_.other_data AS other_data_10, e0_.session_data AS session_data_11, e0_.routine_data AS routine_data_12, e0_.topic_marker AS topic_marker_13, e0_.map_embed_iframe AS map_embed_iframe_14, e0_.benefits AS benefits_15, e0_.courses AS courses_16, e0_.departments AS departments_17, e0_.topic_summary_image AS topic_summary_image_18, e0_.is_event AS is_event_19, e0_.event_expired AS event_expired_20, e0_.is_parent AS is_parent_21, e0_.consultancy_enabled AS consultancy_enabled_22, e0_.only_bookable_by_admin AS only_bookable_by_admin_23, e0_.is_active AS is_active_24, e0_.meeting_type AS meeting_type_25, e0_.consultant_can_upload AS consultant_can_upload_26, e0_.primary_blog_id AS primary_blog_id_27, e0_.event_start_date AS event_start_date_28, e0_.event_start_date_ts AS event_start_date_ts_29, e0_.event_end_date AS event_end_date_30, e0_.event_end_date_ts AS event_end_date_ts_31, e0_.event_desc AS event_desc_32, e0_.topic_summary AS topic_summary_33, e0_.address AS address_34, e0_.location_string AS location_string_35, e0_.location_lat AS location_lat_36, e0_.location_long AS location_long_37, e0_.university_ranking AS university_ranking_38, e0_.topic_image AS topic_image_39, e0_.edit_login_id AS edit_login_id_40, e0_.edit_flag AS edit_flag_41, e0_.delete_flag AS delete_flag_42, e0_.lock_flag AS lock_flag_43, e0_.refresh_flag AS refresh_flag_44, e0_.disabled_flag AS disabled_flag_45, e0_.created_login_id AS created_login_id_46, e0_.edited_login_id AS edited_login_id_47, e0_.created_sig_id AS created_sig_id_48, e0_.edited_sig_id AS edited_sig_id_49, e0_.last_modified_date AS last_modified_date_50, e0_.created_at AS created_at_51, e0_.updated_at AS updated_at_52, e0_.doc_booked_flag AS doc_booked_flag_53, e0_.time_stamp_of_form AS time_stamp_of_form_54 FROM entity_create_topic e0_ WHERE ((e0_.is_event = 0 OR e0_.is_event IS NULL)) AND (e0_.topic_marker LIKE '%_country_%' OR e0_.topic_marker LIKE '%_university_%') AND e0_.consultancy_enabled = 1 LIMIT 100;

SELECT
  DISTINCT current_country_id
FROM
  entity_applicant_details
WHERE
  is_consultant = 1

SELECT DISTINCT current_country_id FROM  entity_applicant_details   WHERE is_consultant=1;

SELECT
  t0.country_id AS country_id_1,
  t0.code AS code_2,
  t0.name_en AS name_en_3,
  t0.nationality_string AS nationality_string_4,
  t0.name_fr AS name_fr_5,
  t0.flag_image AS flag_image_6,
  t0.time_zone_str AS time_zone_str_7,
  t0.flag_image_square AS flag_image_square_8,
  t0.active_for_buddy_bee AS active_for_buddy_bee_9,
  t0.currency_id AS currency_id_10,
  t0.default_language_id AS default_language_id_11,
  t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_12,
  t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_13,
  t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_14,
  t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_15,
  t0.allowed_earning_per_day AS allowed_earning_per_day_16,
  t0.allowed_earning_per_week AS allowed_earning_per_week_17,
  t0.allowed_earning_per_month AS allowed_earning_per_month_18,
  t0.allowed_earning_per_year AS allowed_earning_per_year_19,
  t0.revenue_percentage_per_session AS revenue_percentage_per_session_20
FROM
  entity_countries t0
WHERE
  (
    t0.country_id IN (?)
    OR t0.country_id IS NULL
  )

SELECT t0.country_id AS country_id_1, t0.code AS code_2, t0.name_en AS name_en_3, t0.nationality_string AS nationality_string_4, t0.name_fr AS name_fr_5, t0.flag_image AS flag_image_6, t0.time_zone_str AS time_zone_str_7, t0.flag_image_square AS flag_image_square_8, t0.active_for_buddy_bee AS active_for_buddy_bee_9, t0.currency_id AS currency_id_10, t0.default_language_id AS default_language_id_11, t0.allowed_working_hours_per_day AS allowed_working_hours_per_day_12, t0.allowed_working_hours_per_week AS allowed_working_hours_per_week_13, t0.allowed_working_hours_per_month AS allowed_working_hours_per_month_14, t0.allowed_working_hours_per_year AS allowed_working_hours_per_year_15, t0.allowed_earning_per_day AS allowed_earning_per_day_16, t0.allowed_earning_per_week AS allowed_earning_per_week_17, t0.allowed_earning_per_month AS allowed_earning_per_month_18, t0.allowed_earning_per_year AS allowed_earning_per_year_19, t0.revenue_percentage_per_session AS revenue_percentage_per_session_20 FROM entity_countries t0 WHERE (t0.country_id IN ('0') OR t0.country_id IS NULL);

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.image AS image_4,
  t0.active_for_buddy_bee AS active_for_buddy_bee_5
FROM
  entity_languages t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.image AS image_4, t0.active_for_buddy_bee AS active_for_buddy_bee_5 FROM entity_languages t0;