Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.14 ms
(32.61%)
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
  14966
  53477
  65568
  118164
  129748
  285321
  345630
  365056
  383638
  384117
  385245
  385713
  386193
  388341
  388662
  388672
  388930
  391674
  392452
  392839
  393765
  395428
  401583
  401585
  407290
  409075
  413095
  413391
  414021
  420363
  425495
  432683
  432824
  435559
  442035
  446888
  447985
  459429
  461275
  463845
  471899
  476296
  477496
  487280
  493873
  494385
  498453
  506516
  510820
  510822
  512087
  512357
  512683
  535261
  542413
  546829
  548458
  554498
  555026
  559789
  568259
  568529
  574951
  576494
  581477
  583455
  584183
  592500
  618276
  621682
  622479
  622720
  624193
  631131
  634076
  639960
  640242
  646044
  650498
  673838
  688181
  696584
  707571
  713163
  724580
  727552
  728215
  730074
  735995
  736307
  741220
  741980
  742938
  743947
  744021
  744795
  746177
  748287
  752616
  752627
  758322
  770712
  772104
  772744
  780656
  785073
  787564
  788528
  792761
  796887
  798251
  799349
  801629
  803134
  804198
  807569
  811765
  812057
  812332
  819545
]
212.29 ms
(32.18%)
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
  14966
  53477
  65568
  118164
  129748
  285321
  345630
  365056
  383638
  384117
  385245
  385713
  386193
  388341
  388662
  388672
  388930
  391674
  392452
  392839
  393765
  395428
  401583
  401585
  407290
  409075
  413095
  413391
  414021
  420363
  425495
  432683
  432824
  435559
  442035
  446888
  447985
  459429
  461275
  463845
  471899
  476296
  477496
  487280
  493873
  494385
  498453
  506516
  510820
  510822
  512087
  512357
  512683
  535261
  542413
  546829
  548458
  554498
  555026
  559789
  568259
  568529
  574951
  576494
  581477
  583455
  584183
  592500
  618276
  621682
  622479
  622720
  624193
  631131
  634076
  639960
  640242
  646044
  650498
  673838
  688181
  696584
  707571
  713163
  724580
  727552
  728215
  730074
  735995
  736307
  741220
  741980
  742938
  743947
  744021
  744795
  746177
  748287
  752616
  752627
  758322
  770712
  772104
  772744
  780656
  785073
  787564
  788528
  792761
  796887
  798251
  799349
  801629
  803134
  804198
  807569
  811765
  812057
  812332
  819545
]
210.04 ms
(31.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy хардкор"
]
16.82 ms
(2.55%)
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
  535261
  476296
  555026
  581477
  592500
  787564
  730074
  618276
  407290
  414021
  432824
  65568
  383638
  345630
  393765
  401585
  498453
  741980
  741220
  425495
  477496
  506516
  493873
  574951
  646044
  622479
  631131
  780656
  735995
  742938
  727552
  770712
  772744
  385713
  385245
  384117
  129748
  118164
  391674
  395428
  365056
  285321
  53477
  388672
  388341
  388662
  420363
  442035
  432683
  413095
  435559
  409075
  413391
  819545
  446888
  447985
  459429
  487280
  463845
  471899
  510820
  512683
  510822
  546829
  583455
  542413
  548458
  554498
  568529
  688181
  713163
  673838
  696584
  650498
  707571
  559789
  568259
  576494
  584183
  634076
  640242
  621682
  639960
  624193
  788528
  796887
  807569
  792761
  798251
  804198
  812332
  752616
  758322
  811765
  736307
  724580
  746177
  772104
  743947
  744021
  744795
  728215
  748287
  752627
  622720
  785073
  799349
  801629
  803134
  812057
  392452
  401583
  392839
  461275
  386193
  14966
  388930
  512087
  512357
  494385
]
1.84 ms
(0.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(0.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy хардкор"
]
1.77 ms
(0.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy extreme"
]

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.