Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.21 ms
(84.74%)
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
  39167
  122661
  142528
  143019
  204778
  213432
  308832
  321450
  329296
  382256
  383239
  387817
  396357
  396789
  398705
  401873
  404020
  407220
  408178
  411812
  491178
  529611
  545260
  547268
  557139
  557146
  562020
  601090
  601116
  616060
  620999
  636506
  641125
  649144
  651000
  680630
  687957
  691230
  691997
  695984
  696067
  700840
  707626
  709242
  710239
  715187
  716809
  717084
  721174
  724666
  726392
  728340
  729225
  730452
  732050
  736380
  741086
  741802
  742216
  743404
  746619
  746678
  747027
  749394
  749399
  749980
  750841
  752516
  752966
  755615
  755842
  764323
  768182
  769450
  776269
  778046
  778939
  779319
  779855
  781004
  781468
  784918
  784977
  785501
  787146
  787924
  790212
  790820
  793456
  793709
  795533
  797305
  797648
  799500
  803008
  803588
  805019
  806532
  807168
  807630
  808132
  809198
  809203
  811467
  813524
  813896
  815614
  818743
  818811
  821372
  822246
  822808
  822913
  823042
  823093
  823135
  823319
  823375
  827891
]
12.06 ms
(8.16%)
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
  729225
  732050
  736380
  122661
  716809
  396789
  204778
  822913
  803008
  142528
  815614
  707626
  651000
  616060
  785501
  790212
  793709
  730452
  749394
  749399
  387817
  401873
  750841
  691997
  715187
  743404
  742216
  749980
  717084
  808132
  769450
  768182
  805019
  601116
  781004
  383239
  411812
  382256
  822246
  601090
  641125
  813524
  778939
  39167
  809198
  793456
  823291
  821372
  823375
  529611
  741802
  396357
  407220
  321450
  778046
  784977
  803588
  809203
  807168
  408178
  547268
  784918
  787146
  822808
  823093
  823319
  818811
  823042
  823135
  827891
  562020
  649144
  696067
  695984
  710239
  721174
  687957
  620999
  787924
  752516
  755615
  755842
  797305
  811467
  747027
  728340
  746678
  752966
  746619
  790820
  797648
  404020
  329296
  557146
  308832
  700840
  741086
  709242
  398705
  818743
  807630
  776269
  781468
  491178
  680630
  545260
  143019
  691230
  724666
  213432
  795533
  764323
  813896
  557139
  726392
  636506
  779855
  779319
  799500
  806532
]
3.11 ms
(2.11%)
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
  39167
  122661
  142528
  143019
  204778
  213432
  308832
  321450
  329296
  382256
  383239
  387817
  396357
  396789
  398705
  401873
  404020
  407220
  408178
  411812
  491178
  529611
  545260
  547268
  557139
  557146
  562020
  601090
  601116
  616060
  620999
  636506
  641125
  649144
  651000
  680630
  687957
  691230
  691997
  695984
  696067
  700840
  707626
  709242
  710239
  715187
  716809
  717084
  721174
  724666
  726392
  728340
  729225
  730452
  732050
  736380
  741086
  741802
  742216
  743404
  746619
  746678
  747027
  749394
  749399
  749980
  750841
  752516
  752966
  755615
  755842
  764323
  768182
  769450
  776269
  778046
  778939
  779319
  779855
  781004
  781468
  784918
  784977
  785501
  787146
  787924
  790212
  790820
  793456
  793709
  795533
  797305
  797648
  799500
  803008
  803588
  805019
  806532
  807168
  807630
  808132
  809198
  809203
  811467
  813524
  813896
  815614
  818743
  818811
  821372
  822246
  822808
  822913
  823042
  823093
  823135
  823319
  823375
  827891
]
2.19 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob big tits"
]
1.82 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс большие сиськ"
]
1.77 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(1.07%)
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.