Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.87 ms
(82.15%)
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
  395566
  408563
  415615
  420192
  420575
  421526
  423518
  426033
  428409
  429088
  431410
  435496
  439695
  440816
  443320
  444586
  446004
  448121
  448351
  448828
  451578
  451974
  458905
  459784
  468044
  468717
  468753
  472720
  472937
  474644
  474655
  483875
  484695
  485270
  487150
  488156
  490533
  492434
  496551
  502249
  502890
  504536
  506800
  507078
  509998
  514467
  514600
  515742
  516245
  517849
  517981
  522843
  522899
  525657
  526735
  528202
  528791
  531070
  531252
  531540
  532982
  535094
  542753
  542791
  543475
  545586
  550437
  554519
  558138
  559374
  559760
  561103
  562204
  562247
  562269
  564160
  565355
  567762
  569096
  571847
  572537
  576271
  581349
  581552
  581660
  583503
  583716
  593162
  593850
  598038
  603675
  604894
  608928
  621371
  630765
  632256
  633786
  637121
  640380
  640806
  641671
  644914
  648740
  650823
  661382
  666766
  677766
  679034
  681310
  689521
  696518
  719336
  720197
  724177
  756469
  766021
  775866
  793425
  804531
  811738
]
17.76 ms
(11.32%)
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
  542791
  581552
  648740
  650823
  661382
  696518
  561103
  565355
  567762
  572537
  581660
  641671
  593850
  640806
  775866
  793425
  811738
  766021
  724177
  632256
  451578
  423518
  428409
  426033
  474644
  420575
  440816
  446004
  517849
  526735
  492434
  504536
  506800
  531070
  583716
  562204
  395566
  468753
  472720
  515742
  554519
  564160
  443320
  429088
  431410
  435496
  459784
  448121
  448828
  472937
  485270
  522899
  525657
  531252
  532982
  496551
  502249
  502890
  531540
  543475
  550437
  562269
  583503
  542753
  559760
  559374
  562247
  666766
  679034
  681310
  719336
  630765
  640380
  598038
  804531
  720197
  444586
  439695
  408563
  522843
  484695
  487150
  488156
  507078
  517981
  509998
  514600
  528202
  448351
  576271
  689521
  621371
  514467
  483875
  516245
  451974
  604894
  608928
  490533
  535094
  415615
  421526
  420192
  644914
  468044
  458905
  474655
  468717
  528791
  558138
  571847
  581349
  677766
  545586
  569096
  637121
  593162
  603675
  633786
  756469
]
3.33 ms
(2.12%)
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
  395566
  408563
  415615
  420192
  420575
  421526
  423518
  426033
  428409
  429088
  431410
  435496
  439695
  440816
  443320
  444586
  446004
  448121
  448351
  448828
  451578
  451974
  458905
  459784
  468044
  468717
  468753
  472720
  472937
  474644
  474655
  483875
  484695
  485270
  487150
  488156
  490533
  492434
  496551
  502249
  502890
  504536
  506800
  507078
  509998
  514467
  514600
  515742
  516245
  517849
  517981
  522843
  522899
  525657
  526735
  528202
  528791
  531070
  531252
  531540
  532982
  535094
  542753
  542791
  543475
  545586
  550437
  554519
  558138
  559374
  559760
  561103
  562204
  562247
  562269
  564160
  565355
  567762
  569096
  571847
  572537
  576271
  581349
  581552
  581660
  583503
  583716
  593162
  593850
  598038
  603675
  604894
  608928
  621371
  630765
  632256
  633786
  637121
  640380
  640806
  641671
  644914
  648740
  650823
  661382
  666766
  677766
  679034
  681310
  689521
  696518
  719336
  720197
  724177
  756469
  766021
  775866
  793425
  804531
  811738
]
1.95 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дрочит двум"
]
1.79 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк двум"
]
1.68 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.95%)
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.