Query Metrics

7 Database Queries
7 Different statements
202.23 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
172.24 ms
(85.17%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  33284
  123273
  382049
  392538
  399176
  401274
  401368
  404693
  411895
  413711
  416974
  417482
  418530
  419123
  419220
  420277
  426616
  427248
  427311
  427363
  430542
  433199
  435225
  436322
  443558
  445687
  446501
  447004
  448520
  454802
  468369
  469294
  475629
  479785
  480283
  481142
  482679
  485125
  488805
  492523
  504974
  506034
  515475
  517007
  518755
  520670
  525045
  526164
  530725
  534294
  535546
  536378
  537107
  539240
  540333
  565788
  577390
  581242
  583607
  601034
  602006
  603156
  622335
  624815
  628114
  631199
  639729
  650802
  650827
  656515
  684053
  696426
  714003
  719857
  720095
  720364
  720394
  723660
  724194
  726662
  729134
  737152
  742244
  742896
  755573
  758540
  760811
  761561
  765477
  766747
  770833
  770884
  775186
  776305
  776713
  784866
  789002
  795713
  797546
  798333
  799538
  805484
  806022
  806138
  808622
  810817
  811944
  814852
  814878
  814894
  815530
  815545
  815929
  816015
  817238
  820679
  820753
  820768
  825124
  826248
]
19.22 ms
(9.50%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  650802
  696426
  720394
  583607
  805484
  811944
  770884
  758540
  417482
  401274
  426616
  814878
  506034
  475629
  418530
  525045
  480283
  123273
  624815
  539240
  427363
  815545
  536378
  504974
  719857
  631199
  411895
  447004
  565788
  382049
  392538
  469294
  485125
  581242
  430542
  492523
  401368
  814894
  820679
  723660
  815929
  814852
  815530
  816015
  817238
  820753
  820768
  530725
  537107
  526164
  534294
  517007
  720095
  684053
  603156
  776305
  797546
  806022
  776713
  798333
  742244
  755573
  724194
  770833
  760811
  761561
  765477
  726662
  737152
  784866
  795713
  806138
  808622
  810817
  419220
  33284
  427248
  433199
  443558
  420277
  482679
  479785
  515475
  518755
  540333
  720364
  628114
  622335
  602006
  639729
  714003
  789002
  413711
  446501
  488805
  419123
  729134
  601034
  577390
  427311
  481142
  454802
  416974
  826248
  448520
  535546
  520670
  650827
  775186
  766747
  468369
  399176
  656515
  742896
  436322
  799538
  825124
  404693
  435225
  445687
]
3.05 ms
(1.51%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  33284
  123273
  382049
  392538
  399176
  401274
  401368
  404693
  411895
  413711
  416974
  417482
  418530
  419123
  419220
  420277
  426616
  427248
  427311
  427363
  430542
  433199
  435225
  436322
  443558
  445687
  446501
  447004
  448520
  454802
  468369
  469294
  475629
  479785
  480283
  481142
  482679
  485125
  488805
  492523
  504974
  506034
  515475
  517007
  518755
  520670
  525045
  526164
  530725
  534294
  535546
  536378
  537107
  539240
  540333
  565788
  577390
  581242
  583607
  601034
  602006
  603156
  622335
  624815
  628114
  631199
  639729
  650802
  650827
  656515
  684053
  696426
  714003
  719857
  720095
  720364
  720394
  723660
  724194
  726662
  729134
  737152
  742244
  742896
  755573
  758540
  760811
  761561
  765477
  766747
  770833
  770884
  775186
  776305
  776713
  784866
  789002
  795713
  797546
  798333
  799538
  805484
  806022
  806138
  808622
  810817
  811944
  814852
  814878
  814894
  815530
  815545
  815929
  816015
  817238
  820679
  820753
  820768
  825124
  826248
]
2.16 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal latina tits"
]
1.97 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал латинская сиськ"
]
1.89 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал латинская сиськ"
]

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.

Entities Mapping

No loaded entities.