Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.65 ms
(85.14%)
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
  421470
  469225
  469616
  503144
  509170
  515602
  520778
  522736
  530915
  532337
  532525
  533064
  533335
  537158
  546433
  555198
  555275
  567619
  578805
  584040
  588727
  588877
  589298
  590284
  591220
  591719
  591956
  600415
  618561
  632671
  665998
  681422
  688551
  697683
  698613
  709845
  709939
  710031
  710866
  711827
  715440
  717035
  720345
  725221
  729885
  730181
  730668
  732994
  735817
  736681
  736993
  739201
  739865
  740004
  741855
  744576
  748613
  748877
  753158
  759854
  759909
  761080
  761480
  763526
  764913
  766602
  767292
  767536
  768171
  768300
  768990
  771468
  771607
  773451
  773601
  775089
  775244
  775313
  775767
  776362
  778528
  779859
  781128
  781130
  782661
  785601
  785903
  787665
  789044
  790100
  790217
  791257
  791596
  791840
  791870
  791872
  792359
  792577
  792989
  793038
  793054
  793860
  793876
  794426
  795223
  795341
  798751
  798946
  801132
  801354
  803414
  803876
  804839
  805249
  808209
  808304
  812981
  813013
]
14.38 ms
(8.18%)
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
  812981
  787665
  808209
  736681
  768990
  709845
  509170
  698613
  710031
  791872
  732994
  761480
  805249
  764913
  759854
  736993
  791840
  503144
  792577
  588877
  720345
  813013
  532525
  530915
  584040
  665998
  697683
  717035
  546433
  578805
  588727
  591719
  591220
  591956
  589298
  795223
  801354
  808304
  775313
  792359
  792989
  793054
  794426
  748613
  767292
  771468
  785903
  791870
  793038
  804839
  730181
  773601
  729885
  735817
  739865
  766978
  768171
  739201
  744576
  748877
  763526
  771607
  773451
  759909
  711827
  785601
  790100
  790217
  803876
  710866
  537158
  709939
  681422
  688551
  590284
  775767
  782661
  793860
  793876
  775089
  778528
  791257
  795341
  798751
  766602
  767536
  789044
  801132
  769682
  753158
  730668
  768300
  715440
  798946
  791596
  725221
  522736
  469225
  741855
  515602
  775244
  776362
  779859
  781128
  781130
  740004
  761080
  803414
  520778
  533064
  469616
  600415
  632671
  618561
  421470
  532337
  533335
  555275
  555198
  567619
]
3.17 ms
(1.80%)
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
  421470
  469225
  469616
  503144
  509170
  515602
  520778
  522736
  530915
  532337
  532525
  533064
  533335
  537158
  546433
  555198
  555275
  567619
  578805
  584040
  588727
  588877
  589298
  590284
  591220
  591719
  591956
  600415
  618561
  632671
  665998
  681422
  688551
  697683
  698613
  709845
  709939
  710031
  710866
  711827
  715440
  717035
  720345
  725221
  729885
  730181
  730668
  732994
  735817
  736681
  736993
  739201
  739865
  740004
  741855
  744576
  748613
  748877
  753158
  759854
  759909
  761080
  761480
  763526
  764913
  766602
  767292
  767536
  768171
  768300
  768990
  771468
  771607
  773451
  773601
  775089
  775244
  775313
  775767
  776362
  778528
  779859
  781128
  781130
  782661
  785601
  785903
  787665
  789044
  790100
  790217
  791257
  791596
  791840
  791870
  791872
  792359
  792577
  792989
  793038
  793054
  793860
  793876
  794426
  795223
  795341
  798751
  798946
  801132
  801354
  803414
  803876
  804839
  805249
  808209
  808304
  812981
  813013
]
2.31 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кремпа сперм"
]
2.18 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сперма вытекает из"
]
2.05 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.03 ms
(1.15%)
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.