Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.84 ms
(53.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ден"
]
162.84 ms
(41.03%)
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
  14225
  79570
  383045
  389307
  391045
  408639
  424535
  455675
  457408
  470951
  474412
  476993
  478709
  493392
  534855
  535868
  539204
  544757
  544869
  563124
  565546
  565629
  586349
  589457
  601021
  606020
  606648
  606773
  607200
  608006
  610538
  623929
  624055
  632664
  633049
  641048
  648077
  649207
  649598
  666813
  666955
  668788
  676446
  679082
  680390
  680779
  689833
  689847
  689849
  691871
  703506
  707560
  710497
  714548
  717009
  717065
  718742
  719302
  721898
  725005
  728558
  728987
  729115
  729132
  730112
  730489
  735437
  736659
  736918
  738583
  739682
  742169
  744522
  745300
  748266
  749269
  757705
  759823
  761126
  763499
  765947
  766387
  767223
  777315
  781356
  781569
  781801
  784017
  786414
  787136
  788367
  788943
  789129
  789316
  789981
  791637
  792367
  794187
  794343
  794378
  795864
  797858
  798667
  800496
  800548
  801835
  802353
  804266
  807425
  808572
  809370
  809912
  810812
  811235
  811666
  811716
  812716
  812793
  814670
  814909
]
13.12 ms
(3.31%)
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
  457408
  476993
  478709
  539204
  534855
  535868
  493392
  544869
  563124
  565546
  666813
  668788
  676446
  689833
  691871
  718742
  648077
  649207
  666955
  680390
  689847
  703506
  707560
  719302
  649598
  679082
  680779
  689849
  714548
  544757
  565629
  606020
  606648
  632664
  601021
  606773
  608006
  633049
  641048
  586349
  589457
  607200
  610538
  623929
  781801
  784017
  789981
  792367
  794343
  794378
  795864
  798667
  800496
  807425
  808572
  810812
  811716
  812793
  777315
  786414
  788367
  789316
  791637
  725005
  728558
  729132
  730112
  763499
  767223
  781356
  781569
  788943
  794187
  797858
  802353
  809370
  811666
  739682
  744522
  748266
  749269
  761126
  735437
  736659
  728987
  729115
  742169
  745300
  759823
  766387
  730489
  736918
  738583
  757705
  765947
  624055
  710497
  717009
  717065
  721898
  787136
  789129
  800548
  801835
  804266
  809912
  811235
  812716
  383045
  408639
  455675
  470951
  79570
  14225
  389307
  391045
  424535
  814909
  814670
  474412
]
3.29 ms
(0.83%)
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
  14225
  79570
  383045
  389307
  391045
  408639
  424535
  455675
  457408
  470951
  474412
  476993
  478709
  493392
  534855
  535868
  539204
  544757
  544869
  563124
  565546
  565629
  586349
  589457
  601021
  606020
  606648
  606773
  607200
  608006
  610538
  623929
  624055
  632664
  633049
  641048
  648077
  649207
  649598
  666813
  666955
  668788
  676446
  679082
  680390
  680779
  689833
  689847
  689849
  691871
  703506
  707560
  710497
  714548
  717009
  717065
  718742
  719302
  721898
  725005
  728558
  728987
  729115
  729132
  730112
  730489
  735437
  736659
  736918
  738583
  739682
  742169
  744522
  745300
  748266
  749269
  757705
  759823
  761126
  763499
  765947
  766387
  767223
  777315
  781356
  781569
  781801
  784017
  786414
  787136
  788367
  788943
  789129
  789316
  789981
  791637
  792367
  794187
  794343
  794378
  795864
  797858
  798667
  800496
  800548
  801835
  802353
  804266
  807425
  808572
  809370
  809912
  810812
  811235
  811666
  811716
  812716
  812793
  814670
  814909
]
2.18 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дену"
]
1.86 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.