Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.40 ms
(85.58%)
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
  389264
  389729
  392054
  413182
  421821
  421824
  421834
  421841
  421842
  421843
  421855
  421858
  421862
  421877
  421913
  422141
  422146
  422182
  422185
  422207
  422235
  428869
  429552
  439569
  439633
  439635
  439638
  439704
  439707
  439763
  439802
  440645
  440979
  443182
  443184
  443702
  443711
  443832
  443946
  443996
  446549
  448674
  452616
  460601
  460751
  462082
  465545
  466145
  466368
  466762
  469391
  471883
  474097
  474783
  474786
  474799
  475174
  475175
  476280
  479038
  479059
  490929
  493175
  493185
  493193
  495226
  495227
  495820
  500806
  502813
  506055
  510518
  513495
  514301
  514441
  516480
  516485
  516712
  516787
  516829
  519604
  519735
  520916
  521133
  521391
  523018
  523031
  523837
  523848
  524357
  524779
  526010
  527658
  528826
  531685
  538005
  546937
  550221
  550224
  555158
  561597
  562990
  563142
  563423
  563432
  563436
  603678
  613286
  659197
  659986
  663772
  709458
  731073
  742839
  744184
  753515
  779576
  796202
  796203
  796205
]
16.44 ms
(9.23%)
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
  561597
  563142
  663772
  550224
  779576
  796202
  744184
  796203
  523031
  524779
  659986
  460601
  514441
  490929
  659197
  440645
  443711
  516480
  462082
  546937
  563423
  742839
  465545
  500806
  519604
  527658
  528826
  474783
  466368
  516485
  516829
  521391
  448674
  439802
  421913
  439763
  519735
  475175
  421821
  421834
  495820
  479038
  526010
  563432
  422207
  429552
  443832
  474799
  421824
  439707
  471883
  422141
  422146
  443184
  474786
  422235
  466145
  516712
  538005
  495226
  513495
  520916
  523837
  439569
  443182
  709458
  796205
  731073
  753515
  524357
  550221
  562990
  475174
  440979
  443946
  392054
  421858
  466762
  476280
  439704
  443702
  506055
  502813
  521133
  523848
  493175
  495227
  460751
  422185
  469391
  446549
  493193
  514301
  516787
  421842
  422182
  523018
  555158
  421843
  474097
  531685
  479059
  421841
  389264
  439633
  439638
  493185
  510518
  563436
  613286
  421862
  421877
  421855
  443996
  413182
  452616
  603678
  389729
  428869
  439635
]
2.76 ms
(1.55%)
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
  389264
  389729
  392054
  413182
  421821
  421824
  421834
  421841
  421842
  421843
  421855
  421858
  421862
  421877
  421913
  422141
  422146
  422182
  422185
  422207
  422235
  428869
  429552
  439569
  439633
  439635
  439638
  439704
  439707
  439763
  439802
  440645
  440979
  443182
  443184
  443702
  443711
  443832
  443946
  443996
  446549
  448674
  452616
  460601
  460751
  462082
  465545
  466145
  466368
  466762
  469391
  471883
  474097
  474783
  474786
  474799
  475174
  475175
  476280
  479038
  479059
  490929
  493175
  493185
  493193
  495226
  495227
  495820
  500806
  502813
  506055
  510518
  513495
  514301
  514441
  516480
  516485
  516712
  516787
  516829
  519604
  519735
  520916
  521133
  521391
  523018
  523031
  523837
  523848
  524357
  524779
  526010
  527658
  528826
  531685
  538005
  546937
  550221
  550224
  555158
  561597
  562990
  563142
  563423
  563432
  563436
  603678
  613286
  659197
  659986
  663772
  709458
  731073
  742839
  744184
  753515
  779576
  796202
  796203
  796205
]
1.93 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "son fuck russian"
]
1.67 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "son секс русск"
]
1.58 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.31 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "son секс русск"
]

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.