Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.employee_code AS employee_code_2,
  t0.employee_name AS employee_name_3,
  t0.email AS email_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.mobile AS mobile_9,
  t0.avatar AS avatar_10,
  t0.token AS token_11,
  t0.token_date AS token_date_12,
  t0.last_login AS last_login_13,
  t0.email_verified AS email_verified_14,
  t0.mobile_verified AS mobile_verified_15,
  t0.enabled AS enabled_16,
  t0.date_of_birth AS date_of_birth_17,
  t0.gender AS gender_18,
  t0.display_name AS display_name_19,
  t0.type AS type_20,
  t0.phone AS phone_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.office_location_id AS office_location_id_24,
  t0.zone_id AS zone_id_25,
  t0.department_id AS department_id_26
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.employee_code AS employee_code_2, t0.employee_name AS employee_name_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.mobile AS mobile_9, t0.avatar AS avatar_10, t0.token AS token_11, t0.token_date AS token_date_12, t0.last_login AS last_login_13, t0.email_verified AS email_verified_14, t0.mobile_verified AS mobile_verified_15, t0.enabled AS enabled_16, t0.date_of_birth AS date_of_birth_17, t0.gender AS gender_18, t0.display_name AS display_name_19, t0.type AS type_20, t0.phone AS phone_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.office_location_id AS office_location_id_24, t0.zone_id AS zone_id_25, t0.department_id AS department_id_26 FROM user t0 WHERE t0.id = 2;

SELECT
  t0.user_id AS user_id_1,
  t0.module_id AS module_id_2,
  t0.permission_id AS permission_id_3
FROM
  user_permission t0
WHERE
  t0.user_id = ?

SELECT t0.user_id AS user_id_1, t0.module_id AS module_id_2, t0.permission_id AS permission_id_3 FROM user_permission t0 WHERE t0.user_id = 2;

SELECT
  u0_.id AS id_0,
  u0_.employee_code AS employee_code_1,
  u0_.employee_name AS employee_name_2,
  u0_.email AS email_3,
  u0_.roles AS roles_4,
  u0_.password AS password_5,
  u0_.first_name AS first_name_6,
  u0_.last_name AS last_name_7,
  u0_.mobile AS mobile_8,
  u0_.avatar AS avatar_9,
  u0_.token AS token_10,
  u0_.token_date AS token_date_11,
  u0_.last_login AS last_login_12,
  u0_.email_verified AS email_verified_13,
  u0_.mobile_verified AS mobile_verified_14,
  u0_.enabled AS enabled_15,
  u0_.date_of_birth AS date_of_birth_16,
  u0_.gender AS gender_17,
  u0_.display_name AS display_name_18,
  u0_.type AS type_19,
  u0_.phone AS phone_20,
  u0_.created_at AS created_at_21,
  u0_.updated_at AS updated_at_22,
  u0_.office_location_id AS office_location_id_23,
  u0_.zone_id AS zone_id_24,
  u0_.department_id AS department_id_25
FROM
  user u0_
  INNER JOIN department d1_ ON u0_.department_id = d1_.id
WHERE
  (
    u0_.roles LIKE ?
    OR u0_.roles LIKE ?
    OR u0_.roles LIKE ?
  )
  AND d1_.name = ?
ORDER BY
  CONCAT(
    u0_.first_name,
    CONCAT(' ', u0_.last_name)
  ) ASC

SELECT u0_.id AS id_0, u0_.employee_code AS employee_code_1, u0_.employee_name AS employee_name_2, u0_.email AS email_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.mobile AS mobile_8, u0_.avatar AS avatar_9, u0_.token AS token_10, u0_.token_date AS token_date_11, u0_.last_login AS last_login_12, u0_.email_verified AS email_verified_13, u0_.mobile_verified AS mobile_verified_14, u0_.enabled AS enabled_15, u0_.date_of_birth AS date_of_birth_16, u0_.gender AS gender_17, u0_.display_name AS display_name_18, u0_.type AS type_19, u0_.phone AS phone_20, u0_.created_at AS created_at_21, u0_.updated_at AS updated_at_22, u0_.office_location_id AS office_location_id_23, u0_.zone_id AS zone_id_24, u0_.department_id AS department_id_25 FROM user u0_ INNER JOIN department d1_ ON u0_.department_id = d1_.id WHERE (u0_.roles LIKE '%\"ROLE_ADMIN\"%' OR u0_.roles LIKE '%\"ROLE_MANAGER\"%' OR u0_.roles LIKE '%\"ROLE_USER\"%') AND d1_.name = 'Franchise Relations' ORDER BY CONCAT(u0_.first_name, CONCAT(' ', u0_.last_name)) ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  royalty_increment_type t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM royalty_increment_type t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.official_email AS official_email_4
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.official_email AS official_email_4 FROM department t0 WHERE t0.id = 13;

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.school_name AS school_name_1
FROM
  school s0_
