Symfony Profiler

SELECT
  a0_.active_man AS active_man_0,
  a0_.active_women AS active_women_1,
  a0_.id AS id_2,
  a0_.project_id AS project_id_3,
  a0_.accent_id AS accent_id_4
FROM
  accent_mapping a0_
  LEFT JOIN project p1_ ON a0_.project_id = p1_.id
WHERE
  p1_.subscription_active = 1
  AND (
    a0_.active_man = 1
    OR a0_.active_women = 1
  )

SELECT a0_.active_man AS active_man_0, a0_.active_women AS active_women_1, a0_.id AS id_2, a0_.project_id AS project_id_3, a0_.accent_id AS accent_id_4 FROM accent_mapping a0_ LEFT JOIN project p1_ ON a0_.project_id = p1_.id WHERE p1_.subscription_active = 1 AND (a0_.active_man = 1 OR a0_.active_women = 1);

SELECT
  s0_.active_man AS active_man_0,
  s0_.active_women AS active_women_1,
  s0_.id AS id_2,
  s0_.scenario_id AS scenario_id_3,
  s0_.accent_id AS accent_id_4
FROM
  scenario_accent_mapping s0_
  LEFT JOIN scenario_project s1_ ON s0_.scenario_id = s1_.id
WHERE
  s1_.subscription_active = 1
  AND (
    s0_.active_man = 1
    OR s0_.active_women = 1
  )

SELECT s0_.active_man AS active_man_0, s0_.active_women AS active_women_1, s0_.id AS id_2, s0_.scenario_id AS scenario_id_3, s0_.accent_id AS accent_id_4 FROM scenario_accent_mapping s0_ LEFT JOIN scenario_project s1_ ON s0_.scenario_id = s1_.id WHERE s1_.subscription_active = 1 AND (s0_.active_man = 1 OR s0_.active_women = 1);

SELECT
  t0.name AS name_1,
  t0.note AS note_2,
  t0.active AS active_3,
  t0.subscription_active AS subscription_active_4,
  t0.max_scenario_duration AS max_scenario_duration_5,
  t0.scenario_cost AS scenario_cost_6,
  t0.bonuses AS bonuses_7,
  t0.bonus_costs AS bonus_costs_8,
  t0.sponsor_cost AS sponsor_cost_9,
  t0.high_quality AS high_quality_10,
  t0.phone_number AS phone_number_11,
  t0.allow_sip AS allow_sip_12,
  t0.sip_number AS sip_number_13,
  t0.click_to_call AS click_to_call_14,
  t0.calling_number AS calling_number_15,
  t0.start_date AS start_date_16,
  t0.end_date AS end_date_17,
  t0.delivery_prefix AS delivery_prefix_18,
  t0.isAgentDependent AS isAgentDependent_19,
  t0.id AS id_20,
  t0.currency_id AS currency_id_21,
  t22.display AS display_23,
  t22.id AS id_24,
  t0.phone_country_id AS phone_country_id_25,
  t26.name AS name_27,
  t26.code AS code_28,
  t26.id AS id_29,
  t0.nda_file_id AS nda_file_id_30
FROM
  scenario_project t0
  LEFT JOIN currency t22 ON t0.currency_id = t22.id
  LEFT JOIN country t26 ON t0.phone_country_id = t26.id
WHERE
  t0.id IN (?)

SELECT t0.name AS name_1, t0.note AS note_2, t0.active AS active_3, t0.subscription_active AS subscription_active_4, t0.max_scenario_duration AS max_scenario_duration_5, t0.scenario_cost AS scenario_cost_6, t0.bonuses AS bonuses_7, t0.bonus_costs AS bonus_costs_8, t0.sponsor_cost AS sponsor_cost_9, t0.high_quality AS high_quality_10, t0.phone_number AS phone_number_11, t0.allow_sip AS allow_sip_12, t0.sip_number AS sip_number_13, t0.click_to_call AS click_to_call_14, t0.calling_number AS calling_number_15, t0.start_date AS start_date_16, t0.end_date AS end_date_17, t0.delivery_prefix AS delivery_prefix_18, t0.isAgentDependent AS isAgentDependent_19, t0.id AS id_20, t0.currency_id AS currency_id_21, t22.display AS display_23, t22.id AS id_24, t0.phone_country_id AS phone_country_id_25, t26.name AS name_27, t26.code AS code_28, t26.id AS id_29, t0.nda_file_id AS nda_file_id_30 FROM scenario_project t0 LEFT JOIN currency t22 ON t0.currency_id = t22.id LEFT JOIN country t26 ON t0.phone_country_id = t26.id WHERE t0.id IN (5);

SELECT
  t0.display AS display_1,
  t0.delivery_name AS delivery_name_2,
  t0.place_of_origin AS place_of_origin_3,
  t0.id AS id_4,
  t0.country_id AS country_id_5,
  t6.name AS name_7,
  t6.code AS code_8,
  t6.id AS id_9,
  t0.lang_id AS lang_id_10,
  t11.name AS name_12,
  t11.code AS code_13,
  t11.id AS id_14
FROM
  accent t0
  LEFT JOIN country t6 ON t0.country_id = t6.id
  LEFT JOIN lang t11 ON t0.lang_id = t11.id
WHERE
  t0.id IN (?)

SELECT t0.display AS display_1, t0.delivery_name AS delivery_name_2, t0.place_of_origin AS place_of_origin_3, t0.id AS id_4, t0.country_id AS country_id_5, t6.name AS name_7, t6.code AS code_8, t6.id AS id_9, t0.lang_id AS lang_id_10, t11.name AS name_12, t11.code AS code_13, t11.id AS id_14 FROM accent t0 LEFT JOIN country t6 ON t0.country_id = t6.id LEFT JOIN lang t11 ON t0.lang_id = t11.id WHERE t0.id IN ('australian_english');

SELECT
  c0_.name AS name_0,
  c0_.code AS code_1,
  c0_.id AS id_2
FROM
  country c0_

SELECT c0_.name AS name_0, c0_.code AS code_1, c0_.id AS id_2 FROM country c0_;

SELECT
  c0_.display AS display_0,
  c0_.id AS id_1
FROM
  currency c0_

SELECT c0_.display AS display_0, c0_.id AS id_1 FROM currency c0_;

SELECT
  r0_.display AS display_0,
  r0_.sequence AS sequence_1,
  r0_.id AS id_2
FROM
  resource_source r0_
ORDER BY
  r0_.sequence ASC,
  r0_.display ASC

SELECT r0_.display AS display_0, r0_.sequence AS sequence_1, r0_.id AS id_2 FROM resource_source r0_ ORDER BY r0_.sequence ASC, r0_.display ASC;