Symfony Profiler

SELECT
  t0.url AS url_1,
  t0.token AS token_2,
  t0.enabled AS enabled_3,
  t0.revoked AS revoked_4,
  t0.expires_at AS expires_at_5,
  t0.data AS data_6,
  t0.id AS id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.client_id AS client_id_10,
  t0.application_id AS application_id_11
FROM
  tenant t0
WHERE
  t0.token = ?
  AND t0.enabled = ?
  AND t0.revoked = ?
LIMIT
  1

SELECT t0.url AS url_1, t0.token AS token_2, t0.enabled AS enabled_3, t0.revoked AS revoked_4, t0.expires_at AS expires_at_5, t0.data AS data_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.client_id AS client_id_10, t0.application_id AS application_id_11 FROM tenant t0 WHERE t0.token = 'mmOzfxb7RMCFrn3P-NZC14NPb4DBw1KA0DGfqcszHtumOmcvYbHQ28x4pd1YioiFcYD0_LkhKPSuujL_nzls5A' AND t0.enabled = 1 AND t0.revoked = 0 LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.enabled AS enabled_4,
  t0.data AS data_5,
  t0.id AS id_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.creator_id AS creator_id_9
FROM
  application t0
WHERE
  t0.id = ?

SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.enabled AS enabled_4, t0.data AS data_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.creator_id AS creator_id_9 FROM application t0 WHERE t0.id = '1f0affb7-9aba-6bd2-9389-a58a9e3402d9';

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.adapter AS adapter_3,
  t0.url AS url_4,
  t0.settings AS settings_5,
  t0.enabled AS enabled_6,
  t0.id AS id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.client_id AS client_id_10
FROM
  access_point t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.adapter AS adapter_3, t0.url AS url_4, t0.settings AS settings_5, t0.enabled AS enabled_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.client_id AS client_id_10 FROM access_point t0 WHERE t0.id = '1f0b498e-1bb6-6888-9366-6da7e4854e9c';

SELECT
  t0.name AS name_1,
  t0.identifier_type AS identifier_type_2,
  t0.identifier AS identifier_3,
  t0.address AS address_4,
  t0.city AS city_5,
  t0.postal_code AS postal_code_6,
  t0.email AS email_7,
  t0.country_subentity AS country_subentity_8,
  t0.country AS country_9,
  t0.country_code AS country_code_10,
  t0.data AS data_11,
  t0.keywords AS keywords_12,
  t0.id AS id_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  participant t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.identifier_type AS identifier_type_2, t0.identifier AS identifier_3, t0.address AS address_4, t0.city AS city_5, t0.postal_code AS postal_code_6, t0.email AS email_7, t0.country_subentity AS country_subentity_8, t0.country AS country_9, t0.country_code AS country_code_10, t0.data AS data_11, t0.keywords AS keywords_12, t0.id AS id_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM participant t0 WHERE t0.id = '1f0f2c20-74ba-64ca-8b70-c3467a63fc58';

SELECT
  t0.url AS url_1,
  t0.token AS token_2,
  t0.enabled AS enabled_3,
  t0.revoked AS revoked_4,
  t0.expires_at AS expires_at_5,
  t0.data AS data_6,
  t0.id AS id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.client_id AS client_id_10,
  t0.application_id AS application_id_11
FROM
  tenant t0
  INNER JOIN participant_tenant ON t0.id = participant_tenant.tenant_id
WHERE
  participant_tenant.participant_id = ?

SELECT t0.url AS url_1, t0.token AS token_2, t0.enabled AS enabled_3, t0.revoked AS revoked_4, t0.expires_at AS expires_at_5, t0.data AS data_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.client_id AS client_id_10, t0.application_id AS application_id_11 FROM tenant t0 INNER JOIN participant_tenant ON t0.id = participant_tenant.tenant_id WHERE participant_tenant.participant_id = '1f0f2c20-74ba-64ca-8b70-c3467a63fc58';

SELECT
  t0.data AS data_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.access_point_id AS access_point_id_5,
  t0.participant_id AS participant_id_6
FROM
  access_point_participant t0
WHERE
  t0.participant_id = ?

SELECT t0.data AS data_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.access_point_id AS access_point_id_5, t0.participant_id AS participant_id_6 FROM access_point_participant t0 WHERE t0.participant_id = '1f0f2c20-74ba-64ca-8b70-c3467a63fc58';

