Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.date_created AS date_created_1,
          p0_.razon_social AS razon_social_2,
          p0_.identification AS identification_3,
          p0_.type_id AS type_id_4,
          p0_.location AS location_5,
          p0_.email AS email_6,
          p0_.phone AS phone_7,
          p0_.tipo_sujeto_retenido AS tipo_sujeto_retenido_8,
          p0_.parte_rel AS parte_rel_9,
          c1_.id AS id_10,
          c1_.auth_num AS auth_num_11,
          c1_.expiration AS expiration_12
        FROM
          provider p0_
          LEFT JOIN client_doc_sustento_attributes c1_ ON p0_.doc_attribute_id = c1_.id
        WHERE
          p0_.company_id = ?
          AND (
            p0_.razon_social LIKE ?
            OR p0_.identification LIKE ?
          )
        ORDER BY
          p0_.razon_social ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.date_created AS date_created_1, p0_.razon_social AS razon_social_2, p0_.identification AS identification_3, p0_.type_id AS type_id_4, p0_.location AS location_5, p0_.email AS email_6, p0_.phone AS phone_7, p0_.tipo_sujeto_retenido AS tipo_sujeto_retenido_8, p0_.parte_rel AS parte_rel_9, c1_.id AS id_10, c1_.auth_num AS auth_num_11, c1_.expiration AS expiration_12 FROM provider p0_ LEFT JOIN client_doc_sustento_attributes c1_ ON p0_.doc_attribute_id = c1_.id WHERE p0_.company_id = 15 AND (p0_.razon_social LIKE '%1001862398001%' OR p0_.identification LIKE '1001862398001%') ORDER BY p0_.razon_social ASC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.razon_social AS razon_social_2,
  t0.ruc AS ruc_3,
  t0.direction AS direction_4,
  t0.email AS email_5,
  t0.serie1 AS serie1_6,
  t0.serie2 AS serie2_7,
  t0.obligado_contabilidad AS obligado_contabilidad_8,
  t0.logo AS logo_9,
  t0.agente_retencion AS agente_retencion_10,
  t0.contribuyente_rimpe AS contribuyente_rimpe_11,
  t0.contribuyente_especial AS contribuyente_especial_12,
  t0.contribuyente_rimpe_text AS contribuyente_rimpe_text_13,
  t0.phone AS phone_14,
  t0.iess AS iess_15,
  t0.period103 AS period103_16,
  t0.user_id AS user_id_17,
  t0.certificate_id AS certificate_id_18,
  t19.id AS id_20,
  t19.company_created AS company_created_21,
  t19.sri_info_id AS sri_info_id_22,
  t23.id AS id_24,
  t23.host AS host_25,
  t23.email AS email_26,
  t23.password AS password_27,
  t23.name AS name_28,
  t23.port AS port_29,
  t23.auto_send AS auto_send_30,
  t23.sri_info_id AS sri_info_id_31,
  t32.id AS id_33,
  t32.show_transporter AS show_transporter_34,
  t32.sucursal_limit AS sucursal_limit_35,
  t32.should_print332_pdf AS should_print332_pdf_36,
  t32.company_id AS company_id_37,
  t0.disabled_by_id AS disabled_by_id_38,
  t39.id AS id_40,
  t39.email AS email_41,
  t39.sri_info_id AS sri_info_id_42
