Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.40 ms
(35.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск saggy"
]
208.07 ms
(34.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
165.30 ms
(27.22%)
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
  391527
  391528
  391947
  417071
  426688
  448412
  448892
  448897
  448900
  453682
  454136
  460425
  461942
  471104
  474197
  476636
  476986
  479086
  479308
  484447
  491242
  493342
  496665
  500700
  504325
  506407
  522450
  533052
  533733
  535607
  543689
  543759
  544952
  545875
  546893
  562747
  563454
  566353
  566737
  601409
  605307
  605875
  610835
  620696
  623385
  644861
  657634
  662410
  667907
  667980
  668829
  672841
  683272
  695381
  708215
  711362
  720658
  722085
  725204
  731575
  732903
  735881
  738363
  738527
  741710
  742386
  744172
  754641
  754785
  755875
  759489
  761797
  762521
  762669
  765152
  765495
  766315
  768161
  768452
  768734
  768830
  769138
  770640
  778300
  779386
  781667
  782614
  783609
  789348
  789353
  789361
  789379
  792334
  793051
  795203
  796262
  796459
  797131
  797316
  798289
  799531
  801496
  804091
  805615
  808541
  811144
  818008
  818719
  819265
  819369
  819867
  819921
  824206
  825738
  825743
  825904
  826127
  826219
  826581
  827812
]
13.25 ms
(2.18%)
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
  826127
  391947
  491242
  522450
  533733
  454136
  471104
  391527
  484447
  417071
  644861
  448412
  543759
  562747
  543689
  563454
  672841
  720658
  683272
  605875
  610835
  779386
  783609
  808541
  741710
  765152
  738527
  742386
  762669
  623385
  448892
  479308
  460425
  479086
  448900
  426688
  448897
  476986
  453682
  493342
  496665
  500700
  504325
  506407
  818719
  819369
  825904
  826581
  818008
  819921
  826219
  824206
  825738
  825743
  819867
  535607
  533052
  544952
  545875
  566737
  667980
  657634
  667907
  668829
  708215
  695381
  566353
  620696
  601409
  605307
  792334
  797131
  799531
  805615
  778300
  782614
  789348
  789353
  796262
  797316
  798289
  801496
  731575
  754641
  781667
  789361
  789379
  796459
  811144
  725204
  754785
  766315
  768734
  732903
  738363
  755875
  759489
  768161
  768452
  768830
  735881
  744172
  761797
  765495
  769138
  762521
  770640
  711362
  722085
  793051
  795203
  804091
  391528
  819265
  827812
  476636
  474197
  461942
  546893
  662410
]
3.09 ms
(0.51%)
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
  391527
  391528
  391947
  417071
  426688
  448412
  448892
  448897
  448900
  453682
  454136
  460425
  461942
  471104
  474197
  476636
  476986
  479086
  479308
  484447
  491242
  493342
  496665
  500700
  504325
  506407
  522450
  533052
  533733
  535607
  543689
  543759
  544952
  545875
  546893
  562747
  563454
  566353
  566737
  601409
  605307
  605875
  610835
  620696
  623385
  644861
  657634
  662410
  667907
  667980
  668829
  672841
  683272
  695381
  708215
  711362
  720658
  722085
  725204
  731575
  732903
  735881
  738363
  738527
  741710
  742386
  744172
  754641
  754785
  755875
  759489
  761797
  762521
  762669
  765152
  765495
  766315
  768161
  768452
  768734
  768830
  769138
  770640
  778300
  779386
  781667
  782614
  783609
  789348
  789353
  789361
  789379
  792334
  793051
  795203
  796262
  796459
  797131
  797316
  798289
  799531
  801496
  804091
  805615
  808541
  811144
  818008
  818719
  819265
  819369
  819867
  819921
  824206
  825738
  825743
  825904
  826127
  826219
  826581
  827812
]
1.70 ms
(0.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск saggy"
]
1.57 ms
(0.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian saggy"
]

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.