Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
233.91 ms
(89.84%)
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
  12680
  93079
  96503
  114645
  150488
  242127
  329606
  333653
  382164
  382803
  383508
  386395
  386816
  386869
  388091
  388584
  390593
  391740
  392805
  395511
  396677
  397227
  398204
  398579
  398704
  399389
  400311
  402042
  402103
  402859
  403559
  405847
  411069
  411074
  411236
  411310
  411335
  411752
  412207
  413958
  415907
  416102
  417751
  421743
  425222
  428135
  428602
  429119
  429897
  430064
  432641
  437564
  437742
  437826
  439893
  440694
  440942
  441609
  443044
  443840
  444289
  446249
  447141
  447938
  451566
  451567
  453197
  453604
  454648
  454651
  457546
  457558
  457603
  458090
  458104
  458264
  458441
  458744
  458828
  460426
  461773
  461847
  462705
  463430
  463709
  465977
  466528
  466786
  467135
  467785
  469481
  471997
  472797
  475095
  475896
  476153
  477605
  478989
  479398
  485408
  488637
  489172
  490590
  490806
  490814
  494613
  498155
  498210
  500950
  501989
  502681
  509549
  510637
  512616
  512664
  515615
  516931
  519409
  524716
  524728
]
17.09 ms
(6.56%)
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
  399389
  411335
  429119
  437742
  439893
  444289
  447938
  454648
  458744
  461773
  463709
  465977
  475095
  476153
  479398
  451566
  453604
  458441
  462705
  472797
  475896
  478989
  501989
  502681
  516931
  489172
  490814
  494613
  498210
  509549
  488637
  490590
  498155
  500950
  510637
  512616
  485408
  512664
  515615
  519409
  524716
  524728
  386395
  386816
  386869
  382803
  383508
  150488
  114645
  242127
  392805
  391740
  395511
  333653
  329606
  382164
  93079
  12680
  96503
  388584
  388091
  390593
  396677
  397227
  398204
  400311
  398704
  398579
  402103
  402859
  402042
  403559
  405847
  411310
  416102
  417751
  428602
  440694
  411069
  412207
  413958
  415907
  432641
  437826
  441609
  411074
  428135
  443044
  443840
  411236
  411752
  421743
  425222
  429897
  437564
  440942
  430064
  446249
  454651
  457546
  457558
  458104
  458828
  460426
  461847
  466528
  466786
  469481
  471997
  490806
  447141
  451567
  453197
  457603
  458090
  458264
  463430
  467135
  467785
  477605
]
2.43 ms
(0.93%)
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
  12680
  93079
  96503
  114645
  150488
  242127
  329606
  333653
  382164
  382803
  383508
  386395
  386816
  386869
  388091
  388584
  390593
  391740
  392805
  395511
  396677
  397227
  398204
  398579
  398704
  399389
  400311
  402042
  402103
  402859
  403559
  405847
  411069
  411074
  411236
  411310
  411335
  411752
  412207
  413958
  415907
  416102
  417751
  421743
  425222
  428135
  428602
  429119
  429897
  430064
  432641
  437564
  437742
  437826
  439893
  440694
  440942
  441609
  443044
  443840
  444289
  446249
  447141
  447938
  451566
  451567
  453197
  453604
  454648
  454651
  457546
  457558
  457603
  458090
  458104
  458264
  458441
  458744
  458828
  460426
  461773
  461847
  462705
  463430
  463709
  465977
  466528
  466786
  467135
  467785
  469481
  471997
  472797
  475095
  475896
  476153
  477605
  478989
  479398
  485408
  488637
  489172
  490590
  490806
  490814
  494613
  498155
  498210
  500950
  501989
  502681
  509549
  510637
  512616
  512664
  515615
  516931
  519409
  524716
  524728
]
1.92 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "потрахал"
]
1.82 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "потраха"
]
1.70 ms
(0.65%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "потраха"
]
1.49 ms
(0.57%)
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.