https://asus-merchandising.dtv-projects.com/version

Query Metrics

9 Database Queries
3 Different statements
114.58 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
76.45 ms
(66.73%)
6
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.quantity AS quantity_3, t0.quantity_no_batch AS quantity_no_batch_4, t0.status AS status_5, t0.reference AS reference_6, t0.name AS name_7, t0.description AS description_8, t0.gamme AS gamme_9, t0.price_ht AS price_ht_10, t0.price_ttc AS price_ttc_11, t0.unit_point AS unit_point_12, t0.image_url AS image_url_13, t0.image_thumbnail_url AS image_thumbnail_url_14, t0.taxable_amount AS taxable_amount_15, t0.category_values AS category_values_16, t0.total_chosen_category_values AS total_chosen_category_values_17, t0.wish_date_evasion AS wish_date_evasion_18, t0.weight AS weight_19, t0.is_refundable AS is_refundable_20, t0.is_replaced AS is_replaced_21, t0.bo_id AS bo_id_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.order_id AS order_id_25, t26.id AS id_27, t26.bo_id AS bo_id_28, t26.sale_order_shipment_id AS sale_order_shipment_id_29, t26.sale_order_item_id AS sale_order_item_id_30, t0.replace_item_id AS replace_item_id_31 FROM sale_order_item t0 LEFT JOIN sale_order_shipment_item t26 ON t26.sale_order_item_id = t0.id WHERE t0.order_id = ?
Parameters:
[
  3
]
36.66 ms
(32.00%)
1
SELECT t0.id AS id_1, t0.total AS total_2, t0.shipping_method AS shipping_method_3, t0.status AS status_4, t0.waiting_status AS waiting_status_5, t0.cancel_motif AS cancel_motif_6, t0.shipping_price AS shipping_price_7, t0.internal_reference AS internal_reference_8, t0.comment AS comment_9, t0.is_managed_by_customer AS is_managed_by_customer_10, t0.fees_order AS fees_order_11, t0.extra_cb_payment AS extra_cb_payment_12, t0.total_bonus_used AS total_bonus_used_13, t0.not_billable AS not_billable_14, t0.otherinformations AS otherinformations_15, t0.old_id AS old_id_16, t0.category_values AS category_values_17, t0.fees_category_values AS fees_category_values_18, t0.custom_question AS custom_question_19, t0.order_rate AS order_rate_20, t0.is_trip AS is_trip_21, t0.order_extra_data AS order_extra_data_22, t0.is_express_delivery AS is_express_delivery_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.bank_return_id AS bank_return_id_26, t0.user_id AS user_id_27, t0.saleorder_grouped_id AS saleorder_grouped_id_28, t0.shipping_address_id AS shipping_address_id_29, t0.billing_address_id AS billing_address_id_30, t0.cart_id AS cart_id_31, t0.invoice_id AS invoice_id_32 FROM sale_order t0 WHERE t0.status IN (?, ?, ?, ?) AND t0.is_managed_by_customer = ?
Parameters:
[
  "pending_not_confirmed"
  "pending_canceled"
  "pending_processing"
  "pending_group"
  0
]
1.47 ms
(1.28%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.field_type AS field_type_5, t0.title AS title_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "MODULE_SETTING"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
user_logs doctrine.dbal.user_logs_connection
dtv_blacklisted_emails doctrine.dbal.dtv_blacklisted_emails_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.