Query Metrics
22
Database Queries
11
Different statements
14.99 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.82 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.66 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.55 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.60 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:
[
"Blog"
]
|
5 | 0.85 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 WHERE t0.publish = ? ORDER BY t0.datePublished DESC
Parameters:
[
1
]
|
6 | 0.53 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.slug AS slug_4, t0.created AS created_5, t0.updated AS updated_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM tags t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"ucm-pi"
]
|
7 | 0.83 ms |
SELECT a0_.id AS id_0, a0_.author AS author_1, a0_.title AS title_2, a0_.content AS content_3, a0_.slug AS slug_4, a0_.publish AS publish_5, a0_.created AS created_6, a0_.updated AS updated_7, a0_.datePublished AS datePublished_8, a0_.image_name AS image_name_9, a0_.updated_at AS updated_at_10, a0_.count AS count_11, a0_.created_by AS created_by_12, a0_.updated_by AS updated_by_13 FROM articles a0_ LEFT JOIN articles_tags a2_ ON a0_.id = a2_.articles_id LEFT JOIN tags t1_ ON t1_.id = a2_.tags_id WHERE a0_.publish = 1 AND t1_.slug = ? ORDER BY a0_.datePublished DESC
Parameters:
[
"ucm-pi"
]
|
8 | 0.61 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.slug AS slug_4, t0.created AS created_5, t0.updated AS updated_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM tags t0 ORDER BY t0.name ASC
Parameters:
[] |
9 | 0.71 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
6
]
|
10 | 0.66 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
4
]
|
11 | 0.73 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
3
]
|
12 | 0.70 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
10
]
|
13 | 0.73 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
2
]
|
14 | 0.67 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
5
]
|
15 | 0.66 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
1
]
|
16 | 0.60 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
9
]
|
17 | 0.71 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
7
]
|
18 | 0.59 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
8
]
|
19 | 0.95 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
]
|
20 | 0.63 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.slug AS slug_4, t0.created AS created_5, t0.updated AS updated_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM tags t0 INNER JOIN articles_tags ON t0.id = articles_tags.tags_id WHERE articles_tags.articles_id = ?
Parameters:
[
6
]
|
21 | 0.63 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.slug AS slug_4, t0.created AS created_5, t0.updated AS updated_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM tags t0 INNER JOIN articles_tags ON t0.id = articles_tags.tags_id WHERE articles_tags.articles_id = ?
Parameters:
[
3
]
|
22 | 0.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.title AS title_4, t0.content AS content_5, t0.position AS position_6, t0.category AS category_7, t0.icon AS icon_8, t0.publish AS publish_9, t0.created AS created_10, t0.updated AS updated_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13 FROM features t0 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\Articles | No errors. |
App\Entity\Tags | No errors. |
App\Entity\People | No errors. |