Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.90 ms
(88.81%)
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
  390845
  391871
  401674
  405950
  410855
  410874
  419321
  422019
  429025
  442171
  456691
  461884
  469890
  474923
  483388
  490063
  495706
  495741
  495750
  500566
  508433
  514643
  522532
  537001
  541108
  541967
  544248
  544666
  559644
  560319
  578552
  579535
  584995
  585012
  587637
  590857
  590874
  590876
  590907
  593840
  600049
  601552
  603655
  605626
  620531
  622130
  622349
  632037
  632513
  637527
  637566
  638451
  641852
  645194
  649640
  654624
  675297
  675960
  676851
  677609
  679561
  681792
  693816
  694334
  694639
  696748
  700941
  702570
  703212
  703505
  707434
  708134
  709295
  710781
  712047
  712243
  712470
  715853
  724410
  726290
  729223
  729270
  729276
  730210
  737500
  741655
  742046
  742596
  753678
  759667
  770313
  770670
  770758
  774293
  776307
  776396
  776566
  784700
  787716
  790063
  790823
  792491
  792515
  793175
  793427
  795887
  797908
  806068
  807362
  807439
  807462
  809409
  809614
  809651
  810286
  814320
  814330
  818530
  821837
  825302
]
15.16 ms
(6.41%)
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
  590857
  514643
  807362
  795887
  790063
  637566
  654624
  675960
  810286
  638451
  645194
  784700
  818530
  712243
  730210
  742046
  753678
  793427
  474923
  495741
  825302
  622130
  590907
  770670
  696748
  483388
  793175
  821837
  679561
  737500
  770758
  729270
  790823
  508433
  776396
  715853
  632037
  797908
  605626
  741655
  759667
  579535
  620531
  792491
  681792
  710781
  814330
  712047
  809614
  702570
  729223
  700941
  694639
  677609
  649640
  622349
  703212
  578552
  694334
  390845
  544248
  587637
  807462
  809651
  495706
  500566
  429025
  461884
  405950
  707434
  601552
  603655
  632513
  522532
  541108
  693816
  401674
  590876
  590874
  703505
  391871
  410855
  537001
  641852
  560319
  708134
  809409
  544666
  559644
  712470
  774293
  709295
  469890
  495750
  792515
  807439
  600049
  814320
  726290
  490063
  410874
  422019
  676851
  776566
  806068
  729276
  456691
  541967
  675297
  637527
  787716
  742596
  770313
  776307
  442171
  593840
  724410
  419321
  584995
  585012
]
3.53 ms
(1.50%)
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
  390845
  391871
  401674
  405950
  410855
  410874
  419321
  422019
  429025
  442171
  456691
  461884
  469890
  474923
  483388
  490063
  495706
  495741
  495750
  500566
  508433
  514643
  522532
  537001
  541108
  541967
  544248
  544666
  559644
  560319
  578552
  579535
  584995
  585012
  587637
  590857
  590874
  590876
  590907
  593840
  600049
  601552
  603655
  605626
  620531
  622130
  622349
  632037
  632513
  637527
  637566
  638451
  641852
  645194
  649640
  654624
  675297
  675960
  676851
  677609
  679561
  681792
  693816
  694334
  694639
  696748
  700941
  702570
  703212
  703505
  707434
  708134
  709295
  710781
  712047
  712243
  712470
  715853
  724410
  726290
  729223
  729270
  729276
  730210
  737500
  741655
  742046
  742596
  753678
  759667
  770313
  770670
  770758
  774293
  776307
  776396
  776566
  784700
  787716
  790063
  790823
  792491
  792515
  793175
  793427
  795887
  797908
  806068
  807362
  807439
  807462
  809409
  809614
  809651
  810286
  814320
  814330
  818530
  821837
  825302
]
2.14 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жмж дом"
]
1.94 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жмж секс втро домашн любительск"
]
1.78 ms
(0.75%)
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.