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

Query Metrics

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

Grouped Statements

Show all queries

salle2 connection

Time Count Info
1.10 ms
(23.07%)
1
SELECT * FROM customer c
                             LEFT JOIN product_subscription ps 
                                  ON c.id = ps.customer_id
                                  WHERE c.id =?
Parameters:
[
  "4169"
]
0.85 ms
(17.85%)
1
SELECT * FROM `order` WHERE customer_id = ? LIMIT 1;
Parameters:
[
  3771
]

default connection

Time Count Info
1.25 ms
(26.14%)
1
"COMMIT"
Parameters:
[]
0.94 ms
(19.67%)
1
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"
]
0.44 ms
(9.31%)
1
INSERT INTO visit_outside (fist_name, last_name, photo, phone, identity, create_at, card_reference, manual) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "SOUHAILI"
  "KALTOUM"
  "WhatsApp Image 2024-10-17 at 09.25.58.jpg"
  "0661410926"
  "BJ394369"
  "2025-09-09 03:50:59"
  "693496587629"
  null
]
0.19 ms
(3.95%)
1
"START TRANSACTION"
Parameters:
[]

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