Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.50 ms
(87.11%)
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
  385589
  388482
  391718
  393706
  393747
  393757
  393762
  397163
  400431
  400448
  400467
  401041
  402245
  402249
  411854
  414204
  418595
  428520
  428531
  445841
  445866
  453422
  455619
  456680
  459667
  462709
  470196
  472921
  474903
  484730
  491160
  491693
  503866
  515198
  521239
  527931
  529162
  550435
  554391
  557270
  564154
  565426
  567424
  569664
  569670
  569671
  569676
  569678
  569681
  569688
  570072
  570076
  574497
  602933
  603126
  615112
  626395
  649561
  676510
  680864
  684187
  684588
  684589
  684590
  684594
  684596
  698657
  700541
  700654
  701007
  709591
  712441
  716563
  718241
  718554
  718705
  720429
  720480
  722655
  722659
  724175
  726446
  731037
  731386
  732145
  735480
  741289
  743122
  743123
  743139
  744306
  747568
  747832
  747839
  747840
  747855
  747861
  747864
  747875
  754219
  759564
  759590
  759592
  759649
  759652
  759653
  765445
  765446
  767950
  767959
  774109
  776881
  800629
  810572
  812123
  812361
  817462
  817630
  819515
  824513
]
15.28 ms
(7.76%)
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
  574497
  474903
  626395
  455619
  445841
  453422
  418595
  445866
  491160
  411854
  484730
  567424
  428520
  462709
  470196
  819515
  565426
  602933
  491693
  459667
  414204
  428531
  521239
  554391
  527931
  503866
  456680
  529162
  735480
  743122
  747864
  684596
  676510
  767959
  747832
  747568
  743123
  747875
  747840
  747861
  701007
  684589
  743139
  385589
  569664
  564154
  720429
  747855
  759649
  684588
  817462
  722655
  776881
  716563
  684594
  812123
  732145
  397163
  774109
  400431
  744306
  400448
  718554
  718705
  615112
  759590
  759653
  570076
  472921
  684590
  712441
  741289
  759592
  393706
  400467
  824513
  569671
  810572
  747839
  759652
  649561
  603126
  402245
  550435
  570072
  569670
  569688
  731037
  726446
  569678
  698657
  718241
  680864
  731386
  393762
  393757
  391718
  817630
  684187
  700541
  700654
  557270
  754219
  767950
  724175
  569681
  720480
  401041
  402249
  515198
  722659
  709591
  759564
  800629
  765445
  765446
  393747
  388482
  569676
  812361
]
3.00 ms
(1.53%)
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
  385589
  388482
  391718
  393706
  393747
  393757
  393762
  397163
  400431
  400448
  400467
  401041
  402245
  402249
  411854
  414204
  418595
  428520
  428531
  445841
  445866
  453422
  455619
  456680
  459667
  462709
  470196
  472921
  474903
  484730
  491160
  491693
  503866
  515198
  521239
  527931
  529162
  550435
  554391
  557270
  564154
  565426
  567424
  569664
  569670
  569671
  569676
  569678
  569681
  569688
  570072
  570076
  574497
  602933
  603126
  615112
  626395
  649561
  676510
  680864
  684187
  684588
  684589
  684590
  684594
  684596
  698657
  700541
  700654
  701007
  709591
  712441
  716563
  718241
  718554
  718705
  720429
  720480
  722655
  722659
  724175
  726446
  731037
  731386
  732145
  735480
  741289
  743122
  743123
  743139
  744306
  747568
  747832
  747839
  747840
  747855
  747861
  747864
  747875
  754219
  759564
  759590
  759592
  759649
  759652
  759653
  765445
  765446
  767950
  767959
  774109
  776881
  800629
  810572
  812123
  812361
  817462
  817630
  819515
  824513
]
1.96 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young секс"
]
1.78 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young fuck"
]
1.68 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young секс"
]
1.67 ms
(0.85%)
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.