Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.69 ms
(82.93%)
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
  201639
  202134
  384220
  405043
  423846
  425762
  441877
  456787
  456983
  458894
  458904
  459546
  459993
  461631
  462257
  464125
  469636
  471472
  474141
  474810
  475040
  476877
  479950
  481441
  485367
  486644
  487889
  488974
  489786
  492697
  493057
  501466
  504328
  510364
  513693
  515263
  515271
  515282
  516832
  522216
  523088
  525735
  525806
  528868
  530194
  533991
  546767
  550555
  550776
  552332
  553328
  556393
  559864
  560999
  564200
  565103
  566760
  568398
  571375
  574671
  575013
  580365
  581136
  584101
  593248
  593270
  593288
  593314
  593316
  593330
  593346
  593354
  593379
  593381
  593391
  593396
  593400
  593404
  593405
  593418
  593440
  595842
  602227
  605915
  606668
  614499
  619412
  619678
  622149
  628308
  635980
  649516
  668997
  674330
  675533
  680468
  683660
  686877
  687544
  687588
  688342
  691510
  698680
  705518
  708518
  711006
  712886
  722420
  742034
  759883
  759896
  771364
  775916
  776442
  788266
  795538
  801147
  807757
  817841
  820126
]
16.58 ms
(10.85%)
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
  489786
  469636
  510364
  516832
  513693
  530194
  533991
  515282
  488974
  550555
  580365
  571375
  575013
  691510
  722420
  675533
  705518
  708518
  560999
  593270
  593314
  593316
  605915
  593354
  593391
  593396
  593405
  593440
  606668
  622149
  628308
  593248
  593330
  593346
  593381
  593400
  593404
  593418
  595842
  614499
  619678
  635980
  593379
  619412
  795538
  801147
  775916
  788266
  759896
  807757
  742034
  759883
  771364
  602227
  711006
  776442
  201639
  423846
  456983
  458904
  459993
  462257
  479950
  384220
  459546
  528868
  504328
  485367
  515271
  522216
  487889
  525735
  202134
  405043
  425762
  441877
  817841
  820126
  474141
  486644
  493057
  461631
  476877
  492697
  456787
  458894
  471472
  474810
  501466
  525806
  515263
  523088
  464125
  475040
  481441
  556393
  559864
  574671
  581136
  552332
  553328
  566760
  568398
  584101
  546767
  565103
  674330
  680468
  687544
  712886
  668997
  683660
  698680
  649516
  686877
  687588
  688342
  550776
  564200
  593288
]
3.10 ms
(2.03%)
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
  201639
  202134
  384220
  405043
  423846
  425762
  441877
  456787
  456983
  458894
  458904
  459546
  459993
  461631
  462257
  464125
  469636
  471472
  474141
  474810
  475040
  476877
  479950
  481441
  485367
  486644
  487889
  488974
  489786
  492697
  493057
  501466
  504328
  510364
  513693
  515263
  515271
  515282
  516832
  522216
  523088
  525735
  525806
  528868
  530194
  533991
  546767
  550555
  550776
  552332
  553328
  556393
  559864
  560999
  564200
  565103
  566760
  568398
  571375
  574671
  575013
  580365
  581136
  584101
  593248
  593270
  593288
  593314
  593316
  593330
  593346
  593354
  593379
  593381
  593391
  593396
  593400
  593404
  593405
  593418
  593440
  595842
  602227
  605915
  606668
  614499
  619412
  619678
  622149
  628308
  635980
  649516
  668997
  674330
  675533
  680468
  683660
  686877
  687544
  687588
  688342
  691510
  698680
  705518
  708518
  711006
  712886
  722420
  742034
  759883
  759896
  771364
  775916
  776442
  788266
  795538
  801147
  807757
  817841
  820126
]
1.77 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "nurse 2009"
]
1.64 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "врачих"
]
1.60 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.90%)
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.