Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
236.20 ms
(90.84%)
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
  30420
  88505
  88614
  186858
  225591
  226412
  336085
  383388
  416240
  419616
  423703
  458203
  465489
  465579
  467841
  473764
  489377
  503745
  529865
  530692
  531732
  544147
  549308
  549502
  549515
  550625
  553746
  555226
  559863
  560884
  568803
  574342
  575378
  576540
  581645
  585016
  589593
  593169
  593798
  595166
  601872
  608378
  618393
  619606
  628261
  632340
  632901
  633092
  633406
  637318
  643423
  645844
  649437
  650113
  650948
  651536
  651731
  652881
  657536
  660283
  661653
  666492
  669896
  669941
  674202
  678780
  683698
  686338
  689988
  700907
  703218
  704613
  705478
  708226
  713940
  722360
  729204
  731119
  737106
  740567
  742536
  745936
  754638
  757003
  757239
  760315
  761944
  763052
  764268
  768025
  768234
  769122
  774774
  778448
  782831
  801810
  801937
  803886
  804239
  805234
  807028
  807825
  810087
  810390
  810484
  811319
  811914
  812038
  812529
  812551
  813791
  816147
  819665
  823778
  823890
  824000
  824103
  824663
  825582
  826873
]
13.13 ms
(5.05%)
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
  383388
  416240
  608378
  810390
  423703
  473764
  465489
  544147
  757003
  549308
  703218
  30420
  585016
  530692
  574342
  705478
  650113
  722360
  549502
  568803
  628261
  805234
  782831
  760315
  632901
  807028
  689988
  704613
  778448
  812038
  225591
  553746
  489377
  186858
  88505
  645844
  649437
  708226
  737106
  742536
  764268
  465579
  419616
  226412
  336085
  88614
  824103
  824663
  825582
  816147
  813791
  819665
  823890
  824000
  826873
  458203
  529865
  549515
  559863
  575378
  576540
  652881
  700907
  683698
  666492
  669896
  678780
  589593
  593798
  632340
  593169
  595166
  618393
  619606
  637318
  601872
  643423
  774774
  810484
  812529
  803886
  811319
  811914
  769122
  812551
  729204
  768234
  761944
  768025
  754638
  763052
  731119
  745936
  633092
  633406
  801810
  804239
  807825
  467841
  823778
  555226
  757239
  740567
  801937
  810087
  503745
  531732
  560884
  581645
  550625
  651731
  674202
  686338
  661653
  669941
  713940
  650948
  651536
  657536
  660283
]
3.27 ms
(1.26%)
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
  30420
  88505
  88614
  186858
  225591
  226412
  336085
  383388
  416240
  419616
  423703
  458203
  465489
  465579
  467841
  473764
  489377
  503745
  529865
  530692
  531732
  544147
  549308
  549502
  549515
  550625
  553746
  555226
  559863
  560884
  568803
  574342
  575378
  576540
  581645
  585016
  589593
  593169
  593798
  595166
  601872
  608378
  618393
  619606
  628261
  632340
  632901
  633092
  633406
  637318
  643423
  645844
  649437
  650113
  650948
  651536
  651731
  652881
  657536
  660283
  661653
  666492
  669896
  669941
  674202
  678780
  683698
  686338
  689988
  700907
  703218
  704613
  705478
  708226
  713940
  722360
  729204
  731119
  737106
  740567
  742536
  745936
  754638
  757003
  757239
  760315
  761944
  763052
  764268
  768025
  768234
  769122
  774774
  778448
  782831
  801810
  801937
  803886
  804239
  805234
  807028
  807825
  810087
  810390
  810484
  811319
  811914
  812038
  812529
  812551
  813791
  816147
  819665
  823778
  823890
  824000
  824103
  824663
  825582
  826873
]
2.10 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl masturbation toilet"
]
2.09 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.63%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк мастурбац туалет"
]
1.59 ms
(0.61%)
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.