Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.98 ms
(81.98%)
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
  43748
  117388
  397065
  406847
  417116
  428052
  432769
  437302
  445536
  453778
  459629
  461091
  461376
  462588
  485407
  486617
  493271
  499860
  499874
  500060
  502855
  502893
  504846
  509114
  509984
  510332
  511387
  512150
  512603
  512804
  512956
  512962
  513369
  514094
  514199
  516348
  518320
  519355
  520381
  520394
  521005
  524078
  525151
  525495
  525505
  525757
  526273
  527406
  528359
  530032
  532319
  540311
  540548
  543970
  547428
  547584
  547828
  549081
  550077
  552854
  557472
  560952
  560993
  562083
  563176
  563300
  564040
  566337
  568588
  573362
  575283
  576527
  576932
  577178
  580425
  581462
  584456
  584698
  584921
  585095
  588082
  590498
  593671
  597584
  598387
  598457
  598469
  598512
  598539
  598897
  599142
  604293
  604605
  605183
  607353
  610016
  611206
  621095
  624551
  627076
  628059
  628708
  631549
  632163
  645935
  645949
  650726
  654380
  656525
  660080
  670425
  671131
  675049
  675303
  675705
  677352
  678891
  680102
  680459
  684934
]
16.08 ms
(11.27%)
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
  524078
  525757
  528359
  540548
  512150
  514094
  518320
  520381
  520394
  526273
  532319
  461376
  563176
  564040
  577178
  584456
  543970
  547428
  550077
  560952
  562083
  575283
  584921
  563300
  568588
  645949
  656525
  675049
  680102
  645935
  654380
  670425
  675303
  677352
  678891
  684934
  650726
  660080
  680459
  547828
  552854
  560993
  573362
  576527
  593671
  597584
  598897
  604293
  610016
  598387
  598457
  598512
  598539
  604605
  627076
  628708
  632163
  598469
  599142
  621095
  607353
  611206
  628059
  445536
  462588
  117388
  428052
  43748
  397065
  417116
  437302
  504846
  512603
  500060
  502855
  502893
  521005
  493271
  509984
  519355
  485407
  486617
  510332
  432769
  585095
  511387
  513369
  514199
  512804
  499860
  547584
  566337
  576932
  581462
  584698
  549081
  557472
  675705
  580425
  590498
  624551
  588082
  605183
  631549
  406847
  671131
  461091
  453778
  459629
  512962
  525495
  525505
  527406
  530032
  509114
  525151
  540311
  499874
  512956
  516348
]
2.51 ms
(1.76%)
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
  43748
  117388
  397065
  406847
  417116
  428052
  432769
  437302
  445536
  453778
  459629
  461091
  461376
  462588
  485407
  486617
  493271
  499860
  499874
  500060
  502855
  502893
  504846
  509114
  509984
  510332
  511387
  512150
  512603
  512804
  512956
  512962
  513369
  514094
  514199
  516348
  518320
  519355
  520381
  520394
  521005
  524078
  525151
  525495
  525505
  525757
  526273
  527406
  528359
  530032
  532319
  540311
  540548
  543970
  547428
  547584
  547828
  549081
  550077
  552854
  557472
  560952
  560993
  562083
  563176
  563300
  564040
  566337
  568588
  573362
  575283
  576527
  576932
  577178
  580425
  581462
  584456
  584698
  584921
  585095
  588082
  590498
  593671
  597584
  598387
  598457
  598469
  598512
  598539
  598897
  599142
  604293
  604605
  605183
  607353
  610016
  611206
  621095
  624551
  627076
  628059
  628708
  631549
  632163
  645935
  645949
  650726
  654380
  656525
  660080
  670425
  671131
  675049
  675303
  675705
  677352
  678891
  680102
  680459
  684934
]
2.08 ms
(1.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(1.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп бок"
]
1.72 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жопу боком"
]
1.39 ms
(0.97%)
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.