Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
193.14 ms
(88.01%)
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
  992
  7665
  28591
  75664
  114631
  192943
  221923
  269876
  282481
  383202
  389376
  393384
  399585
  400143
  400169
  401180
  402717
  402977
  404042
  404831
  413199
  419176
  429814
  435645
  443680
  445575
  447928
  453852
  458600
  470548
  490068
  494339
  497568
  506786
  510427
  511011
  514942
  515881
  520619
  522532
  522568
  523305
  530540
  538858
  538997
  541082
  549416
  549757
  557945
  562255
  566451
  571609
  575515
  579077
  583688
  584087
  586635
  593358
  600001
  603240
  618882
  622121
  622343
  623512
  624850
  630380
  630497
  640939
  641852
  643998
  644237
  649146
  652172
  652897
  653527
  654471
  654491
  656638
  657293
  661099
  666769
  670689
  680871
  694143
  703391
  706602
  717313
  719142
  720481
  720834
  721443
  721842
  722262
  722860
  722871
  723608
  724528
  740797
  743380
  747259
  748741
  756088
  757350
  770799
  770891
  771282
  775137
  775998
  797799
  798083
  798693
  810685
  816272
  817434
  817692
  818351
  819212
  820340
  820523
  820690
]
15.42 ms
(7.03%)
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
  719142
  389376
  652897
  400143
  400169
  435645
  511011
  652172
  586635
  797799
  383202
  603240
  640939
  722871
  522568
  538858
  549757
  654471
  661099
  643998
  623512
  453852
  429814
  269876
  654491
  657293
  706602
  520619
  514942
  541082
  445575
  703391
  618882
  584087
  820523
  817692
  649146
  694143
  720834
  770891
  771282
  770799
  798083
  7665
  28591
  557945
  510427
  515881
  583688
  680871
  656638
  549416
  775998
  740797
  221923
  419176
  530540
  717313
  622121
  798693
  506786
  593358
  747259
  819212
  743380
  756088
  443680
  75664
  402717
  523305
  522532
  470548
  644237
  490068
  562255
  992
  413199
  721443
  641852
  600001
  494339
  404042
  630497
  757350
  666769
  399585
  816272
  817434
  566451
  575515
  571609
  670689
  720481
  721842
  624850
  722860
  775137
  401180
  393384
  810685
  724528
  447928
  114631
  538997
  723608
  820690
  820340
  622343
  402977
  192943
  404831
  722262
  282481
  497568
  630380
  818351
  579077
  653527
  458600
  748741
]
3.45 ms
(1.57%)
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
  992
  7665
  28591
  75664
  114631
  192943
  221923
  269876
  282481
  383202
  389376
  393384
  399585
  400143
  400169
  401180
  402717
  402977
  404042
  404831
  413199
  419176
  429814
  435645
  443680
  445575
  447928
  453852
  458600
  470548
  490068
  494339
  497568
  506786
  510427
  511011
  514942
  515881
  520619
  522532
  522568
  523305
  530540
  538858
  538997
  541082
  549416
  549757
  557945
  562255
  566451
  571609
  575515
  579077
  583688
  584087
  586635
  593358
  600001
  603240
  618882
  622121
  622343
  623512
  624850
  630380
  630497
  640939
  641852
  643998
  644237
  649146
  652172
  652897
  653527
  654471
  654491
  656638
  657293
  661099
  666769
  670689
  680871
  694143
  703391
  706602
  717313
  719142
  720481
  720834
  721443
  721842
  722262
  722860
  722871
  723608
  724528
  740797
  743380
  747259
  748741
  756088
  757350
  770799
  770891
  771282
  775137
  775998
  797799
  798083
  798693
  810685
  816272
  817434
  817692
  818351
  819212
  820340
  820523
  820690
]
2.26 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome fuck girls"
]
1.81 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро секс девушк"
]
1.66 ms
(0.76%)
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.