Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.27 ms
(84.25%)
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
  233683
  411350
  411362
  415246
  422273
  422354
  422394
  424042
  427135
  439589
  439633
  442441
  442989
  446902
  448288
  451495
  459190
  459636
  459715
  461814
  462172
  463469
  464526
  465362
  465909
  466343
  466357
  466761
  467818
  469117
  469680
  470654
  473793
  475200
  475621
  475942
  476419
  477088
  477974
  479606
  480689
  480912
  481430
  483306
  484147
  484646
  489022
  490952
  492644
  493193
  494587
  495326
  495732
  497044
  504721
  506039
  507412
  508610
  508801
  508871
  509159
  509264
  509747
  509761
  512424
  513377
  514000
  514041
  517299
  520107
  520810
  520897
  522337
  523978
  525412
  525455
  528321
  534494
  544099
  545493
  546664
  546897
  549570
  549576
  553023
  561990
  563299
  581072
  590392
  595396
  595421
  596648
  597584
  598457
  609714
  610260
  612514
  614983
  623031
  626969
  637589
  659986
  674278
  695401
  700926
  718551
  730970
  736928
  742657
  745474
  753497
  755013
  757112
  780852
  784189
  785811
  794153
  794874
  795654
  806242
]
17.05 ms
(9.25%)
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
  549570
  581072
  546664
  549576
  597584
  590392
  596648
  598457
  595421
  614983
  427135
  233683
  473793
  442989
  465909
  466343
  506039
  517299
  509761
  422394
  442441
  544099
  553023
  610260
  612514
  780852
  794874
  745474
  795654
  626969
  475200
  718551
  785811
  411362
  415246
  439589
  465362
  477974
  439633
  464526
  480689
  470654
  509747
  493193
  520897
  484646
  495326
  467818
  475621
  494587
  509159
  545493
  637589
  459190
  462172
  469117
  480912
  451495
  466761
  475942
  479606
  424042
  459636
  459715
  469680
  481430
  461814
  477088
  509264
  523978
  483306
  484147
  492644
  508610
  508801
  513377
  525412
  525455
  497044
  508871
  512424
  514041
  520107
  522337
  528321
  489022
  490952
  495732
  507412
  514000
  520810
  700926
  674278
  695401
  609714
  794153
  753497
  755013
  784189
  742657
  806242
  736928
  563299
  466357
  463469
  504721
  546897
  561990
  422354
  411350
  730970
  757112
  534494
  659986
  623031
  595396
  422273
  446902
  476419
  448288
]
3.20 ms
(1.74%)
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
  233683
  411350
  411362
  415246
  422273
  422354
  422394
  424042
  427135
  439589
  439633
  442441
  442989
  446902
  448288
  451495
  459190
  459636
  459715
  461814
  462172
  463469
  464526
  465362
  465909
  466343
  466357
  466761
  467818
  469117
  469680
  470654
  473793
  475200
  475621
  475942
  476419
  477088
  477974
  479606
  480689
  480912
  481430
  483306
  484147
  484646
  489022
  490952
  492644
  493193
  494587
  495326
  495732
  497044
  504721
  506039
  507412
  508610
  508801
  508871
  509159
  509264
  509747
  509761
  512424
  513377
  514000
  514041
  517299
  520107
  520810
  520897
  522337
  523978
  525412
  525455
  528321
  534494
  544099
  545493
  546664
  546897
  549570
  549576
  553023
  561990
  563299
  581072
  590392
  595396
  595421
  596648
  597584
  598457
  609714
  610260
  612514
  614983
  623031
  626969
  637589
  659986
  674278
  695401
  700926
  718551
  730970
  736928
  742657
  745474
  753497
  755013
  757112
  780852
  784189
  785811
  794153
  794874
  795654
  806242
]
2.85 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ukrainian ass"
]
2.36 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие русск жоп"
]
2.07 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие русск жоп"
]
1.49 ms
(0.81%)
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.