Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
82.36 ms
(72.44%)
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
  417530
  444728
  459532
  461495
  464953
  466297
  466907
  476414
  477875
  482609
  482922
  488773
  494000
  496686
  501068
  516819
  520730
  520961
  522869
  524717
  525867
  527101
  527121
  527582
  528011
  532384
  535282
  561024
  566340
  578308
  581882
  588529
  589148
  590652
  619106
  624753
  631503
  634608
  635050
  664459
  665920
  669637
  691725
  697169
  697465
  703687
  715129
  716675
  717420
  737198
  785635
  790163
  790754
  794523
  796761
  801977
  804964
  814712
  817053
]
10.43 ms
(9.18%)
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:
[
  "bdsm couple"
  "bdsm couple"
  "bdsm couple"
  20
]
9.95 ms
(8.75%)
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
  588529
  796761
  664459
  635050
  417530
  817053
  624753
  794523
  590652
  619106
  691725
  634608
  703687
  717420
  697465
  466297
  501068
  444728
  527582
  524717
  488773
  669637
  804964
  566340
  482609
  525867
  715129
  801977
  790163
  814712
  522869
  494000
  697169
  482922
  459532
  477875
  532384
  496686
  665920
  716675
  631503
  461495
  476414
  466907
  578308
  561024
  785635
  737198
  527101
  520730
  516819
  581882
  790754
  520961
  527121
  535282
  589148
  528011
  464953
]
2.74 ms
(2.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.65 ms
(2.33%)
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
  417530
  444728
  459532
  461495
  464953
  466297
  466907
  476414
  477875
  482609
  482922
  488773
  494000
  496686
  501068
  516819
  520730
  520961
  522869
  524717
  525867
  527101
  527121
  527582
  528011
  532384
  535282
  561024
  566340
  578308
  581882
  588529
  589148
  590652
  619106
  624753
  631503
  634608
  635050
  664459
  665920
  669637
  691725
  697169
  697465
  703687
  715129
  716675
  717420
  737198
  785635
  790163
  790754
  794523
  796761
  801977
  804964
  814712
  817053
]
2.01 ms
(1.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bdsm couple"
]
1.79 ms
(1.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бдсм couple"
]
1.77 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бдсм couple"
]

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.