Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.95 ms
(86.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
  20429
  79082
  161342
  330478
  341596
  391596
  392325
  395450
  401540
  409861
  419804
  424333
  425866
  429799
  431741
  435399
  446394
  452289
  456710
  457584
  460364
  460736
  462955
  464168
  470596
  470692
  471406
  474975
  477439
  477549
  484407
  485488
  486706
  488483
  488585
  490785
  495260
  496303
  500156
  501028
  504047
  505129
  505243
  508019
  509222
  509842
  509862
  510641
  513771
  515891
  516714
  516991
  519367
  519563
  520894
  523591
  524853
  526385
  528867
  536618
  536865
  537173
  538514
  541774
  545763
  550823
  556839
  559178
  562028
  564367
  565905
  566228
  566415
  566688
  566812
  567725
  568305
  571664
  571670
  571823
  572320
  575716
  578435
  578512
  580518
  586912
  587185
  590515
  590535
  598680
  598897
  601339
  607705
  610766
  611571
  612265
  613836
  614408
  619082
  622953
  626311
  632551
  633491
  637094
  639786
  645706
  651907
  667985
  675104
  678569
  679072
  680020
  682252
  691196
  698821
  706658
  707844
  733886
  780406
  801519
]
17.33 ms
(8.58%)
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
  566688
  419804
  578435
  598897
  801519
  79082
  568305
  580518
  571670
  622953
  516991
  667985
  706658
  330478
  536865
  501028
  559178
  528867
  632551
  446394
  675104
  601339
  578512
  679072
  619082
  610766
  550823
  611571
  682252
  474975
  567725
  524853
  566228
  651907
  586912
  780406
  508019
  513771
  541774
  429799
  477549
  500156
  464168
  391596
  537173
  452289
  462955
  680020
  519563
  691196
  571664
  564367
  707844
  566812
  612265
  536618
  519367
  733886
  471406
  425866
  614408
  457584
  509222
  566415
  565905
  607705
  477439
  424333
  435399
  545763
  515891
  562028
  556839
  504047
  639786
  486706
  470596
  488483
  598680
  488585
  496303
  538514
  613836
  505243
  571823
  626311
  460736
  392325
  495260
  509842
  575716
  161342
  590515
  523591
  456710
  520894
  509862
  470692
  516714
  20429
  633491
  587185
  637094
  485488
  395450
  341596
  645706
  678569
  590535
  409861
  484407
  505129
  401540
  431741
  460364
  510641
  490785
  526385
  572320
  698821
]
2.41 ms
(1.19%)
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
  20429
  79082
  161342
  330478
  341596
  391596
  392325
  395450
  401540
  409861
  419804
  424333
  425866
  429799
  431741
  435399
  446394
  452289
  456710
  457584
  460364
  460736
  462955
  464168
  470596
  470692
  471406
  474975
  477439
  477549
  484407
  485488
  486706
  488483
  488585
  490785
  495260
  496303
  500156
  501028
  504047
  505129
  505243
  508019
  509222
  509842
  509862
  510641
  513771
  515891
  516714
  516991
  519367
  519563
  520894
  523591
  524853
  526385
  528867
  536618
  536865
  537173
  538514
  541774
  545763
  550823
  556839
  559178
  562028
  564367
  565905
  566228
  566415
  566688
  566812
  567725
  568305
  571664
  571670
  571823
  572320
  575716
  578435
  578512
  580518
  586912
  587185
  590515
  590535
  598680
  598897
  601339
  607705
  610766
  611571
  612265
  613836
  614408
  619082
  622953
  626311
  632551
  633491
  637094
  639786
  645706
  651907
  667985
  675104
  678569
  679072
  680020
  682252
  691196
  698821
  706658
  707844
  733886
  780406
  801519
]
2.25 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "два члена в письке"
]
1.77 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "два член в вагин"
]
1.76 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.80%)
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.