Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.39 ms
(82.55%)
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
  4377
  8824
  78942
  80203
  117844
  366004
  383598
  385035
  385841
  387541
  389060
  391155
  391596
  392181
  392547
  393621
  394498
  394586
  395450
  396432
  396794
  396834
  397113
  399806
  401599
  402596
  407165
  409702
  413335
  415344
  416299
  418443
  420368
  423459
  423600
  424209
  424612
  426272
  427233
  427911
  428100
  429567
  437845
  437901
  441424
  442649
  443905
  450126
  453659
  455997
  457408
  458608
  459083
  460545
  464954
  465459
  476635
  477386
  477565
  479088
  482944
  484304
  485029
  485343
  488520
  494682
  496194
  498317
  505947
  518806
  521533
  523136
  543596
  550519
  551602
  559672
  564998
  578797
  583859
  590612
  597171
  601229
  603668
  609707
  613898
  620249
  621777
  623395
  630725
  641134
  661920
  666466
  680436
  684693
  686384
  692280
  695080
  700476
  700824
  701661
  721484
  727507
  732579
  732792
  738121
  751508
  758337
  760509
  761916
  768041
  779895
  791248
  791881
  792308
  792653
  792746
  803873
  809790
  810136
  811710
]
15.34 ms
(10.52%)
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
  613898
  803873
  666466
  543596
  590612
  396432
  518806
  485343
  385035
  117844
  8824
  441424
  420368
  551602
  760509
  809790
  738121
  701661
  792746
  415344
  428100
  641134
  680436
  488520
  484304
  661920
  684693
  686384
  692280
  695080
  721484
  761916
  700476
  393621
  482944
  791881
  768041
  792653
  383598
  80203
  395450
  387541
  429567
  409702
  450126
  621777
  791248
  399806
  424209
  459083
  496194
  620249
  700824
  603668
  477565
  597171
  423600
  426272
  427911
  78942
  396794
  397113
  416299
  442649
  443905
  407165
  455997
  505947
  583859
  550519
  751508
  758337
  401599
  477386
  453659
  4377
  779895
  389060
  402596
  413335
  418443
  460545
  465459
  476635
  811710
  732792
  394498
  521533
  458608
  609707
  437901
  392547
  427233
  423459
  485029
  564998
  623395
  727507
  792308
  810136
  396834
  391155
  424612
  366004
  498317
  437845
  392181
  457408
  494682
  601229
  523136
  385841
  559672
  732579
  630725
  578797
  394586
  391596
  464954
  479088
]
2.91 ms
(2.00%)
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
  4377
  8824
  78942
  80203
  117844
  366004
  383598
  385035
  385841
  387541
  389060
  391155
  391596
  392181
  392547
  393621
  394498
  394586
  395450
  396432
  396794
  396834
  397113
  399806
  401599
  402596
  407165
  409702
  413335
  415344
  416299
  418443
  420368
  423459
  423600
  424209
  424612
  426272
  427233
  427911
  428100
  429567
  437845
  437901
  441424
  442649
  443905
  450126
  453659
  455997
  457408
  458608
  459083
  460545
  464954
  465459
  476635
  477386
  477565
  479088
  482944
  484304
  485029
  485343
  488520
  494682
  496194
  498317
  505947
  518806
  521533
  523136
  543596
  550519
  551602
  559672
  564998
  578797
  583859
  590612
  597171
  601229
  603668
  609707
  613898
  620249
  621777
  623395
  630725
  641134
  661920
  666466
  680436
  684693
  686384
  692280
  695080
  700476
  700824
  701661
  721484
  727507
  732579
  732792
  738121
  751508
  758337
  760509
  761916
  768041
  779895
  791248
  791881
  792308
  792653
  792746
  803873
  809790
  810136
  811710
]
1.90 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"муж трахает любовникÐ%…"
]
1.85 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен секс любовник"
]
1.84 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.10%)
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.