Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.71 ms
(84.49%)
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
  404734
  416989
  419933
  443231
  447553
  447629
  454802
  454954
  463893
  466161
  468171
  468835
  470949
  481142
  482583
  487362
  493122
  499104
  510877
  515358
  516073
  516684
  519592
  529794
  529998
  530482
  530659
  532360
  532760
  532963
  533013
  533062
  533928
  536359
  536638
  536674
  536744
  537204
  539203
  544816
  545611
  549092
  554210
  555104
  557676
  569174
  573493
  582540
  584503
  591805
  598451
  598584
  599872
  599927
  600337
  601544
  602928
  606633
  612399
  617424
  620663
  626021
  628082
  628334
  630541
  631202
  632649
  635975
  637442
  639741
  639745
  639824
  640751
  641097
  641938
  641953
  641956
  641996
  642310
  646200
  647860
  651601
  651634
  656842
  666525
  668463
  668505
  671648
  672686
  674988
  676023
  676088
  677676
  678117
  678532
  689949
  701500
  707418
  713695
  715788
  716901
  719480
  723494
  725047
  729055
  730724
  736735
  738912
  739993
  742348
  744653
  751503
  751565
  751670
  760689
  761231
  768957
  785503
  805263
  805513
]
18.63 ms
(9.61%)
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
  641097
  606633
  591805
  598584
  601544
  725047
  730724
  785503
  738912
  742348
  751670
  751503
  768957
  404734
  463893
  447553
  516684
  468171
  539203
  536744
  530659
  545611
  651601
  599927
  641953
  635975
  639745
  641996
  751565
  529794
  672686
  569174
  671648
  719480
  642310
  630541
  739993
  744653
  805513
  760689
  530482
  482583
  536674
  533062
  668463
  599872
  416989
  468835
  499104
  584503
  666525
  557676
  628082
  519592
  487362
  493122
  533013
  647860
  639741
  443231
  555104
  602928
  573493
  549092
  656842
  701500
  707418
  713695
  646200
  689949
  723494
  641938
  598451
  626021
  729055
  736735
  715788
  805263
  761231
  419933
  454954
  481142
  454802
  515358
  532760
  533928
  536359
  536638
  532360
  537204
  532963
  544816
  678117
  678532
  716901
  651634
  674988
  676088
  668505
  676023
  677676
  582540
  628334
  632649
  637442
  612399
  639824
  600337
  631202
  641956
  617424
  640751
  470949
  516073
  554210
  620663
  466161
  529998
  510877
  447629
]
3.39 ms
(1.75%)
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
  404734
  416989
  419933
  443231
  447553
  447629
  454802
  454954
  463893
  466161
  468171
  468835
  470949
  481142
  482583
  487362
  493122
  499104
  510877
  515358
  516073
  516684
  519592
  529794
  529998
  530482
  530659
  532360
  532760
  532963
  533013
  533062
  533928
  536359
  536638
  536674
  536744
  537204
  539203
  544816
  545611
  549092
  554210
  555104
  557676
  569174
  573493
  582540
  584503
  591805
  598451
  598584
  599872
  599927
  600337
  601544
  602928
  606633
  612399
  617424
  620663
  626021
  628082
  628334
  630541
  631202
  632649
  635975
  637442
  639741
  639745
  639824
  640751
  641097
  641938
  641953
  641956
  641996
  642310
  646200
  647860
  651601
  651634
  656842
  666525
  668463
  668505
  671648
  672686
  674988
  676023
  676088
  677676
  678117
  678532
  689949
  701500
  707418
  713695
  715788
  716901
  719480
  723494
  725047
  729055
  730724
  736735
  738912
  739993
  742348
  744653
  751503
  751565
  751670
  760689
  761231
  768957
  785503
  805263
  805513
]
2.34 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo anal cock"
]
2.01 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд анал cock"
]
1.73 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд анал cock"
]

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.