Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.lvl AS lvl_1,
  c0_.lft AS lft_2,
  c0_.rgt AS rgt_3,
  c0_.root AS root_4,
  c0_.name AS name_5,
  c0_.role AS role_6,
  c0_.parent_id AS parent_id_7
FROM
  cms_roles c0_
WHERE
  c0_.lvl IN (0, 1)
  AND c0_.role NOT LIKE 'ROLE_ADMIN_%'
ORDER BY
  c0_.root ASC,
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.lvl AS lvl_1, c0_.lft AS lft_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.name AS name_5, c0_.role AS role_6, c0_.parent_id AS parent_id_7 FROM cms_roles c0_ WHERE c0_.lvl IN (0, 1) AND c0_.role NOT LIKE 'ROLE_ADMIN_%' ORDER BY c0_.root ASC, c0_.lft ASC;

SELECT
  r0_.name AS name_0,
  r0_.value AS value_1
FROM
  runtime_parameter r0_

SELECT r0_.name AS name_0, r0_.value AS value_1 FROM runtime_parameter r0_;

SELECT
  MAX(p0_.id) AS sclr_0
FROM
  package p0_
GROUP BY
  p0_.package_label_id

SELECT MAX(p0_.id) AS sclr_0 FROM package p0_ GROUP BY p0_.package_label_id;

SELECT
  p0_.id AS id_0,
  p0_.monthly_fees AS monthly_fees_1,
  p0_.monthly_fees_discount AS monthly_fees_discount_2,
  p0_.yearly_fees AS yearly_fees_3,
  p0_.yearly_fees_discount AS yearly_fees_discount_4,
  p0_.setup_fees AS setup_fees_5,
  p0_.setup_fees_discount AS setup_fees_discount_6,
  p0_.free_period AS free_period_7,
  p0_.created_at AS created_at_8,
  p0_.updated_at AS updated_at_9,
  p1_.id AS id_10,
  p1_.enabled AS enabled_11,
  p1_.highlighted AS highlighted_12,
  p1_.view_order AS view_order_13,
  p1_.action_target AS action_target_14,
  p1_.createdAt AS createdAt_15,
  p1_.updated_at AS updated_at_16,
  p2_.name AS name_17,
  p2_.description AS description_18,
  p2_.action_name AS action_name_19,
  p2_.locale AS locale_20,
  p3_.id AS id_21,
  p3_.createdAt AS createdAt_22,
  p3_.updated_at AS updated_at_23,
  p4_.name AS name_24,
  p4_.locale AS locale_25,
  p0_.package_label_id AS package_label_id_26,
  p0_.created_by_id AS created_by_id_27,
  p0_.updated_by AS updated_by_28,
  p1_.created_by AS created_by_29,
  p1_.updated_by AS updated_by_30,
  p2_.id AS id_31,
  p3_.created_by AS created_by_32,
  p3_.updated_by AS updated_by_33,
  p4_.id AS id_34
FROM
  package p0_
  INNER JOIN package_label p1_ ON p0_.package_label_id = p1_.id
  INNER JOIN package_label_translation p2_ ON p1_.id = p2_.id
  AND (p2_.locale = 'en')
  LEFT JOIN package_label_package_benefit p5_ ON p1_.id = p5_.package_label_id
  LEFT JOIN package_benefit p3_ ON p3_.id = p5_.package_benefit_id
  LEFT JOIN package_benefit_translation p4_ ON p3_.id = p4_.id
  AND (p4_.locale = 'en')
WHERE
  p1_.enabled = 1
  AND p0_.id IN (?)
ORDER BY
  p1_.view_order ASC,
  p1_.id ASC

