Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
79.02 ms
(43.44%)
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:
[
  "teen doggystyle anal"
  "teen doggystyle anal"
  "teen doggystyle anal"
  20
]
78.32 ms
(43.06%)
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
  382050
  385077
  385092
  413141
  413824
  423592
  423908
  424530
  430262
  435157
  441416
  441589
  443492
  445289
  446908
  446991
  447557
  453039
  456951
  458907
  464142
  467995
  468604
  469641
  472299
  475512
  480331
  480450
  481047
  484792
  487370
  502242
  503056
  505598
  514241
  520767
  528923
  534432
  538773
  541278
  541325
  542709
  545201
  545223
  598485
  604406
  642022
  644056
  675405
  702622
  709917
  720424
  752609
  788264
  796539
]
8.40 ms
(4.62%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen doggystyle анал"
]
7.35 ms
(4.04%)
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
  752609
  413824
  480450
  480331
  484792
  675405
  385077
  538773
  541325
  441416
  468604
  475512
  534432
  423908
  796539
  443492
  446908
  545201
  447557
  441589
  545223
  481047
  423592
  503056
  430262
  542709
  445289
  709917
  720424
  604406
  644056
  464142
  541278
  642022
  435157
  502242
  385092
  456951
  505598
  469641
  446991
  520767
  467995
  788264
  458907
  472299
  382050
  702622
  487370
  514241
  598485
  424530
  453039
  413141
  528923
]
3.19 ms
(1.76%)
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
  382050
  385077
  385092
  413141
  413824
  423592
  423908
  424530
  430262
  435157
  441416
  441589
  443492
  445289
  446908
  446991
  447557
  453039
  456951
  458907
  464142
  467995
  468604
  469641
  472299
  475512
  480331
  480450
  481047
  484792
  487370
  502242
  503056
  505598
  514241
  520767
  528923
  534432
  538773
  541278
  541325
  542709
  545201
  545223
  598485
  604406
  642022
  644056
  675405
  702622
  709917
  720424
  752609
  788264
  796539
]
2.06 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen doggystyle анал"
]
1.76 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen doggystyle anal"
]

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.