Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
196.37 ms
(87.04%)
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
  93079
  384847
  386595
  395687
  395733
  395824
  400426
  400940
  401590
  405000
  405531
  406299
  406621
  410940
  413944
  413950
  414327
  414618
  414673
  416365
  421340
  421974
  422515
  425709
  426716
  429762
  430828
  432771
  435648
  442358
  442494
  443609
  443963
  444692
  445928
  447470
  448215
  448687
  455020
  463764
  465509
  469071
  470512
  477183
  477545
  478044
  478775
  478818
  482179
  488604
  491885
  491887
  500312
  501931
  503807
  505040
  515136
  516215
  517154
  519087
  520540
  530663
  534907
  539010
  541919
  542346
  543721
  543740
  544667
  544739
  545708
  546015
  546544
  548606
  548900
  552120
  552330
  556016
  556432
  558250
  559715
  561412
  562078
  562269
  563540
  565460
  567153
  567462
  567997
  569692
  570698
  576337
  584721
  587761
  590857
  596507
  596550
  606587
  613001
  622090
  633140
  636267
  640700
  650843
  656050
  664824
  693883
  723504
  742219
  748715
  750809
  754198
  773580
  801604
  802175
  811795
  814223
  817190
  819193
  821001
]
17.71 ms
(7.85%)
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
  811795
  754198
  773580
  656050
  430828
  519087
  435648
  613001
  750809
  463764
  534907
  801604
  445928
  590857
  413950
  406299
  421974
  465509
  443609
  541919
  405000
  416365
  552120
  561412
  425709
  414673
  447470
  515136
  505040
  448215
  491887
  545708
  395687
  414327
  491885
  501931
  542346
  567462
  556432
  546544
  548900
  636267
  444692
  442494
  469071
  569692
  477183
  470512
  478818
  400940
  405531
  455020
  478775
  503807
  500312
  520540
  596550
  488604
  400426
  432771
  442358
  413944
  429762
  422515
  421340
  448687
  478044
  539010
  548606
  562269
  565460
  546015
  562078
  567153
  414618
  443963
  477545
  530663
  558250
  410940
  406621
  650843
  543721
  748715
  426716
  563540
  570698
  556016
  606587
  633140
  640700
  395824
  384847
  93079
  817190
  819193
  543740
  587761
  596507
  723504
  401590
  386595
  395733
  814223
  516215
  482179
  544667
  552330
  559715
  567997
  576337
  664824
  821001
  517154
  584721
  693883
  544739
  622090
  802175
  742219
]
4.12 ms
(1.83%)
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
  93079
  384847
  386595
  395687
  395733
  395824
  400426
  400940
  401590
  405000
  405531
  406299
  406621
  410940
  413944
  413950
  414327
  414618
  414673
  416365
  421340
  421974
  422515
  425709
  426716
  429762
  430828
  432771
  435648
  442358
  442494
  443609
  443963
  444692
  445928
  447470
  448215
  448687
  455020
  463764
  465509
  469071
  470512
  477183
  477545
  478044
  478775
  478818
  482179
  488604
  491885
  491887
  500312
  501931
  503807
  505040
  515136
  516215
  517154
  519087
  520540
  530663
  534907
  539010
  541919
  542346
  543721
  543740
  544667
  544739
  545708
  546015
  546544
  548606
  548900
  552120
  552330
  556016
  556432
  558250
  559715
  561412
  562078
  562269
  563540
  565460
  567153
  567462
  567997
  569692
  570698
  576337
  584721
  587761
  590857
  596507
  596550
  606587
  613001
  622090
  633140
  636267
  640700
  650843
  656050
  664824
  693883
  723504
  742219
  748715
  750809
  754198
  773580
  801604
  802175
  811795
  814223
  817190
  819193
  821001
]
2.03 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "худая втроём"
]
1.85 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худая секс втро"
]
1.76 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.