Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.08 ms
(56.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пробуют"
]
143.42 ms
(38.83%)
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
  78709
  327523
  383619
  385634
  396528
  396626
  401986
  405151
  416013
  421350
  422388
  423811
  425599
  429537
  447411
  451683
  468015
  472842
  475250
  478091
  490267
  504101
  512794
  515990
  527171
  529036
  531911
  538518
  540317
  547400
  550806
  554215
  555324
  556521
  558655
  562850
  571753
  575334
  584261
  588578
  600933
  602291
  602415
  604572
  618886
  623572
  625766
  626734
  627239
  630099
  633213
  633537
  636983
  639957
  639960
  653376
  666993
  668183
  669852
  673947
  677021
  689525
  689949
  691561
  701001
  702629
  707738
  709556
  721207
  723838
  725396
  726164
  726476
  730327
  730464
  730943
  742178
  742297
  743197
  743325
  744044
  744593
  744907
  744990
  747340
  749659
  751506
  753638
  756081
  758078
  758673
  765100
  765510
  767020
  767399
  769910
  771174
  771217
  774514
  774817
  775383
  777599
  777801
  778727
  780192
  784108
  785274
  785579
  788230
  790511
  792680
  793838
  794647
  796887
  797389
  798020
  803384
  806342
  814019
  815137
]
11.08 ms
(3.00%)
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
  625766
  636983
  777599
  777801
  778727
  416013
  385634
  447411
  478091
  531911
  538518
  504101
  540317
  550806
  575334
  584261
  691561
  701001
  673947
  709556
  669852
  602291
  618886
  627239
  785579
  793838
  792680
  726164
  730943
  744044
  744907
  765100
  723838
  726476
  742297
  771174
  751506
  767399
  725396
  747340
  749659
  758673
  769910
  602415
  623572
  630099
  633213
  702629
  721207
  784108
  785274
  788230
  798020
  806342
  423811
  529036
  327523
  396626
  396528
  405151
  421350
  422388
  429537
  815137
  814019
  472842
  490267
  515990
  527171
  554215
  558655
  562850
  571753
  555324
  556521
  547400
  666993
  707738
  677021
  653376
  668183
  689525
  689949
  588578
  604572
  633537
  639960
  600933
  626734
  639957
  774514
  796887
  774817
  794647
  803384
  742178
  743197
  790511
  730327
  765510
  743325
  744593
  744990
  767020
  730464
  753638
  771217
  756081
  758078
  775383
  780192
  797389
  451683
  383619
  468015
  512794
  78709
  401986
  425599
  475250
]
2.98 ms
(0.81%)
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
  78709
  327523
  383619
  385634
  396528
  396626
  401986
  405151
  416013
  421350
  422388
  423811
  425599
  429537
  447411
  451683
  468015
  472842
  475250
  478091
  490267
  504101
  512794
  515990
  527171
  529036
  531911
  538518
  540317
  547400
  550806
  554215
  555324
  556521
  558655
  562850
  571753
  575334
  584261
  588578
  600933
  602291
  602415
  604572
  618886
  623572
  625766
  626734
  627239
  630099
  633213
  633537
  636983
  639957
  639960
  653376
  666993
  668183
  669852
  673947
  677021
  689525
  689949
  691561
  701001
  702629
  707738
  709556
  721207
  723838
  725396
  726164
  726476
  730327
  730464
  730943
  742178
  742297
  743197
  743325
  744044
  744593
  744907
  744990
  747340
  749659
  751506
  753638
  756081
  758078
  758673
  765100
  765510
  767020
  767399
  769910
  771174
  771217
  774514
  774817
  775383
  777599
  777801
  778727
  780192
  784108
  785274
  785579
  788230
  790511
  792680
  793838
  794647
  796887
  797389
  798020
  803384
  806342
  814019
  815137
]
1.67 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "проб"
]
1.63 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "проб"
]
1.50 ms
(0.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.