Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.21 ms
(83.95%)
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
  233457
  388364
  396350
  397848
  397870
  398200
  401218
  410686
  441562
  463328
  478454
  485649
  485995
  493681
  495059
  516044
  529337
  532763
  534094
  536213
  537665
  544878
  552664
  560949
  564521
  564559
  566767
  575341
  578478
  583510
  587543
  591931
  593213
  593594
  597732
  601509
  604171
  604240
  614923
  623420
  635578
  641126
  646624
  654922
  656569
  661991
  671049
  677021
  677203
  680143
  680302
  689146
  693103
  693509
  702630
  707323
  711112
  715436
  715652
  720680
  720888
  724523
  724978
  728262
  734967
  734969
  735073
  736218
  737525
  740094
  742797
  743278
  748825
  750247
  753449
  756160
  756666
  756986
  757599
  759795
  760249
  761597
  764245
  764817
  764820
  764879
  765376
  765398
  765412
  765952
  766337
  768715
  769038
  769040
  769878
  770326
  771607
  776999
  777637
  778133
  778215
  778951
  781052
  781331
  781568
  783364
  784209
  785491
  790446
  791200
  792092
  792989
  794368
  794373
  796153
  805733
  806617
  807103
  812014
  828555
]
12.58 ms
(8.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
  757599
  765412
  742797
  748825
  765376
  734969
  735073
  737525
  764245
  715652
  776999
  781568
  794373
  410686
  552664
  623420
  720680
  711112
  656569
  689146
  720888
  778133
  790446
  791200
  778951
  792989
  806617
  756160
  784209
  756666
  768715
  769038
  724523
  728262
  769040
  771607
  777637
  778215
  781331
  396350
  397848
  388364
  401218
  485995
  478454
  536213
  516044
  537665
  583510
  560949
  564559
  578478
  646624
  654922
  671049
  680143
  693103
  677021
  661991
  677203
  680302
  693509
  707323
  597732
  635578
  591931
  593594
  614923
  593213
  604171
  587543
  601509
  604240
  781052
  724978
  740094
  743278
  750247
  769878
  794368
  805733
  812014
  736218
  756986
  760249
  761597
  764820
  764879
  765952
  764817
  753449
  765398
  770326
  734967
  759795
  766337
  702630
  715436
  783364
  785491
  792092
  796153
  807103
  463328
  398200
  441562
  485649
  641126
  233457
  397870
  828555
  493681
  529337
  532763
  495059
  534094
  566767
  544878
  564521
  575341
]
3.20 ms
(2.20%)
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
  233457
  388364
  396350
  397848
  397870
  398200
  401218
  410686
  441562
  463328
  478454
  485649
  485995
  493681
  495059
  516044
  529337
  532763
  534094
  536213
  537665
  544878
  552664
  560949
  564521
  564559
  566767
  575341
  578478
  583510
  587543
  591931
  593213
  593594
  597732
  601509
  604171
  604240
  614923
  623420
  635578
  641126
  646624
  654922
  656569
  661991
  671049
  677021
  677203
  680143
  680302
  689146
  693103
  693509
  702630
  707323
  711112
  715436
  715652
  720680
  720888
  724523
  724978
  728262
  734967
  734969
  735073
  736218
  737525
  740094
  742797
  743278
  748825
  750247
  753449
  756160
  756666
  756986
  757599
  759795
  760249
  761597
  764245
  764817
  764820
  764879
  765376
  765398
  765412
  765952
  766337
  768715
  769038
  769040
  769878
  770326
  771607
  776999
  777637
  778133
  778215
  778951
  781052
  781331
  781568
  783364
  784209
  785491
  790446
  791200
  792092
  792989
  794368
  794373
  796153
  805733
  806617
  807103
  812014
  828555
]
2.05 ms
(1.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал"
]
1.95 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в жопу лучше"
]
1.88 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.16%)
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.