Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.83 ms
(85.59%)
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
  385815
  391756
  395252
  397531
  401190
  409597
  415937
  417547
  418253
  419895
  419987
  420005
  420314
  421619
  421801
  421940
  423326
  423916
  424011
  424156
  424349
  424734
  425506
  425727
  426561
  432366
  432464
  432487
  435737
  435937
  437006
  437980
  439291
  440724
  440867
  441169
  441666
  441748
  441800
  443896
  444002
  444234
  447217
  449712
  450296
  450446
  451324
  454016
  455202
  457403
  458296
  459070
  460319
  460408
  461057
  461601
  463420
  463469
  463991
  465869
  466756
  467060
  467787
  468275
  468942
  471850
  472814
  473634
  473825
  475605
  477503
  478633
  479696
  480339
  482914
  484939
  486628
  487761
  487948
  488914
  490287
  510785
  513203
  513257
  513628
  516596
  517277
  521014
  522510
  528465
  534601
  540816
  543945
  555925
  560768
  585073
  599789
  637250
  725012
  731159
  738212
  751260
  751581
  752765
  759134
  763726
  763729
  763740
  764046
  768603
  768851
  783303
  785841
  790094
  799118
  802236
  804725
  805538
  808143
  824889
]
16.07 ms
(8.45%)
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
  790094
  805538
  763740
  764046
  768603
  731159
  751581
  752765
  763726
  763729
  768851
  783303
  785841
  799118
  804725
  385815
  424156
  432366
  432464
  441748
  444234
  454016
  475605
  477503
  419895
  420005
  421619
  460408
  466756
  418253
  421801
  421940
  461057
  468275
  480339
  395252
  439291
  441800
  450446
  455202
  459070
  463469
  479696
  449712
  451324
  467787
  472814
  513628
  488914
  513203
  482914
  528465
  484939
  510785
  516596
  521014
  423916
  534601
  560768
  555925
  637250
  738212
  808143
  444002
  517277
  522510
  759134
  397531
  440867
  435737
  450296
  468942
  463420
  490287
  543945
  599789
  802236
  725012
  751260
  473634
  425727
  487761
  513257
  486628
  391756
  401190
  417547
  424011
  432487
  437980
  443896
  415937
  419987
  425506
  441169
  420314
  424734
  426561
  440724
  409597
  423326
  437006
  424349
  435937
  441666
  540816
  585073
  824889
  458296
  461601
  467060
  478633
  487948
  447217
  457403
  460319
  463991
  465869
  471850
  473825
]
3.74 ms
(1.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife naked"
]
2.78 ms
(1.46%)
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
  385815
  391756
  395252
  397531
  401190
  409597
  415937
  417547
  418253
  419895
  419987
  420005
  420314
  421619
  421801
  421940
  423326
  423916
  424011
  424156
  424349
  424734
  425506
  425727
  426561
  432366
  432464
  432487
  435737
  435937
  437006
  437980
  439291
  440724
  440867
  441169
  441666
  441748
  441800
  443896
  444002
  444234
  447217
  449712
  450296
  450446
  451324
  454016
  455202
  457403
  458296
  459070
  460319
  460408
  461057
  461601
  463420
  463469
  463991
  465869
  466756
  467060
  467787
  468275
  468942
  471850
  472814
  473634
  473825
  475605
  477503
  478633
  479696
  480339
  482914
  484939
  486628
  487761
  487948
  488914
  490287
  510785
  513203
  513257
  513628
  516596
  517277
  521014
  522510
  528465
  534601
  540816
  543945
  555925
  560768
  585073
  599789
  637250
  725012
  731159
  738212
  751260
  751581
  752765
  759134
  763726
  763729
  763740
  764046
  768603
  768851
  783303
  785841
  790094
  799118
  802236
  804725
  805538
  808143
  824889
]
1.79 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен голые"
]
1.43 ms
(0.75%)
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.