Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.taxdown_id AS taxdown_id_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.nif AS nif_7,
  t0.birth_date AS birth_date_8,
  t0.nationality AS nationality_9,
  t0.mobile AS mobile_10,
  t0.email AS email_11,
  t0.id_cliente_sefide AS id_cliente_sefide_12,
  t0.updated_at AS updated_at_13,
  t0.sso_id AS sso_id_14,
  t0.sso_metadata AS sso_metadata_15,
  t0.created_at AS created_at_16,
  t0.skip_inform_to_tax_down AS skip_inform_to_tax_down_17,
  t18.naturaleza_juridica AS naturaleza_juridica_19,
  t18.situacion_juridica AS situacion_juridica_20,
  t18.cnae AS cnae_21,
  t18.iae AS iae_22,
  t18.inscrita_en AS inscrita_en_23,
  t18.num_inscripcion_registral AS num_inscripcion_registral_24,
  t18.fec_inscripcion_registral AS fec_inscripcion_registral_25,
  t18.nivel_rrpp AS nivel_rrpp_26,
  t18.nivel_ingresos AS nivel_ingresos_27,
  t18.volumen_ventas AS volumen_ventas_28,
  t18.objeto_social AS objeto_social_29,
  t18.numero_sucursales AS numero_sucursales_30,
  t18.paises_donde_opera AS paises_donde_opera_31,
  t18.created_at AS created_at_32,
  t18.updated_at AS updated_at_33,
  t18.id AS id_34,
  t18.skip_inform_to_tax_down AS skip_inform_to_tax_down_35,
  t18.applicant_id AS applicant_id_36
FROM
  applicant t0
  LEFT JOIN legal_entity t18 ON t18.applicant_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.taxdown_id AS taxdown_id_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.nif AS nif_7, t0.birth_date AS birth_date_8, t0.nationality AS nationality_9, t0.mobile AS mobile_10, t0.email AS email_11, t0.id_cliente_sefide AS id_cliente_sefide_12, t0.updated_at AS updated_at_13, t0.sso_id AS sso_id_14, t0.sso_metadata AS sso_metadata_15, t0.created_at AS created_at_16, t0.skip_inform_to_tax_down AS skip_inform_to_tax_down_17, t18.naturaleza_juridica AS naturaleza_juridica_19, t18.situacion_juridica AS situacion_juridica_20, t18.cnae AS cnae_21, t18.iae AS iae_22, t18.inscrita_en AS inscrita_en_23, t18.num_inscripcion_registral AS num_inscripcion_registral_24, t18.fec_inscripcion_registral AS fec_inscripcion_registral_25, t18.nivel_rrpp AS nivel_rrpp_26, t18.nivel_ingresos AS nivel_ingresos_27, t18.volumen_ventas AS volumen_ventas_28, t18.objeto_social AS objeto_social_29, t18.numero_sucursales AS numero_sucursales_30, t18.paises_donde_opera AS paises_donde_opera_31, t18.created_at AS created_at_32, t18.updated_at AS updated_at_33, t18.id AS id_34, t18.skip_inform_to_tax_down AS skip_inform_to_tax_down_35, t18.applicant_id AS applicant_id_36 FROM applicant t0 LEFT JOIN legal_entity t18 ON t18.applicant_id = t0.id WHERE t0.id = 'f678ec7a-db38-448a-81c4-93c382064427';

SELECT
  id
FROM
  white_label
WHERE
  is_active = 1
  AND (
    -- Búsqueda exacta en platform_domains
    JSON_SEARCH(
      platforms, 'one', ?, NULL, '$[*].platform_domains[*]'
    ) IS NOT NULL
    OR JSON_SEARCH(
      platforms, 'one', ?, NULL, '$[*].platform_domains[*]'
    ) IS NOT NULL -- Búsqueda exacta en origin_urls
    OR JSON_CONTAINS(origin_urls, ?)
    OR JSON_CONTAINS(origin_urls, ?) -- Búsqueda por dominio base en origin_urls (ej: iodapp.com)
    OR (
      ? != ''
      AND (
        origin_urls LIKE CONCAT('%', ?, '%')
        OR sso_domain LIKE CONCAT('%', ?, '%')
      )
    )
  )
