Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.66 ms
(83.81%)
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
  81022
  385411
  391492
  391668
  391705
  397861
  400481
  400722
  400816
  412827
  421820
  421828
  421857
  422185
  422207
  423802
  423947
  424234
  424434
  428039
  433614
  439437
  439572
  439717
  439802
  440979
  443913
  443920
  447981
  449094
  450684
  451495
  454508
  456701
  459514
  460581
  461814
  462386
  462605
  462705
  466227
  466847
  467628
  467781
  468343
  470147
  470621
  470674
  470686
  475127
  475319
  480013
  481383
  482045
  483602
  483656
  485596
  485646
  485945
  486046
  486365
  487246
  491125
  493681
  499997
  501984
  502718
  503442
  503450
  504509
  504665
  508382
  508869
  509192
  516668
  521121
  525695
  526456
  526792
  530289
  533659
  537963
  543745
  543985
  544524
  546649
  555046
  578348
  579079
  581126
  590539
  599153
  699976
  710204
  716090
  726843
  726887
  731652
  733661
  738000
  749900
  759088
  761607
  762113
  762274
  764142
  769131
  778215
  782122
  791883
  794763
  794886
  795359
  802160
  803145
  805666
  809645
  827432
  828555
]
14.29 ms
(9.24%)
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
  485945
  543985
  443920
  412827
  421857
  508382
  782122
  385411
  769131
  764595
  462605
  439717
  428039
  461814
  503442
  485646
  449094
  526456
  749900
  733661
  440979
  400816
  483656
  795359
  475127
  468343
  391668
  726843
  726887
  805666
  599153
  530289
  462705
  421828
  450684
  503450
  502718
  738000
  509192
  487246
  581126
  486046
  424234
  456701
  501984
  439572
  486365
  525695
  544524
  433614
  537963
  462386
  423802
  493681
  422207
  764142
  491125
  716090
  762113
  439437
  470686
  499997
  778215
  424434
  470674
  508869
  81022
  391705
  481383
  400481
  504665
  526792
  467628
  482045
  791883
  400722
  397861
  555046
  454508
  521121
  422185
  466227
  391492
  543745
  475319
  483602
  466847
  421820
  470621
  699976
  439802
  504509
  443913
  759088
  470147
  590539
  480013
  546649
  578348
  731652
  809645
  761607
  533659
  579079
  516668
  827432
  762274
  467781
  460581
  451495
  447981
  485596
  459514
  828555
  710204
  794886
  802160
  794763
  803145
  423947
]
3.98 ms
(2.57%)
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
  81022
  385411
  391492
  391668
  391705
  397861
  400481
  400722
  400816
  412827
  421820
  421828
  421857
  422185
  422207
  423802
  423947
  424234
  424434
  428039
  433614
  439437
  439572
  439717
  439802
  440979
  443913
  443920
  447981
  449094
  450684
  451495
  454508
  456701
  459514
  460581
  461814
  462386
  462605
  462705
  466227
  466847
  467628
  467781
  468343
  470147
  470621
  470674
  470686
  475127
  475319
  480013
  481383
  482045
  483602
  483656
  485596
  485646
  485945
  486046
  486365
  487246
  491125
  493681
  499997
  501984
  502718
  503442
  503450
  504509
  504665
  508382
  508869
  509192
  516668
  521121
  525695
  526456
  526792
  530289
  533659
  537963
  543745
  543985
  544524
  546649
  555046
  578348
  579079
  581126
  590539
  599153
  699976
  710204
  716090
  726843
  726887
  731652
  733661
  738000
  749900
  759088
  761607
  762113
  762274
  764142
  769131
  778215
  782122
  791883
  794763
  794886
  795359
  802160
  803145
  805666
  809645
  827432
  828555
]
1.98 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мамы русское реальное…"
]
1.87 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин русск любительск"
]
1.37 ms
(0.89%)
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.