Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.29 ms
(82.65%)
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
  365295
  384883
  387324
  392789
  421989
  422198
  427550
  430048
  442318
  455281
  466963
  469476
  471403
  471629
  482346
  487435
  488123
  489082
  496101
  504927
  513076
  515305
  519087
  519278
  519931
  524865
  524896
  527249
  532054
  539649
  542677
  544312
  556643
  556661
  557958
  561559
  563014
  571508
  583067
  589629
  591112
  591636
  593165
  599726
  601234
  602959
  603733
  660357
  663516
  681146
  702050
  702465
  705553
  715696
  717740
  718279
  719065
  723938
  726667
  728089
  729570
  733973
  734313
  737089
  740158
  750890
  752539
  753620
  754850
  756070
  760166
  760816
  769978
  770002
  771394
  774116
  774131
  775569
  776775
  784304
  784587
  784850
  789505
  789716
  795559
  798393
  799054
  802095
  802981
  804302
  807969
  810506
  813045
  813245
  813486
  813779
  814898
  814941
  815678
  815824
  815913
  816008
  816941
  817040
  818672
  820005
  820007
  821171
  821653
  821801
  821905
  822385
  823397
  823619
  824840
  825681
  826303
  826761
]
15.22 ms
(9.81%)
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
  561559
  593165
  603733
  776775
  784850
  798393
  802095
  807969
  775569
  789505
  795559
  804302
  813486
  740158
  769978
  774116
  802981
  810506
  728089
  733973
  729570
  760166
  737089
  771394
  771729
  702050
  705553
  813045
  813245
  384883
  816008
  825681
  421989
  488123
  524865
  496101
  430048
  442318
  471629
  524896
  513076
  519087
  519931
  487435
  489082
  469476
  816941
  815824
  820005
  826303
  544312
  718279
  702465
  717740
  589629
  756070
  750890
  723938
  753620
  774131
  455281
  557958
  556643
  559076
  571508
  601234
  602959
  784304
  527249
  519278
  471403
  556661
  563014
  599726
  422198
  542677
  583067
  760816
  821801
  821905
  817040
  660357
  663516
  681146
  591636
  789716
  752539
  734313
  754850
  770002
  482346
  466963
  427550
  504927
  824840
  539649
  532054
  515305
  719065
  591112
  726667
  715696
  784587
  799054
  387324
  392789
  365295
  814898
  815678
  821171
  821653
  823619
  814941
  815913
  818672
  820007
  822385
  823397
  826761
  813779
]
3.64 ms
(2.34%)
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
  365295
  384883
  387324
  392789
  421989
  422198
  427550
  430048
  442318
  455281
  466963
  469476
  471403
  471629
  482346
  487435
  488123
  489082
  496101
  504927
  513076
  515305
  519087
  519278
  519931
  524865
  524896
  527249
  532054
  539649
  542677
  544312
  556643
  556661
  557958
  561559
  563014
  571508
  583067
  589629
  591112
  591636
  593165
  599726
  601234
  602959
  603733
  660357
  663516
  681146
  702050
  702465
  705553
  715696
  717740
  718279
  719065
  723938
  726667
  728089
  729570
  733973
  734313
  737089
  740158
  750890
  752539
  753620
  754850
  756070
  760166
  760816
  769978
  770002
  771394
  774116
  774131
  775569
  776775
  784304
  784587
  784850
  789505
  789716
  795559
  798393
  799054
  802095
  802981
  804302
  807969
  810506
  813045
  813245
  813486
  813779
  814898
  814941
  815678
  815824
  815913
  816008
  816941
  817040
  818672
  820005
  820007
  821171
  821653
  821801
  821905
  822385
  823397
  823619
  824840
  825681
  826303
  826761
]
2.25 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dick for mom"
]
2.04 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член mom"
]
1.95 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "член mom"
]

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.