Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
80.42 ms
(71.92%)
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
  391944
  419545
  451538
  453480
  454567
  458313
  463942
  466080
  470568
  470580
  470614
  474495
  476244
  491079
  493411
  494568
  497579
  497587
  499407
  502913
  504414
  506825
  508736
  509282
  510745
  510750
  517100
  517549
  520350
  525709
  527168
  540286
  547959
  548742
  549169
  551195
  551410
  562251
  566459
  566584
  569400
  576389
  601903
  661256
  781400
]
15.07 ms
(13.48%)
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:
[
  "russian in sauna"
  "russian in sauna"
  "russian in sauna"
  20
]
7.20 ms
(6.44%)
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
  510745
  491079
  494568
  525709
  497579
  509282
  506825
  527168
  502913
  391944
  458313
  540286
  547959
  569400
  562251
  566584
  781400
  419545
  470614
  470580
  517100
  520350
  454567
  499407
  470568
  576389
  549169
  551195
  548742
  463942
  508736
  504414
  453480
  476244
  566459
  451538
  474495
  466080
  510750
  497587
  493411
  551410
  517549
  661256
  601903
]
2.17 ms
(1.95%)
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
  391944
  419545
  451538
  453480
  454567
  458313
  463942
  466080
  470568
  470580
  470614
  474495
  476244
  491079
  493411
  494568
  497579
  497587
  499407
  502913
  504414
  506825
  508736
  509282
  510745
  510750
  517100
  517549
  520350
  525709
  527168
  540286
  547959
  548742
  549169
  551195
  551410
  562251
  566459
  566584
  569400
  576389
  601903
  661256
  781400
]
2.02 ms
(1.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian in sauna"
]
1.74 ms
(1.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск бан"
]
1.58 ms
(1.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.