Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.15 ms
(53.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
151.49 ms
(39.10%)
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
  392019
  397960
  398740
  403215
  414929
  415303
  415874
  418145
  420295
  426283
  427292
  427722
  428728
  429892
  430366
  435136
  440641
  441355
  443432
  445945
  448854
  450323
  450557
  450930
  451044
  452540
  458115
  460115
  460533
  466601
  467114
  467560
  467588
  467882
  468148
  468817
  473873
  477496
  482839
  483315
  484065
  485468
  485472
  486761
  490953
  493839
  499856
  500288
  502447
  508891
  510834
  513220
  516684
  517710
  527922
  529323
  530383
  530659
  531804
  542588
  544838
  546083
  553215
  558171
  558190
  559281
  559787
  582848
  584418
  588137
  589166
  590696
  592500
  602846
  618041
  623402
  626082
  630558
  633147
  636379
  640813
  645230
  650325
  650476
  653391
  663183
  666672
  667276
  675402
  689010
  712882
  713297
  716965
  721106
  723930
  724470
  730461
  739165
  745345
  748257
  749070
  753960
  782236
  786604
  786876
  788800
  791892
  796712
  796801
  798291
  799268
  800293
  802114
  802914
  805543
  806271
  814429
  815559
  816547
  818387
]
18.83 ms
(4.86%)
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
  440641
  452540
  473873
  435136
  443432
  468148
  451044
  513220
  485472
  589166
  730461
  626082
  798291
  467588
  429892
  544838
  448854
  477496
  516684
  588137
  618041
  713297
  663183
  502447
  415303
  441355
  450557
  458115
  527922
  510834
  558190
  559281
  582848
  666672
  553215
  467560
  493839
  483315
  689010
  420295
  445945
  508891
  559787
  782236
  430366
  450323
  392019
  398740
  428728
  427722
  818387
  815559
  816547
  467114
  468817
  485468
  499856
  531804
  667276
  645230
  721106
  592500
  590696
  630558
  786604
  796801
  806271
  800293
  799268
  805543
  723930
  724470
  749070
  745345
  748257
  739165
  753960
  623402
  633147
  716965
  786876
  788800
  802114
  802914
  403215
  460533
  640813
  500288
  415874
  814429
  530383
  542588
  650325
  712882
  653391
  636379
  791892
  796712
  558171
  584418
  675402
  482839
  397960
  460115
  529323
  517710
  484065
  546083
  602846
  467882
  427292
  418145
  490953
  414929
  466601
  650476
  450930
  426283
  486761
  530659
]
3.77 ms
(0.97%)
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
  392019
  397960
  398740
  403215
  414929
  415303
  415874
  418145
  420295
  426283
  427292
  427722
  428728
  429892
  430366
  435136
  440641
  441355
  443432
  445945
  448854
  450323
  450557
  450930
  451044
  452540
  458115
  460115
  460533
  466601
  467114
  467560
  467588
  467882
  468148
  468817
  473873
  477496
  482839
  483315
  484065
  485468
  485472
  486761
  490953
  493839
  499856
  500288
  502447
  508891
  510834
  513220
  516684
  517710
  527922
  529323
  530383
  530659
  531804
  542588
  544838
  546083
  553215
  558171
  558190
  559281
  559787
  582848
  584418
  588137
  589166
  590696
  592500
  602846
  618041
  623402
  626082
  630558
  633147
  636379
  640813
  645230
  650325
  650476
  653391
  663183
  666672
  667276
  675402
  689010
  712882
  713297
  716965
  721106
  723930
  724470
  730461
  739165
  745345
  748257
  749070
  753960
  782236
  786604
  786876
  788800
  791892
  796712
  796801
  798291
  799268
  800293
  802114
  802914
  805543
  806271
  814429
  815559
  816547
  818387
]
1.88 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge dildo pussy"
]
1.69 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные дилд pussy"
]
1.60 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "огромные дилд pussy"
]

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.