Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.11 ms
(80.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
  88664
  241603
  287436
  311897
  405712
  416824
  425143
  439532
  444684
  444743
  444795
  446529
  448816
  450518
  463855
  471668
  474874
  476417
  477812
  478775
  479768
  482375
  482773
  485468
  489305
  495126
  499856
  504085
  511196
  511372
  514254
  521438
  521850
  522043
  522142
  526553
  530497
  530791
  530941
  531103
  531107
  531248
  532345
  532779
  532960
  536310
  536608
  537250
  537663
  541832
  541851
  542583
  545648
  550203
  552701
  564201
  567062
  580160
  586933
  590263
  590507
  590908
  592702
  598675
  599894
  599916
  601575
  601691
  610083
  611572
  621125
  622066
  629630
  631203
  632794
  633163
  633521
  633767
  633768
  636303
  639762
  642038
  644962
  647322
  648583
  649583
  650175
  668151
  674077
  675019
  676097
  677801
  677986
  678063
  678128
  678144
  678161
  678533
  679728
  704526
  708443
  716900
  723618
  723620
  745384
  747468
  777982
  780189
  787075
  787466
  802899
  808155
  808691
  814270
  814971
  816547
  816669
  818387
  819565
  821409
]
21.06 ms
(11.99%)
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
  780189
  777982
  444743
  723618
  814971
  482773
  495126
  530497
  531103
  531248
  511196
  567062
  580160
  649583
  592702
  598675
  599894
  633767
  599916
  601575
  611572
  631203
  808155
  787075
  802899
  808691
  747468
  311897
  668151
  88664
  444795
  471668
  537663
  526553
  564201
  504085
  586933
  448816
  521438
  405712
  723620
  644962
  482375
  532779
  536608
  531107
  532960
  477812
  545648
  550203
  542583
  650175
  678144
  678161
  679728
  677801
  677986
  678533
  704526
  647322
  675019
  639762
  636303
  610083
  633521
  633768
  642038
  708443
  463855
  478775
  474874
  476417
  590908
  287436
  816669
  489305
  601691
  416824
  541832
  674077
  633163
  537250
  541851
  648583
  552701
  590507
  632794
  590263
  629630
  439532
  511372
  446529
  521850
  532345
  530791
  530941
  536310
  678063
  676097
  678128
  716900
  425143
  479768
  522043
  522142
  745384
  622066
  787466
  621125
  241603
  444684
  814270
  818387
  819565
  821409
  816547
  485468
  450518
  499856
  514254
]
4.59 ms
(2.61%)
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
  88664
  241603
  287436
  311897
  405712
  416824
  425143
  439532
  444684
  444743
  444795
  446529
  448816
  450518
  463855
  471668
  474874
  476417
  477812
  478775
  479768
  482375
  482773
  485468
  489305
  495126
  499856
  504085
  511196
  511372
  514254
  521438
  521850
  522043
  522142
  526553
  530497
  530791
  530941
  531103
  531107
  531248
  532345
  532779
  532960
  536310
  536608
  537250
  537663
  541832
  541851
  542583
  545648
  550203
  552701
  564201
  567062
  580160
  586933
  590263
  590507
  590908
  592702
  598675
  599894
  599916
  601575
  601691
  610083
  611572
  621125
  622066
  629630
  631203
  632794
  633163
  633521
  633767
  633768
  636303
  639762
  642038
  644962
  647322
  648583
  649583
  650175
  668151
  674077
  675019
  676097
  677801
  677986
  678063
  678128
  678144
  678161
  678533
  679728
  704526
  708443
  716900
  723618
  723620
  745384
  747468
  777982
  780189
  787075
  787466
  802899
  808155
  808691
  814270
  814971
  816547
  816669
  818387
  819565
  821409
]
2.23 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.07 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo dick"
]
1.98 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд член"
]
1.56 ms
(0.89%)
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.