Query Metrics
4
Database Queries
4
Different statements
5.14 ms
Query time
0
Invalid entities
68
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.19 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.41 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 | 2.20 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" "videos" ] |
| 4 | 1.34 ms |
SELECT v0_.id AS id_0, v0_.girl AS girl_1, v0_.intname AS intname_2, v0_.name AS name_3, v0_.video AS video_4, v0_.cont AS cont_5, v0_.prior AS prior_6, v0_.title AS title_7, v0_.h1 AS h1_8, v0_.kw AS kw_9, v0_.descr AS descr_10, v0_.visible AS visible_11, v0_.hidden AS hidden_12 FROM video v0_ WHERE v0_.girl IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY v0_.prior DESC, v0_.id DESC
Parameters:
[ 746 568 622 561 571 605 629 693 716 983 755 766 807 864 871 863 893 1119 1029 940 947 965 968 971 993 1002 1014 1020 1037 1045 1046 1065 1050 1055 1057 1063 1070 1077 1076 1078 1098 1086 1084 1088 1092 1100 1102 1103 1117 1109 1107 1108 1110 1111 1115 1112 1114 1113 1118 1116 ] |
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\Video | 40 |
| 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\Video | No errors. |
| App\Entity\Translation\VideoTranslation | No errors. |