Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.name AS name_3,
  t0.state AS state_4,
  t0.ticket_state AS ticket_state_5,
  t0.user_email AS user_email_6,
  t0.user_lastname AS user_lastname_7,
  t0.user_firstname AS user_firstname_8,
  t0.user_fullname AS user_fullname_9,
  t0.ticket_user_email AS ticket_user_email_10,
  t0.ticket_user_lastname AS ticket_user_lastname_11,
  t0.ticket_user_firstname AS ticket_user_firstname_12,
  t0.ticket_note_id AS ticket_note_id_13,
  t0.ticket_id AS ticket_id_14,
  t0.link AS link_15,
  t0.address_delivery_type AS address_delivery_type_16,
  t0.address_delivery_truck_access AS address_delivery_truck_access_17,
  t0.address_delivery_contact AS address_delivery_contact_18,
  t0.address_delivery_main AS address_delivery_main_19,
  t0.address_delivery_complementary AS address_delivery_complementary_20,
  t0.address_delivery_city AS address_delivery_city_21,
  t0.address_delivery_zipcode AS address_delivery_zipcode_22,
  t0.address_delivery_country AS address_delivery_country_23,
  t0.address_invoicing_main AS address_invoicing_main_24,
  t0.address_invoicing_complementary AS address_invoicing_complementary_25,
  t0.address_invoicing_city AS address_invoicing_city_26,
  t0.address_invoicing_zipcode AS address_invoicing_zipcode_27,
  t0.address_invoicing_country AS address_invoicing_country_28,
  t0.company_name AS company_name_29,
  t0.company_siret AS company_siret_30,
  t0.company_vat_number AS company_vat_number_31,
  t0.contact_email AS contact_email_32,
  t0.contact_lastname AS contact_lastname_33,
  t0.contact_firstname AS contact_firstname_34,
  t0.contact_invoicing AS contact_invoicing_35,
  t0.archived AS archived_36,
  t0.deposit_needed AS deposit_needed_37,
  t0.closing_date AS closing_date_38,
  t0.created_at AS created_at_39,
  t0.updated_at AS updated_at_40,
  t0.deleted_at AS deleted_at_41
FROM
  transaction_hubspot t0
