Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.70 ms
(53.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск домашн любительск orgasm"
]
167.18 ms
(41.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
  423861
  424202
  428375
  431718
  437369
  437723
  437950
  438025
  438503
  438641
  441755
  445768
  446425
  448894
  450509
  455547
  459686
  466478
  476637
  481121
  484178
  496004
  500304
  502752
  516353
  529086
  539078
  551611
  564022
  590552
  616007
  616808
  619979
  622791
  657781
  664181
  667933
  669305
  672791
  672816
  674872
  682954
  685832
  688829
  692733
  695552
  695767
  696366
  697217
  701266
  704584
  704587
  707578
  713749
  713977
  721311
  730662
  734251
  735958
  737363
  741796
  741824
  742195
  742657
  743658
  744408
  746824
  749564
  751310
  751314
  751446
  758395
  758552
  759648
  763402
  765518
  766317
  768244
  773158
  773187
  774855
  777840
  780165
  782120
  783287
  783342
  785461
  787523
  788782
  790075
  790316
  792470
  792479
  792677
  794058
  794082
  796375
  796409
  796992
  797599
  797918
  799832
  799834
  800691
  801580
  802098
  803159
  803385
  805261
  807290
  808566
  809600
  809673
  809911
  810398
  812149
  812663
  818062
  824733
]
15.56 ms
(3.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
  797918
  730662
  737363
  735958
  766317
  768244
  783342
  788782
  792470
  797599
  801457
  809911
  812149
  685832
  438025
  438503
  818062
  481121
  455547
  445768
  438641
  551611
  707578
  669305
  682954
  695552
  696366
  697217
  704584
  619979
  704587
  423861
  502752
  701266
  564022
  674872
  672816
  431718
  743658
  428375
  672791
  667933
  780165
  790316
  777840
  742195
  758395
  765518
  785461
  794082
  800691
  751314
  751446
  742657
  744408
  746824
  749564
  758552
  773158
  751310
  721311
  437950
  466478
  437723
  446425
  529086
  616808
  539078
  448894
  741824
  424202
  824733
  500304
  713977
  792479
  794058
  799834
  801580
  805261
  808566
  774855
  790075
  796375
  796992
  802098
  807290
  812663
  773187
  799832
  803159
  803385
  759648
  763402
  741796
  782120
  783287
  787523
  792677
  796409
  809600
  809673
  810398
  496004
  441755
  437369
  459686
  450509
  476637
  590552
  484178
  516353
  692733
  695767
  657781
  664181
  688829
  713749
  616007
  622791
  734251
]
3.30 ms
(0.81%)
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
  423861
  424202
  428375
  431718
  437369
  437723
  437950
  438025
  438503
  438641
  441755
  445768
  446425
  448894
  450509
  455547
  459686
  466478
  476637
  481121
  484178
  496004
  500304
  502752
  516353
  529086
  539078
  551611
  564022
  590552
  616007
  616808
  619979
  622791
  657781
  664181
  667933
  669305
  672791
  672816
  674872
  682954
  685832
  688829
  692733
  695552
  695767
  696366
  697217
  701266
  704584
  704587
  707578
  713749
  713977
  721311
  730662
  734251
  735958
  737363
  741796
  741824
  742195
  742657
  743658
  744408
  746824
  749564
  751310
  751314
  751446
  758395
  758552
  759648
  763402
  765518
  766317
  768244
  773158
  773187
  774855
  777840
  780165
  782120
  783287
  783342
  785461
  787523
  788782
  790075
  790316
  792470
  792479
  792677
  794058
  794082
  796375
  796409
  796992
  797599
  797918
  799832
  799834
  800691
  801580
  802098
  803159
  803385
  805261
  807290
  808566
  809600
  809673
  809911
  810398
  812149
  812663
  818062
  824733
]
1.93 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian homemade orgasm"
]
1.56 ms
(0.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск домашн любительск orgasm"
]
1.44 ms
(0.35%)
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.