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_.email LIKE ? 
  AND i0_.broker_email IS NOT NULL 
  AND i0_.broker_realState IS NOT NULL 
  AND i0_.broker_email IN (?) 
  AND f1_.email = i0_.broker_email 
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_.email LIKE '%[email protected]%' AND i0_.broker_email IS NOT NULL AND i0_.broker_realState IS NOT NULL 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]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]') AND f1_.email = i0_.broker_email ORDER BY i0_.created_at DESC LIMIT 1;

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 = 61;

"COMMIT"

"COMMIT";

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.id AS id_9, 
  t0.created_at AS created_at_10, 
  t0.updated_at AS updated_at_11 
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.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM internit_lead_product t0 WHERE t0.token = 'c9dee34c0a7d21a320766d1aee617f46' LIMIT 1;

SELECT 
  t0.name AS name_1, 
  t0.description AS description_2, 
  t0.enabled AS enabled_3, 
  t0.provider_name AS provider_name_4, 
  t0.provider_status AS provider_status_5, 
  t0.provider_reference AS provider_reference_6, 
  t0.provider_metadata AS provider_metadata_7, 
  t0.width AS width_8, 
  t0.height AS height_9, 
  t0.length AS length_10, 
  t0.content_type AS content_type_11, 
  t0.content_size AS content_size_12, 
  t0.copyright AS copyright_13, 
  t0.author_name AS author_name_14, 
  t0.context AS context_15, 
  t0.cdn_is_flushable AS cdn_is_flushable_16, 
  t0.cdn_flush_identifier AS cdn_flush_identifier_17, 
  t0.cdn_flush_at AS cdn_flush_at_18, 
  t0.cdn_status AS cdn_status_19, 
  t0.updated_at AS updated_at_20, 
  t0.created_at AS created_at_21, 
  t0.id AS id_22 
FROM 
  media__media t0 
WHERE 
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = 15;

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 = 8 ORDER BY t0.position ASC;

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 = 'PATRIMÓVEL';

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 = 'PATRIMÓVEL' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2, 
  t0.description AS description_3, 
  t0.keyWord AS keyWord_4, 
  t0.autHost AS autHost_5, 
  t0.autEmail AS autEmail_6, 
  t0.autPort AS autPort_7, 
  t0.autSecurity AS autSecurity_8, 
  t0.autPassword AS autPassword_9, 
  t0.autAuthenticatedEmail AS autAuthenticatedEmail_10, 
  t0.autEmailStatus AS autEmailStatus_11, 
  t0.headerBackgroundColor AS headerBackgroundColor_12, 
  t0.headerFontColor AS headerFontColor_13, 
  t0.footerBackgroundColor AS footerBackgroundColor_14, 
  t0.footerFontColor AS footerFontColor_15, 
  t0.siteUrl AS siteUrl_16, 
  t0.media_id AS media_id_17, 
  t0.logo_id AS logo_id_18, 
  t0.logo_footer_id AS logo_footer_id_19 
FROM 
  internit_setting_setting t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keyWord AS keyWord_4, t0.autHost AS autHost_5, t0.autEmail AS autEmail_6, t0.autPort AS autPort_7, t0.autSecurity AS autSecurity_8, t0.autPassword AS autPassword_9, t0.autAuthenticatedEmail AS autAuthenticatedEmail_10, t0.autEmailStatus AS autEmailStatus_11, t0.headerBackgroundColor AS headerBackgroundColor_12, t0.headerFontColor AS headerFontColor_13, t0.footerBackgroundColor AS footerBackgroundColor_14, t0.footerFontColor AS footerFontColor_15, t0.siteUrl AS siteUrl_16, t0.media_id AS media_id_17, t0.logo_id AS logo_id_18, t0.logo_footer_id AS logo_footer_id_19 FROM internit_setting_setting t0 WHERE t0.id = 1;

SELECT 
  t0.name AS name_1, 
  t0.phone AS phone_2, 
  t0.whatsapp AS whatsapp_3, 
  t0.siteUrl AS siteUrl_4, 
  t0.mapLink AS mapLink_5, 
  t0.openingHours AS openingHours_6, 
  t0.id AS id_7, 
  t0.created_at AS created_at_8, 
  t0.updated_at AS updated_at_9, 
  t0.logo_id AS logo_id_10, 
  t0.address_id AS address_id_11 
FROM 
  internit_builder_builder t0 
WHERE 
  t0.id = ?

SELECT t0.name AS name_1, t0.phone AS phone_2, t0.whatsapp AS whatsapp_3, t0.siteUrl AS siteUrl_4, t0.mapLink AS mapLink_5, t0.openingHours AS openingHours_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.logo_id AS logo_id_10, t0.address_id AS address_id_11 FROM internit_builder_builder t0 WHERE t0.id = 1;

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.url AS url_1, 
  t0.id AS id_2, 
  t0.created_at AS created_at_3, 
  t0.updated_at AS updated_at_4 
FROM 
  internit_builder_email t0 
  INNER JOIN internit_builder_builder_has_contactEmails ON t0.id = internit_builder_builder_has_contactEmails.email_id 
WHERE 
  internit_builder_builder_has_contactEmails.builder_id = ?

SELECT t0.url AS url_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM internit_builder_email t0 INNER JOIN internit_builder_builder_has_contactEmails ON t0.id = internit_builder_builder_has_contactEmails.email_id WHERE internit_builder_builder_has_contactEmails.builder_id = 1;

INSERT INTO internit_lead_lead (
  name, email, phone, fixedPhone, leadGroup, 
  origem, empreendimento, broker_email, 
  broker_realState, utm_source, utm_medium, 
  utm_campaign, message, 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, created_at, updated_at, product_id) VALUES ('carol teste', '[email protected]', '(11) 11111-1111', NULL, 'Acesso Direto', 'Acesso Direto', NULL, '[email protected]', 'PATRIMÓVEL', NULL, NULL, NULL, NULL, '2024-11-26 10:28:38', '2024-11-26 10:28:38', 8);

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_;

"START TRANSACTION"

"START TRANSACTION";