Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.12 ms
(66.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
  508590
  528843
  535572
  461686
  562224
  571134
  565011
  590251
  593738
  600010
  593733
  779003
  807716
  805259
  759650
  794273
  466397
  516489
  519872
  528123
  528118
  528125
  564751
  579617
  664777
  597144
  608414
  627635
  628515
  621186
  424092
  489809
  513228
  499043
  517428
  494314
  506358
  495361
  551886
  601659
  434792
  509747
  528119
  516496
  528811
  604097
  601845
  493402
  524587
  418068
]
88.57 ms
(27.61%)
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
  418068
  424092
  434792
  461686
  466397
  489809
  493402
  494314
  495361
  499043
  506358
  508590
  509747
  513228
  516489
  516496
  517428
  519872
  524587
  528118
  528119
  528123
  528125
  528811
  528843
  535572
  551886
  562224
  564751
  565011
  571134
  579617
  590251
  593733
  593738
  597144
  600010
  601659
  601845
  604097
  608414
  621186
  627635
  628515
  664777
  759650
  779003
  794273
  805259
  807716
]
9.07 ms
(2.83%)
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:
[
  "cumshot best"
  "cumshot best"
  "cumshot best"
  20
]
2.07 ms
(0.65%)
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
  418068
  424092
  434792
  461686
  466397
  489809
  493402
  494314
  495361
  499043
  506358
  508590
  509747
  513228
  516489
  516496
  517428
  519872
  524587
  528118
  528119
  528123
  528125
  528811
  528843
  535572
  551886
  562224
  564751
  565011
  571134
  579617
  590251
  593733
  593738
  597144
  600010
  601659
  601845
  604097
  608414
  621186
  627635
  628515
  664777
  759650
  779003
  794273
  805259
  807716
]
1.92 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cumshot best"
]
1.75 ms
(0.55%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.53%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cumshot best"
]
1.57 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cumshot best"
]

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.