Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.90 ms
(83.14%)
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
  338311
  383053
  401971
  404478
  404491
  407532
  407549
  413979
  415882
  417416
  421119
  424502
  428961
  433748
  444517
  444815
  448310
  450254
  453513
  454727
  462484
  462970
  464634
  471609
  473836
  475547
  476301
  476309
  477810
  479800
  485450
  489587
  492197
  496549
  501568
  506629
  511902
  513072
  519594
  519848
  525208
  531906
  539417
  540958
  543499
  548081
  551292
  554777
  555177
  561356
  565218
  583283
  586662
  586675
  591968
  599572
  603736
  612348
  613200
  624799
  625180
  625928
  643050
  643406
  643731
  646183
  650427
  654390
  660242
  661397
  663098
  663515
  665277
  666321
  668532
  668549
  671603
  675359
  675448
  685086
  712157
  717438
  718967
  719504
  719864
  728681
  731604
  732976
  743565
  743857
  745044
  749361
  750266
  751918
  758755
  765522
  767422
  778135
  781574
  782008
  788214
  789470
  791924
  801784
  802149
  802979
  804535
  804559
  805881
  806856
  807475
  807775
  807777
  815145
  815824
  816034
  816875
  821542
  823307
  825313
]
14.94 ms
(10.36%)
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
  815145
  816034
  823307
  660242
  661397
  675359
  685086
  718967
  548081
  625180
  789470
  802149
  804559
  767422
  802979
  745044
  758755
  749361
  731604
  717438
  791924
  801784
  583283
  477810
  806856
  807475
  511902
  643731
  586662
  643050
  513072
  561356
  743565
  383053
  765522
  448310
  551292
  444517
  554777
  654390
  404491
  404478
  407532
  413979
  450254
  462484
  473836
  489587
  496549
  501568
  646183
  675448
  586675
  782008
  807775
  417416
  453513
  476309
  401971
  428961
  433748
  421119
  424502
  462970
  471609
  476301
  479800
  485450
  492197
  525208
  519594
  519848
  555177
  540958
  666321
  816875
  815824
  821542
  650427
  668532
  719504
  663098
  663515
  665277
  719864
  599572
  613200
  643406
  805881
  804535
  728681
  743857
  732976
  750266
  751918
  778135
  788214
  807777
  531906
  781574
  671603
  565218
  624799
  591968
  444815
  464634
  543499
  415882
  407549
  539417
  668549
  603736
  475547
  506629
  625928
  612348
  338311
  454727
  712157
  825313
]
2.42 ms
(1.68%)
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
  338311
  383053
  401971
  404478
  404491
  407532
  407549
  413979
  415882
  417416
  421119
  424502
  428961
  433748
  444517
  444815
  448310
  450254
  453513
  454727
  462484
  462970
  464634
  471609
  473836
  475547
  476301
  476309
  477810
  479800
  485450
  489587
  492197
  496549
  501568
  506629
  511902
  513072
  519594
  519848
  525208
  531906
  539417
  540958
  543499
  548081
  551292
  554777
  555177
  561356
  565218
  583283
  586662
  586675
  591968
  599572
  603736
  612348
  613200
  624799
  625180
  625928
  643050
  643406
  643731
  646183
  650427
  654390
  660242
  661397
  663098
  663515
  665277
  666321
  668532
  668549
  671603
  675359
  675448
  685086
  712157
  717438
  718967
  719504
  719864
  728681
  731604
  732976
  743565
  743857
  745044
  749361
  750266
  751918
  758755
  765522
  767422
  778135
  781574
  782008
  788214
  789470
  791924
  801784
  802149
  802979
  804535
  804559
  805881
  806856
  807475
  807775
  807777
  815145
  815824
  816034
  816875
  821542
  823307
  825313
]
2.07 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "massage big ass"
]
1.66 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "массаж большая большие жоп"
]
1.61 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.