Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
78.43 ms
(50.07%)
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
  426030
  434782
  449194
  450997
  451311
  455523
  467370
  468748
  476930
  477124
  479425
  479432
  491220
  494397
  495977
  498105
  504453
  504925
  507649
  514293
  516021
  523491
  541913
  586639
  588240
  589077
  589139
  590707
  591792
  593641
  599598
  601323
  633482
  699577
  702570
  732457
  741901
  750920
  775284
  775606
  779371
  784498
  788970
  790101
  790991
  814940
  815357
  815831
  816935
  821273
  821546
  822960
  823507
]
58.65 ms
(37.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:
[
  "sex photoshoot"
  "sex photoshoot"
  "sex photoshoot"
  20
]
9.37 ms
(5.98%)
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
  504453
  788970
  633482
  823507
  821273
  779371
  821546
  790991
  750920
  775606
  732457
  449194
  741901
  477124
  702570
  822960
  790101
  815831
  589077
  590707
  467370
  816935
  494397
  495977
  541913
  775284
  498105
  504925
  450997
  699577
  815357
  479432
  455523
  514293
  523491
  507649
  589139
  434782
  784498
  599598
  476930
  491220
  468748
  588240
  426030
  586639
  516021
  451311
  814940
  593641
  479425
  601323
  591792
]
2.79 ms
(1.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс photoshoot"
]
2.61 ms
(1.67%)
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
  426030
  434782
  449194
  450997
  451311
  455523
  467370
  468748
  476930
  477124
  479425
  479432
  491220
  494397
  495977
  498105
  504453
  504925
  507649
  514293
  516021
  523491
  541913
  586639
  588240
  589077
  589139
  590707
  591792
  593641
  599598
  601323
  633482
  699577
  702570
  732457
  741901
  750920
  775284
  775606
  779371
  784498
  788970
  790101
  790991
  814940
  815357
  815831
  816935
  821273
  821546
  822960
  823507
]
1.86 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex photoshoot"
]
1.56 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс photoshoot"
]

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.