Symfony Profiler

SELECT
  data
FROM
  acc_setting
WHERE
  name = 'api_auth_enforced'
ORDER BY
  id DESC
LIMIT
  1

SELECT data FROM acc_setting WHERE name = 'api_auth_enforced' ORDER BY id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.sync_flag AS sync_flag_2,
  t0.name AS name_3,
  t0.image AS image_4,
  t0.app_id AS app_id_5,
  t0.owner_id AS owner_id_6,
  t0.stripe_customer_id AS stripe_customer_id_7,
  t0.manage_user_ids AS manage_user_ids_8,
  t0.post_dated_job_active AS post_dated_job_active_9,
  t0.address AS address_10,
  t0.shipping_address AS shipping_address_11,
  t0.billing_address AS billing_address_12,
  t0.motto AS motto_13,
  t0.invoice_footer AS invoice_footer_14,
  t0.general_footer AS general_footer_15,
  t0.company_allowed AS company_allowed_16,
  t0.company_allocated AS company_allocated_17,
  t0.country_id AS country_id_18,
  t0.locale AS locale_19,
  t0.company_remaining AS company_remaining_20,
  t0.user_allowed AS user_allowed_21,
  t0.user_allocated AS user_allocated_22,
  t0.user_remaining AS user_remaining_23,
  t0.admin_user_allowed AS admin_user_allowed_24,
  t0.admin_user_allocated AS admin_user_allocated_25,
  t0.admin_user_remaining AS admin_user_remaining_26,
  t0.contact_number AS contact_number_27,
  t0.email AS email_28,
  t0.db_name AS db_name_29,
  t0.db_pass AS db_pass_30,
  t0.db_user AS db_user_31,
  t0.db_host AS db_host_32,
  t0.company_group_hash AS company_group_hash_33,
  t0.company_group_unique_code AS company_group_unique_code_34,
  t0.enabled_module_id_list AS enabled_module_id_list_35,
  t0.company_group_server_id AS company_group_server_id_36,
  t0.company_group_server_hash AS company_group_server_hash_37,
  t0.company_group_server_address AS company_group_server_address_38,
  t0.company_group_server_port AS company_group_server_port_39,
  t0.company_bin AS company_bin_40,
  t0.company_tin AS company_tin_41,
  t0.company_reg AS company_reg_42,
  t0.company_tl AS company_tl_43,
  t0.initiate_flag AS initiate_flag_44,
  t0.current_server_id AS current_server_id_45,
  t0.current_server_hash AS current_server_hash_46,
  t0.current_server_address AS current_server_address_47,
  t0.current_server_port AS current_server_port_48,
  t0.usage_valid_upto_date AS usage_valid_upto_date_49,
  t0.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_50,
  t0.company_group_server_domain_full_link AS company_group_server_domain_full_link_51,
  t0.current_server_domain_full_link AS current_server_domain_full_link_52,
  t0.company_group_billing_info AS company_group_billing_info_53,
  t0.company_group_next_bill_date AS company_group_next_bill_date_54,
  t0.company_group_next_bill_date_ts AS company_group_next_bill_date_ts_55,
  t0.company_group_billing_frequency AS company_group_billing_frequency_56,
  t0.cash AS cash_57,
  t0.sales AS sales_58,
  t0.expense AS expense_59,
  t0.payable AS payable_60,
  t0.net_worth AS net_worth_61,
  t0.monthly_growth AS monthly_growth_62,
  t0.active AS active_63,
  t0.read_only_mode AS read_only_mode_64,
  t0.company_status AS company_status_65,
  t0.package_type AS package_type_66,
  t0.subscription_expiry AS subscription_expiry_67,
  t0.last_activity_at AS last_activity_at_68,
  t0.current_subscription_package_id AS current_subscription_package_id_69,
  t0.subscription_month AS subscription_month_70,
  t0.billing_amount AS billing_amount_71,
  t0.subscription_details AS subscription_details_72,
  t0.company_type AS company_type_73,
  t0.company_description AS company_description_74,
  t0.skip_in_web_flag AS skip_in_web_flag_75,
  t0.skip_in_app_flag AS skip_in_app_flag_76,
  t0.schema_update_pending_flag AS schema_update_pending_flag_77,
  t0.created_at AS created_at_78,
  t0.updated_at AS updated_at_79
