Query Metrics

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

Queries

Group similar statements

# Time Info
1 2.56 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 2.25 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature new"
]
3 18.48 ms
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
  740479
  612091
  641055
  466874
  430783
  453082
  465942
  476335
  517207
  520769
  486173
  525664
  386218
  389208
  399604
  441095
  423499
  415879
  443209
  453070
  532729
  527146
  481345
  582317
  661977
  552855
  584228
  643935
  586676
  593504
  601333
  634475
  594606
  599551
  788184
  796804
  724291
  603615
  720291
  400182
  450195
  414047
  434212
  471313
  509993
  582694
  599882
  587854
  628414
  804209
  446291
  433310
  466372
  513476
  522284
  523764
  516320
  531943
  401919
  409886
  408257
  441067
  478668
  527128
  522877
  530789
  543614
  582693
  544824
  556049
  665116
  605470
  604409
  641949
  439663
  467975
  430833
  439587
  507640
  489963
  522976
  410959
  477346
  530269
  500799
  535369
  512533
  650419
  786120
  440998
  406954
  535016
  419371
  449881
  469552
  562796
  646849
  648853
  634472
  626024
  601583
  462208
  519931
  587192
  519023
  532039
  627380
  467981
  520803
  492320
]
4 3.30 ms
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
  386218
  389208
  399604
  400182
  401919
  406954
  408257
  409886
  410959
  414047
  415879
  419371
  423499
  430783
  430833
  433310
  434212
  439587
  439663
  440998
  441067
  441095
  443209
  446291
  449881
  450195
  453070
  453082
  462208
  465942
  466372
  466874
  467975
  467981
  469552
  471313
  476335
  477346
  478668
  481345
  486173
  489963
  492320
  500799
  507640
  509993
  512533
  516320
  517207
  519023
  519931
  520769
  520803
  522284
  522877
  522976
  523764
  525664
  527128
  527146
  530269
  530789
  531943
  532039
  532729
  535016
  535369
  543614
  544824
  552855
  556049
  562796
  582317
  582693
  582694
  584228
  586676
  587192
  587854
  593504
  594606
  599551
  599882
  601333
  601583
  603615
  604409
  605470
  612091
  626024
  627380
  628414
  634472
  634475
  641055
  641949
  643935
  646849
  648853
  650419
  661977
  665116
  720291
  724291
  740479
  786120
  788184
  796804
  804209
]
5 161.75 ms
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
  386218
  389208
  399604
  400182
  401919
  406954
  408257
  409886
  410959
  414047
  415879
  419371
  423499
  430783
  430833
  433310
  434212
  439587
  439663
  440998
  441067
  441095
  443209
  446291
  449881
  450195
  453070
  453082
  462208
  465942
  466372
  466874
  467975
  467981
  469552
  471313
  476335
  477346
  478668
  481345
  486173
  489963
  492320
  500799
  507640
  509993
  512533
  516320
  517207
  519023
  519931
  520769
  520803
  522284
  522877
  522976
  523764
  525664
  527128
  527146
  530269
  530789
  531943
  532039
  532729
  535016
  535369
  543614
  544824
  552855
  556049
  562796
  582317
  582693
  582694
  584228
  586676
  587192
  587854
  593504
  594606
  599551
  599882
  601333
  601583
  603615
  604409
  605470
  612091
  626024
  627380
  628414
  634472
  634475
  641055
  641949
  643935
  646849
  648853
  650419
  661977
  665116
  720291
  724291
  740479
  786120
  788184
  796804
  804209
]
6 1.76 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature new"
]
7 1.90 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature new"
]

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.