Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.16 ms
(87.47%)
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
  562527
  569036
  571293
  585831
  588455
  591753
  592132
  593765
  593913
  594617
  596441
  598095
  606389
  614759
  617215
  620938
  625300
  630125
  631224
  636472
  642128
  644178
  653006
  658869
  664551
  668698
  674280
  685805
  701677
  701801
  704797
  707730
  707890
  708734
  709276
  713652
  714126
  714510
  717145
  717378
  718391
  720011
  721965
  725526
  726435
  729641
  730222
  730543
  733409
  734069
  734194
  734258
  734594
  735904
  736894
  739787
  739950
  740280
  741677
  746175
  747046
  748773
  749414
  750768
  753744
  753745
  753760
  756526
  759131
  762155
  762366
  762572
  764156
  764565
  765900
  766534
  767441
  767496
  767654
  767667
  768652
  768657
  768745
  769600
  769911
  770324
  770417
  771281
  772125
  773793
  774918
  775048
  775853
  777349
  778222
  783248
  783737
  784320
  785526
  787152
  787172
  787194
  792779
  793782
  795970
  795976
  796510
  796811
  801976
  802073
  807122
  808700
  809200
  810785
  810921
  811599
  812580
  813319
]
12.95 ms
(6.90%)
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
  707730
  720011
  658869
  685805
  708734
  714126
  717378
  718391
  653006
  664551
  668698
  674280
  701677
  704797
  707890
  709276
  721965
  562527
  569036
  571293
  592132
  593913
  594617
  606389
  642128
  585831
  596441
  625300
  636472
  644178
  591753
  593765
  598095
  617215
  588455
  620938
  631224
  774918
  775048
  785526
  787152
  787194
  793782
  801976
  807122
  808700
  809200
  810785
  811599
  775853
  778222
  783248
  783737
  795970
  795976
  796510
  729641
  730222
  746175
  747046
  750768
  753760
  762572
  766534
  771281
  784320
  792779
  796811
  810921
  812580
  734069
  736894
  740280
  756526
  762155
  762366
  765900
  768657
  770417
  725526
  730543
  733409
  734258
  739950
  741677
  753744
  759131
  764565
  769911
  734194
  735904
  739787
  748773
  753745
  767441
  767496
  767667
  768652
  768745
  772125
  726435
  734594
  749414
  764156
  767654
  768922
  769600
  770324
  771930
  773793
  614759
  630125
  701801
  713652
  714510
  717145
  777349
  787172
  802073
  813319
]
2.60 ms
(1.39%)
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
  562527
  569036
  571293
  585831
  588455
  591753
  592132
  593765
  593913
  594617
  596441
  598095
  606389
  614759
  617215
  620938
  625300
  630125
  631224
  636472
  642128
  644178
  653006
  658869
  664551
  668698
  674280
  685805
  701677
  701801
  704797
  707730
  707890
  708734
  709276
  713652
  714126
  714510
  717145
  717378
  718391
  720011
  721965
  725526
  726435
  729641
  730222
  730543
  733409
  734069
  734194
  734258
  734594
  735904
  736894
  739787
  739950
  740280
  741677
  746175
  747046
  748773
  749414
  750768
  753744
  753745
  753760
  756526
  759131
  762155
  762366
  762572
  764156
  764565
  765900
  766534
  767441
  767496
  767654
  767667
  768652
  768657
  768745
  769600
  769911
  770324
  770417
  771281
  772125
  773793
  774918
  775048
  775853
  777349
  778222
  783248
  783737
  784320
  785526
  787152
  787172
  787194
  792779
  793782
  795970
  795976
  796510
  796811
  801976
  802073
  807122
  808700
  809200
  810785
  810921
  811599
  812580
  813319
]
2.18 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.12 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дрочит женская"
]
1.94 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк женск"
]
1.72 ms
(0.92%)
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.