Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
89.08 ms
(46.39%)
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:
[
  "wife husband anal"
  "wife husband anal"
  "wife husband anal"
  20
]
85.30 ms
(44.42%)
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
  391386
  396253
  416399
  426405
  448148
  451108
  486964
  492606
  502250
  512059
  513126
  513517
  514265
  520132
  520759
  522469
  523401
  523537
  524613
  526182
  529345
  530026
  530763
  531231
  542789
  543508
  543844
  546720
  561135
  562758
  566651
  570177
  572026
  574432
  583723
  591415
  608771
  613177
  620232
  622778
  623380
  623834
  637650
  644005
  649525
  657504
  688055
  688116
  759865
  804491
]
8.57 ms
(4.46%)
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
  637650
  759865
  804491
  574432
  526182
  396253
  502250
  561135
  688055
  657504
  566651
  622778
  623834
  416399
  448148
  608771
  523537
  620232
  572026
  562758
  486964
  530026
  492606
  529345
  513126
  531231
  613177
  623380
  583723
  451108
  546720
  391386
  523401
  649525
  514265
  542789
  688116
  530763
  543508
  512059
  644005
  543844
  513517
  524613
  570177
  520132
  426405
  522469
  591415
  520759
]
2.56 ms
(1.33%)
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
  391386
  396253
  416399
  426405
  448148
  451108
  486964
  492606
  502250
  512059
  513126
  513517
  514265
  520132
  520759
  522469
  523401
  523537
  524613
  526182
  529345
  530026
  530763
  531231
  542789
  543508
  543844
  546720
  561135
  562758
  566651
  570177
  572026
  574432
  583723
  591415
  608771
  613177
  620232
  622778
  623380
  623834
  637650
  644005
  649525
  657504
  688055
  688116
  759865
  804491
]
1.73 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife husband anal"
]
1.66 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен husband анал"
]
1.62 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен husband анал"
]

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.