Symfony Profiler

SELECT 
  c0_.id AS id_0, 
  c0_.name AS name_1, 
  c0_.hierarchy AS hierarchy_2, 
  c0_.slug AS slug_3, 
  c0_.short_description AS short_description_4, 
  c0_.description AS description_5, 
  c0_.created_at AS created_at_6, 
  c0_.updated_at AS updated_at_7, 
  c0_.created_by AS created_by_8, 
  c0_.updated_by AS updated_by_9, 
  c0_.site_id AS site_id_10, 
  c0_.pending_logs AS pending_logs_11, 
  c0_.pending AS pending_12, 
  c0_.version AS version_13, 
  c0_.net_amount AS net_amount_14, 
  c0_.gross_amount AS gross_amount_15, 
  c0_.tax_amount AS tax_amount_16, 
  c0_.currency_code AS currency_code_17, 
  c0_.deletable AS deletable_18, 
  c0_.deletable_at AS deletable_at_19, 
  c0_.editable AS editable_20, 
  c0_.editable_at AS editable_at_21, 
  c0_.parent_id AS parent_id_22, 
  c0_.enabled AS enabled_23, 
  c0_.meta_original_url AS meta_original_url_24, 
  c0_.meta_meta_description AS meta_meta_description_25, 
  c0_.meta_meta_keywords AS meta_meta_keywords_26, 
  c0_.meta_title AS meta_title_27, 
  c0_.meta_extra_properties AS meta_extra_properties_28, 
  c0_.meta_extra_names AS meta_extra_names_29, 
  c0_.meta_extra_http AS meta_extra_http_30, 
  c0_.meta_og_image AS meta_og_image_31, 
  c0_.series AS series_32, 
  c0_.promoted AS promoted_33, 
  c0_.subTitle AS subTitle_34, 
  c0_.slogan AS slogan_35, 
  c0_.excerpt AS excerpt_36, 
  c0_.label AS label_37, 
  c0_.layout_colour AS layout_colour_38, 
  c0_.unit AS unit_39, 
  c0_.extra_properties AS extra_properties_40, 
  c0_.standard_accessories AS standard_accessories_41, 
  c0_.videos AS videos_42, 
  c0_.shops AS shops_43, 
  c0_.published AS published_44, 
  c0_.display_counter AS display_counter_45, 
  c0_.shop_type AS shop_type_46, 
  c0_.priority AS priority_47, 
  c0_.position AS position_48, 
  c0_.route_id AS route_id_49, 
  c0_.tax_rate_id AS tax_rate_id_50, 
  c0_.category_id AS category_id_51, 
  c0_.brand_id AS brand_id_52, 
  c0_.photo_file_id AS photo_file_id_53, 
  c0_.deletable_by AS deletable_by_54, 
  c0_.editable_by AS editable_by_55 
FROM 
  catalog_products c0_ 
WHERE 
  (
    c0_.enabled = 1 
    AND c0_.slug IS NOT NULL 
    AND c0_.slug <> ''
  ) 
  AND (c0_.site_id = 'pl') 
ORDER BY 
  c0_.created_at DESC 
LIMIT 
  1000

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.hierarchy AS hierarchy_2, c0_.slug AS slug_3, c0_.short_description AS short_description_4, c0_.description AS description_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.created_by AS created_by_8, c0_.updated_by AS updated_by_9, c0_.site_id AS site_id_10, c0_.pending_logs AS pending_logs_11, c0_.pending AS pending_12, c0_.version AS version_13, c0_.net_amount AS net_amount_14, c0_.gross_amount AS gross_amount_15, c0_.tax_amount AS tax_amount_16, c0_.currency_code AS currency_code_17, c0_.deletable AS deletable_18, c0_.deletable_at AS deletable_at_19, c0_.editable AS editable_20, c0_.editable_at AS editable_at_21, c0_.parent_id AS parent_id_22, c0_.enabled AS enabled_23, c0_.meta_original_url AS meta_original_url_24, c0_.meta_meta_description AS meta_meta_description_25, c0_.meta_meta_keywords AS meta_meta_keywords_26, c0_.meta_title AS meta_title_27, c0_.meta_extra_properties AS meta_extra_properties_28, c0_.meta_extra_names AS meta_extra_names_29, c0_.meta_extra_http AS meta_extra_http_30, c0_.meta_og_image AS meta_og_image_31, c0_.series AS series_32, c0_.promoted AS promoted_33, c0_.subTitle AS subTitle_34, c0_.slogan AS slogan_35, c0_.excerpt AS excerpt_36, c0_.label AS label_37, c0_.layout_colour AS layout_colour_38, c0_.unit AS unit_39, c0_.extra_properties AS extra_properties_40, c0_.standard_accessories AS standard_accessories_41, c0_.videos AS videos_42, c0_.shops AS shops_43, c0_.published AS published_44, c0_.display_counter AS display_counter_45, c0_.shop_type AS shop_type_46, c0_.priority AS priority_47, c0_.position AS position_48, c0_.route_id AS route_id_49, c0_.tax_rate_id AS tax_rate_id_50, c0_.category_id AS category_id_51, c0_.brand_id AS brand_id_52, c0_.photo_file_id AS photo_file_id_53, c0_.deletable_by AS deletable_by_54, c0_.editable_by AS editable_by_55 FROM catalog_products c0_ WHERE (c0_.enabled = 1 AND c0_.slug IS NOT NULL AND c0_.slug <> '') AND (c0_.site_id = 'pl') ORDER BY c0_.created_at DESC LIMIT 1000;

SELECT 
  t1.id AS id_2, 
  t1.path AS path_3, 
  t1.site_id AS site_id_4, 
  t0.foreign_id AS foreign_id_5, 
  t1.type 
FROM 
  routes_product t0 
  INNER JOIN routes t1 ON t0.id = t1.id 
WHERE 
  t1.id = ?

SELECT t1.id AS id_2, t1.path AS path_3, t1.site_id AS site_id_4, t0.foreign_id AS foreign_id_5, t1.type FROM routes_product t0 INNER JOIN routes t1 ON t0.id = t1.id WHERE t1.id = 540;

SELECT 
  t1.id AS id_2, 
  t1.path AS path_3, 
  t1.site_id AS site_id_4, 
  t0.foreign_id AS foreign_id_5, 
  t1.type 
FROM 
  routes_product t0 
  INNER JOIN routes t1 ON t0.id = t1.id 
WHERE 
  t1.id = ?

SELECT t1.id AS id_2, t1.path AS path_3, t1.site_id AS site_id_4, t0.foreign_id AS foreign_id_5, t1.type FROM routes_product t0 INNER JOIN routes t1 ON t0.id = t1.id WHERE t1.id = 516;