Query Metrics

7 Database Queries
7 Different statements
178.65 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
156.01 ms
(87.33%)
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
  321277
  397001
  398094
  443260
  444283
  448914
  451044
  452840
  455080
  457074
  459028
  464852
  467634
  468148
  471461
  475420
  479832
  480357
  480671
  483741
  485472
  513220
  525468
  546431
  550429
  553732
  557720
  561748
  575391
  589166
  594236
  595249
  598566
  607520
  607692
  619636
  622720
  623280
  630254
  630406
  651737
  655010
  662165
  669268
  692728
  697242
  700693
  709616
  710875
  712098
  734837
  736561
  739155
  739827
  739946
  740255
  740527
  741119
  744021
  744027
  744795
  746177
  746777
  752990
  756776
  756841
  757225
  757466
  757483
  758322
  758789
  760601
  766433
  772579
  773921
  774884
  776031
  777791
  779720
  780350
  781922
  782051
  782079
  782093
  782094
  782891
  783049
  783568
  783709
  788113
  788360
  791520
  796327
  796644
  796863
  801625
  801628
  803543
  803767
  804701
  806529
  806584
  806822
  807050
  807173
  807568
  808144
  811252
  812043
  812195
  813558
  818301
  821075
  823996
  824733
  825329
  827009
  827619
]
12.89 ms
(7.21%)
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
  756841
  758322
  803543
  803767
  806505
  807050
  807147
  808144
  746177
  756776
  744021
  744795
  739827
  757483
  622720
  779720
  782079
  806822
  459028
  712098
  709616
  321277
  443260
  444283
  455080
  467634
  557720
  525468
  561748
  595249
  812043
  398094
  821075
  827619
  818301
  651737
  692728
  710875
  774884
  782051
  777791
  783568
  744027
  752990
  791520
  740255
  760601
  746777
  773921
  796863
  811252
  812195
  397001
  823996
  825329
  824733
  827009
  479832
  546431
  783049
  813558
  452840
  471461
  464852
  553732
  575391
  669268
  655010
  662165
  700693
  697242
  550429
  594236
  607692
  598566
  619636
  630254
  607520
  776031
  788113
  804701
  807173
  780350
  806529
  806584
  807568
  741119
  758789
  766433
  772579
  782891
  788360
  796644
  801628
  734837
  736561
  739946
  739155
  757466
  623280
  630406
  781922
  782093
  782094
  783709
  796327
  801625
  480671
  480357
  483741
  740527
  757225
  457074
  448914
  468148
  451044
  475420
  513220
  485472
  589166
]
2.89 ms
(1.62%)
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
  321277
  397001
  398094
  443260
  444283
  448914
  451044
  452840
  455080
  457074
  459028
  464852
  467634
  468148
  471461
  475420
  479832
  480357
  480671
  483741
  485472
  513220
  525468
  546431
  550429
  553732
  557720
  561748
  575391
  589166
  594236
  595249
  598566
  607520
  607692
  619636
  622720
  623280
  630254
  630406
  651737
  655010
  662165
  669268
  692728
  697242
  700693
  709616
  710875
  712098
  734837
  736561
  739155
  739827
  739946
  740255
  740527
  741119
  744021
  744027
  744795
  746177
  746777
  752990
  756776
  756841
  757225
  757466
  757483
  758322
  758789
  760601
  766433
  772579
  773921
  774884
  776031
  777791
  779720
  780350
  781922
  782051
  782079
  782093
  782094
  782891
  783049
  783568
  783709
  788113
  788360
  791520
  796327
  796644
  796863
  801625
  801628
  803543
  803767
  804701
  806529
  806584
  806822
  807050
  807173
  807568
  808144
  811252
  812043
  812195
  813558
  818301
  821075
  823996
  824733
  825329
  827009
  827619
]
1.89 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo pussy solo"
]
1.70 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд pussy соло"
]
1.65 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд pussy соло"
]

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.