Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.45 ms
(48.72%)
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 anal wife"
  "stepmom anal wife"
  "stepmom anal wife"
  20
]
110.34 ms
(42.85%)
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
  400481
  400497
  421876
  422179
  424265
  433323
  439641
  439696
  439720
  439766
  439785
  439815
  439816
  439819
  441004
  445056
  464328
  465248
  465354
  474783
  484620
  492563
  515777
  517012
  517015
  523876
  546126
  547546
  555181
  563546
  564265
  573742
  573754
  578823
  582417
  582639
  605409
  605461
  607537
  619513
  619527
  619536
  621339
  623468
  628654
  684305
  741687
  795709
  797025
  805462
  824388
]
12.31 ms
(4.78%)
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
  439815
  439816
  433323
  582639
  605461
  439641
  439766
  824388
  795709
  441004
  564265
  741687
  619513
  465354
  439696
  439785
  546126
  797025
  805462
  400481
  605409
  517012
  523876
  547546
  621339
  619536
  422179
  515777
  628654
  421876
  439819
  474783
  445056
  578823
  607537
  465248
  573742
  484620
  492563
  424265
  573754
  517015
  619527
  582417
  439720
  623468
  400497
  684305
  563546
  464328
  555181
]
2.24 ms
(0.87%)
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
  400481
  400497
  421876
  422179
  424265
  433323
  439641
  439696
  439720
  439766
  439785
  439815
  439816
  439819
  441004
  445056
  464328
  465248
  465354
  474783
  484620
  492563
  515777
  517012
  517015
  523876
  546126
  547546
  555181
  563546
  564265
  573742
  573754
  578823
  582417
  582639
  605409
  605461
  607537
  619513
  619527
  619536
  621339
  623468
  628654
  684305
  741687
  795709
  797025
  805462
  824388
]
1.99 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stepmom anal wife"
]
1.77 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.67%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "stepmom анал жен"
]
1.66 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "stepmom анал жен"
]

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.