Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.53 ms
(83.48%)
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
  3417
  10006
  28386
  80663
  172555
  383186
  383419
  383472
  387245
  387270
  389389
  393572
  395737
  396973
  398023
  398759
  399000
  399253
  400425
  400443
  401644
  405417
  414688
  417692
  420133
  426606
  428880
  429095
  431542
  446771
  447629
  462397
  462763
  466320
  466623
  470740
  471403
  473905
  476387
  478895
  479321
  479331
  486944
  491067
  493323
  495027
  501672
  506063
  510640
  512312
  524270
  524792
  526034
  529030
  530348
  534066
  539534
  551168
  552210
  562226
  562308
  563249
  568299
  568600
  570251
  570553
  571631
  573420
  573583
  573811
  573910
  573970
  576038
  578473
  579687
  581659
  581705
  583398
  591747
  592735
  592906
  598136
  601877
  603304
  605478
  612861
  618882
  619080
  632688
  650493
  651945
  657139
  660481
  663441
  713367
  718710
  720506
  729933
  730764
  734832
  736327
  741998
  743044
  743131
  745457
  748147
  758552
  759564
  765244
  775568
  778376
  787936
  795470
  796789
  799725
  799737
  800282
  801217
  801709
  804902
]
21.00 ms
(10.92%)
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
  730764
  745457
  799725
  470740
  479331
  389389
  446771
  478895
  510640
  529030
  581705
  581659
  393572
  395737
  10006
  387270
  400425
  400443
  401644
  428880
  417692
  447629
  479321
  568600
  573910
  576038
  663441
  601877
  598136
  605478
  618882
  743131
  718710
  466623
  399253
  426606
  491067
  493323
  495027
  506063
  398023
  657139
  619080
  795470
  775568
  736327
  399000
  471403
  578473
  524792
  383419
  632688
  778376
  486944
  405417
  804902
  172555
  3417
  396973
  431542
  563249
  573420
  552210
  660481
  720506
  713367
  801217
  759564
  765244
  796789
  758552
  743044
  787936
  799737
  800282
  387245
  414688
  28386
  466320
  512312
  524270
  539534
  501672
  603304
  612861
  476387
  383186
  568299
  383472
  462397
  530348
  562308
  573970
  583398
  551168
  570553
  579687
  651945
  650493
  562226
  570251
  571631
  573583
  573811
  592906
  591747
  592735
  729933
  741998
  748147
  734832
  801709
  80663
  398759
  429095
  462763
  420133
  473905
  526034
  534066
]
4.22 ms
(2.20%)
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
  3417
  10006
  28386
  80663
  172555
  383186
  383419
  383472
  387245
  387270
  389389
  393572
  395737
  396973
  398023
  398759
  399000
  399253
  400425
  400443
  401644
  405417
  414688
  417692
  420133
  426606
  428880
  429095
  431542
  446771
  447629
  462397
  462763
  466320
  466623
  470740
  471403
  473905
  476387
  478895
  479321
  479331
  486944
  491067
  493323
  495027
  501672
  506063
  510640
  512312
  524270
  524792
  526034
  529030
  530348
  534066
  539534
  551168
  552210
  562226
  562308
  563249
  568299
  568600
  570251
  570553
  571631
  573420
  573583
  573811
  573910
  573970
  576038
  578473
  579687
  581659
  581705
  583398
  591747
  592735
  592906
  598136
  601877
  603304
  605478
  612861
  618882
  619080
  632688
  650493
  651945
  657139
  660481
  663441
  713367
  718710
  720506
  729933
  730764
  734832
  736327
  741998
  743044
  743131
  745457
  748147
  758552
  759564
  765244
  775568
  778376
  787936
  795470
  796789
  799725
  799737
  800282
  801217
  801709
  804902
]
2.10 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "порно молодой девушки…"
]
1.61 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "порн молодой девушк"
]
1.54 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.29 ms
(0.67%)
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.