Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.42 ms
(84.03%)
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
  263752
  389208
  407646
  407657
  409165
  419131
  437868
  449021
  461040
  462484
  468038
  468559
  477210
  479860
  480367
  480368
  480379
  480382
  480394
  497441
  502487
  523051
  528538
  532164
  532357
  532776
  533426
  534246
  534284
  534288
  534293
  534312
  534377
  534394
  535017
  535021
  535369
  536370
  558904
  565150
  566606
  570725
  587257
  588211
  588283
  589116
  596571
  606748
  607713
  612423
  614515
  632333
  633150
  633158
  633166
  637758
  638360
  640022
  640710
  640713
  650419
  650421
  713564
  720747
  723443
  727482
  746339
  756395
  756611
  790793
  790794
  790799
  792610
  792637
  801960
  805379
  808444
  808467
  808472
  808579
  809930
  810013
  814749
  814760
  814814
  814832
  814842
  814847
  814850
  814859
  814865
  814892
  814908
  814921
  814951
  815180
  815333
  815340
  815389
  815421
  815529
  815629
  815677
  815704
  815715
  815722
  815785
  815791
  815860
  815890
  815910
  815931
  816052
  816063
  816538
  816542
  816865
  816876
  816886
  816944
]
17.87 ms
(9.91%)
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
  814951
  814850
  814908
  814760
  814847
  814749
  814814
  814921
  497441
  532776
  534284
  534293
  534246
  566606
  650421
  589116
  633150
  607713
  640713
  790794
  790793
  790799
  792610
  808467
  808472
  756611
  612423
  810013
  815931
  528538
  407646
  723443
  727482
  814859
  814842
  814865
  814832
  814892
  468559
  461040
  480379
  480394
  535021
  565150
  640022
  588283
  801960
  808579
  640710
  808444
  792637
  534394
  535369
  535017
  532164
  558904
  570725
  650419
  713564
  588211
  633158
  633166
  587257
  805379
  746339
  637758
  468038
  407657
  480382
  534288
  536370
  534312
  606748
  596571
  756395
  809930
  614515
  462484
  720747
  638360
  523051
  480368
  480367
  532357
  534377
  449021
  389208
  437868
  533426
  479860
  419131
  815860
  815629
  815677
  632333
  816865
  816944
  815785
  816876
  815389
  263752
  815704
  815340
  816052
  477210
  815722
  502487
  409165
  815421
  815333
  815529
  815180
  815715
  815890
  816063
  816538
  815791
  816542
  816886
  815910
]
3.58 ms
(1.98%)
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
  263752
  389208
  407646
  407657
  409165
  419131
  437868
  449021
  461040
  462484
  468038
  468559
  477210
  479860
  480367
  480368
  480379
  480382
  480394
  497441
  502487
  523051
  528538
  532164
  532357
  532776
  533426
  534246
  534284
  534288
  534293
  534312
  534377
  534394
  535017
  535021
  535369
  536370
  558904
  565150
  566606
  570725
  587257
  588211
  588283
  589116
  596571
  606748
  607713
  612423
  614515
  632333
  633150
  633158
  633166
  637758
  638360
  640022
  640710
  640713
  650419
  650421
  713564
  720747
  723443
  727482
  746339
  756395
  756611
  790793
  790794
  790799
  792610
  792637
  801960
  805379
  808444
  808467
  808472
  808579
  809930
  810013
  814749
  814760
  814814
  814832
  814842
  814847
  814850
  814859
  814865
  814892
  814908
  814921
  814951
  815180
  815333
  815340
  815389
  815421
  815529
  815629
  815677
  815704
  815715
  815722
  815785
  815791
  815860
  815890
  815910
  815931
  816052
  816063
  816538
  816542
  816865
  816876
  816886
  816944
]
1.90 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "brazzers mature"
]
1.83 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "brazzers mature"
]
1.80 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brazzers mature"
]

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.