Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.05 ms
(50.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
184.27 ms
(43.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
  396684
  399415
  400903
  403906
  406291
  417316
  418920
  419220
  420315
  422287
  423243
  423398
  426016
  426334
  427869
  428516
  432086
  439456
  441933
  448365
  456365
  457820
  461845
  462983
  466820
  473231
  473375
  475066
  479449
  494221
  494648
  500181
  502289
  503010
  509729
  514480
  514779
  525518
  526394
  539051
  539372
  542923
  546373
  547426
  550088
  552802
  557924
  558232
  558801
  561940
  562497
  562966
  568076
  578247
  581987
  582398
  587885
  588714
  590064
  591819
  592571
  602052
  604042
  605396
  605587
  606333
  613778
  613849
  614045
  619462
  619501
  626432
  632102
  638459
  654596
  661646
  662431
  667427
  674907
  679228
  682270
  692676
  697201
  715622
  716522
  716664
  717930
  721908
  726496
  726530
  737179
  739672
  743128
  744866
  747943
  750069
  750078
  751715
  753181
  760439
  767683
  775697
  781927
  781999
  788377
  789689
  794104
  794820
  796209
  796349
  799435
  800425
  801387
  802868
  803087
  803244
  814521
  820423
  821149
]
15.89 ms
(3.78%)
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
  514779
  525518
  514480
  526394
  557924
  547426
  654596
  682270
  590064
  606333
  767683
  632102
  423398
  814521
  667427
  716664
  605587
  619462
  739672
  753181
  539372
  562966
  619501
  605396
  396684
  399415
  406291
  422287
  423243
  428516
  418920
  417316
  432086
  821149
  820423
  456365
  461845
  466820
  448365
  539051
  500181
  509729
  494221
  494648
  502289
  473375
  479449
  546373
  552802
  558232
  558801
  568076
  542923
  550088
  582398
  561940
  578247
  661646
  674907
  721908
  679228
  692676
  697201
  716522
  717930
  662431
  562497
  581987
  587885
  602052
  613778
  638459
  592571
  613849
  614045
  588714
  604042
  591819
  775697
  789689
  794104
  796209
  800425
  796349
  799435
  743128
  744866
  760439
  788377
  794820
  803087
  726496
  726530
  741919
  747943
  750069
  750078
  751715
  737179
  626432
  715622
  781927
  781999
  801387
  802868
  803244
  403906
  419220
  439456
  473231
  426334
  441933
  400903
  426016
  462983
  420315
  427869
  457820
  475066
  503010
]
3.05 ms
(0.73%)
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
  396684
  399415
  400903
  403906
  406291
  417316
  418920
  419220
  420315
  422287
  423243
  423398
  426016
  426334
  427869
  428516
  432086
  439456
  441933
  448365
  456365
  457820
  461845
  462983
  466820
  473231
  473375
  475066
  479449
  494221
  494648
  500181
  502289
  503010
  509729
  514480
  514779
  525518
  526394
  539051
  539372
  542923
  546373
  547426
  550088
  552802
  557924
  558232
  558801
  561940
  562497
  562966
  568076
  578247
  581987
  582398
  587885
  588714
  590064
  591819
  592571
  602052
  604042
  605396
  605587
  606333
  613778
  613849
  614045
  619462
  619501
  626432
  632102
  638459
  654596
  661646
  662431
  667427
  674907
  679228
  682270
  692676
  697201
  715622
  716522
  716664
  717930
  721908
  726496
  726530
  737179
  739672
  743128
  744866
  747943
  750069
  750078
  751715
  753181
  760439
  767683
  775697
  781927
  781999
  788377
  789689
  794104
  794820
  796209
  796349
  799435
  800425
  801387
  802868
  803087
  803244
  814521
  820423
  821149
]
2.39 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm out"
]
1.94 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм out"
]
1.65 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм out"
]

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.