Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.70 ms
(83.28%)
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
  7322
  97107
  395732
  396429
  399036
  400439
  401498
  402034
  413641
  414139
  416531
  429909
  440715
  443224
  447435
  457608
  466614
  469760
  476198
  486634
  491683
  491718
  492122
  510507
  510542
  522821
  525055
  525905
  526462
  528124
  528730
  529159
  533725
  538665
  542661
  543897
  558058
  571924
  574508
  575111
  579412
  582894
  585109
  590023
  594077
  594365
  595851
  596402
  598349
  600204
  601097
  603026
  604000
  606403
  611563
  628089
  633455
  633533
  643008
  644066
  645994
  654078
  655186
  656186
  659209
  662062
  662065
  669737
  673229
  677671
  678732
  682502
  684360
  685819
  686133
  692077
  692130
  693900
  702571
  707505
  720787
  722914
  724285
  725146
  730038
  731382
  737143
  737734
  737847
  738816
  740908
  741785
  747516
  749669
  751405
  751434
  755341
  757020
  757454
  758959
  762163
  763798
  766729
  766821
  767198
  769830
  785832
  786988
  787033
  788839
  790464
  791416
  793343
  800794
  801311
  805502
  812395
  813879
  814465
  817272
]
15.10 ms
(9.55%)
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
  790464
  737847
  747516
  758959
  766821
  755341
  762163
  766729
  769830
  730038
  737734
  741785
  767198
  731382
  737143
  738816
  749669
  751405
  751434
  763798
  643008
  720787
  786988
  791416
  800794
  7322
  399036
  400439
  401498
  469760
  402034
  440715
  522821
  492122
  429909
  413641
  525055
  677671
  644066
  633533
  628089
  447435
  491683
  491718
  395732
  97107
  396429
  414139
  416531
  443224
  814465
  585109
  817272
  813879
  457608
  476198
  486634
  533725
  510507
  526462
  528124
  528730
  538665
  510542
  525905
  529159
  466614
  542661
  558058
  543897
  571924
  575111
  582894
  574508
  654078
  656186
  659209
  669737
  673229
  684360
  702571
  645994
  662062
  662065
  678732
  686133
  692077
  692130
  693900
  722914
  655186
  682502
  685819
  707505
  579412
  594365
  606403
  595851
  601097
  633455
  594077
  596402
  600204
  611563
  590023
  598349
  603026
  604000
  785832
  787033
  793343
  788839
  801311
  805502
  812395
  724285
  725146
  740908
  757020
  757454
]
2.99 ms
(1.89%)
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
  7322
  97107
  395732
  396429
  399036
  400439
  401498
  402034
  413641
  414139
  416531
  429909
  440715
  443224
  447435
  457608
  466614
  469760
  476198
  486634
  491683
  491718
  492122
  510507
  510542
  522821
  525055
  525905
  526462
  528124
  528730
  529159
  533725
  538665
  542661
  543897
  558058
  571924
  574508
  575111
  579412
  582894
  585109
  590023
  594077
  594365
  595851
  596402
  598349
  600204
  601097
  603026
  604000
  606403
  611563
  628089
  633455
  633533
  643008
  644066
  645994
  654078
  655186
  656186
  659209
  662062
  662065
  669737
  673229
  677671
  678732
  682502
  684360
  685819
  686133
  692077
  692130
  693900
  702571
  707505
  720787
  722914
  724285
  725146
  730038
  731382
  737143
  737734
  737847
  738816
  740908
  741785
  747516
  749669
  751405
  751434
  755341
  757020
  757454
  758959
  762163
  763798
  766729
  766821
  767198
  769830
  785832
  786988
  787033
  788839
  790464
  791416
  793343
  800794
  801311
  805502
  812395
  813879
  814465
  817272
]
2.72 ms
(1.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fucking teen"
]
1.99 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fucking teen"
]
1.88 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fucking teen"
]
1.76 ms
(1.11%)
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.