Symfony Profiler

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.updated_at AS updated_at_1,
  p0_.promoted AS promoted_2
FROM
  product p0_
  INNER JOIN product_category p2_ ON p0_.id = p2_.product_id
  INNER JOIN category c1_ ON c1_.id = p2_.category_id
WHERE
  c1_.slug LIKE CONCAT('%', ?, '%')
  AND p0_.public = ?
ORDER BY
  p0_.updated_at DESC,
  p0_.promoted DESC
LIMIT
  30

SELECT DISTINCT p0_.id AS id_0, p0_.updated_at AS updated_at_1, p0_.promoted AS promoted_2 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.slug LIKE CONCAT('%', 'szkodniki-1', '%') AND p0_.public = 1 ORDER BY p0_.updated_at DESC, p0_.promoted DESC LIMIT 30;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.descr AS descr_2,
  p0_.short AS short_3,
  p0_.youtube AS youtube_4,
  p0_.search_keywords AS search_keywords_5,
  p0_.public AS public_6,
  p0_.title AS title_7,
  p0_.description AS description_8,
  p0_.created_at AS created_at_9,
  p0_.updated_at AS updated_at_10,
  p0_.slug AS slug_11,
  p0_.promoted AS promoted_12,
  p0_.t1_variety_name AS t1_variety_name_13,
  p0_.t1_farmer AS t1_farmer_14,
  p0_.t1_variety_type AS t1_variety_type_15,
  p0_.t1_registry_country AS t1_registry_country_16,
  p0_.t1_short_description AS t1_short_description_17,
  p0_.t1_usable_value AS t1_usable_value_18,
  p0_.t1_agronomy_profile AS t1_agronomy_profile_19,
  p0_.t1_cobor_link AS t1_cobor_link_20,
  p0_.t2_variety_name AS t2_variety_name_21,
  p0_.t2_fao AS t2_fao_22,
  p0_.t2_farmer AS t2_farmer_23,
  p0_.t2_registry_country AS t2_registry_country_24,
  p0_.t2_variety_type AS t2_variety_type_25,
  p0_.t2_short_description AS t2_short_description_26,
  p0_.t2_flask_image AS t2_flask_image_27,
  p0_.t2_flask_section AS t2_flask_section_28,
  p0_.t2_grain_section AS t2_grain_section_29,
  p0_.t2_suggested_use AS t2_suggested_use_30,
  p0_.t2_recommendations AS t2_recommendations_31,
  p0_.t2_description AS t2_description_32,
  p0_.t2_cobor_link AS t2_cobor_link_33,
  p0_.t2_farmer_recommendation AS t2_farmer_recommendation_34,
  p0_.t2_cobor AS t2_cobor_35,
  p0_.t2_chart AS t2_chart_36,
  p0_.t2_soil_requirements AS t2_soil_requirements_37,
  p0_.t3_type AS t3_type_38,
  p0_.t3_variety_name AS t3_variety_name_39,
  p0_.t3_quality_class AS t3_quality_class_40,
  p0_.t3_short_description AS t3_short_description_41,
  p0_.t3_registry_country AS t3_registry_country_42,
  p0_.t3_description AS t3_description_43,
  p0_.t3_description2 AS t3_description2_44,
  p0_.t3_description3 AS t3_description3_45,
  p0_.t3_cobor_link AS t3_cobor_link_46,
  p0_.t4_product_name AS t4_product_name_47,
  p0_.t4_product_type AS t4_product_type_48,
  p0_.t4_formulation AS t4_formulation_49,
  p0_.t4_permit_number AS t4_permit_number_50,
  p0_.t4_info_image AS t4_info_image_51,
  p0_.t4_application AS t4_application_52,
  p0_.t4_action_description AS t4_action_description_53,
  p0_.t4_recommended_dose AS t4_recommended_dose_54,
  p0_.t4_date_of_application AS t4_date_of_application_55,
  p0_.t4_recommended_treatment AS t4_recommended_treatment_56,
  p0_.t4_treatment_number AS t4_treatment_number_57,
  p0_.t4_active_ingredient AS t4_active_ingredient_58,
  p0_.t4_available_package AS t4_available_package_59,
  p0_.t4_kind_of_threat AS t4_kind_of_threat_60,
  p0_.t4_safe_use AS t4_safe_use_61,
  p0_.t4_safe_use_pikto AS t4_safe_use_pikto_62,
  p0_.t4_technology AS t4_technology_63,
  p0_.t4_link AS t4_link_64,
  p0_.t4_advertisment AS t4_advertisment_65,
  p0_.t4_legal_info AS t4_legal_info_66,
  p0_.t4_prize AS t4_prize_67,
  p0_.t5_trade_name AS t5_trade_name_68,
  p0_.t5_chemical_name AS t5_chemical_name_69,
  p0_.t5_formula AS t5_formula_70,
  p0_.t5_ingredients AS t5_ingredients_71,
  p0_.t5_pkwiu_number AS t5_pkwiu_number_72,
  p0_.t5_cn_number AS t5_cn_number_73,
  p0_.t5_description AS t5_description_74,
  p0_.t5_image AS t5_image_75,
  p0_.t6_name AS t6_name_76,
  p0_.t6_type AS t6_type_77,
  p0_.t6_short_description AS t6_short_description_78,
  p0_.t6_short_description2 AS t6_short_description2_79,
  p0_.t6_description AS t6_description_80,
  p0_.t6_condition AS t6_condition_81,
  p0_.t7_product_name AS t7_product_name_82,
  p0_.t7_product_type AS t7_product_type_83,
  p0_.t7_safe_use AS t7_safe_use_84,
  p0_.t1_recommendations AS t1_recommendations_85,
  p0_.t4_product_features AS t4_product_features_86,
  p0_.t4_combated_pests AS t4_combated_pests_87,
  p0_.producer_name AS producer_name_88,
  p0_.download AS download_89,
  p0_.new AS new_90,
  p0_.kurka_available AS kurka_available_91,
  p0_.t7_short_description AS t7_short_description_92,
  p0_.t3_chart AS t3_chart_93,
  p0_.filter_quality_class AS filter_quality_class_94,
  p0_.filter_soil_requirements AS filter_soil_requirements_95,
  p0_.filter_fao AS filter_fao_96,
  p0_.filter_suggested_use AS filter_suggested_use_97,
  p0_.filter_brand AS filter_brand_98,
  p0_.filter_type AS filter_type_99,
  p0_.filter_type2 AS filter_type2_100,
  p0_.filter_type3 AS filter_type3_101,
  p0_.filter_fertilizer_type AS filter_fertilizer_type_102,
  p0_.show_description AS show_description_103,
  p0_.link AS link_104,
  p0_.type_id AS type_id_105,
  p0_.producer_image_id AS producer_image_id_106,
  p0_.packshot_id AS packshot_id_107,
  p0_.author_id AS author_id_108
