Symfony Profiler

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  business_information b0_
WHERE
  LOWER(b0_.id) LIKE ?
  OR LOWER(b0_.business_name) LIKE ?
  OR LOWER(b0_.street_address) LIKE ?
  OR LOWER(b0_.state) LIKE ?
  OR LOWER(b0_.fixe_phone) LIKE ?
  OR LOWER(b0_.fax_number) LIKE ?
  OR LOWER(b0_.mobile) LIKE ?
  OR LOWER(b0_.email) LIKE ?
  OR LOWER(b0_.website) LIKE ?
  OR LOWER(b0_.categories) LIKE ?
  OR LOWER(b0_.logo) LIKE ?
  OR LOWER(b0_.city) LIKE ?
  OR LOWER(b0_.description) LIKE ?
  OR LOWER(b0_.contact_name) LIKE ?
  OR LOWER(b0_.business_title) LIKE ?
  OR LOWER(b0_.custmer_type) LIKE ?
  OR LOWER(b0_.key_words) LIKE ?
  OR LOWER(b0_.general_info) LIKE ?
  OR LOWER(b0_.created_by) LIKE ?
  OR LOWER(b0_.statut) LIKE ?
  OR LOWER(b0_.created_date) LIKE ?
  OR LOWER(b0_.company_presentation) LIKE ?
  OR LOWER(b0_.year_established) LIKE ?
  OR LOWER(b0_.service_photo_1) LIKE ?
  OR LOWER(b0_.service_photo_2) LIKE ?
  OR LOWER(b0_.service_photo_3) LIKE ?
  OR LOWER(b0_.service_photo_4) LIKE ?
  OR LOWER(b0_.service_photo_5) LIKE ?
  OR LOWER(b0_.service_photo_6) LIKE ?
  OR LOWER(b0_.documentations_catalogs) LIKE ?
  OR LOWER(b0_.company_references) LIKE ?
  OR LOWER(b0_.video_entreprise) LIKE ?
  OR LOWER(b0_.facebook) LIKE ?
  OR LOWER(b0_.youtube) LIKE ?
  OR LOWER(b0_.maps) LIKE ?
  OR LOWER(b0_.banner) LIKE ?
  OR LOWER(b0_.add_date) LIKE ?
  OR LOWER(b0_.maquette) LIKE ?

SELECT COUNT(b0_.id) AS sclr_0 FROM business_information b0_ WHERE LOWER(b0_.id) LIKE '%vip%' OR LOWER(b0_.business_name) LIKE '%vip%' OR LOWER(b0_.street_address) LIKE '%vip%' OR LOWER(b0_.state) LIKE '%vip%' OR LOWER(b0_.fixe_phone) LIKE '%vip%' OR LOWER(b0_.fax_number) LIKE '%vip%' OR LOWER(b0_.mobile) LIKE '%vip%' OR LOWER(b0_.email) LIKE '%vip%' OR LOWER(b0_.website) LIKE '%vip%' OR LOWER(b0_.categories) LIKE '%vip%' OR LOWER(b0_.logo) LIKE '%vip%' OR LOWER(b0_.city) LIKE '%vip%' OR LOWER(b0_.description) LIKE '%vip%' OR LOWER(b0_.contact_name) LIKE '%vip%' OR LOWER(b0_.business_title) LIKE '%vip%' OR LOWER(b0_.custmer_type) LIKE '%vip%' OR LOWER(b0_.key_words) LIKE '%vip%' OR LOWER(b0_.general_info) LIKE '%vip%' OR LOWER(b0_.created_by) LIKE '%vip%' OR LOWER(b0_.statut) LIKE '%vip%' OR LOWER(b0_.created_date) LIKE '%vip%' OR LOWER(b0_.company_presentation) LIKE '%vip%' OR LOWER(b0_.year_established) LIKE '%vip%' OR LOWER(b0_.service_photo_1) LIKE '%vip%' OR LOWER(b0_.service_photo_2) LIKE '%vip%' OR LOWER(b0_.service_photo_3) LIKE '%vip%' OR LOWER(b0_.service_photo_4) LIKE '%vip%' OR LOWER(b0_.service_photo_5) LIKE '%vip%' OR LOWER(b0_.service_photo_6) LIKE '%vip%' OR LOWER(b0_.documentations_catalogs) LIKE '%vip%' OR LOWER(b0_.company_references) LIKE '%vip%' OR LOWER(b0_.video_entreprise) LIKE '%vip%' OR LOWER(b0_.facebook) LIKE '%vip%' OR LOWER(b0_.youtube) LIKE '%vip%' OR LOWER(b0_.maps) LIKE '%vip%' OR LOWER(b0_.banner) LIKE '%vip%' OR LOWER(b0_.add_date) LIKE '%vip%' OR LOWER(b0_.maquette) LIKE '%vip%';

