Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.upload AS upload_4,
  t0.description AS description_5
FROM
  environment_parameter t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.upload AS upload_4,
  t0.description AS description_5
FROM
  environment_parameter t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0;

SELECT
  e0_.id AS id_0,
  e0_.header_background_color AS header_background_color_1,
  e0_.wrapper_background_color AS wrapper_background_color_2,
  e0_.content_background_color AS content_background_color_3,
  e0_.text_color AS text_color_4,
  e0_.link_color AS link_color_5,
  e0_.heading_color AS heading_color_6,
  e0_.button_background_color AS button_background_color_7,
  e0_.button_text_color AS button_text_color_8,
  e0_.font_family AS font_family_9,
  e0_.logo_filename AS logo_filename_10,
  e0_.logo_width AS logo_width_11,
  e0_.footer_extra_html AS footer_extra_html_12,
  e0_.social_facebook_url AS social_facebook_url_13,
  e0_.social_instagram_url AS social_instagram_url_14,
  e0_.social_linkedin_url AS social_linkedin_url_15,
  e0_.mail_proposal_text AS mail_proposal_text_16,
  e0_.mail_order_text AS mail_order_text_17,
  e0_.mail_invoice_text AS mail_invoice_text_18,
  e0_.mail_invoice_with_pay_url_text AS mail_invoice_with_pay_url_text_19,
  e0_.mail_invoice_reminder_text AS mail_invoice_reminder_text_20,
  e0_.mail_invoice_reminder_with_pay_url_text AS mail_invoice_reminder_with_pay_url_text_21,
  e0_.mail_invoice_text_direct_debit AS mail_invoice_text_direct_debit_22,
  e0_.mail_proposal_subject AS mail_proposal_subject_23,
  e0_.mail_order_subject AS mail_order_subject_24,
  e0_.mail_invoice_subject AS mail_invoice_subject_25,
  e0_.mail_invoice_with_pay_url_subject AS mail_invoice_with_pay_url_subject_26,
  e0_.mail_invoice_reminder_subject AS mail_invoice_reminder_subject_27,
  e0_.mail_invoice_reminder_with_pay_url_subject AS mail_invoice_reminder_with_pay_url_subject_28,
  e0_.mail_invoice_subject_direct_debit AS mail_invoice_subject_direct_debit_29,
  e0_.default_mail_pdf_with_template AS default_mail_pdf_with_template_30,
  e0_.modify_date AS modify_date_31,
  e0_.modified_by_user_id AS modified_by_user_id_32
FROM
  email_branding e0_
ORDER BY
  e0_.id ASC
LIMIT
  1

