Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
85.85 ms
(53.22%)
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:
[
  "anal mom french"
  "anal mom french"
  "anal mom french"
  20
]
57.86 ms
(35.87%)
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
  3533
  79765
  124144
  395676
  406030
  410543
  422340
  454370
  466278
  470232
  480399
  492111
  506908
  510109
  515681
  521131
  522556
  522606
  522622
  522785
  526894
  533964
  538611
  541540
  560924
  565484
  572716
  582314
  585477
  596899
  613836
  619468
  619483
  619486
  619802
  633119
  639841
  665675
  680977
  726880
  732248
  756499
  772578
  785847
  788249
  788284
  817422
  818426
  819571
  821187
  821521
]
8.22 ms
(5.10%)
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
  639841
  821187
  821521
  785847
  596899
  3533
  772578
  756499
  732248
  79765
  817422
  454370
  565484
  582314
  633119
  726880
  818426
  522622
  819571
  585477
  470232
  788284
  533964
  406030
  680977
  665675
  395676
  788249
  124144
  619486
  619468
  480399
  510109
  466278
  619802
  522785
  422340
  526894
  522606
  515681
  410543
  541540
  619483
  506908
  572716
  560924
  492111
  521131
  522556
  538611
  613836
]
2.18 ms
(1.35%)
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
  3533
  79765
  124144
  395676
  406030
  410543
  422340
  454370
  466278
  470232
  480399
  492111
  506908
  510109
  515681
  521131
  522556
  522606
  522622
  522785
  526894
  533964
  538611
  541540
  560924
  565484
  572716
  582314
  585477
  596899
  613836
  619468
  619483
  619486
  619802
  633119
  639841
  665675
  680977
  726880
  732248
  756499
  772578
  785847
  788249
  788284
  817422
  818426
  819571
  821187
  821521
]
2.02 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal mom french"
]
1.85 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал mom french"
]
1.79 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал mom french"
]

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.