Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.86 ms
(84.14%)
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
  28382
  40835
  361382
  387146
  389065
  390749
  391485
  392469
  403685
  412018
  414043
  423483
  443159
  456444
  483358
  496326
  515886
  523897
  527481
  532284
  534989
  535203
  539550
  540521
  554375
  556978
  558095
  571601
  578419
  591781
  597562
  601819
  606828
  618386
  623426
  634914
  636400
  643329
  645463
  647819
  657745
  669217
  671682
  673696
  682706
  693588
  694325
  705741
  708657
  720571
  724479
  724497
  724844
  728188
  730432
  731580
  731779
  732950
  733127
  734277
  734796
  735962
  736925
  737208
  738198
  738202
  738861
  739789
  742467
  742874
  743005
  746708
  747058
  750558
  752834
  753202
  753317
  755111
  757474
  760761
  764763
  766684
  766807
  768412
  774975
  776269
  778228
  780503
  780797
  782310
  785708
  787884
  788445
  792015
  792252
  793132
  793449
  793610
  793732
  796531
  796936
  797348
  797853
  799202
  799652
  802368
  803082
  805428
  806158
  810148
  812023
  812078
  814723
  817216
  817324
  817518
  818182
  819407
  820665
  823310
]
15.51 ms
(9.54%)
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
  591781
  780503
  805428
  797348
  803082
  736925
  750558
  755111
  785708
  788445
  793132
  793449
  812078
  724497
  731580
  739789
  742874
  753317
  764763
  724844
  746708
  731779
  733127
  734277
  735962
  743005
  757474
  766807
  730432
  747058
  753202
  618386
  623426
  720571
  774975
  787884
  792015
  792252
  793732
  796531
  796936
  802368
  806158
  810148
  412018
  414043
  391485
  403685
  389065
  515886
  814723
  483358
  456444
  532284
  554375
  669217
  708657
  705741
  671682
  601819
  738198
  799202
  728188
  768412
  724479
  752834
  793610
  423483
  392469
  818182
  819407
  820665
  817216
  817324
  817518
  823310
  539550
  535203
  527481
  534989
  496326
  540521
  571601
  558095
  647819
  694325
  645463
  657745
  673696
  682706
  693588
  556978
  578419
  597562
  636400
  643329
  606828
  778228
  797853
  799652
  737208
  732950
  734796
  742467
  766684
  760761
  738861
  634914
  776269
  780797
  782310
  812023
  387146
  443159
  523897
  738202
  361382
  28382
  40835
  390749
]
3.05 ms
(1.87%)
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
  28382
  40835
  361382
  387146
  389065
  390749
  391485
  392469
  403685
  412018
  414043
  423483
  443159
  456444
  483358
  496326
  515886
  523897
  527481
  532284
  534989
  535203
  539550
  540521
  554375
  556978
  558095
  571601
  578419
  591781
  597562
  601819
  606828
  618386
  623426
  634914
  636400
  643329
  645463
  647819
  657745
  669217
  671682
  673696
  682706
  693588
  694325
  705741
  708657
  720571
  724479
  724497
  724844
  728188
  730432
  731580
  731779
  732950
  733127
  734277
  734796
  735962
  736925
  737208
  738198
  738202
  738861
  739789
  742467
  742874
  743005
  746708
  747058
  750558
  752834
  753202
  753317
  755111
  757474
  760761
  764763
  766684
  766807
  768412
  774975
  776269
  778228
  780503
  780797
  782310
  785708
  787884
  788445
  792015
  792252
  793132
  793449
  793610
  793732
  796531
  796936
  797348
  797853
  799202
  799652
  802368
  803082
  805428
  806158
  810148
  812023
  812078
  814723
  817216
  817324
  817518
  818182
  819407
  820665
  823310
]
1.99 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tits fucking"
]
1.84 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сиськ fucking"
]
1.62 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сиськ fucking"
]

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.