Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.32 ms
(86.69%)
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
  6864
  57952
  337704
  383000
  385928
  392391
  392902
  395465
  398376
  398413
  398446
  405705
  407108
  416737
  421590
  440094
  441838
  445011
  445413
  446274
  457228
  457451
  462006
  465582
  467885
  467938
  468169
  469759
  474749
  474968
  477055
  480065
  480450
  480656
  483615
  497906
  503166
  510102
  530698
  537648
  543648
  544108
  547236
  547472
  547476
  555601
  568261
  573270
  578298
  582277
  584164
  587260
  588929
  591206
  597502
  600358
  600444
  604316
  605155
  623379
  628656
  632565
  634067
  636948
  649960
  654901
  659035
  661148
  668449
  670357
  670360
  696593
  699624
  702033
  709850
  710659
  712174
  713185
  713987
  720216
  722937
  729231
  736218
  736741
  736971
  740849
  745503
  748309
  751040
  752595
  752687
  756841
  761087
  761621
  765480
  766788
  776048
  777847
  780404
  781568
  782351
  782650
  782789
  783364
  785582
  787113
  788486
  797478
  799683
  799695
  799696
  799697
  799699
  799861
  800577
  803092
  804317
  813597
  817613
  826043
]
12.31 ms
(7.55%)
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
  649960
  537648
  722937
  668449
  799699
  817613
  582277
  632565
  776048
  799697
  748309
  604316
  480065
  783364
  781568
  799683
  547472
  584164
  600444
  634067
  605155
  785582
  752595
  745503
  392391
  555601
  57952
  457228
  659035
  468169
  782650
  765480
  813597
  568261
  799695
  756841
  799861
  740849
  712174
  337704
  826043
  547236
  670357
  782351
  407108
  661148
  787113
  547476
  696593
  457451
  720216
  654901
  623379
  636948
  421590
  702033
  803092
  467885
  474749
  530698
  600358
  578298
  670360
  445011
  440094
  483615
  469759
  543648
  395465
  416737
  446274
  544108
  710659
  713185
  709850
  597502
  777847
  782789
  729231
  385928
  713987
  761087
  398413
  477055
  398446
  628656
  588929
  804317
  780404
  6864
  800577
  751040
  797478
  405705
  480450
  510102
  497906
  736218
  591206
  467938
  736741
  503166
  699624
  788486
  799696
  766788
  398376
  392902
  441838
  462006
  465582
  573270
  587260
  445413
  474968
  752687
  761621
  736971
  383000
  480656
]
2.89 ms
(1.77%)
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
  6864
  57952
  337704
  383000
  385928
  392391
  392902
  395465
  398376
  398413
  398446
  405705
  407108
  416737
  421590
  440094
  441838
  445011
  445413
  446274
  457228
  457451
  462006
  465582
  467885
  467938
  468169
  469759
  474749
  474968
  477055
  480065
  480450
  480656
  483615
  497906
  503166
  510102
  530698
  537648
  543648
  544108
  547236
  547472
  547476
  555601
  568261
  573270
  578298
  582277
  584164
  587260
  588929
  591206
  597502
  600358
  600444
  604316
  605155
  623379
  628656
  632565
  634067
  636948
  649960
  654901
  659035
  661148
  668449
  670357
  670360
  696593
  699624
  702033
  709850
  710659
  712174
  713185
  713987
  720216
  722937
  729231
  736218
  736741
  736971
  740849
  745503
  748309
  751040
  752595
  752687
  756841
  761087
  761621
  765480
  766788
  776048
  777847
  780404
  781568
  782351
  782650
  782789
  783364
  785582
  787113
  788486
  797478
  799683
  799695
  799696
  799697
  799699
  799861
  800577
  803092
  804317
  813597
  817613
  826043
]
1.88 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал дырк"
]
1.61 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал дырк"
]
1.51 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в жопу через дырку"
]
1.50 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.