Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.69 ms
(59.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
61.61 ms
(17.67%)
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:
[
  "russian cuckold mom"
  "russian cuckold mom"
  "russian cuckold mom"
  20
]
59.18 ms
(16.97%)
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
  421833
  462560
  467545
  472388
  472396
  478528
  478530
  492167
  512560
  513398
  513408
  516090
  517117
  518781
  519955
  520127
  522423
  524613
  529457
  542744
  542745
  542748
  542792
  542872
  546720
  551572
  560474
  583723
  586448
  590546
  596841
  598204
  599213
  599272
  624849
  625567
  626024
  627380
  628426
  659197
  671395
  696308
  725401
  727330
  759484
  779069
  785876
  796506
  803076
]
10.63 ms
(3.05%)
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
  624849
  590546
  513408
  542744
  542792
  478528
  599213
  478530
  796506
  759484
  546720
  472396
  492167
  462560
  625567
  779069
  727330
  725401
  560474
  659197
  785876
  803076
  519955
  596841
  586448
  467545
  551572
  542872
  696308
  542745
  472388
  627380
  522423
  599272
  421833
  628426
  671395
  626024
  529457
  512560
  518781
  513398
  520127
  542748
  524613
  598204
  517117
  516090
  583723
]
2.84 ms
(0.82%)
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
  421833
  462560
  467545
  472388
  472396
  478528
  478530
  492167
  512560
  513398
  513408
  516090
  517117
  518781
  519955
  520127
  522423
  524613
  529457
  542744
  542745
  542748
  542792
  542872
  546720
  551572
  560474
  583723
  586448
  590546
  596841
  598204
  599213
  599272
  624849
  625567
  626024
  627380
  628426
  659197
  671395
  696308
  725401
  727330
  759484
  779069
  785876
  796506
  803076
]
2.42 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian cuckold mom"
]
1.76 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск куколд mom"
]
1.59 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск куколд mom"
]

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.