GET https://app.plavnt.com/admin/category/

Query Metrics

297 Database Queries
6 Different statements
403.23 ms Query time
2 Invalid entities
371 Managed entities

Grouped Statements

Show all queries

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

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
  • The association App\Entity\User\UserOccasion#occasion refers to the inverse side field App\Entity\Occasion#userOccasions which does not exist.
App\Entity\Comment No errors.
App\Entity\Order\OrderMessage No errors.
App\Entity\Notification No errors.
App\Entity\PromoCode No errors.
App\Entity\Category No errors.
App\Entity\Slider
  • The association App\Entity\Slider#package refers to the inverse side field App\Entity\Package\Package#sliders which does not exist.
App\Entity\Package\Package No errors.
App\Entity\Setting 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\Package\AvailableDate No errors.
App\Entity\City No errors.
App\Entity\Package\Segment No errors.
App\Entity\Order\OrderItemProduct No errors.
App\Entity\Package\PackageVariantItem No errors.
App\Entity\Order\OrderItemStatus No errors.