Query Metrics
4
Database Queries
4
Different statements
5.47 ms
Query time
0
Invalid entities
53
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.27 ms |
SELECT p0_.id AS id_0, p0_.old_id AS old_id_1, p0_.type AS type_2, p0_.page AS page_3, p0_.girl AS girl_4, p0_.intname AS intname_5, p0_.mainpage AS mainpage_6, p0_.name AS name_7, p0_.href AS href_8, p0_.short AS short_9, p0_.cont AS cont_10, p0_.cont2 AS cont2_11, p0_.prior AS prior_12, p0_.visible AS visible_13, p0_.autosub AS autosub_14, p0_.title AS title_15, p0_.h1 AS h1_16, p0_.h3 AS h3_17, p0_.kw AS kw_18, p0_.descr AS descr_19, p0_.tstamp AS tstamp_20, p0_.rating AS rating_21, p0_.noindex AS noindex_22, p0_.footmenu AS footmenu_23, p0_.video AS video_24, p0_.showon AS showon_25, p0_.topmenu AS topmenu_26, p0_.topmenu2 AS topmenu2_27, p0_.spec AS spec_28 FROM page p0_ WHERE (p0_.showon LIKE ? OR p0_.showon = '') AND p0_.type = ? AND p0_.visible = 1 AND p0_.page = 0 AND p0_.footmenu = 1 ORDER BY p0_.prior DESC
Parameters:
[ "%en%" "page" ] |
| 2 | 0.28 ms |
SELECT f0_.id AS id_0, f0_.intname AS intname_1, f0_.name AS name_2, f0_.cont AS cont_3, f0_.visible AS visible_4, f0_.title AS title_5, f0_.h1 AS h1_6, f0_.kw AS kw_7, f0_.descr AS descr_8 FROM filterpage f0_ WHERE f0_.visible = 1 ORDER BY f0_.id DESC LIMIT 8
Parameters:
[] |
| 3 | 1.97 ms |
SELECT p0_.id AS id_0, p0_.old_id AS old_id_1, p0_.type AS type_2, p0_.page AS page_3, p0_.girl AS girl_4, p0_.intname AS intname_5, p0_.mainpage AS mainpage_6, p0_.name AS name_7, p0_.href AS href_8, p0_.short AS short_9, p0_.cont AS cont_10, p0_.cont2 AS cont2_11, p0_.prior AS prior_12, p0_.visible AS visible_13, p0_.autosub AS autosub_14, p0_.title AS title_15, p0_.h1 AS h1_16, p0_.h3 AS h3_17, p0_.kw AS kw_18, p0_.descr AS descr_19, p0_.tstamp AS tstamp_20, p0_.rating AS rating_21, p0_.noindex AS noindex_22, p0_.footmenu AS footmenu_23, p0_.video AS video_24, p0_.showon AS showon_25, p0_.topmenu AS topmenu_26, p0_.topmenu2 AS topmenu2_27, p0_.spec AS spec_28 FROM page p0_ WHERE p0_.showon LIKE ? AND p0_.type = ? AND p0_.visible = 1 AND p0_.intname = ?
Parameters:
[ "%en%" "page" "reviews" ] |
| 4 | 1.95 ms |
SELECT t0.id AS id_1, t0.lang AS lang_2, t0.par AS par_3, t0.type AS type_4, t0.user AS user_5, t0.author AS author_6, t0.tstamp AS tstamp_7, t0.cont AS cont_8, t0.visible AS visible_9, t0.confirmed AS confirmed_10, t0.rating AS rating_11, t0.meeting AS meeting_12, t0.phone AS phone_13, t0.email AS email_14, t0.ip AS ip_15 FROM comment t0 WHERE t0.type = ? AND t0.par = ? AND t0.visible = ? ORDER BY t0.tstamp DESC
Parameters:
[ "" 0 1 ] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Comment | 25 |
| App\Entity\Page | 20 |
| App\Entity\Filterpage | 8 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Page | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
| App\Entity\Translation\PageTranslation | No errors. |
| App\Entity\Filterpage | No errors. |
| App\Entity\Translation\FilterpageTranslation | No errors. |
| App\Entity\Comment | No errors. |