GET https://app103.fr/app/offer-import/import

Query Metrics

19 Database Queries
11 Different statements
8.55 ms Query time
0 Invalid entities
878 Managed entities

Queries

Group similar statements

# Time Info
1 0.88 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.18 ms
"START TRANSACTION"
Parameters:
[]
3 0.46 ms
UPDATE user SET last_activity = ? WHERE id = ?
Parameters:
[
  "2025-07-07 09:15:06"
  20
]
4 0.91 ms
"COMMIT"
Parameters:
[]
5 0.39 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 IS NULL LIMIT 1
Parameters:
[]
6 0.61 ms
SELECT t0.image AS image_1, t0.siret_number AS siret_number_2, t0.vat_number AS vat_number_3, t0.model_letter AS model_letter_4, t0.is_default AS is_default_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.code AS code_8, t0.name AS name_9, t0.address AS address_10, t0.address2 AS address2_11, t0.postcode AS postcode_12, t0.city AS city_13, t0.phone AS phone_14, t0.status AS status_15, t0.country_id AS country_id_16 FROM company t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.57 ms
SELECT t0.volume AS volume_1, t0.is_default AS is_default_2, t0.offer_sort AS offer_sort_3, t0.id AS id_4, t0.uuid AS uuid_5, t0.code AS code_6, t0.name AS name_7, t0.name_en AS name_en_8, t0.status AS status_9, t0.regex AS regex_10 FROM product_format t0
Parameters:
[]
8 0.24 ms
SELECT t0.is_default AS is_default_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.position AS position_4, t0.old_id AS old_id_5, t0.name AS name_6, t0.name_en AS name_en_7, t0.code AS code_8, t0.status AS status_9 FROM product_color t0
Parameters:
[]
9 0.29 ms
SELECT t0.qty AS qty_1, t0.is_default AS is_default_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.code AS code_5, t0.name AS name_6, t0.name_en AS name_en_7, t0.position AS position_8, t0.status AS status_9, t0.regex AS regex_10 FROM product_packaging t0
Parameters:
[]
10 0.28 ms
SELECT t0.volume AS volume_1, t0.is_default AS is_default_2, t0.offer_sort AS offer_sort_3, t0.id AS id_4, t0.uuid AS uuid_5, t0.code AS code_6, t0.name AS name_7, t0.name_en AS name_en_8, t0.status AS status_9, t0.regex AS regex_10 FROM product_format t0
Parameters:
[]
11 0.24 ms
SELECT t0.volume AS volume_1, t0.is_default AS is_default_2, t0.offer_sort AS offer_sort_3, t0.id AS id_4, t0.uuid AS uuid_5, t0.code AS code_6, t0.name AS name_7, t0.name_en AS name_en_8, t0.status AS status_9, t0.regex AS regex_10 FROM product_format t0
Parameters:
[]
12 0.25 ms
SELECT t0.volume AS volume_1, t0.is_default AS is_default_2, t0.offer_sort AS offer_sort_3, t0.id AS id_4, t0.uuid AS uuid_5, t0.code AS code_6, t0.name AS name_7, t0.name_en AS name_en_8, t0.status AS status_9, t0.regex AS regex_10 FROM product_format t0
Parameters:
[]
13 0.25 ms
SELECT t0.volume AS volume_1, t0.is_default AS is_default_2, t0.offer_sort AS offer_sort_3, t0.id AS id_4, t0.uuid AS uuid_5, t0.code AS code_6, t0.name AS name_7, t0.name_en AS name_en_8, t0.status AS status_9, t0.regex AS regex_10 FROM product_format t0
Parameters:
[]
14 0.24 ms
SELECT t0.volume AS volume_1, t0.is_default AS is_default_2, t0.offer_sort AS offer_sort_3, t0.id AS id_4, t0.uuid AS uuid_5, t0.code AS code_6, t0.name AS name_7, t0.name_en AS name_en_8, t0.status AS status_9, t0.regex AS regex_10 FROM product_format t0
Parameters:
[]
15 0.35 ms
SELECT t0.volume AS volume_1, t0.is_default AS is_default_2, t0.offer_sort AS offer_sort_3, t0.id AS id_4, t0.uuid AS uuid_5, t0.code AS code_6, t0.name AS name_7, t0.name_en AS name_en_8, t0.status AS status_9, t0.regex AS regex_10 FROM product_format t0
Parameters:
[]
16 0.24 ms
SELECT t0.qty AS qty_1, t0.is_default AS is_default_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.code AS code_5, t0.name AS name_6, t0.name_en AS name_en_7, t0.position AS position_8, t0.status AS status_9, t0.regex AS regex_10 FROM product_packaging t0
Parameters:
[]
17 0.21 ms
SELECT t0.is_default AS is_default_1, t0.id AS id_2, t0.uuid AS uuid_3, t0.position AS position_4, t0.old_id AS old_id_5, t0.name AS name_6, t0.name_en AS name_en_7, t0.code AS code_8, t0.status AS status_9 FROM product_color t0
Parameters:
[]
18 0.99 ms
SELECT t0.value AS value_1, t0.last_update AS last_update_2, t0.id AS id_3, t0.code AS code_4 FROM currency t0
Parameters:
[]
19 0.96 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.status AS status_4 FROM product_appellation t0
Parameters:
[]

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\Product\Appellation 486
App\Entity\Currency 341
App\Entity\Product\Format 27
App\Entity\Product\Packaging 15
App\Entity\Product\Color 6
App\Entity\User 1
App\Entity\Company 1
App\Entity\Country 1