Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
226.35 ms
(88.28%)
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
  33459
  393326
  395489
  395919
  396565
  396728
  397980
  402632
  410954
  413791
  416678
  416688
  421054
  421152
  423425
  423658
  425682
  426390
  431953
  432777
  433232
  433280
  433334
  445455
  447154
  448650
  450824
  451262
  452781
  461933
  462795
  466412
  467041
  469058
  469171
  469616
  472387
  472746
  476195
  477118
  481515
  483814
  485336
  491270
  491678
  495022
  496733
  496758
  497146
  499182
  503119
  509813
  512224
  515897
  518111
  522846
  525613
  526849
  527428
  527514
  527531
  528987
  535647
  549076
  550692
  560660
  564066
  569197
  572707
  583290
  584779
  586593
  586599
  595579
  600010
  600042
  602689
  625483
  629630
  629661
  630773
  651900
  656209
  666364
  671365
  671810
  674117
  694562
  701380
  710799
  711281
  713113
  715835
  716394
  718146
  720231
  730939
  738441
  738473
  739776
  744093
  765071
  768949
  773449
  776287
  776313
  778361
  788309
  792547
  794155
  802317
  803422
  805228
  807521
  814008
  814991
  817322
  820441
  822155
]
18.11 ms
(7.06%)
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
  550692
  477118
  425682
  423658
  450824
  483814
  497146
  496758
  701380
  730939
  773449
  602689
  397980
  817322
  472387
  481515
  525613
  526849
  527514
  461933
  629661
  803422
  738441
  739776
  744093
  711281
  720231
  776313
  467041
  433232
  666364
  595579
  814008
  528987
  671810
  600042
  807521
  792547
  768949
  413791
  814991
  499182
  503119
  512224
  518111
  527428
  560660
  651900
  629630
  445455
  485336
  527531
  469616
  820441
  583290
  549076
  630773
  805228
  765071
  738473
  447154
  469058
  395489
  395919
  410954
  426390
  421054
  432777
  433280
  448650
  466412
  572707
  600010
  396565
  423425
  472746
  469171
  421152
  462795
  396728
  402632
  496733
  509813
  452781
  431953
  564066
  586599
  569197
  584779
  491678
  491270
  416688
  416678
  586593
  595376
  515897
  522846
  33459
  433334
  476195
  674117
  716394
  451262
  778361
  802317
  794155
  495022
  393326
  822155
  535647
  671365
  710799
  715835
  656209
  694562
  713113
  718146
  625483
  776287
  788309
]
4.16 ms
(1.62%)
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
  33459
  393326
  395489
  395919
  396565
  396728
  397980
  402632
  410954
  413791
  416678
  416688
  421054
  421152
  423425
  423658
  425682
  426390
  431953
  432777
  433232
  433280
  433334
  445455
  447154
  448650
  450824
  451262
  452781
  461933
  462795
  466412
  467041
  469058
  469171
  469616
  472387
  472746
  476195
  477118
  481515
  483814
  485336
  491270
  491678
  495022
  496733
  496758
  497146
  499182
  503119
  509813
  512224
  515897
  518111
  522846
  525613
  526849
  527428
  527514
  527531
  528987
  535647
  549076
  550692
  560660
  564066
  569197
  572707
  583290
  584779
  586593
  586599
  595579
  600010
  600042
  602689
  625483
  629630
  629661
  630773
  651900
  656209
  666364
  671365
  671810
  674117
  694562
  701380
  710799
  711281
  713113
  715835
  716394
  718146
  720231
  730939
  738441
  738473
  739776
  744093
  765071
  768949
  773449
  776287
  776313
  778361
  788309
  792547
  794155
  802317
  803422
  805228
  807521
  814008
  814991
  817322
  820441
  822155
]
2.41 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen девушк подборк"
]
2.17 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen girls compilation"
]
1.77 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen девушк подборк"
]

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.