Query Metrics
9
Database Queries
4
Different statements
4.88 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.59 ms (53.14%) |
5 |
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:
[
"Services"
]
|
1.03 ms (21.19%) |
2 |
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"
]
|
0.63 ms (12.99%) |
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
Parameters:
[] |
0.62 ms (12.68%) |
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
Parameters:
[ 1 "service" ] |
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\Products | No errors. |