Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
188.57 ms
(86.31%)
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
  410905
  416022
  418215
  422380
  430374
  433981
  434321
  434355
  434374
  435005
  437496
  437929
  440876
  444168
  444189
  444527
  448369
  448898
  450697
  456385
  456593
  456857
  463384
  467877
  467882
  476670
  478010
  478023
  480647
  484206
  495381
  502861
  504725
  505589
  506239
  509019
  510898
  513741
  513938
  515452
  520651
  524237
  526604
  528122
  541575
  547794
  555984
  562384
  571316
  571697
  590102
  590410
  591197
  592862
  593974
  595660
  599001
  608174
  609926
  614910
  620689
  623832
  653187
  653452
  653560
  659690
  659793
  661268
  663293
  666530
  669893
  669905
  675179
  678611
  685807
  688922
  690666
  690952
  695708
  699928
  709914
  718678
  718746
  725524
  731813
  735194
  736959
  741851
  744786
  744896
  746087
  750699
  751312
  751316
  753902
  756480
  758163
  766150
  767419
  771452
  777830
  779780
  779870
  781429
  782547
  782731
  784792
  787043
  789188
  790038
  791365
  791489
  791623
  798059
  802282
  803880
  805995
  809484
  810896
  825864
]
17.58 ms
(8.05%)
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
  590410
  750699
  478010
  653452
  592862
  440876
  456385
  476670
  562384
  571697
  659793
  669893
  480647
  416022
  513938
  509019
  528122
  504725
  718746
  653187
  663293
  669905
  685807
  608174
  593974
  599001
  779780
  782731
  789188
  791365
  798059
  771452
  735194
  758163
  744896
  746087
  753902
  736959
  751312
  751316
  614910
  777830
  791623
  803880
  433981
  437496
  825864
  555984
  541575
  718678
  666530
  623832
  590102
  609926
  791489
  434374
  467877
  467882
  444527
  430374
  510898
  653560
  484206
  495381
  513741
  505589
  571316
  688922
  690666
  690952
  695708
  659690
  675179
  678611
  699928
  709914
  595660
  620689
  782547
  784792
  787043
  802282
  725524
  781429
  810896
  744786
  756480
  741851
  766150
  767419
  779870
  790038
  805995
  809484
  410905
  448898
  463384
  478023
  731813
  435005
  524237
  591197
  422380
  456857
  547794
  434321
  434355
  448369
  444168
  444189
  456593
  418215
  437929
  450697
  515452
  526604
  506239
  502861
  520651
  661268
]
4.05 ms
(1.86%)
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
  410905
  416022
  418215
  422380
  430374
  433981
  434321
  434355
  434374
  435005
  437496
  437929
  440876
  444168
  444189
  444527
  448369
  448898
  450697
  456385
  456593
  456857
  463384
  467877
  467882
  476670
  478010
  478023
  480647
  484206
  495381
  502861
  504725
  505589
  506239
  509019
  510898
  513741
  513938
  515452
  520651
  524237
  526604
  528122
  541575
  547794
  555984
  562384
  571316
  571697
  590102
  590410
  591197
  592862
  593974
  595660
  599001
  608174
  609926
  614910
  620689
  623832
  653187
  653452
  653560
  659690
  659793
  661268
  663293
  666530
  669893
  669905
  675179
  678611
  685807
  688922
  690666
  690952
  695708
  699928
  709914
  718678
  718746
  725524
  731813
  735194
  736959
  741851
  744786
  744896
  746087
  750699
  751312
  751316
  753902
  756480
  758163
  766150
  767419
  771452
  777830
  779780
  779870
  781429
  782547
  782731
  784792
  787043
  789188
  790038
  791365
  791489
  791623
  798059
  802282
  803880
  805995
  809484
  810896
  825864
]
2.74 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русская дрожит"
]
1.89 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск оргазм"
]
1.85 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.82%)
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.