Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.82 ms
(56.31%)
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
  391597
  400512
  401004
  411897
  412157
  417071
  426407
  437949
  439437
  443682
  443690
  443713
  444142
  444216
  448662
  448714
  448915
  448918
  452905
  453214
  454073
  454136
  454205
  461950
  462156
  462658
  463247
  464539
  464547
  465822
  466079
  466478
  467814
  469450
  469896
  470271
  470916
  470934
  473932
  474181
  474323
  476636
  476675
  476837
  483844
  483852
  484781
  485425
  485986
  486375
  488273
  490499
  491967
  494796
  496019
  499307
  504325
  509966
  513691
  542259
  545662
  546893
  550234
  560341
  563125
  563454
  566672
  569993
  571352
  571419
  573912
  580684
  593384
  619899
  631393
  667971
  683256
  714609
  728900
  740442
  741480
  742387
  742402
  755900
  761254
  764101
  769188
  774146
  777897
  778575
  779386
  781489
  783609
  788004
  794704
  799673
  799918
  803729
  805666
  808313
  814973
  814990
  816120
  817989
  818075
  819273
  819277
  819358
  819777
  819933
  824213
  824260
  824312
  825907
  826196
  826584
  826643
  826687
  827031
  827582
]
143.57 ms
(37.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
  391597
  400512
  401004
  411897
  412157
  417071
  426407
  437949
  439437
  443682
  443690
  443713
  444142
  444216
  448662
  448714
  448915
  448918
  452905
  453214
  454073
  454136
  454205
  461950
  462156
  462658
  463247
  464539
  464547
  465822
  466079
  466478
  467814
  469450
  469896
  470271
  470916
  470934
  473932
  474181
  474323
  476636
  476675
  476837
  483844
  483852
  484781
  485425
  485986
  486375
  488273
  490499
  491967
  494796
  496019
  499307
  504325
  509966
  513691
  542259
  545662
  546893
  550234
  560341
  563125
  563454
  566672
  569993
  571352
  571419
  573912
  580684
  593384
  619899
  631393
  667971
  683256
  714609
  728900
  740442
  741480
  742387
  742402
  755900
  761254
  764101
  769188
  774146
  777897
  778575
  779386
  781489
  783609
  788004
  794704
  799673
  799918
  803729
  805666
  808313
  814973
  814990
  816120
  817989
  818075
  819273
  819277
  819358
  819777
  819933
  824213
  824260
  824312
  825907
  826196
  826584
  826643
  826687
  827031
  827582
]
14.90 ms
(3.94%)
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
  781489
  805666
  443713
  563125
  401004
  499307
  391597
  825907
  814973
  819777
  814990
  462156
  488273
  714609
  580684
  631393
  778575
  788004
  764101
  742402
  742387
  448662
  444216
  469896
  417071
  563454
  779386
  783609
  504325
  816120
  824213
  817989
  824312
  571352
  573912
  803729
  777897
  794704
  799918
  755900
  799673
  728900
  741480
  412157
  819277
  826643
  818075
  819273
  542259
  545662
  566672
  619899
  808313
  769188
  774146
  740442
  761254
  473932
  467814
  560341
  569993
  683256
  550234
  411897
  439437
  464539
  465822
  469450
  470271
  470934
  437949
  448714
  448915
  454073
  464547
  444142
  448918
  474181
  476675
  454205
  470916
  453214
  466079
  483844
  483852
  486375
  484781
  490499
  494796
  667971
  476837
  496019
  426407
  452905
  466478
  474323
  462658
  509966
  485425
  571419
  454136
  476636
  546893
  463247
  400512
  443682
  491967
  443690
  461950
  485986
  513691
  593384
  826196
  826584
  826687
  819933
  824260
  827031
  827582
  819358
]
2.17 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian saggy tits"
]
1.59 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск saggy сиськ"
]
1.48 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск saggy сиськ"
]

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.