Symfony Profiler

SELECT
  t0.id AS id_3,
  t0.email AS email_4,
  t0.roles AS roles_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.sso_id AS sso_id_8,
  t0.sso_metadata AS sso_metadata_9,
  t0.password AS password_10,
  t0.api_key AS api_key_11,
  t0.discriminator,
  t1.social_denomination AS social_denomination_12,
  t1.vat_number AS vat_number_13,
  t1.contract_url AS contract_url_14,
  t1.csv_filename AS csv_filename_15,
  t1.contact_person AS contact_person_16,
  t1.type_person AS type_person_17,
  t1.adress AS adress_18,
  t1.postal_code AS postal_code_19,
  t1.country AS country_20,
  t1.phone_number AS phone_number_21,
  t1.company_name AS company_name_22,
  t1.nationality AS nationality_23,
  t1.name_lastname AS name_lastname_24,
  t1.dni AS dni_25,
  t1.quality AS quality_26,
  t2.default_number_days AS default_number_days_27,
  t2.default_tin_percentage AS default_tin_percentage_28,
  t2.default_opening_percentage AS default_opening_percentage_29,
  t2.default_nominal_cost AS default_nominal_cost_30,
  t2.main_contract_url AS main_contract_url_31,
  t2.social_denomination AS social_denomination_32,
  t2.csv_filename AS csv_filename_33,
  t2.referred AS referred_34,
  t2.contact_person AS contact_person_35,
  t2.number_phone AS number_phone_36,
  t2.contact_name AS contact_name_37,
  t2.company_name AS company_name_38,
  t2.nationality AS nationality_39,
  t2.name_lastname AS name_lastname_40,
  t2.dni AS dni_41,
  t2.quality AS quality_42,
  t2.adress AS adress_43,
  t2.type_person AS type_person_44,
  t2.vat_number AS vat_number_45
FROM
  `user` t0
  LEFT JOIN investor_user t1 ON t0.id = t1.id
  LEFT JOIN financed_user t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.email AS email_4, t0.roles AS roles_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.sso_id AS sso_id_8, t0.sso_metadata AS sso_metadata_9, t0.password AS password_10, t0.api_key AS api_key_11, t0.discriminator, t1.social_denomination AS social_denomination_12, t1.vat_number AS vat_number_13, t1.contract_url AS contract_url_14, t1.csv_filename AS csv_filename_15, t1.contact_person AS contact_person_16, t1.type_person AS type_person_17, t1.adress AS adress_18, t1.postal_code AS postal_code_19, t1.country AS country_20, t1.phone_number AS phone_number_21, t1.company_name AS company_name_22, t1.nationality AS nationality_23, t1.name_lastname AS name_lastname_24, t1.dni AS dni_25, t1.quality AS quality_26, t2.default_number_days AS default_number_days_27, t2.default_tin_percentage AS default_tin_percentage_28, t2.default_opening_percentage AS default_opening_percentage_29, t2.default_nominal_cost AS default_nominal_cost_30, t2.main_contract_url AS main_contract_url_31, t2.social_denomination AS social_denomination_32, t2.csv_filename AS csv_filename_33, t2.referred AS referred_34, t2.contact_person AS contact_person_35, t2.number_phone AS number_phone_36, t2.contact_name AS contact_name_37, t2.company_name AS company_name_38, t2.nationality AS nationality_39, t2.name_lastname AS name_lastname_40, t2.dni AS dni_41, t2.quality AS quality_42, t2.adress AS adress_43, t2.type_person AS type_person_44, t2.vat_number AS vat_number_45 FROM `user` t0 LEFT JOIN investor_user t1 ON t0.id = t1.id LEFT JOIN financed_user t2 ON t0.id = t2.id WHERE t0.id = 'a07c1085-d3bc-4399-bf0a-7ddc311c282e';

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://factoring.smartescrow.eu/', NULL, '$[*].platform_domains[*]') IS NOT NULL
                OR JSON_SEARCH(platforms, 'one', 'https://factoring.smartescrow.eu', NULL, '$[*].platform_domains[*]') IS NOT NULL
                -- Búsqueda exacta en origin_urls
                OR JSON_CONTAINS(origin_urls, '\"https:\\/\\/factoring.smartescrow.eu\\/\"')
                OR JSON_CONTAINS(origin_urls, '\"https:\\/\\/factoring.smartescrow.eu\"')
                -- Búsqueda por dominio base en origin_urls (ej: iodapp.com)
                OR (
                    'smartescrow.eu' != ''
                    AND (
                        origin_urls LIKE CONCAT('%', 'smartescrow.eu', '%')
                        OR sso_domain LIKE CONCAT('%', 'smartescrow.eu', '%')
                    )
                )
            )
            ORDER BY (
                -- Prioridad 1: coincidencia exacta en platform_domains
                CASE WHEN JSON_SEARCH(platforms, 'one', 'https://factoring.smartescrow.eu/', NULL, '$[*].platform_domains[*]') IS NOT NULL THEN 1
                     WHEN JSON_SEARCH(platforms, 'one', 'https://factoring.smartescrow.eu', 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:\\/\\/factoring.smartescrow.eu\\/\"') THEN 1
                     WHEN JSON_CONTAINS(origin_urls, '\"https:\\/\\/factoring.smartescrow.eu\"') 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.contact_url AS contact_url_11,
  t0.sso_domain AS sso_domain_12,
  t0.origin_urls AS origin_urls_13,
  t0.is_active AS is_active_14,
  t0.platforms AS platforms_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.sync_version AS sync_version_18
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.contact_url AS contact_url_11, t0.sso_domain AS sso_domain_12, t0.origin_urls AS origin_urls_13, t0.is_active AS is_active_14, t0.platforms AS platforms_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.sync_version AS sync_version_18 FROM white_label t0 WHERE t0.id = '914109ba-1f81-4f06-ae62-ba754d17ab6a';

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://factoring.smartescrow.eu/', NULL, '$[*].platform_domains[*]') IS NOT NULL
                OR JSON_SEARCH(platforms, 'one', 'https://factoring.smartescrow.eu', NULL, '$[*].platform_domains[*]') IS NOT NULL
                -- Búsqueda exacta en origin_urls
                OR JSON_CONTAINS(origin_urls, '\"https:\\/\\/factoring.smartescrow.eu\\/\"')
                OR JSON_CONTAINS(origin_urls, '\"https:\\/\\/factoring.smartescrow.eu\"')
                -- Búsqueda por dominio base en origin_urls (ej: iodapp.com)
                OR (
                    'smartescrow.eu' != ''
                    AND (
                        origin_urls LIKE CONCAT('%', 'smartescrow.eu', '%')
                        OR sso_domain LIKE CONCAT('%', 'smartescrow.eu', '%')
                    )
                )
            )
            ORDER BY (
                -- Prioridad 1: coincidencia exacta en platform_domains
                CASE WHEN JSON_SEARCH(platforms, 'one', 'https://factoring.smartescrow.eu/', NULL, '$[*].platform_domains[*]') IS NOT NULL THEN 1
                     WHEN JSON_SEARCH(platforms, 'one', 'https://factoring.smartescrow.eu', 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:\\/\\/factoring.smartescrow.eu\\/\"') THEN 1
                     WHEN JSON_CONTAINS(origin_urls, '\"https:\\/\\/factoring.smartescrow.eu\"') THEN 1
                     ELSE 0 END
            ) DESC
            LIMIT 1
        ;