Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
76.82 ms
(60.45%)
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
  34171
  407109
  408609
  422751
  447514
  455051
  470467
  483355
  491250
  492256
  494764
  497953
  504385
  506612
  511735
  512885
  516472
  520737
  525226
  526218
  529162
  539417
  544123
  550599
  556325
  556636
  559129
  562814
  562825
  564203
  584720
  585716
  590723
  610035
  619407
  620223
  621201
  621980
  624734
  654840
  655097
  655340
  658418
  659115
  659347
  686385
  689013
  722332
]
25.38 ms
(19.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:
[
  "пришла после любовника"
  "пришла после любовника"
  "пришла после любовника"
  20
]
14.42 ms
(11.34%)
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
  34171
  559129
  686385
  722332
  455051
  556325
  422751
  504385
  511735
  655097
  447514
  506612
  655340
  407109
  654840
  624734
  659115
  525226
  526218
  621201
  621980
  562814
  556636
  658418
  659347
  610035
  512885
  539417
  494764
  544123
  689013
  620223
  470467
  408609
  491250
  529162
  520737
  492256
  516472
  584720
  564203
  562825
  585716
  619407
  590723
  497953
  550599
  483355
]
2.82 ms
(2.22%)
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
  34171
  407109
  408609
  422751
  447514
  455051
  470467
  483355
  491250
  492256
  494764
  497953
  504385
  506612
  511735
  512885
  516472
  520737
  525226
  526218
  529162
  539417
  544123
  550599
  556325
  556636
  559129
  562814
  562825
  564203
  584720
  585716
  590723
  610035
  619407
  620223
  621201
  621980
  624734
  654840
  655097
  655340
  658418
  659115
  659347
  686385
  689013
  722332
]
2.31 ms
(1.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пришла после любовника"
]
1.88 ms
(1.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пришл посл любовник"
]
1.83 ms
(1.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.