Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
404.62 ms
(93.45%)
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
  381777
  386531
  387973
  399522
  401300
  401866
  407454
  408831
  415540
  415582
  418958
  419856
  425544
  425968
  427262
  428095
  435613
  438060
  441417
  444475
  445072
  445081
  446321
  446577
  446716
  446997
  447878
  448104
  448313
  450809
  452786
  452896
  453375
  453574
  453861
  454089
  454428
  454432
  455120
  455343
  456098
  457645
  457839
  457955
  458981
  459630
  459847
  460279
  460651
  460810
  462816
  463217
  463347
  463869
  464036
  464314
  464429
  465079
  465224
  465290
  466150
  466891
  467728
  469002
  469013
  471190
  472505
  472578
  472933
  473156
  473851
  474720
  474825
  474870
  475368
  475483
  475811
  476302
  477104
  478805
  480058
  481959
  482098
  485158
  486809
  487547
  489272
  489987
  497402
  498363
  499187
  499862
  500635
  500710
  503317
  505156
  506346
  510478
  516838
  517922
  521778
  524373
  526799
  527169
  527884
  527904
  528054
  528845
  529424
  529864
  538665
  542682
  553096
  569447
  587489
  599299
  635977
  710872
  769575
  771005
]
17.78 ms
(4.11%)
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
  457955
  446321
  448313
  481959
  381777
  386531
  399522
  408831
  438060
  446997
  387973
  419856
  452896
  463347
  467728
  477104
  503317
  497402
  498363
  527904
  529424
  425968
  428095
  407454
  441417
  445081
  427262
  454089
  463869
  474720
  456098
  457839
  459630
  471190
  473156
  473851
  480058
  459847
  464314
  466150
  500635
  529864
  472578
  452786
  460279
  462816
  463217
  435613
  482098
  418958
  527169
  505156
  506346
  472505
  401300
  445072
  444475
  446716
  464036
  528054
  538665
  542682
  569447
  710872
  635977
  587489
  769575
  771005
  401866
  425544
  415540
  453375
  454428
  454432
  455120
  448104
  465224
  472933
  453574
  458981
  460651
  466891
  474825
  474870
  485158
  521778
  527884
  516838
  460810
  464429
  476302
  453861
  475368
  446577
  450809
  469002
  475811
  465079
  465290
  469013
  455343
  489272
  500710
  517922
  526799
  487547
  489987
  524373
  499187
  475483
  553096
  599299
  528845
  415582
  447878
  457645
  478805
  486809
  499862
  510478
]
3.37 ms
(0.78%)
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
  381777
  386531
  387973
  399522
  401300
  401866
  407454
  408831
  415540
  415582
  418958
  419856
  425544
  425968
  427262
  428095
  435613
  438060
  441417
  444475
  445072
  445081
  446321
  446577
  446716
  446997
  447878
  448104
  448313
  450809
  452786
  452896
  453375
  453574
  453861
  454089
  454428
  454432
  455120
  455343
  456098
  457645
  457839
  457955
  458981
  459630
  459847
  460279
  460651
  460810
  462816
  463217
  463347
  463869
  464036
  464314
  464429
  465079
  465224
  465290
  466150
  466891
  467728
  469002
  469013
  471190
  472505
  472578
  472933
  473156
  473851
  474720
  474825
  474870
  475368
  475483
  475811
  476302
  477104
  478805
  480058
  481959
  482098
  485158
  486809
  487547
  489272
  489987
  497402
  498363
  499187
  499862
  500635
  500710
  503317
  505156
  506346
  510478
  516838
  517922
  521778
  524373
  526799
  527169
  527884
  527904
  528054
  528845
  529424
  529864
  538665
  542682
  553096
  569447
  587489
  599299
  635977
  710872
  769575
  771005
]
2.11 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge white tits"
]
1.98 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные white сиськ"
]
1.76 ms
(0.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "огромные white сиськ"
]

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.