Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.91 ms
(51.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old жоп секс"
]
183.03 ms
(43.46%)
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
  359458
  382549
  395133
  395942
  407558
  454274
  457011
  468879
  474398
  494573
  516077
  525114
  535399
  551982
  563064
  563483
  567147
  568573
  569668
  572464
  579998
  591430
  593072
  593988
  596453
  599295
  617358
  617440
  626024
  627141
  628219
  641598
  645728
  663242
  663861
  663979
  664315
  665219
  665506
  665513
  665835
  667287
  667540
  667593
  667615
  668185
  668848
  669456
  670479
  670481
  674556
  683382
  710883
  717711
  719276
  721167
  721413
  721415
  722240
  724302
  725578
  727479
  731755
  731758
  732129
  741468
  745840
  754856
  755553
  757927
  758429
  758439
  772660
  772878
  773901
  774313
  775853
  781652
  781679
  781694
  781702
  781748
  781978
  784274
  787328
  788468
  788583
  789530
  789960
  789967
  790611
  798860
  798897
  801210
  802186
  804583
  805266
  807805
  808207
  808551
  808917
  812132
  815629
  816781
  817327
  817746
  818346
  818737
  818893
  820086
  820228
  820280
  820592
  823424
  824023
  824934
  825847
  827889
  827890
]
12.11 ms
(2.88%)
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
  805266
  551982
  569668
  664315
  721167
  665506
  781978
  790611
  812132
  468879
  626024
  663242
  683382
  724302
  563483
  593988
  808917
  457011
  670479
  788468
  516077
  568573
  567147
  801210
  395133
  395942
  407558
  817327
  808551
  775853
  772660
  773901
  774313
  617440
  627141
  787328
  804583
  525114
  669456
  359458
  474398
  725578
  494573
  596453
  641598
  382549
  599295
  454274
  815629
  817746
  820228
  820592
  818893
  820280
  823424
  818346
  818737
  824023
  824934
  816781
  820086
  825847
  827889
  827890
  535399
  572464
  563064
  667593
  721413
  645728
  665219
  665513
  667287
  668185
  668848
  710883
  663861
  663979
  665835
  667540
  667615
  670481
  674556
  579998
  593072
  628219
  591430
  617358
  781748
  789967
  798860
  798897
  781694
  781702
  789530
  802186
  808207
  745840
  772878
  784274
  788583
  789960
  807805
  741468
  754856
  758429
  771786
  727479
  731758
  755553
  758439
  732129
  757927
  731755
  717711
  719276
  721415
  722240
  781652
  781679
]
5.71 ms
(1.36%)
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
  359458
  382549
  395133
  395942
  407558
  454274
  457011
  468879
  474398
  494573
  516077
  525114
  535399
  551982
  563064
  563483
  567147
  568573
  569668
  572464
  579998
  591430
  593072
  593988
  596453
  599295
  617358
  617440
  626024
  627141
  628219
  641598
  645728
  663242
  663861
  663979
  664315
  665219
  665506
  665513
  665835
  667287
  667540
  667593
  667615
  668185
  668848
  669456
  670479
  670481
  674556
  683382
  710883
  717711
  719276
  721167
  721413
  721415
  722240
  724302
  725578
  727479
  731755
  731758
  732129
  741468
  745840
  754856
  755553
  757927
  758429
  758439
  772660
  772878
  773901
  774313
  775853
  781652
  781679
  781694
  781702
  781748
  781978
  784274
  787328
  788468
  788583
  789530
  789960
  789967
  790611
  798860
  798897
  801210
  802186
  804583
  805266
  807805
  808207
  808551
  808917
  812132
  815629
  816781
  817327
  817746
  818346
  818737
  818893
  820086
  820228
  820280
  820592
  823424
  824023
  824934
  825847
  827889
  827890
]
1.84 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old ass fuck"
]
1.70 ms
(0.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old жоп секс"
]

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.