Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.55 ms
(81.64%)
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
  381833
  388545
  389630
  391836
  399218
  415823
  416022
  419584
  420432
  421582
  424089
  424099
  424192
  424562
  425586
  427018
  429733
  432184
  432345
  435510
  435548
  435880
  435962
  438444
  438756
  439103
  439268
  439334
  443927
  447467
  448588
  449377
  451057
  451592
  455475
  460476
  461955
  463687
  464533
  465835
  466344
  467636
  467841
  468509
  469661
  470225
  470308
  471981
  472815
  475216
  481087
  481340
  484923
  488887
  493553
  496054
  500019
  500616
  503482
  504816
  508797
  511933
  517082
  526656
  526871
  534393
  543648
  543743
  543759
  546981
  548175
  549573
  549804
  551555
  552408
  553240
  554488
  555808
  558117
  558324
  568202
  568814
  569393
  573289
  575560
  576285
  579101
  579426
  579587
  580018
  582576
  595398
  596606
  598503
  598726
  599180
  600124
  631255
  637037
  650290
  661933
  672841
  694660
  701665
  722303
  732131
  753604
  753658
  758242
  759061
  760427
  768430
  774096
  778242
  788027
  791038
  791507
  791913
  792282
  825791
]
17.78 ms
(11.75%)
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
  551555
  637037
  778242
  788027
  759061
  774096
  753658
  753604
  760427
  768430
  791038
  381833
  424192
  825791
  722303
  467841
  481087
  468509
  391836
  461955
  526656
  508797
  424099
  500019
  543743
  548175
  543648
  543759
  579101
  555808
  575560
  650290
  672841
  661933
  694660
  598726
  600124
  596606
  631255
  791913
  791507
  758242
  732131
  701665
  792282
  429733
  465835
  415823
  425586
  389630
  427018
  451592
  466344
  517082
  526871
  496054
  534393
  503482
  451057
  463687
  388545
  438444
  439103
  439334
  464533
  493553
  449377
  470225
  488887
  472815
  484923
  500616
  511933
  504816
  467636
  549804
  552408
  554488
  558324
  579426
  579587
  549573
  558117
  568814
  573289
  546981
  569393
  553240
  568202
  576285
  580018
  582576
  595398
  598503
  599180
  399218
  424562
  432184
  432345
  438756
  443927
  447467
  448588
  455475
  460476
  469661
  470308
  471981
  475216
  481340
  416022
  419584
  420432
  421582
  424089
  435510
  435548
  435880
  435962
  439268
]
2.29 ms
(1.51%)
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
  381833
  388545
  389630
  391836
  399218
  415823
  416022
  419584
  420432
  421582
  424089
  424099
  424192
  424562
  425586
  427018
  429733
  432184
  432345
  435510
  435548
  435880
  435962
  438444
  438756
  439103
  439268
  439334
  443927
  447467
  448588
  449377
  451057
  451592
  455475
  460476
  461955
  463687
  464533
  465835
  466344
  467636
  467841
  468509
  469661
  470225
  470308
  471981
  472815
  475216
  481087
  481340
  484923
  488887
  493553
  496054
  500019
  500616
  503482
  504816
  508797
  511933
  517082
  526656
  526871
  534393
  543648
  543743
  543759
  546981
  548175
  549573
  549804
  551555
  552408
  553240
  554488
  555808
  558117
  558324
  568202
  568814
  569393
  573289
  575560
  576285
  579101
  579426
  579587
  580018
  582576
  595398
  596606
  598503
  598726
  599180
  600124
  631255
  637037
  650290
  661933
  672841
  694660
  701665
  722303
  732131
  753604
  753658
  758242
  759061
  760427
  768430
  774096
  778242
  788027
  791038
  791507
  791913
  792282
  825791
]
2.14 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbation russian"
]
1.97 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац русск"
]
1.68 ms
(1.11%)
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.