Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.08 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
  410791
  422132
  427126
  429387
  433397
  438290
  438417
  444806
  453508
  455478
  456549
  456605
  456877
  459937
  473435
  474714
  477338
  479953
  479965
  486223
  488155
  493242
  494496
  496932
  497167
  503544
  506232
  509705
  511077
  511102
  511452
  511466
  517128
  517393
  519323
  520553
  521122
  521676
  524205
  525089
  525369
  530381
  530383
  530476
  530484
  530911
  531114
  531115
  531145
  531179
  531200
  531206
  531209
  531210
  531211
  531225
  531232
  531252
  532733
  532744
  532837
  533043
  533368
  536748
  537123
  537887
  537936
  542591
  543910
  544050
  550199
  552352
  565243
  569923
  575882
  581263
  583793
  585787
  590485
  593485
  595676
  596693
  599911
  600219
  600270
  600329
  606574
  616758
  616765
  616776
  632698
  634157
  637431
  637444
  639816
  641681
  648862
  666867
  676622
  696229
  702675
  703832
  703841
  704269
  715365
  729629
  731683
  734140
  761829
  765040
  780177
  782557
  794436
  794947
  797343
  798071
  798854
  800535
  805274
  824456
]
16.56 ms
(9.46%)
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
  782557
  488155
  590485
  734140
  797343
  798854
  794436
  543910
  511077
  521676
  544050
  427126
  503544
  511466
  520553
  511102
  422132
  496932
  780177
  521122
  524205
  531200
  537936
  552352
  569923
  616776
  729629
  479953
  517128
  525369
  494496
  824456
  715365
  634157
  637444
  798071
  761829
  765040
  479965
  509705
  596693
  800535
  575882
  519323
  581263
  444806
  456549
  473435
  486223
  456605
  537887
  532744
  585787
  438290
  477338
  531179
  696229
  666867
  648862
  616765
  794947
  459937
  583793
  606574
  632698
  637431
  595676
  600329
  616758
  506232
  429387
  537123
  438417
  517393
  511452
  455478
  456877
  531145
  542591
  731683
  433397
  530911
  531210
  532733
  530484
  531209
  531211
  533043
  550199
  704269
  703832
  703841
  453508
  531206
  474714
  676622
  593485
  702675
  599911
  600270
  600219
  639816
  805274
  641681
  497167
  530381
  531252
  565243
  410791
  525089
  493242
  530383
  531225
  531232
  531115
  533368
  536748
  530476
  531114
  532837
]
3.74 ms
(2.14%)
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
  410791
  422132
  427126
  429387
  433397
  438290
  438417
  444806
  453508
  455478
  456549
  456605
  456877
  459937
  473435
  474714
  477338
  479953
  479965
  486223
  488155
  493242
  494496
  496932
  497167
  503544
  506232
  509705
  511077
  511102
  511452
  511466
  517128
  517393
  519323
  520553
  521122
  521676
  524205
  525089
  525369
  530381
  530383
  530476
  530484
  530911
  531114
  531115
  531145
  531179
  531200
  531206
  531209
  531210
  531211
  531225
  531232
  531252
  532733
  532744
  532837
  533043
  533368
  536748
  537123
  537887
  537936
  542591
  543910
  544050
  550199
  552352
  565243
  569923
  575882
  581263
  583793
  585787
  590485
  593485
  595676
  596693
  599911
  600219
  600270
  600329
  606574
  616758
  616765
  616776
  632698
  634157
  637431
  637444
  639816
  641681
  648862
  666867
  676622
  696229
  702675
  703832
  703841
  704269
  715365
  729629
  731683
  734140
  761829
  765040
  780177
  782557
  794436
  794947
  797343
  798071
  798854
  800535
  805274
  824456
]
2.02 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "balls handjob"
]
1.73 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "balls дрочк член"
]
1.30 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "balls дрочк член"
]

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.