Symfony Profiler

Query Metrics

37 Database Queries

2 Different statements

11.58 ms Query time

3 Invalid entities

48 Managed entities

Grouped Statements

Show all queries

Time▼	Count	Info
6.94 ms (59.97%)	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, m2_.id AS id_61, m2_.upload_timestamp AS upload_timestamp_62, m2_.main AS main_63, m2_.file_path AS file_path_64, m2_.type AS type_65, m2_.name AS name_66, m2_.size AS size_67, m2_.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, p4_.id AS id_77, p4_.name AS name_78, p4_.date_entered AS date_entered_79, p4_.date_modified AS date_modified_80, p4_.description AS description_81, p4_.code1c AS code1c_82, p4_.barcode AS barcode_83, p4_.status AS status_84, p4_.price AS price_85, p4_.price_income AS price_income_86, p4_.mark_up AS mark_up_87, p4_.min_mark_up AS min_mark_up_88, p4_.packing_type AS packing_type_89, p4_.packing_type_count AS packing_type_count_90, p4_.discounts AS discounts_91, p4_.count_order AS count_order_92, p4_.product_to_order AS product_to_order_93, p4_.article AS article_94, p4_.nds AS nds_95, p4_.service AS service_96, p4_.transport_service AS transport_service_97, p4_.exise AS exise_98, p4_.expiration_date AS expiration_date_99, p4_.unit_volume AS unit_volume_100, p4_.net_weight AS net_weight_101, p4_.gross_weight AS gross_weight_102, p4_.go_by_weight AS go_by_weight_103, p4_.packaging AS packaging_104, p4_.old_code AS old_code_105, p4_.show AS show_106, p4_.balance AS balance_107, p4_.deleted AS deleted_108, p4_.category_cnt AS category_cnt_109, p4_.price_category AS price_category_110, p4_.is_salle AS is_salle_111, p4_.is_new AS is_new_112, p4_.is_top AS is_top_113, p4_.old_price AS old_price_114, p4_.discount_percent AS discount_percent_115, p4_.date_last_price_income AS date_last_price_income_116, p4_.video AS video_117, p4_.is_video AS is_video_118, p4_.is_free_shipping AS is_free_shipping_119, p4_.warranty_period AS warranty_period_120, p4_.min_balance AS min_balance_121, p4_.min_balance_admin AS min_balance_admin_122, p4_.main_category_id AS main_category_id_123, p4_.discontinued AS discontinued_124, p4_.seo_title AS seo_title_125, p4_.seo_description AS seo_description_126, p4_.salle_price AS salle_price_127, p4_.normal_price AS normal_price_128, p5_.id AS id_129, p5_.name AS name_130, p5_.date_entered AS date_entered_131, p5_.date_modified AS date_modified_132, p5_.description AS description_133, p5_.code1c AS code1c_134, p5_.barcode AS barcode_135, p5_.status AS status_136, p5_.price AS price_137, p5_.price_income AS price_income_138, p5_.mark_up AS mark_up_139, p5_.min_mark_up AS min_mark_up_140, p5_.packing_type AS packing_type_141, p5_.packing_type_count AS packing_type_count_142, p5_.discounts AS discounts_143, p5_.count_order AS count_order_144, p5_.product_to_order AS product_to_order_145, p5_.article AS article_146, p5_.nds AS nds_147, p5_.service AS service_148, p5_.transport_service AS transport_service_149, p5_.exise AS exise_150, p5_.expiration_date AS expiration_date_151, p5_.unit_volume AS unit_volume_152, p5_.net_weight AS net_weight_153, p5_.gross_weight AS gross_weight_154, p5_.go_by_weight AS go_by_weight_155, p5_.packaging AS packaging_156, p5_.old_code AS old_code_157, p5_.show AS show_158, p5_.balance AS balance_159, p5_.deleted AS deleted_160, p5_.category_cnt AS category_cnt_161, p5_.price_category AS price_category_162, p5_.is_salle AS is_salle_163, p5_.is_new AS is_new_164, p5_.is_top AS is_top_165, p5_.old_price AS old_price_166, p5_.discount_percent AS discount_percent_167, p5_.date_last_price_income AS date_last_price_income_168, p5_.video AS video_169, p5_.is_video AS is_video_170, p5_.is_free_shipping AS is_free_shipping_171, p5_.warranty_period AS warranty_period_172, p5_.min_balance AS min_balance_173, p5_.min_balance_admin AS min_balance_admin_174, p5_.main_category_id AS main_category_id_175, p5_.discontinued AS discontinued_176, p5_.seo_title AS seo_title_177, p5_.seo_description AS seo_description_178, p5_.salle_price AS salle_price_179, p5_.normal_price AS normal_price_180, m6_.id AS id_181, m6_.upload_timestamp AS upload_timestamp_182, m6_.main AS main_183, m6_.file_path AS file_path_184, m6_.type AS type_185, m6_.name AS name_186, m6_.size AS size_187, m6_.sort AS sort_188, m7_.id AS id_189, m7_.upload_timestamp AS upload_timestamp_190, m7_.main AS main_191, m7_.file_path AS file_path_192, m7_.type AS type_193, m7_.name AS name_194, m7_.size AS size_195, m7_.sort AS sort_196, p0_.modified_user_id AS modified_user_id_197, p0_.created_by_id AS created_by_id_198, p0_.measurement_unit_id AS measurement_unit_id_199, p0_.site_product_id AS site_product_id_200, p0_.storage_id AS storage_id_201, p0_.storage_element_id AS storage_element_id_202, p0_.language_id AS language_id_203, p0_.translation_id AS translation_id_204, p0_.main_media_id AS main_media_id_205, p0_.main_media_hover_id AS main_media_hover_id_206, m2_.product_id AS product_id_207, m2_.orders_id AS orders_id_208, m2_.users_id AS users_id_209, m2_.account_worker_id AS account_worker_id_210, m2_.form_answer_id AS form_answer_id_211, m2_.job_id AS job_id_212, m2_.resize_img_parent_id AS resize_img_parent_id_213, m3_.product_id AS product_id_214, m3_.orders_id AS orders_id_215, m3_.users_id AS users_id_216, m3_.account_worker_id AS account_worker_id_217, m3_.form_answer_id AS form_answer_id_218, m3_.job_id AS job_id_219, m3_.resize_img_parent_id AS resize_img_parent_id_220, p4_.modified_user_id AS modified_user_id_221, p4_.created_by_id AS created_by_id_222, p4_.measurement_unit_id AS measurement_unit_id_223, p4_.site_product_id AS site_product_id_224, p4_.storage_id AS storage_id_225, p4_.storage_element_id AS storage_element_id_226, p4_.language_id AS language_id_227, p4_.translation_id AS translation_id_228, p4_.main_media_id AS main_media_id_229, p4_.main_media_hover_id AS main_media_hover_id_230, p5_.modified_user_id AS modified_user_id_231, p5_.created_by_id AS created_by_id_232, p5_.measurement_unit_id AS measurement_unit_id_233, p5_.site_product_id AS site_product_id_234, p5_.storage_id AS storage_id_235, p5_.storage_element_id AS storage_element_id_236, p5_.language_id AS language_id_237, p5_.translation_id AS translation_id_238, p5_.main_media_id AS main_media_id_239, p5_.main_media_hover_id AS main_media_hover_id_240, m6_.product_id AS product_id_241, m6_.orders_id AS orders_id_242, m6_.users_id AS users_id_243, m6_.account_worker_id AS account_worker_id_244, m6_.form_answer_id AS form_answer_id_245, m6_.job_id AS job_id_246, m6_.resize_img_parent_id AS resize_img_parent_id_247, m7_.product_id AS product_id_248, m7_.orders_id AS orders_id_249, m7_.users_id AS users_id_250, m7_.account_worker_id AS account_worker_id_251, m7_.form_answer_id AS form_answer_id_252, m7_.job_id AS job_id_253, m7_.resize_img_parent_id AS resize_img_parent_id_254 FROM products p0_ LEFT JOIN measurment_unit m1_ ON p0_.measurement_unit_id = m1_.id LEFT JOIN media_object m2_ ON p0_.id = m2_.product_id LEFT JOIN media_object m3_ ON m2_.id = m3_.resize_img_parent_id LEFT JOIN products p4_ ON p0_.translation_id = p4_.id LEFT JOIN products p5_ ON p0_.id = p5_.translation_id LEFT JOIN media_object m6_ ON p0_.main_media_id = m6_.id LEFT JOIN media_object m7_ ON m6_.id = m7_.resize_img_parent_id WHERE p0_.id = ? Parameters: [`29150`] View formatted query View runnable query Explain query 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, m2_.id AS id_61, m2_.upload_timestamp AS upload_timestamp_62, m2_.main AS main_63, m2_.file_path AS file_path_64, m2_.type AS type_65, m2_.name AS name_66, m2_.size AS size_67, m2_.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, p4_.id AS id_77, p4_.name AS name_78, p4_.date_entered AS date_entered_79, p4_.date_modified AS date_modified_80, p4_.description AS description_81, p4_.code1c AS code1c_82, p4_.barcode AS barcode_83, p4_.status AS status_84, p4_.price AS price_85, p4_.price_income AS price_income_86, p4_.mark_up AS mark_up_87, p4_.min_mark_up AS min_mark_up_88, p4_.packing_type AS packing_type_89, p4_.packing_type_count AS packing_type_count_90, p4_.discounts AS discounts_91, p4_.count_order AS count_order_92, p4_.product_to_order AS product_to_order_93, p4_.article AS article_94, p4_.nds AS nds_95, p4_.service AS service_96, p4_.transport_service AS transport_service_97, p4_.exise AS exise_98, p4_.expiration_date AS expiration_date_99, p4_.unit_volume AS unit_volume_100, p4_.net_weight AS net_weight_101, p4_.gross_weight AS gross_weight_102, p4_.go_by_weight AS go_by_weight_103, p4_.packaging AS packaging_104, p4_.old_code AS old_code_105, p4_.show AS show_106, p4_.balance AS balance_107, p4_.deleted AS deleted_108, p4_.category_cnt AS category_cnt_109, p4_.price_category AS price_category_110, p4_.is_salle AS is_salle_111, p4_.is_new AS is_new_112, p4_.is_top AS is_top_113, p4_.old_price AS old_price_114, p4_.discount_percent AS discount_percent_115, p4_.date_last_price_income AS date_last_price_income_116, p4_.video AS video_117, p4_.is_video AS is_video_118, p4_.is_free_shipping AS is_free_shipping_119, p4_.warranty_period AS warranty_period_120, p4_.min_balance AS min_balance_121, p4_.min_balance_admin AS min_balance_admin_122, p4_.main_category_id AS main_category_id_123, p4_.discontinued AS discontinued_124, p4_.seo_title AS seo_title_125, p4_.seo_description AS seo_description_126, p4_.salle_price AS salle_price_127, p4_.normal_price AS normal_price_128, p5_.id AS id_129, p5_.name AS name_130, p5_.date_entered AS date_entered_131, p5_.date_modified AS date_modified_132, p5_.description AS description_133, p5_.code1c AS code1c_134, p5_.barcode AS barcode_135, p5_.status AS status_136, p5_.price AS price_137, p5_.price_income AS price_income_138, p5_.mark_up AS mark_up_139, p5_.min_mark_up AS min_mark_up_140, p5_.packing_type AS packing_type_141, p5_.packing_type_count AS packing_type_count_142, p5_.discounts AS discounts_143, p5_.count_order AS count_order_144, p5_.product_to_order AS product_to_order_145, p5_.article AS article_146, p5_.nds AS nds_147, p5_.service AS service_148, p5_.transport_service AS transport_service_149, p5_.exise AS exise_150, p5_.expiration_date AS expiration_date_151, p5_.unit_volume AS unit_volume_152, p5_.net_weight AS net_weight_153, p5_.gross_weight AS gross_weight_154, p5_.go_by_weight AS go_by_weight_155, p5_.packaging AS packaging_156, p5_.old_code AS old_code_157, p5_.show AS show_158, p5_.balance AS balance_159, p5_.deleted AS deleted_160, p5_.category_cnt AS category_cnt_161, p5_.price_category AS price_category_162, p5_.is_salle AS is_salle_163, p5_.is_new AS is_new_164, p5_.is_top AS is_top_165, p5_.old_price AS old_price_166, p5_.discount_percent AS discount_percent_167, p5_.date_last_price_income AS date_last_price_income_168, p5_.video AS video_169, p5_.is_video AS is_video_170, p5_.is_free_shipping AS is_free_shipping_171, p5_.warranty_period AS warranty_period_172, p5_.min_balance AS min_balance_173, p5_.min_balance_admin AS min_balance_admin_174, p5_.main_category_id AS main_category_id_175, p5_.discontinued AS discontinued_176, p5_.seo_title AS seo_title_177, p5_.seo_description AS seo_description_178, p5_.salle_price AS salle_price_179, p5_.normal_price AS normal_price_180, m6_.id AS id_181, m6_.upload_timestamp AS upload_timestamp_182, m6_.main AS main_183, m6_.file_path AS file_path_184, m6_.type AS type_185, m6_.name AS name_186, m6_.size AS size_187, m6_.sort AS sort_188, m7_.id AS id_189, m7_.upload_timestamp AS upload_timestamp_190, m7_.main AS main_191, m7_.file_path AS file_path_192, m7_.type AS type_193, m7_.name AS name_194, m7_.size AS size_195, m7_.sort AS sort_196, p0_.modified_user_id AS modified_user_id_197, p0_.created_by_id AS created_by_id_198, p0_.measurement_unit_id AS measurement_unit_id_199, p0_.site_product_id AS site_product_id_200, p0_.storage_id AS storage_id_201, p0_.storage_element_id AS storage_element_id_202, p0_.language_id AS language_id_203, p0_.translation_id AS translation_id_204, p0_.main_media_id AS main_media_id_205, p0_.main_media_hover_id AS main_media_hover_id_206, m2_.product_id AS product_id_207, m2_.orders_id AS orders_id_208, m2_.users_id AS users_id_209, m2_.account_worker_id AS account_worker_id_210, m2_.form_answer_id AS form_answer_id_211, m2_.job_id AS job_id_212, m2_.resize_img_parent_id AS resize_img_parent_id_213, m3_.product_id AS product_id_214, m3_.orders_id AS orders_id_215, m3_.users_id AS users_id_216, m3_.account_worker_id AS account_worker_id_217, m3_.form_answer_id AS form_answer_id_218, m3_.job_id AS job_id_219, m3_.resize_img_parent_id AS resize_img_parent_id_220, p4_.modified_user_id AS modified_user_id_221, p4_.created_by_id AS created_by_id_222, p4_.measurement_unit_id AS measurement_unit_id_223, p4_.site_product_id AS site_product_id_224, p4_.storage_id AS storage_id_225, p4_.storage_element_id AS storage_element_id_226, p4_.language_id AS language_id_227, p4_.translation_id AS translation_id_228, p4_.main_media_id AS main_media_id_229, p4_.main_media_hover_id AS main_media_hover_id_230, p5_.modified_user_id AS modified_user_id_231, p5_.created_by_id AS created_by_id_232, p5_.measurement_unit_id AS measurement_unit_id_233, p5_.site_product_id AS site_product_id_234, p5_.storage_id AS storage_id_235, p5_.storage_element_id AS storage_element_id_236, p5_.language_id AS language_id_237, p5_.translation_id AS translation_id_238, p5_.main_media_id AS main_media_id_239, p5_.main_media_hover_id AS main_media_hover_id_240, m6_.product_id AS product_id_241, m6_.orders_id AS orders_id_242, m6_.users_id AS users_id_243, m6_.account_worker_id AS account_worker_id_244, m6_.form_answer_id AS form_answer_id_245, m6_.job_id AS job_id_246, m6_.resize_img_parent_id AS resize_img_parent_id_247, m7_.product_id AS product_id_248, m7_.orders_id AS orders_id_249, m7_.users_id AS users_id_250, m7_.account_worker_id AS account_worker_id_251, m7_.form_answer_id AS form_answer_id_252, m7_.job_id AS job_id_253, m7_.resize_img_parent_id AS resize_img_parent_id_254 FROM products p0_ LEFT JOIN measurment_unit m1_ ON p0_.measurement_unit_id = m1_.id LEFT JOIN media_object m2_ ON p0_.id = m2_.product_id LEFT JOIN media_object m3_ ON m2_.id = m3_.resize_img_parent_id LEFT JOIN products p4_ ON p0_.translation_id = p4_.id LEFT JOIN products p5_ ON p0_.id = p5_.translation_id LEFT JOIN media_object m6_ ON p0_.main_media_id = m6_.id LEFT JOIN media_object m7_ ON m6_.id = m7_.resize_img_parent_id WHERE p0_.id = ? 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, m2_.id AS id_61, m2_.upload_timestamp AS upload_timestamp_62, m2_.main AS main_63, m2_.file_path AS file_path_64, m2_.type AS type_65, m2_.name AS name_66, m2_.size AS size_67, m2_.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, p4_.id AS id_77, p4_.name AS name_78, p4_.date_entered AS date_entered_79, p4_.date_modified AS date_modified_80, p4_.description AS description_81, p4_.code1c AS code1c_82, p4_.barcode AS barcode_83, p4_.status AS status_84, p4_.price AS price_85, p4_.price_income AS price_income_86, p4_.mark_up AS mark_up_87, p4_.min_mark_up AS min_mark_up_88, p4_.packing_type AS packing_type_89, p4_.packing_type_count AS packing_type_count_90, p4_.discounts AS discounts_91, p4_.count_order AS count_order_92, p4_.product_to_order AS product_to_order_93, p4_.article AS article_94, p4_.nds AS nds_95, p4_.service AS service_96, p4_.transport_service AS transport_service_97, p4_.exise AS exise_98, p4_.expiration_date AS expiration_date_99, p4_.unit_volume AS unit_volume_100, p4_.net_weight AS net_weight_101, p4_.gross_weight AS gross_weight_102, p4_.go_by_weight AS go_by_weight_103, p4_.packaging AS packaging_104, p4_.old_code AS old_code_105, p4_.show AS show_106, p4_.balance AS balance_107, p4_.deleted AS deleted_108, p4_.category_cnt AS category_cnt_109, p4_.price_category AS price_category_110, p4_.is_salle AS is_salle_111, p4_.is_new AS is_new_112, p4_.is_top AS is_top_113, p4_.old_price AS old_price_114, p4_.discount_percent AS discount_percent_115, p4_.date_last_price_income AS date_last_price_income_116, p4_.video AS video_117, p4_.is_video AS is_video_118, p4_.is_free_shipping AS is_free_shipping_119, p4_.warranty_period AS warranty_period_120, p4_.min_balance AS min_balance_121, p4_.min_balance_admin AS min_balance_admin_122, p4_.main_category_id AS main_category_id_123, p4_.discontinued AS discontinued_124, p4_.seo_title AS seo_title_125, p4_.seo_description AS seo_description_126, p4_.salle_price AS salle_price_127, p4_.normal_price AS normal_price_128, p5_.id AS id_129, p5_.name AS name_130, p5_.date_entered AS date_entered_131, p5_.date_modified AS date_modified_132, p5_.description AS description_133, p5_.code1c AS code1c_134, p5_.barcode AS barcode_135, p5_.status AS status_136, p5_.price AS price_137, p5_.price_income AS price_income_138, p5_.mark_up AS mark_up_139, p5_.min_mark_up AS min_mark_up_140, p5_.packing_type AS packing_type_141, p5_.packing_type_count AS packing_type_count_142, p5_.discounts AS discounts_143, p5_.count_order AS count_order_144, p5_.product_to_order AS product_to_order_145, p5_.article AS article_146, p5_.nds AS nds_147, p5_.service AS service_148, p5_.transport_service AS transport_service_149, p5_.exise AS exise_150, p5_.expiration_date AS expiration_date_151, p5_.unit_volume AS unit_volume_152, p5_.net_weight AS net_weight_153, p5_.gross_weight AS gross_weight_154, p5_.go_by_weight AS go_by_weight_155, p5_.packaging AS packaging_156, p5_.old_code AS old_code_157, p5_.show AS show_158, p5_.balance AS balance_159, p5_.deleted AS deleted_160, p5_.category_cnt AS category_cnt_161, p5_.price_category AS price_category_162, p5_.is_salle AS is_salle_163, p5_.is_new AS is_new_164, p5_.is_top AS is_top_165, p5_.old_price AS old_price_166, p5_.discount_percent AS discount_percent_167, p5_.date_last_price_income AS date_last_price_income_168, p5_.video AS video_169, p5_.is_video AS is_video_170, p5_.is_free_shipping AS is_free_shipping_171, p5_.warranty_period AS warranty_period_172, p5_.min_balance AS min_balance_173, p5_.min_balance_admin AS min_balance_admin_174, p5_.main_category_id AS main_category_id_175, p5_.discontinued AS discontinued_176, p5_.seo_title AS seo_title_177, p5_.seo_description AS seo_description_178, p5_.salle_price AS salle_price_179, p5_.normal_price AS normal_price_180, m6_.id AS id_181, m6_.upload_timestamp AS upload_timestamp_182, m6_.main AS main_183, m6_.file_path AS file_path_184, m6_.type AS type_185, m6_.name AS name_186, m6_.size AS size_187, m6_.sort AS sort_188, m7_.id AS id_189, m7_.upload_timestamp AS upload_timestamp_190, m7_.main AS main_191, m7_.file_path AS file_path_192, m7_.type AS type_193, m7_.name AS name_194, m7_.size AS size_195, m7_.sort AS sort_196, p0_.modified_user_id AS modified_user_id_197, p0_.created_by_id AS created_by_id_198, p0_.measurement_unit_id AS measurement_unit_id_199, p0_.site_product_id AS site_product_id_200, p0_.storage_id AS storage_id_201, p0_.storage_element_id AS storage_element_id_202, p0_.language_id AS language_id_203, p0_.translation_id AS translation_id_204, p0_.main_media_id AS main_media_id_205, p0_.main_media_hover_id AS main_media_hover_id_206, m2_.product_id AS product_id_207, m2_.orders_id AS orders_id_208, m2_.users_id AS users_id_209, m2_.account_worker_id AS account_worker_id_210, m2_.form_answer_id AS form_answer_id_211, m2_.job_id AS job_id_212, m2_.resize_img_parent_id AS resize_img_parent_id_213, m3_.product_id AS product_id_214, m3_.orders_id AS orders_id_215, m3_.users_id AS users_id_216, m3_.account_worker_id AS account_worker_id_217, m3_.form_answer_id AS form_answer_id_218, m3_.job_id AS job_id_219, m3_.resize_img_parent_id AS resize_img_parent_id_220, p4_.modified_user_id AS modified_user_id_221, p4_.created_by_id AS created_by_id_222, p4_.measurement_unit_id AS measurement_unit_id_223, p4_.site_product_id AS site_product_id_224, p4_.storage_id AS storage_id_225, p4_.storage_element_id AS storage_element_id_226, p4_.language_id AS language_id_227, p4_.translation_id AS translation_id_228, p4_.main_media_id AS main_media_id_229, p4_.main_media_hover_id AS main_media_hover_id_230, p5_.modified_user_id AS modified_user_id_231, p5_.created_by_id AS created_by_id_232, p5_.measurement_unit_id AS measurement_unit_id_233, p5_.site_product_id AS site_product_id_234, p5_.storage_id AS storage_id_235, p5_.storage_element_id AS storage_element_id_236, p5_.language_id AS language_id_237, p5_.translation_id AS translation_id_238, p5_.main_media_id AS main_media_id_239, p5_.main_media_hover_id AS main_media_hover_id_240, m6_.product_id AS product_id_241, m6_.orders_id AS orders_id_242, m6_.users_id AS users_id_243, m6_.account_worker_id AS account_worker_id_244, m6_.form_answer_id AS form_answer_id_245, m6_.job_id AS job_id_246, m6_.resize_img_parent_id AS resize_img_parent_id_247, m7_.product_id AS product_id_248, m7_.orders_id AS orders_id_249, m7_.users_id AS users_id_250, m7_.account_worker_id AS account_worker_id_251, m7_.form_answer_id AS form_answer_id_252, m7_.job_id AS job_id_253, m7_.resize_img_parent_id AS resize_img_parent_id_254 FROM products p0_ LEFT JOIN measurment_unit m1_ ON p0_.measurement_unit_id = m1_.id LEFT JOIN media_object m2_ ON p0_.id = m2_.product_id LEFT JOIN media_object m3_ ON m2_.id = m3_.resize_img_parent_id LEFT JOIN products p4_ ON p0_.translation_id = p4_.id LEFT JOIN products p5_ ON p0_.id = p5_.translation_id LEFT JOIN media_object m6_ ON p0_.main_media_id = m6_.id LEFT JOIN media_object m7_ ON m6_.id = m7_.resize_img_parent_id WHERE p0_.id = 29150;
4.64 ms (40.03%)	36	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: [`9426`] View formatted query View runnable query Explain query 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 = ? 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 = 9426;

