Query Metrics
5
Database Queries
2
Different statements
5.34 ms
Query time
4
Invalid entities
13
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.66 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, c2_.id AS id_61, c2_.date_entered AS date_entered_62, c2_.date_modified AS date_modified_63, c2_.created_by AS created_by_64, c2_.modified_user_id AS modified_user_id_65, c2_.name AS name_66, c2_.slug AS slug_67, c2_.status AS status_68, c2_.description AS description_69, c2_.main AS main_70, c2_.type AS type_71, c2_.product_cnt AS product_cnt_72, c2_.site_product_cnt AS site_product_cnt_73, c2_.sort AS sort_74, c2_.seo_title AS seo_title_75, c2_.seo_description AS seo_description_76, p3_.id AS id_77, p3_.name AS name_78, p3_.date_entered AS date_entered_79, p3_.date_modified AS date_modified_80, p3_.description AS description_81, p3_.code1c AS code1c_82, p3_.barcode AS barcode_83, p3_.status AS status_84, p3_.price AS price_85, p3_.price_income AS price_income_86, p3_.mark_up AS mark_up_87, p3_.min_mark_up AS min_mark_up_88, p3_.packing_type AS packing_type_89, p3_.packing_type_count AS packing_type_count_90, p3_.discounts AS discounts_91, p3_.count_order AS count_order_92, p3_.product_to_order AS product_to_order_93, p3_.article AS article_94, p3_.nds AS nds_95, p3_.service AS service_96, p3_.transport_service AS transport_service_97, p3_.exise AS exise_98, p3_.expiration_date AS expiration_date_99, p3_.unit_volume AS unit_volume_100, p3_.net_weight AS net_weight_101, p3_.gross_weight AS gross_weight_102, p3_.go_by_weight AS go_by_weight_103, p3_.packaging AS packaging_104, p3_.old_code AS old_code_105, p3_.show AS show_106, p3_.balance AS balance_107, p3_.deleted AS deleted_108, p3_.category_cnt AS category_cnt_109, p3_.price_category AS price_category_110, p3_.is_salle AS is_salle_111, p3_.is_new AS is_new_112, p3_.is_top AS is_top_113, p3_.old_price AS old_price_114, p3_.discount_percent AS discount_percent_115, p3_.date_last_price_income AS date_last_price_income_116, p3_.video AS video_117, p3_.is_video AS is_video_118, p3_.is_free_shipping AS is_free_shipping_119, p3_.warranty_period AS warranty_period_120, p3_.min_balance AS min_balance_121, p3_.min_balance_admin AS min_balance_admin_122, p3_.main_category_id AS main_category_id_123, p3_.discontinued AS discontinued_124, p3_.seo_title AS seo_title_125, p3_.seo_description AS seo_description_126, p3_.salle_price AS salle_price_127, p3_.normal_price AS normal_price_128, p4_.id AS id_129, p4_.name AS name_130, p4_.date_entered AS date_entered_131, p4_.date_modified AS date_modified_132, p4_.description AS description_133, p4_.code1c AS code1c_134, p4_.barcode AS barcode_135, p4_.status AS status_136, p4_.price AS price_137, p4_.price_income AS price_income_138, p4_.mark_up AS mark_up_139, p4_.min_mark_up AS min_mark_up_140, p4_.packing_type AS packing_type_141, p4_.packing_type_count AS packing_type_count_142, p4_.discounts AS discounts_143, p4_.count_order AS count_order_144, p4_.product_to_order AS product_to_order_145, p4_.article AS article_146, p4_.nds AS nds_147, p4_.service AS service_148, p4_.transport_service AS transport_service_149, p4_.exise AS exise_150, p4_.expiration_date AS expiration_date_151, p4_.unit_volume AS unit_volume_152, p4_.net_weight AS net_weight_153, p4_.gross_weight AS gross_weight_154, p4_.go_by_weight AS go_by_weight_155, p4_.packaging AS packaging_156, p4_.old_code AS old_code_157, p4_.show AS show_158, p4_.balance AS balance_159, p4_.deleted AS deleted_160, p4_.category_cnt AS category_cnt_161, p4_.price_category AS price_category_162, p4_.is_salle AS is_salle_163, p4_.is_new AS is_new_164, p4_.is_top AS is_top_165, p4_.old_price AS old_price_166, p4_.discount_percent AS discount_percent_167, p4_.date_last_price_income AS date_last_price_income_168, p4_.video AS video_169, p4_.is_video AS is_video_170, p4_.is_free_shipping AS is_free_shipping_171, p4_.warranty_period AS warranty_period_172, p4_.min_balance AS min_balance_173, p4_.min_balance_admin AS min_balance_admin_174, p4_.main_category_id AS main_category_id_175, p4_.discontinued AS discontinued_176, p4_.seo_title AS seo_title_177, p4_.seo_description AS seo_description_178, p4_.salle_price AS salle_price_179, p4_.normal_price AS normal_price_180, m5_.id AS id_181, m5_.upload_timestamp AS upload_timestamp_182, m5_.main AS main_183, m5_.file_path AS file_path_184, m5_.type AS type_185, m5_.name AS name_186, m5_.size AS size_187, m5_.sort AS sort_188, m6_.id AS id_189, m6_.upload_timestamp AS upload_timestamp_190, m6_.main AS main_191, m6_.file_path AS file_path_192, m6_.type AS type_193, m6_.name AS name_194, m6_.size AS size_195, m6_.sort AS sort_196, m7_.id AS id_197, m7_.upload_timestamp AS upload_timestamp_198, m7_.main AS main_199, m7_.file_path AS file_path_200, m7_.type AS type_201, m7_.name AS name_202, m7_.size AS size_203, m7_.sort AS sort_204, m8_.id AS id_205, m8_.upload_timestamp AS upload_timestamp_206, m8_.main AS main_207, m8_.file_path AS file_path_208, m8_.type AS type_209, m8_.name AS name_210, m8_.size AS size_211, m8_.sort AS sort_212, p0_.modified_user_id AS modified_user_id_213, p0_.created_by_id AS created_by_id_214, p0_.measurement_unit_id AS measurement_unit_id_215, p0_.site_product_id AS site_product_id_216, p0_.storage_id AS storage_id_217, p0_.storage_element_id AS storage_element_id_218, p0_.language_id AS language_id_219, p0_.translation_id AS translation_id_220, p0_.main_media_id AS main_media_id_221, p0_.main_media_hover_id AS main_media_hover_id_222, c2_.parent_id AS parent_id_223, c2_.media_id AS media_id_224, c2_.language_id AS language_id_225, c2_.translation_id AS translation_id_226, p3_.modified_user_id AS modified_user_id_227, p3_.created_by_id AS created_by_id_228, p3_.measurement_unit_id AS measurement_unit_id_229, p3_.site_product_id AS site_product_id_230, p3_.storage_id AS storage_id_231, p3_.storage_element_id AS storage_element_id_232, p3_.language_id AS language_id_233, p3_.translation_id AS translation_id_234, p3_.main_media_id AS main_media_id_235, p3_.main_media_hover_id AS main_media_hover_id_236, p4_.modified_user_id AS modified_user_id_237, p4_.created_by_id AS created_by_id_238, p4_.measurement_unit_id AS measurement_unit_id_239, p4_.site_product_id AS site_product_id_240, p4_.storage_id AS storage_id_241, p4_.storage_element_id AS storage_element_id_242, p4_.language_id AS language_id_243, p4_.translation_id AS translation_id_244, p4_.main_media_id AS main_media_id_245, p4_.main_media_hover_id AS main_media_hover_id_246, m5_.product_id AS product_id_247, m5_.orders_id AS orders_id_248, m5_.users_id AS users_id_249, m5_.account_worker_id AS account_worker_id_250, m5_.form_answer_id AS form_answer_id_251, m5_.job_id AS job_id_252, m5_.resize_img_parent_id AS resize_img_parent_id_253, m6_.product_id AS product_id_254, m6_.orders_id AS orders_id_255, m6_.users_id AS users_id_256, m6_.account_worker_id AS account_worker_id_257, m6_.form_answer_id AS form_answer_id_258, m6_.job_id AS job_id_259, m6_.resize_img_parent_id AS resize_img_parent_id_260, m7_.product_id AS product_id_261, m7_.orders_id AS orders_id_262, m7_.users_id AS users_id_263, m7_.account_worker_id AS account_worker_id_264, m7_.form_answer_id AS form_answer_id_265, m7_.job_id AS job_id_266, m7_.resize_img_parent_id AS resize_img_parent_id_267, m8_.product_id AS product_id_268, m8_.orders_id AS orders_id_269, m8_.users_id AS users_id_270, m8_.account_worker_id AS account_worker_id_271, m8_.form_answer_id AS form_answer_id_272, m8_.job_id AS job_id_273, m8_.resize_img_parent_id AS resize_img_parent_id_274 FROM products p0_ LEFT JOIN measurment_unit m1_ ON p0_.measurement_unit_id = m1_.id LEFT JOIN products_category p9_ ON p0_.id = p9_.products_id LEFT JOIN category c2_ ON c2_.id = p9_.category_id LEFT JOIN products p3_ ON p0_.translation_id = p3_.id LEFT JOIN products p4_ ON p0_.id = p4_.translation_id LEFT JOIN media_object m5_ ON p0_.main_media_id = m5_.id LEFT JOIN media_object m6_ ON m5_.id = m6_.resize_img_parent_id LEFT JOIN media_object m7_ ON p0_.main_media_hover_id = m7_.id LEFT JOIN media_object m8_ ON m7_.id = m8_.resize_img_parent_id WHERE p0_.id = ?
Parameters:
[
29225
]
|
| 2 | 0.29 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:
[
24001
]
|
| 3 | 0.12 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:
[
24002
]
|
| 4 | 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:
[
24003
]
|
| 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:
[
24004
]
|
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 | 7 |
| App\Entity\Category | 4 |
| 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\Category | 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\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\Attributes | No errors. |
| App\Entity\Coupons | No errors. |
| App\Entity\Faq |
|
| App\Entity\Pages | No errors. |
| App\Entity\News | No errors. |
| App\Entity\Objects | No errors. |
| App\Entity\Projects | 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\GalleryItems | No errors. |
| App\Entity\MenuItems | No errors. |
| App\Entity\VacancyRequest |
|
| App\Entity\MaterialMedia | No errors. |
| App\Entity\Accounts | No errors. |
| App\Entity\Posts | No errors. |