Symfony Profiler

SELECT 
  i0_.broker_email AS broker_email_0, 
  i0_.broker_realState AS broker_realState_1, 
  f1_.phone AS phone_2, 
  f1_.firstname AS firstname_3 
FROM 
  internit_lead_lead i0_ 
  LEFT JOIN internit_lead_product i2_ ON i0_.product_id = i2_.id, 
  fos_user_user f1_ 
WHERE 
  i0_.broker_email IS NOT NULL 
  AND i0_.broker_realState IS NOT NULL 
  AND f1_.email = i0_.broker_email 
  AND (
    (
      i0_.email LIKE ? 
      OR i0_.phone LIKE ?
    )
  ) 
  AND i0_.broker_email IN (?) 
ORDER BY 
  i0_.created_at DESC 
LIMIT 
  1

SELECT i0_.broker_email AS broker_email_0, i0_.broker_realState AS broker_realState_1, f1_.phone AS phone_2, f1_.firstname AS firstname_3 FROM internit_lead_lead i0_ LEFT JOIN internit_lead_product i2_ ON i0_.product_id = i2_.id, fos_user_user f1_ WHERE i0_.broker_email IS NOT NULL AND i0_.broker_realState IS NOT NULL AND f1_.email = i0_.broker_email AND ((i0_.email LIKE '%[email protected]%' OR i0_.phone LIKE '%(21) 97452-6787%')) AND i0_.broker_email IN ('[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]') ORDER BY i0_.created_at DESC LIMIT 1;

SELECT 
  i0_.broker_email AS broker_email_0, 
  i0_.broker_realState AS broker_realState_1, 
  f1_.phone AS phone_2, 
  f1_.firstname AS firstname_3 
FROM 
  internit_lead_lead i0_ 
  LEFT JOIN internit_lead_product i2_ ON i0_.product_id = i2_.id, 
  fos_user_user f1_ 
WHERE 
  i0_.broker_email IS NOT NULL 
  AND i0_.broker_realState IS NOT NULL 
  AND f1_.email = i0_.broker_email 
  AND i0_.email LIKE ? 
  AND i0_.broker_email IN (?) 
ORDER BY 
  i0_.created_at DESC 
LIMIT 
  1

SELECT i0_.broker_email AS broker_email_0, i0_.broker_realState AS broker_realState_1, f1_.phone AS phone_2, f1_.firstname AS firstname_3 FROM internit_lead_lead i0_ LEFT JOIN internit_lead_product i2_ ON i0_.product_id = i2_.id, fos_user_user f1_ WHERE i0_.broker_email IS NOT NULL AND i0_.broker_realState IS NOT NULL AND f1_.email = i0_.broker_email AND i0_.email LIKE '%[email protected]%' AND i0_.broker_email IN ('[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]') ORDER BY i0_.created_at DESC LIMIT 1;

SELECT 
  t0.name AS name_1, 
  t0.email AS email_2, 
  t0.phone AS phone_3, 
  t0.fixedPhone AS fixedPhone_4, 
  t0.leadGroup AS leadGroup_5, 
  t0.origem AS origem_6, 
  t0.empreendimento AS empreendimento_7, 
  t0.broker_email AS broker_email_8, 
  t0.broker_realState AS broker_realState_9, 
  t0.utm_source AS utm_source_10, 
  t0.utm_medium AS utm_medium_11, 
  t0.utm_campaign AS utm_campaign_12, 
  t0.message AS message_13, 
  t0.send_status AS send_status_14, 
  t0.type AS type_15, 
  t0.loyalty AS loyalty_16, 
  t0.id AS id_17, 
  t0.created_at AS created_at_18, 
  t0.updated_at AS updated_at_19, 
  t0.product_id AS product_id_20 
FROM 
  internit_lead_lead t0 
WHERE 
  t0.product_id = ?

SELECT t0.name AS name_1, t0.email AS email_2, t0.phone AS phone_3, t0.fixedPhone AS fixedPhone_4, t0.leadGroup AS leadGroup_5, t0.origem AS origem_6, t0.empreendimento AS empreendimento_7, t0.broker_email AS broker_email_8, t0.broker_realState AS broker_realState_9, t0.utm_source AS utm_source_10, t0.utm_medium AS utm_medium_11, t0.utm_campaign AS utm_campaign_12, t0.message AS message_13, t0.send_status AS send_status_14, t0.type AS type_15, t0.loyalty AS loyalty_16, t0.id AS id_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.product_id AS product_id_20 FROM internit_lead_lead t0 WHERE t0.product_id = 10;