SELECT
  DISTINCT b0_.id AS id_0
FROM
  business_information b0_
WHERE
  LOWER(b0_.id) LIKE ?
  OR LOWER(b0_.business_name) LIKE ?
  OR LOWER(b0_.street_address) LIKE ?
  OR LOWER(b0_.state) LIKE ?
  OR LOWER(b0_.fixe_phone) LIKE ?
  OR LOWER(b0_.fax_number) LIKE ?
  OR LOWER(b0_.mobile) LIKE ?
  OR LOWER(b0_.email) LIKE ?
  OR LOWER(b0_.website) LIKE ?
  OR LOWER(b0_.categories) LIKE ?
  OR LOWER(b0_.logo) LIKE ?
  OR LOWER(b0_.city) LIKE ?
  OR LOWER(b0_.description) LIKE ?
  OR LOWER(b0_.contact_name) LIKE ?
  OR LOWER(b0_.business_title) LIKE ?
  OR LOWER(b0_.custmer_type) LIKE ?
  OR LOWER(b0_.key_words) LIKE ?
  OR LOWER(b0_.general_info) LIKE ?
  OR LOWER(b0_.created_by) LIKE ?
  OR LOWER(b0_.statut) LIKE ?
  OR LOWER(b0_.created_date) LIKE ?
  OR LOWER(b0_.company_presentation) LIKE ?
  OR LOWER(b0_.year_established) LIKE ?
  OR LOWER(b0_.service_photo_1) LIKE ?
  OR LOWER(b0_.service_photo_2) LIKE ?
  OR LOWER(b0_.service_photo_3) LIKE ?
  OR LOWER(b0_.service_photo_4) LIKE ?
  OR LOWER(b0_.service_photo_5) LIKE ?
  OR LOWER(b0_.service_photo_6) LIKE ?
  OR LOWER(b0_.documentations_catalogs) LIKE ?
  OR LOWER(b0_.company_references) LIKE ?
  OR LOWER(b0_.video_entreprise) LIKE ?
  OR LOWER(b0_.facebook) LIKE ?
  OR LOWER(b0_.youtube) LIKE ?
  OR LOWER(b0_.maps) LIKE ?
  OR LOWER(b0_.banner) LIKE ?
  OR LOWER(b0_.add_date) LIKE ?
  OR LOWER(b0_.maquette) LIKE ?
LIMIT
  20 OFFSET 40

SELECT DISTINCT b0_.id AS id_0 FROM business_information b0_ WHERE LOWER(b0_.id) LIKE '%vip%' OR LOWER(b0_.business_name) LIKE '%vip%' OR LOWER(b0_.street_address) LIKE '%vip%' OR LOWER(b0_.state) LIKE '%vip%' OR LOWER(b0_.fixe_phone) LIKE '%vip%' OR LOWER(b0_.fax_number) LIKE '%vip%' OR LOWER(b0_.mobile) LIKE '%vip%' OR LOWER(b0_.email) LIKE '%vip%' OR LOWER(b0_.website) LIKE '%vip%' OR LOWER(b0_.categories) LIKE '%vip%' OR LOWER(b0_.logo) LIKE '%vip%' OR LOWER(b0_.city) LIKE '%vip%' OR LOWER(b0_.description) LIKE '%vip%' OR LOWER(b0_.contact_name) LIKE '%vip%' OR LOWER(b0_.business_title) LIKE '%vip%' OR LOWER(b0_.custmer_type) LIKE '%vip%' OR LOWER(b0_.key_words) LIKE '%vip%' OR LOWER(b0_.general_info) LIKE '%vip%' OR LOWER(b0_.created_by) LIKE '%vip%' OR LOWER(b0_.statut) LIKE '%vip%' OR LOWER(b0_.created_date) LIKE '%vip%' OR LOWER(b0_.company_presentation) LIKE '%vip%' OR LOWER(b0_.year_established) LIKE '%vip%' OR LOWER(b0_.service_photo_1) LIKE '%vip%' OR LOWER(b0_.service_photo_2) LIKE '%vip%' OR LOWER(b0_.service_photo_3) LIKE '%vip%' OR LOWER(b0_.service_photo_4) LIKE '%vip%' OR LOWER(b0_.service_photo_5) LIKE '%vip%' OR LOWER(b0_.service_photo_6) LIKE '%vip%' OR LOWER(b0_.documentations_catalogs) LIKE '%vip%' OR LOWER(b0_.company_references) LIKE '%vip%' OR LOWER(b0_.video_entreprise) LIKE '%vip%' OR LOWER(b0_.facebook) LIKE '%vip%' OR LOWER(b0_.youtube) LIKE '%vip%' OR LOWER(b0_.maps) LIKE '%vip%' OR LOWER(b0_.banner) LIKE '%vip%' OR LOWER(b0_.add_date) LIKE '%vip%' OR LOWER(b0_.maquette) LIKE '%vip%' LIMIT 20 OFFSET 40;