ORDER BY
  (
    -- Prioridad 1: coincidencia exacta en platform_domains
    CASE WHEN JSON_SEARCH(
      platforms, 'one', ?, NULL, '$[*].platform_domains[*]'
    ) IS NOT NULL THEN
      1
    WHEN JSON_SEARCH(
      platforms, 'one', ?, NULL, '$[*].platform_domains[*]'
    ) IS NOT NULL THEN
      1
    ELSE
      0
    END
  ) DESC,
  (
    -- Prioridad 2: coincidencia exacta en origin_urls
    CASE WHEN JSON_CONTAINS(origin_urls, ?) THEN
      1
    WHEN JSON_CONTAINS(origin_urls, ?) THEN
      1
    ELSE
      0
    END
  ) DESC
LIMIT
  1

SELECT id
            FROM white_label
            WHERE is_active = 1
            AND (
                -- Búsqueda exacta en platform_domains
                JSON_SEARCH(platforms, 'one', 'https://wallet.iodapp.com/', NULL, '$[*].platform_domains[*]') IS NOT NULL
                OR JSON_SEARCH(platforms, 'one', 'https://wallet.iodapp.com', NULL, '$[*].platform_domains[*]') IS NOT NULL
                -- Búsqueda exacta en origin_urls
                OR JSON_CONTAINS(origin_urls, '\"https:\\/\\/wallet.iodapp.com\\/\"')
                OR JSON_CONTAINS(origin_urls, '\"https:\\/\\/wallet.iodapp.com\"')
                -- Búsqueda por dominio base en origin_urls (ej: iodapp.com)
                OR (
                    'iodapp.com' != ''
                    AND (
                        origin_urls LIKE CONCAT('%', 'iodapp.com', '%')
                        OR sso_domain LIKE CONCAT('%', 'iodapp.com', '%')
                    )
                )
            )
            ORDER BY (
                -- Prioridad 1: coincidencia exacta en platform_domains
                CASE WHEN JSON_SEARCH(platforms, 'one', 'https://wallet.iodapp.com/', NULL, '$[*].platform_domains[*]') IS NOT NULL THEN 1
                     WHEN JSON_SEARCH(platforms, 'one', 'https://wallet.iodapp.com', NULL, '$[*].platform_domains[*]') IS NOT NULL THEN 1
                     ELSE 0 END
            ) DESC, (
                -- Prioridad 2: coincidencia exacta en origin_urls
                CASE WHEN JSON_CONTAINS(origin_urls, '\"https:\\/\\/wallet.iodapp.com\\/\"') THEN 1
                     WHEN JSON_CONTAINS(origin_urls, '\"https:\\/\\/wallet.iodapp.com\"') THEN 1
                     ELSE 0 END
            ) DESC
            LIMIT 1
        ;

SELECT
  t0.id AS id_1,
  t0.white_label_id AS white_label_id_2,
  t0.company_name AS company_name_3,
  t0.login_title AS login_title_4,
  t0.logo_url AS logo_url_5,
  t0.primary_color AS primary_color_6,
  t0.background_color AS background_color_7,
  t0.text_color AS text_color_8,
  t0.terms_url AS terms_url_9,
  t0.privacy_policy_url AS privacy_policy_url_10,
  t0.sso_domain AS sso_domain_11,
  t0.origin_urls AS origin_urls_12,
  t0.is_active AS is_active_13,
  t0.platforms AS platforms_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.sync_version AS sync_version_17
