Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.34 ms
(54.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy hard"
]
150.13 ms
(39.24%)
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
  401525
  445603
  459752
  537653
  543094
  543250
  548074
  548760
  551515
  554447
  559960
  561725
  572434
  573087
  579507
  585214
  595052
  602789
  603546
  604945
  605794
  609939
  614789
  617631
  623209
  653264
  654583
  670770
  672629
  673339
  675042
  678817
  679115
  680616
  681228
  684528
  689336
  693680
  694600
  698822
  698879
  705230
  708828
  709615
  710541
  716986
  718629
  720094
  720234
  720455
  720566
  720987
  722688
  723588
  728955
  729230
  732496
  736285
  742404
  742540
  746884
  747270
  748406
  748832
  750293
  750729
  764666
  768382
  770980
  772439
  773444
  773884
  779859
  780084
  780377
  780518
  780635
  783853
  786924
  787646
  787681
  789806
  791071
  791795
  794119
  794482
  794535
  796218
  796309
  796701
  796737
  799550
  799631
  800524
  801206
  801859
  810057
  812437
  812522
  815848
  817107
  817527
  818500
  819687
  820150
  820198
  824237
  824443
  824654
  824700
  824957
  825473
  825761
  826850
  827059
  827264
  827363
  827962
  828727
  828835
]
13.79 ms
(3.60%)
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
  791071
  810057
  559960
  742404
  827059
  675042
  653264
  720987
  573087
  779859
  812522
  748832
  787681
  459752
  750729
  603546
  824443
  722688
  720455
  614789
  812437
  786924
  789806
  801206
  750293
  764666
  710541
  824237
  825761
  820198
  827264
  827363
  818500
  820150
  825473
  828727
  548074
  551515
  572434
  698879
  705230
  720566
  673339
  678817
  689336
  716986
  585214
  794535
  796218
  796701
  783853
  787646
  794119
  799631
  728955
  748406
  729230
  732496
  747270
  768382
  742540
  718629
  791795
  796737
  401525
  537653
  605794
  445603
  815848
  548760
  561725
  720234
  680616
  693680
  617631
  736285
  770980
  773444
  746884
  602789
  623209
  824654
  824957
  723588
  817107
  824700
  826850
  817527
  819687
  828835
  827962
  543250
  579507
  543094
  554447
  672629
  679115
  681228
  654583
  670770
  684528
  698822
  708828
  709615
  694600
  720094
  595052
  609939
  604945
  780377
  780635
  796309
  799550
  780084
  780518
  794482
  800524
  801859
  772439
  773884
]
4.01 ms
(1.05%)
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
  401525
  445603
  459752
  537653
  543094
  543250
  548074
  548760
  551515
  554447
  559960
  561725
  572434
  573087
  579507
  585214
  595052
  602789
  603546
  604945
  605794
  609939
  614789
  617631
  623209
  653264
  654583
  670770
  672629
  673339
  675042
  678817
  679115
  680616
  681228
  684528
  689336
  693680
  694600
  698822
  698879
  705230
  708828
  709615
  710541
  716986
  718629
  720094
  720234
  720455
  720566
  720987
  722688
  723588
  728955
  729230
  732496
  736285
  742404
  742540
  746884
  747270
  748406
  748832
  750293
  750729
  764666
  768382
  770980
  772439
  773444
  773884
  779859
  780084
  780377
  780518
  780635
  783853
  786924
  787646
  787681
  789806
  791071
  791795
  794119
  794482
  794535
  796218
  796309
  796701
  796737
  799550
  799631
  800524
  801206
  801859
  810057
  812437
  812522
  815848
  817107
  817527
  818500
  819687
  820150
  820198
  824237
  824443
  824654
  824700
  824957
  825473
  825761
  826850
  827059
  827264
  827363
  827962
  828727
  828835
]
2.01 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy hard"
]
1.70 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy hard"
]
1.64 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.