Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.65 ms
(85.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
  119927
  172420
  193462
  358466
  378046
  382434
  384279
  391588
  393856
  397214
  397889
  398484
  400818
  400845
  400855
  401146
  401843
  401916
  403021
  403321
  406688
  409939
  411356
  411975
  416117
  419529
  419539
  421860
  421867
  421902
  424436
  425490
  439621
  439673
  439763
  439776
  439785
  440222
  440771
  443765
  444870
  444890
  444913
  448882
  451221
  452318
  455117
  459837
  466877
  467103
  467914
  468121
  470191
  470201
  472691
  476352
  478384
  479102
  482192
  483629
  483643
  485690
  486578
  493175
  496063
  512947
  514436
  515693
  516477
  521133
  521160
  528474
  531892
  533659
  536431
  561386
  566787
  566875
  580585
  585975
  596228
  599710
  622693
  624472
  663772
  670902
  696513
  713193
  717911
  718538
  725185
  726995
  735031
  735936
  741764
  750169
  759766
  767257
  768730
  770102
  770127
  770129
  770135
  770256
  794854
  794859
  794886
  796679
  797521
  798773
  800567
  802157
  803537
  807994
  810769
  811013
  814129
  823857
  824259
  824584
]
14.52 ms
(8.69%)
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
  596228
  467914
  824259
  531892
  800567
  470201
  421867
  440222
  483629
  515693
  566875
  624472
  803537
  794859
  391588
  440771
  358466
  439776
  483643
  521133
  485690
  536431
  401843
  802157
  400855
  797521
  796679
  798773
  403321
  486578
  382434
  466877
  533659
  750169
  717911
  811013
  741764
  172420
  393856
  401146
  794886
  378046
  419539
  452318
  421860
  425490
  400818
  512947
  444913
  421902
  451221
  439763
  528474
  400845
  439621
  409939
  824584
  467103
  468121
  521160
  663772
  599710
  397214
  444870
  444890
  566787
  406688
  770135
  794854
  193462
  670902
  585975
  767257
  768730
  718538
  439673
  561386
  479102
  470191
  119927
  398484
  493175
  411975
  416117
  482192
  696513
  403021
  496063
  622693
  476352
  419529
  384279
  759766
  713193
  580585
  726995
  735031
  770102
  735936
  770129
  770256
  807994
  810769
  443765
  448882
  401916
  424436
  455117
  516477
  814129
  823857
  459837
  439785
  514436
  770127
  472691
  478384
  725185
  397889
  411356
]
2.85 ms
(1.70%)
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
  119927
  172420
  193462
  358466
  378046
  382434
  384279
  391588
  393856
  397214
  397889
  398484
  400818
  400845
  400855
  401146
  401843
  401916
  403021
  403321
  406688
  409939
  411356
  411975
  416117
  419529
  419539
  421860
  421867
  421902
  424436
  425490
  439621
  439673
  439763
  439776
  439785
  440222
  440771
  443765
  444870
  444890
  444913
  448882
  451221
  452318
  455117
  459837
  466877
  467103
  467914
  468121
  470191
  470201
  472691
  476352
  478384
  479102
  482192
  483629
  483643
  485690
  486578
  493175
  496063
  512947
  514436
  515693
  516477
  521133
  521160
  528474
  531892
  533659
  536431
  561386
  566787
  566875
  580585
  585975
  596228
  599710
  622693
  624472
  663772
  670902
  696513
  713193
  717911
  718538
  725185
  726995
  735031
  735936
  741764
  750169
  759766
  767257
  768730
  770102
  770127
  770129
  770135
  770256
  794854
  794859
  794886
  796679
  797521
  798773
  800567
  802157
  803537
  807994
  810769
  811013
  814129
  823857
  824259
  824584
]
2.13 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анал с зрелой пышкой"
]
1.74 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал зрелая женщин полная"
]
1.72 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.90%)
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.