INSERT INTO lead_queue (
  lead_id, broker_name, broker_email, 
  copy_emails, status, created_at
) 
VALUES 
  (?, ?, ?, ?, ?, ?)

INSERT INTO lead_queue (lead_id, broker_name, broker_email, copy_emails, status, created_at) VALUES (15368, 'Marianna Castilho', '[email protected]', '[email protected],[email protected]', 'pendente', '2025-07-03 20:14:54');

SELECT 
  t0.username AS username_1, 
  t0.username_canonical AS username_canonical_2, 
  t0.email AS email_3, 
  t0.email_canonical AS email_canonical_4, 
  t0.enabled AS enabled_5, 
  t0.salt AS salt_6, 
  t0.password AS password_7, 
  t0.last_login AS last_login_8, 
  t0.confirmation_token AS confirmation_token_9, 
  t0.password_requested_at AS password_requested_at_10, 
  t0.roles AS roles_11, 
  t0.created_at AS created_at_12, 
  t0.updated_at AS updated_at_13, 
  t0.date_of_birth AS date_of_birth_14, 
  t0.firstname AS firstname_15, 
  t0.lastname AS lastname_16, 
  t0.website AS website_17, 
  t0.biography AS biography_18, 
  t0.gender AS gender_19, 
  t0.locale AS locale_20, 
  t0.timezone AS timezone_21, 
  t0.phone AS phone_22, 
  t0.facebook_uid AS facebook_uid_23, 
  t0.facebook_name AS facebook_name_24, 
  t0.facebook_data AS facebook_data_25, 
  t0.twitter_uid AS twitter_uid_26, 
  t0.twitter_name AS twitter_name_27, 
  t0.twitter_data AS twitter_data_28, 
  t0.gplus_uid AS gplus_uid_29, 
  t0.gplus_name AS gplus_name_30, 
  t0.gplus_data AS gplus_data_31, 
  t0.token AS token_32, 
  t0.two_step_code AS two_step_code_33, 
  t0.id AS id_34, 
  t0.nickname AS nickname_35, 
  t0.genre AS genre_36, 
  t0.cpf AS cpf_37, 
  t0.rg AS rg_38, 
  t0.number AS number_39, 
  t0.creci AS creci_40, 
  t0.operator_id AS operator_id_41, 
  t0.department_id AS department_id_42, 
  t0.media_id AS media_id_43, 
  t0.address_id AS address_id_44, 
  t0.image_id AS image_id_45 
FROM 
  fos_user_user t0 
WHERE 
  t0.id = ?

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.date_of_birth AS date_of_birth_14, t0.firstname AS firstname_15, t0.lastname AS lastname_16, t0.website AS website_17, t0.biography AS biography_18, t0.gender AS gender_19, t0.locale AS locale_20, t0.timezone AS timezone_21, t0.phone AS phone_22, t0.facebook_uid AS facebook_uid_23, t0.facebook_name AS facebook_name_24, t0.facebook_data AS facebook_data_25, t0.twitter_uid AS twitter_uid_26, t0.twitter_name AS twitter_name_27, t0.twitter_data AS twitter_data_28, t0.gplus_uid AS gplus_uid_29, t0.gplus_name AS gplus_name_30, t0.gplus_data AS gplus_data_31, t0.token AS token_32, t0.two_step_code AS two_step_code_33, t0.id AS id_34, t0.nickname AS nickname_35, t0.genre AS genre_36, t0.cpf AS cpf_37, t0.rg AS rg_38, t0.number AS number_39, t0.creci AS creci_40, t0.operator_id AS operator_id_41, t0.department_id AS department_id_42, t0.media_id AS media_id_43, t0.address_id AS address_id_44, t0.image_id AS image_id_45 FROM fos_user_user t0 WHERE t0.id = 160;

"COMMIT"

"COMMIT";

SELECT 
  t0.name AS name_1, 
  t0.corporateName AS corporateName_2, 
  t0.cnpj AS cnpj_3, 
  t0.creci AS creci_4, 
  t0.phone AS phone_5, 
  t0.email AS email_6, 
  t0.receive_lead AS receive_lead_7, 
  t0.id AS id_8, 
  t0.created_at AS created_at_9, 
  t0.updated_at AS updated_at_10, 
  t0.logo_id AS logo_id_11, 
  t0.address_id AS address_id_12 