FROM
  white_label t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.white_label_id AS white_label_id_2, t0.company_name AS company_name_3, t0.login_title AS login_title_4, t0.logo_url AS logo_url_5, t0.primary_color AS primary_color_6, t0.background_color AS background_color_7, t0.text_color AS text_color_8, t0.terms_url AS terms_url_9, t0.privacy_policy_url AS privacy_policy_url_10, t0.sso_domain AS sso_domain_11, t0.origin_urls AS origin_urls_12, t0.is_active AS is_active_13, t0.platforms AS platforms_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.sync_version AS sync_version_17 FROM white_label t0 WHERE t0.id = '3e59a9a9-0ad1-45ac-8ca7-b5f4109a3d10';

SELECT
  s0_.operation_type AS operation_type_0,
  s0_.operation_id AS operation_id_1,
  s0_.data AS data_2,
  s0_.status AS status_3,
  s0_.created_at AS created_at_4,
  s0_.updated_at AS updated_at_5,
  s0_.id AS id_6,
  s0_.skip_inform_to_tax_down AS skip_inform_to_tax_down_7,
  s0_.applicant_id AS applicant_id_8
FROM
  scheduled_operation s0_
WHERE
  s0_.status IN (?, ?)
  AND s0_.operation_id IS NOT NULL
ORDER BY
  s0_.created_at DESC

SELECT s0_.operation_type AS operation_type_0, s0_.operation_id AS operation_id_1, s0_.data AS data_2, s0_.status AS status_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.skip_inform_to_tax_down AS skip_inform_to_tax_down_7, s0_.applicant_id AS applicant_id_8 FROM scheduled_operation s0_ WHERE s0_.status IN ('sca_pending', 'error') AND s0_.operation_id IS NOT NULL ORDER BY s0_.created_at DESC;

SELECT
  DISTINCT c0_.user_email AS user_email_0
FROM
  company_assignment c0_
WHERE
  c0_.company_id IN (
    SELECT
      DISTINCT c1_.company_id
    FROM
      company_assignment c1_
    WHERE
      c1_.admin_email = ?
  )

SELECT DISTINCT c0_.user_email AS user_email_0 FROM company_assignment c0_ WHERE c0_.company_id IN (SELECT DISTINCT c1_.company_id FROM company_assignment c1_ WHERE c1_.admin_email = 'angeles.duran@armaturacapital.es');

SELECT
  DISTINCT c0_.company_id AS company_id_0
FROM
  company_assignment c0_
WHERE
  c0_.admin_email = ?

SELECT DISTINCT c0_.company_id AS company_id_0 FROM company_assignment c0_ WHERE c0_.admin_email = 'angeles.duran@armaturacapital.es';

SELECT
  DISTINCT c0_.admin_email AS admin_email_0
FROM
  company_assignment c0_
WHERE
  c0_.company_id IN (?)
  AND c0_.admin_email IS NOT NULL
ORDER BY
  c0_.admin_email ASC

SELECT DISTINCT c0_.admin_email AS admin_email_0 FROM company_assignment c0_ WHERE c0_.company_id IN ('c56a7f57-b3a6-463d-9b6a-68c41524b385') AND c0_.admin_email IS NOT NULL ORDER BY c0_.admin_email ASC;

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.created_at AS created_at_1
FROM
  scheduled_operation s0_
  LEFT JOIN applicant a1_ ON s0_.applicant_id = a1_.id
WHERE
  a1_.email IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  s0_.created_at DESC
LIMIT
  20
OFFSET
  60

