Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.60 ms
(82.11%)
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
  31503
  53553
  96521
  96997
  182749
  309449
  341622
  383641
  387251
  390024
  390680
  391275
  393326
  393677
  395674
  395727
  397232
  397306
  398908
  401184
  409828
  410941
  411014
  411681
  417881
  419064
  420190
  420559
  423657
  426032
  426197
  429763
  429799
  440654
  443218
  443243
  452843
  461086
  509805
  509808
  510395
  515833
  515892
  517847
  522130
  523312
  524183
  527412
  530039
  530054
  530788
  530798
  531239
  531260
  531261
  531836
  531840
  531849
  531861
  532653
  532792
  532804
  532948
  533064
  533371
  533382
  533556
  533949
  534028
  534551
  535358
  535644
  536288
  536290
  536339
  536616
  536681
  537675
  537913
  538817
  540291
  542975
  565243
  583711
  583921
  599852
  617410
  629333
  631162
  632601
  633521
  634122
  636288
  637008
  639784
  642000
  647939
  649497
  649579
  650175
  665973
  676022
  676092
  677307
  678073
  713113
  717849
  721711
  740269
  748530
  748926
  756219
  759948
  794557
  801275
  801923
  808327
  827874
  827899
]
16.87 ms
(10.77%)
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
  509805
  509808
  583921
  398908
  401184
  96521
  524183
  533064
  631162
  637008
  794557
  756219
  748926
  717849
  721711
  31503
  759948
  390024
  397306
  419064
  523312
  96997
  409828
  411014
  440654
  533949
  565243
  649497
  429799
  533371
  536616
  534551
  665973
  676022
  632601
  393326
  531840
  531861
  713113
  740269
  393677
  420559
  534028
  531836
  531849
  443218
  530039
  531260
  536290
  536681
  540291
  522130
  532792
  533556
  535358
  531261
  532948
  536288
  537913
  530788
  532653
  542975
  649579
  678073
  629333
  642000
  599852
  634122
  801923
  633521
  341622
  397232
  417881
  827874
  827899
  182749
  53553
  387251
  533382
  517847
  647939
  639784
  391275
  426032
  443243
  429763
  410941
  452843
  531239
  532804
  530054
  530798
  538817
  636288
  807580
  808327
  748530
  309449
  383641
  395727
  515833
  677307
  801275
  537675
  617410
  583711
  390680
  420190
  426197
  423657
  536339
  515892
  535644
  650175
  676092
  395674
  411681
  461086
  510395
  527412
]
3.36 ms
(2.15%)
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
  31503
  53553
  96521
  96997
  182749
  309449
  341622
  383641
  387251
  390024
  390680
  391275
  393326
  393677
  395674
  395727
  397232
  397306
  398908
  401184
  409828
  410941
  411014
  411681
  417881
  419064
  420190
  420559
  423657
  426032
  426197
  429763
  429799
  440654
  443218
  443243
  452843
  461086
  509805
  509808
  510395
  515833
  515892
  517847
  522130
  523312
  524183
  527412
  530039
  530054
  530788
  530798
  531239
  531260
  531261
  531836
  531840
  531849
  531861
  532653
  532792
  532804
  532948
  533064
  533371
  533382
  533556
  533949
  534028
  534551
  535358
  535644
  536288
  536290
  536339
  536616
  536681
  537675
  537913
  538817
  540291
  542975
  565243
  583711
  583921
  599852
  617410
  629333
  631162
  632601
  633521
  634122
  636288
  637008
  639784
  642000
  647939
  649497
  649579
  650175
  665973
  676022
  676092
  677307
  678073
  713113
  717849
  721711
  740269
  748530
  748926
  756219
  759948
  794557
  801275
  801923
  808327
  827874
  827899
]
2.09 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "extreme double anal"
]
2.03 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор double анал"
]
1.73 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хардкор double анал"
]

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.