Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.81 ms
(85.25%)
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
  88591
  135519
  156525
  197527
  247954
  308832
  382906
  383687
  383888
  386725
  387808
  391270
  391535
  391928
  393790
  394582
  396378
  396623
  397708
  398678
  404477
  419120
  419324
  427339
  429872
  444251
  457205
  458561
  459887
  461580
  464268
  464716
  469647
  469673
  470192
  475524
  476655
  482737
  491244
  495328
  503690
  506441
  507405
  510570
  526291
  530652
  537107
  539316
  543569
  547871
  552324
  552908
  560576
  561451
  562526
  564049
  569160
  571187
  578652
  581747
  585537
  585677
  599748
  603054
  606594
  607444
  629311
  635355
  636358
  642788
  649059
  651852
  652884
  654784
  655295
  659176
  661036
  665247
  670238
  670825
  672388
  676573
  676679
  694539
  694962
  707388
  712707
  717079
  718856
  730269
  737563
  742696
  745054
  745744
  754653
  760790
  768287
  774730
  783357
  787334
  793576
  794413
  794718
  794810
  795778
  799769
  804265
  808281
  811862
  811882
  811900
  818778
  819661
  820124
  823918
  824465
  824989
  825298
  826073
  828482
]
16.71 ms
(8.59%)
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
  386725
  457205
  543569
  569160
  694962
  717079
  712707
  635355
  811900
  754653
  768287
  387808
  247954
  391535
  382906
  826073
  828482
  547871
  642788
  464716
  475524
  419120
  654784
  665247
  774730
  794810
  745744
  730269
  396623
  818778
  824465
  823918
  491244
  539316
  530652
  571187
  578652
  581747
  670825
  676679
  629311
  585537
  795778
  808281
  793576
  383888
  156525
  396378
  537107
  599748
  804265
  469673
  464268
  197527
  564049
  787334
  397708
  476655
  560576
  651852
  652884
  655295
  649059
  670238
  707388
  606594
  603054
  811882
  799769
  760790
  737563
  742696
  811862
  459887
  482737
  383687
  135519
  718856
  794413
  308832
  391928
  88591
  444251
  427339
  458561
  503690
  510570
  552324
  552908
  561451
  404477
  429872
  470192
  393790
  398678
  461580
  469647
  526291
  506441
  507405
  495328
  419324
  694539
  672388
  394582
  391270
  820124
  824989
  819661
  825298
  562526
  661036
  659176
  676573
  636358
  585677
  783357
  794718
  745054
  607444
]
3.10 ms
(1.60%)
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
  88591
  135519
  156525
  197527
  247954
  308832
  382906
  383687
  383888
  386725
  387808
  391270
  391535
  391928
  393790
  394582
  396378
  396623
  397708
  398678
  404477
  419120
  419324
  427339
  429872
  444251
  457205
  458561
  459887
  461580
  464268
  464716
  469647
  469673
  470192
  475524
  476655
  482737
  491244
  495328
  503690
  506441
  507405
  510570
  526291
  530652
  537107
  539316
  543569
  547871
  552324
  552908
  560576
  561451
  562526
  564049
  569160
  571187
  578652
  581747
  585537
  585677
  599748
  603054
  606594
  607444
  629311
  635355
  636358
  642788
  649059
  651852
  652884
  654784
  655295
  659176
  661036
  665247
  670238
  670825
  672388
  676573
  676679
  694539
  694962
  707388
  712707
  717079
  718856
  730269
  737563
  742696
  745054
  745744
  754653
  760790
  768287
  774730
  783357
  787334
  793576
  794413
  794718
  794810
  795778
  799769
  804265
  808281
  811862
  811882
  811900
  818778
  819661
  820124
  823918
  824465
  824989
  825298
  826073
  828482
]
2.99 ms
(1.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая ван"
]
2.20 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "черноволосая ван"
]
2.07 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brunette bathroom"
]
1.61 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.