Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.96 ms
(81.17%)
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
  95864
  97694
  191487
  383075
  383439
  386596
  388690
  390820
  396349
  396708
  396741
  397946
  399388
  399759
  402546
  405070
  407444
  408462
  419804
  424927
  426219
  443662
  443663
  451560
  457166
  457168
  462742
  476578
  476901
  478568
  482936
  483560
  483752
  484411
  486674
  489217
  490684
  495050
  502464
  508187
  516761
  517849
  518935
  519093
  520213
  523418
  527452
  531248
  532950
  533833
  536178
  536394
  536550
  537673
  541216
  542557
  548570
  550292
  550305
  556958
  562281
  565379
  565426
  568190
  574410
  575905
  578380
  583505
  584230
  590767
  590879
  597152
  598828
  600009
  600338
  601575
  604470
  604558
  605003
  605563
  606590
  614020
  615594
  620768
  623204
  630292
  631947
  632034
  632383
  633528
  633807
  634213
  637085
  640022
  644917
  648219
  654596
  661970
  671950
  694028
  704560
  710871
  719015
  720258
  724559
  732574
  737394
  744639
  748365
  755082
  775801
  814856
  815410
  815851
  816553
  816882
  818439
  818906
  827828
  827878
]
17.86 ms
(11.89%)
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
  443663
  578380
  568190
  654596
  633528
  590767
  490684
  632383
  630292
  574410
  556958
  640022
  598828
  519093
  476578
  482936
  424927
  816882
  631947
  615594
  517849
  407444
  419804
  562281
  476901
  623204
  724559
  827828
  827878
  95864
  383075
  383439
  396708
  396741
  443662
  532950
  516761
  462742
  661970
  737394
  633807
  388690
  97694
  390820
  397946
  399759
  818906
  489217
  484411
  508187
  531248
  502464
  536550
  541216
  648219
  632034
  600338
  601575
  604470
  634213
  451560
  386596
  408462
  483560
  191487
  402546
  816553
  644917
  814856
  815851
  457166
  478568
  518935
  495050
  520213
  537673
  533833
  583505
  584230
  542557
  550305
  671950
  719015
  550292
  565379
  565426
  605003
  604558
  606590
  600009
  775801
  732574
  744639
  755082
  620768
  399388
  457168
  405070
  527452
  396349
  426219
  815410
  818439
  486674
  536178
  536394
  523418
  483752
  548570
  575905
  704560
  720258
  694028
  710871
  605563
  637085
  590879
  614020
  597152
  748365
]
2.51 ms
(1.67%)
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
  95864
  97694
  191487
  383075
  383439
  386596
  388690
  390820
  396349
  396708
  396741
  397946
  399388
  399759
  402546
  405070
  407444
  408462
  419804
  424927
  426219
  443662
  443663
  451560
  457166
  457168
  462742
  476578
  476901
  478568
  482936
  483560
  483752
  484411
  486674
  489217
  490684
  495050
  502464
  508187
  516761
  517849
  518935
  519093
  520213
  523418
  527452
  531248
  532950
  533833
  536178
  536394
  536550
  537673
  541216
  542557
  548570
  550292
  550305
  556958
  562281
  565379
  565426
  568190
  574410
  575905
  578380
  583505
  584230
  590767
  590879
  597152
  598828
  600009
  600338
  601575
  604470
  604558
  605003
  605563
  606590
  614020
  615594
  620768
  623204
  630292
  631947
  632034
  632383
  633528
  633807
  634213
  637085
  640022
  644917
  648219
  654596
  661970
  671950
  694028
  704560
  710871
  719015
  720258
  724559
  732574
  737394
  744639
  748365
  755082
  775801
  814856
  815410
  815851
  816553
  816882
  818439
  818906
  827828
  827878
]
2.36 ms
(1.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome bbc"
]
2.01 ms
(1.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро bbc"
]
2.00 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс втро bbc"
]

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.