Time▼

Count

Info

6.94 ms
(59.97%)

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, m2_.id AS id_61, m2_.upload_timestamp AS upload_timestamp_62, m2_.main AS main_63, m2_.file_path AS file_path_64, m2_.type AS type_65, m2_.name AS name_66, m2_.size AS size_67, m2_.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, p4_.id AS id_77, p4_.name AS name_78, p4_.date_entered AS date_entered_79, p4_.date_modified AS date_modified_80, p4_.description AS description_81, p4_.code1c AS code1c_82, p4_.barcode AS barcode_83, p4_.status AS status_84, p4_.price AS price_85, p4_.price_income AS price_income_86, p4_.mark_up AS mark_up_87, p4_.min_mark_up AS min_mark_up_88, p4_.packing_type AS packing_type_89, p4_.packing_type_count AS packing_type_count_90, p4_.discounts AS discounts_91, p4_.count_order AS count_order_92, p4_.product_to_order AS product_to_order_93, p4_.article AS article_94, p4_.nds AS nds_95, p4_.service AS service_96, p4_.transport_service AS transport_service_97, p4_.exise AS exise_98, p4_.expiration_date AS expiration_date_99, p4_.unit_volume AS unit_volume_100, p4_.net_weight AS net_weight_101, p4_.gross_weight AS gross_weight_102, p4_.go_by_weight AS go_by_weight_103, p4_.packaging AS packaging_104, p4_.old_code AS old_code_105, p4_.show AS show_106, p4_.balance AS balance_107, p4_.deleted AS deleted_108, p4_.category_cnt AS category_cnt_109, p4_.price_category AS price_category_110, p4_.is_salle AS is_salle_111, p4_.is_new AS is_new_112, p4_.is_top AS is_top_113, p4_.old_price AS old_price_114, p4_.discount_percent AS discount_percent_115, p4_.date_last_price_income AS date_last_price_income_116, p4_.video AS video_117, p4_.is_video AS is_video_118, p4_.is_free_shipping AS is_free_shipping_119, p4_.warranty_period AS warranty_period_120, p4_.min_balance AS min_balance_121, p4_.min_balance_admin AS min_balance_admin_122, p4_.main_category_id AS main_category_id_123, p4_.discontinued AS discontinued_124, p4_.seo_title AS seo_title_125, p4_.seo_description AS seo_description_126, p4_.salle_price AS salle_price_127, p4_.normal_price AS normal_price_128, p5_.id AS id_129, p5_.name AS name_130, p5_.date_entered AS date_entered_131, p5_.date_modified AS date_modified_132, p5_.description AS description_133, p5_.code1c AS code1c_134, p5_.barcode AS barcode_135, p5_.status AS status_136, p5_.price AS price_137, p5_.price_income AS price_income_138, p5_.mark_up AS mark_up_139, p5_.min_mark_up AS min_mark_up_140, p5_.packing_type AS packing_type_141, p5_.packing_type_count AS packing_type_count_142, p5_.discounts AS discounts_143, p5_.count_order AS count_order_144, p5_.product_to_order AS product_to_order_145, p5_.article AS article_146, p5_.nds AS nds_147, p5_.service AS service_148, p5_.transport_service AS transport_service_149, p5_.exise AS exise_150, p5_.expiration_date AS expiration_date_151, p5_.unit_volume AS unit_volume_152, p5_.net_weight AS net_weight_153, p5_.gross_weight AS gross_weight_154, p5_.go_by_weight AS go_by_weight_155, p5_.packaging AS packaging_156, p5_.old_code AS old_code_157, p5_.show AS show_158, p5_.balance AS balance_159, p5_.deleted AS deleted_160, p5_.category_cnt AS category_cnt_161, p5_.price_category AS price_category_162, p5_.is_salle AS is_salle_163, p5_.is_new AS is_new_164, p5_.is_top AS is_top_165, p5_.old_price AS old_price_166, p5_.discount_percent AS discount_percent_167, p5_.date_last_price_income AS date_last_price_income_168, p5_.video AS video_169, p5_.is_video AS is_video_170, p5_.is_free_shipping AS is_free_shipping_171, p5_.warranty_period AS warranty_period_172, p5_.min_balance AS min_balance_173, p5_.min_balance_admin AS min_balance_admin_174, p5_.main_category_id AS main_category_id_175, p5_.discontinued AS discontinued_176, p5_.seo_title AS seo_title_177, p5_.seo_description AS seo_description_178, p5_.salle_price AS salle_price_179, p5_.normal_price AS normal_price_180, m6_.id AS id_181, m6_.upload_timestamp AS upload_timestamp_182, m6_.main AS main_183, m6_.file_path AS file_path_184, m6_.type AS type_185, m6_.name AS name_186, m6_.size AS size_187, m6_.sort AS sort_188, m7_.id AS id_189, m7_.upload_timestamp AS upload_timestamp_190, m7_.main AS main_191, m7_.file_path AS file_path_192, m7_.type AS type_193, m7_.name AS name_194, m7_.size AS size_195, m7_.sort AS sort_196, p0_.modified_user_id AS modified_user_id_197, p0_.created_by_id AS created_by_id_198, p0_.measurement_unit_id AS measurement_unit_id_199, p0_.site_product_id AS site_product_id_200, p0_.storage_id AS storage_id_201, p0_.storage_element_id AS storage_element_id_202, p0_.language_id AS language_id_203, p0_.translation_id AS translation_id_204, p0_.main_media_id AS main_media_id_205, p0_.main_media_hover_id AS main_media_hover_id_206, m2_.product_id AS product_id_207, m2_.orders_id AS orders_id_208, m2_.users_id AS users_id_209, m2_.account_worker_id AS account_worker_id_210, m2_.form_answer_id AS form_answer_id_211, m2_.job_id AS job_id_212, m2_.resize_img_parent_id AS resize_img_parent_id_213, m3_.product_id AS product_id_214, m3_.orders_id AS orders_id_215, m3_.users_id AS users_id_216, m3_.account_worker_id AS account_worker_id_217, m3_.form_answer_id AS form_answer_id_218, m3_.job_id AS job_id_219, m3_.resize_img_parent_id AS resize_img_parent_id_220, p4_.modified_user_id AS modified_user_id_221, p4_.created_by_id AS created_by_id_222, p4_.measurement_unit_id AS measurement_unit_id_223, p4_.site_product_id AS site_product_id_224, p4_.storage_id AS storage_id_225, p4_.storage_element_id AS storage_element_id_226, p4_.language_id AS language_id_227, p4_.translation_id AS translation_id_228, p4_.main_media_id AS main_media_id_229, p4_.main_media_hover_id AS main_media_hover_id_230, p5_.modified_user_id AS modified_user_id_231, p5_.created_by_id AS created_by_id_232, p5_.measurement_unit_id AS measurement_unit_id_233, p5_.site_product_id AS site_product_id_234, p5_.storage_id AS storage_id_235, p5_.storage_element_id AS storage_element_id_236, p5_.language_id AS language_id_237, p5_.translation_id AS translation_id_238, p5_.main_media_id AS main_media_id_239, p5_.main_media_hover_id AS main_media_hover_id_240, m6_.product_id AS product_id_241, m6_.orders_id AS orders_id_242, m6_.users_id AS users_id_243, m6_.account_worker_id AS account_worker_id_244, m6_.form_answer_id AS form_answer_id_245, m6_.job_id AS job_id_246, m6_.resize_img_parent_id AS resize_img_parent_id_247, m7_.product_id AS product_id_248, m7_.orders_id AS orders_id_249, m7_.users_id AS users_id_250, m7_.account_worker_id AS account_worker_id_251, m7_.form_answer_id AS form_answer_id_252, m7_.job_id AS job_id_253, m7_.resize_img_parent_id AS resize_img_parent_id_254 FROM products p0_ LEFT JOIN measurment_unit m1_ ON p0_.measurement_unit_id = m1_.id LEFT JOIN media_object m2_ ON p0_.id = m2_.product_id LEFT JOIN media_object m3_ ON m2_.id = m3_.resize_img_parent_id LEFT JOIN products p4_ ON p0_.translation_id = p4_.id LEFT JOIN products p5_ ON p0_.id = p5_.translation_id LEFT JOIN media_object m6_ ON p0_.main_media_id = m6_.id LEFT JOIN media_object m7_ ON m6_.id = m7_.resize_img_parent_id WHERE p0_.id = ?

