Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.58 ms
(87.28%)
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
  384532
  409893
  427363
  436569
  465284
  474895
  481906
  485812
  494086
  499371
  504656
  510973
  512918
  518977
  520527
  527395
  531210
  531803
  532837
  532989
  533367
  533606
  533665
  533901
  534627
  536546
  537763
  537922
  543363
  545790
  545848
  547631
  555297
  558156
  563619
  572556
  576687
  579849
  585337
  587445
  588226
  589598
  590287
  591165
  591874
  592206
  592511
  593599
  595663
  597225
  597228
  597843
  599958
  599971
  600459
  600471
  600636
  601544
  606564
  609753
  611274
  613517
  614730
  615076
  618589
  620163
  620512
  621689
  622819
  625266
  629920
  630414
  632579
  637136
  638623
  641764
  641921
  641977
  644962
  647901
  648914
  649830
  659385
  662023
  666548
  666912
  668518
  671674
  674340
  676571
  679785
  690868
  692327
  693030
  693864
  694058
  694115
  694212
  695249
  696353
  698537
  699718
  718804
  719104
  724698
  726911
  733866
  733867
  740118
  748686
  773252
  787007
  789820
  792552
  793671
  793916
  800378
  805433
  823904
]
13.17 ms
(6.78%)
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
  718804
  676571
  694212
  695249
  698537
  579849
  593599
  590287
  595663
  638623
  641921
  592511
  611274
  601544
  622819
  787007
  793671
  793916
  800378
  805433
  773252
  726911
  740118
  618589
  409893
  632579
  384532
  465284
  474895
  494086
  533665
  504656
  531803
  533901
  510973
  543363
  545848
  545790
  563619
  674340
  696353
  690868
  693030
  693864
  694115
  699718
  547631
  572556
  600636
  615076
  621689
  592206
  585337
  588226
  591165
  599971
  587445
  591874
  620163
  620512
  625266
  789820
  792552
  724698
  733866
  436569
  485812
  499371
  527395
  537922
  518977
  512918
  520527
  558156
  576687
  648914
  649830
  659385
  679785
  719104
  666912
  671674
  599958
  600459
  613517
  589598
  606564
  630414
  748686
  629920
  823904
  481906
  531210
  533606
  536546
  532989
  555297
  647901
  666548
  692327
  694058
  662023
  668518
  597225
  637136
  597228
  600471
  597843
  641977
  733867
  614730
  641764
  824599
  427363
  644962
  609753
  534627
  537763
  532837
  533367
]
2.93 ms
(1.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пят"
]
2.78 ms
(1.43%)
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
  384532
  409893
  427363
  436569
  465284
  474895
  481906
  485812
  494086
  499371
  504656
  510973
  512918
  518977
  520527
  527395
  531210
  531803
  532837
  532989
  533367
  533606
  533665
  533901
  534627
  536546
  537763
  537922
  543363
  545790
  545848
  547631
  555297
  558156
  563619
  572556
  576687
  579849
  585337
  587445
  588226
  589598
  590287
  591165
  591874
  592206
  592511
  593599
  595663
  597225
  597228
  597843
  599958
  599971
  600459
  600471
  600636
  601544
  606564
  609753
  611274
  613517
  614730
  615076
  618589
  620163
  620512
  621689
  622819
  625266
  629920
  630414
  632579
  637136
  638623
  641764
  641921
  641977
  644962
  647901
  648914
  649830
  659385
  662023
  666548
  666912
  668518
  671674
  674340
  676571
  679785
  690868
  692327
  693030
  693864
  694058
  694115
  694212
  695249
  696353
  698537
  699718
  718804
  719104
  724698
  726911
  733866
  733867
  740118
  748686
  773252
  787007
  789820
  792552
  793671
  793916
  800378
  805433
  823904
]
2.05 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пять"
]
1.99 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пят"
]
1.80 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.