FROM
  company_group t0
WHERE
  t0.app_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.sync_flag AS sync_flag_2, t0.name AS name_3, t0.image AS image_4, t0.app_id AS app_id_5, t0.owner_id AS owner_id_6, t0.stripe_customer_id AS stripe_customer_id_7, t0.manage_user_ids AS manage_user_ids_8, t0.post_dated_job_active AS post_dated_job_active_9, t0.address AS address_10, t0.shipping_address AS shipping_address_11, t0.billing_address AS billing_address_12, t0.motto AS motto_13, t0.invoice_footer AS invoice_footer_14, t0.general_footer AS general_footer_15, t0.company_allowed AS company_allowed_16, t0.company_allocated AS company_allocated_17, t0.country_id AS country_id_18, t0.locale AS locale_19, t0.company_remaining AS company_remaining_20, t0.user_allowed AS user_allowed_21, t0.user_allocated AS user_allocated_22, t0.user_remaining AS user_remaining_23, t0.admin_user_allowed AS admin_user_allowed_24, t0.admin_user_allocated AS admin_user_allocated_25, t0.admin_user_remaining AS admin_user_remaining_26, t0.contact_number AS contact_number_27, t0.email AS email_28, t0.db_name AS db_name_29, t0.db_pass AS db_pass_30, t0.db_user AS db_user_31, t0.db_host AS db_host_32, t0.company_group_hash AS company_group_hash_33, t0.company_group_unique_code AS company_group_unique_code_34, t0.enabled_module_id_list AS enabled_module_id_list_35, t0.company_group_server_id AS company_group_server_id_36, t0.company_group_server_hash AS company_group_server_hash_37, t0.company_group_server_address AS company_group_server_address_38, t0.company_group_server_port AS company_group_server_port_39, t0.company_bin AS company_bin_40, t0.company_tin AS company_tin_41, t0.company_reg AS company_reg_42, t0.company_tl AS company_tl_43, t0.initiate_flag AS initiate_flag_44, t0.current_server_id AS current_server_id_45, t0.current_server_hash AS current_server_hash_46, t0.current_server_address AS current_server_address_47, t0.current_server_port AS current_server_port_48, t0.usage_valid_upto_date AS usage_valid_upto_date_49, t0.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_50, t0.company_group_server_domain_full_link AS company_group_server_domain_full_link_51, t0.current_server_domain_full_link AS current_server_domain_full_link_52, t0.company_group_billing_info AS company_group_billing_info_53, t0.company_group_next_bill_date AS company_group_next_bill_date_54, t0.company_group_next_bill_date_ts AS company_group_next_bill_date_ts_55, t0.company_group_billing_frequency AS company_group_billing_frequency_56, t0.cash AS cash_57, t0.sales AS sales_58, t0.expense AS expense_59, t0.payable AS payable_60, t0.net_worth AS net_worth_61, t0.monthly_growth AS monthly_growth_62, t0.active AS active_63, t0.read_only_mode AS read_only_mode_64, t0.company_status AS company_status_65, t0.package_type AS package_type_66, t0.subscription_expiry AS subscription_expiry_67, t0.last_activity_at AS last_activity_at_68, t0.current_subscription_package_id AS current_subscription_package_id_69, t0.subscription_month AS subscription_month_70, t0.billing_amount AS billing_amount_71, t0.subscription_details AS subscription_details_72, t0.company_type AS company_type_73, t0.company_description AS company_description_74, t0.skip_in_web_flag AS skip_in_web_flag_75, t0.skip_in_app_flag AS skip_in_app_flag_76, t0.schema_update_pending_flag AS schema_update_pending_flag_77, t0.created_at AS created_at_78, t0.updated_at AS updated_at_79 FROM company_group t0 WHERE t0.app_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.persona_id AS persona_id_2,
  t0.channel AS channel_3,
  t0.identity_kind AS identity_kind_4,
  t0.address AS address_5,
  t0.provider_ref AS provider_ref_6,
  t0.verification_status AS verification_status_7,
  t0.verified_at AS verified_at_8,
  t0.active AS active_9,
  t0.created_by AS created_by_10,
  t0.created_by_name AS created_by_name_11,
  t0.created_at AS created_at_12,
  t0.revoked_by AS revoked_by_13,
  t0.revoked_at AS revoked_at_14
