Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
64.15 ms
(66.09%)
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
  188263
  188453
  382569
  391614
  395660
  395925
  401843
  407793
  407797
  410254
  443716
  452377
  452415
  453149
  454191
  454192
  454209
  465339
  465549
  466127
  466134
  466191
  466426
  466943
  466994
  476251
  483388
  484668
  484699
  484737
  490921
  499077
  506094
  506834
  515927
  533586
  545943
  546114
  546935
  549225
  561356
  563048
  563057
  563069
  563150
  563163
  563232
  563233
  565649
  721487
  724641
  725399
  728288
  731805
  751495
  756869
  782210
]
14.69 ms
(15.13%)
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:
[
  "boy for matures"
  "boy for matures"
  "boy for matures"
  20
]
9.80 ms
(10.10%)
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
  382569
  395925
  188263
  395660
  407793
  782210
  724641
  721487
  506094
  546935
  731805
  751495
  452415
  565649
  391614
  561356
  465339
  443716
  563048
  563069
  725399
  499077
  515927
  563163
  563233
  563150
  466127
  490921
  188453
  401843
  466426
  452377
  756869
  533586
  407797
  454209
  454192
  563057
  563232
  466134
  506834
  466943
  466191
  484699
  466994
  453149
  465549
  484737
  484668
  728288
  476251
  410254
  454191
  545943
  483388
  546114
  549225
]
2.08 ms
(2.14%)
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
  188263
  188453
  382569
  391614
  395660
  395925
  401843
  407793
  407797
  410254
  443716
  452377
  452415
  453149
  454191
  454192
  454209
  465339
  465549
  466127
  466134
  466191
  466426
  466943
  466994
  476251
  483388
  484668
  484699
  484737
  490921
  499077
  506094
  506834
  515927
  533586
  545943
  546114
  546935
  549225
  561356
  563048
  563057
  563069
  563150
  563163
  563232
  563233
  565649
  721487
  724641
  725399
  728288
  731805
  751495
  756869
  782210
]
1.67 ms
(1.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "парен matures"
]
1.60 ms
(1.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boy for matures"
]
1.55 ms
(1.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.56%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "парен matures"
]

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.