Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.business_name AS business_name_2,
  t0.address AS address_3,
  t0.address2 AS address2_4,
  t0.city AS city_5,
  t0.state AS state_6,
  t0.zip_code AS zip_code_7,
  t0.contact_name AS contact_name_8,
  t0.contact_phone AS contact_phone_9,
  t0.contact_email AS contact_email_10,
  t0.status AS status_11,
  t0.password AS password_12,
  t0.uuid AS uuid_13,
  t0.time_zone AS time_zone_14,
  t0.logo AS logo_15,
  t0.logo_meta_data AS logo_meta_data_16,
  t0.acknowledge_correct_information_paragraph AS acknowledge_correct_information_paragraph_17,
  t0.refusal_of_treatment_paragraph AS refusal_of_treatment_paragraph_18,
  t0.acknowledge_witness_paragraph AS acknowledge_witness_paragraph_19
FROM
  business t0
LIMIT
  1

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.address AS address_3, t0.address2 AS address2_4, t0.city AS city_5, t0.state AS state_6, t0.zip_code AS zip_code_7, t0.contact_name AS contact_name_8, t0.contact_phone AS contact_phone_9, t0.contact_email AS contact_email_10, t0.status AS status_11, t0.password AS password_12, t0.uuid AS uuid_13, t0.time_zone AS time_zone_14, t0.logo AS logo_15, t0.logo_meta_data AS logo_meta_data_16, t0.acknowledge_correct_information_paragraph AS acknowledge_correct_information_paragraph_17, t0.refusal_of_treatment_paragraph AS refusal_of_treatment_paragraph_18, t0.acknowledge_witness_paragraph AS acknowledge_witness_paragraph_19 FROM business t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.business_name AS business_name_2,
  t0.address AS address_3,
  t0.address2 AS address2_4,
  t0.city AS city_5,
  t0.state AS state_6,
  t0.zip_code AS zip_code_7,
  t0.contact_name AS contact_name_8,
  t0.contact_phone AS contact_phone_9,
  t0.contact_email AS contact_email_10,
  t0.status AS status_11,
  t0.password AS password_12,
  t0.uuid AS uuid_13,
  t0.time_zone AS time_zone_14,
  t0.logo AS logo_15,
  t0.logo_meta_data AS logo_meta_data_16,
  t0.acknowledge_correct_information_paragraph AS acknowledge_correct_information_paragraph_17,
  t0.refusal_of_treatment_paragraph AS refusal_of_treatment_paragraph_18,
  t0.acknowledge_witness_paragraph AS acknowledge_witness_paragraph_19
FROM
  business t0
WHERE
  t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.address AS address_3, t0.address2 AS address2_4, t0.city AS city_5, t0.state AS state_6, t0.zip_code AS zip_code_7, t0.contact_name AS contact_name_8, t0.contact_phone AS contact_phone_9, t0.contact_email AS contact_email_10, t0.status AS status_11, t0.password AS password_12, t0.uuid AS uuid_13, t0.time_zone AS time_zone_14, t0.logo AS logo_15, t0.logo_meta_data AS logo_meta_data_16, t0.acknowledge_correct_information_paragraph AS acknowledge_correct_information_paragraph_17, t0.refusal_of_treatment_paragraph AS refusal_of_treatment_paragraph_18, t0.acknowledge_witness_paragraph AS acknowledge_witness_paragraph_19 FROM business t0 WHERE t0.status = 'Active' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.is_verified AS is_verified_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.status AS status_9,
  t0.license_active_date AS license_active_date_10,
  t0.license_renewal_date AS license_renewal_date_11,
  t0.photo_url AS photo_url_12,
  t0.business_id AS business_id_13,
  t0.license_id AS license_id_14
FROM
  staff t0
WHERE
  t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.is_verified AS is_verified_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.status AS status_9, t0.license_active_date AS license_active_date_10, t0.license_renewal_date AS license_renewal_date_11, t0.photo_url AS photo_url_12, t0.business_id AS business_id_13, t0.license_id AS license_id_14 FROM staff t0 WHERE t0.status = 'Active' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.first_name AS first_name_1,
  c0_.last_name AS last_name_2,
  c0_.email AS email_3,
  c0_.mobile AS mobile_4,
  c0_.status AS status_5,
  c0_.license AS license_6,
  c0_.license_expire_date AS license_expire_date_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c0_.chart_id AS chart_id_10,
  c0_.created_by_id AS created_by_id_11,
  c0_.updated_by_id AS updated_by_id_12,
  c0_.staff_id AS staff_id_13