SELECT p0_.id AS id_0, p0_.monthly_fees AS monthly_fees_1, p0_.monthly_fees_discount AS monthly_fees_discount_2, p0_.yearly_fees AS yearly_fees_3, p0_.yearly_fees_discount AS yearly_fees_discount_4, p0_.setup_fees AS setup_fees_5, p0_.setup_fees_discount AS setup_fees_discount_6, p0_.free_period AS free_period_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p1_.id AS id_10, p1_.enabled AS enabled_11, p1_.highlighted AS highlighted_12, p1_.view_order AS view_order_13, p1_.action_target AS action_target_14, p1_.createdAt AS createdAt_15, p1_.updated_at AS updated_at_16, p2_.name AS name_17, p2_.description AS description_18, p2_.action_name AS action_name_19, p2_.locale AS locale_20, p3_.id AS id_21, p3_.createdAt AS createdAt_22, p3_.updated_at AS updated_at_23, p4_.name AS name_24, p4_.locale AS locale_25, p0_.package_label_id AS package_label_id_26, p0_.created_by_id AS created_by_id_27, p0_.updated_by AS updated_by_28, p1_.created_by AS created_by_29, p1_.updated_by AS updated_by_30, p2_.id AS id_31, p3_.created_by AS created_by_32, p3_.updated_by AS updated_by_33, p4_.id AS id_34 FROM package p0_ INNER JOIN package_label p1_ ON p0_.package_label_id = p1_.id INNER JOIN package_label_translation p2_ ON p1_.id = p2_.id AND (p2_.locale = 'en') LEFT JOIN package_label_package_benefit p5_ ON p1_.id = p5_.package_label_id LEFT JOIN package_benefit p3_ ON p3_.id = p5_.package_benefit_id LEFT JOIN package_benefit_translation p4_ ON p3_.id = p4_.id AND (p4_.locale = 'en') WHERE p1_.enabled = 1 AND p0_.id IN ('1', '2', '3') ORDER BY p1_.view_order ASC, p1_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tag AS tag_3,
  t0.is_enabled AS is_enabled_4,
  t0.is_system AS is_system_5,
  t0.has_attachments AS has_attachments_6,
  t0.view_order AS view_order_7,
  t0.locale AS locale_8
FROM
  contact_us_category t0
WHERE
  t0.id = ?
  AND (
    (t0.locale = 'en')
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.is_enabled AS is_enabled_4, t0.is_system AS is_system_5, t0.has_attachments AS has_attachments_6, t0.view_order AS view_order_7, t0.locale AS locale_8 FROM contact_us_category t0 WHERE t0.id = 2 AND ((t0.locale = 'en'));

SELECT
  c0_.id AS id_0,
  c0_.alpha3_code AS alpha3_code_1,
  c0_.numeric_code AS numeric_code_2,
  c0_.calling_code AS calling_code_3,
  c0_.default_locale AS default_locale_4,
  c1_.name AS name_5,
  c1_.locale AS locale_6,
  c1_.id AS id_7
FROM
  country c0_
  INNER JOIN country_translation c1_ ON c0_.id = c1_.id
  AND (c1_.locale = 'en')
WHERE
  c1_.locale = ?
ORDER BY
  c1_.name ASC

SELECT c0_.id AS id_0, c0_.alpha3_code AS alpha3_code_1, c0_.numeric_code AS numeric_code_2, c0_.calling_code AS calling_code_3, c0_.default_locale AS default_locale_4, c1_.name AS name_5, c1_.locale AS locale_6, c1_.id AS id_7 FROM country c0_ INNER JOIN country_translation c1_ ON c0_.id = c1_.id AND (c1_.locale = 'en') WHERE c1_.locale = 'en' ORDER BY c1_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.tag AS tag_2,
  c0_.is_enabled AS is_enabled_3,
  c0_.is_system AS is_system_4,
  c0_.has_attachments AS has_attachments_5,
  c0_.view_order AS view_order_6,
  c0_.locale AS locale_7
FROM
  contact_us_category c0_
WHERE
  (c0_.is_enabled = 1)
  AND (c0_.locale = 'en')

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.tag AS tag_2, c0_.is_enabled AS is_enabled_3, c0_.is_system AS is_system_4, c0_.has_attachments AS has_attachments_5, c0_.view_order AS view_order_6, c0_.locale AS locale_7 FROM contact_us_category c0_ WHERE (c0_.is_enabled = 1) AND (c0_.locale = 'en');