Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.18 ms
(82.21%)
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
  352142
  398095
  402626
  410690
  411025
  411459
  415758
  416621
  416703
  416715
  416718
  416751
  418077
  419567
  419613
  421488
  426515
  427007
  428253
  429907
  435373
  435551
  439218
  439244
  439268
  439274
  440993
  441733
  442566
  443106
  443464
  444513
  444922
  445468
  445470
  446515
  448954
  449079
  449404
  450572
  450599
  450697
  451138
  452633
  452850
  452950
  454808
  456233
  456238
  456608
  457480
  458271
  459170
  462378
  462849
  465144
  466474
  467715
  467886
  468661
  470137
  471660
  477125
  480008
  481861
  482731
  483762
  485031
  485546
  492165
  496776
  497482
  498641
  500292
  502287
  504670
  510170
  513379
  513846
  516568
  518671
  523357
  524676
  524754
  532727
  547237
  547484
  555119
  563703
  569633
  577961
  584391
  584886
  590655
  623369
  648761
  657178
  657191
  657217
  667087
  674307
  701192
  734401
  736321
  742636
  749322
  758779
  764867
  765807
  769052
  771178
  778389
  782782
  786876
  791594
  804909
  805495
  809642
  827531
]
15.25 ms
(10.43%)
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
  439218
  450697
  804909
  809642
  411459
  701192
  504670
  674307
  444513
  492165
  470137
  444922
  445468
  481861
  452850
  482731
  547484
  445470
  439268
  454808
  398095
  657178
  771178
  440993
  577961
  524754
  416751
  518671
  452950
  402626
  416715
  410690
  523357
  547237
  595376
  758779
  765807
  439244
  450599
  497482
  782782
  443106
  429907
  428253
  419613
  441733
  449079
  456608
  458271
  457480
  462378
  485031
  502287
  510170
  516568
  483762
  465144
  418077
  427007
  456238
  439274
  498641
  584391
  590655
  827531
  532727
  791594
  736321
  742636
  764867
  769052
  480008
  459170
  468661
  584886
  416621
  426515
  471660
  451138
  446515
  449404
  452633
  555119
  648761
  467886
  466474
  421488
  500292
  513846
  513379
  485546
  805495
  442566
  496776
  623369
  448954
  477125
  563703
  462849
  467715
  657217
  667087
  569633
  778389
  749322
  657191
  352142
  435551
  416718
  419567
  456233
  786876
  435373
  411025
  450572
  734401
  416703
  443464
  415758
  524676
]
2.73 ms
(1.86%)
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
  352142
  398095
  402626
  410690
  411025
  411459
  415758
  416621
  416703
  416715
  416718
  416751
  418077
  419567
  419613
  421488
  426515
  427007
  428253
  429907
  435373
  435551
  439218
  439244
  439268
  439274
  440993
  441733
  442566
  443106
  443464
  444513
  444922
  445468
  445470
  446515
  448954
  449079
  449404
  450572
  450599
  450697
  451138
  452633
  452850
  452950
  454808
  456233
  456238
  456608
  457480
  458271
  459170
  462378
  462849
  465144
  466474
  467715
  467886
  468661
  470137
  471660
  477125
  480008
  481861
  482731
  483762
  485031
  485546
  492165
  496776
  497482
  498641
  500292
  502287
  504670
  510170
  513379
  513846
  516568
  518671
  523357
  524676
  524754
  532727
  547237
  547484
  555119
  563703
  569633
  577961
  584391
  584886
  590655
  623369
  648761
  657178
  657191
  657217
  667087
  674307
  701192
  734401
  736321
  742636
  749322
  758779
  764867
  765807
  769052
  771178
  778389
  782782
  786876
  791594
  804909
  805495
  809642
  827531
]
2.25 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашнее игрушка анал…"
]
2.05 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск игрушк анал"
]
1.97 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.20%)
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.