Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.42 ms
(85.21%)
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
  414604
  415950
  419219
  419320
  420635
  420648
  421835
  421954
  422145
  422152
  422154
  422169
  422194
  422196
  422202
  422208
  423923
  424210
  426765
  426993
  428483
  433211
  436933
  437589
  438934
  439666
  439670
  439689
  439705
  439719
  440980
  446148
  448084
  448831
  449635
  449760
  449845
  452039
  452383
  454812
  455276
  455870
  455974
  456736
  461890
  464175
  466211
  470501
  472276
  474309
  476333
  476644
  478414
  478536
  481167
  482195
  482443
  483428
  491348
  492331
  494496
  496017
  497469
  500623
  501458
  509642
  510553
  511254
  512551
  513095
  513620
  514200
  514656
  517325
  517418
  518507
  519547
  520826
  520851
  521698
  524657
  525253
  525277
  526051
  526381
  527676
  533182
  557154
  557161
  559050
  561470
  561488
  566312
  567209
  568378
  569109
  574446
  580808
  580950
  583547
  590759
  590867
  592027
  596766
  598190
  602744
  604046
  605689
  605762
  616489
  618543
  626399
  641708
  647682
  663294
  690323
  795963
  798509
  813084
  823582
]
17.22 ms
(9.56%)
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
  478414
  422152
  440980
  419219
  421835
  422194
  422196
  439719
  472276
  481167
  474309
  449760
  466211
  513620
  518507
  521698
  500623
  583547
  574446
  596766
  592027
  795963
  798509
  526381
  482443
  524657
  478536
  491348
  437589
  419320
  452039
  449845
  456736
  476333
  476644
  525253
  517418
  526051
  496017
  510553
  514200
  470501
  561470
  561488
  569109
  568378
  663294
  567209
  626399
  641708
  602744
  424210
  439670
  421954
  454812
  422145
  428483
  439666
  448831
  512551
  519547
  494496
  559050
  455870
  590867
  517325
  557154
  618543
  813084
  420635
  616489
  823582
  436933
  448084
  446148
  482195
  483428
  497469
  501458
  492331
  580808
  580950
  598190
  604046
  590759
  605689
  426765
  422169
  426993
  461890
  420648
  423923
  455276
  439689
  439705
  464175
  509642
  513095
  520851
  514656
  533182
  690323
  647682
  452383
  438934
  520826
  511254
  527676
  566312
  605762
  422202
  422154
  422208
  414604
  415950
  557161
  455974
  433211
  449635
  525277
]
2.52 ms
(1.40%)
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
  414604
  415950
  419219
  419320
  420635
  420648
  421835
  421954
  422145
  422152
  422154
  422169
  422194
  422196
  422202
  422208
  423923
  424210
  426765
  426993
  428483
  433211
  436933
  437589
  438934
  439666
  439670
  439689
  439705
  439719
  440980
  446148
  448084
  448831
  449635
  449760
  449845
  452039
  452383
  454812
  455276
  455870
  455974
  456736
  461890
  464175
  466211
  470501
  472276
  474309
  476333
  476644
  478414
  478536
  481167
  482195
  482443
  483428
  491348
  492331
  494496
  496017
  497469
  500623
  501458
  509642
  510553
  511254
  512551
  513095
  513620
  514200
  514656
  517325
  517418
  518507
  519547
  520826
  520851
  521698
  524657
  525253
  525277
  526051
  526381
  527676
  533182
  557154
  557161
  559050
  561470
  561488
  566312
  567209
  568378
  569109
  574446
  580808
  580950
  583547
  590759
  590867
  592027
  596766
  598190
  602744
  604046
  605689
  605762
  616489
  618543
  626399
  641708
  647682
  663294
  690323
  795963
  798509
  813084
  823582
]
1.88 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature brunette pov"
]
1.84 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature черноволосая пов"
]
1.63 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature черноволосая пов"
]
1.53 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.