Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.80 ms
(81.59%)
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
  436030
  437947
  440906
  460535
  471429
  474648
  531121
  531249
  531250
  545408
  551186
  559644
  569154
  589752
  591165
  596815
  600807
  601548
  601593
  603187
  604080
  604383
  607091
  607376
  608035
  608744
  609603
  614186
  619408
  620316
  628185
  628410
  630234
  630295
  630902
  632626
  633776
  634161
  634169
  639782
  640712
  644303
  644314
  644321
  644968
  644972
  645879
  647910
  647996
  649114
  649180
  651062
  653630
  656499
  656502
  665317
  665448
  665457
  665921
  666532
  666879
  667196
  667636
  668527
  670098
  670965
  672984
  673357
  678915
  680121
  680142
  684014
  684029
  692293
  692314
  693194
  693596
  695125
  696998
  697025
  703096
  707275
  712006
  720050
  729881
  733877
  736798
  736881
  743782
  744306
  746636
  755759
  756407
  770732
  775758
  775834
  775858
  775862
  775982
  775989
  780655
  788582
  792560
  795593
  801975
  804460
  805275
  806804
  808112
  811164
  814556
  815080
  815214
  815347
  815483
  816905
  817115
  817288
  817346
  825119
]
15.83 ms
(10.60%)
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
  607376
  601593
  607091
  775834
  801975
  804460
  755759
  736881
  770732
  604383
  644303
  707275
  712006
  775982
  775989
  806804
  436030
  471429
  437947
  604080
  460535
  440906
  474648
  569154
  816905
  817115
  644972
  644968
  825119
  815214
  815483
  814556
  815080
  815347
  817288
  817346
  531250
  531121
  531249
  551186
  545408
  559644
  651062
  656499
  665317
  665448
  665457
  666532
  667636
  672984
  693194
  703096
  645879
  647910
  647996
  649114
  649180
  656502
  665921
  666879
  667196
  670098
  670965
  678915
  680142
  684029
  693596
  696998
  653630
  668527
  673357
  680121
  684014
  692293
  692314
  695125
  697025
  720050
  619408
  628185
  634169
  640712
  600807
  628410
  634161
  589752
  591165
  603187
  608744
  609603
  614186
  633776
  644314
  644321
  596815
  601548
  608035
  620316
  630234
  630295
  630902
  632626
  639782
  775758
  795593
  805275
  808112
  811164
  775858
  775862
  780655
  736798
  746636
  788582
  792560
  733877
  756407
  729881
  743782
  744306
]
4.40 ms
(2.95%)
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
  436030
  437947
  440906
  460535
  471429
  474648
  531121
  531249
  531250
  545408
  551186
  559644
  569154
  589752
  591165
  596815
  600807
  601548
  601593
  603187
  604080
  604383
  607091
  607376
  608035
  608744
  609603
  614186
  619408
  620316
  628185
  628410
  630234
  630295
  630902
  632626
  633776
  634161
  634169
  639782
  640712
  644303
  644314
  644321
  644968
  644972
  645879
  647910
  647996
  649114
  649180
  651062
  653630
  656499
  656502
  665317
  665448
  665457
  665921
  666532
  666879
  667196
  667636
  668527
  670098
  670965
  672984
  673357
  678915
  680121
  680142
  684014
  684029
  692293
  692314
  693194
  693596
  695125
  696998
  697025
  703096
  707275
  712006
  720050
  729881
  733877
  736798
  736881
  743782
  744306
  746636
  755759
  756407
  770732
  775758
  775834
  775858
  775862
  775982
  775989
  780655
  788582
  792560
  795593
  801975
  804460
  805275
  806804
  808112
  811164
  814556
  815080
  815214
  815347
  815483
  816905
  817115
  817288
  817346
  825119
]
1.89 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк член double"
]
1.83 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "handjob double"
]
1.79 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дрочк член double"
]
1.74 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.