Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
191.09 ms
(89.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
  79962
  338997
  394161
  398525
  441811
  452418
  456276
  489255
  489260
  526317
  535800
  545254
  548831
  560455
  560793
  575627
  578237
  578559
  588172
  593794
  593821
  601855
  604848
  614574
  614900
  615156
  616014
  616344
  616809
  626449
  626708
  628229
  636137
  655519
  670212
  672783
  675450
  693326
  695780
  696720
  697613
  697722
  700868
  700874
  707516
  707901
  708337
  710177
  710670
  715779
  717972
  719280
  726385
  727511
  728832
  729255
  729273
  731117
  731702
  733062
  733096
  734129
  739592
  742565
  745333
  749913
  761435
  763776
  764603
  764696
  768151
  768863
  769429
  778153
  778912
  779582
  780427
  780726
  781032
  782359
  787249
  787430
  787473
  790942
  791009
  793793
  795796
  796001
  796032
  796051
  797208
  798537
  798566
  799514
  800043
  800757
  800918
  801699
  802137
  802281
  803692
  804040
  805626
  806712
  806872
  811438
  813632
  816128
  816653
  817728
  818693
  824004
  824018
  824847
  825384
  826071
  826374
  826555
  827520
]
12.49 ms
(5.82%)
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
  780726
  394161
  816128
  824018
  813632
  816653
  826374
  827520
  817728
  818693
  717972
  719280
  779582
  780427
  781032
  787473
  793793
  802281
  804040
  780348
  791009
  801699
  727511
  734129
  742565
  761435
  768863
  795796
  796001
  797208
  798537
  800918
  803692
  806872
  729255
  739592
  745333
  728832
  733096
  749913
  763776
  764696
  768151
  787430
  796032
  800757
  806712
  811438
  79962
  456276
  790942
  787249
  778912
  604848
  802137
  616344
  441811
  489255
  535800
  655519
  697722
  700874
  707901
  670212
  675450
  693326
  696720
  672783
  700868
  588172
  593794
  593821
  601855
  615156
  616809
  626708
  628229
  636137
  614574
  616014
  778153
  729273
  731117
  769429
  726385
  731702
  733062
  764603
  614900
  626449
  697613
  707516
  782359
  799514
  805626
  452418
  489260
  526317
  575627
  548831
  545254
  710177
  800043
  796051
  798566
  715779
  695780
  560793
  578237
  338997
  398525
  825384
  826555
  824004
  824847
  826071
  560455
  578559
  710670
  708337
]
3.74 ms
(1.74%)
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
  79962
  338997
  394161
  398525
  441811
  452418
  456276
  489255
  489260
  526317
  535800
  545254
  548831
  560455
  560793
  575627
  578237
  578559
  588172
  593794
  593821
  601855
  604848
  614574
  614900
  615156
  616014
  616344
  616809
  626449
  626708
  628229
  636137
  655519
  670212
  672783
  675450
  693326
  695780
  696720
  697613
  697722
  700868
  700874
  707516
  707901
  708337
  710177
  710670
  715779
  717972
  719280
  726385
  727511
  728832
  729255
  729273
  731117
  731702
  733062
  733096
  734129
  739592
  742565
  745333
  749913
  761435
  763776
  764603
  764696
  768151
  768863
  769429
  778153
  778912
  779582
  780427
  780726
  781032
  782359
  787249
  787430
  787473
  790942
  791009
  793793
  795796
  796001
  796032
  796051
  797208
  798537
  798566
  799514
  800043
  800757
  800918
  801699
  802137
  802281
  803692
  804040
  805626
  806712
  806872
  811438
  813632
  816128
  816653
  817728
  818693
  824004
  824018
  824847
  825384
  826071
  826374
  826555
  827520
]
2.03 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.97 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum mouth домашн любительск"
]
1.74 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum mouth homemade"
]
1.63 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum mouth домашн любительск"
]

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.