Query Metrics
8
Database Queries
7
Different statements
3.26 ms
Query time
0
Invalid entities
45
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.01 ms |
SELECT k0_.id AS id_0, k0_.old_id AS old_id_1, k0_.type AS type_2, k0_.page AS page_3, k0_.girl AS girl_4, k0_.intname AS intname_5, k0_.mainpage AS mainpage_6, k0_.name AS name_7, k0_.href AS href_8, k0_.short AS short_9, k0_.cont AS cont_10, k0_.cont2 AS cont2_11, k0_.prior AS prior_12, k0_.visible AS visible_13, k0_.autosub AS autosub_14, k0_.title AS title_15, k0_.h1 AS h1_16, k0_.h3 AS h3_17, k0_.kw AS kw_18, k0_.descr AS descr_19, k0_.tstamp AS tstamp_20, k0_.rating AS rating_21, k0_.noindex AS noindex_22, k0_.footmenu AS footmenu_23, k0_.video AS video_24, k0_.showon AS showon_25, k0_.topmenu AS topmenu_26, k0_.topmenu2 AS topmenu2_27, k0_.spec AS spec_28 FROM ke_page k0_ WHERE (k0_.showon LIKE ? OR k0_.showon = '') AND k0_.type = ? AND k0_.visible = 1 AND k0_.page = 0 AND k0_.footmenu = 1 ORDER BY k0_.prior DESC
Parameters:
[ "%en%" "page" ] |
| 2 | 0.35 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.34 ms |
SELECT k0_.id AS id_0, k0_.old_id AS old_id_1, k0_.type AS type_2, k0_.page AS page_3, k0_.girl AS girl_4, k0_.intname AS intname_5, k0_.mainpage AS mainpage_6, k0_.name AS name_7, k0_.href AS href_8, k0_.short AS short_9, k0_.cont AS cont_10, k0_.cont2 AS cont2_11, k0_.prior AS prior_12, k0_.visible AS visible_13, k0_.autosub AS autosub_14, k0_.title AS title_15, k0_.h1 AS h1_16, k0_.h3 AS h3_17, k0_.kw AS kw_18, k0_.descr AS descr_19, k0_.tstamp AS tstamp_20, k0_.rating AS rating_21, k0_.noindex AS noindex_22, k0_.footmenu AS footmenu_23, k0_.video AS video_24, k0_.showon AS showon_25, k0_.topmenu AS topmenu_26, k0_.topmenu2 AS topmenu2_27, k0_.spec AS spec_28 FROM ke_page k0_ WHERE (k0_.showon LIKE ? OR k0_.showon = '') AND k0_.visible = 1 AND k0_.type = ? ORDER BY k0_.tstamp DESC, k0_.id DESC LIMIT 5
Parameters:
[ "%en%" "article" ] |
| 4 | 0.33 ms |
SELECT k0_.id AS id_0, k0_.old_id AS old_id_1, k0_.type AS type_2, k0_.page AS page_3, k0_.girl AS girl_4, k0_.intname AS intname_5, k0_.mainpage AS mainpage_6, k0_.name AS name_7, k0_.href AS href_8, k0_.short AS short_9, k0_.cont AS cont_10, k0_.cont2 AS cont2_11, k0_.prior AS prior_12, k0_.visible AS visible_13, k0_.autosub AS autosub_14, k0_.title AS title_15, k0_.h1 AS h1_16, k0_.h3 AS h3_17, k0_.kw AS kw_18, k0_.descr AS descr_19, k0_.tstamp AS tstamp_20, k0_.rating AS rating_21, k0_.noindex AS noindex_22, k0_.footmenu AS footmenu_23, k0_.video AS video_24, k0_.showon AS showon_25, k0_.topmenu AS topmenu_26, k0_.topmenu2 AS topmenu2_27, k0_.spec AS spec_28 FROM ke_page k0_ WHERE (k0_.showon LIKE ? OR k0_.showon = '') AND k0_.type = ? AND k0_.visible = 1 AND k0_.page = 0 AND k0_.topmenu = 1 ORDER BY k0_.prior DESC
Parameters:
[ "%en%" "page" ] |
| 5 | 0.28 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:
[ 963 871 1092 957 971 834 716 1172 965 568 1053 1122 1026 1146 976 629 605 746 622 1045 1157 1014 1119 863 893 1175 766 864 1161 968 1158 1176 1100 1171 977 1070 1029 1160 1020 1094 1133 1117 826 1156 1159 1126 1168 1046 1145 1151 ] |
| 6 | 0.27 ms |
SELECT t0.id AS id_1, t0.girl AS girl_2, t0.intname AS intname_3, t0.name AS name_4, t0.video AS video_5, t0.cont AS cont_6, t0.prior AS prior_7, t0.title AS title_8, t0.h1 AS h1_9, t0.kw AS kw_10, t0.descr AS descr_11, t0.visible AS visible_12, t0.hidden AS hidden_13 FROM video t0 WHERE t0.intname = ? LIMIT 1
Parameters:
[
"emma8vid"
]
|
| 7 | 0.37 ms |
SELECT t0.id AS id_1, t0.intname AS intname_2, t0.name AS name_3, t0.about AS about_4, t0.price AS price_5, t0.price30 AS price30_6, t0.price1 AS price1_7, t0.price2 AS price2_8, t0.price3 AS price3_9, t0.price4 AS price4_10, t0.num AS num_11, t0.visible AS visible_12, t0.showon AS showon_13, t0.confirmed AS confirmed_14, t0.main AS main_15, t0.best AS best_16, t0.gotd AS gotd_17, t0.today AS today_18, t0.profy AS profy_19, t0.elite AS elite_20, t0.vip AS vip_21, t0.recommend AS recommend_22, t0.odessa AS odessa_23, t0.prior AS prior_24, t0.title AS title_25, t0.h1 AS h1_26, t0.h3 AS h3_27, t0.kw AS kw_28, t0.descr AS descr_29, t0.spec AS spec_30, t0.tstamp AS tstamp_31, t0.views AS views_32, t0.titlecary AS titlecary_33, t0.h1cary AS h1cary_34, t0.h3cary AS h3cary_35, t0.descrcary AS descrcary_36, t0.aboutcary AS aboutcary_37, t0.titlege AS titlege_38, t0.h1ge AS h1ge_39, t0.h3ge AS h3ge_40, t0.descrge AS descrge_41, t0.aboutge AS aboutge_42, t0.titlekt AS titlekt_43, t0.h1kt AS h1kt_44, t0.h3kt AS h3kt_45, t0.descrkt AS descrkt_46, t0.aboutkt AS aboutkt_47, t0.titleke AS titleke_48, t0.h1ke AS h1ke_49, t0.h3ke AS h3ke_50, t0.descrke AS descrke_51, t0.aboutke AS aboutke_52, t0.searchindex AS searchindex_53, t0.hidden_photos AS hidden_photos_54, t0.videochat AS videochat_55, t0.only_open_photos AS only_open_photos_56, t0.closed_face AS closed_face_57 FROM girl t0 WHERE t0.id = ?
Parameters:
[
629
]
|
| 8 | 0.31 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:
[ 963 871 1092 957 971 834 716 1172 965 568 1053 1122 1026 1146 976 629 605 746 622 1045 1157 1014 1119 863 893 1175 766 864 1161 968 1158 1176 1100 1171 977 1070 1029 1160 1020 1094 1133 1117 826 1156 1159 1126 1168 1046 1145 1151 ] |
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 | 44 |
| App\Entity\Girl | 1 |
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\Page | 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. |
| App\Entity\Girl | No errors. |
| App\Entity\Translation\GirlTranslation | No errors. |