Symfony Profiler

SELECT
  COUNT(DISTINCT b0_.id) AS sclr_0
FROM
  business_information b0_
WHERE
  b0_.business_name LIKE ?
  OR b0_.key_words LIKE ?
  OR b0_.description LIKE ?
  OR b0_.company_presentation LIKE ?

SELECT COUNT(DISTINCT b0_.id) AS sclr_0 FROM business_information b0_ WHERE b0_.business_name LIKE '%Eurl%' OR b0_.key_words LIKE '%Eurl%' OR b0_.description LIKE '%Eurl%' OR b0_.company_presentation LIKE '%Eurl%';

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.custmer_type AS custmer_type_1
FROM
  business_information b0_
WHERE
  b0_.business_name LIKE ?
  OR b0_.key_words LIKE ?
  OR b0_.description LIKE ?
  OR b0_.company_presentation LIKE ?
ORDER BY
  b0_.custmer_type DESC
LIMIT
  21 OFFSET 3465

SELECT DISTINCT b0_.id AS id_0, b0_.custmer_type AS custmer_type_1 FROM business_information b0_ WHERE b0_.business_name LIKE '%Eurl%' OR b0_.key_words LIKE '%Eurl%' OR b0_.description LIKE '%Eurl%' OR b0_.company_presentation LIKE '%Eurl%' ORDER BY b0_.custmer_type DESC LIMIT 21 OFFSET 3465;

SELECT
  b0_.id AS id_0,
  b0_.business_name AS business_name_1,
  b0_.street_address AS street_address_2,
  b0_.state AS state_3,
  b0_.fixe_phone AS fixe_phone_4,
  b0_.fax_number AS fax_number_5,
  b0_.mobile AS mobile_6,
  b0_.email AS email_7,
  b0_.website AS website_8,
  b0_.categories AS categories_9,
  b0_.logo AS logo_10,
  b0_.city AS city_11,
  b0_.description AS description_12,
  b0_.contact_name AS contact_name_13,
  b0_.business_title AS business_title_14,
  b0_.custmer_type AS custmer_type_15,
  b0_.key_words AS key_words_16,
  b0_.general_info AS general_info_17,
  b0_.created_by AS created_by_18,
  b0_.statut AS statut_19,
  b0_.created_date AS created_date_20,
  b0_.company_presentation AS company_presentation_21,
  b0_.year_established AS year_established_22,
  b0_.service_photo_1 AS service_photo_1_23,
  b0_.service_photo_2 AS service_photo_2_24,
  b0_.service_photo_3 AS service_photo_3_25,
  b0_.service_photo_4 AS service_photo_4_26,
  b0_.service_photo_5 AS service_photo_5_27,
  b0_.service_photo_6 AS service_photo_6_28,
  b0_.documentations_catalogs AS documentations_catalogs_29,
  b0_.company_references AS company_references_30,
  b0_.video_entreprise AS video_entreprise_31,
  b0_.facebook AS facebook_32,
  b0_.youtube AS youtube_33,
  b0_.maps AS maps_34,
  b0_.banner AS banner_35,
  b0_.add_date AS add_date_36,
  b0_.maquette AS maquette_37,
  b0_.alaune AS alaune_38
FROM
  business_information b0_
WHERE
  (
    b0_.business_name LIKE ?
    OR b0_.key_words LIKE ?
    OR b0_.description LIKE ?
    OR b0_.company_presentation LIKE ?
  )
  AND b0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )
ORDER BY
  b0_.custmer_type DESC

SELECT b0_.id AS id_0, b0_.business_name AS business_name_1, b0_.street_address AS street_address_2, b0_.state AS state_3, b0_.fixe_phone AS fixe_phone_4, b0_.fax_number AS fax_number_5, b0_.mobile AS mobile_6, b0_.email AS email_7, b0_.website AS website_8, b0_.categories AS categories_9, b0_.logo AS logo_10, b0_.city AS city_11, b0_.description AS description_12, b0_.contact_name AS contact_name_13, b0_.business_title AS business_title_14, b0_.custmer_type AS custmer_type_15, b0_.key_words AS key_words_16, b0_.general_info AS general_info_17, b0_.created_by AS created_by_18, b0_.statut AS statut_19, b0_.created_date AS created_date_20, b0_.company_presentation AS company_presentation_21, b0_.year_established AS year_established_22, b0_.service_photo_1 AS service_photo_1_23, b0_.service_photo_2 AS service_photo_2_24, b0_.service_photo_3 AS service_photo_3_25, b0_.service_photo_4 AS service_photo_4_26, b0_.service_photo_5 AS service_photo_5_27, b0_.service_photo_6 AS service_photo_6_28, b0_.documentations_catalogs AS documentations_catalogs_29, b0_.company_references AS company_references_30, b0_.video_entreprise AS video_entreprise_31, b0_.facebook AS facebook_32, b0_.youtube AS youtube_33, b0_.maps AS maps_34, b0_.banner AS banner_35, b0_.add_date AS add_date_36, b0_.maquette AS maquette_37, b0_.alaune AS alaune_38 FROM business_information b0_ WHERE (b0_.business_name LIKE '%Eurl%' OR b0_.key_words LIKE '%Eurl%' OR b0_.description LIKE '%Eurl%' OR b0_.company_presentation LIKE '%Eurl%') AND b0_.id IN (57909, 57925, 57928, 57931, 57942, 57949, 57951, 57967, 57968, 57972, 57994, 58001, 58003, 58013, 58020, 58033, 58046, 58055, 58059, 58103, 58118) ORDER BY b0_.custmer_type DESC;