Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.14 ms
(89.86%)
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
  1117
  382069
  384774
  385004
  387007
  390990
  392033
  396594
  397290
  399554
  399887
  401780
  405858
  410255
  418297
  419103
  420403
  420775
  423305
  425290
  426431
  428380
  444987
  445702
  454794
  460005
  466483
  473994
  475503
  487162
  495928
  504913
  506144
  516611
  529508
  531357
  533415
  533419
  533574
  533975
  543160
  551002
  554934
  555753
  560037
  567805
  571023
  571466
  572314
  572387
  579464
  585524
  588173
  590619
  595712
  614917
  623107
  629092
  630144
  642559
  654058
  654535
  654714
  655980
  658387
  660089
  663240
  663356
  664243
  674635
  678187
  679228
  679681
  682916
  692601
  697649
  701651
  702732
  721420
  722791
  723698
  739248
  743633
  745374
  751138
  757773
  761284
  764548
  764719
  766101
  767555
  773533
  777132
  779049
  779484
  780050
  780221
  780248
  780742
  782011
  783017
  783557
  784470
  788386
  788442
  791755
  792111
  793379
  793956
  798343
  809146
  809305
  810511
  813600
  814325
  817124
  821414
  821556
  821830
  823046
]
13.89 ms
(5.94%)
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
  533419
  506144
  678187
  679228
  595712
  588173
  783017
  809146
  701651
  420403
  418297
  475503
  495928
  529508
  428380
  757773
  397290
  723698
  722791
  721420
  572387
  572314
  444987
  454794
  487162
  387007
  445702
  405858
  419103
  420775
  516611
  533415
  531357
  554934
  702732
  660089
  663240
  692601
  585524
  590619
  623107
  780050
  792111
  793379
  809305
  810511
  780221
  780248
  780742
  783557
  793956
  739248
  745374
  761284
  788386
  798343
  743633
  766101
  764548
  764719
  614917
  779049
  782011
  784470
  399887
  423305
  460005
  425290
  504913
  382069
  1117
  779484
  773533
  384774
  426431
  630144
  767555
  396594
  821556
  571466
  655980
  629092
  777132
  751138
  791755
  390990
  571023
  401780
  399554
  533574
  567805
  679681
  697649
  682916
  642559
  788442
  410255
  473994
  466483
  385004
  392033
  813600
  817124
  821830
  823046
  814325
  821414
  533975
  543160
  551002
  560037
  555753
  579464
  654058
  654535
  658387
  654714
  663356
  664243
  674635
]
2.98 ms
(1.27%)
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
  1117
  382069
  384774
  385004
  387007
  390990
  392033
  396594
  397290
  399554
  399887
  401780
  405858
  410255
  418297
  419103
  420403
  420775
  423305
  425290
  426431
  428380
  444987
  445702
  454794
  460005
  466483
  473994
  475503
  487162
  495928
  504913
  506144
  516611
  529508
  531357
  533415
  533419
  533574
  533975
  543160
  551002
  554934
  555753
  560037
  567805
  571023
  571466
  572314
  572387
  579464
  585524
  588173
  590619
  595712
  614917
  623107
  629092
  630144
  642559
  654058
  654535
  654714
  655980
  658387
  660089
  663240
  663356
  664243
  674635
  678187
  679228
  679681
  682916
  692601
  697649
  701651
  702732
  721420
  722791
  723698
  739248
  743633
  745374
  751138
  757773
  761284
  764548
  764719
  766101
  767555
  773533
  777132
  779049
  779484
  780050
  780221
  780248
  780742
  782011
  783017
  783557
  784470
  788386
  788442
  791755
  792111
  793379
  793956
  798343
  809146
  809305
  810511
  813600
  814325
  817124
  821414
  821556
  821830
  823046
]
1.94 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодой девушк минет оральн секс"
]
1.78 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "молодой девушка минет…"
]
1.67 ms
(0.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.