Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.34 ms
(80.77%)
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
  389966
  390571
  395666
  406168
  416032
  419531
  420129
  425509
  428884
  433640
  441067
  443784
  444238
  452304
  452373
  454227
  454253
  455438
  458281
  463803
  466995
  467705
  473203
  473391
  474786
  474874
  483372
  483377
  483380
  490517
  494508
  500914
  503486
  504174
  505736
  508257
  509262
  509439
  509664
  513808
  516478
  517428
  517705
  517735
  517736
  518596
  519516
  520755
  523046
  523590
  523837
  529400
  532893
  538530
  541418
  541851
  542710
  544024
  550721
  550827
  554374
  556577
  557327
  558172
  561457
  561505
  562342
  565720
  566076
  569303
  571102
  576006
  582438
  582444
  584019
  584172
  586713
  588693
  592184
  592756
  592973
  592985
  593363
  593540
  594560
  595097
  598078
  598832
  602260
  603254
  604631
  605255
  607640
  607716
  618622
  618668
  618999
  622315
  628696
  632083
  634723
  634746
  639119
  660457
  662876
  663485
  667344
  681498
  726710
  726713
  731034
  731124
  741504
  741724
  742404
  752506
  760169
  760739
  760859
  796804
]
19.12 ms
(12.62%)
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
  452373
  454253
  467705
  490517
  500914
  494508
  503486
  505736
  517705
  520755
  508257
  509262
  517736
  529400
  517735
  532893
  557327
  576006
  584172
  542710
  550721
  550827
  561457
  562342
  566076
  582438
  584019
  660457
  662876
  663485
  667344
  681498
  554374
  592756
  592973
  592985
  593540
  598078
  622315
  605255
  607640
  618668
  618999
  639119
  594560
  598832
  603254
  628696
  634723
  592184
  595097
  607716
  731034
  742404
  760169
  760739
  796804
  741504
  726713
  760859
  726710
  741724
  752506
  602260
  604631
  632083
  428884
  466995
  455438
  458281
  406168
  419531
  474786
  416032
  483372
  483377
  523837
  473391
  731124
  473203
  389966
  444238
  443784
  425509
  519516
  569303
  571102
  541851
  556577
  593363
  618622
  588693
  634746
  390571
  474874
  483380
  441067
  538530
  541418
  509664
  518596
  509439
  516478
  504174
  586713
  433640
  395666
  420129
  454227
  463803
  452304
  517428
  523046
  523590
  513808
  558172
  561505
  565720
  582444
  544024
]
2.95 ms
(1.95%)
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
  389966
  390571
  395666
  406168
  416032
  419531
  420129
  425509
  428884
  433640
  441067
  443784
  444238
  452304
  452373
  454227
  454253
  455438
  458281
  463803
  466995
  467705
  473203
  473391
  474786
  474874
  483372
  483377
  483380
  490517
  494508
  500914
  503486
  504174
  505736
  508257
  509262
  509439
  509664
  513808
  516478
  517428
  517705
  517735
  517736
  518596
  519516
  520755
  523046
  523590
  523837
  529400
  532893
  538530
  541418
  541851
  542710
  544024
  550721
  550827
  554374
  556577
  557327
  558172
  561457
  561505
  562342
  565720
  566076
  569303
  571102
  576006
  582438
  582444
  584019
  584172
  586713
  588693
  592184
  592756
  592973
  592985
  593363
  593540
  594560
  595097
  598078
  598832
  602260
  603254
  604631
  605255
  607640
  607716
  618622
  618668
  618999
  622315
  628696
  632083
  634723
  634746
  639119
  660457
  662876
  663485
  667344
  681498
  726710
  726713
  731034
  731124
  741504
  741724
  742404
  752506
  760169
  760739
  760859
  796804
]
2.29 ms
(1.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð╝ð░ÐüÐéÐâÐÇð▒ð░Ðåð©ÐÅ ð┐ð¥ð╗ð¢ÐïðÁ ð▓ð%ÔǪ"
]
1.65 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац полная в"
]
1.55 ms
(1.02%)
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.