Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.79 ms
(86.36%)
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
  233443
  389630
  417290
  424103
  441823
  442162
  443715
  444241
  459081
  492991
  493462
  496690
  498915
  499552
  500019
  503472
  503501
  508797
  509163
  516198
  524194
  524237
  525679
  533695
  542158
  546011
  547224
  549576
  549602
  556719
  579101
  587450
  597448
  618769
  619881
  632831
  644178
  655547
  659212
  661933
  663218
  663835
  663842
  664689
  670019
  675179
  675185
  678611
  678670
  679235
  682872
  683669
  684411
  697217
  703736
  705018
  705732
  711364
  716127
  719385
  722031
  722130
  723909
  725431
  725498
  732582
  732830
  735110
  736739
  741122
  742918
  744416
  746566
  747965
  756520
  757835
  759061
  761770
  764057
  765495
  766317
  766358
  766497
  768711
  771229
  771897
  773215
  778567
  780290
  786626
  787654
  790260
  790649
  791658
  791723
  791756
  791835
  792223
  792308
  792748
  793064
  793847
  794773
  795929
  797581
  797614
  802225
  803966
  809640
  812303
  816690
  816706
  817418
  823654
  824293
  824774
  825360
  826995
  827128
  827337
]
11.55 ms
(7.87%)
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
  778567
  675179
  761770
  678611
  809640
  792223
  790260
  705732
  793847
  682872
  663835
  670019
  587450
  524237
  546011
  725431
  233443
  825360
  703736
  659212
  549602
  683669
  722130
  757835
  771897
  719385
  791835
  766317
  459081
  493462
  663842
  679235
  771229
  816706
  827128
  812303
  759061
  498915
  524194
  684411
  632831
  826995
  542158
  766497
  736739
  747965
  791756
  786626
  793064
  797581
  773215
  579101
  618769
  764057
  711364
  792308
  732582
  549576
  824774
  816690
  722031
  619881
  780290
  791658
  742918
  765495
  525679
  499552
  802225
  705018
  741122
  508797
  556719
  675185
  597448
  787654
  744416
  725498
  746566
  795929
  417290
  791723
  723909
  443715
  516198
  444241
  678670
  503472
  503501
  823654
  824293
  817418
  827337
  533695
  547224
  663218
  664689
  655547
  716127
  790649
  766358
  732830
  756520
  768711
  735110
  792748
  794773
  803966
  424103
  442162
  509163
  697217
  644178
  797614
  496690
  441823
  500019
  661933
  389630
  492991
]
2.03 ms
(1.38%)
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
  233443
  389630
  417290
  424103
  441823
  442162
  443715
  444241
  459081
  492991
  493462
  496690
  498915
  499552
  500019
  503472
  503501
  508797
  509163
  516198
  524194
  524237
  525679
  533695
  542158
  546011
  547224
  549576
  549602
  556719
  579101
  587450
  597448
  618769
  619881
  632831
  644178
  655547
  659212
  661933
  663218
  663835
  663842
  664689
  670019
  675179
  675185
  678611
  678670
  679235
  682872
  683669
  684411
  697217
  703736
  705018
  705732
  711364
  716127
  719385
  722031
  722130
  723909
  725431
  725498
  732582
  732830
  735110
  736739
  741122
  742918
  744416
  746566
  747965
  756520
  757835
  759061
  761770
  764057
  765495
  766317
  766358
  766497
  768711
  771229
  771897
  773215
  778567
  780290
  786626
  787654
  790260
  790649
  791658
  791723
  791756
  791835
  792223
  792308
  792748
  793064
  793847
  794773
  795929
  797581
  797614
  802225
  803966
  809640
  812303
  816690
  816706
  817418
  823654
  824293
  824774
  825360
  826995
  827128
  827337
]
1.87 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ðÂðÁð¢Ðüð║ð░ÐÅ Ðüð┐ðÁÐÇð╝ð░ ÐÇÐâÐüð║ð¥ð%ÔǪ"
]
1.72 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женск сперм русск"
]
1.43 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "женск сперм русск"
]
1.41 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.