Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.39 ms
(51.42%)
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:
[
  "daddy anal sex"
  "daddy anal sex"
  "daddy anal sex"
  20
]
120.93 ms
(40.54%)
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
  395856
  399263
  404811
  412738
  416192
  419320
  422565
  432760
  434523
  437594
  443093
  444660
  446682
  452828
  453364
  454859
  454871
  456035
  456951
  461870
  464650
  464848
  481847
  482084
  485304
  490567
  493192
  496086
  497424
  502133
  503934
  509696
  513201
  521426
  524089
  532644
  567046
  568558
  576990
  577822
  583654
  586821
  609922
  613488
  623135
  659451
  720885
]
12.43 ms
(4.17%)
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
  482084
  461870
  513201
  456035
  490567
  419320
  502133
  623135
  464848
  576990
  659451
  434523
  443093
  568558
  456951
  497424
  422565
  444660
  464650
  720885
  481847
  452828
  404811
  432760
  485304
  524089
  583654
  446682
  454871
  395856
  412738
  509696
  521426
  493192
  399263
  503934
  567046
  453364
  416192
  577822
  454859
  532644
  613488
  437594
  586821
  609922
  496086
]
4.09 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "daddy anal sex"
]
2.79 ms
(0.93%)
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
  395856
  399263
  404811
  412738
  416192
  419320
  422565
  432760
  434523
  437594
  443093
  444660
  446682
  452828
  453364
  454859
  454871
  456035
  456951
  461870
  464650
  464848
  481847
  482084
  485304
  490567
  493192
  496086
  497424
  502133
  503934
  509696
  513201
  521426
  524089
  532644
  567046
  568558
  576990
  577822
  583654
  586821
  609922
  613488
  623135
  659451
  720885
]
1.78 ms
(0.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.53%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "daddy анал секс"
]
1.33 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "daddy анал секс"
]

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.