FROM
  chart_staff c0_
  INNER JOIN chart c1_ ON (c0_.chart_id = c1_.id)
WHERE
  c0_.staff_id = ?
  AND c1_.status = ?
ORDER BY
  c0_.chart_id ASC

SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.email AS email_3, c0_.mobile AS mobile_4, c0_.status AS status_5, c0_.license AS license_6, c0_.license_expire_date AS license_expire_date_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.chart_id AS chart_id_10, c0_.created_by_id AS created_by_id_11, c0_.updated_by_id AS updated_by_id_12, c0_.staff_id AS staff_id_13 FROM chart_staff c0_ INNER JOIN chart c1_ ON (c0_.chart_id = c1_.id) WHERE c0_.staff_id = NULL AND c1_.status = 'Active' ORDER BY c0_.chart_id ASC;

SELECT
  c0_.id AS id_0,
  c0_.first_name AS first_name_1,
  c0_.last_name AS last_name_2,
  c0_.email AS email_3,
  c0_.mobile AS mobile_4,
  c0_.status AS status_5,
  c0_.license AS license_6,
  c0_.license_expire_date AS license_expire_date_7,
  c0_.created_at AS created_at_8,
  c0_.updated_at AS updated_at_9,
  c0_.chart_id AS chart_id_10,
  c0_.created_by_id AS created_by_id_11,
  c0_.updated_by_id AS updated_by_id_12,
  c0_.staff_id AS staff_id_13
FROM
  chart_staff c0_
  INNER JOIN chart c1_ ON (c0_.chart_id = c1_.id)
WHERE
  c0_.staff_id = ?
  AND c1_.status = ?
ORDER BY
  c0_.chart_id ASC

SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.email AS email_3, c0_.mobile AS mobile_4, c0_.status AS status_5, c0_.license AS license_6, c0_.license_expire_date AS license_expire_date_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.chart_id AS chart_id_10, c0_.created_by_id AS created_by_id_11, c0_.updated_by_id AS updated_by_id_12, c0_.staff_id AS staff_id_13 FROM chart_staff c0_ INNER JOIN chart c1_ ON (c0_.chart_id = c1_.id) WHERE c0_.staff_id = NULL AND c1_.status = 'Declined' ORDER BY c0_.chart_id ASC;

SELECT
  t0.id AS id_1,
  t0.business_name AS business_name_2,
  t0.address AS address_3,
  t0.address2 AS address2_4,
  t0.city AS city_5,
  t0.state AS state_6,
  t0.zip_code AS zip_code_7,
  t0.contact_name AS contact_name_8,
  t0.contact_phone AS contact_phone_9,
  t0.contact_email AS contact_email_10,
  t0.status AS status_11,
  t0.password AS password_12,
  t0.uuid AS uuid_13,
  t0.time_zone AS time_zone_14,
  t0.logo AS logo_15,
  t0.logo_meta_data AS logo_meta_data_16,
  t0.acknowledge_correct_information_paragraph AS acknowledge_correct_information_paragraph_17,
  t0.refusal_of_treatment_paragraph AS refusal_of_treatment_paragraph_18,
  t0.acknowledge_witness_paragraph AS acknowledge_witness_paragraph_19
FROM
  business t0
LIMIT
  1

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.address AS address_3, t0.address2 AS address2_4, t0.city AS city_5, t0.state AS state_6, t0.zip_code AS zip_code_7, t0.contact_name AS contact_name_8, t0.contact_phone AS contact_phone_9, t0.contact_email AS contact_email_10, t0.status AS status_11, t0.password AS password_12, t0.uuid AS uuid_13, t0.time_zone AS time_zone_14, t0.logo AS logo_15, t0.logo_meta_data AS logo_meta_data_16, t0.acknowledge_correct_information_paragraph AS acknowledge_correct_information_paragraph_17, t0.refusal_of_treatment_paragraph AS refusal_of_treatment_paragraph_18, t0.acknowledge_witness_paragraph AS acknowledge_witness_paragraph_19 FROM business t0 LIMIT 1;