Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iso_code AS iso_code_3,
  t0.display_name AS display_name_4,
  t0.is_active AS is_active_5
FROM
  language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.display_name AS display_name_4, t0.is_active AS is_active_5 FROM language t0 WHERE t0.id = '2';

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          f0_.id AS id_0,
          f0_.name AS name_1,
          f0_.sku AS sku_2,
          f0_.price AS price_3,
          f0_.images AS images_4,
          f0_.msrp AS msrp_5,
          f0_.discount AS discount_6,
          f0_.total_units AS total_units_7,
          f0_.package_units AS package_units_8,
          f0_.package_format AS package_format_9,
          f0_.is_cp AS is_cp_10,
          f0_.manifest AS manifest_11,
          f0_.weight AS weight_12,
          f0_.description AS description_13,
          f0_.sale_price AS sale_price_14,
          f0_.cost_price AS cost_price_15,
          f0_.calculated_price AS calculated_price_16,
          f0_.quantity_on_hand AS quantity_on_hand_17,
          f0_.quantity_pending AS quantity_pending_18,
          f0_.quantity_available AS quantity_available_19,
          f0_.track_inventory AS track_inventory_20,
          f0_.sort_order AS sort_order_21,
          f0_.is_visible AS is_visible_22,
          f0_.is_allow_purchase AS is_allow_purchase_23,
          f0_.product_availability AS product_availability_24,
          f0_.minimum_purchase_quantity AS minimum_purchase_quantity_25,
          f0_.maximum_purchase_quantity AS maximum_purchase_quantity_26,
          f0_.has_free_shipping AS has_free_shipping_27,
          f0_.fixed_shipping_price AS fixed_shipping_price_28,
          f0_.width AS width_29,
          f0_.height AS height_30,
          f0_.depth AS depth_31,
          f0_.brand AS brand_32,
          f0_.warranty AS warranty_33,
          f0_.show_product_condition AS show_product_condition_34,
          f0_.code AS code_35,
          f0_.tax_group AS tax_group_36,
          f0_.tax_provider_code AS tax_provider_code_37,
          f0_.search_keywords AS search_keywords_38,
          f0_.page_title AS page_title_39,
          f0_.meta_keywords AS meta_keywords_40,
          f0_.meta_description AS meta_description_41,
          f0_.slug AS slug_42,
          f0_.cost_per_unit AS cost_per_unit_43,
          f0_.is_overstock_lot AS is_overstock_lot_44,
          f0_.is_add_on_lot AS is_add_on_lot_45,
          f0_.is_price_drop AS is_price_drop_46,
          f0_.price_dropped_at AS price_dropped_at_47,
          f0_.published_at AS published_at_48,
          f0_.note AS note_49,
          f0_.is_listing_done AS is_listing_done_50,
          f0_.package_sizes AS package_sizes_51,
          f0_.is_truckload AS is_truckload_52,
          f0_.search_terms AS search_terms_53,
          f0_.created_at AS created_at_54,
          f0_.updated_at AS updated_at_55,
          f1_.id AS id_56,
          f1_.position AS position_57,
          f1_.description AS description_58,
          f1_.is_cover AS is_cover_59,
          u2_.id AS id_60,
          u2_.base_name AS base_name_61,
          u2_.file_name AS file_name_62,
          u2_.download_url AS download_url_63,
          u2_.needs_download AS needs_download_64,
          u2_.is_deleted AS is_deleted_65,
          u2_.has_download_error AS has_download_error_66,
          s3_.id AS id_67,
          s3_.name AS name_68,
          s3_.has_actions AS has_actions_69,
          s3_.has_validation AS has_validation_70,
          s3_.has_high_value AS has_high_value_71,
          s3_.is_active AS is_active_72,
          s3_.has_scrapper AS has_scrapper_73,
          s3_.sources_upc AS sources_upc_74,
          s3_.sources_merchant_sku AS sources_merchant_sku_75,
          s3_.sources_category AS sources_category_76,
          s3_.sources_name AS sources_name_77,
          s3_.sources_msrp AS sources_msrp_78,
          s3_.sources_photo AS sources_photo_79,
          s3_.sources_action AS sources_action_80,
          s3_.is_required_upc AS is_required_upc_81,
          s3_.is_required_merchant_sku AS is_required_merchant_sku_82,
          s3_.is_required_category AS is_required_category_83,
          s3_.is_required_name AS is_required_name_84,
          s3_.is_required_msrp AS is_required_msrp_85,
          s3_.is_required_photo AS is_required_photo_86,
          s3_.is_required_action AS is_required_action_87,
          s3_.public_name AS public_name_88,
          s3_.is_deleted AS is_deleted_89,
          s3_.product_generic_link AS product_generic_link_90,
          s3_.billing_name AS billing_name_91,
          s3_.billing_address AS billing_address_92,
          s3_.tax_name1 AS tax_name1_93,
          s3_.tax_rate1 AS tax_rate1_94,
          s3_.tax_name2 AS tax_name2_95,
          s3_.tax_rate2 AS tax_rate2_96,
          s3_.tax_number1 AS tax_number1_97,
          s3_.tax_number2 AS tax_number2_98,
          s3_.tax_currency AS tax_currency_99,
          s3_.weight_per_pallet_feet AS weight_per_pallet_feet_100,
          s3_.has_continuous_po AS has_continuous_po_101,
          s3_.newsletter_default_subject AS newsletter_default_subject_102,
          s3_.newsletter_default_preview_text AS newsletter_default_preview_text_103,
          s3_.newsletter_default_header_line1 AS newsletter_default_header_line1_104,
          s3_.newsletter_default_header_line2 AS newsletter_default_header_line2_105,
          s3_.newsletter_default_footer_block_image AS newsletter_default_footer_block_image_106,
          s3_.newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_107,
          s3_.newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_108,
          s3_.scraper_class AS scraper_class_109,
          s3_.has_splited_scraper AS has_splited_scraper_110,
          s3_.has_synccentric_data AS has_synccentric_data_111,
          s3_.has_upcitemdb_data AS has_upcitemdb_data_112,
          s3_.apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_113,
          s3_.is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_114,
          s4_.id AS id_115,
          s4_.name AS name_116,
          s4_.public_name AS public_name_117
        FROM
          front_product f0_
          LEFT JOIN supplier s5_ ON f0_.supplier_id = s5_.id
          LEFT JOIN supplier_lang s6_ ON s5_.id = s6_.supplier_id
          AND (s6_.language_id = ?)
          LEFT JOIN `product_condition` p7_ ON f0_.product_condition_id = p7_.id
          LEFT JOIN product_condition_lang p8_ ON p7_.id = p8_.product_condition_id
          AND (p8_.language_id = ?)
          INNER JOIN front_product_image f1_ ON f0_.id = f1_.front_product_id
          INNER JOIN uploaded_photo u2_ ON f1_.uploaded_photo_id = u2_.id
          INNER JOIN supplier s3_ ON f0_.supplier_id = s3_.id
          INNER JOIN supplier_lang s4_ ON s3_.id = s4_.supplier_id
        WHERE
          f0_.is_visible = 1
          AND f0_.is_allow_purchase = 1
          AND f0_.quantity_available > 0
          AND f0_.id > 42000
          AND s6_.public_name IN (?)
        ORDER BY
          f0_.published_at DESC,
          f1_.position ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.sku AS sku_2, f0_.price AS price_3, f0_.images AS images_4, f0_.msrp AS msrp_5, f0_.discount AS discount_6, f0_.total_units AS total_units_7, f0_.package_units AS package_units_8, f0_.package_format AS package_format_9, f0_.is_cp AS is_cp_10, f0_.manifest AS manifest_11, f0_.weight AS weight_12, f0_.description AS description_13, f0_.sale_price AS sale_price_14, f0_.cost_price AS cost_price_15, f0_.calculated_price AS calculated_price_16, f0_.quantity_on_hand AS quantity_on_hand_17, f0_.quantity_pending AS quantity_pending_18, f0_.quantity_available AS quantity_available_19, f0_.track_inventory AS track_inventory_20, f0_.sort_order AS sort_order_21, f0_.is_visible AS is_visible_22, f0_.is_allow_purchase AS is_allow_purchase_23, f0_.product_availability AS product_availability_24, f0_.minimum_purchase_quantity AS minimum_purchase_quantity_25, f0_.maximum_purchase_quantity AS maximum_purchase_quantity_26, f0_.has_free_shipping AS has_free_shipping_27, f0_.fixed_shipping_price AS fixed_shipping_price_28, f0_.width AS width_29, f0_.height AS height_30, f0_.depth AS depth_31, f0_.brand AS brand_32, f0_.warranty AS warranty_33, f0_.show_product_condition AS show_product_condition_34, f0_.code AS code_35, f0_.tax_group AS tax_group_36, f0_.tax_provider_code AS tax_provider_code_37, f0_.search_keywords AS search_keywords_38, f0_.page_title AS page_title_39, f0_.meta_keywords AS meta_keywords_40, f0_.meta_description AS meta_description_41, f0_.slug AS slug_42, f0_.cost_per_unit AS cost_per_unit_43, f0_.is_overstock_lot AS is_overstock_lot_44, f0_.is_add_on_lot AS is_add_on_lot_45, f0_.is_price_drop AS is_price_drop_46, f0_.price_dropped_at AS price_dropped_at_47, f0_.published_at AS published_at_48, f0_.note AS note_49, f0_.is_listing_done AS is_listing_done_50, f0_.package_sizes AS package_sizes_51, f0_.is_truckload AS is_truckload_52, f0_.search_terms AS search_terms_53, f0_.created_at AS created_at_54, f0_.updated_at AS updated_at_55, f1_.id AS id_56, f1_.position AS position_57, f1_.description AS description_58, f1_.is_cover AS is_cover_59, u2_.id AS id_60, u2_.base_name AS base_name_61, u2_.file_name AS file_name_62, u2_.download_url AS download_url_63, u2_.needs_download AS needs_download_64, u2_.is_deleted AS is_deleted_65, u2_.has_download_error AS has_download_error_66, s3_.id AS id_67, s3_.name AS name_68, s3_.has_actions AS has_actions_69, s3_.has_validation AS has_validation_70, s3_.has_high_value AS has_high_value_71, s3_.is_active AS is_active_72, s3_.has_scrapper AS has_scrapper_73, s3_.sources_upc AS sources_upc_74, s3_.sources_merchant_sku AS sources_merchant_sku_75, s3_.sources_category AS sources_category_76, s3_.sources_name AS sources_name_77, s3_.sources_msrp AS sources_msrp_78, s3_.sources_photo AS sources_photo_79, s3_.sources_action AS sources_action_80, s3_.is_required_upc AS is_required_upc_81, s3_.is_required_merchant_sku AS is_required_merchant_sku_82, s3_.is_required_category AS is_required_category_83, s3_.is_required_name AS is_required_name_84, s3_.is_required_msrp AS is_required_msrp_85, s3_.is_required_photo AS is_required_photo_86, s3_.is_required_action AS is_required_action_87, s3_.public_name AS public_name_88, s3_.is_deleted AS is_deleted_89, s3_.product_generic_link AS product_generic_link_90, s3_.billing_name AS billing_name_91, s3_.billing_address AS billing_address_92, s3_.tax_name1 AS tax_name1_93, s3_.tax_rate1 AS tax_rate1_94, s3_.tax_name2 AS tax_name2_95, s3_.tax_rate2 AS tax_rate2_96, s3_.tax_number1 AS tax_number1_97, s3_.tax_number2 AS tax_number2_98, s3_.tax_currency AS tax_currency_99, s3_.weight_per_pallet_feet AS weight_per_pallet_feet_100, s3_.has_continuous_po AS has_continuous_po_101, s3_.newsletter_default_subject AS newsletter_default_subject_102, s3_.newsletter_default_preview_text AS newsletter_default_preview_text_103, s3_.newsletter_default_header_line1 AS newsletter_default_header_line1_104, s3_.newsletter_default_header_line2 AS newsletter_default_header_line2_105, s3_.newsletter_default_footer_block_image AS newsletter_default_footer_block_image_106, s3_.newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_107, s3_.newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_108, s3_.scraper_class AS scraper_class_109, s3_.has_splited_scraper AS has_splited_scraper_110, s3_.has_synccentric_data AS has_synccentric_data_111, s3_.has_upcitemdb_data AS has_upcitemdb_data_112, s3_.apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_113, s3_.is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_114, s4_.id AS id_115, s4_.name AS name_116, s4_.public_name AS public_name_117 FROM front_product f0_ LEFT JOIN supplier s5_ ON f0_.supplier_id = s5_.id LEFT JOIN supplier_lang s6_ ON s5_.id = s6_.supplier_id AND (s6_.language_id = 2) LEFT JOIN `product_condition` p7_ ON f0_.product_condition_id = p7_.id LEFT JOIN product_condition_lang p8_ ON p7_.id = p8_.product_condition_id AND (p8_.language_id = 2) INNER JOIN front_product_image f1_ ON f0_.id = f1_.front_product_id INNER JOIN uploaded_photo u2_ ON f1_.uploaded_photo_id = u2_.id INNER JOIN supplier s3_ ON f0_.supplier_id = s3_.id INNER JOIN supplier_lang s4_ ON s3_.id = s4_.supplier_id WHERE f0_.is_visible = 1 AND f0_.is_allow_purchase = 1 AND f0_.quantity_available > 0 AND f0_.id > 42000 AND s6_.public_name IN ('Newegg') ORDER BY f0_.published_at DESC, f1_.position ASC) dctrn_result) dctrn_table;