SELECT e0_.id AS id_0, e0_.header_background_color AS header_background_color_1, e0_.wrapper_background_color AS wrapper_background_color_2, e0_.content_background_color AS content_background_color_3, e0_.text_color AS text_color_4, e0_.link_color AS link_color_5, e0_.heading_color AS heading_color_6, e0_.button_background_color AS button_background_color_7, e0_.button_text_color AS button_text_color_8, e0_.font_family AS font_family_9, e0_.logo_filename AS logo_filename_10, e0_.logo_width AS logo_width_11, e0_.footer_extra_html AS footer_extra_html_12, e0_.social_facebook_url AS social_facebook_url_13, e0_.social_instagram_url AS social_instagram_url_14, e0_.social_linkedin_url AS social_linkedin_url_15, e0_.mail_proposal_text AS mail_proposal_text_16, e0_.mail_order_text AS mail_order_text_17, e0_.mail_invoice_text AS mail_invoice_text_18, e0_.mail_invoice_with_pay_url_text AS mail_invoice_with_pay_url_text_19, e0_.mail_invoice_reminder_text AS mail_invoice_reminder_text_20, e0_.mail_invoice_reminder_with_pay_url_text AS mail_invoice_reminder_with_pay_url_text_21, e0_.mail_invoice_text_direct_debit AS mail_invoice_text_direct_debit_22, e0_.mail_proposal_subject AS mail_proposal_subject_23, e0_.mail_order_subject AS mail_order_subject_24, e0_.mail_invoice_subject AS mail_invoice_subject_25, e0_.mail_invoice_with_pay_url_subject AS mail_invoice_with_pay_url_subject_26, e0_.mail_invoice_reminder_subject AS mail_invoice_reminder_subject_27, e0_.mail_invoice_reminder_with_pay_url_subject AS mail_invoice_reminder_with_pay_url_subject_28, e0_.mail_invoice_subject_direct_debit AS mail_invoice_subject_direct_debit_29, e0_.default_mail_pdf_with_template AS default_mail_pdf_with_template_30, e0_.modify_date AS modify_date_31, e0_.modified_by_user_id AS modified_by_user_id_32 FROM email_branding e0_ ORDER BY e0_.id ASC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO event_log (
  category, title, description, date,
  user_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO event_log (category, title, description, date, user_id) VALUES ('Info', 'Outbound VOIP Call Start', 'uuid=1781205254.63639&direction=outbound&disposition=UNKNOWN&source=502&destination=0031548515016&recordingfile=&duration=0&calldate=1781205254&timestamp=1781205254&clid=&cnam=&cnum=&type=START&voicemail=&owner=0', '2026-06-11 21:14:15', NULL);

"COMMIT"

"COMMIT";

SELECT
  c.id AS customerId
FROM
  `customer` c
WHERE
  c.is_deleted = false
  AND (
    REPLACE(
      REPLACE(
        REPLACE(c.phone_primary, '-', ''),
        '+',
        ''
      ),
      ' ',
      ''
    ) LIKE ?
    OR REPLACE(
      REPLACE(
        REPLACE(c.phone_secondary, '-', ''),
        '+',
        ''
      ),
      ' ',
      ''
    ) LIKE ?
  )
ORDER BY
  create_date DESC
LIMIT
  1;

SELECT c.id AS customerId
			FROM   `customer` c
			WHERE  c.is_deleted = false
				AND
				(REPLACE(REPLACE(REPLACE(c.phone_primary, '-', ''), '+', ''), ' ', '') LIKE '%548515016%'
					OR
				 REPLACE(REPLACE(REPLACE(c.phone_secondary, '-', ''), '+', ''), ' ', '') LIKE '%548515016%')
			ORDER BY create_date DESC LIMIT 1;
		;

SELECT
  cda.id AS deliveryAddressId
FROM
  `customer_delivery_address` cda
  INNER JOIN `customer` c ON cda.customer_id = c.id
WHERE
  cda.is_deleted = false
  AND c.is_deleted = false
  AND (
    REPLACE(
      REPLACE(
        REPLACE(cda.phone_number, '-', ''),
        '+',
        ''
      ),
      ' ',
      ''
    ) LIKE ?
    OR REPLACE(
      REPLACE(
        REPLACE(cda.phone_number, '-', ''),
        '+',
        ''
      ),
      ' ',
      ''
    ) LIKE ?
  )
ORDER BY
  cda.create_date DESC
LIMIT
  1;

SELECT cda.id AS deliveryAddressId
			FROM   `customer_delivery_address` cda
			INNER JOIN `customer` c ON cda.customer_id = c.id
			WHERE  cda.is_deleted = false
				AND c.is_deleted = false
				AND
				(REPLACE(REPLACE(REPLACE(cda.phone_number, '-', ''), '+', ''), ' ', '') LIKE '%548515016%'
					OR
				 REPLACE(REPLACE(REPLACE(cda.phone_number, '-', ''), '+', ''), ' ', '') LIKE '%548515016%')
			ORDER BY cda.create_date DESC LIMIT 1;
		;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO call_history (
  voip_identification, remark, phone_number,
  destination_number, start_call_date,
  end_call_date, is_incoming, is_answered,
  is_processed, create_date, modify_date,
  is_deleted, call_duration, customer_id,
  matched_delivery_address_id, dossier_id,
  created_by_user_id, modified_by_user_id,
  call_category_id, related_order_id,
  related_proposal_id, related_ticket_id,
  related_appointment_id, related_complaint_id,
  related_sales_lead_id, related_task_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO call_history (voip_identification, remark, phone_number, destination_number, start_call_date, end_call_date, is_incoming, is_answered, is_processed, create_date, modify_date, is_deleted, call_duration, customer_id, matched_delivery_address_id, dossier_id, created_by_user_id, modified_by_user_id, call_category_id, related_order_id, related_proposal_id, related_ticket_id, related_appointment_id, related_complaint_id, related_sales_lead_id, related_task_id) VALUES ('1781205254.63639', NULL, 'Kassa PC hoofd (502)', '0548515016', '2026-06-11 21:14:14', NULL, 0, 0, 0, '2026-06-11 21:14:15', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

"COMMIT"

"COMMIT";