Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.32 ms
(87.99%)
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
  385452
  390857
  400579
  402389
  402928
  422817
  426793
  437360
  437560
  437568
  444265
  449258
  449272
  449307
  449412
  450370
  452726
  461022
  462071
  470384
  485262
  488562
  490237
  498156
  500081
  500323
  502193
  503293
  512366
  522462
  539548
  606035
  606260
  620027
  624964
  636477
  640476
  644115
  668776
  671492
  683428
  708405
  717412
  720564
  720566
  720578
  724430
  724516
  724602
  727510
  728187
  728199
  729278
  733329
  734363
  734408
  739938
  742830
  744153
  744166
  744825
  746041
  746367
  747492
  748966
  750631
  753058
  757920
  762781
  768929
  772360
  775587
  775648
  779362
  782766
  784356
  785672
  785700
  786856
  789066
  792231
  792348
  793189
  793218
  794485
  795016
  795029
  796255
  797024
  799984
  800131
  800172
  800185
  801604
  801612
  804360
  804413
  812114
  813171
  816188
  817808
  818521
  818546
  819388
  819439
  820317
  824209
  824307
  824590
  824601
  824711
  825027
  825126
  825227
  825803
  826350
  826409
  826410
  826695
  826987
]
13.11 ms
(6.62%)
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
  500081
  512366
  818521
  818546
  746367
  789066
  470384
  820317
  824601
  826350
  539548
  800185
  734363
  793189
  795016
  727510
  772360
  461022
  819388
  490237
  812114
  422817
  444265
  437560
  825027
  449258
  450370
  717412
  668776
  708405
  671492
  720564
  720578
  606035
  624964
  636477
  620027
  779362
  800131
  782766
  786856
  796255
  801604
  801612
  724430
  724516
  747492
  753058
  744825
  728187
  744153
  768929
  640476
  784356
  793218
  804413
  813171
  452726
  400579
  437568
  449307
  488562
  502193
  500323
  826695
  826410
  824590
  824209
  825126
  800172
  775648
  785700
  744166
  385452
  426793
  437360
  498156
  462071
  390857
  817808
  824307
  720566
  794485
  795029
  746041
  724602
  728199
  729278
  750631
  762781
  733329
  734408
  742830
  748966
  402389
  606260
  644115
  775587
  739938
  825227
  825803
  826987
  826409
  819439
  824711
  449272
  503293
  799984
  757920
  792231
  797024
  402928
  816188
  792348
  785672
  804360
  449412
  485262
  522462
  683428
]
3.35 ms
(1.69%)
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
  385452
  390857
  400579
  402389
  402928
  422817
  426793
  437360
  437560
  437568
  444265
  449258
  449272
  449307
  449412
  450370
  452726
  461022
  462071
  470384
  485262
  488562
  490237
  498156
  500081
  500323
  502193
  503293
  512366
  522462
  539548
  606035
  606260
  620027
  624964
  636477
  640476
  644115
  668776
  671492
  683428
  708405
  717412
  720564
  720566
  720578
  724430
  724516
  724602
  727510
  728187
  728199
  729278
  733329
  734363
  734408
  739938
  742830
  744153
  744166
  744825
  746041
  746367
  747492
  748966
  750631
  753058
  757920
  762781
  768929
  772360
  775587
  775648
  779362
  782766
  784356
  785672
  785700
  786856
  789066
  792231
  792348
  793189
  793218
  794485
  795016
  795029
  796255
  797024
  799984
  800131
  800172
  800185
  801604
  801612
  804360
  804413
  812114
  813171
  816188
  817808
  818521
  818546
  819388
  819439
  820317
  824209
  824307
  824590
  824601
  824711
  825027
  825126
  825227
  825803
  826350
  826409
  826410
  826695
  826987
]
2.07 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam pussy licking"
]
1.92 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер pussy лиза"
]
1.67 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер pussy лиза"
]

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.