Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.83 ms
(84.11%)
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
  130105
  342206
  383391
  390680
  393724
  395552
  395614
  395674
  395687
  396742
  398347
  403909
  404622
  407650
  407895
  408306
  409506
  410267
  410603
  411751
  412593
  412738
  413944
  413971
  414232
  416351
  416772
  418423
  418838
  419524
  420139
  420768
  423657
  425709
  426197
  428404
  442994
  443476
  443773
  454221
  461765
  465606
  468628
  475904
  478048
  483553
  484125
  484699
  489310
  494618
  496900
  497356
  497874
  500312
  501931
  502703
  509808
  512447
  514601
  516045
  517612
  522130
  523851
  528886
  530694
  530808
  531087
  531139
  532984
  533371
  533378
  535358
  536631
  536681
  542975
  544827
  552898
  562255
  573411
  599852
  600049
  600290
  603386
  609154
  629326
  630765
  631249
  633734
  634179
  634787
  637009
  639258
  639742
  640800
  641642
  642064
  642660
  646004
  652223
  665207
  666872
  676024
  677287
  678556
  680271
  693078
  696203
  707315
  743130
  748528
  766847
  770672
  775780
  775900
  792552
  799284
  813082
  827850
  827854
  827855
]
18.15 ms
(10.06%)
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
  531087
  652223
  680271
  634179
  634787
  637009
  603386
  775900
  395674
  425709
  396742
  413971
  130105
  342206
  398347
  404622
  407650
  423657
  416351
  418838
  532984
  678556
  639742
  395552
  407895
  412738
  414232
  395687
  461765
  496900
  501931
  523851
  512447
  390680
  410267
  408306
  426197
  428404
  536681
  522130
  528886
  535358
  531139
  536631
  514601
  542975
  544827
  646004
  696203
  630765
  631249
  642064
  599852
  600290
  640800
  609154
  443773
  443476
  395614
  418423
  410603
  468628
  475904
  483553
  500312
  530808
  633734
  497874
  413944
  416772
  420768
  442994
  517612
  516045
  509808
  666872
  409506
  419524
  411751
  393724
  693078
  641642
  813082
  766847
  420139
  533371
  502703
  533378
  489310
  827854
  677287
  770672
  494618
  484699
  573411
  665207
  827855
  827850
  562255
  478048
  600049
  799284
  743130
  629326
  484125
  454221
  403909
  552898
  748528
  497356
  639258
  465606
  707315
  775780
  792552
  412593
  676024
  530694
  642660
  383391
]
2.72 ms
(1.51%)
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
  130105
  342206
  383391
  390680
  393724
  395552
  395614
  395674
  395687
  396742
  398347
  403909
  404622
  407650
  407895
  408306
  409506
  410267
  410603
  411751
  412593
  412738
  413944
  413971
  414232
  416351
  416772
  418423
  418838
  419524
  420139
  420768
  423657
  425709
  426197
  428404
  442994
  443476
  443773
  454221
  461765
  465606
  468628
  475904
  478048
  483553
  484125
  484699
  489310
  494618
  496900
  497356
  497874
  500312
  501931
  502703
  509808
  512447
  514601
  516045
  517612
  522130
  523851
  528886
  530694
  530808
  531087
  531139
  532984
  533371
  533378
  535358
  536631
  536681
  542975
  544827
  552898
  562255
  573411
  599852
  600049
  600290
  603386
  609154
  629326
  630765
  631249
  633734
  634179
  634787
  637009
  639258
  639742
  640800
  641642
  642064
  642660
  646004
  652223
  665207
  666872
  676024
  677287
  678556
  680271
  693078
  696203
  707315
  743130
  748528
  766847
  770672
  775780
  775900
  792552
  799284
  813082
  827850
  827854
  827855
]
2.10 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome hardcore"
]
2.04 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро хардкор"
]
1.84 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс втро хардкор"
]
1.84 ms
(1.02%)
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.