Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.25 ms
(86.16%)
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
  405074
  432250
  437176
  443080
  451224
  451779
  456737
  462144
  462904
  464372
  467565
  469586
  471886
  475630
  480069
  481766
  484695
  485002
  486336
  487472
  488219
  488823
  490087
  493310
  497166
  500482
  500498
  500505
  501841
  508510
  510157
  512137
  512478
  514659
  514693
  517372
  517395
  517450
  517455
  517596
  517602
  518406
  519851
  525137
  542056
  545009
  548751
  551532
  556778
  558338
  558788
  561131
  568316
  574566
  576113
  583981
  584262
  586786
  587598
  587864
  588016
  588038
  588039
  591908
  594768
  598207
  599272
  599863
  601478
  605456
  605521
  605553
  606541
  606567
  607146
  611902
  615394
  618561
  623149
  625086
  626124
  627380
  632442
  634856
  636567
  637731
  648672
  650983
  654617
  654840
  655410
  655647
  656465
  656686
  656710
  656782
  656789
  657033
  657051
  657067
  657287
  657670
  657692
  658269
  659703
  659714
  659715
  702369
  731397
  732633
  732635
  745526
  760534
  769395
  773971
  778701
  779627
  797138
  803873
  809879
]
18.14 ms
(9.13%)
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
  568316
  598207
  443080
  493310
  514693
  519851
  551532
  487472
  485002
  514659
  574566
  501841
  517602
  659714
  497166
  512478
  525137
  512137
  451779
  469586
  517372
  594768
  607146
  611902
  615394
  591908
  481766
  432250
  659703
  586786
  542056
  548751
  601478
  488219
  518406
  508510
  471886
  517596
  587598
  606541
  510157
  500482
  484695
  545009
  561131
  464372
  637731
  517395
  480069
  606567
  605553
  657051
  583981
  558788
  656686
  657287
  517455
  462904
  517450
  656789
  659715
  599272
  490087
  558338
  654840
  654617
  405074
  656465
  605456
  599863
  618561
  658269
  634856
  657670
  656782
  657033
  657692
  655647
  656710
  556778
  627380
  655410
  657067
  587864
  584262
  588039
  486336
  488823
  576113
  605521
  475630
  779627
  462144
  623149
  456737
  625086
  773971
  636567
  760534
  732635
  626124
  437176
  650983
  588016
  809879
  769395
  731397
  500498
  732633
  451224
  648672
  797138
  632442
  588038
  702369
  500505
  467565
  803873
  778701
  745526
]
2.51 ms
(1.26%)
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
  405074
  432250
  437176
  443080
  451224
  451779
  456737
  462144
  462904
  464372
  467565
  469586
  471886
  475630
  480069
  481766
  484695
  485002
  486336
  487472
  488219
  488823
  490087
  493310
  497166
  500482
  500498
  500505
  501841
  508510
  510157
  512137
  512478
  514659
  514693
  517372
  517395
  517450
  517455
  517596
  517602
  518406
  519851
  525137
  542056
  545009
  548751
  551532
  556778
  558338
  558788
  561131
  568316
  574566
  576113
  583981
  584262
  586786
  587598
  587864
  588016
  588038
  588039
  591908
  594768
  598207
  599272
  599863
  601478
  605456
  605521
  605553
  606541
  606567
  607146
  611902
  615394
  618561
  623149
  625086
  626124
  627380
  632442
  634856
  636567
  637731
  648672
  650983
  654617
  654840
  655410
  655647
  656465
  656686
  656710
  656782
  656789
  657033
  657051
  657067
  657287
  657670
  657692
  658269
  659703
  659714
  659715
  702369
  731397
  732633
  732635
  745526
  760534
  769395
  773971
  778701
  779627
  797138
  803873
  809879
]
1.97 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куколд дрочк член"
]
1.71 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куколд дрочк член"
]
1.59 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cuckold handjob"
]

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.