Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
58.60 ms
(61.73%)
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
  420304
  443632
  445638
  473823
  485692
  495040
  507199
  516002
  517690
  517822
  580921
  581366
  595097
  610293
  610647
  614721
  615031
  625171
  626066
  633954
  658445
  658453
  658469
  658854
  663478
  665833
  665894
  667682
  669749
  695163
  698472
  711617
  725451
  731034
  738673
  742618
  743641
  743658
  744828
  757226
  772123
  776749
  781792
  792625
  792819
  797175
  798640
  802291
  803756
  827295
  828596
]
16.87 ms
(17.77%)
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:
[
  "bbw horny"
  "bbw horny"
  "bbw horny"
  20
]
9.35 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
  802291
  420304
  711617
  776749
  743658
  744828
  743641
  828596
  803756
  725451
  663478
  738673
  626066
  731034
  669749
  665894
  581366
  517822
  625171
  827295
  698472
  667682
  792625
  665833
  742618
  797175
  757226
  633954
  792819
  485692
  658453
  658469
  658854
  610647
  798640
  443632
  445638
  516002
  473823
  658445
  614721
  781792
  772123
  615031
  495040
  580921
  595097
  517690
  507199
  610293
  695163
]
2.70 ms
(2.84%)
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
  420304
  443632
  445638
  473823
  485692
  495040
  507199
  516002
  517690
  517822
  580921
  581366
  595097
  610293
  610647
  614721
  615031
  625171
  626066
  633954
  658445
  658453
  658469
  658854
  663478
  665833
  665894
  667682
  669749
  695163
  698472
  711617
  725451
  731034
  738673
  742618
  743641
  743658
  744828
  757226
  772123
  776749
  781792
  792625
  792819
  797175
  798640
  802291
  803756
  827295
  828596
]
2.31 ms
(2.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbw horny"
]
2.00 ms
(2.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbw horny"
]
1.36 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbw horny"
]

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.