Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.84 ms
(90.02%)
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
  13450
  383504
  393422
  449972
  457722
  463135
  478357
  479373
  488806
  497056
  504828
  520856
  530346
  530587
  532034
  532189
  533169
  533303
  534097
  537606
  537608
  538371
  541282
  541494
  542479
  543052
  544711
  545130
  548268
  548411
  554846
  558023
  563519
  563937
  565148
  572403
  576450
  577308
  577610
  579850
  609611
  631141
  646662
  648587
  660068
  681926
  698916
  701179
  703769
  717258
  719978
  720784
  721806
  723591
  724325
  725267
  725290
  727486
  728910
  729050
  729294
  730589
  731623
  731878
  732904
  732950
  734786
  734796
  735622
  735682
  735812
  736811
  738575
  738861
  739381
  742467
  743986
  744317
  744762
  746396
  746479
  748044
  750775
  756403
  758604
  759626
  760761
  761224
  761767
  772193
  779663
  787148
  788663
  793535
  806030
  810615
  812023
  812214
  814761
  814819
  814941
  817785
  818672
  818870
  819002
  819192
  819454
  820724
  821205
  821665
  822712
  822775
  825636
  826329
  827684
  827784
  827953
]
10.59 ms
(5.42%)
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
  725290
  728910
  729050
  729294
  730589
  735622
  744762
  746396
  748044
  725267
  732950
  734796
  736811
  738575
  742467
  758604
  759626
  724325
  727486
  731878
  732904
  734786
  735682
  735812
  739381
  743986
  744317
  746479
  760761
  761224
  761767
  772193
  738861
  756403
  609611
  631141
  701179
  703769
  717258
  720784
  721806
  721975
  788663
  793535
  810615
  812023
  393422
  13450
  817785
  545130
  554846
  660068
  681926
  698916
  719978
  779663
  787148
  750775
  731623
  806030
  812214
  383504
  814761
  818870
  819002
  723591
  814941
  818672
  819454
  822056
  826329
  814819
  819192
  820724
  821205
  821665
  822712
  822775
  825636
  827953
  827784
  827684
  479373
  488806
  449972
  457722
  478357
  463135
  533303
  534097
  538371
  497056
  504828
  530346
  530587
  532189
  537606
  537608
  520856
  532034
  533169
  535845
  543052
  544711
  563519
  563937
  565148
  577308
  579850
  542479
  548411
  558023
  576450
  541282
  541494
  548268
  572403
  577610
  646662
  648587
]
2.72 ms
(1.39%)
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
  13450
  383504
  393422
  449972
  457722
  463135
  478357
  479373
  488806
  497056
  504828
  520856
  530346
  530587
  532034
  532189
  533169
  533303
  534097
  537606
  537608
  538371
  541282
  541494
  542479
  543052
  544711
  545130
  548268
  548411
  554846
  558023
  563519
  563937
  565148
  572403
  576450
  577308
  577610
  579850
  609611
  631141
  646662
  648587
  660068
  681926
  698916
  701179
  703769
  717258
  719978
  720784
  721806
  723591
  724325
  725267
  725290
  727486
  728910
  729050
  729294
  730589
  731623
  731878
  732904
  732950
  734786
  734796
  735622
  735682
  735812
  736811
  738575
  738861
  739381
  742467
  743986
  744317
  744762
  746396
  746479
  748044
  750775
  756403
  758604
  759626
  760761
  761224
  761767
  772193
  779663
  787148
  788663
  793535
  806030
  810615
  812023
  812214
  814761
  814819
  814941
  817785
  818672
  818870
  819002
  819192
  819454
  820724
  821205
  821665
  822712
  822775
  825636
  826329
  827684
  827784
  827953
]
1.75 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cock fucking"
]
1.52 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cock fucking"
]
1.41 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cock fucking"
]

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.