Query Metrics
5
Database Queries
2
Different statements
4.02 ms
Query time
3
Invalid entities
8
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.41 ms |
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_.date_last_price_income AS date_last_price_income_39, p0_.video AS video_40, p0_.is_video AS is_video_41, p0_.is_free_shipping AS is_free_shipping_42, p0_.warranty_period AS warranty_period_43, p0_.min_balance AS min_balance_44, p0_.min_balance_admin AS min_balance_admin_45, p0_.main_category_id AS main_category_id_46, p0_.discontinued AS discontinued_47, p0_.seo_title AS seo_title_48, p0_.seo_description AS seo_description_49, p0_.salle_price AS salle_price_50, p0_.normal_price AS normal_price_51, m1_.id AS id_52, m1_.short_name AS short_name_53, m1_.name AS name_54, m1_.date_entered AS date_entered_55, m1_.date_modified AS date_modified_56, m1_.created_by AS created_by_57, m1_.modified_user_id AS modified_user_id_58, m1_.description AS description_59, m1_.code1c AS code1c_60, p2_.id AS id_61, p2_.name AS name_62, p2_.date_entered AS date_entered_63, p2_.date_modified AS date_modified_64, p2_.description AS description_65, p2_.code1c AS code1c_66, p2_.barcode AS barcode_67, p2_.status AS status_68, p2_.price AS price_69, p2_.price_income AS price_income_70, p2_.mark_up AS mark_up_71, p2_.min_mark_up AS min_mark_up_72, p2_.packing_type AS packing_type_73, p2_.packing_type_count AS packing_type_count_74, p2_.discounts AS discounts_75, p2_.count_order AS count_order_76, p2_.product_to_order AS product_to_order_77, p2_.article AS article_78, p2_.nds AS nds_79, p2_.service AS service_80, p2_.transport_service AS transport_service_81, p2_.exise AS exise_82, p2_.expiration_date AS expiration_date_83, p2_.unit_volume AS unit_volume_84, p2_.net_weight AS net_weight_85, p2_.gross_weight AS gross_weight_86, p2_.go_by_weight AS go_by_weight_87, p2_.packaging AS packaging_88, p2_.old_code AS old_code_89, p2_.show AS show_90, p2_.balance AS balance_91, p2_.deleted AS deleted_92, p2_.category_cnt AS category_cnt_93, p2_.price_category AS price_category_94, p2_.is_salle AS is_salle_95, p2_.is_new AS is_new_96, p2_.is_top AS is_top_97, p2_.old_price AS old_price_98, p2_.discount_percent AS discount_percent_99, p2_.date_last_price_income AS date_last_price_income_100, p2_.video AS video_101, p2_.is_video AS is_video_102, p2_.is_free_shipping AS is_free_shipping_103, p2_.warranty_period AS warranty_period_104, p2_.min_balance AS min_balance_105, p2_.min_balance_admin AS min_balance_admin_106, p2_.main_category_id AS main_category_id_107, p2_.discontinued AS discontinued_108, p2_.seo_title AS seo_title_109, p2_.seo_description AS seo_description_110, p2_.salle_price AS salle_price_111, p2_.normal_price AS normal_price_112, p3_.id AS id_113, p3_.name AS name_114, p3_.date_entered AS date_entered_115, p3_.date_modified AS date_modified_116, p3_.description AS description_117, p3_.code1c AS code1c_118, p3_.barcode AS barcode_119, p3_.status AS status_120, p3_.price AS price_121, p3_.price_income AS price_income_122, p3_.mark_up AS mark_up_123, p3_.min_mark_up AS min_mark_up_124, p3_.packing_type AS packing_type_125, p3_.packing_type_count AS packing_type_count_126, p3_.discounts AS discounts_127, p3_.count_order AS count_order_128, p3_.product_to_order AS product_to_order_129, p3_.article AS article_130, p3_.nds AS nds_131, p3_.service AS service_132, p3_.transport_service AS transport_service_133, p3_.exise AS exise_134, p3_.expiration_date AS expiration_date_135, p3_.unit_volume AS unit_volume_136, p3_.net_weight AS net_weight_137, p3_.gross_weight AS gross_weight_138, p3_.go_by_weight AS go_by_weight_139, p3_.packaging AS packaging_140, p3_.old_code AS old_code_141, p3_.show AS show_142, p3_.balance AS balance_143, p3_.deleted AS deleted_144, p3_.category_cnt AS category_cnt_145, p3_.price_category AS price_category_146, p3_.is_salle AS is_salle_147, p3_.is_new AS is_new_148, p3_.is_top AS is_top_149, p3_.old_price AS old_price_150, p3_.discount_percent AS discount_percent_151, p3_.date_last_price_income AS date_last_price_income_152, p3_.video AS video_153, p3_.is_video AS is_video_154, p3_.is_free_shipping AS is_free_shipping_155, p3_.warranty_period AS warranty_period_156, p3_.min_balance AS min_balance_157, p3_.min_balance_admin AS min_balance_admin_158, p3_.main_category_id AS main_category_id_159, p3_.discontinued AS discontinued_160, p3_.seo_title AS seo_title_161, p3_.seo_description AS seo_description_162, p3_.salle_price AS salle_price_163, p3_.normal_price AS normal_price_164, m4_.id AS id_165, m4_.upload_timestamp AS upload_timestamp_166, m4_.main AS main_167, m4_.file_path AS file_path_168, m4_.type AS type_169, m4_.name AS name_170, m4_.size AS size_171, m4_.sort AS sort_172, m5_.id AS id_173, m5_.upload_timestamp AS upload_timestamp_174, m5_.main AS main_175, m5_.file_path AS file_path_176, m5_.type AS type_177, m5_.name AS name_178, m5_.size AS size_179, m5_.sort AS sort_180, p0_.modified_user_id AS modified_user_id_181, p0_.created_by_id AS created_by_id_182, p0_.measurement_unit_id AS measurement_unit_id_183, p0_.site_product_id AS site_product_id_184, p0_.storage_id AS storage_id_185, p0_.storage_element_id AS storage_element_id_186, p0_.language_id AS language_id_187, p0_.translation_id AS translation_id_188, p0_.main_media_id AS main_media_id_189, p0_.main_media_hover_id AS main_media_hover_id_190, p2_.modified_user_id AS modified_user_id_191, p2_.created_by_id AS created_by_id_192, p2_.measurement_unit_id AS measurement_unit_id_193, p2_.site_product_id AS site_product_id_194, p2_.storage_id AS storage_id_195, p2_.storage_element_id AS storage_element_id_196, p2_.language_id AS language_id_197, p2_.translation_id AS translation_id_198, p2_.main_media_id AS main_media_id_199, p2_.main_media_hover_id AS main_media_hover_id_200, p3_.modified_user_id AS modified_user_id_201, p3_.created_by_id AS created_by_id_202, p3_.measurement_unit_id AS measurement_unit_id_203, p3_.site_product_id AS site_product_id_204, p3_.storage_id AS storage_id_205, p3_.storage_element_id AS storage_element_id_206, p3_.language_id AS language_id_207, p3_.translation_id AS translation_id_208, p3_.main_media_id AS main_media_id_209, p3_.main_media_hover_id AS main_media_hover_id_210, m4_.product_id AS product_id_211, m4_.orders_id AS orders_id_212, m4_.users_id AS users_id_213, m4_.account_worker_id AS account_worker_id_214, m4_.form_answer_id AS form_answer_id_215, m4_.job_id AS job_id_216, m4_.resize_img_parent_id AS resize_img_parent_id_217, m5_.product_id AS product_id_218, m5_.orders_id AS orders_id_219, m5_.users_id AS users_id_220, m5_.account_worker_id AS account_worker_id_221, m5_.form_answer_id AS form_answer_id_222, m5_.job_id AS job_id_223, m5_.resize_img_parent_id AS resize_img_parent_id_224 FROM products p0_ LEFT JOIN measurment_unit m1_ ON p0_.measurement_unit_id = m1_.id LEFT JOIN products p2_ ON p0_.translation_id = p2_.id LEFT JOIN products p3_ ON p0_.id = p3_.translation_id LEFT JOIN media_object m4_ ON p0_.main_media_id = m4_.id LEFT JOIN media_object m5_ ON m4_.id = m5_.resize_img_parent_id WHERE p0_.id = ?
Parameters:
[
29140
]
|
| 2 | 0.25 ms |
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:
[
8436
]
|
| 3 | 0.15 ms |
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:
[
8437
]
|
| 4 | 0.11 ms |
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:
[
8438
]
|
| 5 | 0.11 ms |
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:
[
8439
]
|
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\MediaObject | 6 |
| App\Entity\Products | 1 |
| App\Entity\MeasurmentUnit | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Products | No errors. |
| App\Entity\MeasurmentUnit | No errors. |
| App\Entity\MediaObject | No errors. |
| App\Entity\User |
|
| App\Entity\SiteProducts | No errors. |
| App\Entity\Storage | No errors. |
| App\Entity\StorageElement | No errors. |
| App\Entity\Languages |
|
| 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\Category | 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\Documents | No errors. |
| App\Entity\ProductDiscount | 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. |
| App\Entity\News | No errors. |
| App\Entity\GalleryItems | No errors. |
| App\Entity\MenuItems | No errors. |
| App\Entity\VacancyRequest |
|
| App\Entity\MaterialMedia | No errors. |
| App\Entity\Accounts | No errors. |
| App\Entity\Objects | No errors. |
| App\Entity\Projects | No errors. |
| App\Entity\Posts | No errors. |