GET https://app103.fr/app/property/show/3ad210ed-51d5-4f7e-858a-8f8ff1a27725

Query Metrics

27 Database Queries
16 Different statements
16.21 ms Query time
0 Invalid entities
319 Managed entities

Queries

Group similar statements

# Time Info
1 0.63 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:
[
  4
]
2 0.17 ms
"START TRANSACTION"
Parameters:
[]
3 0.40 ms
UPDATE user SET last_activity = ? WHERE id = ?
Parameters:
[
  "2025-07-07 08:02:31"
  4
]
4 0.14 ms
"COMMIT"
Parameters:
[]
5 1.44 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.uuid = ? LIMIT 1
Parameters:
[
  "3ad210ed-51d5-4f7e-858a-8f8ff1a27725"
]
6 0.57 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.name AS name_5, t0.status AS status_6 FROM entity_type t0 WHERE t0.id = ?
Parameters:
[
  2
]
7 0.64 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:
[
  225
]
8 0.47 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
]
9 0.63 ms
SELECT t0.accise_number AS accise_number_1, t0.phones AS phones_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.old_id AS old_id_5, t0.name AS name_6, t0.email AS email_7, t0.address AS address_8, t0.address2 AS address2_9, t0.postcode AS postcode_10, t0.city AS city_11, t0.status AS status_12, t0.note AS note_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.country_id AS country_id_16 FROM warehouse t0 INNER JOIN entity_warehouse ON t0.id = entity_warehouse.warehouse_id WHERE entity_warehouse.property_id = ?
Parameters:
[
  2849
]
10 0.80 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.parent_id = ? AND t0.status = ?
Parameters:
[
  225
  1
]
11 0.52 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.status AS status_4, t0.entity_id AS entity_id_5 FROM producer t0 WHERE t0.entity_id = ?
Parameters:
[
  2202
]
12 0.31 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.status AS status_4, t0.entity_id AS entity_id_5 FROM producer t0 WHERE t0.entity_id = ?
Parameters:
[
  2849
]
13 0.32 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.status AS status_4, t0.entity_id AS entity_id_5 FROM producer t0 WHERE t0.entity_id = ?
Parameters:
[
  3268
]
14 0.57 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.status AS status_4, t0.entity_id AS entity_id_5 FROM producer t0 WHERE t0.entity_id = ?
Parameters:
[
  3367
]
15 0.36 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.status AS status_4, t0.entity_id AS entity_id_5 FROM producer t0 WHERE t0.entity_id = ?
Parameters:
[
  4616
]
16 1.05 ms
SELECT t0.price AS price_1, t0.category AS category_2, t0.last_update AS last_update_3, t0.qty AS qty_4, t0.vintage AS vintage_5, t0.unoficial_price AS unoficial_price_6, t0.unoficial_qty AS unoficial_qty_7, t0.unoficial_update AS unoficial_update_8, t0.slug AS slug_9, t0.packaging_value AS packaging_value_10, t0.packaging_flat AS packaging_flat_11, t0.format_filled AS format_filled_12, t0.type AS type_13, t0.is_flat AS is_flat_14, t0.comment AS comment_15, t0.private_note AS private_note_16, t0.edited_note AS edited_note_17, t0.created_by_name AS created_by_name_18, t0.edited_by AS edited_by_19, t0.control AS control_20, t0.id AS id_21, t0.uuid AS uuid_22, t0.status AS status_23, t0.product_id AS product_id_24, t0.entity_id AS entity_id_25, t0.format_id AS format_id_26, t0.packaging_id AS packaging_id_27, t0.import_process_id AS import_process_id_28, t0.created_by_id AS created_by_id_29 FROM offer t0 WHERE t0.entity_id = ?
Parameters:
[
  2849
]
17 0.79 ms
SELECT t0.code AS code_1, t0.display_name AS display_name_2, t0.lwin AS lwin_3, t0.site AS site_4, t0.seller_price_qty AS seller_price_qty_5, t0.price AS price_6, t0.merged_uuids AS merged_uuids_7, t0.has_lwin_suggests AS has_lwin_suggests_8, t0.from_import AS from_import_9, t0.bundle AS bundle_10, t0.id AS id_11, t0.uuid AS uuid_12, t0.name AS name_13, t0.status AS status_14, t0.country_id AS country_id_15, t0.region_id AS region_id_16, t0.sub_region_id AS sub_region_id_17, t0.color_id AS color_id_18, t0.type_id AS type_id_19, t0.sub_type_id AS sub_type_id_20, t0.entity_id AS entity_id_21, t0.classification_id AS classification_id_22, t0.line_id AS line_id_23, t0.producer_id AS producer_id_24 FROM product t0 WHERE t0.entity_id = ?
Parameters:
[
  2849
]
18 0.98 ms
SELECT t0.price AS price_1, t0.category AS category_2, t0.last_update AS last_update_3, t0.qty AS qty_4, t0.vintage AS vintage_5, t0.unoficial_price AS unoficial_price_6, t0.unoficial_qty AS unoficial_qty_7, t0.unoficial_update AS unoficial_update_8, t0.slug AS slug_9, t0.packaging_value AS packaging_value_10, t0.packaging_flat AS packaging_flat_11, t0.format_filled AS format_filled_12, t0.type AS type_13, t0.is_flat AS is_flat_14, t0.comment AS comment_15, t0.private_note AS private_note_16, t0.edited_note AS edited_note_17, t0.created_by_name AS created_by_name_18, t0.edited_by AS edited_by_19, t0.control AS control_20, t0.id AS id_21, t0.uuid AS uuid_22, t0.status AS status_23, t0.product_id AS product_id_24, t0.entity_id AS entity_id_25, t0.format_id AS format_id_26, t0.packaging_id AS packaging_id_27, t0.import_process_id AS import_process_id_28, t0.created_by_id AS created_by_id_29 FROM offer t0 WHERE t0.product_id = ?
Parameters:
[
  124
]
19 2.53 ms
SELECT t0.price AS price_1, t0.category AS category_2, t0.last_update AS last_update_3, t0.qty AS qty_4, t0.vintage AS vintage_5, t0.unoficial_price AS unoficial_price_6, t0.unoficial_qty AS unoficial_qty_7, t0.unoficial_update AS unoficial_update_8, t0.slug AS slug_9, t0.packaging_value AS packaging_value_10, t0.packaging_flat AS packaging_flat_11, t0.format_filled AS format_filled_12, t0.type AS type_13, t0.is_flat AS is_flat_14, t0.comment AS comment_15, t0.private_note AS private_note_16, t0.edited_note AS edited_note_17, t0.created_by_name AS created_by_name_18, t0.edited_by AS edited_by_19, t0.control AS control_20, t0.id AS id_21, t0.uuid AS uuid_22, t0.status AS status_23, t0.product_id AS product_id_24, t0.entity_id AS entity_id_25, t0.format_id AS format_id_26, t0.packaging_id AS packaging_id_27, t0.import_process_id AS import_process_id_28, t0.created_by_id AS created_by_id_29 FROM offer t0 WHERE t0.product_id = ?
Parameters:
[
  148
]
20 0.57 ms
SELECT t0.email AS email_1, t0.phone AS phone_2, t0.mobile AS mobile_3, t0.job_function AS job_function_4, t0.status AS status_5, t0.assigned_at AS assigned_at_6, t0.unassigned_at AS unassigned_at_7, t0.updated_at AS updated_at_8, t0.ms_id AS ms_id_9, t0.other_emails AS other_emails_10, t0.id AS id_11, t0.uuid AS uuid_12, t0.note AS note_13, t0.contact_id AS contact_id_14, t0.property_id AS property_id_15 FROM contact_property t0 WHERE t0.property_id = ? ORDER BY t0.status ASC
Parameters:
[
  2849
]
21 0.46 ms
SELECT t0.email AS email_1, t0.status AS status_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.civ AS civ_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7 FROM contact t0 WHERE t0.id = ?
Parameters:
[
  3094
]
22 0.27 ms
SELECT t0.email AS email_1, t0.status AS status_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.civ AS civ_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7 FROM contact t0 WHERE t0.id = ?
Parameters:
[
  3095
]
23 0.23 ms
SELECT t0.email AS email_1, t0.status AS status_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.civ AS civ_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7 FROM contact t0 WHERE t0.id = ?
Parameters:
[
  3096
]
24 0.41 ms
SELECT t0.email AS email_1, t0.status AS status_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.civ AS civ_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7 FROM contact t0 WHERE t0.id = ?
Parameters:
[
  2440
]
25 0.28 ms
SELECT t0.email AS email_1, t0.status AS status_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.civ AS civ_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7 FROM contact t0 WHERE t0.id = ?
Parameters:
[
  3097
]
26 0.37 ms
SELECT t0.email AS email_1, t0.status AS status_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.civ AS civ_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7 FROM contact t0 WHERE t0.id = ?
Parameters:
[
  3098
]
27 0.29 ms
SELECT t0.email AS email_1, t0.status AS status_2, t0.id AS id_3, t0.uuid AS uuid_4, t0.civ AS civ_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7 FROM contact t0 WHERE t0.id = ?
Parameters:
[
  2442
]

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\Offer 211
App\Entity\Property\Property 34
App\Entity\Import\ImportProcess 28
App\Entity\Product\Format 9
App\Entity\Property\Producer 8
App\Entity\Contact\ContactProperty 7
App\Entity\Contact\Contact 7
App\Entity\Property\PropertyType 3
App\Entity\Product\Packaging 3
App\Entity\Product\Product 2
App\Entity\User 1
App\Entity\Company 1
App\Entity\Country 1
App\Entity\Region 1
App\Entity\Product\Color 1
App\Entity\Product\Type 1
App\Entity\Product\Classification 1