http://calper.descomplicavendas.com.br/api/leads/send

Method
POST
HTTP Status
200
IP
18.206.194.199
Profiled on
Token
3e9ed6

Query Metrics

43 Database Queries
20 Different statements
56.20 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.82 ms 
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
Parameters: 
[
  "143626b7e2e00a441ce8c5d1f4cd68ca"
]
View formatted query    View runnable query    Explain query
2 0.31 ms 
SELECT i0_.fidelityDays AS fidelityDays_0, i0_.fidelityPriority AS fidelityPriority_1 FROM internit_setting_setting i0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
3 0.49 ms 
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
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
4 0.64 ms 
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 = ?
Parameters: 
[
  160
]
View formatted query    View runnable query    Explain query
5 0.46 ms 
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 = ?
Parameters: 
[
  87
]
View formatted query    View runnable query    Explain query
6 0.32 ms 
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 = ?
Parameters: 
[
  104
]
View formatted query    View runnable query    Explain query
7 0.26 ms 
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 = ?
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query
8 0.26 ms 
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 = ?
Parameters: 
[
  66
]
View formatted query    View runnable query    Explain query
9 0.26 ms 
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 = ?
Parameters: 
[
  67
]
View formatted query    View runnable query    Explain query
10 0.24 ms 
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 = ?
Parameters: 
[
  68
]
View formatted query    View runnable query    Explain query
11 0.25 ms 
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 = ?
Parameters: 
[
  72
]
View formatted query    View runnable query    Explain query
12 0.25 ms 
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 = ?
Parameters: 
[
  106
]
View formatted query    View runnable query    Explain query
13 0.22 ms 
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 = ?
Parameters: 
[
  127
]
View formatted query    View runnable query    Explain query
14 0.27 ms 
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 = ?
Parameters: 
[
  128
]
View formatted query    View runnable query    Explain query
15 0.25 ms 
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 = ?
Parameters: 
[
  154
]
View formatted query    View runnable query    Explain query
16 0.25 ms 
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 = ?
Parameters: 
[
  70
]
View formatted query    View runnable query    Explain query
17 12.69 ms 
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
View formatted query    View runnable query    Explain query
18 0.42 ms 
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
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
19 0.25 ms 
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 = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
20 0.38 ms 
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 = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
21 0.19 ms 
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 = ?
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query
22 0.16 ms 
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 = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
23 0.15 ms 
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 = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
24 0.15 ms 
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 = ?
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query
25 0.17 ms 
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 = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query
26 2.95 ms 
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 = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
27 3.31 ms 
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 = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
28 0.53 ms 
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 = ?
Parameters: 
[
  10
  "LOPES CM"
]
View formatted query    View runnable query    Explain query
29 0.38 ms 
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 = ?
Parameters: 
[
  10
  "LOPES CM"
]
View formatted query    View runnable query    Explain query
30 15.97 ms 
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
View formatted query    View runnable query    Explain query
31 0.42 ms 
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 = ?
Parameters: 
[
  "LOPES CM"
]
View formatted query    View runnable query    Explain query
32 0.30 ms 
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
Parameters: 
[
  "LOPES CM"
]
View formatted query    View runnable query    Explain query
33 0.31 ms 
SELECT count(i0_.id) AS sclr_0 FROM internit_setting_setting i0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
34 0.24 ms 
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_
Parameters: 
[]
View formatted query    View runnable query    Explain query
35 0.14 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
36 0.33 ms 
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  1 => "Vitor Dantas"
  2 => "[email protected]"
  3 => "(21) 97452-6787"
  4 => null
  5 => "empreendimeEtehe Residencial"
  6 => "Acesso direto – site Calper - "
  7 => null
  8 => "[email protected]"
  9 => "LOPES CM"
  10 => null
  11 => null
  12 => null
  13 => null
  14 => "Enviando"
  15 => null
  16 => null
  17 => "2025-07-03 17:14:54"
  18 => "2025-07-03 17:14:54"
  19 => 10
]
View formatted query    View runnable query    Explain query
37 0.79 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
38 3.47 ms 
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 = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
39 0.47 ms 
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
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
40 0.12 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
41 0.34 ms 
INSERT INTO internit_lead_product_log (createdAt, log, type, product_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  1 => "2025-07-03 20:14:54"
  2 => """
    {\n
        "Imobiliarias": {\n
            "ANDRADE NEGÓCIOS IMOBILIÁRIOS": {\n
                "corretores": [\n
                    "[email protected] > recebido 21"\n
                ],\n
                "ultimo": "[email protected]",\n
                "proximo": "[email protected]"\n
            },\n
            "IMOVERSO": {\n
                "corretores": [\n
                    "[email protected] > recebido 18",\n
                    "[email protected] > recebido 13",\n
                    "[email protected] > recebido 21",\n
                    "[email protected] > recebido 7",\n
                    "[email protected] > recebido 4",\n
                    "[email protected] > recebido 10",\n
                    "[email protected] > recebido 6"\n
                ],\n
                "ultimo": "[email protected]",\n
                "proximo": "[email protected]"\n
            },\n
            "LOPES CM": {\n
                "corretores": [\n
                    "[email protected] > recebido 13",\n
                    "[email protected] > recebido 61",\n
                    "[email protected] > recebido 4",\n
                    "[email protected] > recebido 71"\n
                ],\n
                "ultimo": "[email protected]",\n
                "proximo": "[email protected]"\n
            },\n
            "LOPES PENÍNSULA": {\n
                "corretores": [\n
                    "[email protected] > recebido 96",\n
                    "[email protected] > recebido 6",\n
                    "[email protected] > recebido 96"\n
                ],\n
                "ultimo": "[email protected]",\n
                "proximo": "[email protected]"\n
            },\n
            "PATRIMÓVEL": {\n
                "corretores": [\n
                    "[email protected] > recebido 80",\n
                    "[email protected] > recebido 66"\n
                ],\n
                "ultimo": "[email protected]",\n
                "proximo": "[email protected]"\n
            },\n
            "TECH BROKERS": {\n
                "corretores": [\n
                    "[email protected] > recebido 29",\n
                    "[email protected] > recebido 16",\n
                    "[email protected] > recebido 6",\n
                    "[email protected] > recebido 4",\n
                    "[email protected] > recebido 4",\n
                    "[email protected] > recebido 16",\n
                    "[email protected] > recebido 3"\n
                ],\n
                "ultimo": "[email protected]",\n
                "proximo": "[email protected]"\n
            },\n
            "VG": {\n
                "corretores": [\n
                    "[email protected] > recebido 105",\n
                    "[email protected] > recebido 2",\n
                    "[email protected] > recebido 2",\n
                    "[email protected] > recebido 1",\n
                    "[email protected] > recebido 1"\n
                ],\n
                "ultimo": "[email protected]",\n
                "proximo": "[email protected]"\n
            },\n
            "IMPERIUS": {\n
                "corretores": [\n
                    "[email protected] > recebido 32",\n
                    "[email protected] > recebido 1"\n
                ],\n
                "ultimo": "[email protected]",\n
                "proximo": "[email protected]"\n
            },\n
            "Imobiliaria_Nao_Definida": {\n
                "corretores": [\n
                    "[email protected] > recebido 2"\n
                ],\n
                "ultimo": "Nenhum",\n
                "proximo": "[email protected]"\n
            }\n
        }\n
    }
    """
  3 => "DISTRIBUICAO"
  4 => 10
]
View formatted query    View runnable query    Explain query
42 1.17 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
43 4.87 ms 
INSERT INTO lead_queue (lead_id, broker_name, broker_email, copy_emails, status, created_at) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  15368
  "Marianna Castilho"
  "[email protected]"
  "[email protected],[email protected]"
  "pendente"
  "2025-07-03 20:14:54"
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Application\Internit\ContentBundle\Entity\Entity No errors.
App\Application\Internit\LeadBundle\Entity\Product No errors.
App\Application\Internit\LeadBundle\Entity\ProductUser No errors.
App\Application\Internit\LeadBundle\Entity\Lead No errors.
App\Application\Internit\LeadBundle\Entity\realStatePercent No errors.
App\Application\Internit\SettingBundle\Entity\Setting No errors.
FOS\UserBundle\Model\User No errors.
Sonata\UserBundle\Entity\BaseUser No errors.
App\Application\Sonata\UserBundle\Entity\User No errors.
App\Application\Internit\RealEstateBundle\Entity\RealEstate No errors.
Sonata\MediaBundle\Entity\BaseMedia No errors.
App\Application\Sonata\MediaBundle\Entity\Media No errors.
App\Application\Internit\ContentBundle\Entity\Address No errors.
App\Application\Internit\QuizBundle\Entity\UserAnswer No errors.
App\Application\Internit\QuizBundle\Entity\RewardRequest No errors.
FOS\UserBundle\Model\Group No errors.
Sonata\UserBundle\Entity\BaseGroup No errors.
App\Application\Sonata\UserBundle\Entity\Group No errors.
App\Application\Internit\CommunicationBundle\Entity\Communication No errors.
App\Application\Internit\RealEstateBundle\Entity\Realty No errors.
App\Application\Internit\LeadBundle\Entity\RealEstateEmail No errors.
App\Application\Internit\ContentBundle\Entity\Email No errors.
App\Application\Internit\LeadBundle\Entity\ProductLog
  • The association App\Application\Internit\LeadBundle\Entity\ProductLog#product refers to the inverse side field App\Application\Internit\LeadBundle\Entity\Product#logs which does not exist.