Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.inquiry_id AS inquiry_id_2,
  t0.inquiry_type AS inquiry_type_3,
  t0.inquiry_order_id AS inquiry_order_id_4,
  t0.inquiry_configuration_id AS inquiry_configuration_id_5,
  t0.date AS date_6,
  t0.email AS email_7,
  t0.firstname AS firstname_8,
  t0.lastname AS lastname_9,
  t0.company AS company_10,
  t0.street AS street_11,
  t0.zipcode AS zipcode_12,
  t0.city AS city_13,
  t0.phone AS phone_14,
  t0.phone_plain AS phone_plain_15,
  t0.phone_reachable AS phone_reachable_16,
  t0.phone_original AS phone_original_17,
  t0.message AS message_18,
  t0.product_request AS product_request_19,
  t0.configuration_price AS configuration_price_20,
  t0.configuration_price_discount AS configuration_price_discount_21,
  t0.configuration_price_before_discount AS configuration_price_before_discount_22,
  t0.configuration_discount_percent_complete AS configuration_discount_percent_complete_23,
  t0.sent_to_hubspot AS sent_to_hubspot_24,
  t0.product_group AS product_group_25,
  t0.product AS product_26,
  t0.attached_files AS attached_files_27,
  t0.salutation AS salutation_28,
  t0.sent_to_hubspot_error AS sent_to_hubspot_error_29,
  t0.microtech_an_no AS microtech_an_no_30,
  t0.status AS status_31,
  t0.status_reason AS status_reason_32,
  t0.status_comment AS status_comment_33,
  t0.status_date AS status_date_34,
  t0.assigned_by AS assigned_by_35,
  t0.assigned_to AS assigned_to_36,
  t0.can_not_send_to_hubspot AS can_not_send_to_hubspot_37,
  t0.coupon AS coupon_38,
  t0.coupon_validation AS coupon_validation_39
FROM
  _mis_inquiry t0
WHERE
  t0.sent_to_hubspot = ?
  AND t0.sent_to_hubspot_error = ?
  AND t0.can_not_send_to_hubspot = ?

SELECT t0.id AS id_1, t0.inquiry_id AS inquiry_id_2, t0.inquiry_type AS inquiry_type_3, t0.inquiry_order_id AS inquiry_order_id_4, t0.inquiry_configuration_id AS inquiry_configuration_id_5, t0.date AS date_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.company AS company_10, t0.street AS street_11, t0.zipcode AS zipcode_12, t0.city AS city_13, t0.phone AS phone_14, t0.phone_plain AS phone_plain_15, t0.phone_reachable AS phone_reachable_16, t0.phone_original AS phone_original_17, t0.message AS message_18, t0.product_request AS product_request_19, t0.configuration_price AS configuration_price_20, t0.configuration_price_discount AS configuration_price_discount_21, t0.configuration_price_before_discount AS configuration_price_before_discount_22, t0.configuration_discount_percent_complete AS configuration_discount_percent_complete_23, t0.sent_to_hubspot AS sent_to_hubspot_24, t0.product_group AS product_group_25, t0.product AS product_26, t0.attached_files AS attached_files_27, t0.salutation AS salutation_28, t0.sent_to_hubspot_error AS sent_to_hubspot_error_29, t0.microtech_an_no AS microtech_an_no_30, t0.status AS status_31, t0.status_reason AS status_reason_32, t0.status_comment AS status_comment_33, t0.status_date AS status_date_34, t0.assigned_by AS assigned_by_35, t0.assigned_to AS assigned_to_36, t0.can_not_send_to_hubspot AS can_not_send_to_hubspot_37, t0.coupon AS coupon_38, t0.coupon_validation AS coupon_validation_39 FROM _mis_inquiry t0 WHERE t0.sent_to_hubspot = '0' AND t0.sent_to_hubspot_error = '0' AND t0.can_not_send_to_hubspot = '0';

"COMMIT"

"COMMIT";

UPDATE
  _mis_inquiry
SET
  sent_to_hubspot = ?
WHERE
  id = ?

UPDATE _mis_inquiry SET sent_to_hubspot = 1 WHERE id = 211894;

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";

