Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.31 ms
(54.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass cumshot"
]
143.84 ms
(38.09%)
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
  391499
  395378
  414753
  417243
  419094
  423887
  427007
  427620
  432690
  432708
  432732
  432744
  437155
  437966
  440884
  442518
  442664
  445376
  446055
  448296
  449735
  453504
  456460
  458420
  466397
  467027
  468029
  481410
  482115
  484806
  485551
  496942
  499995
  501491
  508262
  511302
  512011
  512950
  513369
  521232
  522327
  524911
  530014
  545221
  550842
  554495
  554648
  558327
  562249
  565011
  566358
  569071
  581699
  582708
  592293
  592315
  592830
  594297
  598295
  604635
  604688
  613598
  616643
  618851
  626351
  627766
  632102
  632747
  643319
  650098
  651922
  656628
  659423
  669634
  672526
  672877
  677112
  679561
  683143
  689432
  691166
  693884
  701170
  703915
  708905
  710377
  716364
  717839
  725451
  730507
  736350
  745981
  753023
  755721
  756659
  758869
  759575
  760313
  762330
  762867
  769039
  769585
  769916
  780215
  782738
  786713
  788026
  794302
  796283
  801064
  803556
  804640
  805258
  805302
  810767
  811993
  812876
  813292
  813961
  818554
]
19.29 ms
(5.11%)
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
  530014
  562249
  550842
  554648
  566358
  650098
  679561
  701170
  659423
  669634
  683143
  691166
  717839
  672526
  677112
  693884
  703915
  710377
  592315
  626351
  632747
  613598
  643319
  592830
  616643
  627766
  796283
  805258
  804640
  736350
  758869
  762330
  769039
  788026
  730507
  745981
  760313
  769585
  769916
  755721
  756659
  762867
  604635
  604688
  708905
  782738
  801064
  805302
  810767
  449735
  468029
  427620
  481410
  414753
  522327
  484806
  508262
  512011
  432690
  482115
  513369
  545221
  554495
  618851
  811993
  453504
  427007
  582708
  395378
  419094
  818554
  813961
  558327
  581699
  651922
  672877
  689432
  716364
  598295
  594297
  759575
  786713
  803556
  417243
  432708
  432732
  437966
  432744
  442664
  437155
  445376
  446055
  456460
  458420
  511302
  501491
  512950
  521232
  524911
  656628
  565011
  569071
  592293
  794302
  812876
  725451
  753023
  632102
  780215
  813292
  423887
  442518
  466397
  440884
  467027
  448296
  499995
  485551
  496942
  391499
]
2.87 ms
(0.76%)
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
  391499
  395378
  414753
  417243
  419094
  423887
  427007
  427620
  432690
  432708
  432732
  432744
  437155
  437966
  440884
  442518
  442664
  445376
  446055
  448296
  449735
  453504
  456460
  458420
  466397
  467027
  468029
  481410
  482115
  484806
  485551
  496942
  499995
  501491
  508262
  511302
  512011
  512950
  513369
  521232
  522327
  524911
  530014
  545221
  550842
  554495
  554648
  558327
  562249
  565011
  566358
  569071
  581699
  582708
  592293
  592315
  592830
  594297
  598295
  604635
  604688
  613598
  616643
  618851
  626351
  627766
  632102
  632747
  643319
  650098
  651922
  656628
  659423
  669634
  672526
  672877
  677112
  679561
  683143
  689432
  691166
  693884
  701170
  703915
  708905
  710377
  716364
  717839
  725451
  730507
  736350
  745981
  753023
  755721
  756659
  758869
  759575
  760313
  762330
  762867
  769039
  769585
  769916
  780215
  782738
  786713
  788026
  794302
  796283
  801064
  803556
  804640
  805258
  805302
  810767
  811993
  812876
  813292
  813961
  818554
]
2.07 ms
(0.55%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп cumshot"
]
1.56 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп cumshot"
]

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.