Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.53 ms
(83.60%)
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
  7065
  61762
  145335
  212982
  233397
  385562
  388722
  390045
  391392
  391521
  391574
  391588
  394218
  395925
  400989
  401055
  407754
  411704
  412975
  454194
  460923
  464339
  465592
  465825
  465834
  466206
  470017
  474106
  474478
  474479
  474480
  474482
  476284
  479053
  481955
  482322
  484379
  485916
  486470
  504850
  522589
  523572
  525528
  530357
  532698
  533022
  546716
  547568
  556630
  561777
  566327
  566940
  591260
  601951
  608355
  615667
  620199
  665200
  665877
  665881
  666137
  666807
  667207
  667500
  667884
  712321
  714647
  716460
  721388
  721392
  721570
  724274
  724276
  725561
  727898
  728317
  732171
  740530
  741027
  745055
  746638
  748242
  756058
  757641
  773547
  774763
  781670
  781710
  781734
  782160
  782227
  782261
  782270
  784669
  785867
  788461
  788787
  788823
  788873
  789527
  789535
  789536
  789969
  793529
  794629
  794678
  802409
  804009
  807602
  807639
  808866
  816766
  816791
  818665
  818720
  818770
  823586
  823637
  823909
  828373
]
17.67 ms
(10.36%)
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
  388722
  784669
  530357
  532698
  391574
  390045
  391392
  412975
  407754
  486470
  481955
  460923
  464339
  465592
  474479
  479053
  504850
  522589
  523572
  566940
  546716
  556630
  566327
  591260
  789536
  727898
  748242
  725561
  728317
  391588
  400989
  391521
  474480
  474482
  476284
  385562
  474106
  411704
  465825
  465834
  466206
  470017
  482322
  454194
  474478
  485916
  484379
  145335
  394218
  61762
  7065
  816766
  818665
  816791
  823637
  818720
  818770
  823586
  823909
  828373
  525528
  533022
  547568
  561777
  665881
  721392
  721570
  665200
  666137
  665877
  666807
  667207
  667500
  667884
  712321
  714647
  716460
  615667
  601951
  620199
  608355
  774763
  781670
  781710
  781734
  782227
  782270
  785867
  788873
  789535
  802409
  804009
  807639
  782261
  788787
  789527
  794629
  724276
  782160
  788823
  789969
  793529
  794678
  807602
  808866
  724274
  756058
  732171
  741027
  745055
  740530
  746638
  757641
  773547
  721388
  788461
  212982
  233397
  395925
  401055
]
3.16 ms
(1.85%)
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
  7065
  61762
  145335
  212982
  233397
  385562
  388722
  390045
  391392
  391521
  391574
  391588
  394218
  395925
  400989
  401055
  407754
  411704
  412975
  454194
  460923
  464339
  465592
  465825
  465834
  466206
  470017
  474106
  474478
  474479
  474480
  474482
  476284
  479053
  481955
  482322
  484379
  485916
  486470
  504850
  522589
  523572
  525528
  530357
  532698
  533022
  546716
  547568
  556630
  561777
  566327
  566940
  591260
  601951
  608355
  615667
  620199
  665200
  665877
  665881
  666137
  666807
  667207
  667500
  667884
  712321
  714647
  716460
  721388
  721392
  721570
  724274
  724276
  725561
  727898
  728317
  732171
  740530
  741027
  745055
  746638
  748242
  756058
  757641
  773547
  774763
  781670
  781710
  781734
  782160
  782227
  782261
  782270
  784669
  785867
  788461
  788787
  788823
  788873
  789527
  789535
  789536
  789969
  793529
  794629
  794678
  802409
  804009
  807602
  807639
  808866
  816766
  816791
  818665
  818720
  818770
  823586
  823637
  823909
  828373
]
1.99 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature old young"
]
1.79 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature old young"
]
1.73 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature old young"
]
1.62 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.