Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.04 ms
(86.63%)
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
  403858
  413115
  422722
  426897
  434903
  438957
  449573
  449582
  472535
  472606
  474925
  477429
  479604
  480984
  483658
  495251
  496377
  497716
  513450
  516458
  527834
  528541
  529774
  534443
  534734
  538024
  540196
  544791
  559314
  560071
  564749
  577309
  577698
  579622
  581745
  585645
  586752
  593082
  599795
  603747
  605795
  606594
  613899
  617682
  620817
  634895
  651690
  655926
  662151
  664094
  672901
  678697
  681491
  687620
  693313
  695321
  697654
  702308
  702317
  702338
  704079
  706727
  706826
  707851
  708505
  708692
  708989
  711637
  713314
  713343
  736074
  736349
  738514
  740848
  741186
  742702
  743268
  743610
  744002
  744206
  748263
  748283
  751791
  752295
  752452
  753193
  758316
  760573
  765256
  777838
  777840
  780151
  782135
  782654
  784047
  784116
  784459
  785986
  787976
  788128
  789234
  791542
  792712
  796992
  798481
  799058
  800692
  802251
  803104
  804622
  804696
  806642
  806803
  806967
  808158
  809924
  812681
  813327
]
15.76 ms
(8.03%)
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
  777838
  777840
  780151
  782135
  782654
  784459
  787976
  796992
  800692
  812681
  741186
  744002
  758316
  784116
  788128
  789234
  806967
  808158
  813327
  736349
  738514
  748263
  748283
  765256
  752452
  751791
  752295
  760573
  736074
  742702
  743268
  744206
  702308
  702317
  784047
  785986
  799058
  803104
  806642
  806803
  743610
  792712
  802251
  438957
  579622
  804622
  474925
  426897
  413115
  434903
  477429
  449573
  449582
  538024
  581745
  708692
  707851
  585645
  620817
  791542
  809924
  740848
  798481
  804696
  806505
  753193
  702338
  479604
  403858
  480984
  495251
  483658
  422722
  472606
  472535
  516458
  496377
  497716
  527834
  528541
  540196
  534734
  513450
  529774
  534443
  544791
  560071
  559314
  577698
  564749
  577309
  664094
  681491
  697654
  704079
  706727
  706826
  711637
  713291
  713314
  651690
  662151
  672901
  678697
  687620
  693313
  695321
  708505
  708989
  655926
  713343
  603747
  605795
  613899
  617682
  634895
  599795
  606594
  586752
  593082
]
2.56 ms
(1.31%)
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
  403858
  413115
  422722
  426897
  434903
  438957
  449573
  449582
  472535
  472606
  474925
  477429
  479604
  480984
  483658
  495251
  496377
  497716
  513450
  516458
  527834
  528541
  529774
  534443
  534734
  538024
  540196
  544791
  559314
  560071
  564749
  577309
  577698
  579622
  581745
  585645
  586752
  593082
  599795
  603747
  605795
  606594
  613899
  617682
  620817
  634895
  651690
  655926
  662151
  664094
  672901
  678697
  681491
  687620
  693313
  695321
  697654
  702308
  702317
  702338
  704079
  706727
  706826
  707851
  708505
  708692
  708989
  711637
  713314
  713343
  736074
  736349
  738514
  740848
  741186
  742702
  743268
  743610
  744002
  744206
  748263
  748283
  751791
  752295
  752452
  753193
  758316
  760573
  765256
  777838
  777840
  780151
  782135
  782654
  784047
  784116
  784459
  785986
  787976
  788128
  789234
  791542
  792712
  796992
  798481
  799058
  800692
  802251
  803104
  804622
  804696
  806642
  806803
  806967
  808158
  809924
  812681
  813327
]
2.29 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соло мастурбация мокрая"
]
2.06 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло мастурбац мокрая"
]
1.95 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.83%)
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.