Query Metrics
9
Database Queries
2
Different statements
4.63 ms
Query time
2
Invalid entities
Grouped Statements
| 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.