FROM
  product p0_
  INNER JOIN product_category p2_ ON p0_.id = p2_.product_id
  INNER JOIN category c1_ ON c1_.id = p2_.category_id
WHERE
  c1_.slug LIKE CONCAT('%', ?, '%')
  AND p0_.public = ?
  AND p0_.id IN (?, ?, ?)
ORDER BY
  p0_.updated_at DESC,
  p0_.promoted DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.descr AS descr_2, p0_.short AS short_3, p0_.youtube AS youtube_4, p0_.search_keywords AS search_keywords_5, p0_.public AS public_6, p0_.title AS title_7, p0_.description AS description_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.slug AS slug_11, p0_.promoted AS promoted_12, p0_.t1_variety_name AS t1_variety_name_13, p0_.t1_farmer AS t1_farmer_14, p0_.t1_variety_type AS t1_variety_type_15, p0_.t1_registry_country AS t1_registry_country_16, p0_.t1_short_description AS t1_short_description_17, p0_.t1_usable_value AS t1_usable_value_18, p0_.t1_agronomy_profile AS t1_agronomy_profile_19, p0_.t1_cobor_link AS t1_cobor_link_20, p0_.t2_variety_name AS t2_variety_name_21, p0_.t2_fao AS t2_fao_22, p0_.t2_farmer AS t2_farmer_23, p0_.t2_registry_country AS t2_registry_country_24, p0_.t2_variety_type AS t2_variety_type_25, p0_.t2_short_description AS t2_short_description_26, p0_.t2_flask_image AS t2_flask_image_27, p0_.t2_flask_section AS t2_flask_section_28, p0_.t2_grain_section AS t2_grain_section_29, p0_.t2_suggested_use AS t2_suggested_use_30, p0_.t2_recommendations AS t2_recommendations_31, p0_.t2_description AS t2_description_32, p0_.t2_cobor_link AS t2_cobor_link_33, p0_.t2_farmer_recommendation AS t2_farmer_recommendation_34, p0_.t2_cobor AS t2_cobor_35, p0_.t2_chart AS t2_chart_36, p0_.t2_soil_requirements AS t2_soil_requirements_37, p0_.t3_type AS t3_type_38, p0_.t3_variety_name AS t3_variety_name_39, p0_.t3_quality_class AS t3_quality_class_40, p0_.t3_short_description AS t3_short_description_41, p0_.t3_registry_country AS t3_registry_country_42, p0_.t3_description AS t3_description_43, p0_.t3_description2 AS t3_description2_44, p0_.t3_description3 AS t3_description3_45, p0_.t3_cobor_link AS t3_cobor_link_46, p0_.t4_product_name AS t4_product_name_47, p0_.t4_product_type AS t4_product_type_48, p0_.t4_formulation AS t4_formulation_49, p0_.t4_permit_number AS t4_permit_number_50, p0_.t4_info_image AS t4_info_image_51, p0_.t4_application AS t4_application_52, p0_.t4_action_description AS t4_action_description_53, p0_.t4_recommended_dose AS t4_recommended_dose_54, p0_.t4_date_of_application AS t4_date_of_application_55, p0_.t4_recommended_treatment AS t4_recommended_treatment_56, p0_.t4_treatment_number AS t4_treatment_number_57, p0_.t4_active_ingredient AS t4_active_ingredient_58, p0_.t4_available_package AS t4_available_package_59, p0_.t4_kind_of_threat AS t4_kind_of_threat_60, p0_.t4_safe_use AS t4_safe_use_61, p0_.t4_safe_use_pikto AS t4_safe_use_pikto_62, p0_.t4_technology AS t4_technology_63, p0_.t4_link AS t4_link_64, p0_.t4_advertisment AS t4_advertisment_65, p0_.t4_legal_info AS t4_legal_info_66, p0_.t4_prize AS t4_prize_67, p0_.t5_trade_name AS t5_trade_name_68, p0_.t5_chemical_name AS t5_chemical_name_69, p0_.t5_formula AS t5_formula_70, p0_.t5_ingredients AS t5_ingredients_71, p0_.t5_pkwiu_number AS t5_pkwiu_number_72, p0_.t5_cn_number AS t5_cn_number_73, p0_.t5_description AS t5_description_74, p0_.t5_image AS t5_image_75, p0_.t6_name AS t6_name_76, p0_.t6_type AS t6_type_77, p0_.t6_short_description AS t6_short_description_78, p0_.t6_short_description2 AS t6_short_description2_79, p0_.t6_description AS t6_description_80, p0_.t6_condition AS t6_condition_81, p0_.t7_product_name AS t7_product_name_82, p0_.t7_product_type AS t7_product_type_83, p0_.t7_safe_use AS t7_safe_use_84, p0_.t1_recommendations AS t1_recommendations_85, p0_.t4_product_features AS t4_product_features_86, p0_.t4_combated_pests AS t4_combated_pests_87, p0_.producer_name AS producer_name_88, p0_.download AS download_89, p0_.new AS new_90, p0_.kurka_available AS kurka_available_91, p0_.t7_short_description AS t7_short_description_92, p0_.t3_chart AS t3_chart_93, p0_.filter_quality_class AS filter_quality_class_94, p0_.filter_soil_requirements AS filter_soil_requirements_95, p0_.filter_fao AS filter_fao_96, p0_.filter_suggested_use AS filter_suggested_use_97, p0_.filter_brand AS filter_brand_98, p0_.filter_type AS filter_type_99, p0_.filter_type2 AS filter_type2_100, p0_.filter_type3 AS filter_type3_101, p0_.filter_fertilizer_type AS filter_fertilizer_type_102, p0_.show_description AS show_description_103, p0_.link AS link_104, p0_.type_id AS type_id_105, p0_.producer_image_id AS producer_image_id_106, p0_.packshot_id AS packshot_id_107, p0_.author_id AS author_id_108 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.slug LIKE CONCAT('%', 'szkodniki-1', '%') AND p0_.public = 1 AND p0_.id IN ('587', '316', '4') ORDER BY p0_.updated_at DESC, p0_.promoted DESC;

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2
FROM
  media_object t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2 FROM media_object t0 WHERE t0.id = 5949;

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2
FROM
  media_object t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2 FROM media_object t0 WHERE t0.id = 5802;

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2
FROM
  media_object t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2 FROM media_object t0 WHERE t0.id = 5801;

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2
FROM
  media_object t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2 FROM media_object t0 WHERE t0.id = 1104;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.slug AS slug_6
