Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.19 ms
(84.07%)
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
  366036
  388180
  391187
  391527
  411374
  412533
  421600
  423837
  423936
  424011
  424107
  426784
  426886
  427147
  427148
  428651
  429696
  435528
  435698
  435883
  438459
  439281
  439285
  440217
  442155
  443248
  450520
  452425
  454078
  455119
  459622
  462131
  462143
  470023
  470195
  471333
  474206
  474214
  477137
  481226
  483854
  485294
  486857
  486933
  487299
  489378
  491149
  492959
  494598
  501130
  502559
  503099
  503706
  509298
  513667
  521202
  523606
  523687
  523695
  524402
  526747
  531745
  543546
  546986
  557896
  558919
  559811
  574076
  599245
  599985
  600272
  602048
  630453
  637727
  648664
  664181
  668700
  685742
  689207
  694102
  701963
  706442
  715965
  717095
  720113
  722924
  734251
  740561
  740852
  744952
  744953
  751680
  754577
  754915
  754921
  766174
  768431
  773654
  774146
  774824
  777677
  778037
  779641
  781381
  782466
  783247
  786601
  786770
  790730
  800143
  801430
  808507
  811142
  811441
  812039
  812060
  813587
  813626
  814449
  826233
]
13.83 ms
(9.21%)
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
  777677
  813626
  814449
  826233
  509298
  531745
  543546
  559811
  715965
  722924
  694102
  648664
  689207
  701963
  717095
  600272
  602048
  630453
  599985
  786601
  786770
  808507
  811142
  812039
  781381
  782466
  783247
  811441
  740852
  766174
  800143
  754915
  744953
  751680
  754921
  773654
  768431
  774146
  740561
  754577
  637727
  720113
  774824
  778037
  812060
  366036
  426784
  424011
  423837
  435528
  424107
  513667
  501130
  477137
  546986
  557896
  574076
  599245
  426886
  435698
  438459
  439281
  459622
  462131
  462143
  470195
  412533
  428651
  440217
  443248
  388180
  391187
  411374
  421600
  429696
  435883
  439285
  450520
  455119
  470023
  474214
  423936
  442155
  454078
  481226
  427147
  452425
  503099
  523687
  523695
  524402
  526747
  483854
  485294
  486933
  487299
  489378
  503706
  486857
  491149
  521202
  523606
  502559
  391527
  494598
  427148
  813587
  474206
  471333
  492959
  558919
  668700
  706442
  685742
  664181
  779641
  801430
  734251
  744952
  790730
]
3.20 ms
(2.13%)
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
  366036
  388180
  391187
  391527
  411374
  412533
  421600
  423837
  423936
  424011
  424107
  426784
  426886
  427147
  427148
  428651
  429696
  435528
  435698
  435883
  438459
  439281
  439285
  440217
  442155
  443248
  450520
  452425
  454078
  455119
  459622
  462131
  462143
  470023
  470195
  471333
  474206
  474214
  477137
  481226
  483854
  485294
  486857
  486933
  487299
  489378
  491149
  492959
  494598
  501130
  502559
  503099
  503706
  509298
  513667
  521202
  523606
  523687
  523695
  524402
  526747
  531745
  543546
  546986
  557896
  558919
  559811
  574076
  599245
  599985
  600272
  602048
  630453
  637727
  648664
  664181
  668700
  685742
  689207
  694102
  701963
  706442
  715965
  717095
  720113
  722924
  734251
  740561
  740852
  744952
  744953
  751680
  754577
  754915
  754921
  766174
  768431
  773654
  774146
  774824
  777677
  778037
  779641
  781381
  782466
  783247
  786601
  786770
  790730
  800143
  801430
  808507
  811142
  811441
  812039
  812060
  813587
  813626
  814449
  826233
]
1.80 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian masturbation"
]
1.75 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск мастурбац"
]
1.70 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск мастурбац"
]
1.64 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.