Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.54 ms
(86.22%)
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
  386862
  387910
  388755
  390593
  390701
  391204
  393738
  393793
  395141
  395548
  396473
  401180
  402657
  402667
  403979
  406931
  408767
  413730
  424846
  429391
  443600
  453852
  470548
  477471
  501785
  511011
  517184
  522532
  523305
  528597
  533410
  541108
  543110
  557937
  557944
  567159
  569097
  570419
  571609
  574828
  575158
  575515
  576046
  579077
  586635
  598833
  601547
  603239
  620557
  622166
  623512
  624850
  628292
  642832
  644292
  644321
  644636
  652172
  652897
  653527
  653563
  653566
  660299
  663409
  663412
  664955
  665431
  665497
  667337
  671501
  679102
  687241
  702344
  703391
  705875
  711904
  717246
  719142
  719289
  721203
  721206
  721397
  721443
  721769
  721791
  721792
  721836
  721842
  722860
  723104
  723507
  729839
  731777
  737893
  740584
  743120
  746997
  747656
  749495
  750751
  770790
  775137
  775893
  790026
  792480
  793629
  798778
  800083
  801275
  805368
  805543
  807495
  807513
  809927
  815132
  816272
  816797
  818351
  819212
]
14.69 ms
(8.04%)
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
  703391
  623512
  453852
  567159
  743120
  477471
  750751
  511011
  528597
  557937
  557944
  574828
  652172
  644292
  586635
  501785
  644321
  603239
  775893
  533410
  644636
  543110
  671501
  721769
  798778
  729839
  622166
  702344
  723104
  393738
  819212
  653563
  737893
  793629
  429391
  408767
  402657
  523305
  393793
  818351
  579077
  653527
  792480
  517184
  667337
  665497
  770790
  800083
  679102
  390701
  815132
  809927
  805543
  387910
  386862
  663412
  642832
  749495
  569097
  443600
  413730
  816272
  570419
  575515
  571609
  660299
  721842
  620557
  624850
  747656
  746997
  722860
  775137
  391204
  401180
  396473
  406931
  395141
  652897
  711904
  628292
  522532
  576046
  541108
  664955
  598833
  470548
  388755
  390593
  719142
  653566
  721792
  719289
  601547
  717246
  705875
  790026
  801275
  731777
  403979
  721203
  721443
  740584
  402667
  395548
  424846
  816797
  672488
  721397
  723507
  663409
  665431
  721206
  687241
  721791
  575158
  805368
  807513
  721836
  807495
]
3.34 ms
(1.83%)
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
  386862
  387910
  388755
  390593
  390701
  391204
  393738
  393793
  395141
  395548
  396473
  401180
  402657
  402667
  403979
  406931
  408767
  413730
  424846
  429391
  443600
  453852
  470548
  477471
  501785
  511011
  517184
  522532
  523305
  528597
  533410
  541108
  543110
  557937
  557944
  567159
  569097
  570419
  571609
  574828
  575158
  575515
  576046
  579077
  586635
  598833
  601547
  603239
  620557
  622166
  623512
  624850
  628292
  642832
  644292
  644321
  644636
  652172
  652897
  653527
  653563
  653566
  660299
  663409
  663412
  664955
  665431
  665497
  667337
  671501
  679102
  687241
  702344
  703391
  705875
  711904
  717246
  719142
  719289
  721203
  721206
  721397
  721443
  721769
  721791
  721792
  721836
  721842
  722860
  723104
  723507
  729839
  731777
  737893
  740584
  743120
  746997
  747656
  749495
  750751
  770790
  775137
  775893
  790026
  792480
  793629
  798778
  800083
  801275
  805368
  805543
  807495
  807513
  809927
  815132
  816272
  816797
  818351
  819212
]
2.12 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18 sex threesome"
]
1.72 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 секс секс втро"
]
1.46 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 секс секс втро"
]

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.