WHERE
  s0_.school_status = ?
ORDER BY
  s0_.school_name ASC
LIMIT
  20

SELECT DISTINCT s0_.id AS id_0, s0_.school_name AS school_name_1 FROM school s0_ WHERE s0_.school_status = 0 ORDER BY s0_.school_name ASC LIMIT 20;

SELECT
  s0_.id AS id_0,
  s0_.brand_name AS brand_name_1,
  s0_.category AS category_2,
  s0_.school_name AS school_name_3,
  s0_.partner_name AS partner_name_4,
  s0_.trust_name AS trust_name_5,
  s0_.address AS address_6,
  s0_.location AS location_7,
  s0_.state AS state_8,
  s0_.pin_code AS pin_code_9,
  s0_.phone AS phone_10,
  s0_.radius AS radius_11,
  s0_.operational_year AS operational_year_12,
  s0_.royalty_rate AS royalty_rate_13,
  s0_.royalty_increment_percent AS royalty_increment_percent_14,
  s0_.royalty_increment_type AS royalty_increment_type_15,
  s0_.balance_amount AS balance_amount_16,
  s0_.agreement_date AS agreement_date_17,
  s0_.agreement_tenure AS agreement_tenure_18,
  s0_.agreement_expiry_date AS agreement_expiry_date_19,
  s0_.consultancy_fee_method AS consultancy_fee_method_20,
  s0_.active AS active_21,
  s0_.principal_email AS principal_email_22,
  s0_.partner_email AS partner_email_23,
  s0_.principal_mobile AS principal_mobile_24,
  s0_.partner_mobile AS partner_mobile_25,
  s0_.billing_name AS billing_name_26,
  s0_.billing_address AS billing_address_27,
  s0_.billing_city AS billing_city_28,
  s0_.billing_state AS billing_state_29,
  s0_.school_code AS school_code_30,
  s0_.board AS board_31,
  s0_.capacity_built_up AS capacity_built_up_32,
  s0_.capacity_operational AS capacity_operational_33,
  s0_.occupancy AS occupancy_34,
  s0_.session AS session_35,
  s0_.school_status AS school_status_36,
  s0_.frm_assigned_at AS frm_assigned_at_37,
  s0_.partner_welcome_email_sent_at AS partner_welcome_email_sent_at_38,
  s0_.publish_approval_status AS publish_approval_status_39,
  s0_.created_at AS created_at_40,
  s0_.updated_at AS updated_at_41,
  s0_.brand_id AS brand_id_42,
  s0_.zone_id AS zone_id_43,
  s0_.status_id AS status_id_44,
  s0_.countersigned_id AS countersigned_id_45,
  s0_.assignee_id AS assignee_id_46,
  s0_.lead_id AS lead_id_47,
  s0_.created_by AS created_by_48,
  s0_.updated_by AS updated_by_49
FROM
  school s0_
WHERE
  s0_.school_status = ?
  AND s0_.id IN (?, ?)
ORDER BY
  s0_.school_name ASC

