Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.54 ms
(84.12%)
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
  154692
  392023
  410694
  411469
  415965
  416157
  416170
  416522
  417789
  424613
  425984
  426167
  427132
  430350
  432680
  441042
  441049
  443240
  443255
  446778
  447160
  450455
  451029
  467585
  467875
  467952
  469567
  473745
  475420
  482190
  482293
  486773
  497474
  498511
  505343
  506945
  508250
  511314
  518458
  518550
  525468
  536378
  542684
  545775
  546065
  546708
  548835
  556885
  561040
  561794
  579670
  582833
  584592
  586402
  586566
  587178
  589710
  601656
  602821
  603362
  605133
  605219
  607629
  609885
  615823
  615921
  622777
  628515
  628633
  634108
  637198
  639530
  648716
  651130
  656672
  664149
  665971
  669067
  669080
  671044
  698821
  700061
  708517
  709729
  716840
  717035
  720206
  730166
  730181
  733040
  733519
  734657
  735841
  737052
  738659
  741878
  752704
  755079
  758787
  760319
  764321
  770397
  783261
  788209
  788953
  793156
  796646
  798243
  798415
  802899
  811690
  814975
  818577
  819307
  824084
  824801
  825834
  826384
  826753
  828572
]
13.52 ms
(9.44%)
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
  582833
  648716
  664149
  669080
  561040
  605133
  605219
  609885
  586402
  586566
  602821
  603362
  634108
  589710
  615921
  622777
  628633
  788209
  788953
  755079
  741878
  760319
  770397
  752704
  758787
  615823
  796646
  482293
  451029
  416157
  426167
  427132
  518458
  498511
  518550
  410694
  708517
  411469
  826384
  793156
  511314
  154692
  824084
  430350
  416522
  425984
  415965
  417789
  424613
  814975
  446778
  473745
  450455
  486773
  447160
  467585
  467952
  475420
  482190
  497474
  536378
  505343
  506945
  508250
  579670
  548835
  656672
  671044
  665971
  698821
  669067
  709729
  556885
  587178
  628515
  737052
  798243
  802899
  811690
  764321
  720206
  392023
  432680
  441042
  467875
  469567
  443240
  525468
  828572
  798415
  783261
  561794
  651130
  601656
  639530
  730181
  700061
  584592
  607629
  734657
  826753
  824801
  825834
  818577
  819307
  717035
  730166
  738659
  546065
  542684
  546708
  545775
  716840
  637198
  733040
  733519
  735841
  416170
  441049
  443255
]
2.49 ms
(1.74%)
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
  154692
  392023
  410694
  411469
  415965
  416157
  416170
  416522
  417789
  424613
  425984
  426167
  427132
  430350
  432680
  441042
  441049
  443240
  443255
  446778
  447160
  450455
  451029
  467585
  467875
  467952
  469567
  473745
  475420
  482190
  482293
  486773
  497474
  498511
  505343
  506945
  508250
  511314
  518458
  518550
  525468
  536378
  542684
  545775
  546065
  546708
  548835
  556885
  561040
  561794
  579670
  582833
  584592
  586402
  586566
  587178
  589710
  601656
  602821
  603362
  605133
  605219
  607629
  609885
  615823
  615921
  622777
  628515
  628633
  634108
  637198
  639530
  648716
  651130
  656672
  664149
  665971
  669067
  669080
  671044
  698821
  700061
  708517
  709729
  716840
  717035
  720206
  730166
  730181
  733040
  733519
  734657
  735841
  737052
  738659
  741878
  752704
  755079
  758787
  760319
  764321
  770397
  783261
  788209
  788953
  793156
  796646
  798243
  798415
  802899
  811690
  814975
  818577
  819307
  824084
  824801
  825834
  826384
  826753
  828572
]
2.02 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade huge"
]
1.83 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск огромные"
]
1.41 ms
(0.98%)
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.