Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.79 ms
(83.36%)
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
  45799
  188335
  365865
  390508
  391917
  391992
  397167
  416121
  417332
  417789
  419319
  420300
  421795
  424118
  424124
  424547
  424765
  427260
  428610
  432438
  440755
  442070
  444145
  444185
  446947
  450287
  452810
  453323
  453334
  453547
  453571
  453578
  453719
  454456
  454461
  454958
  456030
  457587
  458768
  460368
  461902
  462707
  463152
  467016
  472403
  472673
  473376
  473384
  479107
  479261
  481167
  481747
  483361
  484181
  485386
  491860
  492005
  493177
  496512
  498441
  500976
  505833
  510334
  511631
  515617
  518975
  519751
  520114
  524803
  524991
  525717
  529166
  531566
  533583
  533953
  536430
  541850
  543404
  544109
  549689
  549727
  549737
  557605
  558755
  561506
  562469
  565632
  566361
  567211
  573196
  575339
  578829
  581013
  582262
  590666
  591928
  595097
  595270
  595288
  595328
  607576
  618668
  623412
  625275
  630142
  638380
  650664
  662879
  664241
  668807
  690882
  712828
  724481
  726550
  733044
  733579
  735855
  741687
  748383
  758803
]
18.76 ms
(10.66%)
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
  607576
  630142
  421795
  424118
  462707
  467016
  479261
  452810
  472403
  440755
  454461
  473376
  424124
  481747
  510334
  520114
  484181
  519751
  496512
  524991
  536430
  453571
  549737
  575339
  595328
  595097
  733579
  735855
  188335
  454958
  543404
  544109
  573196
  690882
  566361
  590666
  625275
  456030
  533583
  733044
  365865
  578829
  638380
  500976
  391917
  397167
  428610
  432438
  442070
  417789
  420300
  424547
  424765
  450287
  453323
  453719
  461902
  473384
  491860
  492005
  453334
  505833
  531566
  524803
  518975
  529166
  460368
  549689
  549727
  558755
  561506
  565632
  581013
  582262
  541850
  557605
  650664
  664241
  668807
  562469
  595270
  595288
  591928
  618668
  758803
  741687
  724481
  726550
  748383
  623412
  472673
  479107
  391992
  453578
  457587
  481167
  417332
  444145
  416121
  485386
  498441
  525717
  483361
  493177
  515617
  444185
  427260
  533953
  511631
  567211
  463152
  446947
  454456
  45799
  390508
  712828
  662879
  419319
  453547
  458768
]
3.11 ms
(1.76%)
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
  45799
  188335
  365865
  390508
  391917
  391992
  397167
  416121
  417332
  417789
  419319
  420300
  421795
  424118
  424124
  424547
  424765
  427260
  428610
  432438
  440755
  442070
  444145
  444185
  446947
  450287
  452810
  453323
  453334
  453547
  453571
  453578
  453719
  454456
  454461
  454958
  456030
  457587
  458768
  460368
  461902
  462707
  463152
  467016
  472403
  472673
  473376
  473384
  479107
  479261
  481167
  481747
  483361
  484181
  485386
  491860
  492005
  493177
  496512
  498441
  500976
  505833
  510334
  511631
  515617
  518975
  519751
  520114
  524803
  524991
  525717
  529166
  531566
  533583
  533953
  536430
  541850
  543404
  544109
  549689
  549727
  549737
  557605
  558755
  561506
  562469
  565632
  566361
  567211
  573196
  575339
  578829
  581013
  582262
  590666
  591928
  595097
  595270
  595288
  595328
  607576
  618668
  623412
  625275
  630142
  638380
  650664
  662879
  664241
  668807
  690882
  712828
  724481
  726550
  733044
  733579
  735855
  741687
  748383
  758803
]
1.98 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby жен riding"
]
1.88 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby wife riding"
]
1.64 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby жен riding"
]

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.