Query Metrics
5
Database Queries
5
Different statements
3.28 ms
Query time
0
Invalid entities
27
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.95 ms |
SELECT g0_.id AS id_0, g0_.old_id AS old_id_1, g0_.type AS type_2, g0_.page AS page_3, g0_.girl AS girl_4, g0_.intname AS intname_5, g0_.mainpage AS mainpage_6, g0_.name AS name_7, g0_.href AS href_8, g0_.short AS short_9, g0_.cont AS cont_10, g0_.cont2 AS cont2_11, g0_.prior AS prior_12, g0_.visible AS visible_13, g0_.autosub AS autosub_14, g0_.title AS title_15, g0_.h1 AS h1_16, g0_.h3 AS h3_17, g0_.kw AS kw_18, g0_.descr AS descr_19, g0_.tstamp AS tstamp_20, g0_.rating AS rating_21, g0_.noindex AS noindex_22, g0_.footmenu AS footmenu_23, g0_.video AS video_24, g0_.showon AS showon_25, g0_.topmenu AS topmenu_26, g0_.topmenu2 AS topmenu2_27, g0_.spec AS spec_28 FROM ge_page g0_ WHERE (g0_.showon LIKE ? OR g0_.showon = '') AND g0_.type = ? AND g0_.visible = 1 AND g0_.page = 0 AND g0_.footmenu = 1 ORDER BY g0_.prior DESC
Parameters:
[ "%en%" "page" ] |
| 2 | 0.31 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 | 0.29 ms |
SELECT g0_.id AS id_0, g0_.old_id AS old_id_1, g0_.type AS type_2, g0_.page AS page_3, g0_.girl AS girl_4, g0_.intname AS intname_5, g0_.mainpage AS mainpage_6, g0_.name AS name_7, g0_.href AS href_8, g0_.short AS short_9, g0_.cont AS cont_10, g0_.cont2 AS cont2_11, g0_.prior AS prior_12, g0_.visible AS visible_13, g0_.autosub AS autosub_14, g0_.title AS title_15, g0_.h1 AS h1_16, g0_.h3 AS h3_17, g0_.kw AS kw_18, g0_.descr AS descr_19, g0_.tstamp AS tstamp_20, g0_.rating AS rating_21, g0_.noindex AS noindex_22, g0_.footmenu AS footmenu_23, g0_.video AS video_24, g0_.showon AS showon_25, g0_.topmenu AS topmenu_26, g0_.topmenu2 AS topmenu2_27, g0_.spec AS spec_28 FROM ge_page g0_ WHERE (g0_.showon LIKE ? OR g0_.showon = '') AND g0_.type = ? AND g0_.visible = 1 AND g0_.page = 0 AND g0_.topmenu = 1 ORDER BY g0_.prior DESC
Parameters:
[ "%en%" "page" ] |
| 4 | 0.22 ms |
SELECT g0_.id AS id_0, g0_.old_id AS old_id_1, g0_.type AS type_2, g0_.page AS page_3, g0_.girl AS girl_4, g0_.intname AS intname_5, g0_.mainpage AS mainpage_6, g0_.name AS name_7, g0_.href AS href_8, g0_.short AS short_9, g0_.cont AS cont_10, g0_.cont2 AS cont2_11, g0_.prior AS prior_12, g0_.visible AS visible_13, g0_.autosub AS autosub_14, g0_.title AS title_15, g0_.h1 AS h1_16, g0_.h3 AS h3_17, g0_.kw AS kw_18, g0_.descr AS descr_19, g0_.tstamp AS tstamp_20, g0_.rating AS rating_21, g0_.noindex AS noindex_22, g0_.footmenu AS footmenu_23, g0_.video AS video_24, g0_.showon AS showon_25, g0_.topmenu AS topmenu_26, g0_.topmenu2 AS topmenu2_27, g0_.spec AS spec_28 FROM ge_page g0_ WHERE (g0_.showon LIKE ? OR g0_.showon = '') AND g0_.type = ? AND g0_.visible = 1 AND g0_.page = 0 AND g0_.prior > 200 AND g0_.prior < 300 ORDER BY g0_.prior DESC
Parameters:
[ "%en%" "page" ] |
| 5 | 1.52 ms |
SELECT g0_.id AS id_0, g0_.lang AS lang_1, g0_.par AS par_2, g0_.type AS type_3, g0_.user AS user_4, g0_.author AS author_5, g0_.tstamp AS tstamp_6, g0_.cont AS cont_7, g0_.visible AS visible_8, g0_.confirmed AS confirmed_9, g0_.rating AS rating_10, g0_.meeting AS meeting_11, g0_.phone AS phone_12, g0_.email AS email_13, g0_.ip AS ip_14 FROM ge_comment g0_ WHERE g0_.visible = 1 AND g0_.type = ? AND g0_.par = ? AND g0_.lang = ?
Parameters:
[ "girl" 746 "en" ] |
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\Page | 17 |
| App\Entity\Filterpage | 8 |
| App\Entity\Comment | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Block | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
| App\Entity\Translation\BlockTranslation | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Translation\PageTranslation | No errors. |
| App\Entity\Video | No errors. |
| App\Entity\Translation\VideoTranslation | No errors. |
| App\Entity\Filterpage | No errors. |
| App\Entity\Translation\FilterpageTranslation | No errors. |