FROM
  product_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.slug AS slug_6 FROM product_type t0 WHERE t0.id = '4';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short AS short_3,
  t0.public AS public_4,
  t0.slug AS slug_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.type AS type_8,
  t0.lft AS lft_9,
  t0.lvl AS lvl_10,
  t0.rgt AS rgt_11,
  t0.position AS position_12,
  t0.show_in_footer AS show_in_footer_13,
  t0.author_id AS author_id_14,
  t0.tree_root AS tree_root_15,
  t0.parent_id AS parent_id_16,
  t0.image_id AS image_id_17
FROM
  category t0
  INNER JOIN product_category ON t0.id = product_category.category_id
WHERE
  product_category.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short AS short_3, t0.public AS public_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type AS type_8, t0.lft AS lft_9, t0.lvl AS lvl_10, t0.rgt AS rgt_11, t0.position AS position_12, t0.show_in_footer AS show_in_footer_13, t0.author_id AS author_id_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = '587';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3
FROM
  filter_use t0
  INNER JOIN product_filter_use ON t0.id = product_filter_use.filter_use_id
WHERE
  product_filter_use.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3 FROM filter_use t0 INNER JOIN product_filter_use ON t0.id = product_filter_use.filter_use_id WHERE product_filter_use.product_id = '587';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.descr AS descr_3,
  t0.short AS short_4,
  t0.youtube AS youtube_5,
  t0.search_keywords AS search_keywords_6,
  t0.public AS public_7,
  t0.title AS title_8,
  t0.description AS description_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.slug AS slug_12,
  t0.promoted AS promoted_13,
  t0.t1_variety_name AS t1_variety_name_14,
  t0.t1_farmer AS t1_farmer_15,
  t0.t1_variety_type AS t1_variety_type_16,
  t0.t1_registry_country AS t1_registry_country_17,
  t0.t1_short_description AS t1_short_description_18,
  t0.t1_usable_value AS t1_usable_value_19,
  t0.t1_agronomy_profile AS t1_agronomy_profile_20,
  t0.t1_cobor_link AS t1_cobor_link_21,
  t0.t2_variety_name AS t2_variety_name_22,
  t0.t2_fao AS t2_fao_23,
  t0.t2_farmer AS t2_farmer_24,
  t0.t2_registry_country AS t2_registry_country_25,
  t0.t2_variety_type AS t2_variety_type_26,
  t0.t2_short_description AS t2_short_description_27,
  t0.t2_flask_image AS t2_flask_image_28,
  t0.t2_flask_section AS t2_flask_section_29,
  t0.t2_grain_section AS t2_grain_section_30,
  t0.t2_suggested_use AS t2_suggested_use_31,
  t0.t2_recommendations AS t2_recommendations_32,
  t0.t2_description AS t2_description_33,
  t0.t2_cobor_link AS t2_cobor_link_34,
  t0.t2_farmer_recommendation AS t2_farmer_recommendation_35,
  t0.t2_cobor AS t2_cobor_36,
  t0.t2_chart AS t2_chart_37,
  t0.t2_soil_requirements AS t2_soil_requirements_38,
  t0.t3_type AS t3_type_39,
  t0.t3_variety_name AS t3_variety_name_40,
  t0.t3_quality_class AS t3_quality_class_41,
  t0.t3_short_description AS t3_short_description_42,
  t0.t3_registry_country AS t3_registry_country_43,
  t0.t3_description AS t3_description_44,
  t0.t3_description2 AS t3_description2_45,
  t0.t3_description3 AS t3_description3_46,
  t0.t3_cobor_link AS t3_cobor_link_47,
  t0.t4_product_name AS t4_product_name_48,
  t0.t4_product_type AS t4_product_type_49,
  t0.t4_formulation AS t4_formulation_50,
  t0.t4_permit_number AS t4_permit_number_51,
  t0.t4_info_image AS t4_info_image_52,
  t0.t4_application AS t4_application_53,
  t0.t4_action_description AS t4_action_description_54,
  t0.t4_recommended_dose AS t4_recommended_dose_55,
  t0.t4_date_of_application AS t4_date_of_application_56,
  t0.t4_recommended_treatment AS t4_recommended_treatment_57,
  t0.t4_treatment_number AS t4_treatment_number_58,
  t0.t4_active_ingredient AS t4_active_ingredient_59,
  t0.t4_available_package AS t4_available_package_60,
  t0.t4_kind_of_threat AS t4_kind_of_threat_61,
  t0.t4_safe_use AS t4_safe_use_62,
  t0.t4_safe_use_pikto AS t4_safe_use_pikto_63,
  t0.t4_technology AS t4_technology_64,
  t0.t4_link AS t4_link_65,
  t0.t4_advertisment AS t4_advertisment_66,
  t0.t4_legal_info AS t4_legal_info_67,
  t0.t4_prize AS t4_prize_68,
  t0.t5_trade_name AS t5_trade_name_69,
  t0.t5_chemical_name AS t5_chemical_name_70,
  t0.t5_formula AS t5_formula_71,
  t0.t5_ingredients AS t5_ingredients_72,
  t0.t5_pkwiu_number AS t5_pkwiu_number_73,
  t0.t5_cn_number AS t5_cn_number_74,
  t0.t5_description AS t5_description_75,
  t0.t5_image AS t5_image_76,
  t0.t6_name AS t6_name_77,
  t0.t6_type AS t6_type_78,
  t0.t6_short_description AS t6_short_description_79,
  t0.t6_short_description2 AS t6_short_description2_80,
  t0.t6_description AS t6_description_81,
  t0.t6_condition AS t6_condition_82,
  t0.t7_product_name AS t7_product_name_83,
  t0.t7_product_type AS t7_product_type_84,
  t0.t7_safe_use AS t7_safe_use_85,
  t0.t1_recommendations AS t1_recommendations_86,
  t0.t4_product_features AS t4_product_features_87,
  t0.t4_combated_pests AS t4_combated_pests_88,
  t0.producer_name AS producer_name_89,
  t0.download AS download_90,
  t0.new AS new_91,
  t0.kurka_available AS kurka_available_92,
  t0.t7_short_description AS t7_short_description_93,
  t0.t3_chart AS t3_chart_94,
  t0.filter_quality_class AS filter_quality_class_95,
  t0.filter_soil_requirements AS filter_soil_requirements_96,
  t0.filter_fao AS filter_fao_97,
  t0.filter_suggested_use AS filter_suggested_use_98,
  t0.filter_brand AS filter_brand_99,
  t0.filter_type AS filter_type_100,
  t0.filter_type2 AS filter_type2_101,
  t0.filter_type3 AS filter_type3_102,
  t0.filter_fertilizer_type AS filter_fertilizer_type_103,
  t0.show_description AS show_description_104,
  t0.link AS link_105,
  t0.type_id AS type_id_106,
  t0.producer_image_id AS producer_image_id_107,
  t0.packshot_id AS packshot_id_108,
  t0.author_id AS author_id_109
