Symfony Profiler

Query Metrics

5 Database Queries

2 Different statements

3.98 ms Query time

3 Invalid entities

8 Managed entities

Grouped Statements

Show all queries

Time▼	Count	Info
3.35 ms (84.07%)	1	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.date_entered AS date_entered_2, p0_.date_modified AS date_modified_3, p0_.description AS description_4, p0_.code1c AS code1c_5, p0_.barcode AS barcode_6, p0_.status AS status_7, p0_.price AS price_8, p0_.price_income AS price_income_9, p0_.mark_up AS mark_up_10, p0_.min_mark_up AS min_mark_up_11, p0_.packing_type AS packing_type_12, p0_.packing_type_count AS packing_type_count_13, p0_.discounts AS discounts_14, p0_.count_order AS count_order_15, p0_.product_to_order AS product_to_order_16, p0_.article AS article_17, p0_.nds AS nds_18, p0_.service AS service_19, p0_.transport_service AS transport_service_20, p0_.exise AS exise_21, p0_.expiration_date AS expiration_date_22, p0_.unit_volume AS unit_volume_23, p0_.net_weight AS net_weight_24, p0_.gross_weight AS gross_weight_25, p0_.go_by_weight AS go_by_weight_26, p0_.packaging AS packaging_27, p0_.old_code AS old_code_28, p0_.show AS show_29, p0_.balance AS balance_30, p0_.deleted AS deleted_31, p0_.category_cnt AS category_cnt_32, p0_.price_category AS price_category_33, p0_.is_salle AS is_salle_34, p0_.is_new AS is_new_35, p0_.is_top AS is_top_36, p0_.old_price AS old_price_37, p0_.discount_percent AS discount_percent_38, p0_.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: [`29177`] 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, 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 = ? 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 = 29177;
0.63 ms (15.93%)	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: [`20267`] 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 = 20267;

Time▼

Count

Info

3.35 ms
(84.07%)

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:

[
  29177
]

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

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

0.63 ms
(15.93%)

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:

[
  20267
]

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

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	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/29177?g%25255B0%25255D%253Dproduct%25253Aread%2526g%25255B1%25255D%253Dproduct%25253Amedia%3D=

Configuration Settings

Theme

Page Width