SELECT DISTINCT s0_.id AS id_0, s0_.created_at AS created_at_1 FROM scheduled_operation s0_ LEFT JOIN applicant a1_ ON s0_.applicant_id = a1_.id WHERE a1_.email IN ('administracion@magnusretail.es', 'admin@biotech3d.es', 'loli@punzomet.com', 'jaimguerrero@gmail.com', 'rcintas@teamplv.com', 'info@hummel.es', 'christian@flexomed.com', 'dterranova@magnusretail.es', 'SAYACHAWEZ@GMAIL.COM', 'team@teamplv.com', 'jbardaxo@yahoo.es', 'salvador.perez@hummel.es', 'sunnygo.invest@gmail.com', 'INTRUSTIAL', 'lmmeheras1@hotmail.es', 'financiero@teamplv.com', 'contacto@puma.net', 'intrustial@smartescrow.es', 'alejandrasmr999@gmail.com', 'marina', 'service@puma.com', 'bsch@fortuna-cp.com', 'e.ballester@evaballester.com', 'dmartin@teamplv.com', 'contact@biotech3d.es', 'obras', 'mdelanava@intrustial.com', 'eaglehardGestion@eaglehardGestion.com', 'jmperez@oteros.es', 'raul@flexomed.com', 'jgonzalez@newater.es', 'gerencia@puertomarinashopping.es', 'angeles.duran@hotmail.es', 'administracion@armaturacapital.es', 'alberto.ortega@armaturacapital.es', 'alberto.ortega@iodapplications.com', 'alberto.ortega@iodapplications.es', 'andres.galindo@armaturacapital.es', 'angeles.duran@armaturacapital.es') ORDER BY s0_.created_at DESC LIMIT 20 OFFSET 60;

SELECT
  s0_.operation_type AS operation_type_0,
  s0_.operation_id AS operation_id_1,
  s0_.data AS data_2,
  s0_.status AS status_3,
  s0_.created_at AS created_at_4,
  s0_.updated_at AS updated_at_5,
  s0_.id AS id_6,
  s0_.skip_inform_to_tax_down AS skip_inform_to_tax_down_7,
  s0_.applicant_id AS applicant_id_8
FROM
  scheduled_operation s0_
  LEFT JOIN applicant a1_ ON s0_.applicant_id = a1_.id
WHERE
  a1_.email IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  s0_.created_at DESC

SELECT s0_.operation_type AS operation_type_0, s0_.operation_id AS operation_id_1, s0_.data AS data_2, s0_.status AS status_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6, s0_.skip_inform_to_tax_down AS skip_inform_to_tax_down_7, s0_.applicant_id AS applicant_id_8 FROM scheduled_operation s0_ LEFT JOIN applicant a1_ ON s0_.applicant_id = a1_.id WHERE a1_.email IN ('administracion@magnusretail.es', 'admin@biotech3d.es', 'loli@punzomet.com', 'jaimguerrero@gmail.com', 'rcintas@teamplv.com', 'info@hummel.es', 'christian@flexomed.com', 'dterranova@magnusretail.es', 'SAYACHAWEZ@GMAIL.COM', 'team@teamplv.com', 'jbardaxo@yahoo.es', 'salvador.perez@hummel.es', 'sunnygo.invest@gmail.com', 'INTRUSTIAL', 'lmmeheras1@hotmail.es', 'financiero@teamplv.com', 'contacto@puma.net', 'intrustial@smartescrow.es', 'alejandrasmr999@gmail.com', 'marina', 'service@puma.com', 'bsch@fortuna-cp.com', 'e.ballester@evaballester.com', 'dmartin@teamplv.com', 'contact@biotech3d.es', 'obras', 'mdelanava@intrustial.com', 'eaglehardGestion@eaglehardGestion.com', 'jmperez@oteros.es', 'raul@flexomed.com', 'jgonzalez@newater.es', 'gerencia@puertomarinashopping.es', 'angeles.duran@hotmail.es', 'administracion@armaturacapital.es', 'alberto.ortega@armaturacapital.es', 'alberto.ortega@iodapplications.com', 'alberto.ortega@iodapplications.es', 'andres.galindo@armaturacapital.es', 'angeles.duran@armaturacapital.es') AND s0_.id IN ('ec6a3d0f-00c5-4c5e-8621-0c2ed66ca0bd', '06f0c846-5ccc-4a52-91a9-f2f4c49baa57', '4b47a32b-2722-420f-aaef-191718227c34', 'bd0b6061-45a6-4b46-8c78-290d25029968', 'c798391f-d29e-447a-b8b2-293714473f18', 'e9c92ec8-ba7b-4423-949c-170116258418', 'e2eee16c-61e9-4716-a53e-ac8e667e021e', '8c16057c-f711-415c-a268-cf13b75fddcd', '85ec24a7-334b-4c8f-8b74-04aa8ec33243', '17fc9af1-6626-4688-a2bd-f6ce4f0b5dac', '8ce85c6e-d512-4bec-a9a0-26e2a45f9941', '0e289b20-00d8-451c-933a-b031bc362df2', '6f962c09-4562-4e22-9e3d-9e8d7ef9a5ab', 'caa4d0ef-e3ff-4690-9f86-07f6add65fd9', '94340920-428a-4eba-8996-c2a270a661b5', '4bec71f9-a081-4c61-8741-f54642937332', '505ecc79-5d18-4736-b186-4e66adf58b38', 'e2a03e78-bdc1-4b8f-919d-14f7a30fb0ef', '687363a1-a4c1-477d-9e94-4ad948e3173c', 'd56c137a-e950-455a-ab31-31697634b01c') ORDER BY s0_.created_at DESC;

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  scheduled_operation s0_
  LEFT JOIN applicant a1_ ON s0_.applicant_id = a1_.id