FROM
  channel_identity t0
WHERE
  t0.channel = ?
  AND t0.address = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.persona_id AS persona_id_2, t0.channel AS channel_3, t0.identity_kind AS identity_kind_4, t0.address AS address_5, t0.provider_ref AS provider_ref_6, t0.verification_status AS verification_status_7, t0.verified_at AS verified_at_8, t0.active AS active_9, t0.created_by AS created_by_10, t0.created_by_name AS created_by_name_11, t0.created_at AS created_at_12, t0.revoked_by AS revoked_by_13, t0.revoked_at AS revoked_at_14 FROM channel_identity t0 WHERE t0.channel = 'whatsapp' AND t0.address = '8801325081052' AND t0.active = 1 LIMIT 1;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.app_id AS app_id_2,
  t0.channel AS channel_3,
  t0.external_space_id AS external_space_id_4,
  t0.space_kind AS space_kind_5,
  t0.persona_id AS persona_id_6,
  t0.title AS title_7,
  t0.audience_default AS audience_default_8,
  t0.status AS status_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  communication_space t0
WHERE
  t0.app_id = ?
  AND t0.channel = ?
  AND t0.external_space_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.app_id AS app_id_2, t0.channel AS channel_3, t0.external_space_id AS external_space_id_4, t0.space_kind AS space_kind_5, t0.persona_id AS persona_id_6, t0.title AS title_7, t0.audience_default AS audience_default_8, t0.status AS status_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM communication_space t0 WHERE t0.app_id = 1 AND t0.channel = 'whatsapp' AND t0.external_space_id = 'wa:8801911706483' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  comm_inbox_event
SET
  STATUS = ?,
  message_id = ?,
  vault_ref = ?,
  processed_at = ?
WHERE
  id = ?

UPDATE comm_inbox_event SET STATUS = 'processed', message_id = 2, vault_ref = '784ef80ed7e6d97106c7411714a24d0e95987a93fb992c5a92ac1e5ab21e8e91', processed_at = '2026-07-15 21:29:53' WHERE id = '4';

SELECT
  t0.id AS id_1,
  t0.space_id AS space_id_2,
  t0.app_id AS app_id_3,
  t0.channel AS channel_4,
  t0.external_conversation_id AS external_conversation_id_5,
  t0.audience_context AS audience_context_6,
  t0.participant_fingerprint AS participant_fingerprint_7,
  t0.audience_version AS audience_version_8,
  t0.correlation_id AS correlation_id_9,
  t0.bound_type AS bound_type_10,
  t0.bound_id AS bound_id_11,
  t0.status AS status_12,
  t0.first_message_at AS first_message_at_13,
  t0.last_message_at AS last_message_at_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16
FROM
  comm_conversation t0
WHERE
  t0.app_id = ?
  AND t0.channel = ?
  AND t0.external_conversation_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.space_id AS space_id_2, t0.app_id AS app_id_3, t0.channel AS channel_4, t0.external_conversation_id AS external_conversation_id_5, t0.audience_context AS audience_context_6, t0.participant_fingerprint AS participant_fingerprint_7, t0.audience_version AS audience_version_8, t0.correlation_id AS correlation_id_9, t0.bound_type AS bound_type_10, t0.bound_id AS bound_id_11, t0.status AS status_12, t0.first_message_at AS first_message_at_13, t0.last_message_at AS last_message_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16 FROM comm_conversation t0 WHERE t0.app_id = 1 AND t0.channel = 'whatsapp' AND t0.external_conversation_id = 'wa:8801911706483' LIMIT 1;

UPDATE
  comm_conversation
SET
  last_message_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE comm_conversation SET last_message_at = '2026-07-15 21:29:53', updated_at = '2026-07-15 21:29:53' WHERE id = '1';

