Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.98 ms
(86.03%)
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
  38908
  398670
  422280
  429573
  440606
  504110
  507442
  508237
  512842
  518418
  520869
  524265
  524824
  525733
  527100
  528505
  529379
  532200
  533263
  535536
  536880
  537281
  539327
  539342
  540168
  542309
  544536
  545696
  546865
  546892
  555213
  555454
  555636
  556180
  556790
  557193
  557716
  557841
  560035
  563709
  564569
  565881
  567622
  574626
  578573
  582316
  583877
  584252
  584365
  584390
  584504
  584686
  584949
  585326
  585336
  585574
  588322
  588937
  589722
  591556
  591837
  591884
  591957
  592349
  592688
  593827
  594412
  595047
  595069
  597890
  601380
  603085
  605291
  605564
  606804
  608007
  610974
  613837
  617512
  618696
  619462
  619670
  620371
  621100
  622962
  632186
  633657
  635736
  636450
  641528
  643832
  648424
  664545
  666721
  672844
  676564
  677191
  682652
  684511
  696071
  705220
  725655
  729087
  730606
  730766
  732191
  736419
  738327
  744161
  746477
  750463
  755436
  779300
  783839
  784446
  787356
  793647
  796796
  801677
  803256
]
12.54 ms
(7.65%)
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
  584252
  593827
  617512
  605291
  440606
  525733
  527100
  595047
  620371
  585574
  512842
  584686
  636450
  524824
  507442
  610974
  584365
  672844
  601380
  606804
  801677
  729087
  736419
  744161
  796796
  750463
  755436
  730766
  705220
  648424
  556180
  664545
  618696
  633657
  533263
  677191
  682652
  779300
  536880
  555213
  556790
  591556
  619670
  594412
  608007
  574626
  578573
  546892
  592688
  622962
  605564
  784446
  738327
  730606
  746477
  787356
  398670
  696071
  585336
  422280
  585326
  557716
  684511
  583877
  584504
  635736
  793647
  732191
  529379
  508237
  504110
  539327
  557841
  38908
  783839
  532200
  567622
  676564
  584949
  643832
  613837
  632186
  520869
  524265
  429573
  564569
  582316
  603085
  542309
  803256
  563709
  725655
  592349
  621100
  595069
  591884
  537281
  588937
  545696
  641528
  555636
  518418
  535536
  544536
  565881
  591957
  589722
  584390
  557193
  539342
  540168
  666721
  591837
  597890
  560035
  619462
  588322
  528505
  555454
  546865
]
3.40 ms
(2.08%)
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
  38908
  398670
  422280
  429573
  440606
  504110
  507442
  508237
  512842
  518418
  520869
  524265
  524824
  525733
  527100
  528505
  529379
  532200
  533263
  535536
  536880
  537281
  539327
  539342
  540168
  542309
  544536
  545696
  546865
  546892
  555213
  555454
  555636
  556180
  556790
  557193
  557716
  557841
  560035
  563709
  564569
  565881
  567622
  574626
  578573
  582316
  583877
  584252
  584365
  584390
  584504
  584686
  584949
  585326
  585336
  585574
  588322
  588937
  589722
  591556
  591837
  591884
  591957
  592349
  592688
  593827
  594412
  595047
  595069
  597890
  601380
  603085
  605291
  605564
  606804
  608007
  610974
  613837
  617512
  618696
  619462
  619670
  620371
  621100
  622962
  632186
  633657
  635736
  636450
  641528
  643832
  648424
  664545
  666721
  672844
  676564
  677191
  682652
  684511
  696071
  705220
  725655
  729087
  730606
  730766
  732191
  736419
  738327
  744161
  746477
  750463
  755436
  779300
  783839
  784446
  787356
  793647
  796796
  801677
  803256
]
2.00 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончи в киску"
]
1.78 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм в вагин"
]
1.59 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.96%)
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.