Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.42 ms
(86.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
  4205
  65700
  383462
  391150
  420328
  420333
  423346
  444614
  446502
  452344
  468232
  472357
  474721
  482913
  485014
  488203
  490162
  490169
  490380
  492991
  503745
  522420
  539962
  542030
  547058
  552756
  553206
  557937
  560883
  574115
  576540
  577599
  579808
  583115
  584678
  584681
  585645
  591097
  593509
  598640
  602023
  606919
  608529
  613498
  614592
  616993
  618429
  629828
  630991
  632340
  632564
  638750
  641444
  647048
  664483
  665094
  669583
  669587
  679415
  680969
  689833
  689849
  689898
  694862
  695413
  698497
  702557
  703339
  704984
  705459
  706642
  709504
  712228
  723637
  733434
  734264
  737804
  738928
  745872
  746001
  747376
  755961
  758158
  759316
  761142
  768053
  768092
  773182
  773326
  778452
  781108
  783933
  784048
  787078
  788690
  791297
  796515
  799734
  800707
  800754
  801810
  805037
  805073
  809800
  810322
  810638
  817146
  818215
  819670
  819810
  823506
  823576
  824914
  825201
  825432
  825582
  826493
  827578
  827654
  827722
]
17.92 ms
(9.11%)
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
  602023
  488203
  492991
  391150
  591097
  423346
  490162
  383462
  444614
  689833
  712228
  702557
  689849
  641444
  787078
  805037
  733434
  784048
  759316
  773326
  810638
  823576
  723637
  825582
  827578
  827722
  819670
  824914
  818215
  823506
  825432
  474721
  472357
  539962
  522420
  490169
  552756
  577599
  579808
  576540
  583115
  669587
  689898
  694862
  695413
  664483
  703339
  705459
  680969
  704984
  553206
  614592
  632340
  593509
  608529
  613498
  618429
  606919
  616993
  629828
  598640
  638750
  781108
  796515
  799734
  805073
  747376
  791297
  734264
  737804
  755961
  768053
  745872
  746001
  768092
  773182
  630991
  632564
  778452
  783933
  801810
  809800
  810322
  4205
  420328
  706642
  468232
  490380
  800754
  738928
  758158
  420333
  452344
  560883
  585645
  788690
  761142
  800707
  485014
  446502
  557937
  482913
  65700
  826493
  819810
  817146
  825201
  827654
  503745
  542030
  574115
  584678
  584681
  547058
  647048
  665094
  669583
  679415
  698497
  709504
]
2.56 ms
(1.30%)
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
  4205
  65700
  383462
  391150
  420328
  420333
  423346
  444614
  446502
  452344
  468232
  472357
  474721
  482913
  485014
  488203
  490162
  490169
  490380
  492991
  503745
  522420
  539962
  542030
  547058
  552756
  553206
  557937
  560883
  574115
  576540
  577599
  579808
  583115
  584678
  584681
  585645
  591097
  593509
  598640
  602023
  606919
  608529
  613498
  614592
  616993
  618429
  629828
  630991
  632340
  632564
  638750
  641444
  647048
  664483
  665094
  669583
  669587
  679415
  680969
  689833
  689849
  689898
  694862
  695413
  698497
  702557
  703339
  704984
  705459
  706642
  709504
  712228
  723637
  733434
  734264
  737804
  738928
  745872
  746001
  747376
  755961
  758158
  759316
  761142
  768053
  768092
  773182
  773326
  778452
  781108
  783933
  784048
  787078
  788690
  791297
  796515
  799734
  800707
  800754
  801810
  805037
  805073
  809800
  810322
  810638
  817146
  818215
  819670
  819810
  823506
  823576
  824914
  825201
  825432
  825582
  826493
  827578
  827654
  827722
]
1.99 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbation hidden"
]
1.80 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац скрыт"
]
1.63 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.74%)
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.