Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.10 ms
(82.92%)
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
  88182
  154463
  182118
  242575
  290847
  384108
  391917
  391986
  393313
  398114
  399083
  402792
  404369
  407436
  410272
  414071
  414122
  416609
  420244
  427008
  428229
  429958
  432929
  443083
  443244
  444283
  450599
  454282
  456226
  456232
  457541
  463777
  466869
  467220
  467560
  467585
  467588
  467598
  467634
  468680
  469023
  471691
  471764
  477587
  478057
  483735
  486432
  491173
  492215
  496337
  497474
  499931
  501611
  505356
  506119
  511275
  512943
  513846
  517612
  521831
  523357
  529069
  533942
  533988
  534534
  534537
  534993
  536684
  538992
  545294
  545442
  547521
  548458
  552706
  554528
  556899
  556903
  559281
  559289
  564514
  568261
  568379
  571192
  574458
  575859
  578308
  582848
  584301
  590281
  592030
  599958
  601789
  608491
  619659
  627225
  628402
  631593
  633502
  639706
  639802
  642766
  661933
  671049
  694464
  696216
  703574
  722428
  728295
  736337
  744795
  745083
  751710
  781250
  786873
  792761
  794213
  803509
  803582
  811700
  816078
]
18.36 ms
(11.10%)
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
  628402
  466869
  242575
  469023
  467220
  443244
  384108
  154463
  182118
  391917
  290847
  398114
  402792
  416609
  443083
  414071
  420244
  444283
  467598
  467634
  467585
  471764
  486432
  497474
  511275
  529069
  582848
  601789
  399083
  456226
  467588
  427008
  467560
  454282
  429958
  450599
  478057
  513846
  506119
  432929
  456232
  457541
  391986
  547521
  88182
  393313
  816078
  491173
  534537
  534534
  538992
  533988
  545294
  556903
  559289
  575859
  548458
  556899
  571192
  671049
  703574
  661933
  694464
  722428
  564514
  568261
  781250
  811700
  786873
  792761
  803509
  803582
  751710
  728295
  744795
  745083
  736337
  627225
  794213
  631593
  512943
  536684
  533942
  696216
  590281
  639802
  639706
  468680
  501611
  471691
  584301
  483735
  410272
  568379
  404369
  517612
  521831
  554528
  477587
  463777
  499931
  505356
  523357
  496337
  578308
  552706
  559281
  574458
  592030
  599958
  619659
  608491
  407436
  428229
  492215
  642766
  633502
  414122
  534993
  545442
]
3.30 ms
(1.99%)
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
  88182
  154463
  182118
  242575
  290847
  384108
  391917
  391986
  393313
  398114
  399083
  402792
  404369
  407436
  410272
  414071
  414122
  416609
  420244
  427008
  428229
  429958
  432929
  443083
  443244
  444283
  450599
  454282
  456226
  456232
  457541
  463777
  466869
  467220
  467560
  467585
  467588
  467598
  467634
  468680
  469023
  471691
  471764
  477587
  478057
  483735
  486432
  491173
  492215
  496337
  497474
  499931
  501611
  505356
  506119
  511275
  512943
  513846
  517612
  521831
  523357
  529069
  533942
  533988
  534534
  534537
  534993
  536684
  538992
  545294
  545442
  547521
  548458
  552706
  554528
  556899
  556903
  559281
  559289
  564514
  568261
  568379
  571192
  574458
  575859
  578308
  582848
  584301
  590281
  592030
  599958
  601789
  608491
  619659
  627225
  628402
  631593
  633502
  639706
  639802
  642766
  661933
  671049
  694464
  696216
  703574
  722428
  728295
  736337
  744795
  745083
  751710
  781250
  786873
  792761
  794213
  803509
  803582
  811700
  816078
]
1.75 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fisting stockings"
]
1.72 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фистинг чулк нижн бел"
]
1.52 ms
(0.92%)
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.