Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.20 ms
(52.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в член"
]
171.02 ms
(41.64%)
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
  11998
  394661
  397128
  398299
  402047
  405954
  406931
  407569
  409234
  410874
  410884
  413522
  418336
  419181
  421627
  421635
  421671
  423490
  424157
  426016
  429529
  429575
  433910
  437484
  437801
  437968
  438468
  439217
  444205
  447410
  447664
  447757
  447795
  449164
  450650
  452643
  452766
  453312
  453461
  454697
  455103
  456500
  456597
  456602
  457555
  458149
  458425
  458960
  459121
  460881
  461340
  461655
  462779
  462836
  464474
  465119
  466190
  466961
  467448
  467617
  469849
  469894
  470860
  471311
  472612
  472663
  473545
  473803
  474351
  474580
  474831
  475179
  475464
  475867
  477167
  477401
  477453
  477870
  480086
  482142
  483277
  483761
  485509
  485756
  487880
  488089
  491619
  491698
  492978
  493264
  493397
  495847
  497197
  497551
  499012
  501452
  506178
  508771
  510649
  511740
  512603
  515870
  516106
  517220
  518742
  519682
  519724
  521368
  522583
  523326
  523507
  524985
  525561
  527800
  529209
  548263
  554777
  555793
  561330
  571772
]
17.12 ms
(4.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
  458425
  466961
  447664
  453461
  474580
  488089
  456500
  456597
  457555
  471311
  474831
  519682
  499012
  517220
  497551
  475867
  477167
  561330
  548263
  555793
  397128
  460881
  462836
  464474
  472663
  407569
  421671
  429575
  452766
  458960
  459121
  477401
  477870
  419181
  426016
  482142
  406931
  410884
  418336
  433910
  461340
  462779
  413522
  437968
  467617
  472612
  512603
  518742
  523507
  483277
  491698
  492978
  506178
  510649
  511740
  516106
  519724
  521368
  522583
  501452
  508771
  515870
  523326
  524985
  410874
  421627
  438468
  497197
  480086
  437801
  485509
  449164
  458149
  469849
  394661
  405954
  465119
  483761
  447757
  447795
  493397
  571772
  429529
  473803
  402047
  455103
  409234
  447410
  475464
  529209
  398299
  439217
  452643
  461655
  450650
  487880
  456602
  493264
  475179
  554777
  424157
  437484
  467448
  470860
  474351
  454697
  466190
  444205
  477453
  495847
  453312
  469894
  485756
  473545
  11998
  421635
  525561
  491619
  527800
  423490
]
2.75 ms
(0.67%)
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
  11998
  394661
  397128
  398299
  402047
  405954
  406931
  407569
  409234
  410874
  410884
  413522
  418336
  419181
  421627
  421635
  421671
  423490
  424157
  426016
  429529
  429575
  433910
  437484
  437801
  437968
  438468
  439217
  444205
  447410
  447664
  447757
  447795
  449164
  450650
  452643
  452766
  453312
  453461
  454697
  455103
  456500
  456597
  456602
  457555
  458149
  458425
  458960
  459121
  460881
  461340
  461655
  462779
  462836
  464474
  465119
  466190
  466961
  467448
  467617
  469849
  469894
  470860
  471311
  472612
  472663
  473545
  473803
  474351
  474580
  474831
  475179
  475464
  475867
  477167
  477401
  477453
  477870
  480086
  482142
  483277
  483761
  485509
  485756
  487880
  488089
  491619
  491698
  492978
  493264
  493397
  495847
  497197
  497551
  499012
  501452
  506178
  508771
  510649
  511740
  512603
  515870
  516106
  517220
  518742
  519682
  519724
  521368
  522583
  523326
  523507
  524985
  525561
  527800
  529209
  548263
  554777
  555793
  561330
  571772
]
2.05 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в три хуя"
]
1.92 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.40%)
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.