Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.62 ms
(82.94%)
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
  426510
  460860
  464727
  469195
  497667
  540055
  540104
  540117
  540120
  540129
  542722
  547805
  548895
  550196
  550199
  550205
  553273
  554998
  555055
  555224
  555601
  555772
  555784
  556000
  558264
  568375
  570179
  570941
  571708
  576652
  580868
  583913
  584950
  585143
  590226
  597224
  597873
  600008
  600017
  600360
  604645
  606071
  607236
  612904
  614346
  617414
  618378
  633502
  634218
  635275
  637413
  637741
  639027
  639334
  639774
  639802
  640156
  647885
  647893
  647948
  647995
  648891
  649583
  650817
  661295
  664602
  666892
  666906
  668555
  674983
  675019
  678032
  683045
  691821
  710480
  714551
  715444
  716765
  716878
  718576
  718745
  726624
  727534
  729236
  729251
  729253
  734360
  736462
  739618
  745865
  749340
  751567
  757050
  758259
  758292
  765517
  775958
  781488
  789438
  795943
  795952
  800726
  801084
  801530
  801701
  801776
  801819
  801823
  804416
  811905
  813797
  817881
  818573
  824485
  826098
  826209
  826322
  826408
  827188
  827490
]
15.56 ms
(10.52%)
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
  604645
  614346
  597224
  555055
  571708
  765517
  647893
  585143
  555784
  554998
  666906
  674983
  647948
  639334
  639774
  817881
  540120
  736462
  826098
  612904
  824485
  801701
  801819
  426510
  584950
  547805
  716765
  649583
  718576
  607236
  749340
  469195
  751567
  600360
  827188
  729253
  556000
  570179
  647995
  650817
  729251
  497667
  540055
  540104
  540117
  568375
  590226
  801823
  464727
  804416
  813797
  801776
  826209
  800726
  633502
  637413
  734360
  460860
  550199
  576652
  668555
  678032
  600008
  597873
  617414
  583913
  715444
  600017
  827490
  826408
  555224
  548895
  555772
  606071
  795952
  781488
  801530
  795943
  801084
  739618
  634218
  550196
  637741
  727534
  664602
  710480
  553273
  550205
  647885
  675019
  639802
  639027
  775958
  818573
  540129
  555601
  542722
  691821
  661295
  570941
  757050
  789438
  729236
  745865
  726624
  758259
  714551
  718745
  635275
  716878
  758292
  640156
  811905
  666892
  618378
  826322
  558264
  580868
  683045
  648891
]
2.80 ms
(1.90%)
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
  426510
  460860
  464727
  469195
  497667
  540055
  540104
  540117
  540120
  540129
  542722
  547805
  548895
  550196
  550199
  550205
  553273
  554998
  555055
  555224
  555601
  555772
  555784
  556000
  558264
  568375
  570179
  570941
  571708
  576652
  580868
  583913
  584950
  585143
  590226
  597224
  597873
  600008
  600017
  600360
  604645
  606071
  607236
  612904
  614346
  617414
  618378
  633502
  634218
  635275
  637413
  637741
  639027
  639334
  639774
  639802
  640156
  647885
  647893
  647948
  647995
  648891
  649583
  650817
  661295
  664602
  666892
  666906
  668555
  674983
  675019
  678032
  683045
  691821
  710480
  714551
  715444
  716765
  716878
  718576
  718745
  726624
  727534
  729236
  729251
  729253
  734360
  736462
  739618
  745865
  749340
  751567
  757050
  758259
  758292
  765517
  775958
  781488
  789438
  795943
  795952
  800726
  801084
  801530
  801701
  801776
  801819
  801823
  804416
  811905
  813797
  817881
  818573
  824485
  826098
  826209
  826322
  826408
  827188
  827490
]
2.04 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss milf ass"
]
1.64 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг milf жоп"
]
1.61 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "писсинг milf жоп"
]
1.58 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.