Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
183.88 ms
(87.85%)
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
  370557
  383356
  396665
  399192
  400162
  402784
  402793
  405528
  409936
  419113
  420280
  421310
  423379
  424332
  426675
  427311
  430477
  430584
  430787
  434933
  435624
  440156
  444956
  446861
  447618
  451257
  452115
  456320
  460622
  464624
  467003
  468154
  469830
  472230
  474425
  480024
  481877
  489461
  490831
  493190
  494815
  498391
  498440
  499800
  499823
  501177
  504488
  504592
  509861
  510043
  510291
  515068
  515551
  515994
  516661
  519653
  522094
  522383
  527085
  527207
  531908
  532161
  533877
  537889
  537906
  540564
  546110
  547733
  552585
  554166
  555821
  561344
  566320
  569454
  572305
  572737
  575705
  582489
  584673
  586435
  594788
  599864
  604061
  616978
  619166
  619396
  624838
  624841
  628707
  633756
  642315
  645293
  647895
  648220
  649991
  661974
  666530
  666553
  680138
  688581
  718698
  720262
  728930
  730091
  734038
  744649
  748227
  748264
  750299
  770271
  788196
  788788
  810986
  813346
  813568
  815204
  815232
  816007
  818439
  826874
]
15.41 ms
(7.36%)
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
  499800
  586435
  515551
  572737
  555821
  616978
  619166
  446861
  527207
  504592
  624841
  554166
  405528
  435624
  815204
  510291
  522383
  531908
  584673
  666530
  426675
  472230
  420280
  421310
  409936
  430787
  826874
  818439
  481877
  467003
  509861
  533877
  510043
  519653
  468154
  561344
  661974
  645293
  649991
  720262
  624838
  594788
  628707
  788196
  788788
  813346
  748264
  750299
  730091
  744649
  810986
  400162
  460622
  456320
  399192
  396665
  402793
  434933
  489461
  499823
  501177
  424332
  599864
  444956
  504488
  604061
  498391
  494815
  498440
  572305
  427311
  648220
  480024
  575705
  647895
  815232
  582489
  440156
  370557
  430584
  452115
  516661
  522094
  566320
  688581
  728930
  770271
  419113
  527085
  515994
  633756
  383356
  402784
  430477
  423379
  813568
  816007
  447618
  490831
  493190
  451257
  469830
  474425
  540564
  532161
  537889
  537906
  515068
  464624
  546110
  547733
  552585
  666553
  680138
  718698
  569454
  642315
  619396
  734038
  748227
]
3.19 ms
(1.52%)
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
  370557
  383356
  396665
  399192
  400162
  402784
  402793
  405528
  409936
  419113
  420280
  421310
  423379
  424332
  426675
  427311
  430477
  430584
  430787
  434933
  435624
  440156
  444956
  446861
  447618
  451257
  452115
  456320
  460622
  464624
  467003
  468154
  469830
  472230
  474425
  480024
  481877
  489461
  490831
  493190
  494815
  498391
  498440
  499800
  499823
  501177
  504488
  504592
  509861
  510043
  510291
  515068
  515551
  515994
  516661
  519653
  522094
  522383
  527085
  527207
  531908
  532161
  533877
  537889
  537906
  540564
  546110
  547733
  552585
  554166
  555821
  561344
  566320
  569454
  572305
  572737
  575705
  582489
  584673
  586435
  594788
  599864
  604061
  616978
  619166
  619396
  624838
  624841
  628707
  633756
  642315
  645293
  647895
  648220
  649991
  661974
  666530
  666553
  680138
  688581
  718698
  720262
  728930
  730091
  734038
  744649
  748227
  748264
  750299
  770271
  788196
  788788
  810986
  813346
  813568
  815204
  815232
  816007
  818439
  826874
]
1.89 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy squirt"
]
1.67 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy сквирт оргазм"
]
1.64 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy сквирт оргазм"
]
1.64 ms
(0.78%)
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.