Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.09 ms
(66.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "orgasm his mother"
]
63.61 ms
(20.57%)
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
  418879
  440620
  447679
  455589
  462679
  468912
  495287
  500528
  507647
  513172
  521693
  522210
  528144
  530178
  552356
  555591
  582000
  616798
  617672
  618194
  622670
  625165
  630660
  639986
  645270
  646748
  659226
  667257
  677878
  697217
  709524
  711266
  713115
  728652
  729982
  748620
  764963
  767519
  768116
  771281
  780676
  785148
  790144
  792451
  793218
  794516
  795816
  795950
  799957
  800520
  803371
  804249
  817380
  817675
  825159
  826456
  826693
  827375
]
24.50 ms
(7.92%)
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:
[
  "orgasm his mother"
  "orgasm his mother"
  "orgasm his mother"
  20
]
8.07 ms
(2.61%)
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
  711266
  826693
  827375
  764963
  552356
  616798
  795816
  817675
  826456
  817380
  639986
  768116
  800520
  804249
  825159
  521693
  659226
  794516
  729982
  618194
  418879
  622670
  792451
  795950
  767519
  667257
  790144
  697217
  771281
  455589
  780676
  748620
  793218
  462679
  513172
  713115
  630660
  803371
  785148
  646748
  495287
  582000
  677878
  617672
  799957
  728652
  709524
  468912
  507647
  530178
  555591
  528144
  625165
  440620
  447679
  522210
  645270
  500528
]
3.08 ms
(1.00%)
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
  418879
  440620
  447679
  455589
  462679
  468912
  495287
  500528
  507647
  513172
  521693
  522210
  528144
  530178
  552356
  555591
  582000
  616798
  617672
  618194
  622670
  625165
  630660
  639986
  645270
  646748
  659226
  667257
  677878
  697217
  709524
  711266
  713115
  728652
  729982
  748620
  764963
  767519
  768116
  771281
  780676
  785148
  790144
  792451
  793218
  794516
  795816
  795950
  799957
  800520
  803371
  804249
  817380
  817675
  825159
  826456
  826693
  827375
]
1.81 ms
(0.59%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "orgasm his мам женщин"
]
1.56 ms
(0.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "orgasm his мам женщин"
]

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.