Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.34 ms
(82.69%)
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
  329464
  386060
  397915
  398023
  413237
  417783
  418821
  419931
  425894
  434017
  440629
  442946
  448609
  454609
  456630
  459096
  461449
  462888
  485750
  488813
  491684
  491705
  491709
  491721
  491723
  491733
  502767
  504069
  510631
  510635
  510652
  511920
  512237
  522398
  523452
  537669
  538745
  540831
  546417
  552666
  563588
  567967
  573767
  574851
  575606
  590806
  594150
  594207
  595515
  597498
  598451
  598474
  598712
  598770
  600076
  600128
  616665
  617134
  619134
  619804
  623409
  626507
  632311
  635347
  646662
  647275
  654447
  669288
  677735
  686129
  687771
  692047
  692094
  695264
  700674
  716461
  718366
  718670
  722629
  724129
  724442
  725133
  732001
  732681
  735401
  736959
  741529
  742833
  743849
  746292
  747519
  750166
  750230
  752009
  753260
  753365
  753821
  755968
  756817
  757915
  762344
  765698
  765730
  765908
  766962
  767762
  773419
  776956
  779706
  781331
  785997
  790141
  790468
  794752
  796000
  807532
  809697
  816824
  817726
  827362
]
20.89 ms
(11.72%)
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
  623409
  632311
  448609
  462888
  434017
  510635
  537669
  573767
  654447
  600128
  732001
  386060
  574851
  413237
  510652
  523452
  485750
  504069
  597498
  594150
  594207
  459096
  418821
  419931
  454609
  502767
  552666
  600076
  488813
  522398
  510631
  442946
  456630
  617134
  598770
  538745
  511920
  619804
  743849
  753365
  794752
  397915
  417783
  724442
  718670
  827362
  646662
  692094
  440629
  425894
  491684
  491721
  491705
  512237
  598474
  807532
  765730
  563588
  753260
  692047
  755968
  757915
  635347
  732681
  491709
  491723
  491733
  817726
  796000
  785997
  790141
  750166
  753821
  773419
  746292
  781331
  647275
  575606
  590806
  742833
  747519
  724129
  741529
  736959
  779706
  461449
  816824
  687771
  716461
  567967
  619134
  626507
  765908
  398023
  540831
  546417
  677735
  700674
  686129
  718366
  616665
  776956
  809697
  750230
  756817
  735401
  762344
  752009
  767762
  765698
  766962
  790468
  329464
  722629
  669288
  695264
  598451
  595515
  598712
  725133
]
2.26 ms
(1.27%)
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
  329464
  386060
  397915
  398023
  413237
  417783
  418821
  419931
  425894
  434017
  440629
  442946
  448609
  454609
  456630
  459096
  461449
  462888
  485750
  488813
  491684
  491705
  491709
  491721
  491723
  491733
  502767
  504069
  510631
  510635
  510652
  511920
  512237
  522398
  523452
  537669
  538745
  540831
  546417
  552666
  563588
  567967
  573767
  574851
  575606
  590806
  594150
  594207
  595515
  597498
  598451
  598474
  598712
  598770
  600076
  600128
  616665
  617134
  619134
  619804
  623409
  626507
  632311
  635347
  646662
  647275
  654447
  669288
  677735
  686129
  687771
  692047
  692094
  695264
  700674
  716461
  718366
  718670
  722629
  724129
  724442
  725133
  732001
  732681
  735401
  736959
  741529
  742833
  743849
  746292
  747519
  750166
  750230
  752009
  753260
  753365
  753821
  755968
  756817
  757915
  762344
  765698
  765730
  765908
  766962
  767762
  773419
  776956
  779706
  781331
  785997
  790141
  790468
  794752
  796000
  807532
  809697
  816824
  817726
  827362
]
2.03 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen fucking"
]
1.86 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen fucking"
]
1.79 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen fucking"
]

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.