WHERE
  a1_.email IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM scheduled_operation s0_ LEFT JOIN applicant a1_ ON s0_.applicant_id = a1_.id WHERE a1_.email IN ('administracion@magnusretail.es', 'admin@biotech3d.es', 'loli@punzomet.com', 'jaimguerrero@gmail.com', 'rcintas@teamplv.com', 'info@hummel.es', 'christian@flexomed.com', 'dterranova@magnusretail.es', 'SAYACHAWEZ@GMAIL.COM', 'team@teamplv.com', 'jbardaxo@yahoo.es', 'salvador.perez@hummel.es', 'sunnygo.invest@gmail.com', 'INTRUSTIAL', 'lmmeheras1@hotmail.es', 'financiero@teamplv.com', 'contacto@puma.net', 'intrustial@smartescrow.es', 'alejandrasmr999@gmail.com', 'marina', 'service@puma.com', 'bsch@fortuna-cp.com', 'e.ballester@evaballester.com', 'dmartin@teamplv.com', 'contact@biotech3d.es', 'obras', 'mdelanava@intrustial.com', 'eaglehardGestion@eaglehardGestion.com', 'jmperez@oteros.es', 'raul@flexomed.com', 'jgonzalez@newater.es', 'gerencia@puertomarinashopping.es', 'angeles.duran@hotmail.es', 'administracion@armaturacapital.es', 'alberto.ortega@armaturacapital.es', 'alberto.ortega@iodapplications.com', 'alberto.ortega@iodapplications.es', 'andres.galindo@armaturacapital.es', 'angeles.duran@armaturacapital.es');

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.taxdown_id AS taxdown_id_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.nif AS nif_7,
  t0.birth_date AS birth_date_8,
  t0.nationality AS nationality_9,
  t0.mobile AS mobile_10,
  t0.email AS email_11,
  t0.id_cliente_sefide AS id_cliente_sefide_12,
  t0.updated_at AS updated_at_13,
  t0.sso_id AS sso_id_14,
  t0.sso_metadata AS sso_metadata_15,
  t0.created_at AS created_at_16,
  t0.skip_inform_to_tax_down AS skip_inform_to_tax_down_17,
  t18.naturaleza_juridica AS naturaleza_juridica_19,
  t18.situacion_juridica AS situacion_juridica_20,
  t18.cnae AS cnae_21,
  t18.iae AS iae_22,
  t18.inscrita_en AS inscrita_en_23,
  t18.num_inscripcion_registral AS num_inscripcion_registral_24,
  t18.fec_inscripcion_registral AS fec_inscripcion_registral_25,
  t18.nivel_rrpp AS nivel_rrpp_26,
  t18.nivel_ingresos AS nivel_ingresos_27,
  t18.volumen_ventas AS volumen_ventas_28,
  t18.objeto_social AS objeto_social_29,
  t18.numero_sucursales AS numero_sucursales_30,
  t18.paises_donde_opera AS paises_donde_opera_31,
  t18.created_at AS created_at_32,
  t18.updated_at AS updated_at_33,
  t18.id AS id_34,
  t18.skip_inform_to_tax_down AS skip_inform_to_tax_down_35,
  t18.applicant_id AS applicant_id_36
