Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.type AS type_4,
  t0.metaTitle AS metaTitle_5,
  t0.metaKeywords AS metaKeywords_6,
  t0.metaDescription AS metaDescription_7,
  t0.title AS title_8,
  t0.content AS content_9,
  t0.position AS position_10,
  t0.category AS category_11,
  t0.bannerImage AS bannerImage_12,
  t0.bannerContent AS bannerContent_13,
  t0.publish AS publish_14,
  t0.created AS created_15,
  t0.updated AS updated_16,
  t0.feature1_id AS feature1_id_17,
  t0.feature2_id AS feature2_id_18,
  t0.feature3_id AS feature3_id_19,
  t0.created_by AS created_by_20,
  t0.updated_by AS updated_by_21
FROM
  pages t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.metaTitle AS metaTitle_5, t0.metaKeywords AS metaKeywords_6, t0.metaDescription AS metaDescription_7, t0.title AS title_8, t0.content AS content_9, t0.position AS position_10, t0.category AS category_11, t0.bannerImage AS bannerImage_12, t0.bannerContent AS bannerContent_13, t0.publish AS publish_14, t0.created AS created_15, t0.updated AS updated_16, t0.feature1_id AS feature1_id_17, t0.feature2_id AS feature2_id_18, t0.feature3_id AS feature3_id_19, t0.created_by AS created_by_20, t0.updated_by AS updated_by_21 FROM pages t0 WHERE t0.name = 'Services' LIMIT 1;

SELECT
  p0_.name AS name_0,
  p0_.slug AS slug_1
FROM
  pages p0_
WHERE
  p0_.category = ?
  AND p0_.publish = 1
ORDER BY
  p0_.position ASC

SELECT p0_.name AS name_0, p0_.slug AS slug_1 FROM pages p0_ WHERE p0_.category = 'Main Nav' AND p0_.publish = 1 ORDER BY p0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.orgName AS orgName_2,
  t0.companyRegNumber AS companyRegNumber_3,
  t0.companyVatNumber AS companyVatNumber_4,
  t0.logoFilename AS logoFilename_5,
  t0.genEmail AS genEmail_6,
  t0.genPhoneNumber AS genPhoneNumber_7,
  t0.salesEmail AS salesEmail_8,
  t0.salesPhoneNumber AS salesPhoneNumber_9,
  t0.twitterLink AS twitterLink_10,
  t0.facebookLink AS facebookLink_11,
  t0.googlePlusLink AS googlePlusLink_12,
  t0.linkedinLink AS linkedinLink_13,
  t0.googleMapsAPIKey AS googleMapsAPIKey_14,
  t0.googleAnalyticsCode AS googleAnalyticsCode_15,
  t0.twitterAPIKey AS twitterAPIKey_16,
  t0.crmAPIKey AS crmAPIKey_17,
  t0.created AS created_18,
  t0.updated AS updated_19,
  t0.feature1_id AS feature1_id_20,
  t0.feature2_id AS feature2_id_21,
  t0.feature3_id AS feature3_id_22,
  t0.created_by AS created_by_23,
  t0.updated_by AS updated_by_24
FROM
  sitewide t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.orgName AS orgName_2, t0.companyRegNumber AS companyRegNumber_3, t0.companyVatNumber AS companyVatNumber_4, t0.logoFilename AS logoFilename_5, t0.genEmail AS genEmail_6, t0.genPhoneNumber AS genPhoneNumber_7, t0.salesEmail AS salesEmail_8, t0.salesPhoneNumber AS salesPhoneNumber_9, t0.twitterLink AS twitterLink_10, t0.facebookLink AS facebookLink_11, t0.googlePlusLink AS googlePlusLink_12, t0.linkedinLink AS linkedinLink_13, t0.googleMapsAPIKey AS googleMapsAPIKey_14, t0.googleAnalyticsCode AS googleAnalyticsCode_15, t0.twitterAPIKey AS twitterAPIKey_16, t0.crmAPIKey AS crmAPIKey_17, t0.created AS created_18, t0.updated AS updated_19, t0.feature1_id AS feature1_id_20, t0.feature2_id AS feature2_id_21, t0.feature3_id AS feature3_id_22, t0.created_by AS created_by_23, t0.updated_by AS updated_by_24 FROM sitewide t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.category AS category_3,
  t0.slug AS slug_4,
  t0.metaTitle AS metaTitle_5,
  t0.metaKeywords AS metaKeywords_6,
  t0.metaDescription AS metaDescription_7,
  t0.title AS title_8,
  t0.content AS content_9,
  t0.features AS features_10,
  t0.price AS price_11,
  t0.stock AS stock_12,
  t0.logo AS logo_13,
  t0.bannerImage AS bannerImage_14,
  t0.sliderImage AS sliderImage_15,
  t0.sliderContent AS sliderContent_16,
  t0.position AS position_17,
  t0.publish AS publish_18,
  t0.created AS created_19,
  t0.updated AS updated_20,
  t0.created_by AS created_by_21,
  t0.updated_by AS updated_by_22
FROM
  products t0
WHERE
  t0.publish = ?
  AND t0.category = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.slug AS slug_4, t0.metaTitle AS metaTitle_5, t0.metaKeywords AS metaKeywords_6, t0.metaDescription AS metaDescription_7, t0.title AS title_8, t0.content AS content_9, t0.features AS features_10, t0.price AS price_11, t0.stock AS stock_12, t0.logo AS logo_13, t0.bannerImage AS bannerImage_14, t0.sliderImage AS sliderImage_15, t0.sliderContent AS sliderContent_16, t0.position AS position_17, t0.publish AS publish_18, t0.created AS created_19, t0.updated AS updated_20, t0.created_by AS created_by_21, t0.updated_by AS updated_by_22 FROM products t0 WHERE t0.publish = 1 AND t0.category = 'service' ORDER BY t0.position ASC;