Query Metrics

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

Queries

Group similar statements

# Time Info
1 2.07 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 2.04 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "gangbang girl"
]
3 234.54 ms
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
  397293
  410096
  282858
  389765
  513256
  569593
  720825
  814554
  446330
  514718
  715719
  651620
  680150
  597254
  603891
  746995
  395474
  451531
  533931
  572308
  575079
  575803
  648924
  664490
  679772
  680151
  648850
  666867
  677075
  680188
  548265
  549261
  576355
  634154
  636991
  637096
  630493
  587037
  597236
  775962
  748950
  752155
  634791
  400912
  408439
  445941
  395406
  405182
  361993
  522792
  521927
  423708
  522866
  530636
  536785
  542877
  582143
  582430
  560446
  690787
  706652
  722504
  680115
  648238
  648862
  665918
  679420
  679808
  680153
  696214
  632698
  635225
  639792
  590958
  597243
  597257
  597271
  601609
  630755
  606816
  632660
  636593
  639797
  597793
  603191
  775960
  788115
  775967
  758979
  733863
  733843
  634786
  421107
  396562
  451565
  470631
  500431
  527792
  401262
  815354
  818160
  815737
  815112
  815875
  453032
  515559
  544439
  557391
  567133
  568175
  549856
  647968
  650808
  680787
  682508
  676326
  680142
  671334
  673357
  681867
]
4 209.58 ms
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
  282858
  361993
  389765
  395406
  395474
  396562
  397293
  400912
  401262
  405182
  408439
  410096
  421107
  423708
  445941
  446330
  451531
  451565
  453032
  470631
  500431
  513256
  514718
  515559
  521927
  522792
  522866
  527792
  530636
  533931
  536785
  542877
  544439
  548265
  549261
  549856
  557391
  560446
  567133
  568175
  569593
  572308
  575079
  575803
  576355
  582143
  582430
  587037
  590958
  597236
  597243
  597254
  597257
  597271
  597793
  601609
  603191
  603891
  606816
  630493
  630755
  632660
  632698
  634154
  634786
  634791
  635225
  636593
  636991
  637096
  639792
  639797
  647968
  648238
  648850
  648862
  648924
  650808
  651620
  664490
  665918
  666867
  671334
  673357
  676326
  677075
  679420
  679772
  679808
  680115
  680142
  680150
  680151
  680153
  680188
  680787
  681867
  682508
  690787
  696214
  706652
  715719
  720825
  722504
  733843
  733863
  746995
  748950
  752155
  758979
  775960
  775962
  775967
  788115
  814554
  815112
  815354
  815737
  815875
  818160
]
5 166.91 ms
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
  282858
  361993
  389765
  395406
  395474
  396562
  397293
  400912
  401262
  405182
  408439
  410096
  421107
  423708
  445941
  446330
  451531
  451565
  453032
  470631
  500431
  513256
  514718
  515559
  521927
  522792
  522866
  527792
  530636
  533931
  536785
  542877
  544439
  548265
  549261
  549856
  557391
  560446
  567133
  568175
  569593
  572308
  575079
  575803
  576355
  582143
  582430
  587037
  590958
  597236
  597243
  597254
  597257
  597271
  597793
  601609
  603191
  603891
  606816
  630493
  630755
  632660
  632698
  634154
  634786
  634791
  635225
  636593
  636991
  637096
  639792
  639797
  647968
  648238
  648850
  648862
  648924
  650808
  651620
  664490
  665918
  666867
  671334
  673357
  676326
  677075
  679420
  679772
  679808
  680115
  680142
  680150
  680151
  680153
  680188
  680787
  681867
  682508
  690787
  696214
  706652
  715719
  720825
  722504
  733843
  733863
  746995
  748950
  752155
  758979
  775960
  775962
  775967
  788115
  814554
  815112
  815354
  815737
  815875
  818160
]
6 2.21 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "gangbang девушк"
]
7 212.41 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "gangbang девушк"
]

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.