FROM
  applicant t0
  LEFT JOIN legal_entity t18 ON t18.applicant_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.taxdown_id AS taxdown_id_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.nif AS nif_7, t0.birth_date AS birth_date_8, t0.nationality AS nationality_9, t0.mobile AS mobile_10, t0.email AS email_11, t0.id_cliente_sefide AS id_cliente_sefide_12, t0.updated_at AS updated_at_13, t0.sso_id AS sso_id_14, t0.sso_metadata AS sso_metadata_15, t0.created_at AS created_at_16, t0.skip_inform_to_tax_down AS skip_inform_to_tax_down_17, t18.naturaleza_juridica AS naturaleza_juridica_19, t18.situacion_juridica AS situacion_juridica_20, t18.cnae AS cnae_21, t18.iae AS iae_22, t18.inscrita_en AS inscrita_en_23, t18.num_inscripcion_registral AS num_inscripcion_registral_24, t18.fec_inscripcion_registral AS fec_inscripcion_registral_25, t18.nivel_rrpp AS nivel_rrpp_26, t18.nivel_ingresos AS nivel_ingresos_27, t18.volumen_ventas AS volumen_ventas_28, t18.objeto_social AS objeto_social_29, t18.numero_sucursales AS numero_sucursales_30, t18.paises_donde_opera AS paises_donde_opera_31, t18.created_at AS created_at_32, t18.updated_at AS updated_at_33, t18.id AS id_34, t18.skip_inform_to_tax_down AS skip_inform_to_tax_down_35, t18.applicant_id AS applicant_id_36 FROM applicant t0 LEFT JOIN legal_entity t18 ON t18.applicant_id = t0.id WHERE t0.id = '83482df0-36d3-4d36-a547-4d06ea98483a';

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.taxdown_id AS taxdown_id_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.nif AS nif_7,
  t0.birth_date AS birth_date_8,
  t0.nationality AS nationality_9,
  t0.mobile AS mobile_10,
  t0.email AS email_11,
  t0.id_cliente_sefide AS id_cliente_sefide_12,
  t0.updated_at AS updated_at_13,
  t0.sso_id AS sso_id_14,
  t0.sso_metadata AS sso_metadata_15,
  t0.created_at AS created_at_16,
  t0.skip_inform_to_tax_down AS skip_inform_to_tax_down_17,
  t18.naturaleza_juridica AS naturaleza_juridica_19,
  t18.situacion_juridica AS situacion_juridica_20,
  t18.cnae AS cnae_21,
  t18.iae AS iae_22,
  t18.inscrita_en AS inscrita_en_23,
  t18.num_inscripcion_registral AS num_inscripcion_registral_24,
  t18.fec_inscripcion_registral AS fec_inscripcion_registral_25,
  t18.nivel_rrpp AS nivel_rrpp_26,
  t18.nivel_ingresos AS nivel_ingresos_27,
  t18.volumen_ventas AS volumen_ventas_28,
  t18.objeto_social AS objeto_social_29,
  t18.numero_sucursales AS numero_sucursales_30,
  t18.paises_donde_opera AS paises_donde_opera_31,
  t18.created_at AS created_at_32,
  t18.updated_at AS updated_at_33,
  t18.id AS id_34,
  t18.skip_inform_to_tax_down AS skip_inform_to_tax_down_35,
  t18.applicant_id AS applicant_id_36
