Query Metrics
7
Database Queries
7
Different statements
13.09 ms
Query time
1
Invalid entities
2
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.38 ms (25.80%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.adresse AS adresse_6, t0.phone_number AS phone_number_7, t0.search AS search_8, t0.zip_code AS zip_code_9, t0.city AS city_10, t0.avatar AS avatar_11, t0.lat AS lat_12, t0.lang AS lang_13, t0.area AS area_14, t0.forgot_password_token AS forgot_password_token_15, t0.phone_two AS phone_two_16, t0.social AS social_17, t0.device_id AS device_id_18, t0.active AS active_19, t0.apple_id AS apple_id_20, t0.device_type AS device_type_21, t0.app_language AS app_language_22, t0.last_connected_at AS last_connected_at_23, t0.permissions AS permissions_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.buyer_id AS buyer_id_27 FROM user t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
3.00 ms (22.94%) |
1 |
"COMMIT"
Parameters:
[] |
|
2.14 ms (16.31%) |
1 |
SELECT t0.id AS id_1, t0.total AS total_2, t0.payment_mode AS payment_mode_3, t0.payment_reference AS payment_reference_4, t0.message AS message_5, t0.search AS search_6, t0.shipping_id AS shipping_id_7, t0.statu AS statu_8, t0.payment_token AS payment_token_9, t0.is_payment_confirmed AS is_payment_confirmed_10, t0.payment_date AS payment_date_11, t0.invoice_id AS invoice_id_12, t0.odoo_invoice_id AS odoo_invoice_id_13, t0.delivery_name AS delivery_name_14, t0.delivery_email AS delivery_email_15, t0.delivery_phone AS delivery_phone_16, t0.delivery_address AS delivery_address_17, t0.delivery_city AS delivery_city_18, t0.delivery_zip_code AS delivery_zip_code_19, t0.delivery_lat AS delivery_lat_20, t0.delivery_lang AS delivery_lang_21, t0.delivery_area AS delivery_area_22, t0.promo_code_discount AS promo_code_discount_23, t0.promo_code_used AS promo_code_used_24, t0.subtotal AS subtotal_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.user_id AS user_id_28, t0.user_adress_id AS user_adress_id_29, t0.promo_code_id AS promo_code_id_30 FROM `orders` t0 WHERE t0.user_id = ?
Parameters:
[
3
]
|
|
1.42 ms (10.87%) |
1 |
SELECT t0.id AS id_1, t0.qty AS qty_2, t0.pu AS pu_3, t0.rating AS rating_4, t0.statu AS statu_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.order_id_id AS order_id_id_8, t0.package_id AS package_id_9, t0.package_color_id AS package_color_id_10, t0.segment_id AS segment_id_11 FROM order_item t0 WHERE t0.package_id = ?
Parameters:
[
514
]
|
|
1.39 ms (10.59%) |
1 |
UPDATE package SET is_featured = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "2026-05-13 14:50:46" 514 ] |
|
1.17 ms (8.97%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.descreption AS descreption_3, t0.price_promo AS price_promo_4, t0.is_active AS is_active_5, t0.price AS price_6, t0.search AS search_7, t0.height AS height_8, t0.width AS width_9, t0.depth AS depth_10, t0.types AS types_11, t0.name_ar AS name_ar_12, t0.descreption_ar AS descreption_ar_13, t0.min_delay_day AS min_delay_day_14, t0.is_featured AS is_featured_15, t0.video_youtube AS video_youtube_16, t0.video_file AS video_file_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM package t0 WHERE t0.id = ?
Parameters:
[
"514"
]
|
|
0.59 ms (4.52%) |
1 |
"START TRANSACTION"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\User\User | 1 |
| App\Entity\Package\Package | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User\User | No errors. |
| App\Entity\Buyer | No errors. |
| App\Entity\Order\Order | No errors. |
| App\Entity\User\UserAdress | No errors. |
| App\Entity\User\UserOccasion |
|
| App\Entity\Comment | No errors. |
| App\Entity\Order\OrderMessage | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\PromoCode | No errors. |
| App\Entity\Package\Package | No errors. |
| App\Entity\Package\PackageImage | No errors. |
| App\Entity\Order\OrderItem | No errors. |
| App\Entity\Package\PackageProduct | No errors. |
| App\Entity\Package\PackageVariant | No errors. |
| App\Entity\Package\PackageColor | No errors. |
| App\Entity\Occasion | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Package\AvailableDate | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Package\Segment | No errors. |