Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
180.71 ms
(86.68%)
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
  58325
  152529
  338113
  378272
  382643
  385671
  392446
  393504
  396826
  401844
  411904
  413272
  415049
  417408
  417842
  418961
  420605
  421540
  421829
  425587
  427843
  429958
  431337
  432511
  432622
  436059
  439236
  440662
  440813
  444403
  444880
  445524
  445583
  445829
  448159
  448274
  449102
  449906
  455538
  455819
  456203
  458074
  458130
  459146
  459441
  459930
  462626
  466761
  466793
  472621
  479910
  480508
  480692
  482078
  486257
  487654
  488529
  489011
  490892
  493146
  501072
  501509
  502765
  504411
  505090
  507630
  510497
  514028
  519211
  520812
  525854
  527541
  528025
  541796
  541807
  543500
  544700
  545835
  546966
  547516
  550218
  551617
  551821
  552809
  555388
  556469
  559548
  566101
  568792
  570377
  577633
  586237
  586428
  587337
  588277
  588473
  591767
  591962
  592562
  594983
  597174
  598316
  601932
  620371
  624419
  627326
  627794
  628141
  635736
  653541
  667058
  673152
  725379
  728285
  772951
  789240
  794142
  796553
  798415
  814433
]
16.17 ms
(7.76%)
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
  588277
  427843
  439236
  501509
  487654
  488529
  505090
  445524
  519211
  541807
  417408
  667058
  624419
  794142
  552809
  635736
  628141
  396826
  425587
  415049
  458130
  413272
  401844
  568792
  510497
  789240
  338113
  417842
  429958
  541796
  489011
  58325
  432511
  448159
  479910
  545835
  587337
  449102
  466761
  528025
  556469
  673152
  525854
  591767
  445829
  728285
  480692
  597174
  486257
  459930
  455819
  458074
  591962
  449906
  551617
  620371
  627794
  772951
  796553
  601932
  411904
  444880
  466793
  472621
  502765
  527541
  570377
  445583
  514028
  501072
  627326
  653541
  798415
  432622
  482078
  566101
  382643
  421540
  420605
  550218
  551821
  418961
  392446
  490892
  456203
  444403
  421829
  440813
  480508
  507630
  586428
  555388
  547516
  393504
  459146
  544700
  152529
  462626
  598316
  588473
  504411
  592562
  594983
  385671
  378272
  814433
  559548
  546966
  440662
  543500
  725379
  493146
  448274
  455538
  459441
  520812
  577633
  586237
  431337
  436059
]
4.32 ms
(2.07%)
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
  58325
  152529
  338113
  378272
  382643
  385671
  392446
  393504
  396826
  401844
  411904
  413272
  415049
  417408
  417842
  418961
  420605
  421540
  421829
  425587
  427843
  429958
  431337
  432511
  432622
  436059
  439236
  440662
  440813
  444403
  444880
  445524
  445583
  445829
  448159
  448274
  449102
  449906
  455538
  455819
  456203
  458074
  458130
  459146
  459441
  459930
  462626
  466761
  466793
  472621
  479910
  480508
  480692
  482078
  486257
  487654
  488529
  489011
  490892
  493146
  501072
  501509
  502765
  504411
  505090
  507630
  510497
  514028
  519211
  520812
  525854
  527541
  528025
  541796
  541807
  543500
  544700
  545835
  546966
  547516
  550218
  551617
  551821
  552809
  555388
  556469
  559548
  566101
  568792
  570377
  577633
  586237
  586428
  587337
  588277
  588473
  591767
  591962
  592562
  594983
  597174
  598316
  601932
  620371
  624419
  627326
  627794
  628141
  635736
  653541
  667058
  673152
  725379
  728285
  772951
  789240
  794142
  796553
  798415
  814433
]
2.08 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большие жопы в вагину%…"
]
1.85 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп в вагин"
]
1.58 ms
(0.76%)
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.