Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.19 ms
(81.37%)
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
  550857
  554100
  567905
  574211
  585272
  586100
  588157
  589526
  590831
  597663
  600031
  600916
  607487
  616117
  620957
  621382
  629711
  629732
  638693
  639315
  640081
  640266
  640306
  640353
  642158
  644219
  649372
  652788
  654978
  656879
  656888
  657567
  671194
  671531
  675397
  678757
  684487
  689566
  690630
  693398
  705349
  706894
  710434
  713940
  714205
  715168
  720448
  729327
  735535
  738468
  739084
  739130
  739791
  739804
  741186
  743174
  743208
  744018
  744963
  745066
  745101
  749603
  750145
  751706
  752592
  752646
  753105
  756309
  756779
  756828
  758098
  760200
  761191
  761430
  766945
  767731
  772242
  772272
  776034
  777752
  777760
  777838
  778449
  778760
  780151
  780266
  780274
  780339
  782047
  782861
  783056
  783743
  785960
  786017
  786232
  786904
  787469
  787815
  789234
  791080
  791380
  791389
  792148
  796326
  796673
  796685
  796992
  796996
  803367
  803633
  804937
  806460
  806657
  807122
  807170
  807560
  808969
  809686
  810870
  813485
]
16.12 ms
(11.10%)
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
  715168
  649372
  656879
  671531
  678757
  684487
  693398
  705349
  710434
  713940
  652788
  654978
  656888
  657567
  671194
  675397
  689566
  690630
  706894
  714205
  720448
  550857
  554100
  567905
  574211
  588157
  589526
  597663
  616117
  639315
  642158
  620957
  621382
  629732
  640081
  640266
  640306
  644219
  585272
  586100
  600916
  607487
  629711
  590831
  600031
  638693
  640353
  776034
  777760
  778760
  780274
  780339
  783743
  787815
  792148
  796326
  803367
  807122
  777752
  777838
  778449
  780151
  780266
  782861
  786904
  791080
  791380
  796673
  796685
  796992
  796996
  803633
  806657
  807170
  808969
  739791
  741186
  744018
  751706
  756828
  761430
  772272
  782047
  783056
  785960
  786017
  786232
  787469
  789234
  791389
  804937
  806460
  807560
  809686
  810870
  813485
  729327
  767731
  738468
  739130
  745066
  749603
  756309
  766945
  735535
  739084
  739804
  743208
  745101
  758098
  760200
  761191
  772242
  743174
  744963
  750145
  752592
  752646
  753105
  756779
]
3.47 ms
(2.39%)
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
  550857
  554100
  567905
  574211
  585272
  586100
  588157
  589526
  590831
  597663
  600031
  600916
  607487
  616117
  620957
  621382
  629711
  629732
  638693
  639315
  640081
  640266
  640306
  640353
  642158
  644219
  649372
  652788
  654978
  656879
  656888
  657567
  671194
  671531
  675397
  678757
  684487
  689566
  690630
  693398
  705349
  706894
  710434
  713940
  714205
  715168
  720448
  729327
  735535
  738468
  739084
  739130
  739791
  739804
  741186
  743174
  743208
  744018
  744963
  745066
  745101
  749603
  750145
  751706
  752592
  752646
  753105
  756309
  756779
  756828
  758098
  760200
  761191
  761430
  766945
  767731
  772242
  772272
  776034
  777752
  777760
  777838
  778449
  778760
  780151
  780266
  780274
  780339
  782047
  782861
  783056
  783743
  785960
  786017
  786232
  786904
  787469
  787815
  789234
  791080
  791380
  791389
  792148
  796326
  796673
  796685
  796992
  796996
  803367
  803633
  804937
  806460
  806657
  807122
  807170
  807560
  808969
  809686
  810870
  813485
]
2.07 ms
(1.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbation solo dildo"
]
1.83 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мастурбац соло дилд"
]
1.63 ms
(1.12%)
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.