Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.63 ms
(79.73%)
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
  187996
  188335
  233889
  382184
  382444
  384279
  385974
  386997
  388862
  390303
  391565
  392031
  395998
  396941
  396969
  397223
  398563
  407727
  407782
  411385
  411708
  411773
  415559
  419146
  442649
  442869
  443378
  443925
  453096
  454230
  454559
  460172
  460759
  462328
  466136
  466147
  467240
  467830
  471053
  474485
  474491
  483374
  484395
  484417
  485689
  485755
  492001
  524476
  531546
  532697
  537135
  565116
  571144
  576478
  587805
  591877
  603358
  625036
  664846
  665408
  665415
  665513
  666770
  707476
  710268
  712215
  714164
  715475
  716487
  724232
  724284
  725135
  726756
  727499
  731137
  731755
  731772
  731836
  734015
  737897
  742595
  744207
  744906
  748163
  758118
  758444
  770100
  770151
  770259
  772119
  776742
  781679
  781897
  781980
  788518
  788520
  797254
  799968
  802798
  804112
  807376
  807546
  808003
  808434
  810769
  814125
  815340
  816784
  817360
  817810
  818449
  818737
  819241
  819637
  819646
  826127
  826246
  826555
  827583
]
18.58 ms
(12.28%)
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
  748163
  724232
  737897
  742595
  625036
  781980
  810769
  443378
  492001
  665408
  808434
  772119
  715475
  484395
  817360
  397223
  442649
  819637
  819646
  826555
  818737
  826127
  531546
  537135
  716487
  665513
  664846
  666770
  587805
  776742
  802798
  788520
  808003
  731137
  758444
  781897
  726756
  731772
  734015
  744207
  731836
  770151
  731755
  744906
  781679
  788518
  797254
  799968
  385974
  388862
  411773
  807376
  411385
  233889
  565116
  817810
  828044
  187996
  819241
  532697
  571144
  591877
  725135
  758118
  727499
  712215
  460759
  471053
  474485
  466147
  442869
  710268
  724284
  804112
  770100
  396969
  603358
  467830
  453096
  807546
  390303
  391565
  415559
  460172
  384279
  396941
  188335
  814125
  818449
  827583
  815340
  524476
  576478
  770259
  714164
  382184
  382444
  411708
  419146
  485689
  483374
  665415
  707476
  454230
  462328
  467240
  454559
  443925
  474491
  466136
  484417
  485755
  395998
  386997
  398563
  407727
  816784
  826246
  407782
  392031
]
3.38 ms
(2.23%)
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
  187996
  188335
  233889
  382184
  382444
  384279
  385974
  386997
  388862
  390303
  391565
  392031
  395998
  396941
  396969
  397223
  398563
  407727
  407782
  411385
  411708
  411773
  415559
  419146
  442649
  442869
  443378
  443925
  453096
  454230
  454559
  460172
  460759
  462328
  466136
  466147
  467240
  467830
  471053
  474485
  474491
  483374
  484395
  484417
  485689
  485755
  492001
  524476
  531546
  532697
  537135
  565116
  571144
  576478
  587805
  591877
  603358
  625036
  664846
  665408
  665415
  665513
  666770
  707476
  710268
  712215
  714164
  715475
  716487
  724232
  724284
  725135
  726756
  727499
  731137
  731755
  731772
  731836
  734015
  737897
  742595
  744207
  744906
  748163
  758118
  758444
  770100
  770151
  770259
  772119
  776742
  781679
  781897
  781980
  788518
  788520
  797254
  799968
  802798
  804112
  807376
  807546
  808003
  808434
  810769
  814125
  815340
  816784
  817360
  817810
  818449
  818737
  819241
  819637
  819646
  826127
  826246
  826555
  827583
]
2.46 ms
(1.62%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature boobs сиськ"
]
2.40 ms
(1.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature boobs tits"
]
1.99 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature boobs сиськ"
]
1.86 ms
(1.23%)
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.