SELECT
  t0.id AS id_1,
  t0.fingerprint AS fingerprint_2,
  t0.app_id AS app_id_3,
  t0.channel AS channel_4,
  t0.correlation_id AS correlation_id_5,
  t0.vault_ref AS vault_ref_6,
  t0.error_class AS error_class_7,
  t0.error_message AS error_message_8,
  t0.payload_hash AS payload_hash_9,
  t0.attempts AS attempts_10,
  t0.first_failed_at AS first_failed_at_11,
  t0.last_failed_at AS last_failed_at_12,
  t0.replayed_at AS replayed_at_13,
  t0.resolved AS resolved_14,
  t0.created_at AS created_at_15
FROM
  comm_failed_event t0
WHERE
  t0.fingerprint = ?
  AND t0.resolved = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.fingerprint AS fingerprint_2, t0.app_id AS app_id_3, t0.channel AS channel_4, t0.correlation_id AS correlation_id_5, t0.vault_ref AS vault_ref_6, t0.error_class AS error_class_7, t0.error_message AS error_message_8, t0.payload_hash AS payload_hash_9, t0.attempts AS attempts_10, t0.first_failed_at AS first_failed_at_11, t0.last_failed_at AS last_failed_at_12, t0.replayed_at AS replayed_at_13, t0.resolved AS resolved_14, t0.created_at AS created_at_15 FROM comm_failed_event t0 WHERE t0.fingerprint = '784ef80ed7e6d97106c7411714a24d0e95987a93fb992c5a92ac1e5ab21e8e91' AND t0.resolved = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.app_id AS app_id_2,
  t0.business_number AS business_number_3,
  t0.contact_number AS contact_number_4,
  t0.consent AS consent_5,
  t0.session_expires_at AS session_expires_at_6,
  t0.last_inbound_at AS last_inbound_at_7,
  t0.opted_at AS opted_at_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  wa_contact_consent t0
WHERE
  t0.app_id = ?
  AND t0.business_number = ?
  AND t0.contact_number = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.app_id AS app_id_2, t0.business_number AS business_number_3, t0.contact_number AS contact_number_4, t0.consent AS consent_5, t0.session_expires_at AS session_expires_at_6, t0.last_inbound_at AS last_inbound_at_7, t0.opted_at AS opted_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM wa_contact_consent t0 WHERE t0.app_id = 1 AND t0.business_number = '8801325081052' AND t0.contact_number = '8801911706483' LIMIT 1;

