Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.69 ms
(80.28%)
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
  373905
  390089
  393734
  394045
  394804
  395839
  397256
  397780
  399691
  399889
  401071
  403294
  404318
  404831
  406592
  408196
  411608
  413738
  415148
  415568
  419740
  425472
  425838
  428653
  430573
  431015
  445661
  449425
  449609
  450965
  457387
  458908
  460631
  462817
  463989
  464388
  465080
  465106
  472517
  476810
  482231
  482677
  484298
  485178
  485885
  490584
  491673
  492511
  496586
  498097
  517007
  517846
  520801
  526457
  527059
  527368
  527372
  527373
  527383
  527389
  528767
  530886
  534224
  535700
  536886
  553064
  553071
  559139
  562904
  573406
  579434
  583542
  586678
  596113
  600987
  607012
  623677
  624218
  642725
  656515
  660389
  674688
  681893
  694929
  721627
  722099
  732990
  737278
  738203
  738281
  738493
  746021
  759146
  760127
  760576
  770514
  788816
  790309
  804152
  814910
  815054
  815287
  815778
  816935
  817669
  819150
  820346
  820394
  820420
  820953
  821068
  821120
  821201
  821473
  821527
  821598
  822272
  823417
  823425
  826117
]
18.97 ms
(12.83%)
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
  404318
  600987
  415148
  428653
  462817
  464388
  562904
  397256
  373905
  394045
  390089
  397780
  404831
  430573
  826117
  814910
  815287
  821120
  821527
  819150
  463989
  485178
  498097
  496586
  553064
  660389
  674688
  681893
  656515
  694929
  721627
  722099
  596113
  642725
  586678
  607012
  623677
  790309
  737278
  738493
  788816
  804152
  738203
  738281
  759146
  732990
  746021
  760127
  760576
  770514
  624218
  401071
  413738
  517846
  411608
  445661
  450965
  492511
  465080
  553071
  458908
  476810
  425472
  472517
  403294
  431015
  527059
  520801
  484298
  491673
  419740
  449425
  406592
  415568
  393734
  394804
  395839
  399889
  399691
  408196
  425838
  820420
  821598
  815778
  820953
  821201
  815054
  816935
  820346
  820394
  821068
  823417
  817669
  821473
  822272
  823425
  449609
  490584
  482677
  457387
  460631
  482231
  527372
  527373
  527389
  534224
  527368
  536886
  517007
  526457
  527383
  528767
  530886
  535700
  465106
  485885
  559139
  573406
  579434
  583542
]
2.36 ms
(1.60%)
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
  373905
  390089
  393734
  394045
  394804
  395839
  397256
  397780
  399691
  399889
  401071
  403294
  404318
  404831
  406592
  408196
  411608
  413738
  415148
  415568
  419740
  425472
  425838
  428653
  430573
  431015
  445661
  449425
  449609
  450965
  457387
  458908
  460631
  462817
  463989
  464388
  465080
  465106
  472517
  476810
  482231
  482677
  484298
  485178
  485885
  490584
  491673
  492511
  496586
  498097
  517007
  517846
  520801
  526457
  527059
  527368
  527372
  527373
  527383
  527389
  528767
  530886
  534224
  535700
  536886
  553064
  553071
  559139
  562904
  573406
  579434
  583542
  586678
  596113
  600987
  607012
  623677
  624218
  642725
  656515
  660389
  674688
  681893
  694929
  721627
  722099
  732990
  737278
  738203
  738281
  738493
  746021
  759146
  760127
  760576
  770514
  788816
  790309
  804152
  814910
  815054
  815287
  815778
  816935
  817669
  819150
  820346
  820394
  820420
  820953
  821068
  821120
  821201
  821473
  821527
  821598
  822272
  823417
  823425
  826117
]
2.25 ms
(1.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.09 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy latina"
]
1.83 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая латинская"
]
1.65 ms
(1.12%)
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.