Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.97 ms
(85.19%)
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
  32549
  383354
  401463
  401509
  402419
  406521
  429936
  449097
  453108
  461422
  469379
  474078
  474408
  483906
  487329
  490117
  490637
  492328
  500472
  506848
  510894
  512869
  518289
  520187
  527333
  533390
  539335
  539349
  548421
  550651
  559405
  563112
  563293
  563683
  576474
  576771
  578158
  578174
  584921
  588900
  596523
  596967
  598368
  599737
  607996
  610726
  612160
  614777
  614847
  617575
  619648
  623525
  628295
  632246
  652159
  652315
  661969
  663903
  665294
  665416
  666919
  670952
  677371
  681075
  686058
  693926
  694192
  694987
  698768
  707605
  709298
  709549
  714179
  715370
  715722
  720397
  723380
  724008
  724520
  724696
  726831
  729759
  729886
  729972
  730288
  730326
  732169
  733265
  735947
  736943
  737840
  739060
  739955
  749475
  750072
  755458
  759015
  786639
  789269
  795894
  801206
  801347
  802382
  810056
  810259
  812055
  815822
  817134
  818252
  818396
  820365
  820491
  823835
  824125
  825152
  825259
  825873
  825959
  826203
  826554
]
13.60 ms
(8.98%)
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
  563112
  576771
  652159
  715370
  709549
  607996
  614777
  810259
  812055
  729759
  729886
  733265
  726831
  730288
  737840
  632246
  709298
  715722
  401509
  500472
  487329
  820365
  825959
  826203
  820491
  825259
  652315
  598368
  749475
  786639
  755458
  698768
  714179
  723380
  693926
  550651
  512869
  826554
  801347
  518289
  492328
  533390
  818396
  663903
  619648
  736943
  735947
  402419
  720397
  681075
  686058
  801206
  810056
  623525
  815822
  818252
  824125
  694987
  628295
  795894
  724008
  730326
  610726
  383354
  32549
  453108
  483906
  490637
  506848
  520187
  527333
  539349
  539335
  461422
  563293
  576474
  578158
  548421
  563683
  584921
  665416
  707605
  670952
  677371
  694192
  665294
  559405
  578174
  614847
  588900
  596523
  599737
  612160
  596967
  617575
  802382
  789269
  724696
  729972
  732169
  739060
  724520
  739955
  750072
  759015
  474078
  429936
  406521
  510894
  449097
  661969
  666919
  474408
  490117
  469379
  401463
  825152
  825873
  817134
  823835
]
2.89 ms
(1.91%)
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
  32549
  383354
  401463
  401509
  402419
  406521
  429936
  449097
  453108
  461422
  469379
  474078
  474408
  483906
  487329
  490117
  490637
  492328
  500472
  506848
  510894
  512869
  518289
  520187
  527333
  533390
  539335
  539349
  548421
  550651
  559405
  563112
  563293
  563683
  576474
  576771
  578158
  578174
  584921
  588900
  596523
  596967
  598368
  599737
  607996
  610726
  612160
  614777
  614847
  617575
  619648
  623525
  628295
  632246
  652159
  652315
  661969
  663903
  665294
  665416
  666919
  670952
  677371
  681075
  686058
  693926
  694192
  694987
  698768
  707605
  709298
  709549
  714179
  715370
  715722
  720397
  723380
  724008
  724520
  724696
  726831
  729759
  729886
  729972
  730288
  730326
  732169
  733265
  735947
  736943
  737840
  739060
  739955
  749475
  750072
  755458
  759015
  786639
  789269
  795894
  801206
  801347
  802382
  810056
  810259
  812055
  815822
  817134
  818252
  818396
  820365
  820491
  823835
  824125
  825152
  825259
  825873
  825959
  826203
  826554
]
1.72 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy pussy cock"
]
1.50 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая pussy cock"
]
1.47 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.25 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая pussy cock"
]

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.