Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.26 ms
(83.09%)
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
  13011
  393980
  393987
  394487
  397687
  398257
  399222
  424030
  426315
  426876
  434815
  437169
  438292
  445241
  450123
  457004
  459596
  459716
  463151
  465043
  465235
  465691
  466873
  467289
  471428
  471529
  473117
  478783
  480275
  483640
  483825
  484285
  490700
  490733
  491011
  493770
  495233
  495458
  499694
  502106
  504114
  505633
  507102
  507460
  507840
  509060
  511435
  512390
  513405
  513493
  514755
  517468
  519216
  522492
  523192
  529947
  530070
  530453
  531526
  531676
  531962
  532175
  533109
  533492
  534944
  538307
  538513
  539374
  539397
  540695
  546251
  558784
  578778
  584213
  604945
  606723
  613335
  631739
  632813
  638069
  643665
  644056
  650978
  654977
  664390
  665334
  665989
  679591
  688384
  697586
  697597
  697603
  698822
  710686
  719856
  720027
  720053
  723086
  725333
  732164
  734059
  734062
  737021
  737670
  738976
  747251
  750396
  755845
  757639
  758009
  762623
  783121
  791287
  792694
  792926
  823469
  826227
  828337
  828685
]
15.02 ms
(9.51%)
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
  826432
  397687
  399222
  434815
  584213
  664390
  632813
  734059
  495458
  465691
  513405
  606723
  480275
  513493
  504114
  688384
  720053
  679591
  698822
  723086
  654977
  558784
  638069
  643665
  631739
  604945
  725333
  762623
  783121
  791287
  747251
  758009
  738976
  750396
  484285
  823469
  828337
  531526
  734062
  755845
  507840
  522492
  467289
  650978
  473117
  438292
  471428
  437169
  424030
  530453
  531962
  534944
  514755
  697597
  697586
  710686
  465235
  523192
  495233
  426315
  737021
  512390
  511435
  505633
  483825
  457004
  471529
  538513
  490733
  507460
  578778
  697603
  445241
  519216
  665334
  737670
  828685
  531676
  792694
  792926
  644056
  466873
  499694
  532175
  546251
  732164
  757639
  459596
  450123
  529947
  465043
  509060
  483640
  507102
  613335
  826227
  533492
  539397
  426876
  393980
  490700
  491011
  533109
  539374
  538307
  530070
  478783
  720027
  502106
  463151
  394487
  493770
  540695
  665989
  719856
  459716
  13011
  517468
  393987
  398257
]
3.84 ms
(2.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большой большие член жен"
]
2.65 ms
(1.68%)
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
  13011
  393980
  393987
  394487
  397687
  398257
  399222
  424030
  426315
  426876
  434815
  437169
  438292
  445241
  450123
  457004
  459596
  459716
  463151
  465043
  465235
  465691
  466873
  467289
  471428
  471529
  473117
  478783
  480275
  483640
  483825
  484285
  490700
  490733
  491011
  493770
  495233
  495458
  499694
  502106
  504114
  505633
  507102
  507460
  507840
  509060
  511435
  512390
  513405
  513493
  514755
  517468
  519216
  522492
  523192
  529947
  530070
  530453
  531526
  531676
  531962
  532175
  533109
  533492
  534944
  538307
  538513
  539374
  539397
  540695
  546251
  558784
  578778
  584213
  604945
  606723
  613335
  631739
  632813
  638069
  643665
  644056
  650978
  654977
  664390
  665334
  665989
  679591
  688384
  697586
  697597
  697603
  698822
  710686
  719856
  720027
  720053
  723086
  725333
  732164
  734059
  734062
  737021
  737670
  738976
  747251
  750396
  755845
  757639
  758009
  762623
  783121
  791287
  792694
  792926
  823469
  826227
  828337
  828685
]
1.90 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big dick wife"
]
1.66 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.05%)
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.