Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
74.32 ms
(49.47%)
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
  389208
  401919
  432751
  435942
  439649
  445706
  452199
  454293
  457987
  465024
  468433
  469030
  472750
  472793
  476797
  482527
  484165
  486199
  486569
  486792
  492760
  494978
  501414
  512490
  513338
  515538
  516375
  518243
  520448
  520954
  523183
  524879
  526104
  526948
  532676
  532847
  533350
  535016
  543419
  544800
  558984
  569417
  571018
  582277
  582540
  582789
  586524
  586591
  591314
  597240
  598204
  599888
  601583
  602968
  604409
  611558
  612431
  618596
  634472
  634484
  639796
  647932
  648853
  662137
]
53.08 ms
(35.34%)
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 sex party"
  "milf sex party"
  "milf sex party"
  20
]
13.61 ms
(9.06%)
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
  569417
  602968
  618596
  515538
  484165
  571018
  454293
  558984
  612431
  604409
  435942
  445706
  501414
  598204
  533350
  486199
  468433
  486792
  516375
  472793
  532676
  582789
  389208
  512490
  457987
  520448
  465024
  492760
  518243
  586524
  439649
  469030
  486569
  526948
  452199
  532847
  648853
  582540
  634472
  599888
  601583
  494978
  634484
  662137
  513338
  586591
  401919
  544800
  476797
  520954
  647932
  639796
  523183
  432751
  524879
  482527
  582277
  611558
  591314
  535016
  526104
  472750
  543419
  597240
]
2.62 ms
(1.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf sex party"
]
2.18 ms
(1.45%)
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
  389208
  401919
  432751
  435942
  439649
  445706
  452199
  454293
  457987
  465024
  468433
  469030
  472750
  472793
  476797
  482527
  484165
  486199
  486569
  486792
  492760
  494978
  501414
  512490
  513338
  515538
  516375
  518243
  520448
  520954
  523183
  524879
  526104
  526948
  532676
  532847
  533350
  535016
  543419
  544800
  558984
  569417
  571018
  582277
  582540
  582789
  586524
  586591
  591314
  597240
  598204
  599888
  601583
  602968
  604409
  611558
  612431
  618596
  634472
  634484
  639796
  647932
  648853
  662137
]
1.56 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf секс party"
]
1.49 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf секс party"
]
1.36 ms
(0.91%)
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.