Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.46 ms
(56.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
134.70 ms
(37.28%)
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
  7271
  46409
  117755
  188079
  188499
  203497
  285702
  308542
  373842
  383951
  385677
  387039
  397312
  397319
  398388
  401109
  401122
  401124
  406406
  406596
  409048
  414105
  414218
  414938
  420800
  421146
  424523
  428889
  464921
  468749
  493508
  506501
  509672
  531533
  548162
  550549
  583276
  586006
  592332
  597553
  597995
  600358
  604650
  605167
  610806
  615129
  615690
  615789
  632108
  633115
  634536
  638605
  651636
  662090
  662204
  664781
  671389
  679114
  679147
  696227
  704220
  707738
  720827
  722578
  722869
  725144
  727780
  727839
  731874
  733902
  736802
  742831
  743282
  744704
  750187
  750710
  753638
  755937
  758959
  760966
  764284
  766703
  767125
  767198
  769733
  770284
  774950
  777059
  777562
  777888
  778038
  778842
  778937
  782410
  783609
  785981
  786327
  788820
  788954
  797869
  800303
  800683
  803669
  803919
  804757
  805310
  816241
  816887
  818727
  818793
  821109
  821128
  821588
  822168
  823092
  823341
  824864
  824915
  824938
  827491
]
13.28 ms
(3.67%)
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
  597553
  778937
  774950
  777562
  777888
  727839
  758959
  742831
  767198
  778842
  401124
  696227
  725144
  383951
  188499
  308542
  7271
  638605
  424523
  679114
  285702
  744704
  414938
  464921
  468749
  769733
  600358
  406406
  767125
  117755
  610806
  788820
  797869
  373842
  398388
  401122
  823092
  821109
  531533
  550549
  583276
  704220
  707738
  651636
  662090
  662204
  604650
  605167
  597995
  586006
  615789
  777059
  778038
  783609
  788954
  750710
  755937
  803669
  727780
  750187
  764284
  731874
  743282
  753638
  615129
  632108
  800303
  46409
  414105
  803919
  786327
  406596
  720827
  615690
  804757
  733902
  824915
  818727
  671389
  664781
  736802
  506501
  634536
  203497
  592332
  509672
  387039
  421146
  818793
  679147
  722578
  633115
  401109
  409048
  397319
  493508
  420800
  428889
  188079
  822168
  548162
  722869
  414218
  385677
  397312
  816241
  824938
  823341
  827491
  816887
  824864
  821128
  821588
  805310
  785981
  800683
  760966
  770284
  782410
  766703
]
2.82 ms
(0.78%)
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
  7271
  46409
  117755
  188079
  188499
  203497
  285702
  308542
  373842
  383951
  385677
  387039
  397312
  397319
  398388
  401109
  401122
  401124
  406406
  406596
  409048
  414105
  414218
  414938
  420800
  421146
  424523
  428889
  464921
  468749
  493508
  506501
  509672
  531533
  548162
  550549
  583276
  586006
  592332
  597553
  597995
  600358
  604650
  605167
  610806
  615129
  615690
  615789
  632108
  633115
  634536
  638605
  651636
  662090
  662204
  664781
  671389
  679114
  679147
  696227
  704220
  707738
  720827
  722578
  722869
  725144
  727780
  727839
  731874
  733902
  736802
  742831
  743282
  744704
  750187
  750710
  753638
  755937
  758959
  760966
  764284
  766703
  767125
  767198
  769733
  770284
  774950
  777059
  777562
  777888
  778038
  778842
  778937
  782410
  783609
  785981
  786327
  788820
  788954
  797869
  800303
  800683
  803669
  803919
  804757
  805310
  816241
  816887
  818727
  818793
  821109
  821128
  821588
  822168
  823092
  823341
  824864
  824915
  824938
  827491
]
1.78 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "deepthroat anal"
]
1.72 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "глубокийминет минет оральн секс анал"
]
1.53 ms
(0.42%)
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.