FROM
  product t0
  INNER JOIN product_product ON t0.id = product_product.product_target
WHERE
  product_product.product_source = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.descr AS descr_3, t0.short AS short_4, t0.youtube AS youtube_5, t0.search_keywords AS search_keywords_6, t0.public AS public_7, t0.title AS title_8, t0.description AS description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.slug AS slug_12, t0.promoted AS promoted_13, t0.t1_variety_name AS t1_variety_name_14, t0.t1_farmer AS t1_farmer_15, t0.t1_variety_type AS t1_variety_type_16, t0.t1_registry_country AS t1_registry_country_17, t0.t1_short_description AS t1_short_description_18, t0.t1_usable_value AS t1_usable_value_19, t0.t1_agronomy_profile AS t1_agronomy_profile_20, t0.t1_cobor_link AS t1_cobor_link_21, t0.t2_variety_name AS t2_variety_name_22, t0.t2_fao AS t2_fao_23, t0.t2_farmer AS t2_farmer_24, t0.t2_registry_country AS t2_registry_country_25, t0.t2_variety_type AS t2_variety_type_26, t0.t2_short_description AS t2_short_description_27, t0.t2_flask_image AS t2_flask_image_28, t0.t2_flask_section AS t2_flask_section_29, t0.t2_grain_section AS t2_grain_section_30, t0.t2_suggested_use AS t2_suggested_use_31, t0.t2_recommendations AS t2_recommendations_32, t0.t2_description AS t2_description_33, t0.t2_cobor_link AS t2_cobor_link_34, t0.t2_farmer_recommendation AS t2_farmer_recommendation_35, t0.t2_cobor AS t2_cobor_36, t0.t2_chart AS t2_chart_37, t0.t2_soil_requirements AS t2_soil_requirements_38, t0.t3_type AS t3_type_39, t0.t3_variety_name AS t3_variety_name_40, t0.t3_quality_class AS t3_quality_class_41, t0.t3_short_description AS t3_short_description_42, t0.t3_registry_country AS t3_registry_country_43, t0.t3_description AS t3_description_44, t0.t3_description2 AS t3_description2_45, t0.t3_description3 AS t3_description3_46, t0.t3_cobor_link AS t3_cobor_link_47, t0.t4_product_name AS t4_product_name_48, t0.t4_product_type AS t4_product_type_49, t0.t4_formulation AS t4_formulation_50, t0.t4_permit_number AS t4_permit_number_51, t0.t4_info_image AS t4_info_image_52, t0.t4_application AS t4_application_53, t0.t4_action_description AS t4_action_description_54, t0.t4_recommended_dose AS t4_recommended_dose_55, t0.t4_date_of_application AS t4_date_of_application_56, t0.t4_recommended_treatment AS t4_recommended_treatment_57, t0.t4_treatment_number AS t4_treatment_number_58, t0.t4_active_ingredient AS t4_active_ingredient_59, t0.t4_available_package AS t4_available_package_60, t0.t4_kind_of_threat AS t4_kind_of_threat_61, t0.t4_safe_use AS t4_safe_use_62, t0.t4_safe_use_pikto AS t4_safe_use_pikto_63, t0.t4_technology AS t4_technology_64, t0.t4_link AS t4_link_65, t0.t4_advertisment AS t4_advertisment_66, t0.t4_legal_info AS t4_legal_info_67, t0.t4_prize AS t4_prize_68, t0.t5_trade_name AS t5_trade_name_69, t0.t5_chemical_name AS t5_chemical_name_70, t0.t5_formula AS t5_formula_71, t0.t5_ingredients AS t5_ingredients_72, t0.t5_pkwiu_number AS t5_pkwiu_number_73, t0.t5_cn_number AS t5_cn_number_74, t0.t5_description AS t5_description_75, t0.t5_image AS t5_image_76, t0.t6_name AS t6_name_77, t0.t6_type AS t6_type_78, t0.t6_short_description AS t6_short_description_79, t0.t6_short_description2 AS t6_short_description2_80, t0.t6_description AS t6_description_81, t0.t6_condition AS t6_condition_82, t0.t7_product_name AS t7_product_name_83, t0.t7_product_type AS t7_product_type_84, t0.t7_safe_use AS t7_safe_use_85, t0.t1_recommendations AS t1_recommendations_86, t0.t4_product_features AS t4_product_features_87, t0.t4_combated_pests AS t4_combated_pests_88, t0.producer_name AS producer_name_89, t0.download AS download_90, t0.new AS new_91, t0.kurka_available AS kurka_available_92, t0.t7_short_description AS t7_short_description_93, t0.t3_chart AS t3_chart_94, t0.filter_quality_class AS filter_quality_class_95, t0.filter_soil_requirements AS filter_soil_requirements_96, t0.filter_fao AS filter_fao_97, t0.filter_suggested_use AS filter_suggested_use_98, t0.filter_brand AS filter_brand_99, t0.filter_type AS filter_type_100, t0.filter_type2 AS filter_type2_101, t0.filter_type3 AS filter_type3_102, t0.filter_fertilizer_type AS filter_fertilizer_type_103, t0.show_description AS show_description_104, t0.link AS link_105, t0.type_id AS type_id_106, t0.producer_image_id AS producer_image_id_107, t0.packshot_id AS packshot_id_108, t0.author_id AS author_id_109 FROM product t0 INNER JOIN product_product ON t0.id = product_product.product_target WHERE product_product.product_source = '587';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short AS short_3,
  t0.public AS public_4,
  t0.slug AS slug_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.type AS type_8,
  t0.lft AS lft_9,
  t0.lvl AS lvl_10,
  t0.rgt AS rgt_11,
  t0.position AS position_12,
  t0.show_in_footer AS show_in_footer_13,
  t0.author_id AS author_id_14,
  t0.tree_root AS tree_root_15,
  t0.parent_id AS parent_id_16,
  t0.image_id AS image_id_17
