Symfony Profiler

SELECT
  name
FROM
  bo_geo_cities
WHERE
  slug = ?
LIMIT
  1

SELECT name FROM bo_geo_cities WHERE slug = 'sharonville' LIMIT 1;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  cvs_enterprises c0_
WHERE
  c0_.online = ?
  AND (
    (c0_.city_slug = ?)
    OR (
      (
        c0_.city_slug IS NULL
        OR c0_.city_slug = ''
      )
      AND (
        c0_.city = ?
        OR c0_.city = ?
      )
    )
  )

SELECT COUNT(c0_.id) AS sclr_0 FROM cvs_enterprises c0_ WHERE c0_.online = 1 AND ((c0_.city_slug = 'sharonville') OR ((c0_.city_slug IS NULL OR c0_.city_slug = '') AND (c0_.city = 'sharonville' OR c0_.city = 'sharonville')));

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.category AS category_3,
  c0_.short_title AS short_title_4,
  c0_.short_description AS short_description_5,
  c0_.company_name AS company_name_6,
  c0_.address AS address_7,
  c0_.city AS city_8,
  c0_.zipcode AS zipcode_9,
  c0_.city_ref AS city_ref_10,
  c0_.city_slug AS city_slug_11,
  c0_.area_code AS area_code_12,
  c0_.trade_ref AS trade_ref_13,
  c0_.country AS country_14,
  c0_.website AS website_15,
  c0_.email AS email_16,
  c0_.new_interests_count AS new_interests_count_17,
  c0_.phone AS phone_18,
  c0_.company_description AS company_description_19,
  c0_.contact_name AS contact_name_20,
  c0_.contact_email AS contact_email_21,
  c0_.contact_url AS contact_url_22,
  c0_.online AS online_23,
  c0_.validation AS validation_24,
  c0_.verification AS verification_25,
  c0_.slug AS slug_26,
  c0_.locale AS locale_27,
  c0_.views AS views_28,
  c0_.pointx AS pointx_29,
  c0_.pointy AS pointy_30,
  c0_.image_name AS image_name_31,
  c0_.image_original_name AS image_original_name_32,
  c0_.image_mime_type AS image_mime_type_33,
  c0_.image_size AS image_size_34,
  c0_.image_dimensions AS image_dimensions_35,
  c0_.user_id AS user_id_36,
  c0_.agency_id AS agency_id_37
FROM
  cvs_enterprises c0_
WHERE
  c0_.online = ?
  AND (
    (c0_.city_slug = ?)
    OR (
      (
        c0_.city_slug IS NULL
        OR c0_.city_slug = ''
      )
      AND (
        c0_.city = ?
        OR c0_.city = ?
      )
    )
  )
ORDER BY
  c0_.updated_at DESC
LIMIT
  13

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.category AS category_3, c0_.short_title AS short_title_4, c0_.short_description AS short_description_5, c0_.company_name AS company_name_6, c0_.address AS address_7, c0_.city AS city_8, c0_.zipcode AS zipcode_9, c0_.city_ref AS city_ref_10, c0_.city_slug AS city_slug_11, c0_.area_code AS area_code_12, c0_.trade_ref AS trade_ref_13, c0_.country AS country_14, c0_.website AS website_15, c0_.email AS email_16, c0_.new_interests_count AS new_interests_count_17, c0_.phone AS phone_18, c0_.company_description AS company_description_19, c0_.contact_name AS contact_name_20, c0_.contact_email AS contact_email_21, c0_.contact_url AS contact_url_22, c0_.online AS online_23, c0_.validation AS validation_24, c0_.verification AS verification_25, c0_.slug AS slug_26, c0_.locale AS locale_27, c0_.views AS views_28, c0_.pointx AS pointx_29, c0_.pointy AS pointy_30, c0_.image_name AS image_name_31, c0_.image_original_name AS image_original_name_32, c0_.image_mime_type AS image_mime_type_33, c0_.image_size AS image_size_34, c0_.image_dimensions AS image_dimensions_35, c0_.user_id AS user_id_36, c0_.agency_id AS agency_id_37 FROM cvs_enterprises c0_ WHERE c0_.online = 1 AND ((c0_.city_slug = 'sharonville') OR ((c0_.city_slug IS NULL OR c0_.city_slug = '') AND (c0_.city = 'sharonville' OR c0_.city = 'sharonville'))) ORDER BY c0_.updated_at DESC LIMIT 13;