Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.63 ms
(83.64%)
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
  478472
  480038
  506960
  526817
  527857
  529080
  535557
  535686
  535728
  542928
  551292
  617364
  624232
  627567
  629774
  631334
  632103
  633338
  634003
  638750
  640688
  646375
  650610
  658869
  661787
  663205
  664551
  668698
  674280
  681646
  685805
  693285
  696975
  699767
  704797
  707577
  707730
  708734
  709466
  710168
  713399
  714878
  718391
  720011
  720571
  720648
  724785
  725646
  726263
  727829
  728306
  729634
  729669
  729718
  730083
  731834
  731890
  732261
  733714
  734412
  734443
  734814
  735393
  735679
  736716
  737286
  738556
  738942
  739180
  739200
  739954
  740244
  743763
  744074
  744991
  744992
  745943
  747376
  749515
  749679
  750259
  750306
  750328
  750360
  750467
  750558
  750641
  751244
  751419
  752292
  752534
  752547
  753929
  755688
  757438
  757465
  757587
  758345
  759534
  759660
  759901
  760896
  764074
  770438
  770477
  771413
  771725
  773855
  782297
  789113
  793843
  793882
  808515
  812920
  813683
  814126
  823423
  824179
  828644
]
14.40 ms
(9.90%)
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
  617364
  627567
  629774
  638750
  640866
  789113
  793843
  793882
  725646
  729634
  729718
  734443
  736716
  739200
  740244
  747376
  750259
  750306
  750467
  750558
  751244
  753929
  755688
  758345
  770477
  771413
  782297
  808515
  812920
  726263
  727829
  729669
  731834
  732261
  734412
  735679
  744991
  750641
  752534
  724785
  730083
  733714
  734814
  737286
  738556
  739180
  743763
  749515
  750360
  760896
  764074
  771725
  773855
  731890
  744074
  750328
  752292
  757438
  757465
  759534
  759660
  759901
  728306
  735393
  738942
  739954
  744992
  745943
  749679
  751419
  752547
  757587
  770438
  624232
  631334
  632103
  633338
  634003
  640688
  696975
  707577
  709466
  713399
  720571
  720648
  814126
  823423
  824179
  813683
  828644
  478472
  480038
  506960
  529080
  535686
  535557
  526817
  527857
  535728
  542928
  551292
  650610
  663205
  707730
  720011
  658869
  681646
  685805
  693285
  708734
  710168
  714878
  718391
  646375
  661787
  664551
  668698
  674280
  699767
  704797
]
2.72 ms
(1.87%)
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
  478472
  480038
  506960
  526817
  527857
  529080
  535557
  535686
  535728
  542928
  551292
  617364
  624232
  627567
  629774
  631334
  632103
  633338
  634003
  638750
  640688
  646375
  650610
  658869
  661787
  663205
  664551
  668698
  674280
  681646
  685805
  693285
  696975
  699767
  704797
  707577
  707730
  708734
  709466
  710168
  713399
  714878
  718391
  720011
  720571
  720648
  724785
  725646
  726263
  727829
  728306
  729634
  729669
  729718
  730083
  731834
  731890
  732261
  733714
  734412
  734443
  734814
  735393
  735679
  736716
  737286
  738556
  738942
  739180
  739200
  739954
  740244
  743763
  744074
  744991
  744992
  745943
  747376
  749515
  749679
  750259
  750306
  750328
  750360
  750467
  750558
  750641
  751244
  751419
  752292
  752534
  752547
  753929
  755688
  757438
  757465
  757587
  758345
  759534
  759660
  759901
  760896
  764074
  770438
  770477
  771413
  771725
  773855
  782297
  789113
  793843
  793882
  808515
  812920
  813683
  814126
  823423
  824179
  828644
]
1.96 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbation dick"
]
1.88 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац член"
]
1.50 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.91%)
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.