Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.20 ms
(83.12%)
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
  82281
  130482
  163536
  185563
  208999
  291689
  382466
  383549
  385082
  387241
  387647
  389475
  391190
  398461
  403346
  408988
  428913
  429534
  429540
  429544
  431672
  435618
  444822
  445765
  446499
  448328
  457257
  460938
  463755
  469549
  475812
  477408
  478025
  478454
  481376
  482242
  485046
  487779
  502270
  509776
  510574
  512224
  515749
  515883
  516853
  519904
  519905
  519914
  532927
  534198
  550643
  550644
  550712
  550739
  551943
  552002
  552005
  552017
  552891
  552912
  552913
  552928
  552933
  554320
  556362
  556375
  556397
  556408
  556501
  559875
  559886
  559902
  559968
  563883
  565470
  595705
  606699
  610365
  619420
  619429
  619432
  619435
  619451
  620962
  622601
  623501
  623601
  623608
  627728
  634755
  634756
  634760
  634854
  652127
  673048
  694194
  697447
  706399
  712169
  712182
  712197
  718961
  732304
  735852
  737105
  737125
  737162
  737165
  740313
  740764
  742480
  755696
  762296
  762382
  767283
  767285
  767287
  768090
  776009
  810016
]
14.13 ms
(9.85%)
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
  130482
  385082
  185563
  391190
  457257
  163536
  550739
  595705
  767287
  435618
  556501
  623501
  559875
  712197
  619429
  634756
  634854
  810016
  776009
  502270
  389475
  448328
  382466
  552928
  697447
  291689
  619420
  622601
  403346
  737165
  768090
  509776
  554320
  565470
  619435
  559886
  398461
  532927
  551943
  552891
  712169
  627728
  634760
  445765
  429540
  516853
  634755
  383549
  519905
  444822
  429544
  515749
  706399
  556397
  478025
  556408
  559968
  737125
  755696
  550644
  512224
  519904
  732304
  460938
  446499
  552002
  740764
  387241
  552933
  556362
  428913
  485046
  610365
  559902
  767283
  469549
  208999
  552017
  718961
  619432
  740313
  387647
  482242
  515883
  429534
  463755
  552912
  694194
  606699
  742480
  477408
  550643
  487779
  550712
  652127
  737162
  762382
  619451
  475812
  82281
  620962
  510574
  519914
  534198
  552005
  552913
  737105
  481376
  563883
  556375
  673048
  767285
  431672
  478454
  762296
  623601
  408988
  623608
  735852
  712182
]
3.03 ms
(2.11%)
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
  82281
  130482
  163536
  185563
  208999
  291689
  382466
  383549
  385082
  387241
  387647
  389475
  391190
  398461
  403346
  408988
  428913
  429534
  429540
  429544
  431672
  435618
  444822
  445765
  446499
  448328
  457257
  460938
  463755
  469549
  475812
  477408
  478025
  478454
  481376
  482242
  485046
  487779
  502270
  509776
  510574
  512224
  515749
  515883
  516853
  519904
  519905
  519914
  532927
  534198
  550643
  550644
  550712
  550739
  551943
  552002
  552005
  552017
  552891
  552912
  552913
  552928
  552933
  554320
  556362
  556375
  556397
  556408
  556501
  559875
  559886
  559902
  559968
  563883
  565470
  595705
  606699
  610365
  619420
  619429
  619432
  619435
  619451
  620962
  622601
  623501
  623601
  623608
  627728
  634755
  634756
  634760
  634854
  652127
  673048
  694194
  697447
  706399
  712169
  712182
  712197
  718961
  732304
  735852
  737105
  737125
  737162
  737165
  740313
  740764
  742480
  755696
  762296
  762382
  767283
  767285
  767287
  768090
  776009
  810016
]
2.03 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "japanese fuck"
]
1.81 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "японк азиатк секс"
]
1.74 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.