Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.30 ms
(81.55%)
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
  6666
  69611
  391690
  393660
  396568
  399266
  399379
  401031
  401734
  406064
  415155
  417827
  418038
  424901
  427176
  428385
  429037
  429286
  429301
  430285
  430379
  430429
  443116
  443457
  446335
  448041
  450256
  451571
  451830
  452269
  461538
  462045
  468557
  472429
  473225
  473920
  475725
  475778
  477482
  478491
  478569
  478773
  480429
  481806
  482961
  484841
  485467
  486161
  486169
  486766
  487114
  488721
  491381
  497568
  497684
  508193
  508850
  511713
  514618
  515236
  517869
  517937
  518015
  520157
  521897
  521943
  522809
  523293
  531657
  533384
  534590
  539155
  543260
  544393
  545675
  548588
  551260
  551416
  556327
  556961
  557933
  558652
  560599
  565416
  567014
  568001
  571627
  571672
  571865
  573081
  573543
  573568
  575524
  578434
  580614
  580757
  582134
  582346
  592385
  594280
  601536
  604128
  604490
  604567
  606694
  607091
  607101
  613452
  614110
  617618
  646846
  657398
  661283
  712021
  720295
  722529
  738855
  744647
  749541
  789013
]
17.91 ms
(11.38%)
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
  522809
  508850
  488721
  556327
  6666
  446335
  533384
  508193
  497684
  571627
  548588
  551260
  551416
  573568
  657398
  722529
  557933
  571672
  580757
  614110
  749541
  401734
  418038
  430285
  475778
  429037
  450256
  461538
  415155
  462045
  430379
  511713
  514618
  521897
  427176
  478569
  539155
  573543
  558652
  661283
  424901
  429286
  443116
  475725
  486169
  486766
  468557
  477482
  481806
  517937
  534590
  712021
  606694
  607101
  617618
  789013
  738855
  473225
  478773
  391690
  429301
  448041
  451571
  517869
  473920
  480429
  472429
  497568
  515236
  543260
  720295
  604567
  607091
  601536
  417827
  69611
  393660
  485467
  582346
  571865
  580614
  594280
  604128
  484841
  487114
  443457
  486161
  482961
  646846
  582134
  604490
  592385
  744647
  613452
  428385
  399379
  491381
  406064
  430429
  531657
  578434
  478491
  521943
  523293
  518015
  396568
  399266
  401031
  452269
  451830
  520157
  545675
  567014
  568001
  560599
  573081
  544393
  565416
  556961
  575524
]
3.49 ms
(2.22%)
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
  6666
  69611
  391690
  393660
  396568
  399266
  399379
  401031
  401734
  406064
  415155
  417827
  418038
  424901
  427176
  428385
  429037
  429286
  429301
  430285
  430379
  430429
  443116
  443457
  446335
  448041
  450256
  451571
  451830
  452269
  461538
  462045
  468557
  472429
  473225
  473920
  475725
  475778
  477482
  478491
  478569
  478773
  480429
  481806
  482961
  484841
  485467
  486161
  486169
  486766
  487114
  488721
  491381
  497568
  497684
  508193
  508850
  511713
  514618
  515236
  517869
  517937
  518015
  520157
  521897
  521943
  522809
  523293
  531657
  533384
  534590
  539155
  543260
  544393
  545675
  548588
  551260
  551416
  556327
  556961
  557933
  558652
  560599
  565416
  567014
  568001
  571627
  571672
  571865
  573081
  573543
  573568
  575524
  578434
  580614
  580757
  582134
  582346
  592385
  594280
  601536
  604128
  604490
  604567
  606694
  607091
  607101
  613452
  614110
  617618
  646846
  657398
  661283
  712021
  720295
  722529
  738855
  744647
  749541
  789013
]
2.08 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbc skinny fuck"
]
1.83 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbc худые секс"
]
1.79 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.