Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
352.50 ms
(91.86%)
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
  7365
  43271
  72782
  183634
  187733
  187851
  187960
  188369
  188437
  233331
  326071
  358449
  358592
  379600
  384581
  385225
  388732
  388766
  389729
  391477
  391576
  391614
  393081
  394211
  397873
  400498
  400832
  400842
  400865
  400888
  401009
  401064
  401616
  407867
  409938
  409942
  411322
  411385
  411717
  417080
  419517
  419518
  419523
  419529
  421939
  422183
  424430
  426434
  426940
  428138
  428817
  430393
  439572
  443695
  451498
  457991
  466173
  466190
  466267
  466877
  466893
  467124
  468842
  472688
  478546
  484608
  485460
  486542
  491899
  493306
  515923
  517069
  527570
  531279
  547605
  549848
  557572
  577883
  582335
  594008
  596488
  606595
  623493
  627338
  650388
  670109
  703902
  710485
  714752
  714909
  716277
  717677
  718496
  720604
  724875
  725553
  730370
  732054
  737169
  740097
  742704
  747310
  761590
  770115
  777420
  781648
  782626
  784569
  789722
  790813
  793770
  799146
  800854
  800937
  803298
  803306
  803919
  815529
  818167
  824939
]
21.72 ms
(5.66%)
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
  187733
  426940
  43271
  467124
  486542
  547605
  557572
  703902
  187960
  389729
  400498
  421939
  397873
  391576
  183634
  391614
  394211
  400865
  419518
  419517
  400888
  720604
  606595
  725553
  724875
  747310
  430393
  393081
  411385
  385225
  790813
  824939
  730370
  803919
  409938
  717677
  761590
  793770
  732054
  388732
  188369
  358592
  233331
  517069
  466190
  417080
  515923
  7365
  187851
  72782
  815529
  818167
  527570
  670109
  716277
  803298
  770115
  740097
  401064
  531279
  577883
  800854
  428138
  784569
  737169
  457991
  466173
  401616
  710485
  391477
  400832
  443695
  401009
  411717
  188437
  627338
  358449
  468842
  419529
  384581
  714909
  650388
  714752
  742704
  623493
  781648
  789722
  549848
  799146
  411322
  491899
  426434
  388766
  493306
  718496
  582335
  596488
  782626
  803306
  451498
  485460
  407867
  422183
  466893
  472688
  379600
  400842
  466267
  428817
  484608
  424430
  466877
  419523
  439572
  478546
  409942
  326071
  594008
  777420
  800937
]
2.94 ms
(0.77%)
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
  7365
  43271
  72782
  183634
  187733
  187851
  187960
  188369
  188437
  233331
  326071
  358449
  358592
  379600
  384581
  385225
  388732
  388766
  389729
  391477
  391576
  391614
  393081
  394211
  397873
  400498
  400832
  400842
  400865
  400888
  401009
  401064
  401616
  407867
  409938
  409942
  411322
  411385
  411717
  417080
  419517
  419518
  419523
  419529
  421939
  422183
  424430
  426434
  426940
  428138
  428817
  430393
  439572
  443695
  451498
  457991
  466173
  466190
  466267
  466877
  466893
  467124
  468842
  472688
  478546
  484608
  485460
  486542
  491899
  493306
  515923
  517069
  527570
  531279
  547605
  549848
  557572
  577883
  582335
  594008
  596488
  606595
  623493
  627338
  650388
  670109
  703902
  710485
  714752
  714909
  716277
  717677
  718496
  720604
  724875
  725553
  730370
  732054
  737169
  740097
  742704
  747310
  761590
  770115
  777420
  781648
  782626
  784569
  789722
  790813
  793770
  799146
  800854
  800937
  803298
  803306
  803919
  815529
  818167
  824939
]
1.68 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old mother anal"
]
1.65 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old мам женщин анал"
]
1.63 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old мам женщин анал"
]

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.