Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.27 ms
(83.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
  384220
  399662
  415610
  433980
  435557
  442186
  442556
  450472
  451469
  454262
  455682
  460067
  460115
  460784
  461232
  461613
  462531
  468036
  474141
  477797
  478742
  479946
  481441
  482061
  484861
  485367
  485918
  486672
  486678
  487889
  490908
  491871
  492517
  494770
  498030
  498039
  498054
  503064
  505202
  506803
  508221
  508783
  512208
  516000
  519547
  519785
  524544
  525369
  527245
  527451
  528868
  529477
  531991
  532974
  533409
  545695
  546767
  549643
  552362
  554386
  559864
  564200
  564685
  565103
  573175
  574671
  581136
  584101
  585007
  586440
  586484
  586503
  586564
  593269
  593275
  593288
  593292
  593343
  593361
  593366
  593372
  593382
  593385
  593394
  593416
  593425
  601634
  605450
  606208
  607129
  626892
  639722
  641130
  653405
  653407
  668997
  683660
  686877
  712886
  726875
  743906
  776481
  780724
  817841
  820126
]
17.78 ms
(10.48%)
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
  384220
  528868
  485367
  487889
  593292
  498030
  653405
  626892
  527451
  486678
  817841
  820126
  474141
  481441
  559864
  574671
  581136
  584101
  546767
  565103
  712886
  668997
  683660
  686877
  564200
  593288
  593382
  593416
  593394
  593385
  780724
  726875
  461232
  468036
  479946
  399662
  433980
  435557
  490908
  533409
  492517
  503064
  508783
  527245
  512208
  498039
  593366
  554386
  605450
  586440
  593343
  524544
  516000
  586564
  455682
  531991
  532974
  484861
  564685
  552362
  606208
  776481
  743906
  478742
  415610
  450472
  451469
  460784
  482061
  505202
  519785
  460115
  477797
  508221
  653407
  601634
  641130
  442186
  454262
  461613
  525369
  486672
  519547
  529477
  593372
  639722
  607129
  593425
  549643
  573175
  593275
  586503
  442556
  462531
  460067
  585007
  498054
  485918
  494770
  593269
  491871
  545695
  506803
  593361
  586484
]
2.50 ms
(1.47%)
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
  384220
  399662
  415610
  433980
  435557
  442186
  442556
  450472
  451469
  454262
  455682
  460067
  460115
  460784
  461232
  461613
  462531
  468036
  474141
  477797
  478742
  479946
  481441
  482061
  484861
  485367
  485918
  486672
  486678
  487889
  490908
  491871
  492517
  494770
  498030
  498039
  498054
  503064
  505202
  506803
  508221
  508783
  512208
  516000
  519547
  519785
  524544
  525369
  527245
  527451
  528868
  529477
  531991
  532974
  533409
  545695
  546767
  549643
  552362
  554386
  559864
  564200
  564685
  565103
  573175
  574671
  581136
  584101
  585007
  586440
  586484
  586503
  586564
  593269
  593275
  593288
  593292
  593343
  593361
  593366
  593372
  593382
  593385
  593394
  593416
  593425
  601634
  605450
  606208
  607129
  626892
  639722
  641130
  653405
  653407
  668997
  683660
  686877
  712886
  726875
  743906
  776481
  780724
  817841
  820126
]
2.24 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "nurse medical"
]
1.86 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "врачих медицин"
]
1.45 ms
(0.86%)
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.