INSERT INTO hubspot_api_call (
  status, marked_read, type, url, request_header,
  response_header, request, response,
  created_at, updated_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO hubspot_api_call (status, marked_read, type, url, request_header, response_header, request, response, created_at, updated_at) VALUES (200, 0, 'POST', '/crm/v3/objects/contact/batch/upsert', 'HUBSPOT PHP CLIENT FACTORY CREATED WITH ACCESS-TOKEN', '{\"Date\":[\"Wed, 03 Jun 2026 20:14:04 GMT\"],\"Content-Type\":[\"application\\/json;charset=utf-8\"],\"Transfer-Encoding\":[\"chunked\"],\"Connection\":[\"keep-alive\"],\"CF-Ray\":[\"a0615caadbdffe94-AMS\"],\"CF-Cache-Status\":[\"DYNAMIC\"],\"Nel\":[\"{\\\"report_to\\\":\\\"cf-nel\\\",\\\"success_fraction\\\":0.01,\\\"max_age\\\":604800}\"],\"Server\":[\"cloudflare\"],\"Strict-Transport-Security\":[\"max-age=31536000; includeSubDomains; preload\"],\"Vary\":[\"origin, accept-encoding\"],\"access-control-allow-credentials\":[\"false\"],\"server-timing\":[\"hcid;desc=\\\"019e8f1f-275c-7a59-b1ad-f19c1f547662\\\", cfr;desc=\\\"a0615caba606fe94-FRA\\\"\"],\"x-hubspot-correlation-id\":[\"019e8f1f-275c-7a59-b1ad-f19c1f547662\"],\"x-hubspot-ratelimit-daily\":[\"625000\"],\"x-hubspot-ratelimit-daily-remaining\":[\"624096\"],\"x-hubspot-ratelimit-interval-milliseconds\":[\"10000\"],\"x-hubspot-ratelimit-max\":[\"190\"],\"x-hubspot-ratelimit-remaining\":[\"189\"],\"x-hubspot-ratelimit-secondly\":[\"19\"],\"x-hubspot-ratelimit-secondly-remaining\":[\"18\"],\"set-cookie\":[\"__cf_bm=kyJReo3y2Ss43FkCBnOPMGriQUx9ZpbbjcMBSuOHBPQ-1780517643.979282-1.0.1.1-gz.W_BhdqTmHrgUkCdKGDtNCIvVkud1j0CjZfJ.CrWvnKEKGBOq_nBDXqCVhNxTY5YWWNAcLL30Yqx_acujeAXKU06QxoDchg1776lu7DhZBvobCaQshEgGT2_t1SAFa; HttpOnly; SameSite=None; Secure; Path=\\/; Domain=hubapi.com; Expires=Wed, 03 Jun 2026 20:44:04 GMT\"],\"Report-To\":[\"{\\\"group\\\":\\\"cf-nel\\\",\\\"max_age\\\":604800,\\\"endpoints\\\":[{\\\"url\\\":\\\"https:\\/\\/a.nel.cloudflare.com\\/report\\/v4?s=0%2B94QMvR%2BxNIJX2o7lbfeAioRntkBggGR8QdWCqMiRWRAe6PpbErP2Sp7YN1%2FsZtD1MP7CxozNKuoVScYmsQoNSnESYdEeYAHdXcSFR1065dTb46pxKoTyvQMgGKkDQk\\\"}]}\"]}', '{
    \"inputs\": [
        {
            \"properties\": {
                \"email\": \"klaus.hochreiter@gmx.net\",
                \"firstname\": \"Klaus\",
                \"lastname\": \"Hochreiter\",
                \"phone\": \"0170 2937 998\",
                \"company\": \"\",
                \"address\": \"Keplerstr. 35\",
                \"zip\": \"22763\",
                \"city\": \"Hamburg\",
                \"salutation\": \"Herr\",
                \"gesellschaft\": \"Glasprofi24 GmbH\"
            },
            \"id\": \"klaus.hochreiter@gmx.net\",
            \"idProperty\": \"email\"
        }
    ]
}', '{\"completedAt\":\"2026-06-03T20:14:04.276Z\",\"status\":\"COMPLETE\",\"startedAt\":\"2026-06-03T20:14:04.135Z\",\"results\":[{\"id\":\"770606393541\",\"properties\":{\"address\":\"Keplerstr. 35\",\"city\":\"Hamburg\",\"createdate\":\"2026-05-03T11:39:23.758Z\",\"email\":\"klaus.hochreiter@gmx.net\",\"first_deal_created_date\":\"2026-05-03T11:40:12.864Z\",\"firstname\":\"Klaus\",\"gesellschaft\":\"Glasprofi24 GmbH\",\"hs_all_accessible_team_ids\":\"150496668\",\"hs_all_owner_ids\":\"322216723\",\"hs_all_team_ids\":\"150496668\",\"hs_count_is_unworked\":\"1\",\"hs_count_is_worked\":\"0\",\"hs_full_name_or_email\":\"Klaus Hochreiter\",\"hs_is_contact\":\"true\",\"hs_is_unworked\":\"false\",\"hs_object_id\":\"770606393541\",\"hs_object_source\":\"FORM\",\"hs_object_source_id\":\"f3f2fa25-72a4-4c15-a8f1-554c708e62e2\",\"hs_object_source_label\":\"FORM\",\"hs_pipeline\":\"contacts-lifecycle-pipeline\",\"hs_time_between_contact_creation_and_deal_creation\":\"49106\",\"hs_user_ids_of_all_owners\":\"71517343\",\"hs_v2_date_entered_current_stage\":\"2026-05-03T11:40:13.398Z\",\"hs_v2_time_in_current_stage\":\"2026-05-03T11:40:13.398Z\",\"hubspot_owner_assigneddate\":\"2026-05-07T13:27:03.488Z\",\"hubspot_owner_id\":\"322216723\",\"hubspot_team_id\":\"150496668\",\"lastmodifieddate\":\"2026-06-03T20:14:04.170Z\",\"lastname\":\"Hochreiter\",\"lifecyclestage\":\"opportunity\",\"notes_last_updated\":\"2026-05-22T08:51:04Z\",\"phone\":\"0170 2937 998\",\"salutation\":\"Herr\",\"zip\":\"22763\"},\"createdAt\":\"2026-05-03T11:39:23.758Z\",\"updatedAt\":\"2026-06-03T20:14:04.170Z\",\"archived\":false,\"url\":\"https://app-eu1.hubspot.com/contacts/143888670/record/0-1/770606393541\",\"new\":false}]}', '2026-06-03 22:14:04', NULL);

INSERT INTO hubspot_deal_api_call (
  gp24_inquiry_id, mis_inquiry_id,
  hubspot_api_call_id, created_at,
  updated_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO hubspot_deal_api_call (gp24_inquiry_id, mis_inquiry_id, hubspot_api_call_id, created_at, updated_at) VALUES (196036, 211894, 115035, '2026-06-03 22:14:04', NULL);

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO api_fox_log (
  message, type, file, line, created_at,
  updated_at
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO api_fox_log (message, type, file, line, created_at, updated_at) VALUES ('Hubspot-Calls successful. Ended without product data.', 'Success', '', '', '2026-06-03 22:14:08', NULL);