FROM
  category t0
  INNER JOIN product_category ON t0.id = product_category.category_id
WHERE
  product_category.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short AS short_3, t0.public AS public_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type AS type_8, t0.lft AS lft_9, t0.lvl AS lvl_10, t0.rgt AS rgt_11, t0.position AS position_12, t0.show_in_footer AS show_in_footer_13, t0.author_id AS author_id_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = '316';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3
FROM
  filter_use t0
  INNER JOIN product_filter_use ON t0.id = product_filter_use.filter_use_id
WHERE
  product_filter_use.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3 FROM filter_use t0 INNER JOIN product_filter_use ON t0.id = product_filter_use.filter_use_id WHERE product_filter_use.product_id = '316';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.descr AS descr_3,
  t0.short AS short_4,
  t0.youtube AS youtube_5,
  t0.search_keywords AS search_keywords_6,
  t0.public AS public_7,
  t0.title AS title_8,
  t0.description AS description_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.slug AS slug_12,
  t0.promoted AS promoted_13,
  t0.t1_variety_name AS t1_variety_name_14,
  t0.t1_farmer AS t1_farmer_15,
  t0.t1_variety_type AS t1_variety_type_16,
  t0.t1_registry_country AS t1_registry_country_17,
  t0.t1_short_description AS t1_short_description_18,
  t0.t1_usable_value AS t1_usable_value_19,
  t0.t1_agronomy_profile AS t1_agronomy_profile_20,
  t0.t1_cobor_link AS t1_cobor_link_21,
  t0.t2_variety_name AS t2_variety_name_22,
  t0.t2_fao AS t2_fao_23,
  t0.t2_farmer AS t2_farmer_24,
  t0.t2_registry_country AS t2_registry_country_25,
  t0.t2_variety_type AS t2_variety_type_26,
  t0.t2_short_description AS t2_short_description_27,
  t0.t2_flask_image AS t2_flask_image_28,
  t0.t2_flask_section AS t2_flask_section_29,
  t0.t2_grain_section AS t2_grain_section_30,
  t0.t2_suggested_use AS t2_suggested_use_31,
  t0.t2_recommendations AS t2_recommendations_32,
  t0.t2_description AS t2_description_33,
  t0.t2_cobor_link AS t2_cobor_link_34,
  t0.t2_farmer_recommendation AS t2_farmer_recommendation_35,
  t0.t2_cobor AS t2_cobor_36,
  t0.t2_chart AS t2_chart_37,
  t0.t2_soil_requirements AS t2_soil_requirements_38,
  t0.t3_type AS t3_type_39,
  t0.t3_variety_name AS t3_variety_name_40,
  t0.t3_quality_class AS t3_quality_class_41,
  t0.t3_short_description AS t3_short_description_42,
  t0.t3_registry_country AS t3_registry_country_43,
  t0.t3_description AS t3_description_44,
  t0.t3_description2 AS t3_description2_45,
  t0.t3_description3 AS t3_description3_46,
  t0.t3_cobor_link AS t3_cobor_link_47,
  t0.t4_product_name AS t4_product_name_48,
  t0.t4_product_type AS t4_product_type_49,
  t0.t4_formulation AS t4_formulation_50,
  t0.t4_permit_number AS t4_permit_number_51,
  t0.t4_info_image AS t4_info_image_52,
  t0.t4_application AS t4_application_53,
  t0.t4_action_description AS t4_action_description_54,
  t0.t4_recommended_dose AS t4_recommended_dose_55,
  t0.t4_date_of_application AS t4_date_of_application_56,
  t0.t4_recommended_treatment AS t4_recommended_treatment_57,
  t0.t4_treatment_number AS t4_treatment_number_58,
  t0.t4_active_ingredient AS t4_active_ingredient_59,
  t0.t4_available_package AS t4_available_package_60,
  t0.t4_kind_of_threat AS t4_kind_of_threat_61,
  t0.t4_safe_use AS t4_safe_use_62,
  t0.t4_safe_use_pikto AS t4_safe_use_pikto_63,
  t0.t4_technology AS t4_technology_64,
  t0.t4_link AS t4_link_65,
  t0.t4_advertisment AS t4_advertisment_66,
  t0.t4_legal_info AS t4_legal_info_67,
  t0.t4_prize AS t4_prize_68,
  t0.t5_trade_name AS t5_trade_name_69,
  t0.t5_chemical_name AS t5_chemical_name_70,
  t0.t5_formula AS t5_formula_71,
  t0.t5_ingredients AS t5_ingredients_72,
  t0.t5_pkwiu_number AS t5_pkwiu_number_73,
  t0.t5_cn_number AS t5_cn_number_74,
  t0.t5_description AS t5_description_75,
  t0.t5_image AS t5_image_76,
  t0.t6_name AS t6_name_77,
  t0.t6_type AS t6_type_78,
  t0.t6_short_description AS t6_short_description_79,
  t0.t6_short_description2 AS t6_short_description2_80,
  t0.t6_description AS t6_description_81,
  t0.t6_condition AS t6_condition_82,
  t0.t7_product_name AS t7_product_name_83,
  t0.t7_product_type AS t7_product_type_84,
  t0.t7_safe_use AS t7_safe_use_85,
  t0.t1_recommendations AS t1_recommendations_86,
  t0.t4_product_features AS t4_product_features_87,
  t0.t4_combated_pests AS t4_combated_pests_88,
  t0.producer_name AS producer_name_89,
  t0.download AS download_90,
  t0.new AS new_91,
  t0.kurka_available AS kurka_available_92,
  t0.t7_short_description AS t7_short_description_93,
  t0.t3_chart AS t3_chart_94,
  t0.filter_quality_class AS filter_quality_class_95,
  t0.filter_soil_requirements AS filter_soil_requirements_96,
  t0.filter_fao AS filter_fao_97,
  t0.filter_suggested_use AS filter_suggested_use_98,
  t0.filter_brand AS filter_brand_99,
  t0.filter_type AS filter_type_100,
  t0.filter_type2 AS filter_type2_101,
  t0.filter_type3 AS filter_type3_102,
  t0.filter_fertilizer_type AS filter_fertilizer_type_103,
  t0.show_description AS show_description_104,
  t0.link AS link_105,
  t0.type_id AS type_id_106,
  t0.producer_image_id AS producer_image_id_107,
  t0.packshot_id AS packshot_id_108,
  t0.author_id AS author_id_109
