Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.03 ms
(86.68%)
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
  34198
  247347
  382091
  387965
  391296
  393399
  395741
  397421
  403770
  407169
  410980
  413110
  415543
  418441
  421861
  422299
  426696
  427656
  428096
  430705
  434076
  439753
  439779
  443459
  443785
  444650
  448396
  456312
  457392
  457774
  457965
  459474
  459485
  460172
  460335
  460387
  460451
  469096
  469150
  469300
  470411
  470425
  470617
  471397
  472409
  472583
  473129
  475209
  478588
  478814
  478824
  478949
  483087
  484394
  485684
  490474
  494671
  495172
  498763
  499362
  501701
  508164
  512997
  514817
  520911
  521999
  525062
  525890
  526518
  529444
  531303
  531873
  531977
  536919
  541550
  547962
  549917
  551021
  554711
  556596
  558683
  562152
  565863
  567216
  568107
  584315
  584890
  585220
  586791
  590735
  591636
  592850
  595820
  602632
  604634
  605671
  606625
  607469
  613358
  622687
  626037
  632072
  636053
  666472
  668419
  685578
  699401
  710928
  721983
  742891
  756752
  773766
  791981
  801701
  802256
  803301
  803306
  808461
  811917
  825922
]
13.77 ms
(7.91%)
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
  403770
  430705
  443459
  415543
  427656
  418441
  434076
  469300
  457774
  457965
  460172
  460387
  460451
  470411
  485684
  457392
  470617
  483087
  525062
  512997
  529444
  531873
  494671
  526518
  531977
  536919
  499362
  514817
  531303
  469096
  469150
  472583
  565863
  568107
  547962
  562152
  584315
  584890
  685578
  666472
  721983
  554711
  556596
  558683
  567216
  595820
  607469
  613358
  632072
  592850
  604634
  606625
  626037
  585220
  602632
  636053
  586791
  590735
  605671
  803306
  791981
  802256
  742891
  756752
  808461
  393399
  395741
  397421
  413110
  426696
  478949
  448396
  459474
  460335
  478824
  391296
  407169
  422299
  471397
  472409
  247347
  410980
  439753
  443785
  456312
  473129
  475209
  478814
  421861
  459485
  470425
  478588
  508164
  521999
  484394
  490474
  495172
  541550
  498763
  501701
  439779
  525890
  520911
  825922
  551021
  668419
  549917
  591636
  801701
  811917
  803301
  773766
  622687
  699401
  710928
  382091
  34198
  387965
  428096
  444650
]
2.73 ms
(1.56%)
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
  34198
  247347
  382091
  387965
  391296
  393399
  395741
  397421
  403770
  407169
  410980
  413110
  415543
  418441
  421861
  422299
  426696
  427656
  428096
  430705
  434076
  439753
  439779
  443459
  443785
  444650
  448396
  456312
  457392
  457774
  457965
  459474
  459485
  460172
  460335
  460387
  460451
  469096
  469150
  469300
  470411
  470425
  470617
  471397
  472409
  472583
  473129
  475209
  478588
  478814
  478824
  478949
  483087
  484394
  485684
  490474
  494671
  495172
  498763
  499362
  501701
  508164
  512997
  514817
  520911
  521999
  525062
  525890
  526518
  529444
  531303
  531873
  531977
  536919
  541550
  547962
  549917
  551021
  554711
  556596
  558683
  562152
  565863
  567216
  568107
  584315
  584890
  585220
  586791
  590735
  591636
  592850
  595820
  602632
  604634
  605671
  606625
  607469
  613358
  622687
  626037
  632072
  636053
  666472
  668419
  685578
  699401
  710928
  721983
  742891
  756752
  773766
  791981
  801701
  802256
  803301
  803306
  808461
  811917
  825922
]
1.94 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bathroom milf"
]
1.82 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ван milf"
]
1.32 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ван milf"
]

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.