Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
415.81 ms
(71.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "her boobs"
]
145.65 ms
(24.95%)
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
  185296
  191336
  387472
  421809
  432228
  440726
  447886
  448427
  449716
  452345
  456037
  456647
  456707
  457475
  458313
  460663
  464296
  464298
  469500
  469582
  471657
  474443
  484533
  485720
  493443
  496301
  496549
  497037
  503733
  505342
  510516
  512897
  514878
  515982
  519908
  525621
  526578
  528716
  532519
  535379
  535483
  538912
  540071
  543180
  543311
  543492
  546402
  556592
  557496
  558772
  568640
  580847
  582852
  609376
  610223
  621347
  626369
  630519
  650435
  650992
  664221
  680541
  720524
  726116
  733105
  735541
  738297
  738852
  744186
  748017
  770173
  773204
  773681
  774591
  797069
  802427
  813917
  814753
  814783
  814787
  814840
  814885
  815305
  815367
  815520
  815608
  815755
  815902
  816780
  816816
  816839
  817579
  818205
  818808
  818849
  819148
  819239
  819254
  820330
  821069
  824174
  825338
  825356
  826376
  826393
  826959
  827583
  828001
  828060
  828194
  828229
  828313
  828490
  828596
  828709
  828802
]
14.46 ms
(2.48%)
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
  826376
  816780
  818808
  826959
  815902
  818205
  825338
  825356
  826393
  828001
  828194
  828802
  828081
  828040
  828490
  828596
  535379
  512897
  558772
  546402
  720524
  802427
  733105
  744186
  191336
  557496
  556592
  582852
  650435
  680541
  610223
  626369
  774591
  773681
  738297
  770173
  738852
  609376
  505342
  528716
  519908
  540071
  650992
  621347
  440726
  387472
  816816
  826228
  816839
  827583
  817579
  819148
  819254
  824404
  818849
  819239
  828229
  828060
  828313
  828709
  535483
  543492
  664221
  630519
  797069
  748017
  726116
  773204
  735541
  185296
  432228
  421809
  813917
  815305
  815367
  814753
  815608
  815755
  820330
  814783
  814840
  814885
  815520
  814787
  821069
  824174
  448427
  456647
  456707
  457475
  469500
  484533
  485720
  447886
  449716
  458313
  452345
  456037
  460663
  471657
  493443
  496549
  503733
  497037
  525621
  538912
  514878
  496301
  510516
  515982
  526578
  532519
  464296
  464298
  469582
  474443
  543311
  568640
  580847
  543180
]
2.50 ms
(0.43%)
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
  185296
  191336
  387472
  421809
  432228
  440726
  447886
  448427
  449716
  452345
  456037
  456647
  456707
  457475
  458313
  460663
  464296
  464298
  469500
  469582
  471657
  474443
  484533
  485720
  493443
  496301
  496549
  497037
  503733
  505342
  510516
  512897
  514878
  515982
  519908
  525621
  526578
  528716
  532519
  535379
  535483
  538912
  540071
  543180
  543311
  543492
  546402
  556592
  557496
  558772
  568640
  580847
  582852
  609376
  610223
  621347
  626369
  630519
  650435
  650992
  664221
  680541
  720524
  726116
  733105
  735541
  738297
  738852
  744186
  748017
  770173
  773204
  773681
  774591
  797069
  802427
  813917
  814753
  814783
  814787
  814840
  814885
  815305
  815367
  815520
  815608
  815755
  815902
  816780
  816816
  816839
  817579
  818205
  818808
  818849
  819148
  819239
  819254
  820330
  821069
  824174
  825338
  825356
  826376
  826393
  826959
  827583
  828001
  828060
  828194
  828229
  828313
  828490
  828596
  828709
  828802
]
1.90 ms
(0.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "her boobs"
]
1.71 ms
(0.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "her boobs"
]
1.65 ms
(0.28%)
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.