SELECT s0_.id AS id_0, s0_.brand_name AS brand_name_1, s0_.category AS category_2, s0_.school_name AS school_name_3, s0_.partner_name AS partner_name_4, s0_.trust_name AS trust_name_5, s0_.address AS address_6, s0_.location AS location_7, s0_.state AS state_8, s0_.pin_code AS pin_code_9, s0_.phone AS phone_10, s0_.radius AS radius_11, s0_.operational_year AS operational_year_12, s0_.royalty_rate AS royalty_rate_13, s0_.royalty_increment_percent AS royalty_increment_percent_14, s0_.royalty_increment_type AS royalty_increment_type_15, s0_.balance_amount AS balance_amount_16, s0_.agreement_date AS agreement_date_17, s0_.agreement_tenure AS agreement_tenure_18, s0_.agreement_expiry_date AS agreement_expiry_date_19, s0_.consultancy_fee_method AS consultancy_fee_method_20, s0_.active AS active_21, s0_.principal_email AS principal_email_22, s0_.partner_email AS partner_email_23, s0_.principal_mobile AS principal_mobile_24, s0_.partner_mobile AS partner_mobile_25, s0_.billing_name AS billing_name_26, s0_.billing_address AS billing_address_27, s0_.billing_city AS billing_city_28, s0_.billing_state AS billing_state_29, s0_.school_code AS school_code_30, s0_.board AS board_31, s0_.capacity_built_up AS capacity_built_up_32, s0_.capacity_operational AS capacity_operational_33, s0_.occupancy AS occupancy_34, s0_.session AS session_35, s0_.school_status AS school_status_36, s0_.frm_assigned_at AS frm_assigned_at_37, s0_.partner_welcome_email_sent_at AS partner_welcome_email_sent_at_38, s0_.publish_approval_status AS publish_approval_status_39, s0_.created_at AS created_at_40, s0_.updated_at AS updated_at_41, s0_.brand_id AS brand_id_42, s0_.zone_id AS zone_id_43, s0_.status_id AS status_id_44, s0_.countersigned_id AS countersigned_id_45, s0_.assignee_id AS assignee_id_46, s0_.lead_id AS lead_id_47, s0_.created_by AS created_by_48, s0_.updated_by AS updated_by_49 FROM school s0_ WHERE s0_.school_status = 0 AND s0_.id IN (429, 428) ORDER BY s0_.school_name ASC;

SELECT
  t0.id AS id_1,
  t0.project_status AS project_status_2,
  t0.infrastructure_type AS infrastructure_type_3,
  t0.land_type AS land_type_4,
  t0.project_start_date AS project_start_date_5,
  t0.estimated_launch_date AS estimated_launch_date_6,
  t0.actual_launch_date AS actual_launch_date_7,
  t0.operational_year AS operational_year_8,
  t0.project_progress AS project_progress_9,
  t0.last_notification_sent_at AS last_notification_sent_at_10,
  t0.is_proactive_sent AS is_proactive_sent_11,
  t0.plan_due_by AS plan_due_by_12,
  t0.is_sla_warning_sent AS is_sla_warning_sent_13,
  t0.delay_notification_count AS delay_notification_count_14,
  t0.delay_days AS delay_days_15,
  t0.uuid AS uuid_16,
  t0.school_id AS school_id_17
FROM
  rampup_project t0
WHERE
  t0.school_id = ?

SELECT t0.id AS id_1, t0.project_status AS project_status_2, t0.infrastructure_type AS infrastructure_type_3, t0.land_type AS land_type_4, t0.project_start_date AS project_start_date_5, t0.estimated_launch_date AS estimated_launch_date_6, t0.actual_launch_date AS actual_launch_date_7, t0.operational_year AS operational_year_8, t0.project_progress AS project_progress_9, t0.last_notification_sent_at AS last_notification_sent_at_10, t0.is_proactive_sent AS is_proactive_sent_11, t0.plan_due_by AS plan_due_by_12, t0.is_sla_warning_sent AS is_sla_warning_sent_13, t0.delay_notification_count AS delay_notification_count_14, t0.delay_days AS delay_days_15, t0.uuid AS uuid_16, t0.school_id AS school_id_17 FROM rampup_project t0 WHERE t0.school_id = 429;

