Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.48 ms
(89.95%)
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
  7157
  184943
  185011
  185123
  204992
  382396
  383005
  385096
  386331
  389356
  389518
  390190
  390258
  390304
  391064
  399627
  401489
  404737
  406435
  407549
  409305
  415934
  419115
  437437
  446791
  447488
  454044
  454974
  456184
  456579
  463867
  464195
  464474
  465886
  481652
  487346
  489410
  490070
  493031
  493814
  501750
  502006
  503994
  506795
  507171
  510033
  510041
  518767
  518948
  520417
  521918
  523971
  531416
  531725
  538343
  538675
  543791
  551340
  551405
  551409
  551432
  551741
  558383
  560101
  562881
  568363
  569827
  572013
  575118
  583633
  585254
  598301
  599327
  608595
  610226
  643436
  643535
  651930
  651932
  652206
  653497
  662333
  663050
  663957
  671703
  677030
  689591
  696102
  703506
  707346
  712462
  714471
  721200
  723077
  726511
  727717
  732379
  744469
  744601
  744631
  747347
  748663
  750782
  753784
  781022
  784702
  797499
  800069
  800296
  802737
  805961
  808650
  810031
  814806
  815691
  818725
  825210
  826902
  828466
  828714
]
14.34 ms
(6.13%)
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
  723077
  714471
  797499
  732379
  781022
  800069
  385096
  386331
  456184
  507171
  531725
  390258
  456579
  551741
  562881
  726511
  399627
  401489
  406435
  454974
  481652
  506795
  510041
  503994
  828466
  663050
  464195
  184943
  7157
  389518
  599327
  608595
  404737
  464474
  818725
  677030
  643436
  390190
  185011
  583633
  651930
  663957
  703506
  712462
  652206
  653497
  551405
  800296
  805961
  784702
  748663
  744469
  744631
  810031
  419115
  826902
  707346
  721200
  747347
  825210
  815691
  828714
  753784
  531416
  407549
  502006
  493031
  572013
  560101
  671703
  689591
  585254
  802737
  447488
  391064
  185123
  389356
  415934
  501750
  538343
  493814
  521918
  523971
  814806
  454044
  465886
  558383
  543791
  551409
  696102
  610226
  808650
  750782
  744601
  390304
  437437
  446791
  538675
  518767
  510033
  520417
  489410
  382396
  518948
  463867
  487346
  490070
  662333
  651932
  643535
  568363
  569827
  598301
  727717
  383005
  409305
  204992
  551432
  575118
  551340
]
2.61 ms
(1.12%)
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
  7157
  184943
  185011
  185123
  204992
  382396
  383005
  385096
  386331
  389356
  389518
  390190
  390258
  390304
  391064
  399627
  401489
  404737
  406435
  407549
  409305
  415934
  419115
  437437
  446791
  447488
  454044
  454974
  456184
  456579
  463867
  464195
  464474
  465886
  481652
  487346
  489410
  490070
  493031
  493814
  501750
  502006
  503994
  506795
  507171
  510033
  510041
  518767
  518948
  520417
  521918
  523971
  531416
  531725
  538343
  538675
  543791
  551340
  551405
  551409
  551432
  551741
  558383
  560101
  562881
  568363
  569827
  572013
  575118
  583633
  585254
  598301
  599327
  608595
  610226
  643436
  643535
  651930
  651932
  652206
  653497
  662333
  663050
  663957
  671703
  677030
  689591
  696102
  703506
  707346
  712462
  714471
  721200
  723077
  726511
  727717
  732379
  744469
  744601
  744631
  747347
  748663
  750782
  753784
  781022
  784702
  797499
  800069
  800296
  802737
  805961
  808650
  810031
  814806
  815691
  818725
  825210
  826902
  828466
  828714
]
1.85 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "massage big"
]
1.65 ms
(0.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "массаж большие"
]
1.27 ms
(0.54%)
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.