Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.61 ms
(79.20%)
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
  406075
  414865
  415095
  416200
  421756
  423317
  435792
  439673
  439749
  445735
  448825
  451301
  451931
  452161
  452681
  455316
  457419
  461061
  466151
  473691
  477389
  482317
  482507
  483543
  488710
  489866
  493842
  504411
  507430
  507584
  508424
  510481
  512538
  513001
  513500
  517414
  518248
  520952
  521675
  523030
  523333
  523711
  523720
  523996
  524119
  527076
  529373
  535417
  540800
  540802
  546029
  546710
  546993
  547423
  547986
  548012
  550353
  550409
  553329
  555118
  556741
  557569
  559606
  559725
  560899
  565281
  566248
  567648
  569065
  571137
  571333
  574404
  574519
  576312
  578451
  583706
  585668
  590851
  591954
  593193
  595454
  596786
  596823
  597282
  597559
  598760
  598770
  598838
  599467
  599979
  601340
  601924
  601935
  603873
  603907
  604743
  605416
  606049
  608084
  608106
  608416
  608737
  611416
  613880
  617342
  618943
  620215
  621294
  622228
  624151
  625414
  626478
  628273
  629095
  631504
  649134
  653189
  654374
  677007
  678569
]
27.70 ms
(14.76%)
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
  523333
  521675
  473691
  452681
  482317
  415095
  547986
  560899
  523711
  489866
  550353
  555118
  451301
  457419
  547423
  601935
  523030
  576312
  626478
  559606
  567648
  455316
  493842
  439749
  448825
  507584
  677007
  546710
  598760
  598838
  451931
  518248
  546029
  517414
  520952
  565281
  557569
  578451
  508424
  608084
  421756
  483543
  524119
  571137
  625414
  523720
  423317
  477389
  507430
  513500
  608737
  597282
  583706
  553329
  631504
  613880
  608106
  529373
  461061
  548012
  439673
  654374
  622228
  628273
  596786
  611416
  414865
  416200
  445735
  452161
  540802
  523996
  571333
  649134
  595454
  606049
  618943
  488710
  574519
  597559
  482507
  604743
  624151
  435792
  574404
  569065
  629095
  601924
  510481
  504411
  550409
  556741
  559725
  605416
  603873
  621294
  546993
  593193
  540800
  513001
  535417
  466151
  527076
  599979
  601340
  590851
  406075
  591954
  512538
  566248
  678569
  653189
  617342
  596823
  585668
  598770
  599467
  620215
  603907
  608416
]
3.76 ms
(2.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "залил пизду спермой"
]
2.96 ms
(1.58%)
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
  406075
  414865
  415095
  416200
  421756
  423317
  435792
  439673
  439749
  445735
  448825
  451301
  451931
  452161
  452681
  455316
  457419
  461061
  466151
  473691
  477389
  482317
  482507
  483543
  488710
  489866
  493842
  504411
  507430
  507584
  508424
  510481
  512538
  513001
  513500
  517414
  518248
  520952
  521675
  523030
  523333
  523711
  523720
  523996
  524119
  527076
  529373
  535417
  540800
  540802
  546029
  546710
  546993
  547423
  547986
  548012
  550353
  550409
  553329
  555118
  556741
  557569
  559606
  559725
  560899
  565281
  566248
  567648
  569065
  571137
  571333
  574404
  574519
  576312
  578451
  583706
  585668
  590851
  591954
  593193
  595454
  596786
  596823
  597282
  597559
  598760
  598770
  598838
  599467
  599979
  601340
  601924
  601935
  603873
  603907
  604743
  605416
  606049
  608084
  608106
  608416
  608737
  611416
  613880
  617342
  618943
  620215
  621294
  622228
  624151
  625414
  626478
  628273
  629095
  631504
  649134
  653189
  654374
  677007
  678569
]
1.64 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зал вагин сперм"
]
1.52 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.77%)
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.