SELECT
  t0.id AS id_1,
  t0.project_status AS project_status_2,
  t0.infrastructure_type AS infrastructure_type_3,
  t0.land_type AS land_type_4,
  t0.project_start_date AS project_start_date_5,
  t0.estimated_launch_date AS estimated_launch_date_6,
  t0.actual_launch_date AS actual_launch_date_7,
  t0.operational_year AS operational_year_8,
  t0.project_progress AS project_progress_9,
  t0.last_notification_sent_at AS last_notification_sent_at_10,
  t0.is_proactive_sent AS is_proactive_sent_11,
  t0.plan_due_by AS plan_due_by_12,
  t0.is_sla_warning_sent AS is_sla_warning_sent_13,
  t0.delay_notification_count AS delay_notification_count_14,
  t0.delay_days AS delay_days_15,
  t0.uuid AS uuid_16,
  t0.school_id AS school_id_17
FROM
  rampup_project t0
WHERE
  t0.school_id = ?

SELECT t0.id AS id_1, t0.project_status AS project_status_2, t0.infrastructure_type AS infrastructure_type_3, t0.land_type AS land_type_4, t0.project_start_date AS project_start_date_5, t0.estimated_launch_date AS estimated_launch_date_6, t0.actual_launch_date AS actual_launch_date_7, t0.operational_year AS operational_year_8, t0.project_progress AS project_progress_9, t0.last_notification_sent_at AS last_notification_sent_at_10, t0.is_proactive_sent AS is_proactive_sent_11, t0.plan_due_by AS plan_due_by_12, t0.is_sla_warning_sent AS is_sla_warning_sent_13, t0.delay_notification_count AS delay_notification_count_14, t0.delay_days AS delay_days_15, t0.uuid AS uuid_16, t0.school_id AS school_id_17 FROM rampup_project t0 WHERE t0.school_id = 428;

SELECT
  count(*) AS sclr_0
FROM
  school s0_
WHERE
  s0_.school_status = ?

SELECT count(*) AS sclr_0 FROM school s0_ WHERE s0_.school_status = 0;

SELECT
  t0.id AS id_1,
  t0.brand_name AS brand_name_2,
  t0.brand_code AS brand_code_3
FROM
  brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_code AS brand_code_3 FROM brand t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.shortform AS shortform_3
FROM
  zone t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.shortform AS shortform_3 FROM zone t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.logo AS logo_2,
  t0.tagline AS tagline_3,
  t0.logo_footer AS logo_footer_4,
  t0.footer_description AS footer_description_5,
  t0.facebook_link AS facebook_link_6,
  t0.x_link AS x_link_7,
  t0.instagram_link AS instagram_link_8,
  t0.linkedin_link AS linkedin_link_9,
  t0.whatsapp_link AS whatsapp_link_10,
  t0.contact_phone AS contact_phone_11,
  t0.contact_email AS contact_email_12,
  t0.address AS address_13,
  t0.map_link AS map_link_14,
  t0.home_banner_title AS home_banner_title_15,
  t0.home_banner_description AS home_banner_description_16,
  t0.home_banner_image AS home_banner_image_17,
  t0.google_analytics_id AS google_analytics_id_18,
  t0.google_tag_manager_code AS google_tag_manager_code_19,
  t0.google_site_verification_code AS google_site_verification_code_20,
  t0.meta_title AS meta_title_21,
  t0.meta_description AS meta_description_22,
  t0.meta_keywords AS meta_keywords_23
FROM
  setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.tagline AS tagline_3, t0.logo_footer AS logo_footer_4, t0.footer_description AS footer_description_5, t0.facebook_link AS facebook_link_6, t0.x_link AS x_link_7, t0.instagram_link AS instagram_link_8, t0.linkedin_link AS linkedin_link_9, t0.whatsapp_link AS whatsapp_link_10, t0.contact_phone AS contact_phone_11, t0.contact_email AS contact_email_12, t0.address AS address_13, t0.map_link AS map_link_14, t0.home_banner_title AS home_banner_title_15, t0.home_banner_description AS home_banner_description_16, t0.home_banner_image AS home_banner_image_17, t0.google_analytics_id AS google_analytics_id_18, t0.google_tag_manager_code AS google_tag_manager_code_19, t0.google_site_verification_code AS google_site_verification_code_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.meta_keywords AS meta_keywords_23 FROM setting t0 LIMIT 1;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  approval_request a0_
WHERE
  a0_.status = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM approval_request a0_ WHERE a0_.status = 'Sent for Approval';