Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
71.77 ms
(55.64%)
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
  419956
  425518
  427981
  440631
  444606
  447094
  451317
  457974
  475911
  477114
  485258
  486086
  520572
  528635
  536903
  540512
  551525
  560520
  566585
  573087
  574490
  575815
  581350
  587326
  601176
  608800
  613172
  625186
  631597
  645836
  653494
  657177
  706734
  720277
  729345
  743380
  778111
  784157
  792228
  799349
  800223
  810678
  813337
  818471
  827980
]
37.98 ms
(29.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:
[
  "pussy hard porn"
  "pussy hard porn"
  "pussy hard porn"
  20
]
9.00 ms
(6.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
  451317
  813337
  792228
  573087
  810678
  447094
  800223
  645836
  778111
  608800
  706734
  613172
  827980
  729345
  799349
  485258
  653494
  540512
  720277
  657177
  743380
  818471
  566585
  574490
  784157
  457974
  631597
  419956
  601176
  475911
  440631
  477114
  528635
  551525
  581350
  575815
  587326
  625186
  425518
  520572
  536903
  560520
  427981
  486086
  444606
]
2.84 ms
(2.20%)
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
  419956
  425518
  427981
  440631
  444606
  447094
  451317
  457974
  475911
  477114
  485258
  486086
  520572
  528635
  536903
  540512
  551525
  560520
  566585
  573087
  574490
  575815
  581350
  587326
  601176
  608800
  613172
  625186
  631597
  645836
  653494
  657177
  706734
  720277
  729345
  743380
  778111
  784157
  792228
  799349
  800223
  810678
  813337
  818471
  827980
]
2.06 ms
(1.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy hard porn"
]
1.94 ms
(1.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy hard porn"
]
1.75 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy hard porn"
]
1.65 ms
(1.28%)
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.