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

Query Metrics

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

Queries

Group similar statements

salle2 connection

# Time Info
1 1.79 ms
SELECT * FROM customer c
                             LEFT JOIN product_subscription ps 
                                  ON c.id = ps.customer_id
                                  WHERE c.id =?
Parameters:
[
  "2015"
]
2 1.47 ms
SELECT * FROM `order` WHERE customer_id = ? LIMIT 1;
Parameters:
[
  1760
]

default connection

# Time Info
1 0.16 ms
"START TRANSACTION"
Parameters:
[]
2 6.36 ms
INSERT INTO visit_outside (fist_name, last_name, photo, phone, identity, create_at, card_reference, manual) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "YOUSSEF"
  "EL HOUDAIGUI"
  "WhatsApp Image 2023-12-06 at 20.28.15 (2).jpg"
  "0766308761"
  "BJ436306"
  "2025-06-07 06:36:34"
  "701282122931"
  null
]
3 1.85 ms
"COMMIT"
Parameters:
[]
4 0.87 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