FROM
  applicant t0
  LEFT JOIN legal_entity t18 ON t18.applicant_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.taxdown_id AS taxdown_id_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.nif AS nif_7, t0.birth_date AS birth_date_8, t0.nationality AS nationality_9, t0.mobile AS mobile_10, t0.email AS email_11, t0.id_cliente_sefide AS id_cliente_sefide_12, t0.updated_at AS updated_at_13, t0.sso_id AS sso_id_14, t0.sso_metadata AS sso_metadata_15, t0.created_at AS created_at_16, t0.skip_inform_to_tax_down AS skip_inform_to_tax_down_17, t18.naturaleza_juridica AS naturaleza_juridica_19, t18.situacion_juridica AS situacion_juridica_20, t18.cnae AS cnae_21, t18.iae AS iae_22, t18.inscrita_en AS inscrita_en_23, t18.num_inscripcion_registral AS num_inscripcion_registral_24, t18.fec_inscripcion_registral AS fec_inscripcion_registral_25, t18.nivel_rrpp AS nivel_rrpp_26, t18.nivel_ingresos AS nivel_ingresos_27, t18.volumen_ventas AS volumen_ventas_28, t18.objeto_social AS objeto_social_29, t18.numero_sucursales AS numero_sucursales_30, t18.paises_donde_opera AS paises_donde_opera_31, t18.created_at AS created_at_32, t18.updated_at AS updated_at_33, t18.id AS id_34, t18.skip_inform_to_tax_down AS skip_inform_to_tax_down_35, t18.applicant_id AS applicant_id_36 FROM applicant t0 LEFT JOIN legal_entity t18 ON t18.applicant_id = t0.id WHERE t0.id = '0';

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.taxdown_id AS taxdown_id_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.nif AS nif_7,
  t0.birth_date AS birth_date_8,
  t0.nationality AS nationality_9,
  t0.mobile AS mobile_10,
  t0.email AS email_11,
  t0.id_cliente_sefide AS id_cliente_sefide_12,
  t0.updated_at AS updated_at_13,
  t0.sso_id AS sso_id_14,
  t0.sso_metadata AS sso_metadata_15,
  t0.created_at AS created_at_16,
  t0.skip_inform_to_tax_down AS skip_inform_to_tax_down_17,
  t18.naturaleza_juridica AS naturaleza_juridica_19,
  t18.situacion_juridica AS situacion_juridica_20,
  t18.cnae AS cnae_21,
  t18.iae AS iae_22,
  t18.inscrita_en AS inscrita_en_23,
  t18.num_inscripcion_registral AS num_inscripcion_registral_24,
  t18.fec_inscripcion_registral AS fec_inscripcion_registral_25,
  t18.nivel_rrpp AS nivel_rrpp_26,
  t18.nivel_ingresos AS nivel_ingresos_27,
  t18.volumen_ventas AS volumen_ventas_28,
  t18.objeto_social AS objeto_social_29,
  t18.numero_sucursales AS numero_sucursales_30,
  t18.paises_donde_opera AS paises_donde_opera_31,
  t18.created_at AS created_at_32,
  t18.updated_at AS updated_at_33,
  t18.id AS id_34,
  t18.skip_inform_to_tax_down AS skip_inform_to_tax_down_35,
  t18.applicant_id AS applicant_id_36
FROM
  applicant t0
  LEFT JOIN legal_entity t18 ON t18.applicant_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.taxdown_id AS taxdown_id_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.nif AS nif_7, t0.birth_date AS birth_date_8, t0.nationality AS nationality_9, t0.mobile AS mobile_10, t0.email AS email_11, t0.id_cliente_sefide AS id_cliente_sefide_12, t0.updated_at AS updated_at_13, t0.sso_id AS sso_id_14, t0.sso_metadata AS sso_metadata_15, t0.created_at AS created_at_16, t0.skip_inform_to_tax_down AS skip_inform_to_tax_down_17, t18.naturaleza_juridica AS naturaleza_juridica_19, t18.situacion_juridica AS situacion_juridica_20, t18.cnae AS cnae_21, t18.iae AS iae_22, t18.inscrita_en AS inscrita_en_23, t18.num_inscripcion_registral AS num_inscripcion_registral_24, t18.fec_inscripcion_registral AS fec_inscripcion_registral_25, t18.nivel_rrpp AS nivel_rrpp_26, t18.nivel_ingresos AS nivel_ingresos_27, t18.volumen_ventas AS volumen_ventas_28, t18.objeto_social AS objeto_social_29, t18.numero_sucursales AS numero_sucursales_30, t18.paises_donde_opera AS paises_donde_opera_31, t18.created_at AS created_at_32, t18.updated_at AS updated_at_33, t18.id AS id_34, t18.skip_inform_to_tax_down AS skip_inform_to_tax_down_35, t18.applicant_id AS applicant_id_36 FROM applicant t0 LEFT JOIN legal_entity t18 ON t18.applicant_id = t0.id WHERE t0.id = '0';

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.taxdown_id AS taxdown_id_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.nif AS nif_7,
  t0.birth_date AS birth_date_8,
  t0.nationality AS nationality_9,
  t0.mobile AS mobile_10,
  t0.email AS email_11,
  t0.id_cliente_sefide AS id_cliente_sefide_12,
  t0.updated_at AS updated_at_13,
  t0.sso_id AS sso_id_14,
  t0.sso_metadata AS sso_metadata_15,
  t0.created_at AS created_at_16,
  t0.skip_inform_to_tax_down AS skip_inform_to_tax_down_17,
  t18.naturaleza_juridica AS naturaleza_juridica_19,
  t18.situacion_juridica AS situacion_juridica_20,
  t18.cnae AS cnae_21,
  t18.iae AS iae_22,
  t18.inscrita_en AS inscrita_en_23,
  t18.num_inscripcion_registral AS num_inscripcion_registral_24,
  t18.fec_inscripcion_registral AS fec_inscripcion_registral_25,
  t18.nivel_rrpp AS nivel_rrpp_26,
  t18.nivel_ingresos AS nivel_ingresos_27,
  t18.volumen_ventas AS volumen_ventas_28,
  t18.objeto_social AS objeto_social_29,
  t18.numero_sucursales AS numero_sucursales_30,
  t18.paises_donde_opera AS paises_donde_opera_31,
  t18.created_at AS created_at_32,
  t18.updated_at AS updated_at_33,
  t18.id AS id_34,
  t18.skip_inform_to_tax_down AS skip_inform_to_tax_down_35,
  t18.applicant_id AS applicant_id_36
FROM
  applicant t0
  LEFT JOIN legal_entity t18 ON t18.applicant_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.taxdown_id AS taxdown_id_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.nif AS nif_7, t0.birth_date AS birth_date_8, t0.nationality AS nationality_9, t0.mobile AS mobile_10, t0.email AS email_11, t0.id_cliente_sefide AS id_cliente_sefide_12, t0.updated_at AS updated_at_13, t0.sso_id AS sso_id_14, t0.sso_metadata AS sso_metadata_15, t0.created_at AS created_at_16, t0.skip_inform_to_tax_down AS skip_inform_to_tax_down_17, t18.naturaleza_juridica AS naturaleza_juridica_19, t18.situacion_juridica AS situacion_juridica_20, t18.cnae AS cnae_21, t18.iae AS iae_22, t18.inscrita_en AS inscrita_en_23, t18.num_inscripcion_registral AS num_inscripcion_registral_24, t18.fec_inscripcion_registral AS fec_inscripcion_registral_25, t18.nivel_rrpp AS nivel_rrpp_26, t18.nivel_ingresos AS nivel_ingresos_27, t18.volumen_ventas AS volumen_ventas_28, t18.objeto_social AS objeto_social_29, t18.numero_sucursales AS numero_sucursales_30, t18.paises_donde_opera AS paises_donde_opera_31, t18.created_at AS created_at_32, t18.updated_at AS updated_at_33, t18.id AS id_34, t18.skip_inform_to_tax_down AS skip_inform_to_tax_down_35, t18.applicant_id AS applicant_id_36 FROM applicant t0 LEFT JOIN legal_entity t18 ON t18.applicant_id = t0.id WHERE t0.id = '0';