Query Metrics
4
Database Queries
4
Different statements
4.23 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
1.15 ms (27.21%) |
1 |
SELECT t0.id AS id_1, t0.stripecustomerid AS stripecustomerid_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.kindleemail AS kindleemail_5, t0.user_id AS user_id_6, t0.couponcodes_id AS couponcodes_id_7 FROM Profile t0 WHERE t0.user_id IS NULL LIMIT 1
Parameters:
[] |
1.09 ms (25.70%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.authorEmail AS authorEmail_6, t0.author AS author_7, t0.publishedAt AS publishedAt_8, t0.effective_url AS effective_url_9, t0.topimage AS topimage_10 FROM Post t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"a-neighborly-company"
]
|
1.03 ms (24.30%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.summary AS summary_3, p0_.content AS content_4, p0_.authorEmail AS authorEmail_5, p0_.author AS author_6, p0_.publishedAt AS publishedAt_7, p0_.effective_url AS effective_url_8, p0_.topimage AS topimage_9 FROM Post p0_ WHERE p0_.id = (SELECT min(p1_.id) AS sclr_10 FROM Post p1_ WHERE p1_.id > ?)
Parameters:
[
9
]
|
0.96 ms (22.79%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.summary AS summary_3, p0_.content AS content_4, p0_.authorEmail AS authorEmail_5, p0_.author AS author_6, p0_.publishedAt AS publishedAt_7, p0_.effective_url AS effective_url_8, p0_.topimage AS topimage_9 FROM Post p0_ WHERE p0_.id = (SELECT max(p1_.id) AS sclr_10 FROM Post p1_ WHERE p1_.id < ?)
Parameters:
[
9
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
bbp | doctrine.dbal.bbp_connection |
housemaster | doctrine.dbal.housemaster_connection |
Entity Managers
Name | Service |
---|---|
inertia | doctrine.orm.inertia_entity_manager |
default | doctrine.orm.default_entity_manager |
bbp | doctrine.orm.bbp_entity_manager |
housemaster | doctrine.orm.housemaster_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
inertia entity manager
No loaded entities.
default entity manager
Class | Mapping errors |
---|---|
App\AppBundle\Entity\Post | No errors. |
App\AppBundle\Entity\Profile | No errors. |
FOS\UserBundle\Model\User | No errors. |
App\AppBundle\Entity\User | No errors. |
App\AppBundle\Entity\CouponCodes | No errors. |
bbp entity manager
No loaded entities.
housemaster entity manager
No loaded entities.