Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.09 ms
(86.95%)
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
  389935
  390263
  410905
  419265
  427776
  434313
  444632
  446461
  449525
  458804
  459098
  484218
  493083
  495636
  499182
  505803
  507626
  507628
  508672
  510051
  513854
  527271
  536189
  536623
  537580
  546079
  558595
  578301
  587536
  588048
  593069
  600436
  602522
  604053
  619385
  644068
  644091
  665626
  668739
  669000
  671698
  680607
  691622
  691723
  709972
  711183
  714833
  716366
  718319
  724002
  724113
  724393
  725027
  725664
  729265
  731139
  733289
  740825
  744786
  746123
  747632
  748285
  750601
  754250
  756535
  758826
  761526
  762286
  768261
  768275
  768609
  771915
  773210
  780658
  784431
  785484
  785670
  786502
  794637
  794731
  795045
  795736
  797081
  800353
  801567
  804258
  808483
  811508
  817601
  823458
  823854
  823963
  824065
  824071
  824222
  824320
  824526
  824619
  824651
  824750
  825291
  825898
  826352
  826426
  826436
  826670
  826693
  826742
  826877
  828025
  828203
  828470
  828476
  828585
  828707
  828795
]
14.29 ms
(8.17%)
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
  558595
  758826
  513854
  824320
  508672
  744786
  458804
  714833
  410905
  389935
  797081
  725027
  740825
  785484
  527271
  644068
  644091
  505803
  604053
  507626
  587536
  785670
  794637
  748285
  768261
  750601
  811508
  495636
  602522
  729265
  826670
  419265
  756535
  449525
  493083
  510051
  600436
  459098
  669000
  427776
  446461
  484218
  588048
  823854
  747632
  444632
  390263
  434313
  824620
  824619
  826562
  828461
  826426
  773210
  507628
  593069
  725664
  824651
  724002
  578301
  724393
  824071
  824971
  825898
  826352
  828795
  828476
  828470
  826877
  826742
  536623
  795736
  619385
  537580
  718319
  795045
  824526
  826693
  826436
  828025
  801567
  824065
  780658
  768609
  733289
  823963
  828707
  680607
  671698
  711183
  709972
  794731
  499182
  824222
  817601
  823458
  828203
  786502
  808483
  762286
  784431
  800353
  768275
  804258
  825291
  824750
  828585
  536189
  731139
  724113
  746123
  754250
  771915
  761526
  546079
  665626
  668739
  691723
  691622
  716366
]
2.27 ms
(1.30%)
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
  389935
  390263
  410905
  419265
  427776
  434313
  444632
  446461
  449525
  458804
  459098
  484218
  493083
  495636
  499182
  505803
  507626
  507628
  508672
  510051
  513854
  527271
  536189
  536623
  537580
  546079
  558595
  578301
  587536
  588048
  593069
  600436
  602522
  604053
  619385
  644068
  644091
  665626
  668739
  669000
  671698
  680607
  691622
  691723
  709972
  711183
  714833
  716366
  718319
  724002
  724113
  724393
  725027
  725664
  729265
  731139
  733289
  740825
  744786
  746123
  747632
  748285
  750601
  754250
  756535
  758826
  761526
  762286
  768261
  768275
  768609
  771915
  773210
  780658
  784431
  785484
  785670
  786502
  794637
  794731
  795045
  795736
  797081
  800353
  801567
  804258
  808483
  811508
  817601
  823458
  823854
  823963
  824065
  824071
  824222
  824320
  824526
  824619
  824651
  824750
  825291
  825898
  826352
  826426
  826436
  826670
  826693
  826742
  826877
  828025
  828203
  828470
  828476
  828585
  828707
  828795
]
1.63 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "orgasm amateur"
]
1.61 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "orgasm любительск"
]
1.58 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "orgasm любительск"
]

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.