Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
88.68 ms
(53.14%)
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
  417839
  418968
  441956
  457649
  461690
  473344
  477355
  486197
  487800
  488207
  490744
  491172
  500508
  506844
  508592
  514105
  516826
  530555
  530731
  531424
  537634
  545068
  556396
  560903
  571479
  577670
  585797
  588480
  609708
  615085
  621347
  623956
  637183
  650829
  656876
  668467
  674516
  674894
  705074
  705196
  713445
  714779
  716188
  721883
  724300
  731080
  737508
  740200
  745315
  745319
  748396
  753610
  753933
  754875
  787102
  790819
  795780
  805109
  818832
]
62.49 ms
(37.45%)
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:
[
  "house hidden sex"
  "house hidden sex"
  "house hidden sex"
  20
]
6.04 ms
(3.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
  740200
  745315
  805109
  530555
  615085
  623956
  545068
  753610
  537634
  674894
  705074
  609708
  637183
  724300
  787102
  795780
  668467
  818832
  650829
  737508
  754875
  748396
  716188
  745319
  656876
  753933
  531424
  588480
  721883
  705196
  713445
  674516
  571479
  417839
  486197
  506844
  461690
  560903
  508592
  731080
  441956
  473344
  491172
  457649
  790819
  488207
  500508
  530731
  514105
  516826
  487800
  577670
  418968
  556396
  585797
  621347
  714779
  477355
  490744
]
2.57 ms
(1.54%)
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
  417839
  418968
  441956
  457649
  461690
  473344
  477355
  486197
  487800
  488207
  490744
  491172
  500508
  506844
  508592
  514105
  516826
  530555
  530731
  531424
  537634
  545068
  556396
  560903
  571479
  577670
  585797
  588480
  609708
  615085
  621347
  623956
  637183
  650829
  656876
  668467
  674516
  674894
  705074
  705196
  713445
  714779
  716188
  721883
  724300
  731080
  737508
  740200
  745315
  745319
  748396
  753610
  753933
  754875
  787102
  790819
  795780
  805109
  818832
]
2.02 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "house hidden sex"
]
1.81 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "house скрыт секс"
]
1.77 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "house скрыт секс"
]

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.