Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.61 ms
(86.95%)
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
  251363
  383911
  385316
  385483
  387301
  392825
  394409
  396154
  403928
  416695
  419953
  420481
  421002
  428381
  430333
  435865
  437854
  437925
  438857
  444650
  445533
  452675
  453528
  456380
  456511
  459685
  461802
  462338
  465202
  466985
  468321
  468919
  469031
  469045
  469592
  469817
  469847
  469848
  472327
  475422
  477864
  479713
  482929
  483483
  485294
  488322
  489822
  491381
  491490
  493339
  497887
  498888
  500565
  500679
  501267
  504660
  506117
  508760
  511648
  512563
  517616
  517854
  522263
  526197
  528684
  529708
  531075
  531701
  531782
  533305
  545526
  548623
  550236
  551183
  554213
  555636
  557625
  559660
  562209
  566527
  566624
  569913
  573655
  574646
  576115
  578461
  581691
  581938
  587079
  591544
  593669
  599028
  604794
  610813
  612854
  616515
  618461
  622472
  624982
  628558
  633147
  641095
  668790
  675866
  677516
  708348
  735511
  735647
  744251
  752790
  755743
  767086
  770228
  784664
  787774
  796950
  797023
  801545
  804862
  807048
]
10.92 ms
(7.50%)
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
  511648
  554213
  599028
  622472
  452675
  559660
  618461
  437854
  453528
  469031
  500679
  466985
  616515
  735511
  610813
  420481
  612854
  628558
  796950
  555636
  468321
  468919
  461802
  587079
  392825
  456511
  517854
  675866
  562209
  529708
  528684
  419953
  483483
  489822
  396154
  581691
  438857
  475422
  506117
  573655
  581938
  752790
  469817
  744251
  493339
  784664
  500565
  533305
  550236
  383911
  501267
  633147
  497887
  531782
  574646
  604794
  807048
  801545
  770228
  469592
  469045
  767086
  557625
  469847
  462338
  435865
  465202
  508760
  488322
  566624
  569913
  804862
  576115
  797023
  477864
  591544
  531075
  512563
  403928
  491490
  578461
  755743
  385316
  428381
  735647
  485294
  504660
  624982
  387301
  522263
  548623
  593669
  394409
  641095
  456380
  677516
  421002
  668790
  385483
  251363
  472327
  491381
  517616
  526197
  787774
  498888
  545526
  444650
  437925
  416695
  566527
  479713
  708348
  459685
  482929
  430333
  551183
  469848
  531701
  445533
]
2.24 ms
(1.54%)
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
  251363
  383911
  385316
  385483
  387301
  392825
  394409
  396154
  403928
  416695
  419953
  420481
  421002
  428381
  430333
  435865
  437854
  437925
  438857
  444650
  445533
  452675
  453528
  456380
  456511
  459685
  461802
  462338
  465202
  466985
  468321
  468919
  469031
  469045
  469592
  469817
  469847
  469848
  472327
  475422
  477864
  479713
  482929
  483483
  485294
  488322
  489822
  491381
  491490
  493339
  497887
  498888
  500565
  500679
  501267
  504660
  506117
  508760
  511648
  512563
  517616
  517854
  522263
  526197
  528684
  529708
  531075
  531701
  531782
  533305
  545526
  548623
  550236
  551183
  554213
  555636
  557625
  559660
  562209
  566527
  566624
  569913
  573655
  574646
  576115
  578461
  581691
  581938
  587079
  591544
  593669
  599028
  604794
  610813
  612854
  616515
  618461
  622472
  624982
  628558
  633147
  641095
  668790
  675866
  677516
  708348
  735511
  735647
  744251
  752790
  755743
  767086
  770228
  784664
  787774
  796950
  797023
  801545
  804862
  807048
]
1.73 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "девушки сексом"
]
1.41 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк секс"
]
1.29 ms
(0.89%)
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.