Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.88 ms
(84.17%)
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
  29610
  30841
  46656
  145603
  210619
  385783
  386938
  395949
  397249
  403872
  403890
  408678
  408887
  413116
  417610
  430988
  434926
  438848
  438957
  440642
  442651
  452995
  454789
  454899
  457863
  460237
  466468
  466925
  468290
  468291
  468785
  469956
  479871
  483743
  491187
  493827
  514217
  519352
  519361
  524658
  527564
  533121
  533128
  534635
  535140
  541504
  548026
  550030
  553592
  553604
  556744
  557446
  558893
  561168
  565801
  566564
  566589
  570890
  570942
  574076
  579259
  580490
  580998
  584363
  591029
  591522
  595590
  599343
  599407
  604793
  608296
  609721
  610748
  617775
  620178
  627790
  632885
  650937
  652357
  666419
  671189
  672229
  672301
  672310
  677428
  690726
  709844
  713190
  713372
  719647
  732918
  740261
  740262
  743160
  751203
  751376
  751553
  757188
  763815
  768607
  768832
  775657
  782780
  786812
  786977
  790128
  790436
  790616
  795021
  796927
  800745
  804350
  804407
  804408
  805864
  807877
  812221
  812243
  812528
  819186
]
14.79 ms
(9.66%)
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
  800745
  804350
  804408
  751376
  757188
  768832
  782780
  790128
  790616
  812221
  812243
  740262
  768607
  732918
  740261
  743160
  751203
  751553
  763815
  608296
  775657
  786812
  786977
  790436
  795021
  796927
  804407
  805864
  807877
  812528
  468785
  46656
  434926
  442651
  29610
  210619
  397249
  527564
  574076
  430988
  386938
  438957
  469956
  519361
  385783
  145603
  395949
  30841
  403872
  403890
  408887
  417610
  408678
  413116
  438848
  440642
  819186
  452995
  454899
  457863
  466468
  466925
  491187
  479871
  454789
  493827
  519352
  534635
  533121
  535140
  514217
  524658
  533128
  460237
  468290
  468291
  483743
  557446
  580490
  566589
  570890
  584363
  541504
  548026
  566564
  570942
  579259
  652357
  671189
  672301
  672310
  713372
  650937
  666419
  690726
  709844
  713190
  672229
  677428
  719647
  550030
  553592
  553604
  556744
  558893
  561168
  565801
  580998
  599407
  610748
  632885
  609721
  591029
  599343
  604793
  627790
  591522
  595590
  617775
  620178
]
2.54 ms
(1.66%)
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
  29610
  30841
  46656
  145603
  210619
  385783
  386938
  395949
  397249
  403872
  403890
  408678
  408887
  413116
  417610
  430988
  434926
  438848
  438957
  440642
  442651
  452995
  454789
  454899
  457863
  460237
  466468
  466925
  468290
  468291
  468785
  469956
  479871
  483743
  491187
  493827
  514217
  519352
  519361
  524658
  527564
  533121
  533128
  534635
  535140
  541504
  548026
  550030
  553592
  553604
  556744
  557446
  558893
  561168
  565801
  566564
  566589
  570890
  570942
  574076
  579259
  580490
  580998
  584363
  591029
  591522
  595590
  599343
  599407
  604793
  608296
  609721
  610748
  617775
  620178
  627790
  632885
  650937
  652357
  666419
  671189
  672229
  672301
  672310
  677428
  690726
  709844
  713190
  713372
  719647
  732918
  740261
  740262
  743160
  751203
  751376
  751553
  757188
  763815
  768607
  768832
  775657
  782780
  786812
  786977
  790128
  790436
  790616
  795021
  796927
  800745
  804350
  804407
  804408
  805864
  807877
  812221
  812243
  812528
  819186
]
2.18 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соло голых"
]
1.76 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло голые"
]
1.48 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.