Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.61 ms
(84.02%)
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
  270601
  398652
  403891
  403928
  407156
  407756
  407800
  407812
  409506
  409909
  410352
  410429
  422012
  428616
  429526
  432707
  442943
  446034
  447333
  447865
  448641
  453379
  457081
  457572
  461382
  461745
  462229
  463083
  463873
  464185
  464520
  467705
  468908
  469017
  469763
  470855
  471809
  474095
  475226
  477158
  478025
  479607
  491591
  492575
  493402
  496721
  497317
  497887
  499551
  500298
  500458
  501713
  503370
  504955
  508130
  509702
  510463
  511622
  512533
  512966
  513908
  518210
  520126
  521794
  521929
  522870
  523811
  523815
  529564
  530494
  530950
  533538
  533832
  534312
  534769
  536538
  536657
  537670
  543772
  551116
  556485
  560664
  563424
  563787
  565013
  565162
  565922
  567756
  584180
  584873
  589107
  591918
  593193
  596330
  601537
  612455
  614605
  615761
  617115
  628175
  636053
  640732
  650419
  668137
  670763
  680182
  710174
  725613
  736770
  738446
  770836
  770899
  779647
  793082
  806086
  808679
  810665
  811005
  812141
  817469
]
18.30 ms
(10.01%)
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
  808679
  770836
  738446
  270601
  398652
  448641
  462229
  479607
  461382
  477158
  513908
  521929
  496721
  432707
  447333
  403928
  407756
  407812
  429526
  409909
  817469
  468908
  457572
  470855
  491591
  521794
  530950
  563424
  565922
  636053
  615761
  806086
  770899
  725613
  710174
  811005
  812141
  410429
  453379
  422012
  442943
  457081
  508130
  497887
  503370
  493402
  403891
  428616
  467705
  475226
  463083
  533832
  500298
  584180
  551116
  670763
  591918
  614605
  810665
  736770
  779647
  793082
  511622
  512966
  520126
  529564
  497317
  499551
  512533
  407800
  446034
  447865
  523811
  534769
  504955
  518210
  471809
  668137
  596330
  640732
  617115
  464520
  461745
  464185
  501713
  492575
  589107
  410352
  500458
  533538
  530494
  560664
  565013
  409506
  463873
  478025
  407156
  469763
  509702
  523815
  474095
  536657
  537670
  650419
  565162
  567756
  628175
  593193
  469017
  510463
  522870
  534312
  680182
  563787
  536538
  556485
  601537
  543772
  584873
  612455
]
3.06 ms
(1.67%)
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
  270601
  398652
  403891
  403928
  407156
  407756
  407800
  407812
  409506
  409909
  410352
  410429
  422012
  428616
  429526
  432707
  442943
  446034
  447333
  447865
  448641
  453379
  457081
  457572
  461382
  461745
  462229
  463083
  463873
  464185
  464520
  467705
  468908
  469017
  469763
  470855
  471809
  474095
  475226
  477158
  478025
  479607
  491591
  492575
  493402
  496721
  497317
  497887
  499551
  500298
  500458
  501713
  503370
  504955
  508130
  509702
  510463
  511622
  512533
  512966
  513908
  518210
  520126
  521794
  521929
  522870
  523811
  523815
  529564
  530494
  530950
  533538
  533832
  534312
  534769
  536538
  536657
  537670
  543772
  551116
  556485
  560664
  563424
  563787
  565013
  565162
  565922
  567756
  584180
  584873
  589107
  591918
  593193
  596330
  601537
  612455
  614605
  615761
  617115
  628175
  636053
  640732
  650419
  668137
  670763
  680182
  710174
  725613
  736770
  738446
  770836
  770899
  779647
  793082
  806086
  808679
  810665
  811005
  812141
  817469
]
2.25 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "super pussy"
]
1.91 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "super pussy"
]
1.83 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "super pussy"
]

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.