FROM 
  internit_realestate_realestate t0 
WHERE 
  t0.id = ?

SELECT t0.name AS name_1, t0.corporateName AS corporateName_2, t0.cnpj AS cnpj_3, t0.creci AS creci_4, t0.phone AS phone_5, t0.email AS email_6, t0.receive_lead AS receive_lead_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.logo_id AS logo_id_11, t0.address_id AS address_id_12 FROM internit_realestate_realestate t0 WHERE t0.id = 13;

SELECT 
  t0.position AS position_1, 
  t0.id AS id_2, 
  t0.created_at AS created_at_3, 
  t0.updated_at AS updated_at_4, 
  t0.product_id AS product_id_5, 
  t0.user_id AS user_id_6, 
  t0.realEstate_id AS realEstate_id_7 
FROM 
  internit_lead_product_user t0 
WHERE 
  t0.product_id = ? 
ORDER BY 
  t0.position ASC

SELECT t0.position AS position_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.product_id AS product_id_5, t0.user_id AS user_id_6, t0.realEstate_id AS realEstate_id_7 FROM internit_lead_product_user t0 WHERE t0.product_id = 10 ORDER BY t0.position ASC;

SELECT 
  t0.name AS name_1, 
  t0.description AS description_2, 
  t0.token AS token_3, 
  t0.viva_real AS viva_real_4, 
  t0.zap AS zap_5, 
  t0.olx AS olx_6, 
  t0.turn AS turn_7, 
  t0.email AS email_8, 
  t0.fidelityDays AS fidelityDays_9, 
  t0.id AS id_10, 
  t0.created_at AS created_at_11, 
  t0.updated_at AS updated_at_12 
FROM 
  internit_lead_product t0 
WHERE 
  t0.token = ? 
LIMIT 
  1

SELECT t0.name AS name_1, t0.description AS description_2, t0.token AS token_3, t0.viva_real AS viva_real_4, t0.zap AS zap_5, t0.olx AS olx_6, t0.turn AS turn_7, t0.email AS email_8, t0.fidelityDays AS fidelityDays_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM internit_lead_product t0 WHERE t0.token = '143626b7e2e00a441ce8c5d1f4cd68ca' LIMIT 1;

SELECT 
  i0_.percent AS percent_0, 
  i0_.turn AS turn_1, 
  i0_.extraLeads AS extraLeads_2, 
  i0_.id AS id_3, 
  i0_.created_at AS created_at_4, 
  i0_.updated_at AS updated_at_5, 
  i0_.product_id AS product_id_6, 
  i0_.realEstate_id AS realEstate_id_7 
FROM 
  internit_lead_realstate_percent i0_ 
  INNER JOIN internit_realestate_realestate i1_ ON i0_.realEstate_id = i1_.id 
WHERE 
  i0_.product_id = (?) 
  AND i1_.name = ?

SELECT i0_.percent AS percent_0, i0_.turn AS turn_1, i0_.extraLeads AS extraLeads_2, i0_.id AS id_3, i0_.created_at AS created_at_4, i0_.updated_at AS updated_at_5, i0_.product_id AS product_id_6, i0_.realEstate_id AS realEstate_id_7 FROM internit_lead_realstate_percent i0_ INNER JOIN internit_realestate_realestate i1_ ON i0_.realEstate_id = i1_.id WHERE i0_.product_id = (10) AND i1_.name = 'LOPES CM';

SELECT 
  t0.percent AS percent_1, 
  t0.turn AS turn_2, 
  t0.extraLeads AS extraLeads_3, 
  t0.id AS id_4, 
  t0.created_at AS created_at_5, 
  t0.updated_at AS updated_at_6, 
  t0.product_id AS product_id_7, 
  t0.realEstate_id AS realEstate_id_8 
FROM 
  internit_lead_realstate_percent t0 
WHERE 
  t0.product_id = ? 
ORDER BY 
  t0.percent DESC

SELECT t0.percent AS percent_1, t0.turn AS turn_2, t0.extraLeads AS extraLeads_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7, t0.realEstate_id AS realEstate_id_8 FROM internit_lead_realstate_percent t0 WHERE t0.product_id = 10 ORDER BY t0.percent DESC;

SELECT 
  i0_.url AS url_0 