INSERT INTO comm_message (
  conversation_id, app_id, channel,
  external_message_id, direction,
  sender_ref, sender_display, occurred_at,
  body_hash, vault_ref, security_state,
  correlation_id, created_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO comm_message (conversation_id, app_id, channel, external_message_id, direction, sender_ref, sender_display, occurred_at, body_hash, vault_ref, security_state, correlation_id, created_at) VALUES (1, 1, 'whatsapp', 'wamid.HBgNODgwMTkxMTcwNjQ4MxUCABIYFDNBREM3NTMwMzMwRTU5NUM3NTI5AA==', 'inbound', '8801911706483', 'Mozibul Yasser', '2026-07-15 21:29:51', '47ad9cb7408d313758ba980f7cd0140eebb3341161765ba7348845f08ba64e7f', '784ef80ed7e6d97106c7411714a24d0e95987a93fb992c5a92ac1e5ab21e8e91', 'pending', 'trace_4cf80eac2e915df899f3f598', '2026-07-15 21:29:53');

SELECT
  t0.id AS id_1,
  t0.app_id AS app_id_2,
  t0.conversation_id AS conversation_id_3,
  t0.persona_id AS persona_id_4,
  t0.requested_by AS requested_by_5,
  t0.assigned_owner_id AS assigned_owner_id_6,
  t0.reason AS reason_7,
  t0.status AS status_8,
  t0.resolved_by AS resolved_by_9,
  t0.resolved_at AS resolved_at_10,
  t0.created_at AS created_at_11
FROM
  comm_handover t0
WHERE
  t0.conversation_id = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.app_id AS app_id_2, t0.conversation_id AS conversation_id_3, t0.persona_id AS persona_id_4, t0.requested_by AS requested_by_5, t0.assigned_owner_id AS assigned_owner_id_6, t0.reason AS reason_7, t0.status AS status_8, t0.resolved_by AS resolved_by_9, t0.resolved_at AS resolved_at_10, t0.created_at AS created_at_11 FROM comm_handover t0 WHERE t0.conversation_id = 1 AND t0.status = 'open' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.principal_id AS principal_id_2,
  t0.app_id AS app_id_3,
  t0.display_name AS display_name_4,
  t0.role_title AS role_title_5,
  t0.sender_alias AS sender_alias_6,
  t0.reply_to AS reply_to_7,
  t0.signature_template AS signature_template_8,
  t0.branding_ref AS branding_ref_9,
  t0.status AS status_10,
  t0.created_by AS created_by_11,
  t0.created_by_name AS created_by_name_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.disabled_by AS disabled_by_15,
  t0.disabled_at AS disabled_at_16
FROM
  business_persona t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.principal_id AS principal_id_2, t0.app_id AS app_id_3, t0.display_name AS display_name_4, t0.role_title AS role_title_5, t0.sender_alias AS sender_alias_6, t0.reply_to AS reply_to_7, t0.signature_template AS signature_template_8, t0.branding_ref AS branding_ref_9, t0.status AS status_10, t0.created_by AS created_by_11, t0.created_by_name AS created_by_name_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.disabled_by AS disabled_by_15, t0.disabled_at AS disabled_at_16 FROM business_persona t0 WHERE t0.id = 1;

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = DATABASE()
  AND table_name = 'platform_setting'

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = 'platform_setting';

SELECT
  t0.id AS id_1,
  t0.fingerprint AS fingerprint_2,
  t0.app_id AS app_id_3,
  t0.channel AS channel_4,
  t0.external_space_id AS external_space_id_5,
  t0.external_message_id AS external_message_id_6,
  t0.correlation_id AS correlation_id_7,
  t0.status AS status_8,
  t0.message_id AS message_id_9,
  t0.vault_ref AS vault_ref_10,
  t0.attempts AS attempts_11,
  t0.received_at AS received_at_12,
  t0.processed_at AS processed_at_13,
  t0.last_error AS last_error_14,
  t0.created_at AS created_at_15
FROM
  comm_inbox_event t0
WHERE
  t0.fingerprint = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.fingerprint AS fingerprint_2, t0.app_id AS app_id_3, t0.channel AS channel_4, t0.external_space_id AS external_space_id_5, t0.external_message_id AS external_message_id_6, t0.correlation_id AS correlation_id_7, t0.status AS status_8, t0.message_id AS message_id_9, t0.vault_ref AS vault_ref_10, t0.attempts AS attempts_11, t0.received_at AS received_at_12, t0.processed_at AS processed_at_13, t0.last_error AS last_error_14, t0.created_at AS created_at_15 FROM comm_inbox_event t0 WHERE t0.fingerprint = '784ef80ed7e6d97106c7411714a24d0e95987a93fb992c5a92ac1e5ab21e8e91' LIMIT 1;

INSERT INTO comm_inbox_event (
  fingerprint, app_id, channel, external_space_id,
  external_message_id, correlation_id,
  STATUS, message_id, vault_ref, attempts,
  received_at, processed_at, last_error,
  created_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO comm_inbox_event (fingerprint, app_id, channel, external_space_id, external_message_id, correlation_id, STATUS, message_id, vault_ref, attempts, received_at, processed_at, last_error, created_at) VALUES ('784ef80ed7e6d97106c7411714a24d0e95987a93fb992c5a92ac1e5ab21e8e91', 1, 'whatsapp', 'wa:8801911706483', 'wamid.HBgNODgwMTkxMTcwNjQ4MxUCABIYFDNBREM3NTMwMzMwRTU5NUM3NTI5AA==', 'trace_4cf80eac2e915df899f3f598', 'received', NULL, NULL, 1, '2026-07-15 21:29:52', NULL, NULL, '2026-07-15 21:29:52');

UPDATE
  wa_contact_consent
SET
  session_expires_at = ?,
  last_inbound_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE wa_contact_consent SET session_expires_at = '2026-07-16 21:29:52', last_inbound_at = '2026-07-15 21:29:52', updated_at = '2026-07-15 21:29:52' WHERE id = '1';

SELECT
  setting_value
FROM
  platform_setting
WHERE
  name = ?
  AND app_id = ?
LIMIT
  1

SELECT setting_value FROM platform_setting WHERE name = 'ai_employee_enabled' AND app_id = 1 LIMIT 1;