Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.14 ms
(57.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass cumshot"
]
131.82 ms
(36.27%)
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
  69956
  80900
  81214
  382073
  390827
  396066
  410884
  412136
  419253
  423384
  423606
  432618
  432702
  434429
  434767
  434848
  440390
  441708
  441845
  442107
  444672
  446999
  451074
  452812
  453268
  461757
  468239
  477850
  478111
  479656
  480829
  486036
  487443
  489894
  493751
  499964
  518146
  529137
  531100
  546582
  553256
  558865
  564994
  566305
  579547
  584112
  584476
  586268
  590402
  595314
  602862
  604144
  605055
  605283
  605871
  606604
  610163
  611006
  614842
  617953
  620224
  621433
  624194
  629585
  629593
  641318
  646942
  653245
  655159
  658793
  689028
  690250
  695319
  705729
  707175
  709672
  710941
  715563
  720443
  721869
  721885
  723716
  724102
  724103
  726052
  726232
  727972
  728369
  731111
  742072
  742356
  750247
  751252
  757576
  759599
  759747
  761680
  764280
  768078
  778288
  778931
  779558
  780125
  784220
  785789
  786778
  790389
  791101
  792050
  793830
  799164
  800611
  801322
  805259
  809898
  810352
  811076
  812596
  813987
  826181
]
14.08 ms
(3.87%)
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
  720443
  690250
  705729
  646942
  655159
  695319
  707175
  709672
  546582
  586268
  605871
  617953
  624194
  590402
  595314
  602862
  629593
  610163
  621433
  778288
  779558
  793830
  800611
  812596
  809898
  810352
  750247
  786778
  791101
  792050
  724103
  726052
  742072
  761680
  723716
  724102
  726232
  727972
  728369
  759747
  751252
  757576
  764280
  768078
  614842
  629585
  641318
  710941
  721885
  778931
  784220
  785789
  799164
  412136
  423606
  69956
  419253
  487443
  584112
  390827
  826181
  558865
  689028
  653245
  605283
  604144
  780125
  441845
  396066
  434848
  606604
  611006
  805259
  499964
  81214
  432702
  423384
  440390
  451074
  452812
  480829
  489894
  453268
  461757
  478111
  531100
  479656
  564994
  553256
  579547
  584476
  566305
  658793
  715563
  605055
  620224
  790389
  731111
  759599
  742356
  721869
  801322
  811076
  432618
  434767
  434429
  441708
  444672
  410884
  493751
  518146
  529137
  486036
  80900
  382073
  442107
  813987
  446999
  468239
  477850
]
3.44 ms
(0.95%)
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
  69956
  80900
  81214
  382073
  390827
  396066
  410884
  412136
  419253
  423384
  423606
  432618
  432702
  434429
  434767
  434848
  440390
  441708
  441845
  442107
  444672
  446999
  451074
  452812
  453268
  461757
  468239
  477850
  478111
  479656
  480829
  486036
  487443
  489894
  493751
  499964
  518146
  529137
  531100
  546582
  553256
  558865
  564994
  566305
  579547
  584112
  584476
  586268
  590402
  595314
  602862
  604144
  605055
  605283
  605871
  606604
  610163
  611006
  614842
  617953
  620224
  621433
  624194
  629585
  629593
  641318
  646942
  653245
  655159
  658793
  689028
  690250
  695319
  705729
  707175
  709672
  710941
  715563
  720443
  721869
  721885
  723716
  724102
  724103
  726052
  726232
  727972
  728369
  731111
  742072
  742356
  750247
  751252
  757576
  759599
  759747
  761680
  764280
  768078
  778288
  778931
  779558
  780125
  784220
  785789
  786778
  790389
  791101
  792050
  793830
  799164
  800611
  801322
  805259
  809898
  810352
  811076
  812596
  813987
  826181
]
1.78 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп cumshot"
]
1.45 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп cumshot"
]

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.