SELECT
  t0.id AS id_1,
  t0.business_name AS business_name_2,
  t0.street_address AS street_address_3,
  t0.state AS state_4,
  t0.fixe_phone AS fixe_phone_5,
  t0.fax_number AS fax_number_6,
  t0.mobile AS mobile_7,
  t0.email AS email_8,
  t0.website AS website_9,
  t0.categories AS categories_10,
  t0.logo AS logo_11,
  t0.city AS city_12,
  t0.description AS description_13,
  t0.contact_name AS contact_name_14,
  t0.business_title AS business_title_15,
  t0.custmer_type AS custmer_type_16,
  t0.key_words AS key_words_17,
  t0.general_info AS general_info_18,
  t0.created_by AS created_by_19,
  t0.statut AS statut_20,
  t0.created_date AS created_date_21,
  t0.company_presentation AS company_presentation_22,
  t0.year_established AS year_established_23,
  t0.service_photo_1 AS service_photo_1_24,
  t0.service_photo_2 AS service_photo_2_25,
  t0.service_photo_3 AS service_photo_3_26,
  t0.service_photo_4 AS service_photo_4_27,
  t0.service_photo_5 AS service_photo_5_28,
  t0.service_photo_6 AS service_photo_6_29,
  t0.documentations_catalogs AS documentations_catalogs_30,
  t0.company_references AS company_references_31,
  t0.video_entreprise AS video_entreprise_32,
  t0.facebook AS facebook_33,
  t0.youtube AS youtube_34,
  t0.maps AS maps_35,
  t0.banner AS banner_36,
  t0.add_date AS add_date_37,
  t0.maquette AS maquette_38,
  t0.alaune AS alaune_39