FROM 
  internit_lead_realEstate_email i1_ 
  INNER JOIN internit_lead_realEstateEmail_has_leadEmails i2_ ON i1_.id = i2_.realEstateEmail_id 
  INNER JOIN internit_content_email i0_ ON i0_.id = i2_.email_id 
  INNER JOIN internit_realestate_realestate i3_ ON i1_.realEstate_id = i3_.id 
WHERE 
  i3_.name = ?

SELECT i0_.url AS url_0 FROM internit_lead_realEstate_email i1_ INNER JOIN internit_lead_realEstateEmail_has_leadEmails i2_ ON i1_.id = i2_.realEstateEmail_id INNER JOIN internit_content_email i0_ ON i0_.id = i2_.email_id INNER JOIN internit_realestate_realestate i3_ ON i1_.realEstate_id = i3_.id WHERE i3_.name = 'LOPES CM';

SELECT 
  i0_.name AS name_0, 
  f1_.email AS email_1, 
  f1_.firstname AS firstname_2, 
  f1_.phone AS phone_3, 
  f1_.operator_id AS operator_id_4, 
  f1_.department_id AS department_id_5 
FROM 
  internit_lead_product_user i2_ 
  INNER JOIN internit_realestate_realestate i0_ ON i2_.realEstate_id = i0_.id 
  INNER JOIN fos_user_user f1_ ON i2_.user_id = f1_.id 
WHERE 
  i2_.product_id = (?) 
  AND i0_.name = ?

SELECT i0_.name AS name_0, f1_.email AS email_1, f1_.firstname AS firstname_2, f1_.phone AS phone_3, f1_.operator_id AS operator_id_4, f1_.department_id AS department_id_5 FROM internit_lead_product_user i2_ INNER JOIN internit_realestate_realestate i0_ ON i2_.realEstate_id = i0_.id INNER JOIN fos_user_user f1_ ON i2_.user_id = f1_.id WHERE i2_.product_id = (10) AND i0_.name = 'LOPES CM';

INSERT INTO internit_lead_product_log (createdAt, log, type, product_id) 
VALUES 
  (?, ?, ?, ?)

INSERT INTO internit_lead_product_log (createdAt, log, type, product_id) VALUES ('2025-07-03 20:14:54', '{
    \"Imobiliarias\": {
        \"ANDRADE NEGÓCIOS IMOBILIÁRIOS\": {
            \"corretores\": [
                \"[email protected] > recebido 21\"
            ],
            \"ultimo\": \"[email protected]\",
            \"proximo\": \"[email protected]\"
        },
        \"IMOVERSO\": {
            \"corretores\": [
                \"[email protected] > recebido 18\",
                \"[email protected] > recebido 13\",
                \"[email protected] > recebido 21\",
                \"[email protected] > recebido 7\",
                \"[email protected] > recebido 4\",
                \"[email protected] > recebido 10\",
                \"[email protected] > recebido 6\"
            ],
            \"ultimo\": \"[email protected]\",
            \"proximo\": \"[email protected]\"
        },
        \"LOPES CM\": {
            \"corretores\": [
                \"[email protected] > recebido 13\",
                \"[email protected] > recebido 61\",
                \"[email protected] > recebido 4\",
                \"[email protected] > recebido 71\"
            ],
            \"ultimo\": \"[email protected]\",
            \"proximo\": \"[email protected]\"
        },
        \"LOPES PENÍNSULA\": {
            \"corretores\": [
                \"[email protected] > recebido 96\",
                \"[email protected] > recebido 6\",
                \"[email protected] > recebido 96\"
            ],
            \"ultimo\": \"[email protected]\",
            \"proximo\": \"[email protected]\"
        },
        \"PATRIMÓVEL\": {
            \"corretores\": [
                \"[email protected] > recebido 80\",
                \"[email protected] > recebido 66\"
            ],
            \"ultimo\": \"[email protected]\",
            \"proximo\": \"[email protected]\"
        },
        \"TECH BROKERS\": {
            \"corretores\": [
                \"[email protected] > recebido 29\",
                \"[email protected] > recebido 16\",
                \"[email protected] > recebido 6\",
                \"[email protected] > recebido 4\",
                \"[email protected] > recebido 4\",
                \"[email protected] > recebido 16\",
                \"[email protected] > recebido 3\"
            ],
            \"ultimo\": \"[email protected]\",
            \"proximo\": \"[email protected]\"
        },
        \"VG\": {
            \"corretores\": [
                \"[email protected] > recebido 105\",
                \"[email protected] > recebido 2\",
                \"[email protected] > recebido 2\",
                \"[email protected] > recebido 1\",
                \"[email protected] > recebido 1\"
            ],
            \"ultimo\": \"[email protected]\",
            \"proximo\": \"[email protected]\"
        },
        \"IMPERIUS\": {
            \"corretores\": [
                \"[email protected] > recebido 32\",
                \"[email protected] > recebido 1\"
            ],
            \"ultimo\": \"[email protected]\",
            \"proximo\": \"[email protected]\"
        },
        \"Imobiliaria_Nao_Definida\": {
            \"corretores\": [
                \"[email protected] > recebido 2\"
            ],
            \"ultimo\": \"Nenhum\",
            \"proximo\": \"[email protected]\"
        }
    }
}', 'DISTRIBUICAO', 10);

