Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.07 ms
(84.71%)
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
  14382
  79331
  130289
  359067
  383515
  386758
  388713
  389987
  396708
  396746
  397642
  397849
  397946
  401340
  401992
  403141
  405178
  408074
  408332
  408458
  414364
  414448
  414666
  415591
  425125
  432813
  445017
  445741
  449011
  459830
  462390
  468694
  476138
  483734
  488894
  505103
  517184
  530912
  532667
  575792
  575804
  576053
  576360
  583371
  604451
  604570
  612304
  617411
  629375
  629423
  632497
  633563
  635171
  635215
  635501
  643666
  643844
  677783
  697303
  700158
  703842
  714549
  725443
  725510
  725563
  725712
  727457
  729293
  729482
  729570
  730105
  730441
  730717
  731302
  731316
  732002
  732451
  734073
  734743
  734795
  735905
  737259
  738179
  739637
  739678
  740466
  740761
  741571
  742003
  746598
  747232
  749034
  750648
  751681
  753253
  760180
  764343
  765473
  765998
  766245
  767147
  767162
  769978
  775913
  787015
  796424
  800110
  801355
  802464
  803376
  803407
  804023
  805299
  806145
  807720
  807784
  807793
  808684
  812950
  818439
]
17.12 ms
(9.23%)
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
  803376
  803407
  805299
  806145
  725510
  725563
  725712
  729293
  729482
  730105
  730717
  734795
  737259
  740761
  741571
  742003
  749034
  753253
  769978
  787015
  796424
  802464
  804023
  807720
  725443
  732451
  738179
  739678
  740466
  765473
  765998
  730441
  731302
  747232
  751681
  764343
  766245
  727457
  729570
  732002
  734743
  735905
  760180
  767147
  767162
  731316
  734073
  739637
  746598
  750648
  604570
  612304
  629375
  629423
  632497
  633563
  635501
  643666
  643844
  697303
  700158
  703842
  775913
  800110
  801355
  807784
  807793
  808684
  812950
  401992
  79331
  397642
  383515
  459830
  532667
  517184
  530912
  583371
  677783
  617411
  635171
  635215
  425125
  386758
  130289
  359067
  388713
  389987
  396708
  397849
  397946
  401340
  403141
  405178
  408074
  445017
  408332
  414364
  414666
  415591
  408458
  414448
  432813
  818439
  468694
  445741
  462390
  449011
  488894
  505103
  476138
  483734
  575804
  576360
  575792
  576053
  604451
  714549
  14382
  396746
]
4.00 ms
(2.16%)
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
  14382
  79331
  130289
  359067
  383515
  386758
  388713
  389987
  396708
  396746
  397642
  397849
  397946
  401340
  401992
  403141
  405178
  408074
  408332
  408458
  414364
  414448
  414666
  415591
  425125
  432813
  445017
  445741
  449011
  459830
  462390
  468694
  476138
  483734
  488894
  505103
  517184
  530912
  532667
  575792
  575804
  576053
  576360
  583371
  604451
  604570
  612304
  617411
  629375
  629423
  632497
  633563
  635171
  635215
  635501
  643666
  643844
  677783
  697303
  700158
  703842
  714549
  725443
  725510
  725563
  725712
  727457
  729293
  729482
  729570
  730105
  730441
  730717
  731302
  731316
  732002
  732451
  734073
  734743
  734795
  735905
  737259
  738179
  739637
  739678
  740466
  740761
  741571
  742003
  746598
  747232
  749034
  750648
  751681
  753253
  760180
  764343
  765473
  765998
  766245
  767147
  767162
  769978
  775913
  787015
  796424
  800110
  801355
  802464
  803376
  803407
  804023
  805299
  806145
  807720
  807784
  807793
  808684
  812950
  818439
]
2.33 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "порно межрасовое"
]
1.93 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "порн межрасов"
]
1.35 ms
(0.73%)
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.