Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
69.61 ms
(65.43%)
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
  399209
  404904
  425612
  428040
  428394
  430349
  445672
  446977
  454227
  462955
  465010
  467374
  477100
  483408
  485747
  486199
  486215
  492279
  495739
  502695
  506269
  507710
  510232
  511009
  511413
  513025
  514715
  514717
  514796
  515876
  516025
  518296
  518406
  518722
  520805
  523822
  524416
  524836
  528041
  540912
  550443
  562790
  570896
  588057
  598653
  615979
  621294
  625826
  643456
  651929
  651933
  689978
  700901
  716811
  804771
  814175
]
16.55 ms
(15.56%)
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:
[
  "pussy nice"
  "pussy nice"
  "pussy nice"
  20
]
11.65 ms
(10.95%)
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
  700901
  689978
  643456
  625826
  518722
  511413
  520805
  515876
  510232
  477100
  404904
  425612
  428040
  454227
  467374
  524416
  518296
  804771
  430349
  486215
  485747
  514796
  540912
  428394
  814175
  483408
  507710
  528041
  570896
  615979
  399209
  465010
  462955
  446977
  492279
  514715
  518406
  495739
  486199
  550443
  716811
  588057
  516025
  598653
  524836
  506269
  445672
  513025
  514717
  651929
  651933
  621294
  523822
  562790
  502695
  511009
]
2.20 ms
(2.07%)
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
  399209
  404904
  425612
  428040
  428394
  430349
  445672
  446977
  454227
  462955
  465010
  467374
  477100
  483408
  485747
  486199
  486215
  492279
  495739
  502695
  506269
  507710
  510232
  511009
  511413
  513025
  514715
  514717
  514796
  515876
  516025
  518296
  518406
  518722
  520805
  523822
  524416
  524836
  528041
  540912
  550443
  562790
  570896
  588057
  598653
  615979
  621294
  625826
  643456
  651929
  651933
  689978
  700901
  716811
  804771
  814175
]
1.81 ms
(1.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy nice"
]
1.64 ms
(1.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy nice"
]
1.48 ms
(1.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy nice"
]

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.