SELECT
  t0.name AS name_1,
  t0.data AS data_2,
  t0.keywords AS keywords_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.data AS data_2, t0.keywords AS keywords_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM client t0 WHERE t0.id = '1f0f1e95-871d-6d6c-9238-c76791cfa0f7';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO log (
  type, data, method, endpoint, http_status,
  duration, keywords, position, id,
  created_at, access_point_id, application_id,
  client_id, participant_id, tenant_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO log (type, data, method, endpoint, http_status, duration, keywords, position, id, created_at, access_point_id, application_id, client_id, participant_id, tenant_id) VALUES ('b2brouter_fetch', '{\"url\":\"https:\\/\\/api-staging.b2brouter.net\\/accounts\\/254655\\/invoices\",\"method\":\"GET\",\"options\":{\"querystring\":{\"offset\":0,\"limit\":100,\"type\":\"ReceivedInvoice\",\"new\":true}},\"request_url\":\"https:\\/\\/api-staging.b2brouter.net\\/accounts\\/254655\\/invoices?offset=0&limit=100&type=ReceivedInvoice&new=1\",\"request_options\":{\"headers\":{\"X-B2B-API-KEY\":\"****\",\"accept\":\"application\\/json\"}},\"payload_content\":null,\"response_status\":200,\"response_content\":\"{\\\"invoices\\\":[{\\\"id\\\":641829,\\\"type\\\":\\\"ReceivedInvoice\\\",\\\"number\\\":\\\"TEST_CALCUL_HT_02\\\",\\\"file_reference\\\":null,\\\"series_code\\\":null,\\\"date\\\":\\\"2026-02-13\\\",\\\"due_date\\\":\\\"2026-03-15\\\",\\\"contact\\\":{\\\"id\\\":1313414043,\\\"name\\\":\\\"Sogis\\\",\\\"tin_value\\\":null,\\\"tin_scheme\\\":1},\\\"state\\\":\\\"new\\\",\\\"total\\\":2074.93,\\\"currency\\\":\\\"EUR\\\",\\\"created_at\\\":\\\"2026-02-13T10:20:17.000Z\\\",\\\"updated_at\\\":\\\"2026-02-13T10:20:17.000Z\\\",\\\"state_updated_at\\\":\\\"2026-02-13T10:20:17.000Z\\\",\\\"from_net_id\\\":\\\"f9c7b6f4-bcc3-4b4e-9b7a-5af1d6ae6779@b2brouter.xml\\\",\\\"from_net_meta\\\":null},{\\\"id\\\":641726,\\\"type\\\":\\\"ReceivedInvoice\\\",\\\"number\\\":\\\"TEST_CALCUL_HT_01\\\",\\\"file_reference\\\":null,\\\"series_code\\\":null,\\\"date\\\":\\\"2026-02-13\\\",\\\"due_date\\\":\\\"2026-03-15\\\",\\\"contact\\\":{\\\"id\\\":1313414043,\\\"name\\\":\\\"Sogis\\\",\\\"tin_value\\\":null,\\\"tin_scheme\\\":1},\\\"state\\\":\\\"new\\\",\\\"total\\\":2074.93,\\\"currency\\\":\\\"EUR\\\",\\\"created_at\\\":\\\"2026-02-13T09:53:43.000Z\\\",\\\"updated_at\\\":\\\"2026-02-13T09:53:43.000Z\\\",\\\"state_updated_at\\\":\\\"2026-02-13T09:53:43.000Z\\\",\\\"from_net_id\\\":\\\"8ea4decd-8219-4146-b2f8-5794e9da6f4e@b2brouter.xml\\\",\\\"from_net_meta\\\":null},{\\\"id\\\":628746,\\\"type\\\":\\\"ReceivedInvoice\\\",\\\"number\\\":\\\"TEST-OPTIPRO-3\\\",\\\"file_reference\\\":null,\\\"series_code\\\":null,\\\"date\\\":\\\"2026-01-27\\\",\\\"due_date\\\":\\\"2026-02-11\\\",\\\"contact\\\":{\\\"id\\\":1313414043,\\\"name\\\":\\\"Sogis\\\",\\\"tin_value\\\":null,\\\"tin_scheme\\\":1},\\\"state\\\":\\\"new\\\",\\\"total\\\":680.02,\\\"currency\\\":\\\"EUR\\\",\\\"created_at\\\":\\\"2026-02-11T08:58:07.000Z\\\",\\\"updated_at\\\":\\\"2026-02-11T08:58:08.000Z\\\",\\\"state_updated_at\\\":\\\"2026-02-11T08:58:07.000Z\\\",\\\"from_net_id\\\":\\\"47ed63bf-58df-44f3-b828-56a68dde1a7b@b2brouter.xml\\\",\\\"from_net_meta\\\":null}],\\\"meta\\\":{\\\"total_count\\\":3,\\\"offset\\\":0,\\\"limit\\\":100}}\"}', 'GET', NULL, 200, 0.00082588195800781, 'b2brouterfetch get 200 000082588195800781 point dacces progetis optipro srl orisha  progetis httpsdevoptipoloptiproalphabe urlhttpsapistagingb2brouternetaccounts254655invoicesmethodgetoptionsquerystringoffset0limit100typereceivedinvoicenewtruerequesturlhttpsapistagingb2brouternetaccounts254655invoicesoffset0limit100typereceivedinvoicenew1requestoptionsheadersxb2bapikeyacceptapplicationjsonpayloadcontentnullresponsestatus200responsecontentinvoicesid641829typereceivedinvoicenumbertestcalculht02filereferencenullseriescodenulldate20260213duedate20260315contactid1313414043namesogistinvaluenulltinscheme1statenewtotal207493currencyeurcreatedat20260213t102017000zupdatedat20260213t102017000zstateupdatedat20260213t102017000zfromnetidf9c7b6f4bcc34b4e9b7a5af1d6ae6779b2brouterxmlfromnetmetanullid641726typereceivedinvoicenumbertestcalculht01filereferencenullseriescodenulldate20260213duedate20260315contactid1313414043namesogistinvaluenulltinscheme1statenewtotal207493currencyeurcreatedat20260213t095343000zupdatedat20260213t095343000zstateupdatedat20260213t095343000zfromnetid8ea4decd82194146b2f85794e9da6f4eb2brouterxmlfromnetmetanullid628746typereceivedinvoicenumbertestoptipro3filereferencenullseriescodenulldate20260127duedate20260211contactid1313414043namesogistinvaluenulltinscheme1statenewtotal68002currencyeurcreatedat20260211t085807000zupdatedat20260211t085808000zstateupdatedat20260211t085807000zfromnetid47ed63bf58df44f3b82856a68dde1a7bb2brouterxmlfromnetmetanullmetatotalcount3offset0limit100', NULL, '1f10d82d-68fe-6f90-a962-cdc04e567e0f', '2026-02-19 12:05:02', '1f0b498e-1bb6-6888-9366-6da7e4854e9c', '1f0affb7-9aba-6bd2-9389-a58a9e3402d9', '1f0f1e95-871d-6d6c-9238-c76791cfa0f7', NULL, '1f0f2b37-d2d8-6a14-970e-1fae92ab525e');

"COMMIT"

"COMMIT";

SELECT
  i0_.state AS state_0,
  i0_.direction AS direction_1,
  i0_.adapter_id AS adapter_id_2,
  i0_.id AS id_3,
  i0_.created_at AS created_at_4,
  i0_.updated_at AS updated_at_5,
  i0_.participant_id AS participant_id_6,
  i0_.access_point_id AS access_point_id_7
FROM
  invoice i0_
WHERE
  i0_.access_point_id = ?
  AND i0_.participant_id = ?
  AND i0_.adapter_id = ?
LIMIT
  1

SELECT i0_.state AS state_0, i0_.direction AS direction_1, i0_.adapter_id AS adapter_id_2, i0_.id AS id_3, i0_.created_at AS created_at_4, i0_.updated_at AS updated_at_5, i0_.participant_id AS participant_id_6, i0_.access_point_id AS access_point_id_7 FROM invoice i0_ WHERE i0_.access_point_id = '1f0b498e-1bb6-6888-9366-6da7e4854e9c' AND i0_.participant_id = '1f0f2c20-74ba-64ca-8b70-c3467a63fc58' AND i0_.adapter_id = '641829' LIMIT 1;

SELECT
  i0_.state AS state_0,
  i0_.direction AS direction_1,
  i0_.adapter_id AS adapter_id_2,
  i0_.id AS id_3,
  i0_.created_at AS created_at_4,
  i0_.updated_at AS updated_at_5,
  i0_.participant_id AS participant_id_6,
  i0_.access_point_id AS access_point_id_7
FROM
  invoice i0_
WHERE
  i0_.access_point_id = ?
  AND i0_.participant_id = ?
  AND i0_.adapter_id = ?
LIMIT
  1

SELECT i0_.state AS state_0, i0_.direction AS direction_1, i0_.adapter_id AS adapter_id_2, i0_.id AS id_3, i0_.created_at AS created_at_4, i0_.updated_at AS updated_at_5, i0_.participant_id AS participant_id_6, i0_.access_point_id AS access_point_id_7 FROM invoice i0_ WHERE i0_.access_point_id = '1f0b498e-1bb6-6888-9366-6da7e4854e9c' AND i0_.participant_id = '1f0f2c20-74ba-64ca-8b70-c3467a63fc58' AND i0_.adapter_id = '641726' LIMIT 1;

SELECT
  i0_.state AS state_0,
  i0_.direction AS direction_1,
  i0_.adapter_id AS adapter_id_2,
  i0_.id AS id_3,
  i0_.created_at AS created_at_4,
  i0_.updated_at AS updated_at_5,
  i0_.participant_id AS participant_id_6,
  i0_.access_point_id AS access_point_id_7
FROM
  invoice i0_
WHERE
  i0_.access_point_id = ?
  AND i0_.participant_id = ?
  AND i0_.adapter_id = ?
LIMIT
  1

SELECT i0_.state AS state_0, i0_.direction AS direction_1, i0_.adapter_id AS adapter_id_2, i0_.id AS id_3, i0_.created_at AS created_at_4, i0_.updated_at AS updated_at_5, i0_.participant_id AS participant_id_6, i0_.access_point_id AS access_point_id_7 FROM invoice i0_ WHERE i0_.access_point_id = '1f0b498e-1bb6-6888-9366-6da7e4854e9c' AND i0_.participant_id = '1f0f2c20-74ba-64ca-8b70-c3467a63fc58' AND i0_.adapter_id = '628746' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO log (
  type, data, method, endpoint, http_status,
  duration, keywords, position, id,
  created_at, access_point_id, application_id,
  client_id, participant_id, tenant_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO log (type, data, method, endpoint, http_status, duration, keywords, position, id, created_at, access_point_id, application_id, client_id, participant_id, tenant_id) VALUES ('api_resource_request', '{\"endpoint\":\"\\/api\\/invoices\\/received\",\"path\":\"\\/api\\/invoices\\/received\",\"method\":\"GET\",\"class\":\"App\\\\Entity\\\\Invoice\",\"payload_content\":\"\",\"response_status\":200,\"response_content\":\"[{\\\"id\\\":\\\"1f108c64-1b51-62b2-8d98-15c04fc1c3ca\\\",\\\"state\\\":\\\"new\\\",\\\"direction\\\":\\\"received\\\",\\\"number\\\":\\\"TEST_CALCUL_HT_02\\\",\\\"date\\\":\\\"2026-02-13T00:00:00+01:00\\\",\\\"due_date\\\":\\\"2026-03-15T00:00:00+01:00\\\",\\\"amount\\\":2074.93},{\\\"id\\\":\\\"1f108c21-0dd3-6c7c-8fa0-25c63136513d\\\",\\\"state\\\":\\\"new\\\",\\\"direction\\\":\\\"received\\\",\\\"number\\\":\\\"TEST_CALCUL_HT_01\\\",\\\"date\\\":\\\"2026-02-13T00:00:00+01:00\\\",\\\"due_date\\\":\\\"2026-03-15T00:00:00+01:00\\\",\\\"amount\\\":2074.93},{\\\"id\\\":\\\"1f107280-d278-6830-b27f-7ba00b1d0e24\\\",\\\"state\\\":\\\"new\\\",\\\"direction\\\":\\\"received\\\",\\\"number\\\":\\\"TEST-OPTIPRO-3\\\",\\\"date\\\":\\\"2026-01-27T00:00:00+01:00\\\",\\\"due_date\\\":\\\"2026-02-11T00:00:00+01:00\\\",\\\"amount\\\":680.02}]\"}', 'GET', '/api/invoices/received', 200, 0.23290205001831, 'apiresourcerequest get apiinvoicesreceived 200 023290205001831 optipro srl orisha  progetis httpsdevoptipoloptiproalphabe endpointapiinvoicesreceivedpathapiinvoicesreceivedmethodgetclassappentityinvoicepayloadcontentresponsestatus200responsecontentid1f108c641b5162b28d9815c04fc1c3castatenewdirectionreceivednumbertestcalculht02date20260213t0000000100duedate20260315t0000000100amount207493id1f108c210dd36c7c8fa025c63136513dstatenewdirectionreceivednumbertestcalculht01date20260213t0000000100duedate20260315t0000000100amount207493id1f107280d2786830b27f7ba00b1d0e24statenewdirectionreceivednumbertestoptipro3date20260127t0000000100duedate20260211t0000000100amount68002', NULL, '1f10d82d-6930-678e-8089-cdc04e567e0f', '2026-02-19 12:05:02', NULL, '1f0affb7-9aba-6bd2-9389-a58a9e3402d9', '1f0f1e95-871d-6d6c-9238-c76791cfa0f7', NULL, '1f0f2b37-d2d8-6a14-970e-1fae92ab525e');

"COMMIT"

"COMMIT";