Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.address AS address_2,
  c0_.logo AS logo_3,
  c0_.expiry_date AS expiry_date_4,
  c0_.status AS status_5,
  c0_.subdomain AS subdomain_6,
  c0_.name_bn AS name_bn_7,
  c0_.contact_mobile AS contact_mobile_8,
  c0_.contact_phone AS contact_phone_9,
  c0_.contact_email AS contact_email_10,
  c0_.module AS module_11,
  c0_.go_code AS go_code_12,
  c0_.sms_end_point AS sms_end_point_13,
  c0_.sms_api_key AS sms_api_key_14,
  c0_.sms_sender_id AS sms_sender_id_15,
  c0_.api_vendor AS api_vendor_16
FROM
  companies c0_
WHERE
  c0_.status = 1
  AND c0_.module IN (?, ?)
ORDER BY
  c0_.id ASC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.address AS address_2, c0_.logo AS logo_3, c0_.expiry_date AS expiry_date_4, c0_.status AS status_5, c0_.subdomain AS subdomain_6, c0_.name_bn AS name_bn_7, c0_.contact_mobile AS contact_mobile_8, c0_.contact_phone AS contact_phone_9, c0_.contact_email AS contact_email_10, c0_.module AS module_11, c0_.go_code AS go_code_12, c0_.sms_end_point AS sms_end_point_13, c0_.sms_api_key AS sms_api_key_14, c0_.sms_sender_id AS sms_sender_id_15, c0_.api_vendor AS api_vendor_16 FROM companies c0_ WHERE c0_.status = 1 AND c0_.module IN ('education', 'school') ORDER BY c0_.id ASC LIMIT 1;

SELECT
  w0_.id AS id_0,
  w0_.menu AS menu_1,
  w0_.type AS type_2,
  w0_.title AS title_3,
  w0_.sub_title AS sub_title_4,
  w0_.short_description AS short_description_5,
  w0_.description AS description_6,
  w0_.footer_note AS footer_note_7,
  w0_.image AS image_8,
  w0_.status AS status_9,
  w0_.created_by AS created_by_10,
  w0_.created_time AS created_time_11,
  w0_.updated_by AS updated_by_12,
  w0_.updated_time AS updated_time_13,
  w0_.company_id AS company_id_14
FROM
  website_posts w0_
WHERE
  w0_.company_id = ?
  AND w0_.status = ?
  AND w0_.type = ?
ORDER BY
  w0_.id DESC
LIMIT
  8

SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = 1 AND w0_.status = 1 AND w0_.type = 1 ORDER BY w0_.id DESC LIMIT 8;

SELECT
  w0_.id AS id_0,
  w0_.menu AS menu_1,
  w0_.type AS type_2,
  w0_.title AS title_3,
  w0_.sub_title AS sub_title_4,
  w0_.short_description AS short_description_5,
  w0_.description AS description_6,
  w0_.footer_note AS footer_note_7,
  w0_.image AS image_8,
  w0_.status AS status_9,
  w0_.created_by AS created_by_10,
  w0_.created_time AS created_time_11,
  w0_.updated_by AS updated_by_12,
  w0_.updated_time AS updated_time_13,
  w0_.company_id AS company_id_14
FROM
  website_posts w0_
WHERE
  w0_.company_id = ?
  AND w0_.status = ?
  AND w0_.type = ?
ORDER BY
  w0_.id DESC
LIMIT
  1

SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = 1 AND w0_.status = 1 AND w0_.type = 11 ORDER BY w0_.id DESC LIMIT 1;

SELECT
  w0_.id AS id_0,
  w0_.menu AS menu_1,
  w0_.type AS type_2,
  w0_.title AS title_3,
  w0_.sub_title AS sub_title_4,
  w0_.short_description AS short_description_5,
  w0_.description AS description_6,
  w0_.footer_note AS footer_note_7,
  w0_.image AS image_8,
  w0_.status AS status_9,
  w0_.created_by AS created_by_10,
  w0_.created_time AS created_time_11,
  w0_.updated_by AS updated_by_12,
  w0_.updated_time AS updated_time_13,
  w0_.company_id AS company_id_14
FROM
  website_posts w0_
WHERE
  w0_.company_id = ?
  AND w0_.status = ?
  AND w0_.type IN (?, ?, ?, ?, ?, ?)
ORDER BY
  w0_.type ASC,
  w0_.id ASC

SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = 1 AND w0_.status = 1 AND w0_.type IN (2, 3, 4, 5, 6, 7) ORDER BY w0_.type ASC, w0_.id ASC;

SELECT
  w0_.id AS id_0,
  w0_.menu AS menu_1,
  w0_.type AS type_2,
  w0_.title AS title_3,
  w0_.sub_title AS sub_title_4,
  w0_.short_description AS short_description_5,
  w0_.description AS description_6,
  w0_.footer_note AS footer_note_7,
  w0_.image AS image_8,
  w0_.status AS status_9,
  w0_.created_by AS created_by_10,
  w0_.created_time AS created_time_11,
  w0_.updated_by AS updated_by_12,
  w0_.updated_time AS updated_time_13,
  w0_.company_id AS company_id_14
FROM
  website_posts w0_
WHERE
  w0_.company_id = ?
  AND w0_.status = ?
  AND w0_.type = ?
ORDER BY
  w0_.id DESC
LIMIT
  6

SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = 1 AND w0_.status = 1 AND w0_.type = 8 ORDER BY w0_.id DESC LIMIT 6;