Parameters:

[
  29150
]

View formatted query View runnable query Explain query

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,
  m2_.id AS id_61,
  m2_.upload_timestamp AS upload_timestamp_62,
  m2_.main AS main_63,
  m2_.file_path AS file_path_64,
  m2_.type AS type_65,
  m2_.name AS name_66,
  m2_.size AS size_67,
  m2_.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,
  p4_.id AS id_77,
  p4_.name AS name_78,
  p4_.date_entered AS date_entered_79,
  p4_.date_modified AS date_modified_80,
  p4_.description AS description_81,
  p4_.code1c AS code1c_82,
  p4_.barcode AS barcode_83,
  p4_.status AS status_84,
  p4_.price AS price_85,
  p4_.price_income AS price_income_86,
  p4_.mark_up AS mark_up_87,
  p4_.min_mark_up AS min_mark_up_88,
  p4_.packing_type AS packing_type_89,
  p4_.packing_type_count AS packing_type_count_90,
  p4_.discounts AS discounts_91,
  p4_.count_order AS count_order_92,
  p4_.product_to_order AS product_to_order_93,
  p4_.article AS article_94,
  p4_.nds AS nds_95,
  p4_.service AS service_96,
  p4_.transport_service AS transport_service_97,
  p4_.exise AS exise_98,
  p4_.expiration_date AS expiration_date_99,
  p4_.unit_volume AS unit_volume_100,
  p4_.net_weight AS net_weight_101,
  p4_.gross_weight AS gross_weight_102,
  p4_.go_by_weight AS go_by_weight_103,
  p4_.packaging AS packaging_104,
  p4_.old_code AS old_code_105,
  p4_.show AS show_106,
  p4_.balance AS balance_107,
  p4_.deleted AS deleted_108,
  p4_.category_cnt AS category_cnt_109,
  p4_.price_category AS price_category_110,
  p4_.is_salle AS is_salle_111,
  p4_.is_new AS is_new_112,
  p4_.is_top AS is_top_113,
  p4_.old_price AS old_price_114,
  p4_.discount_percent AS discount_percent_115,
  p4_.date_last_price_income AS date_last_price_income_116,
  p4_.video AS video_117,
  p4_.is_video AS is_video_118,
  p4_.is_free_shipping AS is_free_shipping_119,
  p4_.warranty_period AS warranty_period_120,
  p4_.min_balance AS min_balance_121,
  p4_.min_balance_admin AS min_balance_admin_122,
  p4_.main_category_id AS main_category_id_123,
  p4_.discontinued AS discontinued_124,
  p4_.seo_title AS seo_title_125,
  p4_.seo_description AS seo_description_126,
  p4_.salle_price AS salle_price_127,
  p4_.normal_price AS normal_price_128,
  p5_.id AS id_129,
  p5_.name AS name_130,
  p5_.date_entered AS date_entered_131,
  p5_.date_modified AS date_modified_132,
  p5_.description AS description_133,
  p5_.code1c AS code1c_134,
  p5_.barcode AS barcode_135,
  p5_.status AS status_136,
  p5_.price AS price_137,
  p5_.price_income AS price_income_138,
  p5_.mark_up AS mark_up_139,
  p5_.min_mark_up AS min_mark_up_140,
  p5_.packing_type AS packing_type_141,
  p5_.packing_type_count AS packing_type_count_142,
  p5_.discounts AS discounts_143,
  p5_.count_order AS count_order_144,
  p5_.product_to_order AS product_to_order_145,
  p5_.article AS article_146,
  p5_.nds AS nds_147,
  p5_.service AS service_148,
  p5_.transport_service AS transport_service_149,
  p5_.exise AS exise_150,
  p5_.expiration_date AS expiration_date_151,
  p5_.unit_volume AS unit_volume_152,
  p5_.net_weight AS net_weight_153,
  p5_.gross_weight AS gross_weight_154,
  p5_.go_by_weight AS go_by_weight_155,
  p5_.packaging AS packaging_156,
  p5_.old_code AS old_code_157,
  p5_.show AS show_158,
  p5_.balance AS balance_159,
  p5_.deleted AS deleted_160,
  p5_.category_cnt AS category_cnt_161,
  p5_.price_category AS price_category_162,
  p5_.is_salle AS is_salle_163,
  p5_.is_new AS is_new_164,
  p5_.is_top AS is_top_165,
  p5_.old_price AS old_price_166,
  p5_.discount_percent AS discount_percent_167,
  p5_.date_last_price_income AS date_last_price_income_168,
  p5_.video AS video_169,
  p5_.is_video AS is_video_170,
  p5_.is_free_shipping AS is_free_shipping_171,
  p5_.warranty_period AS warranty_period_172,
  p5_.min_balance AS min_balance_173,
  p5_.min_balance_admin AS min_balance_admin_174,
  p5_.main_category_id AS main_category_id_175,
  p5_.discontinued AS discontinued_176,
  p5_.seo_title AS seo_title_177,
  p5_.seo_description AS seo_description_178,
  p5_.salle_price AS salle_price_179,
  p5_.normal_price AS normal_price_180,
  m6_.id AS id_181,
  m6_.upload_timestamp AS upload_timestamp_182,
  m6_.main AS main_183,
  m6_.file_path AS file_path_184,
  m6_.type AS type_185,
  m6_.name AS name_186,
  m6_.size AS size_187,
  m6_.sort AS sort_188,
  m7_.id AS id_189,
  m7_.upload_timestamp AS upload_timestamp_190,
  m7_.main AS main_191,
  m7_.file_path AS file_path_192,
  m7_.type AS type_193,
  m7_.name AS name_194,
  m7_.size AS size_195,
  m7_.sort AS sort_196,
  p0_.modified_user_id AS modified_user_id_197,
  p0_.created_by_id AS created_by_id_198,
  p0_.measurement_unit_id AS measurement_unit_id_199,
  p0_.site_product_id AS site_product_id_200,
  p0_.storage_id AS storage_id_201,
  p0_.storage_element_id AS storage_element_id_202,
  p0_.language_id AS language_id_203,
  p0_.translation_id AS translation_id_204,
  p0_.main_media_id AS main_media_id_205,
  p0_.main_media_hover_id AS main_media_hover_id_206,
  m2_.product_id AS product_id_207,
  m2_.orders_id AS orders_id_208,
  m2_.users_id AS users_id_209,
  m2_.account_worker_id AS account_worker_id_210,
  m2_.form_answer_id AS form_answer_id_211,
  m2_.job_id AS job_id_212,
  m2_.resize_img_parent_id AS resize_img_parent_id_213,
  m3_.product_id AS product_id_214,
  m3_.orders_id AS orders_id_215,
  m3_.users_id AS users_id_216,
  m3_.account_worker_id AS account_worker_id_217,
  m3_.form_answer_id AS form_answer_id_218,
  m3_.job_id AS job_id_219,
  m3_.resize_img_parent_id AS resize_img_parent_id_220,
  p4_.modified_user_id AS modified_user_id_221,
  p4_.created_by_id AS created_by_id_222,
  p4_.measurement_unit_id AS measurement_unit_id_223,
  p4_.site_product_id AS site_product_id_224,
  p4_.storage_id AS storage_id_225,
  p4_.storage_element_id AS storage_element_id_226,
  p4_.language_id AS language_id_227,
  p4_.translation_id AS translation_id_228,
  p4_.main_media_id AS main_media_id_229,
  p4_.main_media_hover_id AS main_media_hover_id_230,
  p5_.modified_user_id AS modified_user_id_231,
  p5_.created_by_id AS created_by_id_232,
  p5_.measurement_unit_id AS measurement_unit_id_233,
  p5_.site_product_id AS site_product_id_234,
  p5_.storage_id AS storage_id_235,
  p5_.storage_element_id AS storage_element_id_236,
  p5_.language_id AS language_id_237,
  p5_.translation_id AS translation_id_238,
  p5_.main_media_id AS main_media_id_239,
  p5_.main_media_hover_id AS main_media_hover_id_240,
  m6_.product_id AS product_id_241,
  m6_.orders_id AS orders_id_242,
  m6_.users_id AS users_id_243,
  m6_.account_worker_id AS account_worker_id_244,
  m6_.form_answer_id AS form_answer_id_245,
  m6_.job_id AS job_id_246,
  m6_.resize_img_parent_id AS resize_img_parent_id_247,
  m7_.product_id AS product_id_248,
  m7_.orders_id AS orders_id_249,
  m7_.users_id AS users_id_250,
  m7_.account_worker_id AS account_worker_id_251,
  m7_.form_answer_id AS form_answer_id_252,
  m7_.job_id AS job_id_253,
  m7_.resize_img_parent_id AS resize_img_parent_id_254
