Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
114.59 ms
(82.01%)
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
  382839
  413524
  413808
  421915
  423517
  428833
  428867
  429867
  432393
  433429
  433441
  435600
  439676
  451507
  453091
  455034
  455479
  459098
  460124
  466402
  466878
  468278
  472569
  473460
  474867
  475752
  475951
  477554
  477555
  478990
  494684
  499840
  515535
  515550
  515618
  515634
  515702
  516393
  516937
  517222
  517813
  519371
  522184
  522795
  523824
  524774
  526569
  527176
  528345
  531724
  535089
  538009
  540713
  542978
  543253
  543400
  543774
  545490
  545498
  545645
  546213
  546906
  546908
  547827
  552757
  555044
  556467
  557244
  559188
  560064
  561526
  562905
  564381
  565691
  569002
  571128
  572712
  573388
  573746
  578106
  578531
  584366
  589129
  591972
  593416
  596520
  601118
  605108
  617781
  618856
  622321
  629208
  663399
  663474
  663490
  663912
  665386
  666719
  670974
  694308
  725527
  730688
  751570
  761517
  764604
  771004
  801087
  824258
]
15.68 ms
(11.22%)
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
  433441
  413808
  473460
  515618
  535089
  515550
  515702
  531724
  540713
  560064
  663474
  663912
  694308
  545490
  564381
  622321
  629208
  591972
  596520
  764604
  751570
  428833
  433429
  453091
  382839
  435600
  466402
  517813
  519371
  527176
  423517
  771004
  451507
  824258
  459098
  460124
  474867
  515634
  517222
  515535
  516937
  494684
  543400
  543253
  546906
  559188
  578106
  542978
  664464
  665386
  666719
  545498
  546908
  593416
  801087
  725527
  730688
  761517
  605108
  468278
  478990
  428867
  499840
  522184
  526569
  584366
  466878
  472569
  475752
  556467
  557244
  543774
  569002
  571128
  545645
  562905
  670974
  546213
  552757
  555044
  589129
  601118
  617781
  455034
  561526
  547827
  572712
  663399
  663490
  413524
  429867
  432393
  477555
  522795
  523824
  516393
  538009
  524774
  573746
  578531
  573388
  455479
  421915
  528345
  477554
  565691
  618856
  439676
  475951
]
2.73 ms
(1.95%)
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
  382839
  413524
  413808
  421915
  423517
  428833
  428867
  429867
  432393
  433429
  433441
  435600
  439676
  451507
  453091
  455034
  455479
  459098
  460124
  466402
  466878
  468278
  472569
  473460
  474867
  475752
  475951
  477554
  477555
  478990
  494684
  499840
  515535
  515550
  515618
  515634
  515702
  516393
  516937
  517222
  517813
  519371
  522184
  522795
  523824
  524774
  526569
  527176
  528345
  531724
  535089
  538009
  540713
  542978
  543253
  543400
  543774
  545490
  545498
  545645
  546213
  546906
  546908
  547827
  552757
  555044
  556467
  557244
  559188
  560064
  561526
  562905
  564381
  565691
  569002
  571128
  572712
  573388
  573746
  578106
  578531
  584366
  589129
  591972
  593416
  596520
  601118
  605108
  617781
  618856
  622321
  629208
  663399
  663474
  663490
  663912
  665386
  666719
  670974
  694308
  725527
  730688
  751570
  761517
  764604
  771004
  801087
  824258
]
1.91 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "legs milf"
]
1.68 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "legs milf"
]
1.49 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "legs milf"
]

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.