Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.67 ms
(51.26%)
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
  82307
  734841
  559425
  594375
  387854
  554712
  740487
  577026
  583410
  548186
  684883
  628524
  809077
  717758
  782528
  446764
  549040
  707441
  588939
  626163
  738110
  739408
  661378
  630239
  779765
  783218
  768969
  642286
  446768
  583300
  712108
  744178
  755489
  803516
  576440
  669318
  756618
  734853
  437244
  390286
  540107
  495525
  769409
  784896
  730338
  463435
  812043
  726816
  584379
  550367
  615910
  751428
  725527
  510938
  692743
  613800
  669269
  680706
  611032
  602092
]
119.48 ms
(29.21%)
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
  82307
  387854
  390286
  437244
  446764
  446768
  463435
  495525
  510938
  540107
  548186
  549040
  550367
  554712
  559425
  576440
  577026
  583300
  583410
  584379
  588939
  594375
  602092
  611032
  613800
  615910
  626163
  628524
  630239
  642286
  661378
  669269
  669318
  680706
  684883
  692743
  707441
  712108
  717758
  725527
  726816
  730338
  734841
  734853
  738110
  739408
  740487
  744178
  751428
  755489
  756618
  768969
  769409
  779765
  782528
  783218
  784896
  803516
  809077
  812043
]
71.02 ms
(17.36%)
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:
[
  "соло spread pussy"
  "соло spread pussy"
  "соло spread pussy"
  20
]
2.44 ms
(0.60%)
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
  82307
  387854
  390286
  437244
  446764
  446768
  463435
  495525
  510938
  540107
  548186
  549040
  550367
  554712
  559425
  576440
  577026
  583300
  583410
  584379
  588939
  594375
  602092
  611032
  613800
  615910
  626163
  628524
  630239
  642286
  661378
  669269
  669318
  680706
  684883
  692743
  707441
  712108
  717758
  725527
  726816
  730338
  734841
  734853
  738110
  739408
  740487
  744178
  751428
  755489
  756618
  768969
  769409
  779765
  782528
  783218
  784896
  803516
  809077
  812043
]
2.01 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соло spread pussy"
]
1.64 ms
(0.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло spread pussy"
]
1.43 ms
(0.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло spread pussy"
]
1.32 ms
(0.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.