Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.40 ms
(84.60%)
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
  6056
  161823
  390924
  398140
  398317
  402092
  404622
  405446
  409948
  410096
  417881
  420216
  420356
  429729
  430738
  434492
  445182
  446872
  462390
  463864
  467642
  468873
  471611
  473501
  478052
  481143
  488623
  489168
  491255
  491679
  495267
  498626
  503194
  508179
  508914
  512029
  512781
  513660
  522846
  525375
  525923
  526182
  527226
  527659
  527780
  528776
  529120
  529277
  529792
  531210
  531319
  531530
  532443
  533476
  537203
  540408
  541832
  542590
  543892
  550063
  556406
  557238
  563854
  565505
  565511
  565948
  567207
  569457
  572189
  573302
  590891
  591033
  595270
  595337
  597121
  597246
  600946
  615961
  626811
  628114
  630542
  630765
  632021
  632579
  632690
  632970
  633806
  633972
  636306
  637039
  642060
  643415
  646004
  647313
  647944
  648587
  649186
  655113
  675002
  676116
  681313
  707360
  720237
  732620
  738048
  747012
  770120
  770201
  775752
  792842
  795482
  801091
  805811
  816832
  820917
  823758
  826012
  826874
  828115
  828369
]
15.82 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
  533476
  537203
  420356
  462390
  471611
  478052
  512781
  526182
  527226
  532443
  647944
  595270
  632970
  630542
  632021
  633972
  805811
  747012
  398140
  402092
  390924
  489168
  522846
  649186
  409948
  567207
  792842
  770201
  636306
  632579
  6056
  828369
  591033
  615961
  503194
  491679
  528776
  525923
  543892
  600946
  410096
  398317
  525375
  498626
  404622
  527780
  529277
  572189
  626811
  826012
  541832
  828115
  161823
  430738
  826874
  495267
  467642
  473501
  565511
  565505
  595337
  637039
  775752
  417881
  488623
  491255
  405446
  531530
  816832
  648587
  770120
  738048
  801091
  529792
  434492
  707360
  732620
  550063
  681313
  642060
  429729
  481143
  446872
  468873
  512029
  529120
  531210
  540408
  508179
  513660
  508914
  563854
  565948
  556406
  720237
  647313
  675002
  557238
  569457
  573302
  590891
  597246
  597121
  628114
  643415
  420216
  445182
  527659
  676116
  820917
  531319
  463864
  823758
  795482
  632690
  542590
  646004
  630765
  633806
  655113
]
2.41 ms
(1.49%)
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
  6056
  161823
  390924
  398140
  398317
  402092
  404622
  405446
  409948
  410096
  417881
  420216
  420356
  429729
  430738
  434492
  445182
  446872
  462390
  463864
  467642
  468873
  471611
  473501
  478052
  481143
  488623
  489168
  491255
  491679
  495267
  498626
  503194
  508179
  508914
  512029
  512781
  513660
  522846
  525375
  525923
  526182
  527226
  527659
  527780
  528776
  529120
  529277
  529792
  531210
  531319
  531530
  532443
  533476
  537203
  540408
  541832
  542590
  543892
  550063
  556406
  557238
  563854
  565505
  565511
  565948
  567207
  569457
  572189
  573302
  590891
  591033
  595270
  595337
  597121
  597246
  600946
  615961
  626811
  628114
  630542
  630765
  632021
  632579
  632690
  632970
  633806
  633972
  636306
  637039
  642060
  643415
  646004
  647313
  647944
  648587
  649186
  655113
  675002
  676116
  681313
  707360
  720237
  732620
  738048
  747012
  770120
  770201
  775752
  792842
  795482
  801091
  805811
  816832
  820917
  823758
  826012
  826874
  828115
  828369
]
1.84 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big tits bbc"
]
1.77 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ bbc"
]
1.50 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие сиськ bbc"
]

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.