Query Metrics
23
Database Queries
13
Different statements
18.61 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.56 ms (35.23%) |
10 |
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
]
|
4.34 ms (23.31%) |
1 |
"COMMIT"
Parameters:
[] |
1.26 ms (6.77%) |
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.88 ms (4.73%) |
1 |
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
]
|
0.87 ms (4.66%) |
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.78 ms (4.17%) |
1 |
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
]
|
0.62 ms (3.34%) |
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 = ? LIMIT 1
Parameters:
[
"Blog"
]
|
0.61 ms (3.27%) |
1 |
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:
[] |
0.61 ms (3.26%) |
1 |
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:
[
2
]
|
0.60 ms (3.20%) |
1 |
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.slug = ? LIMIT 1
Parameters:
[
"how-to-set-up-a-parent-child-relationship-with-foselasticabundle"
]
|
0.59 ms (3.17%) |
1 |
UPDATE articles SET count = ?, updated = ? WHERE id = ?
Parameters:
[ 15129 "2024-09-21 14:05:45" 2 ] |
0.57 ms (3.04%) |
1 |
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
]
|
0.34 ms (1.84%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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. |