INSERT INTO internit_lead_lead (
  name, email, phone, fixedPhone, leadGroup, 
  origem, empreendimento, broker_email, 
  broker_realState, utm_source, utm_medium, 
  utm_campaign, message, send_status, 
  type, loyalty, created_at, updated_at, 
  product_id
) 
VALUES 
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
    ?, ?, ?
  )

INSERT INTO internit_lead_lead (name, email, phone, fixedPhone, leadGroup, origem, empreendimento, broker_email, broker_realState, utm_source, utm_medium, utm_campaign, message, send_status, type, loyalty, created_at, updated_at, product_id) VALUES ('Vitor Dantas', '[email protected]', '(21) 97452-6787', NULL, 'empreendimeEtehe Residencial', 'Acesso direto – site Calper - ', NULL, '[email protected]', 'LOPES CM', NULL, NULL, NULL, NULL, 'Enviando', NULL, NULL, '2025-07-03 17:14:54', '2025-07-03 17:14:54', 10);

SELECT 
  i0_.fidelityDays AS fidelityDays_0, 
  i0_.fidelityPriority AS fidelityPriority_1 
FROM 
  internit_setting_setting i0_

SELECT i0_.fidelityDays AS fidelityDays_0, i0_.fidelityPriority AS fidelityPriority_1 FROM internit_setting_setting i0_;

SELECT 
  count(i0_.id) AS sclr_0 
FROM 
  internit_setting_setting i0_

SELECT count(i0_.id) AS sclr_0 FROM internit_setting_setting i0_;

SELECT 
  t0.name AS name_1, 
  t0.corporateName AS corporateName_2, 
  t0.cnpj AS cnpj_3, 
  t0.creci AS creci_4, 
  t0.phone AS phone_5, 
  t0.email AS email_6, 
  t0.receive_lead AS receive_lead_7, 
  t0.id AS id_8, 
  t0.created_at AS created_at_9, 
  t0.updated_at AS updated_at_10, 
  t0.logo_id AS logo_id_11, 
  t0.address_id AS address_id_12 
FROM 
  internit_realestate_realestate t0 
WHERE 
  t0.name = ? 
LIMIT 
  1

SELECT t0.name AS name_1, t0.corporateName AS corporateName_2, t0.cnpj AS cnpj_3, t0.creci AS creci_4, t0.phone AS phone_5, t0.email AS email_6, t0.receive_lead AS receive_lead_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.logo_id AS logo_id_11, t0.address_id AS address_id_12 FROM internit_realestate_realestate t0 WHERE t0.name = 'LOPES CM' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

SELECT 
  i0_.title AS title_0, 
  i0_.autEmail AS autEmail_1, 
  i0_.autPassword AS autPassword_2, 
  i0_.autHost AS autHost_3, 
  i0_.autPort AS autPort_4, 
  i0_.description AS description_5, 
  i0_.keyWord AS keyWord_6, 
  i0_.autSecurity AS autSecurity_7, 
  i0_.autAuthenticatedEmail AS autAuthenticatedEmail_8, 
  i0_.autEmailStatus AS autEmailStatus_9 
FROM 
  internit_setting_setting i0_

SELECT i0_.title AS title_0, i0_.autEmail AS autEmail_1, i0_.autPassword AS autPassword_2, i0_.autHost AS autHost_3, i0_.autPort AS autPort_4, i0_.description AS description_5, i0_.keyWord AS keyWord_6, i0_.autSecurity AS autSecurity_7, i0_.autAuthenticatedEmail AS autAuthenticatedEmail_8, i0_.autEmailStatus AS autEmailStatus_9 FROM internit_setting_setting i0_;