Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.15 ms
(47.87%)
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
  418268
  424103
  427575
  437707
  443893
  446233
  449514
  452335
  455698
  457505
  463295
  470492
  481390
  489033
  496217
  496479
  508210
  513921
  522522
  524433
  524959
  526887
  529419
  529503
  532369
  533777
  536107
  540181
  540419
  541093
  548418
  549070
  549087
  556075
  557828
  558777
  559318
  570104
  575349
  576167
  577725
  579615
  580119
  583662
  585192
  585364
  585543
  587523
  587747
  587962
  589317
  589460
  589814
  592261
  592269
  593745
  594615
  600930
  602448
  602525
  603114
  603594
  605681
  612963
  613998
  615995
  629116
  632128
  642259
  642950
  645519
  647122
  649068
  649207
  655208
  656208
  664409
  666724
  668972
  670064
  670251
  675453
  677379
  684404
  684430
  691291
  696563
  697657
  699181
  700055
  708078
  716985
  717877
  734923
  761601
  761677
  764303
  770591
  775681
  776902
  778882
  779384
  779721
  780568
  783464
  783996
  784250
  784849
  788359
  797087
  804808
  805456
  806175
  808283
  809638
  813669
  815094
  816682
  827850
]
205.34 ms
(46.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
13.65 ms
(3.11%)
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
  664409
  670064
  696563
  691291
  708078
  602525
  587523
  589814
  603114
  784849
  806175
  632128
  700055
  775681
  470492
  437707
  449514
  455698
  489033
  815094
  783996
  629116
  418268
  615995
  536107
  496479
  557828
  666724
  813669
  816682
  827850
  452335
  524433
  532369
  533777
  526887
  540181
  541093
  549070
  549087
  558777
  647122
  655208
  677379
  699181
  649207
  668972
  684430
  697657
  717877
  649068
  656208
  684404
  556075
  575349
  580119
  585364
  587747
  587962
  592261
  605681
  642259
  593745
  594615
  600930
  585192
  586568
  585543
  779384
  779721
  780568
  784250
  804808
  761601
  761677
  783464
  805456
  734923
  764303
  770591
  613998
  642950
  716985
  776902
  778882
  788359
  797087
  808283
  809638
  446233
  559318
  576167
  463295
  481390
  508210
  670251
  645519
  675453
  548418
  589460
  602448
  612963
  603594
  427575
  424103
  443893
  540419
  457505
  522522
  529419
  529503
  496217
  524959
  513921
  570104
  577725
  579615
  583662
  589317
  592269
]
4.11 ms
(0.94%)
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
  418268
  424103
  427575
  437707
  443893
  446233
  449514
  452335
  455698
  457505
  463295
  470492
  481390
  489033
  496217
  496479
  508210
  513921
  522522
  524433
  524959
  526887
  529419
  529503
  532369
  533777
  536107
  540181
  540419
  541093
  548418
  549070
  549087
  556075
  557828
  558777
  559318
  570104
  575349
  576167
  577725
  579615
  580119
  583662
  585192
  585364
  585543
  587523
  587747
  587962
  589317
  589460
  589814
  592261
  592269
  593745
  594615
  600930
  602448
  602525
  603114
  603594
  605681
  612963
  613998
  615995
  629116
  632128
  642259
  642950
  645519
  647122
  649068
  649207
  655208
  656208
  664409
  666724
  668972
  670064
  670251
  675453
  677379
  684404
  684430
  691291
  696563
  697657
  699181
  700055
  708078
  716985
  717877
  734923
  761601
  761677
  764303
  770591
  775681
  776902
  778882
  779384
  779721
  780568
  783464
  783996
  784250
  784849
  788359
  797087
  804808
  805456
  806175
  808283
  809638
  813669
  815094
  816682
  827850
]
2.20 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов вагин"
]
1.90 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov vagina"
]
1.62 ms
(0.37%)
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.