GET https://app103.fr/app/offer-import/process-preview/93ecaf61-7e4e-4a30-bcf7-2f12c751aab9

Query Metrics

7 Database Queries
7 Different statements
4.75 ms Query time
0 Invalid entities
8 Managed entities

Queries

Group similar statements

# Time Info
1 0.94 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.need_password_update AS need_password_update_4, t0.tryout AS tryout_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.image AS image_10, t0.theme AS theme_11, t0.status AS status_12, t0.last_login AS last_login_13, t0.last_activity AS last_activity_14, t0.note AS note_15, t0.acl AS acl_16, t0.widgets AS widgets_17, t0.preferences AS preferences_18, t0.notification AS notification_19, t0.id AS id_20, t0.uuid AS uuid_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = ?
Parameters:
[
  20
]
2 0.20 ms
"START TRANSACTION"
Parameters:
[]
3 0.52 ms
UPDATE user SET last_activity = ? WHERE id = ?
Parameters:
[
  "2025-07-07 14:16:08"
  20
]
4 0.93 ms
"COMMIT"
Parameters:
[]
5 0.62 ms
SELECT t0.type AS type_1, t0.is_full AS is_full_2, t0.files_datas AS files_datas_3, t0.duration AS duration_4, t0.items AS items_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.entity_id AS entity_id_8 FROM import_prepare t0 WHERE t0.uuid = ? LIMIT 1
Parameters:
[
  "93ecaf61-7e4e-4a30-bcf7-2f12c751aab9"
]
6 0.69 ms
SELECT i0_.logs AS logs_0, i0_.date AS date_1, i0_.is_full AS is_full_2, i0_.type AS type_3, i0_.duration AS duration_4, i0_.items AS items_5, i0_.id AS id_6, i0_.uuid AS uuid_7, i0_.status AS status_8, i0_.items AS items_9, i0_.entity_id AS entity_id_10, i0_.created_by_id AS created_by_id_11 FROM import_logs i0_ WHERE i0_.entity_id = ? AND i0_.is_full = ? ORDER BY i0_.id DESC LIMIT 1
Parameters:
[
  5847
  1
]
7 0.84 ms
SELECT t0.name AS name_1, t0.display_name AS display_name_2, t0.phones AS phones_3, t0.is_seller AS is_seller_4, t0.is_pool AS is_pool_5, t0.oenodata AS oenodata_6, t0.siret_number AS siret_number_7, t0.vat_number AS vat_number_8, t0.accise_number AS accise_number_9, t0.gacc_number AS gacc_number_10, t0.fda_number AS fda_number_11, t0.duns_number AS duns_number_12, t0.owner AS owner_13, t0.is_archived AS is_archived_14, t0.approved AS approved_15, t0.ignore_import AS ignore_import_16, t0.merged_uuids AS merged_uuids_17, t0.provisioning AS provisioning_18, t0.offer_type AS offer_type_19, t0.public_offer AS public_offer_20, t0.emails AS emails_21, t0.offer_disable_comment AS offer_disable_comment_22, t0.default_import_packaging_value AS default_import_packaging_value_23, t0.id AS id_24, t0.uuid AS uuid_25, t0.code AS code_26, t0.status AS status_27, t0.address AS address_28, t0.address2 AS address2_29, t0.postcode AS postcode_30, t0.city AS city_31, t0.url AS url_32, t0.parent_id AS parent_id_33, t0.type_id AS type_id_34, t35.columns AS columns_36, t35.type AS type_37, t35.id AS id_38, t35.uuid AS uuid_39, t35.status AS status_40, t35.entity_id AS entity_id_41, t0.pay_type_id AS pay_type_id_42, t0.default_import_packaging_id AS default_import_packaging_id_43, t0.country_id AS country_id_44 FROM entity t0 LEFT JOIN import_feeds t35 ON t35.entity_id = t0.id WHERE t0.id = ?
Parameters:
[
  5847
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 2
App\Entity\Company 1
App\Entity\Import\ImportPrepare 1
App\Entity\Property\Property 1
App\Entity\Import\ImportLog 1
App\Entity\Property\PropertyType 1
App\Entity\Country 1