Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.67 ms
(55.38%)
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:
[
  "doctor anal sex"
  "doctor anal sex"
  "doctor anal sex"
  20
]
77.39 ms
(36.11%)
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
  90718
  408383
  410088
  422686
  424401
  430437
  439465
  447458
  469507
  469852
  491840
  508150
  519472
  519642
  521805
  531195
  531236
  534208
  534680
  548548
  548556
  548559
  548574
  555118
  560943
  562511
  563489
  583677
  593292
  593348
  593425
  593487
  607344
  609297
  632585
  641130
  659361
  669577
  681088
  706286
]
8.92 ms
(4.16%)
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
  491840
  560943
  410088
  562511
  408383
  593348
  469852
  531195
  534208
  641130
  422686
  469507
  531236
  706286
  519472
  555118
  563489
  534680
  548548
  548574
  583677
  521805
  669577
  447458
  593487
  609297
  424401
  548556
  659361
  681088
  90718
  593292
  632585
  439465
  593425
  519642
  548559
  607344
  508150
  430437
]
2.42 ms
(1.13%)
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
  90718
  408383
  410088
  422686
  424401
  430437
  439465
  447458
  469507
  469852
  491840
  508150
  519472
  519642
  521805
  531195
  531236
  534208
  534680
  548548
  548556
  548559
  548574
  555118
  560943
  562511
  563489
  583677
  593292
  593348
  593425
  593487
  607344
  609297
  632585
  641130
  659361
  669577
  681088
  706286
]
1.90 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "доктор анал секс"
]
1.70 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doctor anal sex"
]
1.44 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.