POST https://store.juste-elles.com/admin/click-and-collect/ajax/expedition

Query Metrics

60 Database Queries
9 Different statements
261.89 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
202.73 ms
(77.41%)
5
SELECT t0.id AS id_1, t0.id_warehouse AS id_warehouse_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.phone AS phone_5, t0.date_order AS date_order_6, t0.payment AS payment_7, t0.date_add AS date_add_8, t0.sms1_send AS sms1_send_9, t0.sms2_send AS sms2_send_10, t0.paid AS paid_11, t0.id_order AS id_order_12, t0.email AS email_13, t0.date_delivered AS date_delivered_14, t0.total AS total_15, t0.date_send AS date_send_16, t0.date_recep AS date_recep_17, t0.qty_product AS qty_product_18, t0.cancel AS cancel_19, t0.date_cancel AS date_cancel_20, t0.id_package_shipping_bo AS id_package_shipping_bo_21, t0.comment AS comment_22 FROM c_and_c_order_history t0 WHERE t0.id_order = ? LIMIT 1
Parameters:
[
  283334
]
31.40 ms
(11.99%)
11
"COMMIT"
Parameters:
[]
7.81 ms
(2.98%)
14
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4, t0.description AS description_5 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "SHIPPINGBO_ACCESS_TOKEN"
]
4.50 ms
(1.72%)
11
"START TRANSACTION"
Parameters:
[]
4.31 ms
(1.65%)
5
SELECT id_order, id_order_magento FROM mapping_orders_presta_magento WHERE id_order_magento = :id
Parameters:
[
  "id" => 204051494
]
4.26 ms
(1.63%)
5
INSERT INTO history_action (date_add, action, user_id) VALUES (?, ?, ?)
Parameters:
[
  "2026-02-17 10:55:27"
  "Expédition click&collect[204051494][ID: 204051494]"
  10
]
3.93 ms
(1.50%)
5
INSERT INTO c_and_c_order_history (id_warehouse, firstname, lastname, phone, date_order, payment, date_add, sms1_send, sms2_send, paid, id_order, email, date_delivered, total, date_send, date_recep, qty_product, cancel, date_cancel, id_package_shipping_bo, comment) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  4
  "angelique"
  "faelens"
  "+33612527303"
  "2026-02-13 13:48:10"
  "A PAYER EN MAGASIN"
  "2026-02-17 10:55:28"
  0
  0
  0
  "283334"
  "juste.elles.neuville@gmail.com"
  null
  39.99
  "2026-02-17 10:55:28"
  null
  1
  null
  null
  "204051494"
  null
]
2.01 ms
(0.77%)
3
UPDATE configuration SET value = ? WHERE id = ?
Parameters:
[
  "FREm5D4CBY_I7OWPAKadgUAkfAyfOHWphRNR70ZwHsk"
  6
]
0.93 ms
(0.36%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.active AS active_8 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  10
]

Database Connections

Name Service
default doctrine.dbal.default_connection
dashboard doctrine.dbal.dashboard_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\HistoryAction No errors.
App\Entity\Gifts No errors.
App\Entity\GiftHistory No errors.
App\Entity\Configuration No errors.
App\Entity\ScanHistory No errors.