Query Metrics

9 Database Queries
2 Different statements
4.63 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.33 ms
(72.07%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.date_entered AS date_entered_2, p0_.date_modified AS date_modified_3, p0_.description AS description_4, p0_.code1c AS code1c_5, p0_.barcode AS barcode_6, p0_.status AS status_7, p0_.price AS price_8, p0_.price_income AS price_income_9, p0_.mark_up AS mark_up_10, p0_.min_mark_up AS min_mark_up_11, p0_.packing_type AS packing_type_12, p0_.packing_type_count AS packing_type_count_13, p0_.discounts AS discounts_14, p0_.count_order AS count_order_15, p0_.product_to_order AS product_to_order_16, p0_.article AS article_17, p0_.nds AS nds_18, p0_.service AS service_19, p0_.transport_service AS transport_service_20, p0_.exise AS exise_21, p0_.expiration_date AS expiration_date_22, p0_.unit_volume AS unit_volume_23, p0_.net_weight AS net_weight_24, p0_.gross_weight AS gross_weight_25, p0_.go_by_weight AS go_by_weight_26, p0_.packaging AS packaging_27, p0_.old_code AS old_code_28, p0_.show AS show_29, p0_.balance AS balance_30, p0_.deleted AS deleted_31, p0_.category_cnt AS category_cnt_32, p0_.price_category AS price_category_33, p0_.is_salle AS is_salle_34, p0_.is_new AS is_new_35, p0_.is_top AS is_top_36, p0_.old_price AS old_price_37, p0_.discount_percent AS discount_percent_38, p0_.video AS video_39, p0_.is_video AS is_video_40, p0_.is_free_shipping AS is_free_shipping_41, p0_.warranty_period AS warranty_period_42, p0_.min_balance AS min_balance_43, p0_.min_balance_admin AS min_balance_admin_44, p0_.main_category_id AS main_category_id_45, m1_.id AS id_46, m1_.short_name AS short_name_47, m1_.name AS name_48, m1_.date_entered AS date_entered_49, m1_.date_modified AS date_modified_50, m1_.created_by AS created_by_51, m1_.modified_user_id AS modified_user_id_52, m1_.description AS description_53, m1_.code1c AS code1c_54, c2_.id AS id_55, c2_.date_entered AS date_entered_56, c2_.date_modified AS date_modified_57, c2_.created_by AS created_by_58, c2_.modified_user_id AS modified_user_id_59, c2_.name AS name_60, c2_.slug AS slug_61, c2_.status AS status_62, c2_.description AS description_63, c2_.main AS main_64, c2_.type AS type_65, c2_.product_cnt AS product_cnt_66, c2_.site_product_cnt AS site_product_cnt_67, c2_.sort AS sort_68, m3_.id AS id_69, m3_.upload_timestamp AS upload_timestamp_70, m3_.main AS main_71, m3_.file_path AS file_path_72, m3_.type AS type_73, m3_.name AS name_74, m3_.size AS size_75, m3_.sort AS sort_76, m4_.id AS id_77, m4_.upload_timestamp AS upload_timestamp_78, m4_.main AS main_79, m4_.file_path AS file_path_80, m4_.type AS type_81, m4_.name AS name_82, m4_.size AS size_83, m4_.sort AS sort_84, m5_.id AS id_85, m5_.upload_timestamp AS upload_timestamp_86, m5_.main AS main_87, m5_.file_path AS file_path_88, m5_.type AS type_89, m5_.name AS name_90, m5_.size AS size_91, m5_.sort AS sort_92, m6_.id AS id_93, m6_.upload_timestamp AS upload_timestamp_94, m6_.main AS main_95, m6_.file_path AS file_path_96, m6_.type AS type_97, m6_.name AS name_98, m6_.size AS size_99, m6_.sort AS sort_100, p0_.modified_user_id AS modified_user_id_101, p0_.created_by_id AS created_by_id_102, p0_.measurement_unit_id AS measurement_unit_id_103, p0_.site_product_id AS site_product_id_104, p0_.storage_id AS storage_id_105, p0_.storage_element_id AS storage_element_id_106, p0_.language_id AS language_id_107, p0_.translations_id AS translations_id_108, p0_.main_media_id AS main_media_id_109, p0_.main_media_hover_id AS main_media_hover_id_110, c2_.parent_id AS parent_id_111, c2_.media_id AS media_id_112, m3_.product_id AS product_id_113, m3_.orders_id AS orders_id_114, m3_.users_id AS users_id_115, m3_.account_worker_id AS account_worker_id_116, m3_.form_answer_id AS form_answer_id_117, m3_.job_id AS job_id_118, m3_.resize_img_parent_id AS resize_img_parent_id_119, m4_.product_id AS product_id_120, m4_.orders_id AS orders_id_121, m4_.users_id AS users_id_122, m4_.account_worker_id AS account_worker_id_123, m4_.form_answer_id AS form_answer_id_124, m4_.job_id AS job_id_125, m4_.resize_img_parent_id AS resize_img_parent_id_126, m5_.product_id AS product_id_127, m5_.orders_id AS orders_id_128, m5_.users_id AS users_id_129, m5_.account_worker_id AS account_worker_id_130, m5_.form_answer_id AS form_answer_id_131, m5_.job_id AS job_id_132, m5_.resize_img_parent_id AS resize_img_parent_id_133, m6_.product_id AS product_id_134, m6_.orders_id AS orders_id_135, m6_.users_id AS users_id_136, m6_.account_worker_id AS account_worker_id_137, m6_.form_answer_id AS form_answer_id_138, m6_.job_id AS job_id_139, m6_.resize_img_parent_id AS resize_img_parent_id_140 FROM products p0_ LEFT JOIN measurment_unit m1_ ON p0_.measurement_unit_id = m1_.id LEFT JOIN products_category p7_ ON p0_.id = p7_.products_id LEFT JOIN category c2_ ON c2_.id = p7_.category_id LEFT JOIN media_object m3_ ON p0_.main_media_id = m3_.id LEFT JOIN media_object m4_ ON m3_.id = m4_.resize_img_parent_id LEFT JOIN media_object m5_ ON p0_.main_media_hover_id = m5_.id LEFT JOIN media_object m6_ ON m5_.id = m6_.resize_img_parent_id WHERE p0_.id = ?
Parameters:
[
  29206
]
1.29 ms
(27.93%)
8
SELECT t0.id AS id_1, t0.upload_timestamp AS upload_timestamp_2, t0.main AS main_3, t0.file_path AS file_path_4, t0.type AS type_5, t0.name AS name_6, t0.size AS size_7, t0.sort AS sort_8, t0.product_id AS product_id_9, t0.orders_id AS orders_id_10, t0.users_id AS users_id_11, t0.account_worker_id AS account_worker_id_12, t0.form_answer_id AS form_answer_id_13, t0.job_id AS job_id_14, t0.resize_img_parent_id AS resize_img_parent_id_15 FROM media_object t0 WHERE t0.resize_img_parent_id = ?
Parameters:
[
  21539
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Products No errors.
App\Entity\MeasurmentUnit No errors.
App\Entity\Category No errors.
App\Entity\MediaObject No errors.
App\Entity\User
  • The association App\Entity\User#faqs refers to the owning side field App\Entity\Faq#created_by which does not exist.
App\Entity\SiteProducts No errors.
App\Entity\Storage No errors.
App\Entity\StorageElement No errors.
App\Entity\Languages No errors.
App\Entity\Orders No errors.
App\Entity\AccountWorker No errors.
App\Entity\FormAnswer No errors.
App\Entity\Jobs No errors.
App\Entity\ProductInfo No errors.
App\Entity\IncomingInvoiceProduct No errors.
App\Entity\UserLikeList No errors.
App\Entity\AttributeItems No errors.
App\Entity\Prices No errors.
App\Entity\ProductBalanceInStorage No errors.
App\Entity\OrderProduct No errors.
App\Entity\Comments No errors.
App\Entity\ProductsReleted No errors.
App\Entity\Attributes No errors.
App\Entity\Coupons No errors.
App\Entity\Faq
  • The mappings App\Entity\Faq#createdUser and App\Entity\User#faqs are inconsistent with each other.
App\Entity\Pages No errors.
App\Entity\News No errors.
App\Entity\UsersDocs No errors.
App\Entity\Workers No errors.
App\Entity\AccountJobsList No errors.
App\Entity\SiteProductsMedia No errors.
App\Entity\Slide No errors.