Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.85 ms
(84.57%)
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
  16870
  39532
  53932
  70359
  81412
  81571
  97191
  163536
  185820
  188437
  234067
  308328
  311176
  325253
  383715
  397106
  397495
  397631
  398017
  401641
  402949
  406282
  424263
  425157
  427033
  445831
  478653
  487458
  488017
  488565
  494312
  496059
  498217
  500998
  504895
  505936
  510565
  516000
  523032
  524965
  535575
  535808
  535920
  544258
  548267
  554875
  563962
  573506
  577314
  583170
  585599
  588172
  592834
  595751
  596559
  601828
  601900
  605794
  608106
  617030
  618289
  621360
  622872
  633649
  648347
  662776
  666899
  679578
  697613
  714360
  717247
  718533
  719127
  719284
  719452
  723156
  724874
  729255
  729441
  730165
  731125
  731277
  731429
  733447
  735534
  735890
  739253
  739981
  746725
  753641
  762499
  763002
  767633
  767801
  768151
  768974
  769221
  772353
  777175
  777817
  777961
  777993
  779781
  779923
  781034
  782359
  782613
  782691
  787222
  787236
  787258
  787392
  790594
  790705
  792355
  793793
  794784
  796040
  799711
  810216
]
12.43 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
  397631
  516000
  308328
  719127
  510565
  524965
  595751
  445831
  188437
  425157
  397495
  16870
  397106
  544258
  779923
  794784
  724874
  753641
  729255
  768151
  777817
  97191
  70359
  81571
  488565
  505936
  554875
  563962
  679578
  718533
  719284
  723156
  777993
  779781
  787392
  781034
  739253
  746725
  782691
  787258
  790705
  731277
  768974
  769221
  739981
  735534
  735890
  763002
  767801
  731429
  633649
  714360
  777961
  787222
  790594
  810216
  398017
  424263
  81412
  772353
  605794
  504895
  601900
  163536
  427033
  618289
  535575
  717247
  487458
  53932
  592834
  311176
  185820
  401641
  500998
  548267
  777175
  535808
  406282
  535920
  496059
  583170
  608106
  39532
  782359
  488017
  793793
  730165
  733447
  731125
  577314
  799711
  325253
  622872
  729441
  662776
  596559
  617030
  621360
  383715
  402949
  498217
  719452
  588172
  585599
  792355
  782613
  796040
  762499
  767633
  787236
  697613
  234067
  573506
  648347
  523032
  494312
  666899
  601828
  478653
]
3.28 ms
(2.12%)
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
  16870
  39532
  53932
  70359
  81412
  81571
  97191
  163536
  185820
  188437
  234067
  308328
  311176
  325253
  383715
  397106
  397495
  397631
  398017
  401641
  402949
  406282
  424263
  425157
  427033
  445831
  478653
  487458
  488017
  488565
  494312
  496059
  498217
  500998
  504895
  505936
  510565
  516000
  523032
  524965
  535575
  535808
  535920
  544258
  548267
  554875
  563962
  573506
  577314
  583170
  585599
  588172
  592834
  595751
  596559
  601828
  601900
  605794
  608106
  617030
  618289
  621360
  622872
  633649
  648347
  662776
  666899
  679578
  697613
  714360
  717247
  718533
  719127
  719284
  719452
  723156
  724874
  729255
  729441
  730165
  731125
  731277
  731429
  733447
  735534
  735890
  739253
  739981
  746725
  753641
  762499
  763002
  767633
  767801
  768151
  768974
  769221
  772353
  777175
  777817
  777961
  777993
  779781
  779923
  781034
  782359
  782613
  782691
  787222
  787236
  787258
  787392
  790594
  790705
  792355
  793793
  794784
  796040
  799711
  810216
]
2.21 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"камшот кончают в ротиÐ…"
]
2.19 ms
(1.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм сперм в рот"
]
2.01 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.13%)
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.