Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.37 ms
(86.80%)
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
  32994
  314006
  317898
  364242
  391815
  398522
  417240
  433704
  468952
  475988
  477285
  478158
  481986
  488563
  493107
  494667
  496247
  512649
  514208
  528062
  530539
  536974
  538165
  541722
  544639
  546296
  548604
  553417
  555010
  556282
  556617
  567477
  575269
  583343
  586197
  586295
  586312
  588756
  599681
  600660
  616070
  617496
  625086
  632754
  633300
  641920
  642274
  643988
  644171
  644199
  645623
  650294
  652699
  656494
  663285
  665324
  665515
  671223
  684876
  699156
  707174
  707238
  709677
  709834
  710097
  712646
  713587
  714777
  715591
  716066
  717578
  720844
  724453
  725053
  726947
  726999
  727683
  730093
  730645
  730944
  741765
  743496
  747540
  748002
  749994
  750673
  753642
  758136
  759680
  761405
  762168
  766056
  766952
  768982
  769193
  771260
  771488
  771556
  772522
  777184
  783940
  784382
  787123
  787654
  788062
  788560
  790325
  790670
  794451
  794816
  795236
  795577
  796679
  797123
  798043
  801759
  802918
  803468
  804037
  806088
]
10.04 ms
(6.84%)
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
  794451
  806088
  777184
  784382
  787654
  788560
  790670
  794816
  798043
  725053
  727683
  747540
  750673
  761405
  766056
  769193
  771488
  787123
  788062
  790325
  795236
  795577
  796679
  801759
  724453
  730645
  730944
  749994
  753642
  759680
  766952
  768982
  771260
  741765
  743496
  762168
  730093
  758136
  771556
  772522
  726947
  726999
  748002
  616070
  699156
  709677
  715591
  717578
  720844
  783940
  797123
  802918
  803468
  804037
  317898
  364242
  32994
  398522
  512649
  391815
  314006
  433704
  417240
  475988
  468952
  481986
  488563
  496247
  530539
  536974
  528062
  538165
  494667
  514208
  477285
  478158
  493107
  546296
  548604
  556282
  556617
  583343
  541722
  650294
  684876
  707174
  713587
  645623
  652699
  656494
  663285
  665324
  665515
  671223
  707238
  709834
  710097
  712646
  714777
  716066
  544639
  553417
  555010
  567477
  575269
  632754
  633300
  643988
  588756
  600660
  625086
  641920
  642274
  644199
  586295
  586312
  599681
  617496
  644171
  586197
]
2.39 ms
(1.63%)
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
  32994
  314006
  317898
  364242
  391815
  398522
  417240
  433704
  468952
  475988
  477285
  478158
  481986
  488563
  493107
  494667
  496247
  512649
  514208
  528062
  530539
  536974
  538165
  541722
  544639
  546296
  548604
  553417
  555010
  556282
  556617
  567477
  575269
  583343
  586197
  586295
  586312
  588756
  599681
  600660
  616070
  617496
  625086
  632754
  633300
  641920
  642274
  643988
  644171
  644199
  645623
  650294
  652699
  656494
  663285
  665324
  665515
  671223
  684876
  699156
  707174
  707238
  709677
  709834
  710097
  712646
  713587
  714777
  715591
  716066
  717578
  720844
  724453
  725053
  726947
  726999
  727683
  730093
  730645
  730944
  741765
  743496
  747540
  748002
  749994
  750673
  753642
  758136
  759680
  761405
  762168
  766056
  766952
  768982
  769193
  771260
  771488
  771556
  772522
  777184
  783940
  784382
  787123
  787654
  788062
  788560
  790325
  790670
  794451
  794816
  795236
  795577
  796679
  797123
  798043
  801759
  802918
  803468
  804037
  806088
]
2.00 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зашёл к соседям"
]
1.75 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сосед"
]
1.51 ms
(1.03%)
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.