Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.91 ms
(86.21%)
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
  85949
  219052
  397777
  399013
  401834
  418572
  438365
  455996
  456663
  466418
  530102
  531353
  531355
  531363
  534504
  540887
  548831
  558957
  562451
  563457
  567861
  579029
  584211
  585290
  591175
  597000
  603828
  614939
  615893
  617852
  623372
  626797
  629650
  632071
  632409
  635726
  648165
  648315
  648323
  648326
  649866
  650095
  652434
  652529
  652532
  653307
  653915
  654984
  657759
  657830
  659190
  661924
  670069
  671166
  674257
  678643
  689160
  693503
  693572
  699108
  700869
  701283
  701530
  701772
  710208
  716729
  718427
  720217
  725782
  726344
  726356
  731669
  733316
  733938
  742012
  743711
  745933
  748458
  755166
  761955
  763232
  763771
  764313
  764558
  764582
  764826
  764991
  769977
  771512
  773413
  776364
  777503
  777990
  778046
  779843
  780037
  780081
  780840
  782500
  783510
  783706
  783788
  784698
  786667
  787327
  789147
  789508
  790263
  790540
  791982
  793349
  793752
  793756
  793764
  802840
  817971
  822989
  824093
  825047
  825646
]
9.36 ms
(6.73%)
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
  700869
  540887
  531353
  579029
  562451
  652532
  689160
  693572
  648326
  652434
  701772
  648323
  671166
  584211
  626797
  597000
  778046
  764826
  769977
  773413
  614939
  789508
  793764
  771512
  743711
  466418
  720217
  824093
  455996
  764558
  764582
  649866
  793756
  399013
  726356
  530102
  817971
  825047
  567861
  699108
  653307
  701530
  629650
  776364
  731669
  763232
  764991
  790540
  793349
  761955
  764313
  763771
  615893
  718427
  780840
  783788
  787327
  632071
  531355
  650095
  657759
  648315
  678643
  710208
  648165
  657830
  591175
  745933
  635726
  742012
  674257
  548831
  791982
  438365
  563457
  652529
  558957
  585290
  779843
  783706
  725782
  782500
  780081
  733938
  85949
  701283
  780037
  786667
  777503
  783510
  784698
  790263
  733316
  748458
  777990
  693503
  534504
  716729
  661924
  603828
  632409
  789147
  617852
  802840
  531363
  659190
  726344
  219052
  456663
  418572
  755166
  401834
  397777
  623372
  670069
  793752
  653915
  822989
  825646
  654984
]
2.45 ms
(1.76%)
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
  85949
  219052
  397777
  399013
  401834
  418572
  438365
  455996
  456663
  466418
  530102
  531353
  531355
  531363
  534504
  540887
  548831
  558957
  562451
  563457
  567861
  579029
  584211
  585290
  591175
  597000
  603828
  614939
  615893
  617852
  623372
  626797
  629650
  632071
  632409
  635726
  648165
  648315
  648323
  648326
  649866
  650095
  652434
  652529
  652532
  653307
  653915
  654984
  657759
  657830
  659190
  661924
  670069
  671166
  674257
  678643
  689160
  693503
  693572
  699108
  700869
  701283
  701530
  701772
  710208
  716729
  718427
  720217
  725782
  726344
  726356
  731669
  733316
  733938
  742012
  743711
  745933
  748458
  755166
  761955
  763232
  763771
  764313
  764558
  764582
  764826
  764991
  769977
  771512
  773413
  776364
  777503
  777990
  778046
  779843
  780037
  780081
  780840
  782500
  783510
  783706
  783788
  784698
  786667
  787327
  789147
  789508
  790263
  790540
  791982
  793349
  793752
  793756
  793764
  802840
  817971
  822989
  824093
  825047
  825646
]
2.02 ms
(1.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс любительск"
]
1.82 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс любительск"
]
1.78 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "минет любительское же…"
]
1.75 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.