Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
81.62 ms
(67.93%)
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
  414327
  419370
  424190
  431913
  437671
  444313
  447258
  447718
  454074
  458614
  463495
  466376
  471380
  480194
  485059
  486337
  487816
  488823
  497230
  501209
  503310
  507312
  509713
  510321
  510832
  517345
  520205
  520448
  522238
  523862
  527222
  528006
  529271
  529684
  530761
  532380
  533950
  543659
  556664
  560199
  567154
  572318
  580293
  591176
  591413
  600938
  615491
  617153
  618711
  620250
  621275
  626014
  626311
]
21.35 ms
(17.77%)
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:
[
  "sloppy tits"
  "sloppy tits"
  "sloppy tits"
  20
]
8.25 ms
(6.86%)
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
  454074
  510321
  591413
  447258
  414327
  485059
  523862
  463495
  580293
  618711
  600938
  437671
  486337
  510832
  444313
  556664
  431913
  617153
  533950
  466376
  458614
  507312
  527222
  532380
  567154
  424190
  447718
  528006
  487816
  520448
  497230
  529684
  572318
  626311
  471380
  501209
  615491
  509713
  621275
  503310
  530761
  522238
  529271
  560199
  543659
  620250
  520205
  505794
  480194
  419370
  626014
  591176
  517345
  488823
]
2.36 ms
(1.96%)
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
  414327
  419370
  424190
  431913
  437671
  444313
  447258
  447718
  454074
  458614
  463495
  466376
  471380
  480194
  485059
  486337
  487816
  488823
  497230
  501209
  503310
  507312
  509713
  510321
  510832
  517345
  520205
  520448
  522238
  523862
  527222
  528006
  529271
  529684
  530761
  532380
  533950
  543659
  556664
  560199
  567154
  572318
  580293
  591176
  591413
  600938
  615491
  617153
  618711
  620250
  621275
  626014
  626311
]
2.02 ms
(1.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sloppy tits"
]
1.57 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sloppy сиськ"
]
1.52 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sloppy сиськ"
]
1.47 ms
(1.23%)
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.