FROM
  product t0
  INNER JOIN product_product ON t0.id = product_product.product_target
WHERE
  product_product.product_source = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.descr AS descr_3, t0.short AS short_4, t0.youtube AS youtube_5, t0.search_keywords AS search_keywords_6, t0.public AS public_7, t0.title AS title_8, t0.description AS description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.slug AS slug_12, t0.promoted AS promoted_13, t0.t1_variety_name AS t1_variety_name_14, t0.t1_farmer AS t1_farmer_15, t0.t1_variety_type AS t1_variety_type_16, t0.t1_registry_country AS t1_registry_country_17, t0.t1_short_description AS t1_short_description_18, t0.t1_usable_value AS t1_usable_value_19, t0.t1_agronomy_profile AS t1_agronomy_profile_20, t0.t1_cobor_link AS t1_cobor_link_21, t0.t2_variety_name AS t2_variety_name_22, t0.t2_fao AS t2_fao_23, t0.t2_farmer AS t2_farmer_24, t0.t2_registry_country AS t2_registry_country_25, t0.t2_variety_type AS t2_variety_type_26, t0.t2_short_description AS t2_short_description_27, t0.t2_flask_image AS t2_flask_image_28, t0.t2_flask_section AS t2_flask_section_29, t0.t2_grain_section AS t2_grain_section_30, t0.t2_suggested_use AS t2_suggested_use_31, t0.t2_recommendations AS t2_recommendations_32, t0.t2_description AS t2_description_33, t0.t2_cobor_link AS t2_cobor_link_34, t0.t2_farmer_recommendation AS t2_farmer_recommendation_35, t0.t2_cobor AS t2_cobor_36, t0.t2_chart AS t2_chart_37, t0.t2_soil_requirements AS t2_soil_requirements_38, t0.t3_type AS t3_type_39, t0.t3_variety_name AS t3_variety_name_40, t0.t3_quality_class AS t3_quality_class_41, t0.t3_short_description AS t3_short_description_42, t0.t3_registry_country AS t3_registry_country_43, t0.t3_description AS t3_description_44, t0.t3_description2 AS t3_description2_45, t0.t3_description3 AS t3_description3_46, t0.t3_cobor_link AS t3_cobor_link_47, t0.t4_product_name AS t4_product_name_48, t0.t4_product_type AS t4_product_type_49, t0.t4_formulation AS t4_formulation_50, t0.t4_permit_number AS t4_permit_number_51, t0.t4_info_image AS t4_info_image_52, t0.t4_application AS t4_application_53, t0.t4_action_description AS t4_action_description_54, t0.t4_recommended_dose AS t4_recommended_dose_55, t0.t4_date_of_application AS t4_date_of_application_56, t0.t4_recommended_treatment AS t4_recommended_treatment_57, t0.t4_treatment_number AS t4_treatment_number_58, t0.t4_active_ingredient AS t4_active_ingredient_59, t0.t4_available_package AS t4_available_package_60, t0.t4_kind_of_threat AS t4_kind_of_threat_61, t0.t4_safe_use AS t4_safe_use_62, t0.t4_safe_use_pikto AS t4_safe_use_pikto_63, t0.t4_technology AS t4_technology_64, t0.t4_link AS t4_link_65, t0.t4_advertisment AS t4_advertisment_66, t0.t4_legal_info AS t4_legal_info_67, t0.t4_prize AS t4_prize_68, t0.t5_trade_name AS t5_trade_name_69, t0.t5_chemical_name AS t5_chemical_name_70, t0.t5_formula AS t5_formula_71, t0.t5_ingredients AS t5_ingredients_72, t0.t5_pkwiu_number AS t5_pkwiu_number_73, t0.t5_cn_number AS t5_cn_number_74, t0.t5_description AS t5_description_75, t0.t5_image AS t5_image_76, t0.t6_name AS t6_name_77, t0.t6_type AS t6_type_78, t0.t6_short_description AS t6_short_description_79, t0.t6_short_description2 AS t6_short_description2_80, t0.t6_description AS t6_description_81, t0.t6_condition AS t6_condition_82, t0.t7_product_name AS t7_product_name_83, t0.t7_product_type AS t7_product_type_84, t0.t7_safe_use AS t7_safe_use_85, t0.t1_recommendations AS t1_recommendations_86, t0.t4_product_features AS t4_product_features_87, t0.t4_combated_pests AS t4_combated_pests_88, t0.producer_name AS producer_name_89, t0.download AS download_90, t0.new AS new_91, t0.kurka_available AS kurka_available_92, t0.t7_short_description AS t7_short_description_93, t0.t3_chart AS t3_chart_94, t0.filter_quality_class AS filter_quality_class_95, t0.filter_soil_requirements AS filter_soil_requirements_96, t0.filter_fao AS filter_fao_97, t0.filter_suggested_use AS filter_suggested_use_98, t0.filter_brand AS filter_brand_99, t0.filter_type AS filter_type_100, t0.filter_type2 AS filter_type2_101, t0.filter_type3 AS filter_type3_102, t0.filter_fertilizer_type AS filter_fertilizer_type_103, t0.show_description AS show_description_104, t0.link AS link_105, t0.type_id AS type_id_106, t0.producer_image_id AS producer_image_id_107, t0.packshot_id AS packshot_id_108, t0.author_id AS author_id_109 FROM product t0 INNER JOIN product_product ON t0.id = product_product.product_target WHERE product_product.product_source = '316';