Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
417.97 ms
(70.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "stepmom busty"
]
135.56 ms
(22.98%)
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
  263812
  395701
  407494
  411704
  435942
  448711
  449721
  449733
  451804
  458715
  462398
  462472
  463768
  464388
  466729
  469288
  477885
  490769
  498428
  501553
  502738
  502740
  505823
  507528
  513597
  518507
  518940
  522767
  526675
  528181
  532684
  537808
  543509
  556565
  559845
  561478
  561739
  561758
  562355
  562894
  567135
  582449
  586805
  591284
  595595
  597857
  603703
  649156
  673655
  673659
  706676
  716307
  719015
  788604
  792530
  803095
]
16.81 ms
(2.85%)
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:
[
  "stepmom busty"
  "stepmom busty"
  "stepmom busty"
  20
]
11.32 ms
(1.92%)
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
  449733
  464388
  505823
  513597
  537808
  501553
  561758
  556565
  543509
  561739
  719015
  716307
  582449
  411704
  518507
  522767
  407494
  448711
  462398
  466729
  532684
  567135
  649156
  673655
  597857
  803095
  706676
  792530
  462472
  477885
  449721
  507528
  498428
  490769
  395701
  435942
  458715
  469288
  526675
  586805
  595595
  788604
  451804
  263812
  502740
  518940
  559845
  673659
  528181
  562355
  502738
  463768
  603703
  562894
  561478
  591284
]
3.04 ms
(0.52%)
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
  263812
  395701
  407494
  411704
  435942
  448711
  449721
  449733
  451804
  458715
  462398
  462472
  463768
  464388
  466729
  469288
  477885
  490769
  498428
  501553
  502738
  502740
  505823
  507528
  513597
  518507
  518940
  522767
  526675
  528181
  532684
  537808
  543509
  556565
  559845
  561478
  561739
  561758
  562355
  562894
  567135
  582449
  586805
  591284
  595595
  597857
  603703
  649156
  673655
  673659
  706676
  716307
  719015
  788604
  792530
  803095
]
1.72 ms
(0.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stepmom busty"
]
1.66 ms
(0.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "stepmom busty"
]

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.