Query Metrics

9 Database Queries
9 Different statements
235.07 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.51 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.54 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife husband sperm"
]
3 1.67 ms
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01“vê\x18Üq\t¤T¿(·ßxŠ"
]
4 20.16 ms
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
  620121
  545014
  633870
  631826
  725413
  801612
  583534
  695784
  725166
  455495
  599466
  691710
  674550
  787117
  444958
  484992
  823285
  675844
  714544
  635789
  782495
  788009
  803590
  778905
  779841
  804076
  745593
  795618
  813183
  770470
  743738
  700517
  780662
  818908
  478764
  494570
  506886
  546765
  547639
  569411
  565865
  618203
  810931
  727804
  768790
  453685
  473261
  418436
  500230
  519410
  500536
  523231
  597726
  397531
  428516
  460464
  479822
  460539
  456685
  525720
  470533
  479225
  559572
  557008
  565646
  721867
  615246
  614935
  620402
  591300
  793877
  805276
  808503
  796349
  742839
  789612
  726366
  727018
  738624
  767995
  797800
  808497
  437176
  452755
  479959
  447071
  449039
  482129
  420473
  459593
  471830
  472172
  521522
  489680
  524170
  524359
  503000
  440973
  620425
  789792
  733404
  603544
  525848
  566413
  644056
  517448
  484995
  154675
  560435
  553687
  577428
  713195
  590272
  599657
  594532
  759464
  494584
  578737
  453992
  480590
]
5 4.30 ms
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
  154675
  397531
  418436
  420473
  428516
  437176
  440973
  444958
  447071
  449039
  452755
  453685
  453992
  455495
  456685
  459593
  460464
  460539
  470533
  471830
  472172
  473261
  478764
  479225
  479822
  479959
  480590
  482129
  484992
  484995
  489680
  494570
  494584
  500230
  500536
  503000
  506886
  517448
  519410
  521522
  523231
  524170
  524359
  525720
  525848
  545014
  546765
  547639
  553687
  557008
  559572
  560435
  565646
  565865
  566413
  569411
  577428
  578737
  583534
  590272
  591300
  594532
  597726
  599466
  599657
  603544
  614935
  615246
  618203
  620121
  620402
  620425
  631826
  633870
  635789
  644056
  674550
  675844
  691710
  695784
  700517
  713195
  714544
  721867
  725166
  725413
  726366
  727018
  727804
  733404
  738624
  742839
  743738
  745593
  759464
  767995
  768790
  770470
  778905
  779841
  780662
  782495
  787117
  788009
  789612
  789792
  793877
  795618
  796349
  797800
  801612
  803590
  804076
  805276
  808497
  808503
  810931
  813183
  818908
  823285
]
6 176.50 ms
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
  154675
  397531
  418436
  420473
  428516
  437176
  440973
  444958
  447071
  449039
  452755
  453685
  453992
  455495
  456685
  459593
  460464
  460539
  470533
  471830
  472172
  473261
  478764
  479225
  479822
  479959
  480590
  482129
  484992
  484995
  489680
  494570
  494584
  500230
  500536
  503000
  506886
  517448
  519410
  521522
  523231
  524170
  524359
  525720
  525848
  545014
  546765
  547639
  553687
  557008
  559572
  560435
  565646
  565865
  566413
  569411
  577428
  578737
  583534
  590272
  591300
  594532
  597726
  599466
  599657
  603544
  614935
  615246
  618203
  620121
  620402
  620425
  631826
  633870
  635789
  644056
  674550
  675844
  691710
  695784
  700517
  713195
  714544
  721867
  725166
  725413
  726366
  727018
  727804
  733404
  738624
  742839
  743738
  745593
  759464
  767995
  768790
  770470
  778905
  779841
  780662
  782495
  787117
  788009
  789612
  789792
  793877
  795618
  796349
  797800
  801612
  803590
  804076
  805276
  808497
  808503
  810931
  813183
  818908
  823285
]
7 1.60 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен husband сперм"
]
8 1.43 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен husband сперм"
]
9 26.38 ms
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "wife husband sperm"
  "wife husband sperm"
  "wife husband sperm"
  20
]

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.