Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
84.53 ms
(67.27%)
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
  403268
  423349
  446198
  446394
  448121
  448215
  466490
  472785
  477478
  482147
  513824
  520205
  520759
  523212
  530287
  543384
  543740
  544113
  557069
  559103
  560319
  568188
  579304
  581552
  584328
  603633
  609807
  633179
  649276
  650789
  661382
  666714
  708303
  717665
  718160
  718388
  720877
  721988
  723892
  737893
  767874
  768186
  807914
  812777
  825302
]
21.15 ms
(16.83%)
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:
[
  "hotel threesome amateur"
  "hotel threesome amateur"
  "hotel threesome amateur"
  20
]
9.31 ms
(7.41%)
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
  544113
  825302
  530287
  649276
  633179
  557069
  568188
  403268
  768186
  650789
  720877
  767874
  543740
  737893
  579304
  721988
  560319
  543384
  718388
  708303
  482147
  717665
  472785
  581552
  807914
  666714
  661382
  812777
  477478
  723892
  609807
  513824
  603633
  559103
  718160
  584328
  423349
  448215
  466490
  448121
  446394
  446198
  523212
  520205
  520759
]
3.23 ms
(2.57%)
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
  403268
  423349
  446198
  446394
  448121
  448215
  466490
  472785
  477478
  482147
  513824
  520205
  520759
  523212
  530287
  543384
  543740
  544113
  557069
  559103
  560319
  568188
  579304
  581552
  584328
  603633
  609807
  633179
  649276
  650789
  661382
  666714
  708303
  717665
  718160
  718388
  720877
  721988
  723892
  737893
  767874
  768186
  807914
  812777
  825302
]
2.00 ms
(1.59%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hotel секс втро любительск"
]
1.86 ms
(1.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hotel threesome amateur"
]
1.77 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hotel секс втро любительск"
]

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.