GET https://fsd6.webbamboo.net/a/page

Query Metrics

9 Database Queries
8 Different statements
3.72 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.31 ms
(35.27%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.metatitle AS metatitle_2, a0_.metadescription AS metadescription_3, a0_.permalink AS permalink_4, a0_.content AS content_5, a0_.interestingarticle1 AS interestingarticle1_6, a0_.interestingarticle2 AS interestingarticle2_7, a0_.interestingarticle3 AS interestingarticle3_8, a0_.interestingarticle4 AS interestingarticle4_9, a0_.interestingarticle5 AS interestingarticle5_10, a0_.published AS published_11, a0_.status AS status_12 FROM Article a0_ WHERE a0_.status = ? OR a0_.status IS NULL ORDER BY a0_.id DESC LIMIT 20
Parameters:
[
  "published"
]
0.67 ms
(17.92%)
1
SELECT t0.id AS id_1, t0.metatitle AS metatitle_2, t0.metadescription AS metadescription_3, t0.pagenumber AS pagenumber_4 FROM Allpagesmeta t0 WHERE t0.pagenumber = ? LIMIT 1
Parameters:
[
  1
]
0.60 ms
(16.19%)
1
SELECT t0.id AS id_1, t0.fromurl AS fromurl_2, t0.tourl AS tourl_3, t0.timestamp AS timestamp_4 FROM general t0
Parameters:
[]
0.30 ms
(8.10%)
2
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3 FROM Generalsettings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
  "Analytics"
]
0.24 ms
(6.54%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.metatitle AS metatitle_3, t0.permalink AS permalink_4, t0.content AS content_5, t0.metadescription AS metadescription_6, t0.menuname AS menuname_7, t0.published AS published_8 FROM Page t0
Parameters:
[]
0.21 ms
(5.73%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.metatitle AS metatitle_2, a0_.metadescription AS metadescription_3, a0_.permalink AS permalink_4, a0_.content AS content_5, a0_.interestingarticle1 AS interestingarticle1_6, a0_.interestingarticle2 AS interestingarticle2_7, a0_.interestingarticle3 AS interestingarticle3_8, a0_.interestingarticle4 AS interestingarticle4_9, a0_.interestingarticle5 AS interestingarticle5_10, a0_.published AS published_11, a0_.status AS status_12 FROM Article a0_ WHERE a0_.status = ? OR a0_.status IS NULL ORDER BY a0_.id DESC) dctrn_result) dctrn_table
Parameters:
[
  "published"
]
0.19 ms
(5.14%)
1
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3 FROM Articlesettings t0
Parameters:
[]
0.19 ms
(5.11%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.permalink AS permalink_4, t0.manualmetatitle AS manualmetatitle_5, t0.manualmetadescription AS manualmetadescription_6, t0.manualh1 AS manualh1_7, t0.manualcontentone AS manualcontentone_8, t0.manualcontenttwo AS manualcontenttwo_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.manualthumbnail AS manualthumbnail_12, t0.manualthumbnailname AS manualthumbnailname_13, t0.manualthumbnailalt AS manualthumbnailalt_14, t0.manual AS manual_15, t0.metatitle_id AS metatitle_id_16, t0.metadescription_id AS metadescription_id_17, t0.h1_id AS h1_id_18, t0.contentone_id AS contentone_id_19, t0.contenttwo_id AS contenttwo_id_20, t0.thumbnail_id AS thumbnail_id_21 FROM Counties t0
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.