GET http://api-felso.inneti.net/api/products/29225?g%5B0%5D=product%3Aread&g%5B1%5D=product%3Ahover&g%5B2%5D=product%3Acategory&show=true

Response
200 OK
Browse referrer URL
IP
253.129.206.168
Profiled on
Token
8ec10d

Query Metrics

5 Database Queries
2 Different statements
5.38 ms Query time
4 Invalid entities
13 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
4.68 ms
(87.05%) 		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_.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
]
View formatted query    View runnable query    Explain query
0.70 ms
(12.95%) 		4 
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
]
View formatted query    View runnable query    Explain query

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
  • 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
  • The association App\Entity\Languages#vacancies refers to the owning side field App\Entity\Vacancies#language which does not exist.
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
  • 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\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
  • The association App\Entity\VacancyRequest#vacancy refers to the inverse side field App\Entity\Vacancies#vacancyRequests which does not exist.
App\Entity\MaterialMedia No errors.
App\Entity\Accounts No errors.
App\Entity\Posts No errors.