Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.27 ms
(85.52%)
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
  6056
  14392
  130022
  383288
  389987
  393673
  396368
  396606
  401252
  405446
  413786
  416226
  430467
  443424
  446752
  449032
  459668
  459830
  461757
  465190
  465710
  476111
  477472
  488894
  495407
  501589
  531530
  533476
  536227
  536966
  537497
  537896
  551552
  557877
  560223
  562502
  563278
  583371
  601756
  604172
  605590
  607436
  622682
  629279
  631086
  634207
  637103
  642727
  643050
  644000
  646001
  648587
  649092
  665338
  665361
  665932
  666779
  668157
  671409
  673540
  675007
  675022
  675425
  676116
  682220
  682275
  699425
  707360
  715251
  716435
  717076
  719391
  719915
  722491
  723357
  723512
  726633
  731371
  733586
  739752
  741682
  742964
  743851
  746470
  746794
  747144
  749043
  759725
  770120
  773866
  773870
  776244
  781773
  781811
  792803
  795482
  796282
  798215
  800870
  801511
  801515
  802978
  805554
  809209
  809458
  813121
  815812
  816685
  816832
  817093
  818490
  823758
  823983
  825951
  826173
  826231
  828115
  828369
]
11.32 ms
(7.86%)
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
  488894
  14392
  396368
  476111
  6056
  825951
  828369
  816832
  823983
  648587
  716435
  682220
  666779
  601756
  781773
  792803
  743851
  770120
  396606
  707360
  604172
  537497
  130022
  393673
  401252
  665932
  815812
  533476
  676116
  531530
  537896
  637103
  634207
  675007
  501589
  405446
  816685
  430467
  461757
  646001
  643050
  383288
  823758
  826173
  551552
  801515
  801511
  749043
  773870
  795482
  667269
  622682
  560223
  741682
  746794
  776244
  668157
  731371
  465710
  459830
  446752
  536227
  563278
  719391
  605590
  465190
  665361
  733586
  746470
  562502
  607436
  828115
  800870
  817093
  536966
  443424
  673540
  557877
  449032
  583371
  826231
  818490
  649092
  719915
  665338
  666827
  671409
  682275
  717076
  722491
  723357
  629279
  644000
  809458
  813121
  796282
  798215
  773866
  809209
  759725
  739752
  726633
  675425
  675022
  742964
  802978
  477472
  699425
  631086
  781811
  642727
  723512
  805554
  747144
  389987
  413786
  416226
  459668
  495407
  715251
]
2.77 ms
(1.92%)
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
  6056
  14392
  130022
  383288
  389987
  393673
  396368
  396606
  401252
  405446
  413786
  416226
  430467
  443424
  446752
  449032
  459668
  459830
  461757
  465190
  465710
  476111
  477472
  488894
  495407
  501589
  531530
  533476
  536227
  536966
  537497
  537896
  551552
  557877
  560223
  562502
  563278
  583371
  601756
  604172
  605590
  607436
  622682
  629279
  631086
  634207
  637103
  642727
  643050
  644000
  646001
  648587
  649092
  665338
  665361
  665932
  666779
  668157
  671409
  673540
  675007
  675022
  675425
  676116
  682220
  682275
  699425
  707360
  715251
  716435
  717076
  719391
  719915
  722491
  723357
  723512
  726633
  731371
  733586
  739752
  741682
  742964
  743851
  746470
  746794
  747144
  749043
  759725
  770120
  773866
  773870
  776244
  781773
  781811
  792803
  795482
  796282
  798215
  800870
  801511
  801515
  802978
  805554
  809209
  809458
  813121
  815812
  816685
  816832
  817093
  818490
  823758
  823983
  825951
  826173
  826231
  828115
  828369
]
1.95 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big tits interracial"
]
1.79 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ межрасов"
]
1.60 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.99%)
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.