Query Metrics

8 Database Queries
8 Different statements
153.31 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
69.05 ms
(45.04%)
1
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:
[
  "hairy anal bbc"
  "hairy anal bbc"
  "hairy anal bbc"
  20
]
63.99 ms
(41.74%)
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
  403141
  405061
  405921
  406381
  408609
  421093
  428397
  440632
  445641
  445737
  448445
  454802
  463842
  467611
  469534
  481147
  482527
  485100
  496794
  498551
  512447
  524952
  525864
  528361
  531117
  532975
  538360
  541588
  541614
  541643
  541651
  541661
  541667
  541671
  541683
  543874
  546804
  555054
  576720
  576723
  583701
  589060
  605521
  606577
  617422
  621125
  635275
  639292
  639739
  641978
  643103
  646176
  647948
  651601
  756395
]
11.87 ms
(7.74%)
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
  485100
  538360
  496794
  481147
  576720
  428397
  445737
  403141
  555054
  406381
  531117
  643103
  405061
  583701
  448445
  454802
  756395
  639292
  421093
  498551
  541651
  525864
  541661
  617422
  482527
  467611
  651601
  639739
  524952
  546804
  589060
  646176
  532975
  541614
  576723
  469534
  463842
  541643
  621125
  408609
  541683
  541667
  647948
  445641
  512447
  405921
  440632
  528361
  605521
  635275
  541671
  541588
  641978
  606577
  543874
]
2.16 ms
(1.41%)
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
  403141
  405061
  405921
  406381
  408609
  421093
  428397
  440632
  445641
  445737
  448445
  454802
  463842
  467611
  469534
  481147
  482527
  485100
  496794
  498551
  512447
  524952
  525864
  528361
  531117
  532975
  538360
  541588
  541614
  541643
  541651
  541661
  541667
  541671
  541683
  543874
  546804
  555054
  576720
  576723
  583701
  589060
  605521
  606577
  617422
  621125
  635275
  639292
  639739
  641978
  643103
  646176
  647948
  651601
  756395
]
1.71 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy anal bbc"
]
1.62 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая анал bbc"
]
1.49 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая анал bbc"
]

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.