Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.fid AS fid_3,
  t0.email AS email_4,
  t0.username AS username_5,
  t0.fcode AS fcode_6,
  t0.password AS password_7,
  t0.center AS center_8,
  t0.address AS address_9,
  t0.city AS city_10,
  t0.country AS country_11,
  t0.zip AS zip_12,
  t0.email2 AS email2_13,
  t0.phone AS phone_14,
  t0.mobile AS mobile_15,
  t0.status AS status_16,
  t0.area AS area_17,
  t0.computer AS computer_18,
  t0.staff AS staff_19,
  t0.marks AS marks_20,
  t0.entry_date AS entry_date_21,
  t0.reg_date AS reg_date_22,
  t0.exp_date AS exp_date_23,
  t0.ffee AS ffee_24,
  t0.payment_id AS payment_id_25,
  t0.lat AS lat_26,
  t0.lang AS lang_27,
  t0.is_mobile_verified AS is_mobile_verified_28,
  t0.m_verify_code AS m_verify_code_29,
  t0.m_verify_date AS m_verify_date_30,
  t0.is_unsubscribe AS is_unsubscribe_31,
  t0.unsubscribe_key AS unsubscribe_key_32,
  t0.unsubscribe_on AS unsubscribe_on_33,
  t0.is_email_verified AS is_email_verified_34,
  t0.e_verify_code AS e_verify_code_35,
  t0.e_verify_date AS e_verify_date_36,
  t0.created_on AS created_on_37,
  t0.registred_on AS registred_on_38,
  t0.expiry_date AS expiry_date_39,
  t0.is_active AS is_active_40,
  t0.roles AS roles_41,
  t0.old_id AS old_id_42,
  t0.franchise_code AS franchise_code_43,
  t0.discount AS discount_44,
  t0.franchise_is_paid AS franchise_is_paid_45,
  t0.auto_login_key AS auto_login_key_46,
  t0.app_key AS app_key_47,
  t0.has_printing_power AS has_printing_power_48,
  t0.api_key AS api_key_49,
  t0.api_key_expired_on AS api_key_expired_on_50,
  t0.conversion_stage AS conversion_stage_51,
  t0.engagement_score AS engagement_score_52,
  t0.last_interaction_at AS last_interaction_at_53,
  t0.next_followup_at AS next_followup_at_54,
  t0.lead_source AS lead_source_55,
  t0.renewal_risk_level AS renewal_risk_level_56,
  t0.next_best_action AS next_best_action_57,
  t0.country_id AS country_id_58,
  t0.state_id AS state_id_59,
  t0.parent_partner_id AS parent_partner_id_60
FROM
  franchise t0
WHERE
  t0.franchise_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.fid AS fid_3, t0.email AS email_4, t0.username AS username_5, t0.fcode AS fcode_6, t0.password AS password_7, t0.center AS center_8, t0.address AS address_9, t0.city AS city_10, t0.country AS country_11, t0.zip AS zip_12, t0.email2 AS email2_13, t0.phone AS phone_14, t0.mobile AS mobile_15, t0.status AS status_16, t0.area AS area_17, t0.computer AS computer_18, t0.staff AS staff_19, t0.marks AS marks_20, t0.entry_date AS entry_date_21, t0.reg_date AS reg_date_22, t0.exp_date AS exp_date_23, t0.ffee AS ffee_24, t0.payment_id AS payment_id_25, t0.lat AS lat_26, t0.lang AS lang_27, t0.is_mobile_verified AS is_mobile_verified_28, t0.m_verify_code AS m_verify_code_29, t0.m_verify_date AS m_verify_date_30, t0.is_unsubscribe AS is_unsubscribe_31, t0.unsubscribe_key AS unsubscribe_key_32, t0.unsubscribe_on AS unsubscribe_on_33, t0.is_email_verified AS is_email_verified_34, t0.e_verify_code AS e_verify_code_35, t0.e_verify_date AS e_verify_date_36, t0.created_on AS created_on_37, t0.registred_on AS registred_on_38, t0.expiry_date AS expiry_date_39, t0.is_active AS is_active_40, t0.roles AS roles_41, t0.old_id AS old_id_42, t0.franchise_code AS franchise_code_43, t0.discount AS discount_44, t0.franchise_is_paid AS franchise_is_paid_45, t0.auto_login_key AS auto_login_key_46, t0.app_key AS app_key_47, t0.has_printing_power AS has_printing_power_48, t0.api_key AS api_key_49, t0.api_key_expired_on AS api_key_expired_on_50, t0.conversion_stage AS conversion_stage_51, t0.engagement_score AS engagement_score_52, t0.last_interaction_at AS last_interaction_at_53, t0.next_followup_at AS next_followup_at_54, t0.lead_source AS lead_source_55, t0.renewal_risk_level AS renewal_risk_level_56, t0.next_best_action AS next_best_action_57, t0.country_id AS country_id_58, t0.state_id AS state_id_59, t0.parent_partner_id AS parent_partner_id_60 FROM franchise t0 WHERE t0.franchise_code = 'inpb0001' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.guid AS guid_1,
  c0_.code AS code_2,
  c0_.name AS name_3,
  c0_.months AS months_4,
  c0_.hours AS hours_5,
  c0_.status AS status_6,
  c0_.fee AS fee_7,
  c0_.eligibility AS eligibility_8,
  c0_.book AS book_9,
  c0_.file AS file_10,
  c0_.file_type AS file_type_11,
  c0_.old_id AS old_id_12,
  c0_.syllabus AS syllabus_13,
  c0_.description AS description_14,
  c0_.online_test AS online_test_15,
  c0_.page_body AS page_body_16,
  c0_.title AS title_17,
  c0_.keywords AS keywords_18,
  c0_.is_public AS is_public_19,
  c0_.job_opportunities AS job_opportunities_20