WHERE
  t0.external_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.state AS state_4, t0.ticket_state AS ticket_state_5, t0.user_email AS user_email_6, t0.user_lastname AS user_lastname_7, t0.user_firstname AS user_firstname_8, t0.user_fullname AS user_fullname_9, t0.ticket_user_email AS ticket_user_email_10, t0.ticket_user_lastname AS ticket_user_lastname_11, t0.ticket_user_firstname AS ticket_user_firstname_12, t0.ticket_note_id AS ticket_note_id_13, t0.ticket_id AS ticket_id_14, t0.link AS link_15, t0.address_delivery_type AS address_delivery_type_16, t0.address_delivery_truck_access AS address_delivery_truck_access_17, t0.address_delivery_contact AS address_delivery_contact_18, t0.address_delivery_main AS address_delivery_main_19, t0.address_delivery_complementary AS address_delivery_complementary_20, t0.address_delivery_city AS address_delivery_city_21, t0.address_delivery_zipcode AS address_delivery_zipcode_22, t0.address_delivery_country AS address_delivery_country_23, t0.address_invoicing_main AS address_invoicing_main_24, t0.address_invoicing_complementary AS address_invoicing_complementary_25, t0.address_invoicing_city AS address_invoicing_city_26, t0.address_invoicing_zipcode AS address_invoicing_zipcode_27, t0.address_invoicing_country AS address_invoicing_country_28, t0.company_name AS company_name_29, t0.company_siret AS company_siret_30, t0.company_vat_number AS company_vat_number_31, t0.contact_email AS contact_email_32, t0.contact_lastname AS contact_lastname_33, t0.contact_firstname AS contact_firstname_34, t0.contact_invoicing AS contact_invoicing_35, t0.archived AS archived_36, t0.deposit_needed AS deposit_needed_37, t0.closing_date AS closing_date_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.deleted_at AS deleted_at_41 FROM transaction_hubspot t0 WHERE t0.external_id = 416688440522 AND ((t0.deleted_at IS NULL)) LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO transaction_hubspot (
  external_id, name, state, ticket_state,
  user_email, user_lastname, user_firstname,
  ticket_user_email, ticket_user_lastname,
  ticket_user_firstname, ticket_note_id,
  ticket_id, link, address_delivery_type,
  address_delivery_truck_access,
  address_delivery_contact, address_delivery_main,
  address_delivery_complementary,
  address_delivery_city, address_delivery_zipcode,
  address_delivery_country, address_invoicing_main,
  address_invoicing_complementary,
  address_invoicing_city, address_invoicing_zipcode,
  address_invoicing_country, company_name,
  company_siret, company_vat_number,
  contact_email, contact_lastname,
  contact_firstname, contact_invoicing,
  archived, deposit_needed, closing_date,
  created_at, updated_at, deleted_at
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO transaction_hubspot (external_id, name, state, ticket_state, user_email, user_lastname, user_firstname, ticket_user_email, ticket_user_lastname, ticket_user_firstname, ticket_note_id, ticket_id, link, address_delivery_type, address_delivery_truck_access, address_delivery_contact, address_delivery_main, address_delivery_complementary, address_delivery_city, address_delivery_zipcode, address_delivery_country, address_invoicing_main, address_invoicing_complementary, address_invoicing_city, address_invoicing_zipcode, address_invoicing_country, company_name, company_siret, company_vat_number, contact_email, contact_lastname, contact_firstname, contact_invoicing, archived, deposit_needed, closing_date, created_at, updated_at, deleted_at) VALUES ('416688440522', 'France Travail (34) catalogue 24122025', 'Lead qualifié', NULL, 'amandine.lopez@scop3.com', 'LOPEZ', 'Amandine', NULL, NULL, NULL, NULL, NULL, 'https://app-eu1.hubspot.com/contacts/25701427/record/0-3/416688440522', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '13000548116990', NULL, 'johanna.murgia-ext@francetravail.fr', 'MURGIA', 'Johanna', NULL, 0, 1, '2026-06-26 12:47:05', '2025-12-24 13:47:08', '2025-12-24 14:47:10', NULL);

"ROLLBACK"

"ROLLBACK";

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.name AS name_3,
  t0.state AS state_4,
  t0.ticket_state AS ticket_state_5,
  t0.user_email AS user_email_6,
  t0.user_lastname AS user_lastname_7,
  t0.user_firstname AS user_firstname_8,
  t0.user_fullname AS user_fullname_9,
  t0.ticket_user_email AS ticket_user_email_10,
  t0.ticket_user_lastname AS ticket_user_lastname_11,
  t0.ticket_user_firstname AS ticket_user_firstname_12,
  t0.ticket_note_id AS ticket_note_id_13,
  t0.ticket_id AS ticket_id_14,
  t0.link AS link_15,
  t0.address_delivery_type AS address_delivery_type_16,
  t0.address_delivery_truck_access AS address_delivery_truck_access_17,
  t0.address_delivery_contact AS address_delivery_contact_18,
  t0.address_delivery_main AS address_delivery_main_19,
  t0.address_delivery_complementary AS address_delivery_complementary_20,
  t0.address_delivery_city AS address_delivery_city_21,
  t0.address_delivery_zipcode AS address_delivery_zipcode_22,
  t0.address_delivery_country AS address_delivery_country_23,
  t0.address_invoicing_main AS address_invoicing_main_24,
  t0.address_invoicing_complementary AS address_invoicing_complementary_25,
  t0.address_invoicing_city AS address_invoicing_city_26,
  t0.address_invoicing_zipcode AS address_invoicing_zipcode_27,
  t0.address_invoicing_country AS address_invoicing_country_28,
  t0.company_name AS company_name_29,
  t0.company_siret AS company_siret_30,
  t0.company_vat_number AS company_vat_number_31,
  t0.contact_email AS contact_email_32,
  t0.contact_lastname AS contact_lastname_33,
  t0.contact_firstname AS contact_firstname_34,
  t0.contact_invoicing AS contact_invoicing_35,
  t0.archived AS archived_36,
  t0.deposit_needed AS deposit_needed_37,
  t0.closing_date AS closing_date_38,
  t0.created_at AS created_at_39,
  t0.updated_at AS updated_at_40,
  t0.deleted_at AS deleted_at_41
FROM
  transaction_hubspot t0
WHERE
  t0.external_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.state AS state_4, t0.ticket_state AS ticket_state_5, t0.user_email AS user_email_6, t0.user_lastname AS user_lastname_7, t0.user_firstname AS user_firstname_8, t0.user_fullname AS user_fullname_9, t0.ticket_user_email AS ticket_user_email_10, t0.ticket_user_lastname AS ticket_user_lastname_11, t0.ticket_user_firstname AS ticket_user_firstname_12, t0.ticket_note_id AS ticket_note_id_13, t0.ticket_id AS ticket_id_14, t0.link AS link_15, t0.address_delivery_type AS address_delivery_type_16, t0.address_delivery_truck_access AS address_delivery_truck_access_17, t0.address_delivery_contact AS address_delivery_contact_18, t0.address_delivery_main AS address_delivery_main_19, t0.address_delivery_complementary AS address_delivery_complementary_20, t0.address_delivery_city AS address_delivery_city_21, t0.address_delivery_zipcode AS address_delivery_zipcode_22, t0.address_delivery_country AS address_delivery_country_23, t0.address_invoicing_main AS address_invoicing_main_24, t0.address_invoicing_complementary AS address_invoicing_complementary_25, t0.address_invoicing_city AS address_invoicing_city_26, t0.address_invoicing_zipcode AS address_invoicing_zipcode_27, t0.address_invoicing_country AS address_invoicing_country_28, t0.company_name AS company_name_29, t0.company_siret AS company_siret_30, t0.company_vat_number AS company_vat_number_31, t0.contact_email AS contact_email_32, t0.contact_lastname AS contact_lastname_33, t0.contact_firstname AS contact_firstname_34, t0.contact_invoicing AS contact_invoicing_35, t0.archived AS archived_36, t0.deposit_needed AS deposit_needed_37, t0.closing_date AS closing_date_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.deleted_at AS deleted_at_41 FROM transaction_hubspot t0 WHERE t0.external_id = 416688440522 AND ((t0.deleted_at IS NULL)) LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  transaction_hubspot
SET
  closing_date = ?,
  created_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE transaction_hubspot SET closing_date = '2026-06-26 12:47:05', created_at = '2025-12-24 13:47:08', updated_at = '2025-12-24 14:47:11' WHERE id = 4101;

SELECT
  user_fullname
FROM
  transaction_hubspot
WHERE
  id = ?

SELECT user_fullname FROM transaction_hubspot WHERE id = 4101;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.pennylane_quote_id AS pennylane_quote_id_2,
  t0.pennylane_quote_number AS pennylane_quote_number_3,
  t0.pennylane_analytic_code AS pennylane_analytic_code_4,
  t0.pennylane_category_id AS pennylane_category_id_5,
  t0.cost_products_ht_min AS cost_products_ht_min_6,
  t0.cost_products_ht_max AS cost_products_ht_max_7,
  t0.margin_products_ht_min AS margin_products_ht_min_8,
  t0.margin_products_ht_max AS margin_products_ht_max_9,
  t0.margin_products_percentage AS margin_products_percentage_10,
  t0.price_products_ht_min AS price_products_ht_min_11,
  t0.price_products_ht_max AS price_products_ht_max_12,
  t0.cost_services_ht_min AS cost_services_ht_min_13,
  t0.cost_services_ht_max AS cost_services_ht_max_14,
  t0.margin_services_ht_min AS margin_services_ht_min_15,
  t0.margin_services_ht_max AS margin_services_ht_max_16,
  t0.margin_services_percentage AS margin_services_percentage_17,
  t0.price_services_ht_min AS price_services_ht_min_18,
  t0.price_services_ht_max AS price_services_ht_max_19,
  t0.cost_ht_min AS cost_ht_min_20,
  t0.cost_ht_max AS cost_ht_max_21,
  t0.margin_ht_min AS margin_ht_min_22,
  t0.margin_ht_max AS margin_ht_max_23,
  t0.margin_percentage AS margin_percentage_24,
  t0.price_ht_min AS price_ht_min_25,
  t0.price_ht_max AS price_ht_max_26,
  t0.kg_co2eq_min AS kg_co2eq_min_27,
  t0.kg_co2eq_max AS kg_co2eq_max_28,
  t0.kg_trash_min AS kg_trash_min_29,
  t0.kg_trash_max AS kg_trash_max_30,
  t0.last_activity_at AS last_activity_at_31,
  t0.created_at AS created_at_32,
  t0.updated_at AS updated_at_33,
  t0.deleted_at AS deleted_at_34,
  t0.id_transaction_hubspot AS id_transaction_hubspot_35,
  t0.created_by AS created_by_36,
  t0.updated_by AS updated_by_37,
  t0.deleted_by AS deleted_by_38
FROM
  proposal t0
WHERE
  t0.id_transaction_hubspot = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.pennylane_quote_id AS pennylane_quote_id_2, t0.pennylane_quote_number AS pennylane_quote_number_3, t0.pennylane_analytic_code AS pennylane_analytic_code_4, t0.pennylane_category_id AS pennylane_category_id_5, t0.cost_products_ht_min AS cost_products_ht_min_6, t0.cost_products_ht_max AS cost_products_ht_max_7, t0.margin_products_ht_min AS margin_products_ht_min_8, t0.margin_products_ht_max AS margin_products_ht_max_9, t0.margin_products_percentage AS margin_products_percentage_10, t0.price_products_ht_min AS price_products_ht_min_11, t0.price_products_ht_max AS price_products_ht_max_12, t0.cost_services_ht_min AS cost_services_ht_min_13, t0.cost_services_ht_max AS cost_services_ht_max_14, t0.margin_services_ht_min AS margin_services_ht_min_15, t0.margin_services_ht_max AS margin_services_ht_max_16, t0.margin_services_percentage AS margin_services_percentage_17, t0.price_services_ht_min AS price_services_ht_min_18, t0.price_services_ht_max AS price_services_ht_max_19, t0.cost_ht_min AS cost_ht_min_20, t0.cost_ht_max AS cost_ht_max_21, t0.margin_ht_min AS margin_ht_min_22, t0.margin_ht_max AS margin_ht_max_23, t0.margin_percentage AS margin_percentage_24, t0.price_ht_min AS price_ht_min_25, t0.price_ht_max AS price_ht_max_26, t0.kg_co2eq_min AS kg_co2eq_min_27, t0.kg_co2eq_max AS kg_co2eq_max_28, t0.kg_trash_min AS kg_trash_min_29, t0.kg_trash_max AS kg_trash_max_30, t0.last_activity_at AS last_activity_at_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.deleted_at AS deleted_at_34, t0.id_transaction_hubspot AS id_transaction_hubspot_35, t0.created_by AS created_by_36, t0.updated_by AS updated_by_37, t0.deleted_by AS deleted_by_38 FROM proposal t0 WHERE t0.id_transaction_hubspot = 4101 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.name AS name_3,
  t0.state AS state_4,
  t0.ticket_state AS ticket_state_5,
  t0.user_email AS user_email_6,
  t0.user_lastname AS user_lastname_7,
  t0.user_firstname AS user_firstname_8,
  t0.user_fullname AS user_fullname_9,
  t0.ticket_user_email AS ticket_user_email_10,
  t0.ticket_user_lastname AS ticket_user_lastname_11,
  t0.ticket_user_firstname AS ticket_user_firstname_12,
  t0.ticket_note_id AS ticket_note_id_13,
  t0.ticket_id AS ticket_id_14,
  t0.link AS link_15,
  t0.address_delivery_type AS address_delivery_type_16,
  t0.address_delivery_truck_access AS address_delivery_truck_access_17,
  t0.address_delivery_contact AS address_delivery_contact_18,
  t0.address_delivery_main AS address_delivery_main_19,
  t0.address_delivery_complementary AS address_delivery_complementary_20,
  t0.address_delivery_city AS address_delivery_city_21,
  t0.address_delivery_zipcode AS address_delivery_zipcode_22,
  t0.address_delivery_country AS address_delivery_country_23,
  t0.address_invoicing_main AS address_invoicing_main_24,
  t0.address_invoicing_complementary AS address_invoicing_complementary_25,
  t0.address_invoicing_city AS address_invoicing_city_26,
  t0.address_invoicing_zipcode AS address_invoicing_zipcode_27,
  t0.address_invoicing_country AS address_invoicing_country_28,
  t0.company_name AS company_name_29,
  t0.company_siret AS company_siret_30,
  t0.company_vat_number AS company_vat_number_31,
  t0.contact_email AS contact_email_32,
  t0.contact_lastname AS contact_lastname_33,
  t0.contact_firstname AS contact_firstname_34,
  t0.contact_invoicing AS contact_invoicing_35,
  t0.archived AS archived_36,
  t0.deposit_needed AS deposit_needed_37,
  t0.closing_date AS closing_date_38,
  t0.created_at AS created_at_39,
  t0.updated_at AS updated_at_40,
  t0.deleted_at AS deleted_at_41
FROM
  transaction_hubspot t0
WHERE
  t0.external_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.state AS state_4, t0.ticket_state AS ticket_state_5, t0.user_email AS user_email_6, t0.user_lastname AS user_lastname_7, t0.user_firstname AS user_firstname_8, t0.user_fullname AS user_fullname_9, t0.ticket_user_email AS ticket_user_email_10, t0.ticket_user_lastname AS ticket_user_lastname_11, t0.ticket_user_firstname AS ticket_user_firstname_12, t0.ticket_note_id AS ticket_note_id_13, t0.ticket_id AS ticket_id_14, t0.link AS link_15, t0.address_delivery_type AS address_delivery_type_16, t0.address_delivery_truck_access AS address_delivery_truck_access_17, t0.address_delivery_contact AS address_delivery_contact_18, t0.address_delivery_main AS address_delivery_main_19, t0.address_delivery_complementary AS address_delivery_complementary_20, t0.address_delivery_city AS address_delivery_city_21, t0.address_delivery_zipcode AS address_delivery_zipcode_22, t0.address_delivery_country AS address_delivery_country_23, t0.address_invoicing_main AS address_invoicing_main_24, t0.address_invoicing_complementary AS address_invoicing_complementary_25, t0.address_invoicing_city AS address_invoicing_city_26, t0.address_invoicing_zipcode AS address_invoicing_zipcode_27, t0.address_invoicing_country AS address_invoicing_country_28, t0.company_name AS company_name_29, t0.company_siret AS company_siret_30, t0.company_vat_number AS company_vat_number_31, t0.contact_email AS contact_email_32, t0.contact_lastname AS contact_lastname_33, t0.contact_firstname AS contact_firstname_34, t0.contact_invoicing AS contact_invoicing_35, t0.archived AS archived_36, t0.deposit_needed AS deposit_needed_37, t0.closing_date AS closing_date_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.deleted_at AS deleted_at_41 FROM transaction_hubspot t0 WHERE t0.external_id = 416688440522 AND ((t0.deleted_at IS NULL)) LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  transaction_hubspot
SET
  closing_date = ?,
  created_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE transaction_hubspot SET closing_date = '2026-06-26 12:47:05', created_at = '2025-12-24 13:47:08', updated_at = '2025-12-24 14:47:12' WHERE id = 4101;

SELECT
  user_fullname
FROM
  transaction_hubspot
WHERE
  id = ?

SELECT user_fullname FROM transaction_hubspot WHERE id = 4101;

"COMMIT"

"COMMIT";