Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.71 ms
(65.09%)
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
  383109
  383281
  387046
  387766
  402042
  437939
  464067
  464600
  509487
  515778
  515781
  515783
  515786
  515787
  515789
  515790
  524525
  524529
  572828
  572834
  572841
  572844
  572848
  572851
  572854
  572857
  572860
  572862
  572863
  572865
  572867
  572869
  575711
  630222
  644078
  665897
  671302
  671305
  671383
  700753
  702094
  702106
  702115
  702116
  712717
  714518
]
85.82 ms
(26.39%)
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
  383109
  383281
  387046
  387766
  402042
  437939
  464067
  464600
  509487
  515778
  515781
  515783
  515786
  515787
  515789
  515790
  524525
  524529
  572828
  572834
  572841
  572844
  572848
  572851
  572854
  572857
  572860
  572862
  572863
  572865
  572867
  572869
  575711
  630222
  644078
  665897
  671302
  671305
  671383
  700753
  702094
  702106
  702115
  702116
  712717
  714518
]
11.80 ms
(3.63%)
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:
[
  "pawn blowjob"
  "pawn blowjob"
  "pawn blowjob"
  20
]
8.87 ms
(2.73%)
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
  572863
  515783
  644078
  572854
  572834
  572867
  572848
  700753
  515790
  572862
  515789
  509487
  572857
  515787
  572851
  515781
  572860
  572841
  572865
  572844
  572869
  671302
  671383
  702115
  702116
  665897
  714518
  630222
  712717
  671305
  402042
  524529
  702094
  702106
  383109
  387046
  464600
  383281
  437939
  575711
  464067
  572828
  515786
  524525
  387766
  515778
]
2.14 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pawn blowjob"
]
1.89 ms
(0.58%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pawn минет оральн секс"
]
1.52 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pawn минет оральн секс"
]
1.52 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.