Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.27 ms
(86.43%)
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
  396902
  398533
  453849
  481117
  485069
  500363
  530287
  541134
  547720
  553831
  564588
  585416
  592540
  592680
  592962
  596965
  602051
  602775
  604989
  609732
  617914
  625617
  626135
  626265
  627583
  630016
  632522
  636765
  637409
  644216
  644622
  646079
  651393
  655485
  658966
  670569
  675454
  690633
  691148
  695415
  698826
  700196
  702300
  713008
  714326
  714589
  715592
  716346
  716999
  718079
  718396
  718453
  721605
  721894
  723575
  723848
  728712
  730614
  731792
  733481
  736009
  736167
  737538
  740906
  743024
  744190
  747798
  748880
  750652
  752288
  755123
  756513
  757453
  757572
  757629
  757654
  757941
  762499
  762964
  763424
  764659
  765839
  765976
  768888
  771400
  771437
  771778
  772193
  773782
  776769
  777755
  778776
  780345
  781105
  781562
  781773
  782067
  782897
  787456
  787905
  788279
  789030
  789380
  790161
  791478
  791753
  792209
  792360
  793113
  795429
  796016
  797145
  797368
  799089
  799840
  801717
  804177
  804486
  813700
]
13.06 ms
(8.04%)
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
  485069
  718453
  778252
  782897
  789380
  733481
  747798
  757941
  772193
  771778
  799089
  691148
  813700
  718079
  778776
  736167
  744190
  797145
  757629
  743024
  755123
  773782
  780345
  782067
  804486
  481117
  547720
  646079
  651393
  698826
  700196
  713008
  670569
  585416
  592540
  632522
  637409
  592680
  626135
  644622
  636765
  596965
  604989
  627583
  790161
  765976
  757453
  625617
  714326
  530287
  398533
  564588
  721894
  644216
  792209
  781562
  792360
  797368
  757572
  736009
  737538
  757654
  771437
  776769
  777755
  787905
  396902
  718396
  714589
  781773
  788279
  796016
  799840
  731792
  787456
  748880
  756513
  723848
  763424
  715592
  716999
  781105
  791478
  795429
  553831
  675454
  690633
  695415
  702300
  655485
  658966
  617914
  592962
  609732
  602051
  630016
  602775
  626265
  541134
  791753
  500363
  723575
  453849
  716346
  721605
  789030
  793113
  804177
  730614
  752288
  762499
  762964
  771400
  765839
  728712
  768888
  740906
  750652
  764659
  801717
]
2.30 ms
(1.42%)
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
  396902
  398533
  453849
  481117
  485069
  500363
  530287
  541134
  547720
  553831
  564588
  585416
  592540
  592680
  592962
  596965
  602051
  602775
  604989
  609732
  617914
  625617
  626135
  626265
  627583
  630016
  632522
  636765
  637409
  644216
  644622
  646079
  651393
  655485
  658966
  670569
  675454
  690633
  691148
  695415
  698826
  700196
  702300
  713008
  714326
  714589
  715592
  716346
  716999
  718079
  718396
  718453
  721605
  721894
  723575
  723848
  728712
  730614
  731792
  733481
  736009
  736167
  737538
  740906
  743024
  744190
  747798
  748880
  750652
  752288
  755123
  756513
  757453
  757572
  757629
  757654
  757941
  762499
  762964
  763424
  764659
  765839
  765976
  768888
  771400
  771437
  771778
  772193
  773782
  776769
  777755
  778776
  780345
  781105
  781562
  781773
  782067
  782897
  787456
  787905
  788279
  789030
  789380
  790161
  791478
  791753
  792209
  792360
  793113
  795429
  796016
  797145
  797368
  799089
  799840
  801717
  804177
  804486
  813700
]
1.91 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашнее отель"
]
1.75 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск отел"
]
1.59 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.87%)
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.