Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
412.48 ms
(68.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
168.09 ms
(27.74%)
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
  15162
  32678
  382188
  393061
  395405
  395578
  397714
  399710
  401930
  406488
  409893
  413569
  416226
  417878
  420084
  425395
  430762
  458098
  458913
  459668
  460261
  464145
  465106
  465652
  468704
  469001
  469986
  471827
  480137
  519810
  523573
  532487
  535841
  543154
  544779
  547080
  548102
  564304
  564392
  568228
  573308
  574117
  583953
  584731
  585270
  586692
  590794
  591936
  595279
  595965
  595969
  596116
  599876
  600832
  602070
  604457
  604468
  604495
  604510
  604527
  604531
  604556
  604681
  606858
  607126
  610029
  610201
  612182
  614990
  622716
  630898
  630955
  633428
  633755
  634209
  634552
  634553
  636576
  647629
  649187
  649857
  649964
  655832
  674043
  681297
  687881
  694632
  699347
  700169
  704187
  708279
  708923
  715371
  718945
  720030
  720116
  720306
  724266
  727597
  732549
  732868
  733405
  737159
  737177
  744598
  744601
  744632
  744665
  747745
  752939
  756228
  772815
  787738
  789516
  800297
  800703
  802462
  803473
  807763
  813448
]
16.41 ms
(2.71%)
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
  519810
  523573
  532487
  535841
  460261
  464145
  465106
  468704
  469001
  469986
  544779
  564392
  547080
  548102
  574117
  584731
  543154
  564304
  583953
  649857
  649964
  681297
  704187
  649187
  655832
  687881
  700169
  708923
  720116
  647629
  674043
  694632
  699347
  708279
  715371
  718945
  720306
  568228
  573308
  585270
  590794
  596116
  604457
  604531
  604681
  607126
  622716
  591936
  602070
  604495
  610029
  614990
  634553
  636576
  586692
  599876
  600832
  610201
  633755
  634209
  634552
  595279
  595965
  595969
  604510
  604527
  612182
  630898
  802462
  803473
  800297
  800703
  807763
  727597
  752939
  756228
  772815
  787738
  789516
  813448
  724266
  733405
  744632
  737159
  737177
  744601
  732549
  732868
  744598
  744665
  747745
  604468
  604556
  606858
  630955
  633428
  720030
  15162
  382188
  395578
  409893
  413569
  416226
  458098
  458913
  459668
  393061
  399710
  401930
  417878
  465652
  471827
  480137
  32678
  395405
  397714
  406488
  420084
  425395
  430762
]
3.23 ms
(0.53%)
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
  15162
  32678
  382188
  393061
  395405
  395578
  397714
  399710
  401930
  406488
  409893
  413569
  416226
  417878
  420084
  425395
  430762
  458098
  458913
  459668
  460261
  464145
  465106
  465652
  468704
  469001
  469986
  471827
  480137
  519810
  523573
  532487
  535841
  543154
  544779
  547080
  548102
  564304
  564392
  568228
  573308
  574117
  583953
  584731
  585270
  586692
  590794
  591936
  595279
  595965
  595969
  596116
  599876
  600832
  602070
  604457
  604468
  604495
  604510
  604527
  604531
  604556
  604681
  606858
  607126
  610029
  610201
  612182
  614990
  622716
  630898
  630955
  633428
  633755
  634209
  634552
  634553
  636576
  647629
  649187
  649857
  649964
  655832
  674043
  681297
  687881
  694632
  699347
  700169
  704187
  708279
  708923
  715371
  718945
  720030
  720116
  720306
  724266
  727597
  732549
  732868
  733405
  737159
  737177
  744598
  744601
  744632
  744665
  747745
  752939
  756228
  772815
  787738
  789516
  800297
  800703
  802462
  803473
  807763
  813448
]
2.14 ms
(0.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbc cock"
]
1.84 ms
(0.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbc cock"
]
1.81 ms
(0.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbc cock"
]

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.