FROM
  course c0_
  INNER JOIN course_country c1_ ON c0_.id = c1_.course_id
  AND (c1_.country_id = ?)
WHERE
  c0_.status = ?
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.guid AS guid_1, c0_.code AS code_2, c0_.name AS name_3, c0_.months AS months_4, c0_.hours AS hours_5, c0_.status AS status_6, c0_.fee AS fee_7, c0_.eligibility AS eligibility_8, c0_.book AS book_9, c0_.file AS file_10, c0_.file_type AS file_type_11, c0_.old_id AS old_id_12, c0_.syllabus AS syllabus_13, c0_.description AS description_14, c0_.online_test AS online_test_15, c0_.page_body AS page_body_16, c0_.title AS title_17, c0_.keywords AS keywords_18, c0_.is_public AS is_public_19, c0_.job_opportunities AS job_opportunities_20 FROM course c0_ INNER JOIN course_country c1_ ON c0_.id = c1_.course_id AND (c1_.country_id = 2) WHERE c0_.status = 'a' ORDER BY c0_.name ASC;

SELECT
  c0_.course_id AS sclr_0,
  c0_.fee AS fee_1
FROM
  course_country_fee c0_
WHERE
  c0_.course_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
  AND c0_.country_id = ?

SELECT c0_.course_id AS sclr_0, c0_.fee AS fee_1 FROM course_country_fee c0_ WHERE c0_.course_id IN (52, 37, 53, 26, 33, 27, 48, 59, 62, 60, 50, 24, 10, 18, 8, 23, 40, 58, 11, 43, 55, 42, 41, 35, 19, 9, 30, 61, 25, 51, 20, 22, 21, 49, 6, 39, 12, 56, 16, 13, 15, 32, 31, 38, 14, 34, 36, 7, 17, 54) AND c0_.country_id = 2;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.body AS body_3,
  t0.created_on AS created_on_4,
  t0.tags AS tags_5,
  t0.is_approved AS is_approved_6,
  t0.description AS description_7,
  t0.status AS status_8,
  t0.blog_category_id AS blog_category_id_9,
  t0.franchise_id AS franchise_id_10
FROM
  blog t0
WHERE
  t0.status = ?
  AND t0.franchise_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.created_on AS created_on_4, t0.tags AS tags_5, t0.is_approved AS is_approved_6, t0.description AS description_7, t0.status AS status_8, t0.blog_category_id AS blog_category_id_9, t0.franchise_id AS franchise_id_10 FROM blog t0 WHERE t0.status = 'a' AND t0.franchise_id = 6;

SELECT
  t0.guid AS guid_1,
  t0.id AS id_2,
  t0.name AS name_3,
  t0.iso AS iso_4,
  t0.iso2 AS iso2_5,
  t0.iso_numeric AS iso_numeric_6,
  t0.phone_code AS phone_code_7,
  t0.currency_iso AS currency_iso_8,
  t0.activation_fee AS activation_fee_9,
  t0.renewal_fee AS renewal_fee_10,
  t0.minimum_fund_allowed AS minimum_fund_allowed_11,
  t0.capital_city AS capital_city_12,
  t0.is_active AS is_active_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.guid AS guid_1, t0.id AS id_2, t0.name AS name_3, t0.iso AS iso_4, t0.iso2 AS iso2_5, t0.iso_numeric AS iso_numeric_6, t0.phone_code AS phone_code_7, t0.currency_iso AS currency_iso_8, t0.activation_fee AS activation_fee_9, t0.renewal_fee AS renewal_fee_10, t0.minimum_fund_allowed AS minimum_fund_allowed_11, t0.capital_city AS capital_city_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM country t0 WHERE t0.id = 2;

SELECT
  t0.guid AS guid_1,
  t0.id AS id_2,
  t0.iso2 AS iso2_3,
  t0.name AS name_4,
  t0.country_id AS country_id_5
FROM
  state t0
WHERE
  t0.id = ?

SELECT t0.guid AS guid_1, t0.id AS id_2, t0.iso2 AS iso2_3, t0.name AS name_4, t0.country_id AS country_id_5 FROM state t0 WHERE t0.id = 28;