Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
74.09 ms
(56.48%)
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
  381979
  386991
  400428
  406556
  410724
  440265
  440745
  440963
  440977
  448712
  453037
  453068
  453073
  454333
  454706
  454913
  455799
  456859
  457585
  457603
  457644
  457668
  457737
  457789
  457791
  459162
  464295
  469234
  470664
  471174
  471196
  476588
  479787
  486083
  486485
  488532
  488541
  498038
  503695
  511028
  513517
  516418
  517428
  523561
  526086
  543612
  557595
  619508
  663856
  663992
  665227
  666842
  714053
  714743
  738352
  770164
  781930
  788945
  818638
  818815
]
37.75 ms
(28.78%)
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:
[
  "beach mature boy"
  "beach mature boy"
  "beach mature boy"
  20
]
10.65 ms
(8.12%)
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
  400428
  486083
  781930
  457737
  770164
  448712
  557595
  440963
  469234
  665227
  503695
  526086
  738352
  714053
  440977
  454706
  788945
  440745
  464295
  459162
  714743
  471196
  476588
  456859
  457791
  457789
  440265
  453037
  454913
  619508
  457603
  381979
  453068
  523561
  457668
  486485
  470664
  488532
  663856
  666842
  386991
  818638
  471174
  517428
  663992
  818815
  406556
  454333
  455799
  457644
  479787
  457585
  488541
  543612
  513517
  453073
  516418
  410724
  511028
  498038
]
2.58 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
  381979
  386991
  400428
  406556
  410724
  440265
  440745
  440963
  440977
  448712
  453037
  453068
  453073
  454333
  454706
  454913
  455799
  456859
  457585
  457603
  457644
  457668
  457737
  457789
  457791
  459162
  464295
  469234
  470664
  471174
  471196
  476588
  479787
  486083
  486485
  488532
  488541
  498038
  503695
  511028
  513517
  516418
  517428
  523561
  526086
  543612
  557595
  619508
  663856
  663992
  665227
  666842
  714053
  714743
  738352
  770164
  781930
  788945
  818638
  818815
]
1.72 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пляж природ mature парен"
]
1.61 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beach mature boy"
]
1.46 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пляж природ mature парен"
]
1.33 ms
(1.01%)
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.