Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.06 ms
(85.43%)
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
  384562
  386567
  402032
  404470
  428877
  451608
  457001
  465123
  466817
  486830
  507481
  511199
  525367
  528334
  531879
  538448
  542167
  554121
  567984
  570145
  575344
  579528
  579650
  584691
  590105
  598302
  601955
  603919
  604287
  610109
  616429
  616473
  616505
  617552
  618712
  624994
  630239
  633999
  646964
  647682
  648744
  651800
  658728
  663250
  664634
  666697
  668713
  673102
  677921
  683092
  683560
  684513
  692103
  697108
  698496
  702006
  702047
  702971
  705385
  708680
  711637
  714175
  716115
  717130
  718491
  718492
  719210
  720090
  720407
  720536
  722127
  722833
  730301
  735866
  740185
  744283
  745765
  749522
  750626
  760597
  767793
  774295
  774883
  775679
  778032
  779114
  779365
  781370
  781978
  783194
  787997
  788111
  789455
  789926
  790514
  791681
  792578
  793257
  795157
  795628
  796027
  796055
  797728
  800702
  801419
  801839
  802106
  802879
  804100
  806025
  809503
  810147
  810414
  811428
  814285
  819110
  823813
  824164
  826883
]
14.96 ms
(8.75%)
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
  601955
  603919
  697108
  698496
  702971
  705385
  714175
  718492
  720536
  775679
  779114
  781370
  793257
  795157
  801419
  801839
  802879
  804100
  811428
  402032
  384562
  466817
  404470
  386567
  428877
  814285
  819110
  824164
  827961
  823813
  826883
  486830
  451608
  465123
  457001
  511199
  525367
  528334
  538448
  507481
  531879
  567984
  575344
  542167
  554121
  570145
  584691
  579650
  648744
  658728
  663250
  666697
  668713
  692103
  702006
  711637
  718491
  720407
  722127
  722833
  646964
  651800
  664634
  673102
  684513
  708680
  717130
  720090
  647682
  677921
  683092
  683560
  702047
  716115
  719210
  579528
  610109
  616505
  617552
  630239
  633999
  590105
  604287
  616429
  618712
  624994
  598302
  616473
  774883
  781978
  787997
  788111
  790514
  795628
  806025
  778032
  779365
  791681
  796027
  796055
  800702
  809503
  810147
  744283
  745765
  750626
  760597
  774295
  783194
  789455
  789926
  792578
  797728
  802106
  810414
  730301
  735866
  740185
  749522
  767793
]
2.75 ms
(1.61%)
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
  384562
  386567
  402032
  404470
  428877
  451608
  457001
  465123
  466817
  486830
  507481
  511199
  525367
  528334
  531879
  538448
  542167
  554121
  567984
  570145
  575344
  579528
  579650
  584691
  590105
  598302
  601955
  603919
  604287
  610109
  616429
  616473
  616505
  617552
  618712
  624994
  630239
  633999
  646964
  647682
  648744
  651800
  658728
  663250
  664634
  666697
  668713
  673102
  677921
  683092
  683560
  684513
  692103
  697108
  698496
  702006
  702047
  702971
  705385
  708680
  711637
  714175
  716115
  717130
  718491
  718492
  719210
  720090
  720407
  720536
  722127
  722833
  730301
  735866
  740185
  744283
  745765
  749522
  750626
  760597
  767793
  774295
  774883
  775679
  778032
  779114
  779365
  781370
  781978
  783194
  787997
  788111
  789455
  789926
  790514
  791681
  792578
  793257
  795157
  795628
  796027
  796055
  797728
  800702
  801419
  801839
  802106
  802879
  804100
  806025
  809503
  810147
  810414
  811428
  814285
  819110
  823813
  824164
  826883
]
2.24 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy hard"
]
1.72 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy hard"
]
1.71 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy hard"
]

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.