GET http://lasalleerp-h.com/api/visit-customers?customerId=642&other=true

Query Metrics

6 Database Queries
6 Different statements
3.46 ms Query time
0 Invalid entities

Queries

Group similar statements

salle2 connection

# Time Info
1 0.97 ms
SELECT * FROM customer c
                             LEFT JOIN product_subscription ps 
                                  ON c.id = ps.customer_id
                                  WHERE c.id =?
Parameters:
[
  "642"
]
2 0.48 ms
SELECT * FROM `order` WHERE customer_id = ? LIMIT 1;
Parameters:
[
  620
]

default connection

# Time Info
1 0.17 ms
"START TRANSACTION"
Parameters:
[]
2 0.41 ms
INSERT INTO visit_outside (fist_name, last_name, photo, phone, identity, create_at, card_reference, manual) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "KHADIJA"
  "KASSOUAD"
  null
  "0672909800"
  "I701094"
  "2025-04-19 20:14:16"
  "274121523845"
  null
]
3 0.83 ms
"COMMIT"
Parameters:
[]
4 0.61 ms
SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "main"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
salle2 doctrine.dbal.salle2_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping