Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
106.43 ms
(80.22%)
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
  229555
  383482
  384144
  395707
  403579
  404678
  412289
  413090
  425619
  426412
  428126
  428819
  445932
  446135
  446625
  450860
  451485
  453013
  453461
  453721
  456536
  456613
  456614
  456615
  456618
  458462
  459243
  463158
  469039
  471181
  472161
  474654
  474693
  474700
  476327
  478596
  484685
  484700
  485269
  490204
  495199
  534299
  537126
  549507
  563164
  606782
  631616
  631718
  639011
  682522
  753990
  814909
  815365
  815454
  815723
  816405
]
9.83 ms
(7.41%)
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
  458462
  229555
  476327
  446625
  383482
  453461
  816405
  814909
  815454
  450860
  815365
  631718
  456536
  815723
  395707
  534299
  484685
  453013
  451485
  446135
  563164
  428819
  403579
  549507
  384144
  537126
  456613
  413090
  425619
  639011
  453721
  459243
  471181
  426412
  456615
  484700
  485269
  474700
  474693
  753990
  478596
  445932
  631616
  469039
  412289
  463158
  404678
  606782
  456614
  682522
  456618
  474654
  428126
  472161
  490204
  495199
]
7.42 ms
(5.59%)
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:
[
  "mommy deepthroat"
  "mommy deepthroat"
  "mommy deepthroat"
  20
]
2.04 ms
(1.54%)
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
  229555
  383482
  384144
  395707
  403579
  404678
  412289
  413090
  425619
  426412
  428126
  428819
  445932
  446135
  446625
  450860
  451485
  453013
  453461
  453721
  456536
  456613
  456614
  456615
  456618
  458462
  459243
  463158
  469039
  471181
  472161
  474654
  474693
  474700
  476327
  478596
  484685
  484700
  485269
  490204
  495199
  534299
  537126
  549507
  563164
  606782
  631616
  631718
  639011
  682522
  753990
  814909
  815365
  815454
  815723
  816405
]
1.98 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mommy deepthroat"
]
1.86 ms
(1.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mommy глубокийминет минет оральн секс"
]
1.50 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mommy глубокийминет минет оральн секс"
]

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.