Symfony Profiler

INSERT INTO leads_customfield_values (
  lead_id, custom_field_id, value_type,
  value_text, value_number, value_bool,
  value_date, value_datetime, value_json,
  created_at, updated_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY
UPDATE
  value_type =
VALUES
  (value_type),
  value_text =
VALUES
  (value_text),
  value_number =
VALUES
  (value_number),
  value_bool =
VALUES
  (value_bool),
  value_date =
VALUES
  (value_date),
  value_datetime =
VALUES
  (value_datetime),
  value_json =
VALUES
  (value_json),
  updated_at =
VALUES
  (updated_at)

INSERT INTO leads_customfield_values (
                    lead_id,
                    custom_field_id,
                    value_type,
                    value_text,
                    value_number,
                    value_bool,
                    value_date,
                    value_datetime,
                    value_json,
                    created_at,
                    updated_at
                ) VALUES (
                    44272,
                    34,
                    'string',
                    '931351381',
                    NULL,
                    NULL,
                    NULL,
                    NULL,
                    NULL,
                    '2026-02-27 09:06:45',
                    '2026-02-27 09:06:45'
                )
                ON DUPLICATE KEY UPDATE
                    value_type = VALUES(value_type),
                    value_text = VALUES(value_text),
                    value_number = VALUES(value_number),
                    value_bool = VALUES(value_bool),
                    value_date = VALUES(value_date),
                    value_datetime = VALUES(value_datetime),
                    value_json = VALUES(value_json),
                    updated_at = VALUES(updated_at);

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'sconsult_db_sy_sos'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

UPDATE
  leads
SET
  estado_id = ?,
  subestado_id = ?,
  custom_fields = ?,
  updated = ?,
  updated_by = ?,
  logs = ?
WHERE
  id = ?

UPDATE leads SET estado_id = 3, subestado_id = 11, custom_fields = '{\"telemovel\":\"931351381\",\"canal\":\"inbound\",\"ext_id\":\"ab9a2e54c94e9f82a7be1dbe55da9fea\",\"web_leads_last_estado_id\":3,\"web_leads_last_subestado_id\":11,\"web_leads_last_sent_at\":\"2026-02-27T09:06:45+00:00\",\"responsavel_user_id\":\"40\"}', updated = '2026-02-27 09:06:45', updated_by = 40, logs = '{\"web_leads_responses\":[{\"at\":\"2026-02-26T18:10:56+00:00\",\"ext_id\":\"ab9a2e54c94e9f82a7be1dbe55da9fea\",\"user_id\":1,\"estado_id\":3,\"subestado_id\":11,\"external_push\":{\"url\":\"https://ws.walmeric.com/provision/wsApiHelper/executeApiHelper.html?apiType=M&tagId=29842f94d414949bf95fb2e6109142cfef1fb2a78114c2c536a36bf5a65b953a93e99c8370bea01bdf71d694d56ec4d64bba05f118f7c84996a57b4073cfbe20c2aed7106a030ac8be06095492c118b0dae57e5fbac64991e347ad4a62aee4214d4e13ec13faf0da749b2e35d346bd35&searchType=leadId&searchValue=ab9a2e54c94e9f82a7be1dbe55da9fea&ext:1006=15&ext:1007=69\",\"response\":\"{\\\"cod\\\":\\\"200\\\",\\\"message\\\":\\\"Actualizaci\\\\u00f3n correcta\\\"}\",\"http_code\":200}},{\"at\":\"2026-02-27T09:06:45+00:00\",\"ext_id\":\"ab9a2e54c94e9f82a7be1dbe55da9fea\",\"estado_id\":3,\"subestado_id\":11,\"user_id\":40,\"external_push\":{\"url\":\"https://ws.walmeric.com/provision/wsApiHelper/executeApiHelper.html?apiType=M&tagId=29842f94d414949bf95fb2e6109142cfef1fb2a78114c2c536a36bf5a65b953a93e99c8370bea01bdf71d694d56ec4d64bba05f118f7c84996a57b4073cfbe20c2aed7106a030ac8be06095492c118b0dae57e5fbac64991e347ad4a62aee4214d4e13ec13faf0da749b2e35d346bd35&searchType=leadId&searchValue=ab9a2e54c94e9f82a7be1dbe55da9fea&ext:1006=15&ext:1007=69\",\"http_code\":200,\"response\":\"{\\\"cod\\\":\\\"200\\\",\\\"message\\\":\\\"Actualizaci\\\\u00f3n correcta\\\"}\"}}]}' WHERE id = 44272;

SELECT
  id,
  data_type
FROM
  leads_customfields
WHERE
  category = ?
  AND field_key = ?
LIMIT
  1

SELECT id, data_type FROM leads_customfields WHERE category = 'energy' AND field_key = 'telemovel' LIMIT 1;

INSERT INTO lead_events (
  lead_id, event_type, payload, created_by_id,
  created_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO lead_events (lead_id, event_type, payload, created_by_id, created_at) VALUES (44272, 'lead_updated', '{\"source\":\"web_leads_response\",\"changes\":{\"estado_id\":3,\"subestado_id\":11,\"ext_id\":\"ab9a2e54c94e9f82a7be1dbe55da9fea\"},\"lead_after\":{\"id\":44272,\"name\":\"Lead 931351381\",\"nif\":null,\"email\":null,\"category\":\"energy\",\"canal\":\"inbound\",\"campanha\":\"Web Leads\",\"working_campaign_id\":2,\"id_origem_dados\":null,\"id_tipo_inquerito\":1,\"id_rgpd\":null,\"origem\":null,\"data_limite\":null,\"created\":\"2026-02-26 18:10:04\",\"updated\":\"2026-02-27 09:06:45\",\"created_by\":null,\"updated_by\":40,\"estado_id\":3,\"subestado_id\":11,\"custom_fields\":{\"telemovel\":\"931351381\",\"canal\":\"inbound\",\"ext_id\":\"ab9a2e54c94e9f82a7be1dbe55da9fea\",\"web_leads_last_estado_id\":3,\"web_leads_last_subestado_id\":11,\"web_leads_last_sent_at\":\"2026-02-27T09:06:45+00:00\",\"responsavel_user_id\":\"40\"},\"estado_chamada\":null,\"agendamento\":null,\"classification_id\":null,\"is_closed\":0,\"deleted_at\":null,\"deleted_by\":null}}', 40, '2026-02-27 09:06:45');

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.db_host AS db_host_3,
  t0.db_port AS db_port_4,
  t0.db_name AS db_name_5,
  t0.db_user AS db_user_6,
  t0.db_password AS db_password_7,
  t0.db_charset AS db_charset_8,
  t0.company_id AS company_id_9,
  t0.json_data AS json_data_10
FROM
  tenant t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.db_host AS db_host_3, t0.db_port AS db_port_4, t0.db_name AS db_name_5, t0.db_user AS db_user_6, t0.db_password AS db_password_7, t0.db_charset AS db_charset_8, t0.company_id AS company_id_9, t0.json_data AS json_data_10 FROM tenant t0 WHERE t0.code = 'sos' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.allowed AS allowed_5,
  t0.active AS active_6,
  t0.email AS email_7,
  t0.token AS token_8,
  t0.companies AS companies_9,
  t0.tenant_code AS tenant_code_10,
  t11.leadfieldsshow AS leadfieldsshow_12,
  t11.homepage_widgets AS homepage_widgets_13,
  t11.user_id AS user_id_14
FROM
  user t0
  LEFT JOIN user_apps_settings t11 ON t11.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.allowed AS allowed_5, t0.active AS active_6, t0.email AS email_7, t0.token AS token_8, t0.companies AS companies_9, t0.tenant_code AS tenant_code_10, t11.leadfieldsshow AS leadfieldsshow_12, t11.homepage_widgets AS homepage_widgets_13, t11.user_id AS user_id_14 FROM user t0 LEFT JOIN user_apps_settings t11 ON t11.user_id = t0.id WHERE t0.id = 40;

DELETE FROM
  leads_customfield_values
WHERE
  lead_id = ?
  AND custom_field_id NOT IN (?, ?, ?, ?, ?, ?, ?)

DELETE FROM leads_customfield_values WHERE lead_id = 44272 AND custom_field_id NOT IN (34, 84, 70, 77, 78, 79, 75);

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  id,
  custom_fields,
  logs
FROM
  leads
WHERE
  id = ?

SELECT id, custom_fields, logs FROM leads WHERE id = 44272;

SELECT
  t0.id AS id_1,
  t0.group_id AS group_id_2,
  t0.user_id AS user_id_3
FROM
  tenant_group_member t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.group_id AS group_id_2, t0.user_id AS user_id_3 FROM tenant_group_member t0 WHERE t0.user_id = 40;

SELECT
  external_id
FROM
  estados
WHERE
  id = ?

SELECT external_id FROM estados WHERE id = 3;

SELECT
  *
FROM
  leads
WHERE
  id = ?

SELECT * FROM leads WHERE id = 44272;

SELECT
  id,
  category,
  custom_fields
FROM
  leads
WHERE
  id = ?
LIMIT
  1

SELECT id, category, custom_fields FROM leads WHERE id = 44272 LIMIT 1;

SELECT
  external_id
FROM
  subestados
WHERE
  id = ?

SELECT external_id FROM subestados WHERE id = 11;