Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.89 ms
(83.36%)
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
  7308
  270601
  406472
  421629
  424566
  432997
  443427
  443693
  444259
  458774
  461437
  462091
  462521
  466209
  466273
  467968
  470341
  470790
  473947
  473995
  476387
  484633
  486306
  486509
  492239
  493897
  495417
  496040
  501874
  504552
  513277
  513304
  513690
  516261
  524252
  524664
  526114
  550001
  552075
  552430
  558040
  558861
  561659
  561714
  565173
  565279
  565324
  569453
  574482
  574867
  575210
  575423
  576027
  576058
  576071
  576271
  579370
  580678
  581384
  590413
  594048
  595851
  596347
  597045
  597992
  598688
  609895
  615514
  653527
  654397
  654423
  659448
  662407
  670462
  670987
  677337
  683291
  695402
  704028
  713076
  713441
  718658
  721294
  721334
  722632
  725169
  730623
  736066
  740083
  741231
  741981
  741983
  747435
  747517
  748327
  748524
  751043
  754106
  754221
  754698
  762262
  773657
  774081
  774083
  774085
  774111
  776807
  777564
  777808
  778688
  779234
  779254
  780123
  782676
  782699
  782725
  786274
  786770
  800248
  812402
]
19.36 ms
(11.14%)
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
  552430
  670462
  695402
  670987
  654397
  677337
  552075
  786274
  786770
  782699
  730623
  741981
  748524
  741231
  747435
  774083
  754698
  754106
  773657
  777564
  777808
  780123
  526114
  473995
  424566
  501874
  558040
  576271
  574482
  574867
  576027
  576071
  561659
  558861
  580678
  596347
  432997
  458774
  467968
  462091
  443427
  513277
  486509
  493897
  565324
  466209
  524664
  495417
  484633
  496040
  470790
  659448
  595851
  597992
  762262
  443693
  722632
  713441
  662407
  704028
  713076
  721294
  653527
  609895
  615514
  778688
  779254
  812402
  782725
  800248
  740083
  747517
  782676
  736066
  748327
  774111
  754221
  741983
  774081
  774085
  751043
  779234
  598688
  462521
  7308
  444259
  406472
  597045
  473947
  575423
  581384
  683291
  654423
  594048
  776807
  725169
  718658
  721334
  270601
  470341
  524252
  513690
  466273
  486306
  492239
  504552
  579370
  565173
  576058
  561714
  565279
  569453
  575210
  550001
  590413
  421629
  461437
  476387
  513304
  516261
]
3.13 ms
(1.80%)
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
  7308
  270601
  406472
  421629
  424566
  432997
  443427
  443693
  444259
  458774
  461437
  462091
  462521
  466209
  466273
  467968
  470341
  470790
  473947
  473995
  476387
  484633
  486306
  486509
  492239
  493897
  495417
  496040
  501874
  504552
  513277
  513304
  513690
  516261
  524252
  524664
  526114
  550001
  552075
  552430
  558040
  558861
  561659
  561714
  565173
  565279
  565324
  569453
  574482
  574867
  575210
  575423
  576027
  576058
  576071
  576271
  579370
  580678
  581384
  590413
  594048
  595851
  596347
  597045
  597992
  598688
  609895
  615514
  653527
  654397
  654423
  659448
  662407
  670462
  670987
  677337
  683291
  695402
  704028
  713076
  713441
  718658
  721294
  721334
  722632
  725169
  730623
  736066
  740083
  741231
  741981
  741983
  747435
  747517
  748327
  748524
  751043
  754106
  754221
  754698
  762262
  773657
  774081
  774083
  774085
  774111
  776807
  777564
  777808
  778688
  779234
  779254
  780123
  782676
  782699
  782725
  786274
  786770
  800248
  812402
]
1.89 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русское кастинг порно…"
]
1.64 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск кастинг порн"
]
1.52 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.79%)
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.