Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.25 ms
(85.88%)
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
  384786
  390624
  402967
  403761
  421709
  424517
  427580
  429595
  435318
  437325
  437333
  438787
  446578
  447007
  448521
  451033
  451038
  452333
  452796
  454122
  454137
  455487
  455950
  458328
  458791
  459892
  459965
  460387
  460872
  461693
  463567
  464826
  470560
  471497
  472787
  475599
  476521
  479584
  480903
  483274
  484830
  484857
  484860
  487172
  490088
  490280
  492012
  495324
  495600
  495940
  496850
  497462
  497588
  502552
  506718
  509265
  510261
  512916
  514765
  516424
  519438
  520523
  520877
  521965
  523313
  523315
  526604
  526860
  527356
  530863
  532746
  535416
  541561
  541629
  542053
  543389
  543971
  546730
  548740
  557100
  560452
  560587
  561930
  565770
  566415
  568732
  568763
  571801
  571802
  577690
  579171
  579530
  584567
  586532
  601754
  602971
  603648
  605735
  609214
  615707
  619524
  624429
  624949
  626569
  626838
  631908
  632567
  654923
  717603
  718788
  720447
  726478
  735910
  755448
  756966
  772167
  776566
  781511
  796804
  811770
]
15.87 ms
(7.91%)
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
  483274
  429595
  447007
  452796
  455950
  459965
  460387
  455487
  487172
  532746
  512916
  492012
  541561
  579530
  543389
  543971
  568732
  571801
  577690
  615707
  603648
  586532
  776566
  755448
  735910
  772167
  438787
  475599
  461693
  520523
  484860
  521965
  484830
  496850
  523313
  384786
  530863
  427580
  437333
  424517
  451038
  479584
  452333
  463567
  472787
  527356
  565770
  541629
  571802
  717603
  720447
  584567
  609214
  619524
  626838
  811770
  781511
  756966
  726478
  471497
  435318
  437325
  458328
  446578
  454137
  464826
  480903
  451033
  476521
  509265
  526604
  526860
  495600
  506718
  495940
  510261
  516424
  523315
  403761
  495324
  542053
  718788
  796804
  497462
  514765
  566415
  654923
  624429
  624949
  632567
  601754
  626569
  454122
  605735
  631908
  390624
  421709
  448521
  490280
  497588
  602971
  402967
  548740
  484857
  458791
  460872
  470560
  459892
  490088
  519438
  502552
  520877
  535416
  561930
  557100
  560452
  560587
  546730
  568763
  579171
]
4.62 ms
(2.30%)
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
  384786
  390624
  402967
  403761
  421709
  424517
  427580
  429595
  435318
  437325
  437333
  438787
  446578
  447007
  448521
  451033
  451038
  452333
  452796
  454122
  454137
  455487
  455950
  458328
  458791
  459892
  459965
  460387
  460872
  461693
  463567
  464826
  470560
  471497
  472787
  475599
  476521
  479584
  480903
  483274
  484830
  484857
  484860
  487172
  490088
  490280
  492012
  495324
  495600
  495940
  496850
  497462
  497588
  502552
  506718
  509265
  510261
  512916
  514765
  516424
  519438
  520523
  520877
  521965
  523313
  523315
  526604
  526860
  527356
  530863
  532746
  535416
  541561
  541629
  542053
  543389
  543971
  546730
  548740
  557100
  560452
  560587
  561930
  565770
  566415
  568732
  568763
  571801
  571802
  577690
  579171
  579530
  584567
  586532
  601754
  602971
  603648
  605735
  609214
  615707
  619524
  624429
  624949
  626569
  626838
  631908
  632567
  654923
  717603
  718788
  720447
  726478
  735910
  755448
  756966
  772167
  776566
  781511
  796804
  811770
]
2.41 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "party homemade"
]
1.88 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "party домашн любительск"
]
1.78 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "party домашн любительск"
]

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.