Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.18 ms
(86.89%)
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
  419096
  419312
  420462
  423846
  427843
  428497
  433920
  435724
  435806
  436765
  444939
  446510
  447722
  449466
  449475
  449545
  449556
  449998
  450013
  450715
  450829
  452184
  452299
  452754
  454452
  455978
  457559
  457901
  459942
  459966
  460809
  461034
  461193
  462281
  463053
  463471
  465708
  467970
  469780
  470767
  476623
  476841
  478213
  478238
  480162
  480334
  480508
  480697
  481167
  483786
  487636
  492462
  495002
  495356
  496747
  496750
  497748
  498550
  505298
  505526
  507287
  508226
  509594
  516537
  517337
  519536
  520040
  521041
  522037
  522782
  525985
  527595
  533200
  537814
  539445
  565027
  566205
  567525
  572266
  573165
  577458
  581232
  582563
  584482
  585936
  587876
  591958
  594219
  594460
  595244
  602072
  603786
  605683
  605702
  617106
  626245
  637965
  638727
  641387
  642162
  664223
  707617
  709300
  714300
  722931
  731609
  740577
  740787
  745605
  759690
  772035
  777003
  784976
  784981
  796248
  799052
  806823
  809876
  812842
  814272
]
16.46 ms
(7.98%)
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
  480334
  709300
  714300
  435724
  480508
  436765
  419312
  814272
  452754
  487636
  449545
  496750
  602072
  784976
  784981
  812842
  423846
  462281
  480697
  444939
  459942
  459966
  603786
  740787
  731609
  740577
  806823
  463053
  519536
  521041
  509594
  772035
  591958
  605683
  594219
  617106
  577458
  454452
  642162
  585936
  777003
  463471
  450715
  467970
  495356
  587876
  707617
  435806
  419096
  427843
  498550
  483786
  497748
  594460
  799052
  626245
  637965
  641387
  461034
  449466
  505298
  508226
  572266
  573165
  565027
  595244
  449998
  455978
  461193
  469780
  420462
  452184
  584482
  470767
  476623
  480162
  745605
  759690
  495002
  796248
  517337
  664223
  449475
  505526
  537814
  539445
  449556
  582563
  507287
  516537
  605702
  452299
  481167
  433920
  522037
  525985
  527595
  450829
  478213
  457901
  450013
  465708
  522782
  496747
  460809
  476841
  478238
  520040
  809876
  428497
  446510
  492462
  533200
  566205
  638727
  722931
  447722
  457559
  581232
  567525
]
3.16 ms
(1.53%)
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
  419096
  419312
  420462
  423846
  427843
  428497
  433920
  435724
  435806
  436765
  444939
  446510
  447722
  449466
  449475
  449545
  449556
  449998
  450013
  450715
  450829
  452184
  452299
  452754
  454452
  455978
  457559
  457901
  459942
  459966
  460809
  461034
  461193
  462281
  463053
  463471
  465708
  467970
  469780
  470767
  476623
  476841
  478213
  478238
  480162
  480334
  480508
  480697
  481167
  483786
  487636
  492462
  495002
  495356
  496747
  496750
  497748
  498550
  505298
  505526
  507287
  508226
  509594
  516537
  517337
  519536
  520040
  521041
  522037
  522782
  525985
  527595
  533200
  537814
  539445
  565027
  566205
  567525
  572266
  573165
  577458
  581232
  582563
  584482
  585936
  587876
  591958
  594219
  594460
  595244
  602072
  603786
  605683
  605702
  617106
  626245
  637965
  638727
  641387
  642162
  664223
  707617
  709300
  714300
  722931
  731609
  740577
  740787
  745605
  759690
  772035
  777003
  784976
  784981
  796248
  799052
  806823
  809876
  812842
  814272
]
1.97 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов любительск cowgirl"
]
1.87 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov amateur cowgirl"
]
1.68 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов любительск cowgirl"
]

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.