Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.platform_id AS platform_id_1,
  c0_.name AS name_2,
  c0_.alias AS alias_3,
  c0_.cui AS cui_4,
  c0_.reg_com AS reg_com_5,
  c0_.address AS address_6,
  c0_.bank AS bank_7,
  c0_.bank_account AS bank_account_8,
  c0_.contact AS contact_9,
  c0_.email AS email_10,
  c0_.phone AS phone_11,
  c0_.contract_number AS contract_number_12,
  c0_.contract_date AS contract_date_13,
  c0_.payment_method AS payment_method_14,
  c0_.payment_term AS payment_term_15,
  c0_.tax_payer AS tax_payer_16,
  c0_.country AS country_17,
  c0_.county AS county_18,
  c0_.city AS city_19,
  c0_.observation AS observation_20,
  c0_.folder AS folder_21,
  c0_.agent_sales_id AS agent_sales_id_22,
  c0_.user_created AS user_created_23,
  c0_.date_created AS date_created_24,
  c0_.is_active AS is_active_25,
  c1_.payment_term AS payment_term_26,
  s2_.states_name AS states_name_27,
  z3_.zone_name AS zone_name_28,
  u4_.firstname AS firstname_29,
  u4_.lastname AS lastname_30
FROM
  client c0_
  LEFT JOIN config_payment_method c1_ ON (c0_.payment_method = c1_.id)
  LEFT JOIN states s2_ ON (c0_.county = s2_.id)
  LEFT JOIN zones z3_ ON (c0_.city = z3_.zone_id)
  LEFT JOIN user u4_ ON (c0_.agent_sales_id = u4_.id)
WHERE
  c0_.company_id = ?
  AND c0_.platform_id = ?
  AND c0_.id = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.platform_id AS platform_id_1, c0_.name AS name_2, c0_.alias AS alias_3, c0_.cui AS cui_4, c0_.reg_com AS reg_com_5, c0_.address AS address_6, c0_.bank AS bank_7, c0_.bank_account AS bank_account_8, c0_.contact AS contact_9, c0_.email AS email_10, c0_.phone AS phone_11, c0_.contract_number AS contract_number_12, c0_.contract_date AS contract_date_13, c0_.payment_method AS payment_method_14, c0_.payment_term AS payment_term_15, c0_.tax_payer AS tax_payer_16, c0_.country AS country_17, c0_.county AS county_18, c0_.city AS city_19, c0_.observation AS observation_20, c0_.folder AS folder_21, c0_.agent_sales_id AS agent_sales_id_22, c0_.user_created AS user_created_23, c0_.date_created AS date_created_24, c0_.is_active AS is_active_25, c1_.payment_term AS payment_term_26, s2_.states_name AS states_name_27, z3_.zone_name AS zone_name_28, u4_.firstname AS firstname_29, u4_.lastname AS lastname_30 FROM client c0_ LEFT JOIN config_payment_method c1_ ON (c0_.payment_method = c1_.id) LEFT JOIN states s2_ ON (c0_.county = s2_.id) LEFT JOIN zones z3_ ON (c0_.city = z3_.zone_id) LEFT JOIN user u4_ ON (c0_.agent_sales_id = u4_.id) WHERE c0_.company_id = 1 AND c0_.platform_id = 1 AND c0_.id = 465 LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.platform_id AS platform_id_1,
  u0_.role_id AS role_id_2,
  u0_.firstname AS firstname_3,
  u0_.lastname AS lastname_4,
  u0_.email AS email_5,
  u0_.phone AS phone_6,
  u0_.is_active AS is_active_7
FROM
  user u0_
WHERE
  u0_.role_id = ?
  AND u0_.platform_id = ?
  AND u0_.is_active = 1

SELECT u0_.id AS id_0, u0_.platform_id AS platform_id_1, u0_.role_id AS role_id_2, u0_.firstname AS firstname_3, u0_.lastname AS lastname_4, u0_.email AS email_5, u0_.phone AS phone_6, u0_.is_active AS is_active_7 FROM user u0_ WHERE u0_.role_id = 6 AND u0_.platform_id = 1 AND u0_.is_active = 1;

SELECT
  o0_.id AS id_0,
  o0_.client_id AS client_id_1,
  o0_.date_created AS date_created_2,
  o0_.is_active AS is_active_3
FROM
  `order` o0_
WHERE
  o0_.client_id = ?
  AND o0_.company_id = ?
  AND o0_.is_active = ?
ORDER BY
  o0_.id DESC
LIMIT
  30

SELECT o0_.id AS id_0, o0_.client_id AS client_id_1, o0_.date_created AS date_created_2, o0_.is_active AS is_active_3 FROM `order` o0_ WHERE o0_.client_id = 465 AND o0_.company_id = 1 AND o0_.is_active = 1 ORDER BY o0_.id DESC LIMIT 30;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  `order` o0_
WHERE
  o0_.client_id = ?
  AND o0_.company_id = ?
  AND o0_.is_active = ?

SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.client_id = 465 AND o0_.company_id = 1 AND o0_.is_active = 1;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  `order` o0_
WHERE
  o0_.client_id = ?
  AND o0_.company_id = ?
  AND o0_.paid = ?
  AND o0_.is_active = ?

SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.client_id = 465 AND o0_.company_id = 1 AND o0_.paid = 0 AND o0_.is_active = 1;