Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.11 ms
(88.72%)
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
  70131
  360205
  381979
  384804
  391101
  401814
  423128
  482884
  500092
  505947
  506548
  522644
  525409
  525932
  526136
  537764
  539099
  542174
  544291
  547073
  555397
  564242
  567161
  568375
  568739
  569024
  569530
  569538
  572958
  574300
  575615
  589580
  589771
  589773
  592487
  606090
  606212
  606265
  609918
  611687
  617885
  618189
  619737
  623352
  626351
  626430
  627191
  628669
  633664
  644847
  644984
  647126
  649866
  664655
  666978
  689478
  689868
  696053
  696058
  696642
  696664
  696687
  696698
  697085
  701604
  702347
  707973
  708170
  709512
  716146
  716582
  718593
  721755
  722993
  724731
  726049
  730499
  736498
  738352
  739810
  746442
  748126
  750686
  751242
  754635
  755737
  758949
  761069
  764367
  768042
  768293
  768999
  771514
  775815
  778925
  779614
  780201
  780742
  782745
  784264
  791105
  791491
  791575
  791581
  791643
  792462
  792990
  793019
  795992
  799590
  802804
  807275
  809767
  811637
  817403
  817519
  817620
  820920
  821477
  823038
]
12.37 ms
(6.16%)
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
  623352
  779614
  567161
  360205
  791491
  70131
  506548
  809767
  701604
  689868
  384804
  522644
  544291
  555397
  568739
  589773
  821477
  568375
  784264
  795992
  547073
  542174
  716146
  724731
  739810
  525409
  611687
  618189
  569538
  664655
  626351
  738352
  647126
  761069
  539099
  423128
  689478
  391101
  482884
  575615
  666978
  696053
  696058
  696698
  709512
  722993
  702347
  707973
  716582
  606212
  589771
  633664
  619737
  627191
  791105
  791643
  736498
  768042
  768293
  754635
  617885
  696664
  696687
  697085
  718593
  811637
  791575
  525932
  574300
  401814
  564242
  381979
  820920
  817620
  823038
  730499
  569024
  696642
  807275
  782745
  751242
  758949
  771514
  775815
  778925
  792990
  780742
  755737
  726049
  793019
  644984
  537764
  589580
  750686
  609918
  592487
  791581
  500092
  644847
  628669
  626430
  572958
  649866
  606090
  792462
  748126
  569530
  780201
  526136
  505947
  721755
  708170
  606265
  799590
  802804
  746442
  768999
  764367
  817403
  817519
]
3.18 ms
(1.59%)
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
  70131
  360205
  381979
  384804
  391101
  401814
  423128
  482884
  500092
  505947
  506548
  522644
  525409
  525932
  526136
  537764
  539099
  542174
  544291
  547073
  555397
  564242
  567161
  568375
  568739
  569024
  569530
  569538
  572958
  574300
  575615
  589580
  589771
  589773
  592487
  606090
  606212
  606265
  609918
  611687
  617885
  618189
  619737
  623352
  626351
  626430
  627191
  628669
  633664
  644847
  644984
  647126
  649866
  664655
  666978
  689478
  689868
  696053
  696058
  696642
  696664
  696687
  696698
  697085
  701604
  702347
  707973
  708170
  709512
  716146
  716582
  718593
  721755
  722993
  724731
  726049
  730499
  736498
  738352
  739810
  746442
  748126
  750686
  751242
  754635
  755737
  758949
  761069
  764367
  768042
  768293
  768999
  771514
  775815
  778925
  779614
  780201
  780742
  782745
  784264
  791105
  791491
  791575
  791581
  791643
  792462
  792990
  793019
  795992
  799590
  802804
  807275
  809767
  811637
  817403
  817519
  817620
  820920
  821477
  823038
]
2.04 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm public"
]
1.76 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм на улиц"
]
1.73 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.78%)
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.