Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
111.36 ms
(83.84%)
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
  388312
  413029
  423637
  425195
  449502
  483771
  507929
  511462
  541347
  543538
  543600
  555471
  556079
  567734
  570134
  570962
  571110
  581192
  590525
  612787
  620581
  622159
  625743
  634961
  635782
  640392
  647192
  651220
  653065
  653844
  656252
  661901
  675167
  675185
  680378
  682612
  684863
  684893
  685935
  689054
  689930
  691761
  693669
  698249
  698252
  699304
  702993
  705435
  712201
  713002
  714389
  715070
  715604
  716950
  718113
  720852
  726899
  727729
  727985
  728568
  729197
  730442
  730972
  734537
  735281
  735925
  736686
  737532
  737841
  738320
  738522
  741073
  741524
  744416
  747245
  750703
  753158
  757174
  760266
  760621
  761011
  765942
  767449
  767878
  768331
  768641
  772662
  773430
  773798
  775290
  777276
  777675
  778122
  780585
  780977
  782418
  782433
  785692
  786534
  787690
  788233
  788560
  791874
  792245
  793588
  795059
  795824
  796348
  796765
  798527
  800159
  800729
  800734
  802051
  802329
  808316
  809903
  814433
  818465
  824498
]
13.13 ms
(9.88%)
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
  792245
  782418
  423637
  507929
  675167
  800159
  753158
  388312
  413029
  824498
  818465
  449502
  715070
  741073
  425195
  814433
  483771
  511462
  541347
  543600
  570134
  570962
  581192
  567734
  543538
  556079
  680378
  684863
  684893
  685935
  691761
  693669
  699304
  702993
  651220
  653844
  656252
  675185
  682612
  689930
  705435
  712201
  713002
  714389
  716950
  647192
  653065
  661901
  689054
  698249
  698252
  715604
  718113
  720852
  555471
  571110
  620581
  622159
  634961
  590525
  612787
  635782
  625743
  640392
  777276
  777675
  778122
  780977
  786534
  793588
  795059
  795824
  796348
  800729
  802329
  775290
  780585
  782433
  787690
  788560
  791874
  796765
  800734
  809903
  727729
  727985
  728568
  729197
  735925
  747245
  757174
  760621
  761011
  767449
  768641
  772662
  785692
  788233
  798527
  802051
  808316
  730972
  734537
  736686
  737532
  737841
  741524
  744416
  750703
  760266
  765942
  767878
  768331
  773430
  773798
  726899
  730442
  735281
  738320
  738522
]
2.08 ms
(1.57%)
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
  388312
  413029
  423637
  425195
  449502
  483771
  507929
  511462
  541347
  543538
  543600
  555471
  556079
  567734
  570134
  570962
  571110
  581192
  590525
  612787
  620581
  622159
  625743
  634961
  635782
  640392
  647192
  651220
  653065
  653844
  656252
  661901
  675167
  675185
  680378
  682612
  684863
  684893
  685935
  689054
  689930
  691761
  693669
  698249
  698252
  699304
  702993
  705435
  712201
  713002
  714389
  715070
  715604
  716950
  718113
  720852
  726899
  727729
  727985
  728568
  729197
  730442
  730972
  734537
  735281
  735925
  736686
  737532
  737841
  738320
  738522
  741073
  741524
  744416
  747245
  750703
  753158
  757174
  760266
  760621
  761011
  765942
  767449
  767878
  768331
  768641
  772662
  773430
  773798
  775290
  777276
  777675
  778122
  780585
  780977
  782418
  782433
  785692
  786534
  787690
  788233
  788560
  791874
  792245
  793588
  795059
  795824
  796348
  796765
  798527
  800159
  800729
  800734
  802051
  802329
  808316
  809903
  814433
  818465
  824498
]
1.84 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm pussy cum"
]
1.48 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм pussy cum"
]
1.47 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм pussy cum"
]

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.