Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
67.64 ms
(64.15%)
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
  396983
  400690
  400718
  406061
  418383
  434888
  445612
  449849
  453006
  453730
  458141
  462216
  466406
  501547
  514263
  514775
  516796
  517293
  519740
  520309
  520643
  523422
  524277
  524413
  536214
  540623
  543489
  560511
  561314
  598836
  602734
  603878
  612601
  616674
  616679
  626030
  659197
  682328
  686210
  703099
  732605
  732744
  747114
  750673
  756973
  761896
  770578
  787706
  793530
  811939
  813471
  827844
]
20.00 ms
(18.97%)
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:
[
  "daughter cum"
  "daughter cum"
  "daughter cum"
  20
]
9.09 ms
(8.62%)
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
  540623
  612601
  811939
  813471
  418383
  523422
  516796
  793530
  732605
  406061
  827844
  750673
  761896
  703099
  770578
  747114
  462216
  787706
  400690
  520643
  682328
  756973
  445612
  466406
  543489
  659197
  686210
  616679
  400718
  453730
  449849
  524277
  616674
  626030
  732744
  458141
  434888
  514775
  517293
  520309
  396983
  524413
  598836
  453006
  561314
  519740
  501547
  514263
  536214
  602734
  603878
  560511
]
2.41 ms
(2.29%)
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
  396983
  400690
  400718
  406061
  418383
  434888
  445612
  449849
  453006
  453730
  458141
  462216
  466406
  501547
  514263
  514775
  516796
  517293
  519740
  520309
  520643
  523422
  524277
  524413
  536214
  540623
  543489
  560511
  561314
  598836
  602734
  603878
  612601
  616674
  616679
  626030
  659197
  682328
  686210
  703099
  732605
  732744
  747114
  750673
  756973
  761896
  770578
  787706
  793530
  811939
  813471
  827844
]
1.86 ms
(1.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "daughter cum"
]
1.67 ms
(1.58%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "daughter cum"
]
1.48 ms
(1.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.30 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "daughter cum"
]

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.