Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.91 ms
(86.04%)
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
  397193
  399412
  423349
  435471
  435515
  443637
  447102
  472496
  477472
  508179
  532278
  535073
  537181
  537606
  540441
  540887
  542699
  555850
  557882
  558784
  563280
  563281
  564270
  567207
  571751
  574254
  576987
  578784
  579033
  579295
  579300
  582042
  586207
  586398
  587751
  589232
  591718
  592229
  596690
  600960
  602079
  604191
  604487
  604992
  606727
  615083
  615335
  615898
  623278
  626382
  627634
  630696
  631003
  631009
  633430
  633918
  639645
  644757
  645605
  646173
  646174
  647077
  647083
  648326
  651001
  651577
  653745
  653793
  653797
  653812
  653821
  653824
  653832
  655880
  655920
  658192
  664436
  665939
  672699
  680020
  686763
  688230
  691729
  697615
  699425
  699451
  707719
  711255
  711566
  711576
  720018
  725333
  729240
  732624
  732857
  733583
  737330
  737616
  737657
  738390
  738396
  738430
  739014
  739875
  746545
  749144
  750238
  758169
  784492
  796997
  803551
  818048
  823766
  826721
  827832
  827853
  827872
  827874
  827877
  827899
]
15.88 ms
(9.00%)
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
  564270
  579033
  582042
  646173
  647077
  653797
  653832
  658192
  680020
  707719
  711255
  645605
  651001
  653793
  653824
  686763
  646174
  653812
  653821
  655920
  664436
  672699
  688230
  699425
  558784
  563280
  591718
  600960
  615335
  615083
  627634
  596690
  602079
  631003
  604992
  631009
  633430
  633918
  639645
  732857
  750238
  738390
  729240
  604487
  623278
  626382
  644757
  697615
  423349
  823766
  737616
  535073
  579295
  574254
  399412
  665939
  630696
  443637
  435471
  435515
  472496
  447102
  508179
  555850
  576987
  587751
  592229
  586207
  606727
  615898
  586398
  796997
  397193
  818048
  739014
  540441
  578784
  571751
  604191
  589232
  477472
  563281
  542699
  567207
  720018
  803551
  725333
  732624
  733583
  737330
  784492
  739875
  746545
  737657
  738396
  738430
  758169
  749144
  540887
  826721
  827877
  827872
  827832
  827874
  827853
  827899
  537181
  537606
  532278
  557882
  579300
  651577
  653745
  711566
  711576
  647083
  648326
  655880
  691729
  699451
]
2.13 ms
(1.21%)
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
  397193
  399412
  423349
  435471
  435515
  443637
  447102
  472496
  477472
  508179
  532278
  535073
  537181
  537606
  540441
  540887
  542699
  555850
  557882
  558784
  563280
  563281
  564270
  567207
  571751
  574254
  576987
  578784
  579033
  579295
  579300
  582042
  586207
  586398
  587751
  589232
  591718
  592229
  596690
  600960
  602079
  604191
  604487
  604992
  606727
  615083
  615335
  615898
  623278
  626382
  627634
  630696
  631003
  631009
  633430
  633918
  639645
  644757
  645605
  646173
  646174
  647077
  647083
  648326
  651001
  651577
  653745
  653793
  653797
  653812
  653821
  653824
  653832
  655880
  655920
  658192
  664436
  665939
  672699
  680020
  686763
  688230
  691729
  697615
  699425
  699451
  707719
  711255
  711566
  711576
  720018
  725333
  729240
  732624
  732857
  733583
  737330
  737616
  737657
  738390
  738396
  738430
  739014
  739875
  746545
  749144
  750238
  758169
  784492
  796997
  803551
  818048
  823766
  826721
  827832
  827853
  827872
  827874
  827877
  827899
]
1.89 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur bbc homemade"
]
1.69 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск bbc домашн любительск"
]
1.63 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск bbc домашн любительск"
]

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.