Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
421.45 ms
(53.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск черноволосая"
]
209.79 ms
(26.74%)
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
  86241
  125809
  382693
  385224
  390012
  391898
  395809
  396379
  401374
  403603
  405687
  407409
  421637
  421831
  424024
  424048
  428035
  429867
  429950
  435471
  438540
  438858
  439659
  443420
  445092
  447234
  449316
  449764
  453960
  455071
  455194
  455642
  456589
  457060
  457109
  458038
  458333
  461836
  463235
  467922
  469308
  470630
  473933
  474954
  475853
  478728
  480662
  481624
  483528
  485043
  488037
  488520
  488961
  490199
  492986
  493042
  493937
  495104
  495929
  498432
  498847
  500585
  501679
  507638
  509586
  511873
  512402
  514060
  515264
  521531
  521629
  521803
  524690
  526802
  529470
  546660
  549596
  553118
  553354
  554983
  556537
  557940
  561291
  567682
  580206
  584456
  584690
  588508
  589813
  591478
  593197
  593781
  594045
  594983
  599115
  599454
  600439
  602758
  616545
  618249
  618345
  621270
  623230
  637965
  662449
  664595
  668815
  671875
  672317
  686977
  694044
  696075
  697166
  708062
  752913
  823853
  824718
  826332
]
129.98 ms
(16.57%)
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
  86241
  125809
  382693
  385224
  390012
  391898
  395809
  396379
  401374
  403603
  405687
  407409
  421637
  421831
  424024
  424048
  428035
  429867
  429950
  435471
  438540
  438858
  439659
  443420
  445092
  447234
  449316
  449764
  453960
  455071
  455194
  455642
  456589
  457060
  457109
  458038
  458333
  461836
  463235
  467922
  469308
  470630
  473933
  474954
  475853
  478728
  480662
  481624
  483528
  485043
  488037
  488520
  488961
  490199
  492986
  493042
  493937
  495104
  495929
  498432
  498847
  500585
  501679
  507638
  509586
  511873
  512402
  514060
  515264
  521531
  521629
  521803
  524690
  526802
  529470
  546660
  549596
  553118
  553354
  554983
  556537
  557940
  561291
  567682
  580206
  584456
  584690
  588508
  589813
  591478
  593197
  593781
  594045
  594983
  599115
  599454
  600439
  602758
  616545
  618249
  618345
  621270
  623230
  637965
  662449
  664595
  668815
  671875
  672317
  686977
  694044
  696075
  697166
  708062
  752913
  823853
  824718
  826332
]
17.17 ms
(2.19%)
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
  396379
  438540
  447234
  449316
  455071
  455642
  467922
  86241
  445092
  385224
  401374
  407409
  424024
  457060
  458038
  511873
  495104
  529470
  488520
  488961
  429950
  557940
  521629
  458333
  553354
  567682
  580206
  588508
  623230
  599115
  752913
  424048
  469308
  483528
  493042
  826332
  382693
  602758
  594045
  439659
  823853
  668815
  618345
  457109
  480662
  526802
  492986
  824784
  825375
  824718
  478728
  481624
  495929
  512402
  493937
  584456
  546660
  553118
  708062
  664595
  686977
  694044
  697166
  662449
  672317
  696075
  556537
  591478
  616545
  599454
  593197
  594983
  600439
  637965
  589813
  593781
  618249
  521531
  490199
  498847
  488037
  500585
  514060
  521803
  671875
  428035
  435471
  443420
  449764
  584690
  561291
  621270
  438858
  421831
  429867
  524690
  507638
  125809
  391898
  395809
  390012
  403603
  405687
  421637
  453960
  456589
  455194
  461836
  463235
  470630
  473933
  475853
  498432
  501679
  509586
  515264
  474954
  485043
  549596
  554983
]
2.25 ms
(0.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"домашнее брюнетки отÑ%…"
]
2.01 ms
(0.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск черноволосая"
]
1.88 ms
(0.24%)
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.