Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.39 ms
(85.57%)
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
  90684
  190925
  203528
  322014
  382726
  388280
  401126
  401615
  406817
  416185
  419497
  422684
  422686
  424494
  426052
  428381
  441874
  443563
  444629
  449102
  449114
  456889
  458878
  458892
  461232
  466765
  468036
  469709
  469914
  472438
  472641
  474854
  475040
  480468
  480475
  480477
  480490
  485208
  486422
  486562
  487779
  488697
  489909
  490879
  490908
  491393
  491395
  491842
  492261
  492521
  492595
  498023
  498025
  498051
  498066
  500311
  502299
  503047
  504405
  505013
  505202
  506522
  507351
  508780
  508782
  513693
  515276
  515285
  515294
  515306
  515931
  516831
  519620
  523635
  535204
  542084
  547835
  548571
  548581
  552129
  552362
  552483
  553723
  563050
  563623
  565847
  568439
  569058
  574836
  576648
  581136
  581316
  585747
  586486
  586488
  587880
  598013
  598041
  607137
  618854
  626287
  629278
  665236
  669458
  683945
  685669
  689660
  700375
  704557
  706286
  713156
  724328
  744930
  776600
  785293
  795538
  807708
  807711
  811001
  814748
]
15.35 ms
(8.73%)
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
  449102
  388280
  502299
  488697
  322014
  406817
  422684
  426052
  458892
  489909
  491842
  480490
  474854
  498051
  513693
  500311
  535204
  568439
  689660
  713156
  700375
  552483
  569058
  607137
  585747
  618854
  629278
  776600
  795538
  811001
  744930
  785293
  382726
  190925
  424494
  449114
  480477
  504405
  508780
  487779
  515285
  515294
  519620
  516831
  523635
  203528
  441874
  444629
  485208
  475040
  548581
  552129
  581136
  547835
  548571
  685669
  683945
  665236
  704557
  581316
  586488
  598041
  626287
  807711
  807708
  724328
  706286
  90684
  469709
  472641
  428381
  461232
  468036
  401126
  472438
  507351
  486562
  490908
  508782
  490879
  492521
  505013
  401615
  419497
  466765
  480468
  480475
  498023
  498025
  498066
  503047
  506522
  515931
  542084
  563050
  553723
  565847
  576648
  552362
  574836
  669458
  563623
  586486
  598013
  587880
  416185
  456889
  458878
  469914
  505202
  486422
  492261
  491393
  491395
  515276
  515306
  492595
  443563
  422686
  814748
]
3.08 ms
(1.76%)
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
  90684
  190925
  203528
  322014
  382726
  388280
  401126
  401615
  406817
  416185
  419497
  422684
  422686
  424494
  426052
  428381
  441874
  443563
  444629
  449102
  449114
  456889
  458878
  458892
  461232
  466765
  468036
  469709
  469914
  472438
  472641
  474854
  475040
  480468
  480475
  480477
  480490
  485208
  486422
  486562
  487779
  488697
  489909
  490879
  490908
  491393
  491395
  491842
  492261
  492521
  492595
  498023
  498025
  498051
  498066
  500311
  502299
  503047
  504405
  505013
  505202
  506522
  507351
  508780
  508782
  513693
  515276
  515285
  515294
  515306
  515931
  516831
  519620
  523635
  535204
  542084
  547835
  548571
  548581
  552129
  552362
  552483
  553723
  563050
  563623
  565847
  568439
  569058
  574836
  576648
  581136
  581316
  585747
  586486
  586488
  587880
  598013
  598041
  607137
  618854
  626287
  629278
  665236
  669458
  683945
  685669
  689660
  700375
  704557
  706286
  713156
  724328
  744930
  776600
  785293
  795538
  807708
  807711
  811001
  814748
]
2.21 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "врачу"
]
1.76 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "врач"
]
1.51 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "врач"
]
1.46 ms
(0.83%)
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.