Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
86.17 ms
(52.26%)
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:
[
  "public anal masturbating"
  "public anal masturbating"
  "public anal masturbating"
  20
]
60.23 ms
(36.53%)
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
  391993
  408998
  413960
  422180
  426550
  429861
  440863
  442991
  444999
  450281
  450380
  455591
  456481
  457638
  457991
  458558
  459648
  464264
  466204
  473479
  494291
  495498
  504424
  504626
  510716
  516332
  522167
  522280
  524598
  546762
  549800
  551484
  555095
  556751
  562637
  576317
  580129
  582010
  585392
  585633
  585666
  585691
  588334
  590398
  592975
  597781
  603286
  614831
  618381
  629468
  726805
  750287
  790409
  790696
  802208
  811068
  813136
  819810
]
8.96 ms
(5.43%)
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
  811068
  422180
  555095
  585691
  510716
  802208
  459648
  585392
  582010
  556751
  464264
  522167
  458558
  790696
  457638
  590398
  429861
  442991
  549800
  444999
  597781
  750287
  391993
  592975
  790409
  426550
  522280
  504424
  585633
  413960
  457991
  408998
  473479
  562637
  450380
  504626
  819810
  495498
  629468
  618381
  466204
  494291
  585666
  813136
  450281
  516332
  440863
  576317
  524598
  456481
  580129
  588334
  726805
  603286
  455591
  551484
  614831
  546762
]
2.25 ms
(1.36%)
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
  391993
  408998
  413960
  422180
  426550
  429861
  440863
  442991
  444999
  450281
  450380
  455591
  456481
  457638
  457991
  458558
  459648
  464264
  466204
  473479
  494291
  495498
  504424
  504626
  510716
  516332
  522167
  522280
  524598
  546762
  549800
  551484
  555095
  556751
  562637
  576317
  580129
  582010
  585392
  585633
  585666
  585691
  588334
  590398
  592975
  597781
  603286
  614831
  618381
  629468
  726805
  750287
  790409
  790696
  802208
  811068
  813136
  819810
]
2.10 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public anal masturbating"
]
1.82 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц анал masturbating"
]
1.74 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на улиц анал masturbating"
]

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.