Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
200.85 ms
(87.34%)
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
  12203
  83386
  233147
  324395
  382182
  383000
  387874
  390760
  396768
  400813
  402419
  404582
  405485
  409929
  411864
  422294
  450136
  450155
  453893
  454058
  458007
  459988
  461035
  461815
  465791
  466716
  466930
  467518
  468112
  469345
  471605
  476271
  476586
  484672
  485695
  486365
  489299
  490188
  490410
  490915
  493102
  497207
  514706
  523023
  523191
  527270
  531821
  533219
  539023
  539464
  543289
  543592
  547807
  547853
  549504
  549646
  554235
  555120
  555141
  556899
  557594
  558523
  563444
  563898
  570155
  589650
  591304
  593047
  593541
  595928
  597843
  619511
  620211
  647602
  662380
  664848
  667017
  667743
  693032
  699370
  710368
  712561
  716279
  717545
  720236
  721910
  726897
  727653
  736741
  737182
  741777
  741778
  742753
  743065
  745341
  759914
  760534
  765822
  770610
  785435
  792142
  794250
  794794
  796027
  796149
  797178
  800731
  801881
  803086
  803295
  804339
  807489
  812662
  813539
  814851
  815094
  816062
  817371
  824011
  824345
]
17.17 ms
(7.46%)
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
  466930
  563444
  543592
  662380
  667017
  555141
  467518
  814851
  461815
  664848
  794794
  797178
  801881
  813539
  737182
  83386
  422294
  396768
  383000
  404582
  411864
  409929
  454058
  549646
  558523
  593541
  597843
  400813
  514706
  527270
  484672
  815094
  539023
  543289
  712561
  693032
  716279
  717545
  595928
  812662
  741778
  785435
  800731
  699370
  461035
  469345
  554235
  619511
  743065
  466716
  458007
  459988
  471605
  489299
  490915
  490410
  485695
  547807
  324395
  390760
  817371
  816062
  824011
  824345
  450136
  450155
  539464
  486365
  556899
  549504
  667743
  710368
  794250
  792142
  807489
  727653
  741777
  759914
  736741
  770610
  765822
  745341
  760534
  803295
  405485
  490188
  523191
  555120
  557594
  591304
  593047
  803086
  476271
  465791
  476586
  497207
  523023
  493102
  720236
  382182
  12203
  402419
  468112
  531821
  533219
  547853
  563898
  721910
  570155
  589650
  796149
  804339
  796027
  726897
  742753
  453893
  387874
  233147
  647602
  620211
]
4.58 ms
(1.99%)
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
  12203
  83386
  233147
  324395
  382182
  383000
  387874
  390760
  396768
  400813
  402419
  404582
  405485
  409929
  411864
  422294
  450136
  450155
  453893
  454058
  458007
  459988
  461035
  461815
  465791
  466716
  466930
  467518
  468112
  469345
  471605
  476271
  476586
  484672
  485695
  486365
  489299
  490188
  490410
  490915
  493102
  497207
  514706
  523023
  523191
  527270
  531821
  533219
  539023
  539464
  543289
  543592
  547807
  547853
  549504
  549646
  554235
  555120
  555141
  556899
  557594
  558523
  563444
  563898
  570155
  589650
  591304
  593047
  593541
  595928
  597843
  619511
  620211
  647602
  662380
  664848
  667017
  667743
  693032
  699370
  710368
  712561
  716279
  717545
  720236
  721910
  726897
  727653
  736741
  737182
  741777
  741778
  742753
  743065
  745341
  759914
  760534
  765822
  770610
  785435
  792142
  794250
  794794
  796027
  796149
  797178
  800731
  801881
  803086
  803295
  804339
  807489
  812662
  813539
  814851
  815094
  816062
  817371
  824011
  824345
]
2.06 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot mature sex"
]
1.93 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot mature секс"
]
1.68 ms
(0.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot mature секс"
]

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.