Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.53 ms
(87.81%)
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
  384588
  401388
  401688
  410356
  410786
  414734
  415101
  417947
  418259
  418554
  420898
  423516
  437441
  442587
  444848
  445752
  446049
  449105
  449260
  449280
  449312
  449313
  451770
  452454
  458870
  464190
  469716
  469720
  471427
  471672
  474428
  476787
  480019
  481961
  482639
  489324
  490509
  505336
  507975
  510362
  511143
  516353
  519744
  520481
  522162
  523717
  524839
  525297
  526313
  553441
  554861
  560967
  567565
  570994
  571769
  576357
  577614
  589583
  589701
  601223
  603294
  604226
  608670
  613038
  617047
  618302
  620174
  624128
  626245
  639184
  648444
  660434
  660572
  685843
  687844
  689981
  690066
  694407
  708399
  709542
  727844
  727882
  732991
  733910
  735772
  739496
  740556
  741160
  748624
  749929
  752000
  757435
  761273
  762812
  763966
  764153
  764160
  765518
  766342
  767786
  769839
  776327
  777838
  784110
  784357
  784735
  787532
  787774
  789771
  792215
  795419
  796194
  796939
  801580
  802908
  803549
  810076
  811571
  813189
  824868
]
12.97 ms
(6.92%)
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
  764153
  767786
  733910
  757435
  813189
  617047
  801580
  414734
  511143
  449313
  469720
  577614
  567565
  787774
  784110
  766342
  639184
  445752
  452454
  523717
  516353
  482639
  474428
  648444
  687844
  589583
  740556
  769839
  776327
  401388
  708399
  660572
  689981
  752000
  784357
  741160
  763966
  444848
  446049
  505336
  608670
  449260
  481961
  520481
  620174
  401688
  423516
  449280
  449312
  489324
  451770
  553441
  576357
  690066
  571769
  626245
  589701
  603294
  601223
  811571
  802908
  739496
  796939
  410786
  437441
  464190
  449105
  418259
  471672
  524839
  490509
  526313
  442587
  480019
  469716
  507975
  660434
  613038
  618302
  604226
  787532
  789771
  727882
  748624
  417947
  471427
  458870
  476787
  519744
  510362
  525297
  554861
  570994
  418554
  420898
  384588
  410356
  694407
  777838
  784735
  765518
  732991
  415101
  522162
  824868
  709542
  685843
  560967
  624128
  792215
  795419
  803549
  727844
  749929
  764160
  796194
  810076
  761273
  762812
  735772
]
2.61 ms
(1.39%)
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
  384588
  401388
  401688
  410356
  410786
  414734
  415101
  417947
  418259
  418554
  420898
  423516
  437441
  442587
  444848
  445752
  446049
  449105
  449260
  449280
  449312
  449313
  451770
  452454
  458870
  464190
  469716
  469720
  471427
  471672
  474428
  476787
  480019
  481961
  482639
  489324
  490509
  505336
  507975
  510362
  511143
  516353
  519744
  520481
  522162
  523717
  524839
  525297
  526313
  553441
  554861
  560967
  567565
  570994
  571769
  576357
  577614
  589583
  589701
  601223
  603294
  604226
  608670
  613038
  617047
  618302
  620174
  624128
  626245
  639184
  648444
  660434
  660572
  685843
  687844
  689981
  690066
  694407
  708399
  709542
  727844
  727882
  732991
  733910
  735772
  739496
  740556
  741160
  748624
  749929
  752000
  757435
  761273
  762812
  763966
  764153
  764160
  765518
  766342
  767786
  769839
  776327
  777838
  784110
  784357
  784735
  787532
  787774
  789771
  792215
  795419
  796194
  796939
  801580
  802908
  803549
  810076
  811571
  813189
  824868
]
2.14 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вагин секс orgasm"
]
1.71 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "vagina sex orgasm"
]
1.60 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вагин секс orgasm"
]

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.