Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
190.73 ms
(88.93%)
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
  17037
  24255
  80089
  229555
  382050
  384566
  385505
  385890
  389288
  394552
  396176
  396526
  396597
  396809
  401225
  404395
  410003
  415224
  417339
  424753
  426147
  426789
  430308
  440813
  445238
  446226
  446695
  447474
  457291
  460583
  461812
  470958
  478182
  479253
  486442
  487367
  491705
  495127
  509201
  512232
  512639
  513091
  513198
  517068
  522962
  526925
  532897
  535918
  540745
  545268
  553030
  568282
  574488
  581833
  590413
  597254
  603371
  606285
  615658
  620875
  632052
  635081
  646783
  646929
  659380
  660866
  665658
  672636
  674327
  684947
  688937
  692450
  706993
  709614
  712534
  717236
  719873
  721070
  726864
  727811
  727818
  730741
  731998
  732452
  738126
  742161
  743136
  746510
  760114
  760267
  763593
  766447
  771895
  773226
  776265
  778143
  781997
  782628
  785923
  787782
  788078
  790992
  797409
  798373
  799872
  801864
  802510
  802540
  802884
  803459
  805606
  808452
  811211
  813575
  814130
  814527
  814571
  815766
  817720
  818745
]
14.51 ms
(6.76%)
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
  460583
  478182
  512232
  526925
  396597
  24255
  606285
  706993
  80089
  721070
  743136
  731998
  672636
  688937
  763593
  742161
  813575
  424753
  446226
  802540
  426147
  445238
  491705
  394552
  401225
  814571
  553030
  665658
  632052
  782628
  802510
  766447
  773226
  799872
  17037
  487367
  535918
  802884
  727811
  389288
  430308
  522962
  229555
  384566
  581833
  486442
  385505
  396176
  684947
  801864
  512639
  790992
  426789
  382050
  674327
  712534
  646783
  646929
  805606
  797409
  808452
  811211
  788078
  732452
  730741
  798373
  415224
  818745
  446695
  532897
  814130
  760114
  568282
  597254
  615658
  803459
  717236
  396809
  814527
  495127
  660866
  692450
  635081
  785923
  620875
  461812
  659380
  727818
  410003
  815766
  817720
  709614
  517068
  470958
  540745
  590413
  726864
  760267
  404395
  417339
  479253
  513198
  509201
  719873
  440813
  457291
  603371
  787782
  781997
  746510
  513091
  574488
  776265
  738126
  771895
  778143
  385890
  447474
  545268
  396526
]
2.98 ms
(1.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
  17037
  24255
  80089
  229555
  382050
  384566
  385505
  385890
  389288
  394552
  396176
  396526
  396597
  396809
  401225
  404395
  410003
  415224
  417339
  424753
  426147
  426789
  430308
  440813
  445238
  446226
  446695
  447474
  457291
  460583
  461812
  470958
  478182
  479253
  486442
  487367
  491705
  495127
  509201
  512232
  512639
  513091
  513198
  517068
  522962
  526925
  532897
  535918
  540745
  545268
  553030
  568282
  574488
  581833
  590413
  597254
  603371
  606285
  615658
  620875
  632052
  635081
  646783
  646929
  659380
  660866
  665658
  672636
  674327
  684947
  688937
  692450
  706993
  709614
  712534
  717236
  719873
  721070
  726864
  727811
  727818
  730741
  731998
  732452
  738126
  742161
  743136
  746510
  760114
  760267
  763593
  766447
  771895
  773226
  776265
  778143
  781997
  782628
  785923
  787782
  788078
  790992
  797409
  798373
  799872
  801864
  802510
  802540
  802884
  803459
  805606
  808452
  811211
  813575
  814130
  814527
  814571
  815766
  817720
  818745
]
1.73 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рыжая минет оральн секс"
]
1.53 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "redhead blowjob"
]
1.40 ms
(0.65%)
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.