FROM
  business_information t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.street_address AS street_address_3, t0.state AS state_4, t0.fixe_phone AS fixe_phone_5, t0.fax_number AS fax_number_6, t0.mobile AS mobile_7, t0.email AS email_8, t0.website AS website_9, t0.categories AS categories_10, t0.logo AS logo_11, t0.city AS city_12, t0.description AS description_13, t0.contact_name AS contact_name_14, t0.business_title AS business_title_15, t0.custmer_type AS custmer_type_16, t0.key_words AS key_words_17, t0.general_info AS general_info_18, t0.created_by AS created_by_19, t0.statut AS statut_20, t0.created_date AS created_date_21, t0.company_presentation AS company_presentation_22, t0.year_established AS year_established_23, t0.service_photo_1 AS service_photo_1_24, t0.service_photo_2 AS service_photo_2_25, t0.service_photo_3 AS service_photo_3_26, t0.service_photo_4 AS service_photo_4_27, t0.service_photo_5 AS service_photo_5_28, t0.service_photo_6 AS service_photo_6_29, t0.documentations_catalogs AS documentations_catalogs_30, t0.company_references AS company_references_31, t0.video_entreprise AS video_entreprise_32, t0.facebook AS facebook_33, t0.youtube AS youtube_34, t0.maps AS maps_35, t0.banner AS banner_36, t0.add_date AS add_date_37, t0.maquette AS maquette_38, t0.alaune AS alaune_39 FROM business_information t0 WHERE t0.id = '9623';

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6 FROM user t0 WHERE t0.id = 4;

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
  (
    LOWER(b0_.id) LIKE ?
    OR LOWER(b0_.business_name) LIKE ?
    OR LOWER(b0_.street_address) LIKE ?
    OR LOWER(b0_.state) LIKE ?
    OR LOWER(b0_.fixe_phone) LIKE ?
    OR LOWER(b0_.fax_number) LIKE ?
    OR LOWER(b0_.mobile) LIKE ?
    OR LOWER(b0_.email) LIKE ?
    OR LOWER(b0_.website) LIKE ?
    OR LOWER(b0_.categories) LIKE ?
    OR LOWER(b0_.logo) LIKE ?
    OR LOWER(b0_.city) LIKE ?
    OR LOWER(b0_.description) LIKE ?
    OR LOWER(b0_.contact_name) LIKE ?
    OR LOWER(b0_.business_title) LIKE ?
    OR LOWER(b0_.custmer_type) LIKE ?
    OR LOWER(b0_.key_words) LIKE ?
    OR LOWER(b0_.general_info) LIKE ?
    OR LOWER(b0_.created_by) LIKE ?
    OR LOWER(b0_.statut) LIKE ?
    OR LOWER(b0_.created_date) LIKE ?
    OR LOWER(b0_.company_presentation) LIKE ?
    OR LOWER(b0_.year_established) LIKE ?
    OR LOWER(b0_.service_photo_1) LIKE ?
    OR LOWER(b0_.service_photo_2) LIKE ?
    OR LOWER(b0_.service_photo_3) LIKE ?
    OR LOWER(b0_.service_photo_4) LIKE ?
    OR LOWER(b0_.service_photo_5) LIKE ?
    OR LOWER(b0_.service_photo_6) LIKE ?
    OR LOWER(b0_.documentations_catalogs) LIKE ?
    OR LOWER(b0_.company_references) LIKE ?
    OR LOWER(b0_.video_entreprise) LIKE ?
    OR LOWER(b0_.facebook) LIKE ?
    OR LOWER(b0_.youtube) LIKE ?
    OR LOWER(b0_.maps) LIKE ?
    OR LOWER(b0_.banner) LIKE ?
    OR LOWER(b0_.add_date) LIKE ?
    OR LOWER(b0_.maquette) LIKE ?
  )
  AND b0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

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 (LOWER(b0_.id) LIKE '%vip%' OR LOWER(b0_.business_name) LIKE '%vip%' OR LOWER(b0_.street_address) LIKE '%vip%' OR LOWER(b0_.state) LIKE '%vip%' OR LOWER(b0_.fixe_phone) LIKE '%vip%' OR LOWER(b0_.fax_number) LIKE '%vip%' OR LOWER(b0_.mobile) LIKE '%vip%' OR LOWER(b0_.email) LIKE '%vip%' OR LOWER(b0_.website) LIKE '%vip%' OR LOWER(b0_.categories) LIKE '%vip%' OR LOWER(b0_.logo) LIKE '%vip%' OR LOWER(b0_.city) LIKE '%vip%' OR LOWER(b0_.description) LIKE '%vip%' OR LOWER(b0_.contact_name) LIKE '%vip%' OR LOWER(b0_.business_title) LIKE '%vip%' OR LOWER(b0_.custmer_type) LIKE '%vip%' OR LOWER(b0_.key_words) LIKE '%vip%' OR LOWER(b0_.general_info) LIKE '%vip%' OR LOWER(b0_.created_by) LIKE '%vip%' OR LOWER(b0_.statut) LIKE '%vip%' OR LOWER(b0_.created_date) LIKE '%vip%' OR LOWER(b0_.company_presentation) LIKE '%vip%' OR LOWER(b0_.year_established) LIKE '%vip%' OR LOWER(b0_.service_photo_1) LIKE '%vip%' OR LOWER(b0_.service_photo_2) LIKE '%vip%' OR LOWER(b0_.service_photo_3) LIKE '%vip%' OR LOWER(b0_.service_photo_4) LIKE '%vip%' OR LOWER(b0_.service_photo_5) LIKE '%vip%' OR LOWER(b0_.service_photo_6) LIKE '%vip%' OR LOWER(b0_.documentations_catalogs) LIKE '%vip%' OR LOWER(b0_.company_references) LIKE '%vip%' OR LOWER(b0_.video_entreprise) LIKE '%vip%' OR LOWER(b0_.facebook) LIKE '%vip%' OR LOWER(b0_.youtube) LIKE '%vip%' OR LOWER(b0_.maps) LIKE '%vip%' OR LOWER(b0_.banner) LIKE '%vip%' OR LOWER(b0_.add_date) LIKE '%vip%' OR LOWER(b0_.maquette) LIKE '%vip%') AND b0_.id IN (6669, 7704, 9421, 9623, 9700, 9883, 10413, 11030, 11692, 11785, 12237, 12239, 12534, 12566, 12705, 12707, 14193, 14194, 14195, 14196);