Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.56 ms
(89.26%)
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
  390646
  393810
  409759
  417697
  419574
  420045
  420833
  433704
  447925
  477144
  484084
  486304
  492234
  519551
  525443
  528875
  530824
  532836
  534441
  541494
  541704
  543728
  544535
  546434
  547990
  548202
  551585
  553673
  557579
  558254
  563964
  569511
  569525
  581589
  584476
  585329
  592563
  595035
  595645
  598455
  607030
  607098
  608423
  613785
  614530
  614946
  622446
  622585
  623452
  629116
  631401
  634897
  652697
  658208
  673818
  680362
  682179
  684886
  695070
  709677
  723056
  723575
  758892
  763661
  764497
  764617
  764770
  765145
  767878
  768061
  776017
  777844
  778199
  780828
  781219
  781505
  782693
  782838
  786739
  787419
  788139
  788445
  789349
  789578
  789582
  790922
  790932
  791750
  791773
  792873
  794541
  797198
  799958
  800224
  801589
  811204
  813279
  814150
  814623
  815091
  815125
  817020
  818531
  818688
  820450
  820565
  820839
  821157
  821163
  821182
  821626
  821832
  821991
  822181
  822786
  823131
  825552
  826105
  827881
]
12.04 ms
(6.26%)
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
  789578
  797198
  801589
  786739
  789582
  800224
  767878
  758892
  764497
  765145
  763661
  631401
  709677
  789349
  799958
  811204
  813279
  525443
  821991
  826105
  484084
  492234
  447925
  409759
  622446
  768061
  629116
  723575
  820565
  825552
  814623
  815091
  818688
  530824
  528875
  569525
  546434
  563964
  680362
  723056
  684886
  622585
  623452
  595645
  614946
  791773
  788139
  780828
  790922
  393810
  695070
  595035
  634897
  614530
  486304
  532836
  417697
  433704
  814150
  820839
  822181
  817020
  822786
  823131
  818531
  820450
  821182
  821626
  828272
  534441
  547990
  548202
  682179
  551585
  598455
  613785
  592563
  608423
  776017
  790932
  792873
  778199
  781505
  782693
  791750
  782838
  787419
  788445
  794541
  764770
  764617
  419574
  390646
  569511
  827881
  519551
  553673
  821163
  777844
  585329
  544535
  584476
  658208
  607030
  815125
  821157
  607098
  781219
  420833
  420045
  821832
  477144
  543728
  581589
  541494
  541704
  557579
  558254
  652697
  673818
]
2.31 ms
(1.20%)
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
  390646
  393810
  409759
  417697
  419574
  420045
  420833
  433704
  447925
  477144
  484084
  486304
  492234
  519551
  525443
  528875
  530824
  532836
  534441
  541494
  541704
  543728
  544535
  546434
  547990
  548202
  551585
  553673
  557579
  558254
  563964
  569511
  569525
  581589
  584476
  585329
  592563
  595035
  595645
  598455
  607030
  607098
  608423
  613785
  614530
  614946
  622446
  622585
  623452
  629116
  631401
  634897
  652697
  658208
  673818
  680362
  682179
  684886
  695070
  709677
  723056
  723575
  758892
  763661
  764497
  764617
  764770
  765145
  767878
  768061
  776017
  777844
  778199
  780828
  781219
  781505
  782693
  782838
  786739
  787419
  788139
  788445
  789349
  789578
  789582
  790922
  790932
  791750
  791773
  792873
  794541
  797198
  799958
  800224
  801589
  811204
  813279
  814150
  814623
  815091
  815125
  817020
  818531
  818688
  820450
  820565
  820839
  821157
  821163
  821182
  821626
  821832
  821991
  822181
  822786
  823131
  825552
  826105
  827881
]
1.69 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые секс пов"
]
1.60 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny fuck pov"
]
1.45 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.