Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.22 ms
(83.90%)
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
  48547
  69589
  85949
  150261
  381983
  387648
  393600
  397106
  398753
  399021
  400518
  404084
  414765
  443143
  469292
  480220
  482418
  508231
  511462
  512384
  514670
  522565
  524729
  536993
  537637
  555533
  571744
  579853
  582864
  583314
  585401
  585769
  591516
  598131
  601173
  602730
  606926
  614706
  616585
  622179
  625122
  627268
  627768
  628776
  629816
  635830
  639929
  640727
  642562
  650881
  651348
  651420
  654217
  662920
  666019
  666686
  679549
  683484
  690703
  695773
  695805
  697471
  702380
  702993
  705224
  710419
  713413
  715787
  718592
  718872
  719648
  722442
  725094
  726019
  729587
  730928
  731131
  732592
  734270
  734700
  736338
  738377
  741268
  744080
  749076
  749639
  752019
  754173
  757760
  760874
  761504
  762507
  762819
  764668
  765424
  767819
  768660
  768876
  770592
  771730
  773116
  778184
  780376
  783964
  784009
  784680
  787286
  788592
  789282
  793412
  796289
  798235
  798675
  799723
  801325
  801768
  802475
  804060
  809362
  813744
]
13.11 ms
(8.93%)
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
  757760
  789282
  69589
  48547
  469292
  522565
  585769
  629816
  591516
  650881
  651348
  713413
  798675
  582864
  683484
  662920
  715787
  583314
  787286
  804060
  783964
  788592
  760874
  780376
  666019
  754173
  695773
  784009
  397106
  404084
  511462
  537637
  666686
  702993
  705224
  718872
  718592
  602730
  598131
  627268
  628776
  802475
  741268
  752019
  765424
  773116
  726019
  729587
  738377
  749076
  734270
  762819
  771730
  625122
  710419
  400518
  414765
  398753
  85949
  387648
  770592
  798235
  801325
  809362
  651420
  761504
  730928
  555533
  399021
  150261
  749639
  514670
  536993
  690703
  702380
  614706
  736338
  734700
  719648
  778184
  784680
  679549
  622179
  744080
  512384
  443143
  482418
  722442
  642562
  627768
  725094
  801768
  393600
  654217
  601173
  616585
  585401
  767819
  768660
  768876
  697471
  799723
  732592
  695805
  764668
  635830
  381983
  813744
  480220
  508231
  639929
  793412
  731131
  796289
  762507
  606926
  524729
  640727
  571744
  579853
]
2.87 ms
(1.96%)
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
  48547
  69589
  85949
  150261
  381983
  387648
  393600
  397106
  398753
  399021
  400518
  404084
  414765
  443143
  469292
  480220
  482418
  508231
  511462
  512384
  514670
  522565
  524729
  536993
  537637
  555533
  571744
  579853
  582864
  583314
  585401
  585769
  591516
  598131
  601173
  602730
  606926
  614706
  616585
  622179
  625122
  627268
  627768
  628776
  629816
  635830
  639929
  640727
  642562
  650881
  651348
  651420
  654217
  662920
  666019
  666686
  679549
  683484
  690703
  695773
  695805
  697471
  702380
  702993
  705224
  710419
  713413
  715787
  718592
  718872
  719648
  722442
  725094
  726019
  729587
  730928
  731131
  732592
  734270
  734700
  736338
  738377
  741268
  744080
  749076
  749639
  752019
  754173
  757760
  760874
  761504
  762507
  762819
  764668
  765424
  767819
  768660
  768876
  770592
  771730
  773116
  778184
  780376
  783964
  784009
  784680
  787286
  788592
  789282
  793412
  796289
  798235
  798675
  799723
  801325
  801768
  802475
  804060
  809362
  813744
]
2.23 ms
(1.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "друг жен секс"
]
1.84 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "друга жену трахнул"
]
1.67 ms
(1.14%)
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.