Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.83 ms
(53.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
147.60 ms
(37.40%)
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
  401880
  414341
  421146
  429761
  429762
  429801
  443476
  443480
  447150
  447152
  447668
  447926
  452606
  453356
  458555
  478973
  482534
  497870
  499105
  511254
  530476
  530480
  530487
  530489
  530491
  530493
  530627
  530643
  531104
  531139
  531157
  531163
  531210
  531211
  531232
  531262
  531419
  534028
  534650
  534985
  535006
  535054
  535620
  536582
  536608
  536681
  537209
  537654
  537763
  537910
  539239
  540400
  540408
  540434
  541856
  542580
  542583
  542590
  542595
  544803
  565247
  565253
  565254
  565266
  582217
  588301
  596643
  597237
  599902
  599908
  599917
  599941
  599945
  599994
  600290
  600295
  600332
  600334
  601514
  601517
  628376
  628391
  628403
  628415
  633478
  633748
  633758
  634777
  647885
  649215
  649498
  649545
  649595
  650846
  651147
  651599
  656568
  656574
  666852
  666866
  666881
  666897
  674980
  676110
  677295
  677801
  678066
  678126
  678138
  678144
  678161
  687257
  696947
  708447
  731665
  733840
  733879
  733908
  748931
  820779
]
26.96 ms
(6.83%)
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
  666852
  588301
  536608
  452606
  414341
  531419
  708447
  582217
  666866
  401880
  499105
  531262
  530480
  599908
  748931
  530627
  531210
  534650
  540408
  531211
  530643
  565266
  677295
  599917
  601514
  596643
  628403
  429801
  531104
  537209
  599941
  733908
  731665
  674980
  656574
  678138
  429761
  443480
  530493
  447150
  453356
  536681
  540434
  534985
  542590
  542595
  565253
  733879
  421146
  511254
  535006
  656568
  649498
  597237
  678126
  447668
  651599
  633748
  633758
  535054
  820779
  531232
  530476
  531139
  458555
  429762
  447152
  531157
  537763
  539239
  530489
  540400
  542583
  666881
  678161
  649215
  677801
  651147
  666897
  678066
  565247
  599945
  628376
  600290
  599902
  599994
  600334
  601517
  633478
  482534
  530491
  535620
  537910
  544803
  676110
  647885
  649545
  649595
  650846
  600295
  696947
  443476
  634777
  497870
  447926
  531163
  537654
  534028
  530487
  541856
  565254
  542580
  687257
  628415
  628391
  733840
  478973
  536582
  678144
  600332
]
2.86 ms
(0.73%)
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
  401880
  414341
  421146
  429761
  429762
  429801
  443476
  443480
  447150
  447152
  447668
  447926
  452606
  453356
  458555
  478973
  482534
  497870
  499105
  511254
  530476
  530480
  530487
  530489
  530491
  530493
  530627
  530643
  531104
  531139
  531157
  531163
  531210
  531211
  531232
  531262
  531419
  534028
  534650
  534985
  535006
  535054
  535620
  536582
  536608
  536681
  537209
  537654
  537763
  537910
  539239
  540400
  540408
  540434
  541856
  542580
  542583
  542590
  542595
  544803
  565247
  565253
  565254
  565266
  582217
  588301
  596643
  597237
  599902
  599908
  599917
  599941
  599945
  599994
  600290
  600295
  600332
  600334
  601514
  601517
  628376
  628391
  628403
  628415
  633478
  633748
  633758
  634777
  647885
  649215
  649498
  649545
  649595
  650846
  651147
  651599
  656568
  656574
  666852
  666866
  666881
  666897
  674980
  676110
  677295
  677801
  678066
  678126
  678138
  678144
  678161
  687257
  696947
  708447
  731665
  733840
  733879
  733908
  748931
  820779
]
2.11 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dap big tits"
]
1.68 ms
(0.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "dap большие сиськ"
]
1.58 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "dap большие сиськ"
]

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.