Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
57.85 ms
(63.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
  378046
  412189
  427087
  434275
  435972
  441640
  442434
  449784
  460282
  463074
  467555
  474400
  475479
  505843
  508386
  511449
  519029
  520260
  525257
  525921
  527967
  530495
  531163
  532762
  534027
  537648
  539203
  542526
  544123
  550820
  577402
  578017
  579714
  585751
  593886
  599505
  599913
  599963
  600002
  623678
  633451
  633792
  634151
  634218
  640779
  640793
  642060
  645858
  646838
  647830
  647952
  655555
  675722
  696204
]
14.69 ms
(16.19%)
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:
[
  "my first blowjob"
  "my first blowjob"
  "my first blowjob"
  20
]
8.94 ms
(9.85%)
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
  435972
  442434
  520260
  640779
  675722
  599505
  593886
  600002
  579714
  508386
  599963
  511449
  441640
  578017
  378046
  475479
  646838
  467555
  696204
  634151
  577402
  519029
  531163
  542526
  655555
  642060
  645858
  427087
  412189
  474400
  550820
  585751
  463074
  532762
  647952
  640793
  647830
  633792
  599913
  633451
  460282
  434275
  534027
  537648
  530495
  634218
  449784
  525257
  505843
  544123
  539203
  525921
  623678
  527967
]
2.24 ms
(2.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "my first blowjob"
]
2.17 ms
(2.39%)
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
  378046
  412189
  427087
  434275
  435972
  441640
  442434
  449784
  460282
  463074
  467555
  474400
  475479
  505843
  508386
  511449
  519029
  520260
  525257
  525921
  527967
  530495
  531163
  532762
  534027
  537648
  539203
  542526
  544123
  550820
  577402
  578017
  579714
  585751
  593886
  599505
  599913
  599963
  600002
  623678
  633451
  633792
  634151
  634218
  640779
  640793
  642060
  645858
  646838
  647830
  647952
  655555
  675722
  696204
]
1.80 ms
(1.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "my first минет оральн секс"
]
1.54 ms
(1.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "my first минет оральн секс"
]
1.54 ms
(1.70%)
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.