FROM
  products p0_
  LEFT JOIN measurment_unit m1_ ON p0_.measurement_unit_id = m1_.id
  LEFT JOIN media_object m2_ ON p0_.id = m2_.product_id
  LEFT JOIN media_object m3_ ON m2_.id = m3_.resize_img_parent_id
  LEFT JOIN products p4_ ON p0_.translation_id = p4_.id
  LEFT JOIN products p5_ ON p0_.id = p5_.translation_id
  LEFT JOIN media_object m6_ ON p0_.main_media_id = m6_.id
  LEFT JOIN media_object m7_ ON m6_.id = m7_.resize_img_parent_id
WHERE
  p0_.id = ?

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, m2_.id AS id_61, m2_.upload_timestamp AS upload_timestamp_62, m2_.main AS main_63, m2_.file_path AS file_path_64, m2_.type AS type_65, m2_.name AS name_66, m2_.size AS size_67, m2_.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, p4_.id AS id_77, p4_.name AS name_78, p4_.date_entered AS date_entered_79, p4_.date_modified AS date_modified_80, p4_.description AS description_81, p4_.code1c AS code1c_82, p4_.barcode AS barcode_83, p4_.status AS status_84, p4_.price AS price_85, p4_.price_income AS price_income_86, p4_.mark_up AS mark_up_87, p4_.min_mark_up AS min_mark_up_88, p4_.packing_type AS packing_type_89, p4_.packing_type_count AS packing_type_count_90, p4_.discounts AS discounts_91, p4_.count_order AS count_order_92, p4_.product_to_order AS product_to_order_93, p4_.article AS article_94, p4_.nds AS nds_95, p4_.service AS service_96, p4_.transport_service AS transport_service_97, p4_.exise AS exise_98, p4_.expiration_date AS expiration_date_99, p4_.unit_volume AS unit_volume_100, p4_.net_weight AS net_weight_101, p4_.gross_weight AS gross_weight_102, p4_.go_by_weight AS go_by_weight_103, p4_.packaging AS packaging_104, p4_.old_code AS old_code_105, p4_.show AS show_106, p4_.balance AS balance_107, p4_.deleted AS deleted_108, p4_.category_cnt AS category_cnt_109, p4_.price_category AS price_category_110, p4_.is_salle AS is_salle_111, p4_.is_new AS is_new_112, p4_.is_top AS is_top_113, p4_.old_price AS old_price_114, p4_.discount_percent AS discount_percent_115, p4_.date_last_price_income AS date_last_price_income_116, p4_.video AS video_117, p4_.is_video AS is_video_118, p4_.is_free_shipping AS is_free_shipping_119, p4_.warranty_period AS warranty_period_120, p4_.min_balance AS min_balance_121, p4_.min_balance_admin AS min_balance_admin_122, p4_.main_category_id AS main_category_id_123, p4_.discontinued AS discontinued_124, p4_.seo_title AS seo_title_125, p4_.seo_description AS seo_description_126, p4_.salle_price AS salle_price_127, p4_.normal_price AS normal_price_128, p5_.id AS id_129, p5_.name AS name_130, p5_.date_entered AS date_entered_131, p5_.date_modified AS date_modified_132, p5_.description AS description_133, p5_.code1c AS code1c_134, p5_.barcode AS barcode_135, p5_.status AS status_136, p5_.price AS price_137, p5_.price_income AS price_income_138, p5_.mark_up AS mark_up_139, p5_.min_mark_up AS min_mark_up_140, p5_.packing_type AS packing_type_141, p5_.packing_type_count AS packing_type_count_142, p5_.discounts AS discounts_143, p5_.count_order AS count_order_144, p5_.product_to_order AS product_to_order_145, p5_.article AS article_146, p5_.nds AS nds_147, p5_.service AS service_148, p5_.transport_service AS transport_service_149, p5_.exise AS exise_150, p5_.expiration_date AS expiration_date_151, p5_.unit_volume AS unit_volume_152, p5_.net_weight AS net_weight_153, p5_.gross_weight AS gross_weight_154, p5_.go_by_weight AS go_by_weight_155, p5_.packaging AS packaging_156, p5_.old_code AS old_code_157, p5_.show AS show_158, p5_.balance AS balance_159, p5_.deleted AS deleted_160, p5_.category_cnt AS category_cnt_161, p5_.price_category AS price_category_162, p5_.is_salle AS is_salle_163, p5_.is_new AS is_new_164, p5_.is_top AS is_top_165, p5_.old_price AS old_price_166, p5_.discount_percent AS discount_percent_167, p5_.date_last_price_income AS date_last_price_income_168, p5_.video AS video_169, p5_.is_video AS is_video_170, p5_.is_free_shipping AS is_free_shipping_171, p5_.warranty_period AS warranty_period_172, p5_.min_balance AS min_balance_173, p5_.min_balance_admin AS min_balance_admin_174, p5_.main_category_id AS main_category_id_175, p5_.discontinued AS discontinued_176, p5_.seo_title AS seo_title_177, p5_.seo_description AS seo_description_178, p5_.salle_price AS salle_price_179, p5_.normal_price AS normal_price_180, m6_.id AS id_181, m6_.upload_timestamp AS upload_timestamp_182, m6_.main AS main_183, m6_.file_path AS file_path_184, m6_.type AS type_185, m6_.name AS name_186, m6_.size AS size_187, m6_.sort AS sort_188, m7_.id AS id_189, m7_.upload_timestamp AS upload_timestamp_190, m7_.main AS main_191, m7_.file_path AS file_path_192, m7_.type AS type_193, m7_.name AS name_194, m7_.size AS size_195, m7_.sort AS sort_196, p0_.modified_user_id AS modified_user_id_197, p0_.created_by_id AS created_by_id_198, p0_.measurement_unit_id AS measurement_unit_id_199, p0_.site_product_id AS site_product_id_200, p0_.storage_id AS storage_id_201, p0_.storage_element_id AS storage_element_id_202, p0_.language_id AS language_id_203, p0_.translation_id AS translation_id_204, p0_.main_media_id AS main_media_id_205, p0_.main_media_hover_id AS main_media_hover_id_206, m2_.product_id AS product_id_207, m2_.orders_id AS orders_id_208, m2_.users_id AS users_id_209, m2_.account_worker_id AS account_worker_id_210, m2_.form_answer_id AS form_answer_id_211, m2_.job_id AS job_id_212, m2_.resize_img_parent_id AS resize_img_parent_id_213, m3_.product_id AS product_id_214, m3_.orders_id AS orders_id_215, m3_.users_id AS users_id_216, m3_.account_worker_id AS account_worker_id_217, m3_.form_answer_id AS form_answer_id_218, m3_.job_id AS job_id_219, m3_.resize_img_parent_id AS resize_img_parent_id_220, p4_.modified_user_id AS modified_user_id_221, p4_.created_by_id AS created_by_id_222, p4_.measurement_unit_id AS measurement_unit_id_223, p4_.site_product_id AS site_product_id_224, p4_.storage_id AS storage_id_225, p4_.storage_element_id AS storage_element_id_226, p4_.language_id AS language_id_227, p4_.translation_id AS translation_id_228, p4_.main_media_id AS main_media_id_229, p4_.main_media_hover_id AS main_media_hover_id_230, p5_.modified_user_id AS modified_user_id_231, p5_.created_by_id AS created_by_id_232, p5_.measurement_unit_id AS measurement_unit_id_233, p5_.site_product_id AS site_product_id_234, p5_.storage_id AS storage_id_235, p5_.storage_element_id AS storage_element_id_236, p5_.language_id AS language_id_237, p5_.translation_id AS translation_id_238, p5_.main_media_id AS main_media_id_239, p5_.main_media_hover_id AS main_media_hover_id_240, m6_.product_id AS product_id_241, m6_.orders_id AS orders_id_242, m6_.users_id AS users_id_243, m6_.account_worker_id AS account_worker_id_244, m6_.form_answer_id AS form_answer_id_245, m6_.job_id AS job_id_246, m6_.resize_img_parent_id AS resize_img_parent_id_247, m7_.product_id AS product_id_248, m7_.orders_id AS orders_id_249, m7_.users_id AS users_id_250, m7_.account_worker_id AS account_worker_id_251, m7_.form_answer_id AS form_answer_id_252, m7_.job_id AS job_id_253, m7_.resize_img_parent_id AS resize_img_parent_id_254 FROM products p0_ LEFT JOIN measurment_unit m1_ ON p0_.measurement_unit_id = m1_.id LEFT JOIN media_object m2_ ON p0_.id = m2_.product_id LEFT JOIN media_object m3_ ON m2_.id = m3_.resize_img_parent_id LEFT JOIN products p4_ ON p0_.translation_id = p4_.id LEFT JOIN products p5_ ON p0_.id = p5_.translation_id LEFT JOIN media_object m6_ ON p0_.main_media_id = m6_.id LEFT JOIN media_object m7_ ON m6_.id = m7_.resize_img_parent_id WHERE p0_.id = 29150;

4.64 ms
(40.03%)

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:

[
  9426
]

View formatted query View runnable query Explain query

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 = ?

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 = 9426;

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	46
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	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\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	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\Objects	No errors.
App\Entity\Projects	No errors.
App\Entity\Posts	No errors.

Symfony Profiler

GET http://api-felso.inneti.net/api/products/29150?g%5B0%5D=product%3Aread&g%5B1%5D=product%3Amedia

Configuration Settings

Theme

Page Width