Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.83 ms
(83.92%)
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
  82281
  180923
  191509
  191728
  193390
  203811
  238575
  308886
  382024
  382183
  396165
  411399
  418720
  419055
  421484
  428229
  428322
  429441
  431082
  435052
  440652
  444742
  448051
  453148
  455070
  464346
  464706
  465882
  466043
  466318
  467621
  468108
  468533
  469453
  472937
  476707
  477422
  478396
  485075
  485083
  485522
  487578
  490932
  491906
  491950
  495104
  496803
  499912
  500628
  503682
  505040
  505944
  507797
  508283
  509362
  511341
  511503
  511567
  515137
  515615
  515631
  515733
  515737
  517001
  517143
  517559
  520937
  522784
  522961
  523903
  527235
  528849
  532978
  546762
  549680
  559889
  563221
  570179
  571822
  583729
  585476
  588321
  588332
  594903
  598348
  600749
  601119
  601271
  601297
  630754
  644636
  644642
  650785
  663348
  668518
  668528
  671647
  677843
  689715
  707353
  747386
  748208
  752920
  759860
  775821
  776753
  786940
  789232
  796120
  799965
  814884
  814938
  815093
  815123
  815141
  815895
  817868
  817934
  818432
  828759
]
15.84 ms
(10.24%)
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
  776753
  759860
  707353
  382183
  478396
  429441
  532978
  598348
  585476
  428322
  455070
  444742
  520937
  238575
  382024
  671647
  594903
  411399
  559889
  505944
  528849
  464346
  515631
  522961
  503682
  644636
  630754
  650785
  517559
  515137
  485083
  191728
  419055
  818432
  677843
  588332
  799965
  747386
  421484
  491950
  509362
  786940
  476707
  517143
  546762
  549680
  418720
  601271
  748208
  308886
  203811
  477422
  431082
  435052
  523903
  570179
  668518
  464706
  440652
  468108
  511567
  485075
  583729
  817934
  815141
  817868
  499912
  601297
  752920
  396165
  515615
  814938
  468533
  527235
  571822
  563221
  588321
  796120
  467621
  500628
  517001
  487578
  485522
  495104
  828759
  689715
  600749
  775821
  466318
  522784
  507797
  515737
  515733
  663348
  491906
  815895
  815123
  453148
  180923
  505040
  814884
  448051
  191509
  815093
  465882
  466043
  490932
  496803
  472937
  668528
  644642
  508283
  511341
  428229
  789232
  601119
  469453
  193390
  82281
  511503
]
2.78 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
  82281
  180923
  191509
  191728
  193390
  203811
  238575
  308886
  382024
  382183
  396165
  411399
  418720
  419055
  421484
  428229
  428322
  429441
  431082
  435052
  440652
  444742
  448051
  453148
  455070
  464346
  464706
  465882
  466043
  466318
  467621
  468108
  468533
  469453
  472937
  476707
  477422
  478396
  485075
  485083
  485522
  487578
  490932
  491906
  491950
  495104
  496803
  499912
  500628
  503682
  505040
  505944
  507797
  508283
  509362
  511341
  511503
  511567
  515137
  515615
  515631
  515733
  515737
  517001
  517143
  517559
  520937
  522784
  522961
  523903
  527235
  528849
  532978
  546762
  549680
  559889
  563221
  570179
  571822
  583729
  585476
  588321
  588332
  594903
  598348
  600749
  601119
  601271
  601297
  630754
  644636
  644642
  650785
  663348
  668518
  668528
  671647
  677843
  689715
  707353
  747386
  748208
  752920
  759860
  775821
  776753
  786940
  789232
  796120
  799965
  814884
  814938
  815093
  815123
  815141
  815895
  817868
  817934
  818432
  828759
]
1.79 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "office in sex"
]
1.57 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секретарш секс"
]
1.49 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 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.