FROM
  sri_info t0
  LEFT JOIN sri_edwin t19 ON t19.sri_info_id = t0.id
  LEFT JOIN email_configuration t23 ON t23.sri_info_id = t0.id
  LEFT JOIN saas_configuration t32 ON t32.company_id = t0.id
  LEFT JOIN email_extra_config t39 ON t39.sri_info_id = t0.id
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.razon_social AS razon_social_2, t0.ruc AS ruc_3, t0.direction AS direction_4, t0.email AS email_5, t0.serie1 AS serie1_6, t0.serie2 AS serie2_7, t0.obligado_contabilidad AS obligado_contabilidad_8, t0.logo AS logo_9, t0.agente_retencion AS agente_retencion_10, t0.contribuyente_rimpe AS contribuyente_rimpe_11, t0.contribuyente_especial AS contribuyente_especial_12, t0.contribuyente_rimpe_text AS contribuyente_rimpe_text_13, t0.phone AS phone_14, t0.iess AS iess_15, t0.period103 AS period103_16, t0.user_id AS user_id_17, t0.certificate_id AS certificate_id_18, t19.id AS id_20, t19.company_created AS company_created_21, t19.sri_info_id AS sri_info_id_22, t23.id AS id_24, t23.host AS host_25, t23.email AS email_26, t23.password AS password_27, t23.name AS name_28, t23.port AS port_29, t23.auto_send AS auto_send_30, t23.sri_info_id AS sri_info_id_31, t32.id AS id_33, t32.show_transporter AS show_transporter_34, t32.sucursal_limit AS sucursal_limit_35, t32.should_print332_pdf AS should_print332_pdf_36, t32.company_id AS company_id_37, t0.disabled_by_id AS disabled_by_id_38, t39.id AS id_40, t39.email AS email_41, t39.sri_info_id AS sri_info_id_42 FROM sri_info t0 LEFT JOIN sri_edwin t19 ON t19.sri_info_id = t0.id LEFT JOIN email_configuration t23 ON t23.sri_info_id = t0.id LEFT JOIN saas_configuration t32 ON t32.company_id = t0.id LEFT JOIN email_extra_config t39 ON t39.sri_info_id = t0.id WHERE t0.user_id = 25;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      razon_social_2
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.date_created AS date_created_1,
          p0_.razon_social AS razon_social_2,
          p0_.identification AS identification_3,
          p0_.type_id AS type_id_4,
          p0_.location AS location_5,
          p0_.email AS email_6,
          p0_.phone AS phone_7,
          p0_.tipo_sujeto_retenido AS tipo_sujeto_retenido_8,
          p0_.parte_rel AS parte_rel_9,
          c1_.id AS id_10,
          c1_.auth_num AS auth_num_11,
          c1_.expiration AS expiration_12
        FROM
          provider p0_
          LEFT JOIN client_doc_sustento_attributes c1_ ON p0_.doc_attribute_id = c1_.id
        WHERE
          p0_.company_id = ?
          AND (
            p0_.razon_social LIKE ?
            OR p0_.identification LIKE ?
          )
      ) dctrn_result_inner
    ORDER BY
      razon_social_2 ASC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, razon_social_2 FROM (SELECT p0_.id AS id_0, p0_.date_created AS date_created_1, p0_.razon_social AS razon_social_2, p0_.identification AS identification_3, p0_.type_id AS type_id_4, p0_.location AS location_5, p0_.email AS email_6, p0_.phone AS phone_7, p0_.tipo_sujeto_retenido AS tipo_sujeto_retenido_8, p0_.parte_rel AS parte_rel_9, c1_.id AS id_10, c1_.auth_num AS auth_num_11, c1_.expiration AS expiration_12 FROM provider p0_ LEFT JOIN client_doc_sustento_attributes c1_ ON p0_.doc_attribute_id = c1_.id WHERE p0_.company_id = 15 AND (p0_.razon_social LIKE '%1001862398001%' OR p0_.identification LIKE '1001862398001%')) dctrn_result_inner ORDER BY razon_social_2 ASC) dctrn_result LIMIT 20;

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.name AS name_6,
  t0.lastname AS lastname_7,
  t0.reset_password_key AS reset_password_key_8,
  t9.id AS id_10,
  t9.phone AS phone_11,
  t9.can_report_main_sucursal AS can_report_main_sucursal_12,
  t9.user_id AS user_id_13,
  t9.sri_info_id AS sri_info_id_14,
  t9.sucursal_id AS sucursal_id_15,
  t0.disabled_by_id AS disabled_by_id_16
FROM
  user t0
  LEFT JOIN employee t9 ON t9.user_id = t0.id
WHERE
  t0.id = ?

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.name AS name_6, t0.lastname AS lastname_7, t0.reset_password_key AS reset_password_key_8, t9.id AS id_10, t9.phone AS phone_11, t9.can_report_main_sucursal AS can_report_main_sucursal_12, t9.user_id AS user_id_13, t9.sri_info_id AS sri_info_id_14, t9.sucursal_id AS sucursal_id_15, t0.disabled_by_id AS disabled_by_id_16 FROM user t0 LEFT JOIN employee t9 ON t9.user_id = t0.id WHERE t0.id = 25;

SELECT
  p0_.id AS id_0,
  p0_.date_created AS date_created_1,
  p0_.razon_social AS razon_social_2,
  p0_.identification AS identification_3,
  p0_.type_id AS type_id_4,
  p0_.location AS location_5,
  p0_.email AS email_6,
  p0_.phone AS phone_7,
  p0_.tipo_sujeto_retenido AS tipo_sujeto_retenido_8,
  p0_.parte_rel AS parte_rel_9,
  c1_.id AS id_10,
  c1_.auth_num AS auth_num_11,
  c1_.expiration AS expiration_12,
  p0_.company_id AS company_id_13,
  p0_.doc_attribute_id AS doc_attribute_id_14
FROM
  provider p0_
  LEFT JOIN client_doc_sustento_attributes c1_ ON p0_.doc_attribute_id = c1_.id
WHERE
  p0_.company_id = ?
  AND (
    p0_.razon_social LIKE ?
    OR p0_.identification LIKE ?
  )
  AND p0_.id IN (?)
ORDER BY
  p0_.razon_social ASC

SELECT p0_.id AS id_0, p0_.date_created AS date_created_1, p0_.razon_social AS razon_social_2, p0_.identification AS identification_3, p0_.type_id AS type_id_4, p0_.location AS location_5, p0_.email AS email_6, p0_.phone AS phone_7, p0_.tipo_sujeto_retenido AS tipo_sujeto_retenido_8, p0_.parte_rel AS parte_rel_9, c1_.id AS id_10, c1_.auth_num AS auth_num_11, c1_.expiration AS expiration_12, p0_.company_id AS company_id_13, p0_.doc_attribute_id AS doc_attribute_id_14 FROM provider p0_ LEFT JOIN client_doc_sustento_attributes c1_ ON p0_.doc_attribute_id = c1_.id WHERE p0_.company_id = 15 AND (p0_.razon_social LIKE '%1001862398001%' OR p0_.identification LIKE '1001862398001%') AND p0_.id IN (9174) ORDER BY p0_.razon_social ASC;