Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.21 ms
(60.90%)
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
  410559
  413960
  414767
  419198
  419646
  420434
  421211
  425065
  447385
  450281
  451772
  454215
  468256
  470842
  476059
  494322
  504626
  522280
  524203
  525179
  526102
  531090
  545702
  548966
  562637
  563362
  566635
  571193
  576317
  578484
  588525
  590398
  591368
  594125
  594262
  594434
  597781
  597922
  600977
  603108
  605462
  606076
  618381
  760117
  779840
  809899
  810962
]
75.06 ms
(21.85%)
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
  410559
  413960
  414767
  419198
  419646
  420434
  421211
  425065
  447385
  450281
  451772
  454215
  468256
  470842
  476059
  494322
  504626
  522280
  524203
  525179
  526102
  531090
  545702
  548966
  562637
  563362
  566635
  571193
  576317
  578484
  588525
  590398
  591368
  594125
  594262
  594434
  597781
  597922
  600977
  603108
  605462
  606076
  618381
  760117
  779840
  809899
  810962
]
42.38 ms
(12.33%)
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:
[
  "teen girls masturbating"
  "teen girls masturbating"
  "teen girls masturbating"
  20
]
9.57 ms
(2.78%)
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
  421211
  562637
  809899
  531090
  419646
  447385
  494322
  760117
  420434
  545702
  594434
  468256
  410559
  548966
  597922
  566635
  603108
  590398
  594125
  413960
  476059
  578484
  779840
  526102
  600977
  597781
  810962
  425065
  504626
  414767
  606076
  594262
  470842
  571193
  450281
  451772
  525179
  419198
  522280
  563362
  605462
  588525
  524203
  618381
  591368
  454215
  576317
]
2.02 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen girls masturbating"
]
1.93 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen девушк masturbating"
]
1.86 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen девушк masturbating"
]
1.53 ms
(0.45%)
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.