Query Metrics
297
Database Queries
6
Different statements
403.23 ms
Query time
2
Invalid entities
371
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
341.78 ms (84.76%) |
260 |
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:
[
159
]
|
|
47.52 ms (11.78%) |
30 |
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 INNER JOIN package_category ON t0.id = package_category.package_id WHERE package_category.category_id = ?
Parameters:
[
28
]
|
|
9.17 ms (2.27%) |
4 |
SELECT t0.id AS id_1, t0.tax AS tax_2, t0.logo AS logo_3, t0.site_name AS site_name_4, t0.site_name_ar AS site_name_ar_5, t0.contact_email AS contact_email_6, t0.fb_page AS fb_page_7, t0.instagram AS instagram_8, t0.youtube AS youtube_9, t0.x_profile AS x_profile_10, t0.js_code AS js_code_11, t0.css_code AS css_code_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM setting t0 LIMIT 1
Parameters:
[] |
|
2.26 ms (0.56%) |
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
]
|
|
1.39 ms (0.35%) |
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.12 ms (0.28%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.color AS color_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.search AS search_7, t0.name_ar AS name_ar_8 FROM category t0 ORDER BY t0.name ASC
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\Package\Package | 260 |
| App\Entity\Category | 45 |
| App\Entity\Order\OrderItem | 20 |
| App\Entity\Package\Segment | 20 |
| App\Entity\Order\Order | 17 |
| App\Entity\Package\PackageColor | 7 |
| App\Entity\User\User | 1 |
| App\Entity\Setting | 1 |