Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.59 ms
(86.62%)
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
  6710
  99632
  162721
  188150
  266183
  291356
  384419
  388329
  391099
  391354
  393430
  397085
  409573
  409930
  423299
  430777
  434155
  493488
  506339
  510890
  510936
  518786
  522614
  530464
  531929
  534549
  537777
  539632
  540533
  554513
  554892
  558718
  569205
  572351
  584400
  592741
  599716
  600758
  601468
  604570
  605256
  607537
  614292
  616521
  620225
  621536
  634766
  634849
  668480
  680778
  682276
  698111
  707308
  709346
  714620
  716329
  717665
  718040
  720105
  720179
  724632
  728451
  729923
  730547
  734461
  735891
  739608
  740890
  746634
  750743
  753057
  754990
  757288
  757848
  760714
  760738
  765915
  768208
  769834
  770167
  772769
  774147
  778774
  779248
  787870
  788942
  788946
  789243
  789489
  789691
  795731
  799979
  800529
  801398
  802208
  803717
  805704
  805832
  805978
  807143
  807609
  812054
  814541
  815167
  815283
  817283
  817447
  819402
  820117
  820656
  823176
  823801
  824181
  824267
  826520
  826636
  828035
  828142
  828370
  828703
]
14.92 ms
(7.71%)
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
  718040
  720105
  788942
  795731
  800529
  592741
  604570
  621536
  388329
  537777
  668480
  717665
  569205
  616521
  805832
  430777
  506339
  518786
  99632
  162721
  539632
  682276
  601468
  803717
  754990
  769834
  799979
  724632
  753057
  760714
  757848
  709346
  720179
  789489
  807143
  730547
  789243
  789691
  188150
  728451
  826636
  828703
  397085
  409930
  423299
  802208
  815283
  534549
  558718
  787870
  729923
  812054
  707308
  778774
  393430
  820656
  826520
  817283
  823176
  815167
  531929
  554892
  572351
  599716
  605256
  779248
  805978
  734461
  746634
  757288
  765915
  805704
  740890
  739608
  768208
  614292
  291356
  510936
  391354
  434155
  600758
  510890
  716329
  680778
  714620
  634849
  788946
  409573
  522614
  607537
  391099
  820117
  828370
  540533
  698111
  584400
  634766
  770167
  735891
  750743
  554513
  620225
  384419
  266183
  6710
  493488
  801398
  807609
  774147
  760738
  824267
  824181
  817447
  823801
  814541
  819402
  828035
  828142
  530464
  772769
]
4.09 ms
(2.11%)
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
  6710
  99632
  162721
  188150
  266183
  291356
  384419
  388329
  391099
  391354
  393430
  397085
  409573
  409930
  423299
  430777
  434155
  493488
  506339
  510890
  510936
  518786
  522614
  530464
  531929
  534549
  537777
  539632
  540533
  554513
  554892
  558718
  569205
  572351
  584400
  592741
  599716
  600758
  601468
  604570
  605256
  607537
  614292
  616521
  620225
  621536
  634766
  634849
  668480
  680778
  682276
  698111
  707308
  709346
  714620
  716329
  717665
  718040
  720105
  720179
  724632
  728451
  729923
  730547
  734461
  735891
  739608
  740890
  746634
  750743
  753057
  754990
  757288
  757848
  760714
  760738
  765915
  768208
  769834
  770167
  772769
  774147
  778774
  779248
  787870
  788942
  788946
  789243
  789489
  789691
  795731
  799979
  800529
  801398
  802208
  803717
  805704
  805832
  805978
  807143
  807609
  812054
  814541
  815167
  815283
  817283
  817447
  819402
  820117
  820656
  823176
  823801
  824181
  824267
  826520
  826636
  828035
  828142
  828370
  828703
]
1.99 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "очкастая тетка"
]
1.76 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "очкастая мам женщин"
]
1.73 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.72%)
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.