http://alphawerks.co.uk/ucm-pi

Query Metrics

5 Database Queries
4 Different statements
3.40 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.81 ms
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
Parameters:
[]
2 0.63 ms
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
Parameters:
[
  "Main Nav"
]
3 0.52 ms
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
Parameters:
[
  "Other Nav"
]
4 0.65 ms
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
Parameters:
[
  "UCM-Pi"
]
5 0.80 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.slug AS slug_3, t0.salt AS salt_4, t0.password AS password_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.roles AS roles_8, t0.created AS created_9, t0.updated AS updated_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t13.id AS id_14, t13.firstName AS firstName_15, t13.lastName AS lastName_16, t13.slug AS slug_17, t13.roleTitle AS roleTitle_18, t13.team AS team_19, t13.email AS email_20, t13.phoneNumber AS phoneNumber_21, t13.phoneExtension AS phoneExtension_22, t13.mobileNumber AS mobileNumber_23, t13.faxNumber AS faxNumber_24, t13.skypeName AS skypeName_25, t13.twitterName AS twitterName_26, t13.facebookLink AS facebookLink_27, t13.linkedInLink AS linkedInLink_28, t13.googlePlusLink AS googlePlusLink_29, t13.specialities AS specialities_30, t13.bio AS bio_31, t13.interests AS interests_32, t13.recommendations AS recommendations_33, t13.companyQuote AS companyQuote_34, t13.thumbnailName AS thumbnailName_35, t13.photoName AS photoName_36, t13.backgroundName AS backgroundName_37, t13.crmID AS crmID_38, t13.publish AS publish_39, t13.position AS position_40, t13.datePublished AS datePublished_41, t13.created AS created_42, t13.updated AS updated_43, t13.user_id AS user_id_44, t13.manager_id AS manager_id_45, t13.created_by AS created_by_46, t13.updated_by AS updated_by_47 FROM users t0 LEFT JOIN people t13 ON t13.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  2
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Sitewide No errors.
App\Entity\Features No errors.
App\Entity\User No errors.
App\Entity\Pages No errors.
App\Entity\People No errors.