Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.62 ms
(84.18%)
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
  392624
  419361
  463661
  481120
  487666
  507285
  513558
  522749
  531383
  541061
  543592
  544580
  545062
  554208
  555992
  558491
  568917
  571437
  577396
  583744
  585737
  588021
  603280
  614693
  618407
  619320
  629695
  630880
  635402
  637081
  641764
  643472
  644447
  645006
  650691
  653117
  672824
  689951
  703749
  710939
  715349
  715604
  716967
  718603
  718629
  720345
  722162
  723957
  724903
  725060
  725088
  725204
  725410
  728947
  729045
  730119
  734595
  735984
  737807
  738560
  739240
  744056
  746321
  746440
  746745
  746777
  747990
  747994
  748107
  750635
  752945
  753153
  758620
  762580
  765396
  768382
  768651
  775644
  780217
  781009
  781111
  781113
  782642
  782686
  785668
  786708
  787414
  787669
  787740
  789554
  791596
  791631
  791657
  791795
  792167
  792499
  793321
  795346
  795789
  795860
  796218
  796701
  797214
  797380
  800972
  801354
  801456
  802067
  808254
  813193
  813410
  817187
  819734
  819758
  819922
  824091
  824775
  825871
  826263
  826580
]
13.30 ms
(9.05%)
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
  558491
  637081
  618407
  629695
  643472
  603280
  630880
  781009
  782642
  796218
  775644
  780217
  785668
  786708
  787414
  787740
  795789
  795860
  796701
  801456
  808254
  725060
  725088
  746321
  746745
  750635
  789554
  800972
  725204
  728947
  735984
  737807
  747990
  747994
  768651
  723957
  725410
  729045
  739240
  758620
  765396
  738560
  746777
  768382
  730119
  744056
  703749
  718603
  718629
  781111
  791795
  792499
  793321
  797214
  797380
  813193
  571437
  689951
  715349
  635402
  753153
  791657
  724903
  734595
  748107
  644447
  716967
  481120
  419361
  645006
  555992
  543592
  577396
  585737
  614693
  802067
  641764
  463661
  513558
  392624
  826580
  817187
  819734
  819758
  824091
  826263
  819922
  824775
  522749
  531383
  568917
  541061
  554208
  545062
  583744
  653117
  720345
  722162
  792167
  801354
  781113
  791596
  795346
  813410
  752945
  782686
  746440
  619320
  588021
  487666
  825871
  507285
  544580
  672824
  650691
  710939
  715604
  787669
  791631
  762580
]
2.68 ms
(1.83%)
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
  392624
  419361
  463661
  481120
  487666
  507285
  513558
  522749
  531383
  541061
  543592
  544580
  545062
  554208
  555992
  558491
  568917
  571437
  577396
  583744
  585737
  588021
  603280
  614693
  618407
  619320
  629695
  630880
  635402
  637081
  641764
  643472
  644447
  645006
  650691
  653117
  672824
  689951
  703749
  710939
  715349
  715604
  716967
  718603
  718629
  720345
  722162
  723957
  724903
  725060
  725088
  725204
  725410
  728947
  729045
  730119
  734595
  735984
  737807
  738560
  739240
  744056
  746321
  746440
  746745
  746777
  747990
  747994
  748107
  750635
  752945
  753153
  758620
  762580
  765396
  768382
  768651
  775644
  780217
  781009
  781111
  781113
  782642
  782686
  785668
  786708
  787414
  787669
  787740
  789554
  791596
  791631
  791657
  791795
  792167
  792499
  793321
  795346
  795789
  795860
  796218
  796701
  797214
  797380
  800972
  801354
  801456
  802067
  808254
  813193
  813410
  817187
  819734
  819758
  819922
  824091
  824775
  825871
  826263
  826580
]
2.11 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "vagina cum"
]
1.82 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вагин cum"
]
1.71 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вагин cum"
]

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.