Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.93 ms
(85.50%)
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
  43207
  88945
  96521
  96636
  233556
  266369
  289778
  309758
  379777
  385408
  385674
  386414
  387884
  391837
  391840
  397211
  398960
  399355
  400801
  403279
  413529
  428160
  444083
  458207
  470016
  470232
  470354
  479999
  505405
  523611
  533489
  543094
  543250
  543988
  564791
  581285
  589707
  599595
  645841
  645881
  661948
  675498
  684989
  691600
  692462
  702896
  705887
  707379
  714465
  717685
  727758
  735559
  737577
  738864
  740968
  741464
  744325
  745023
  746066
  747072
  751648
  755465
  760180
  760886
  768418
  771345
  773884
  773896
  774323
  776761
  785055
  787187
  789556
  791428
  793958
  796276
  799009
  799013
  799018
  799631
  800018
  801073
  803008
  803015
  803254
  803323
  804057
  804302
  804616
  806872
  807101
  808122
  810454
  811214
  811328
  811467
  814478
  815918
  816092
  817315
  817488
  817799
  818418
  818424
  818429
  818506
  818990
  819589
  819998
  820051
  823302
  823808
  824025
  824600
  824603
  825004
  825141
  825142
  828755
]
11.22 ms
(7.93%)
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
  479999
  818990
  707379
  705887
  774323
  746066
  808122
  398960
  413529
  385674
  266369
  825142
  692462
  684989
  589707
  787187
  741464
  738864
  740968
  803323
  470354
  599595
  810454
  818424
  768418
  289778
  96636
  233556
  817488
  800018
  799631
  771345
  803008
  823808
  385408
  564791
  581285
  801073
  824603
  818506
  675498
  691600
  793958
  760886
  744325
  799009
  96521
  816092
  819998
  820051
  823302
  825004
  815918
  819589
  824025
  824600
  533489
  523611
  543988
  645881
  661948
  645841
  804616
  791428
  804302
  751648
  737577
  745023
  760180
  727758
  714465
  785055
  796276
  799013
  799018
  88945
  391840
  391837
  825928
  817315
  828755
  803254
  811467
  747072
  702896
  428160
  399355
  818429
  397211
  387884
  403279
  811214
  458207
  717685
  400801
  543250
  543094
  818418
  811328
  806872
  735559
  804057
  379777
  444083
  309758
  470232
  807101
  776761
  505405
  43207
  755465
  386414
  773884
  773896
  789556
  814478
  803015
  817799
  470016
  825141
]
2.95 ms
(2.09%)
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
  43207
  88945
  96521
  96636
  233556
  266369
  289778
  309758
  379777
  385408
  385674
  386414
  387884
  391837
  391840
  397211
  398960
  399355
  400801
  403279
  413529
  428160
  444083
  458207
  470016
  470232
  470354
  479999
  505405
  523611
  533489
  543094
  543250
  543988
  564791
  581285
  589707
  599595
  645841
  645881
  661948
  675498
  684989
  691600
  692462
  702896
  705887
  707379
  714465
  717685
  727758
  735559
  737577
  738864
  740968
  741464
  744325
  745023
  746066
  747072
  751648
  755465
  760180
  760886
  768418
  771345
  773884
  773896
  774323
  776761
  785055
  787187
  789556
  791428
  793958
  796276
  799009
  799013
  799018
  799631
  800018
  801073
  803008
  803015
  803254
  803323
  804057
  804302
  804616
  806872
  807101
  808122
  810454
  811214
  811328
  811467
  814478
  815918
  816092
  817315
  817488
  817799
  818418
  818424
  818429
  818506
  818990
  819589
  819998
  820051
  823302
  823808
  824025
  824600
  824603
  825004
  825141
  825142
  828755
]
1.99 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stockings blowjob"
]
1.59 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел минет оральн секс"
]
1.45 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.31 ms
(0.92%)
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.