Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
229.22 ms
(64.51%)
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:
[
  "homemade amateur family"
  "homemade amateur family"
  "homemade amateur family"
  20
]
104.85 ms
(29.51%)
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
  396772
  419196
  426908
  448213
  453074
  454872
  457423
  457687
  460282
  462700
  464395
  467793
  470248
  474024
  482492
  484571
  485940
  491021
  494226
  510629
  510742
  516789
  518106
  518403
  518596
  520803
  524323
  525287
  525750
  526176
  526762
  539786
  542745
  548071
  558353
  561515
  582372
  584716
  584870
  587193
  591140
  601101
  601947
  601949
  617342
  620032
  621454
  623150
  623457
  624400
  625436
  625439
  632715
  634070
  732735
  784493
]
10.97 ms
(3.09%)
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
  518106
  582372
  542745
  625436
  632715
  784493
  732735
  457423
  516789
  624400
  539786
  526762
  584716
  467793
  457687
  558353
  634070
  518596
  601949
  623457
  454872
  620032
  426908
  494226
  485940
  448213
  396772
  525750
  591140
  419196
  510629
  462700
  460282
  587193
  561515
  623150
  484571
  548071
  453074
  510742
  625439
  518403
  621454
  526176
  482492
  474024
  470248
  524323
  464395
  584870
  617342
  601101
  601947
  525287
  491021
  520803
]
2.81 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade amateur family"
]
2.15 ms
(0.60%)
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
  396772
  419196
  426908
  448213
  453074
  454872
  457423
  457687
  460282
  462700
  464395
  467793
  470248
  474024
  482492
  484571
  485940
  491021
  494226
  510629
  510742
  516789
  518106
  518403
  518596
  520803
  524323
  525287
  525750
  526176
  526762
  539786
  542745
  548071
  558353
  561515
  582372
  584716
  584870
  587193
  591140
  601101
  601947
  601949
  617342
  620032
  621454
  623150
  623457
  624400
  625436
  625439
  632715
  634070
  732735
  784493
]
1.90 ms
(0.53%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск любительск family"
]
1.87 ms
(0.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск любительск family"
]

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.