SELECT
  w0_.id AS id_0,
  w0_.menu AS menu_1,
  w0_.type AS type_2,
  w0_.title AS title_3,
  w0_.sub_title AS sub_title_4,
  w0_.short_description AS short_description_5,
  w0_.description AS description_6,
  w0_.footer_note AS footer_note_7,
  w0_.image AS image_8,
  w0_.status AS status_9,
  w0_.created_by AS created_by_10,
  w0_.created_time AS created_time_11,
  w0_.updated_by AS updated_by_12,
  w0_.updated_time AS updated_time_13,
  w0_.company_id AS company_id_14
FROM
  website_posts w0_
WHERE
  w0_.company_id = ?
  AND w0_.status = ?
  AND w0_.type = ?
ORDER BY
  w0_.id DESC
LIMIT
  6

SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = 1 AND w0_.status = 1 AND w0_.type = 9 ORDER BY w0_.id DESC LIMIT 6;

SELECT
  w0_.id AS id_0,
  w0_.menu AS menu_1,
  w0_.type AS type_2,
  w0_.title AS title_3,
  w0_.sub_title AS sub_title_4,
  w0_.short_description AS short_description_5,
  w0_.description AS description_6,
  w0_.footer_note AS footer_note_7,
  w0_.image AS image_8,
  w0_.status AS status_9,
  w0_.created_by AS created_by_10,
  w0_.created_time AS created_time_11,
  w0_.updated_by AS updated_by_12,
  w0_.updated_time AS updated_time_13,
  w0_.company_id AS company_id_14
FROM
  website_posts w0_
WHERE
  w0_.company_id = ?
  AND w0_.status = ?
  AND w0_.type = ?
ORDER BY
  w0_.id DESC
LIMIT
  8

SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = 1 AND w0_.status = 1 AND w0_.type = 12 ORDER BY w0_.id DESC LIMIT 8;

SELECT
  w0_.id AS id_0,
  w0_.menu AS menu_1,
  w0_.type AS type_2,
  w0_.title AS title_3,
  w0_.sub_title AS sub_title_4,
  w0_.short_description AS short_description_5,
  w0_.description AS description_6,
  w0_.footer_note AS footer_note_7,
  w0_.image AS image_8,
  w0_.status AS status_9,
  w0_.created_by AS created_by_10,
  w0_.created_time AS created_time_11,
  w0_.updated_by AS updated_by_12,
  w0_.updated_time AS updated_time_13,
  w0_.company_id AS company_id_14
FROM
  website_posts w0_
WHERE
  w0_.company_id = ?
  AND w0_.status = ?
  AND w0_.type = ?
ORDER BY
  w0_.id DESC
LIMIT
  12

SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = 1 AND w0_.status = 1 AND w0_.type = 10 ORDER BY w0_.id DESC LIMIT 12;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.address AS address_2,
  c0_.code AS code_3,
  c0_.alias AS alias_4,
  c0_.status AS status_5,
  c0_.created_by AS created_by_6,
  c0_.created_time AS created_time_7,
  c0_.updated_by AS updated_by_8,
  c0_.updated_time AS updated_time_9,
  c0_.company_id AS company_id_10
FROM
  campus c0_
WHERE
  c0_.status <> ?
  AND c0_.company_id = ?
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.address AS address_2, c0_.code AS code_3, c0_.alias AS alias_4, c0_.status AS status_5, c0_.created_by AS created_by_6, c0_.created_time AS created_time_7, c0_.updated_by AS updated_by_8, c0_.updated_time AS updated_time_9, c0_.company_id AS company_id_10 FROM campus c0_ WHERE c0_.status <> 99 AND c0_.company_id = 1 ORDER BY c0_.name ASC;

SELECT
  t0_.id AS id_0,
  t0_.teacher_id AS teacher_id_1,
  t0_.name AS name_2,
  t0_.phone AS phone_3,
  t0_.email AS email_4,
  t0_.gender AS gender_5,
  t0_.date_of_birth AS date_of_birth_6,
  t0_.joining_date AS joining_date_7,
  t0_.qualification AS qualification_8,
  t0_.designation AS designation_9,
  t0_.address AS address_10,
  t0_.photo AS photo_11,
  t0_.specialization AS specialization_12,
  t0_.salary AS salary_13,
  t0_.status AS status_14,
  t0_.created_by AS created_by_15,
  t0_.created_time AS created_time_16,
  t0_.updated_by AS updated_by_17,
  t0_.updated_time AS updated_time_18,
  t0_.company_id AS company_id_19,
  t0_.user_id AS user_id_20
FROM
  teacher t0_
WHERE
  t0_.company_id = ?
  AND t0_.status = 1
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.teacher_id AS teacher_id_1, t0_.name AS name_2, t0_.phone AS phone_3, t0_.email AS email_4, t0_.gender AS gender_5, t0_.date_of_birth AS date_of_birth_6, t0_.joining_date AS joining_date_7, t0_.qualification AS qualification_8, t0_.designation AS designation_9, t0_.address AS address_10, t0_.photo AS photo_11, t0_.specialization AS specialization_12, t0_.salary AS salary_13, t0_.status AS status_14, t0_.created_by AS created_by_15, t0_.created_time AS created_time_16, t0_.updated_by AS updated_by_17, t0_.updated_time AS updated_time_18, t0_.company_id AS company_id_19, t0_.user_id AS user_id_20 FROM teacher t0_ WHERE t0_.company_id = 1 AND t0_.status = 1 ORDER BY t0_.name ASC;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  student_info s0_
WHERE
  s0_.status <> ?
  AND s0_.company_id = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM student_info s0_ WHERE s0_.status <> 99 AND s0_.company_id = 1;