Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.10 ms
(82.19%)
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
  386535
  386771
  387858
  387973
  391934
  392903
  395922
  396673
  397918
  399416
  399909
  400638
  401101
  401928
  401989
  403654
  405702
  406377
  406391
  407532
  407753
  409166
  411353
  411513
  411580
  413464
  414104
  414201
  414317
  415753
  415873
  415965
  416561
  416632
  416644
  416914
  417006
  417090
  418345
  418640
  418741
  418757
  418923
  418989
  419146
  419836
  420392
  420586
  421073
  421100
  421153
  421536
  422182
  422233
  422349
  422642
  422666
  422909
  423042
  423382
  423481
  423941
  424486
  425154
  425170
  425181
  425849
  426354
  426680
  427273
  427737
  428643
  429441
  429445
  431501
  433716
  433885
  435350
  435999
  437803
  437968
  438226
  438411
  438742
  439499
  440664
  441237
  441355
  442271
  442847
  443064
  443131
  443198
  443412
  443945
  443998
  444103
  444115
  444213
  444326
  444732
  445106
  445256
  445411
  445747
  445963
  446750
  447449
  447588
  448578
  448646
  449186
  449206
  450666
  451008
  451693
  452206
  452285
  453580
  454468
]
17.63 ms
(11.77%)
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
  399416
  399909
  409166
  415873
  416914
  419836
  423382
  433885
  447449
  411513
  437968
  442271
  444115
  445747
  386771
  387858
  397918
  407532
  414317
  417006
  418640
  425181
  438226
  414104
  414201
  416632
  418345
  418741
  421100
  426354
  431501
  444732
  445106
  443064
  443198
  443412
  444326
  418923
  422909
  443131
  415753
  419146
  423042
  440664
  445963
  448578
  453580
  448646
  451008
  407753
  413464
  420586
  424486
  425849
  427737
  429445
  438411
  451693
  395922
  396673
  401101
  417090
  418757
  422642
  425170
  427273
  447588
  452285
  416644
  422666
  423941
  433716
  442847
  444103
  444213
  445411
  386535
  387973
  405702
  411580
  422182
  426680
  435999
  443998
  422349
  445256
  449186
  392903
  400638
  401989
  406377
  406391
  403654
  418989
  421536
  429441
  439499
  411353
  416561
  423481
  425154
  437803
  441237
  441355
  435350
  415965
  421153
  438742
  446750
  449206
  454468
  450666
  452206
  420392
  421073
  422233
  443945
  391934
  401928
  428643
]
2.69 ms
(1.79%)
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
  386535
  386771
  387858
  387973
  391934
  392903
  395922
  396673
  397918
  399416
  399909
  400638
  401101
  401928
  401989
  403654
  405702
  406377
  406391
  407532
  407753
  409166
  411353
  411513
  411580
  413464
  414104
  414201
  414317
  415753
  415873
  415965
  416561
  416632
  416644
  416914
  417006
  417090
  418345
  418640
  418741
  418757
  418923
  418989
  419146
  419836
  420392
  420586
  421073
  421100
  421153
  421536
  422182
  422233
  422349
  422642
  422666
  422909
  423042
  423382
  423481
  423941
  424486
  425154
  425170
  425181
  425849
  426354
  426680
  427273
  427737
  428643
  429441
  429445
  431501
  433716
  433885
  435350
  435999
  437803
  437968
  438226
  438411
  438742
  439499
  440664
  441237
  441355
  442271
  442847
  443064
  443131
  443198
  443412
  443945
  443998
  444103
  444115
  444213
  444326
  444732
  445106
  445256
  445411
  445747
  445963
  446750
  447449
  447588
  448578
  448646
  449186
  449206
  450666
  451008
  451693
  452206
  452285
  453580
  454468
]
2.00 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "блядью"
]
1.70 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бляд"
]
1.21 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.