Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
114.86 ms
(79.93%)
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
  81734
  154972
  183074
  315244
  381812
  386421
  387026
  388722
  392019
  403225
  412814
  414090
  414094
  414104
  414337
  414342
  415855
  415878
  416032
  416583
  416611
  416649
  416659
  416682
  416694
  416696
  416751
  418989
  419613
  424606
  428179
  429799
  429909
  433288
  436937
  439031
  441120
  441157
  443317
  444531
  444548
  447668
  448791
  451336
  454000
  465132
  466476
  466636
  466639
  468946
  469735
  470479
  473366
  475780
  476054
  478437
  478463
  478488
  478993
  482283
  482773
  483737
  483738
  483745
  483762
  485154
  486831
  493398
  495737
  496337
  497691
  497695
  497697
  500333
  500335
  500338
  505386
  508895
  509833
  511455
  515419
  515488
  519699
  519712
  520788
  526504
  527915
  529739
  530659
  531103
  533461
  536590
  537904
  537913
  543860
  545455
  547468
  547470
  547847
  550203
  550890
  552800
  586407
  588014
  590803
  595761
  601604
  619659
  635993
  644918
  669025
  671052
  712555
  722384
  722392
  760938
  777044
  777051
  786874
  825878
]
18.48 ms
(12.86%)
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
  466476
  536590
  429799
  415855
  414342
  416694
  429909
  483737
  478463
  497695
  508895
  444548
  482283
  454000
  500335
  509833
  511455
  483745
  486831
  493398
  519699
  543860
  595761
  527915
  669025
  520788
  547847
  601604
  635993
  588014
  712555
  387026
  386421
  416751
  530659
  154972
  392019
  381812
  403225
  412814
  416611
  414090
  414104
  416659
  428179
  436937
  443317
  414094
  416649
  424606
  439031
  441157
  415878
  416682
  419613
  825878
  470479
  478488
  465132
  468946
  473366
  478437
  485154
  483738
  526504
  497691
  497697
  500333
  495737
  515419
  537904
  466636
  469735
  483762
  545455
  547470
  722384
  552800
  590803
  586407
  777051
  786874
  777044
  760938
  476054
  466639
  183074
  451336
  519712
  529739
  644918
  447668
  550890
  81734
  537913
  550203
  414337
  533461
  315244
  418989
  441120
  416583
  433288
  444531
  416696
  482773
  478993
  448791
  531103
  515488
  496337
  500338
  505386
  547468
  671052
  619659
  722392
  388722
  416032
  475780
]
2.38 ms
(1.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge anal hole"
]
2.29 ms
(1.59%)
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
  81734
  154972
  183074
  315244
  381812
  386421
  387026
  388722
  392019
  403225
  412814
  414090
  414094
  414104
  414337
  414342
  415855
  415878
  416032
  416583
  416611
  416649
  416659
  416682
  416694
  416696
  416751
  418989
  419613
  424606
  428179
  429799
  429909
  433288
  436937
  439031
  441120
  441157
  443317
  444531
  444548
  447668
  448791
  451336
  454000
  465132
  466476
  466636
  466639
  468946
  469735
  470479
  473366
  475780
  476054
  478437
  478463
  478488
  478993
  482283
  482773
  483737
  483738
  483745
  483762
  485154
  486831
  493398
  495737
  496337
  497691
  497695
  497697
  500333
  500335
  500338
  505386
  508895
  509833
  511455
  515419
  515488
  519699
  519712
  520788
  526504
  527915
  529739
  530659
  531103
  533461
  536590
  537904
  537913
  543860
  545455
  547468
  547470
  547847
  550203
  550890
  552800
  586407
  588014
  590803
  595761
  601604
  619659
  635993
  644918
  669025
  671052
  712555
  722384
  722392
  760938
  777044
  777051
  786874
  825878
]
2.02 ms
(1.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные анал дырк"
]
1.87 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.26%)
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.