Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
70.34 ms
(63.51%)
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
  407168
  415936
  417855
  420008
  426459
  434741
  442643
  443184
  453094
  457595
  461055
  470442
  470443
  470451
  471176
  472806
  474696
  474857
  478981
  478994
  479343
  486785
  489087
  490831
  491680
  504610
  508662
  512451
  524879
  525683
  526104
  532482
  535393
  535410
  541632
  541871
  542969
  545643
  548311
  551919
  555182
  556913
  590860
  613318
  614273
  615770
]
17.68 ms
(15.96%)
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:
[
  "milf city"
  "milf city"
  "milf city"
  20
]
11.59 ms
(10.47%)
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
  535393
  535410
  442643
  417855
  491680
  457595
  461055
  472806
  443184
  470443
  479343
  420008
  489087
  490831
  453094
  478994
  542969
  590860
  471176
  434741
  470451
  470442
  556913
  426459
  478981
  415936
  551919
  615770
  474696
  486785
  548311
  407168
  508662
  512451
  525683
  524879
  555182
  504610
  545643
  614273
  613318
  474857
  526104
  541632
  541871
  532482
]
2.92 ms
(2.63%)
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
  407168
  415936
  417855
  420008
  426459
  434741
  442643
  443184
  453094
  457595
  461055
  470442
  470443
  470451
  471176
  472806
  474696
  474857
  478981
  478994
  479343
  486785
  489087
  490831
  491680
  504610
  508662
  512451
  524879
  525683
  526104
  532482
  535393
  535410
  541632
  541871
  542969
  545643
  548311
  551919
  555182
  556913
  590860
  613318
  614273
  615770
]
2.40 ms
(2.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf город"
]
2.23 ms
(2.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf city"
]
1.87 ms
(1.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf город"
]

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.