Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.51 ms
(84.37%)
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
  392517
  396334
  396699
  416138
  417841
  420853
  422074
  423464
  424646
  429715
  432647
  432690
  432732
  432777
  432778
  435177
  436437
  439135
  441519
  441848
  443333
  445340
  447116
  452636
  453598
  454145
  454534
  454926
  461306
  461968
  462757
  463810
  463922
  464578
  464811
  464837
  465267
  467910
  470425
  472399
  472692
  473222
  474670
  476975
  478833
  480714
  482769
  486204
  490171
  491802
  492495
  493172
  496616
  500884
  500938
  500955
  503271
  508560
  514024
  517854
  518451
  523541
  524319
  535431
  537960
  538266
  541629
  541732
  547865
  552395
  554552
  556445
  558490
  561844
  563082
  574643
  576516
  579469
  580418
  586897
  592614
  593787
  595549
  603725
  609878
  611348
  618364
  622932
  623968
  632096
  632114
  634600
  637802
  665923
  680422
  695900
  696081
  708276
  709781
  717820
  720132
  725119
  735195
  736470
  740871
  741656
  742320
  743068
  750668
  751432
  761048
  761481
  761583
  766996
  778593
  793472
  794135
  796168
  801259
  814944
]
15.44 ms
(9.34%)
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
  464578
  579469
  696081
  623968
  740871
  736470
  743068
  766996
  750668
  435177
  452636
  432778
  463922
  461968
  500955
  416138
  441848
  461306
  508560
  574643
  709781
  695900
  609878
  611348
  618364
  793472
  725119
  761048
  500938
  500884
  491802
  482769
  708276
  634600
  796168
  778593
  742320
  761481
  741656
  751432
  632096
  717820
  720132
  517854
  637802
  632114
  432777
  454926
  593787
  420853
  496616
  443333
  432690
  465267
  454145
  454534
  474670
  535431
  464837
  680422
  554552
  595549
  470425
  422074
  445340
  486204
  490171
  480714
  552395
  563082
  541629
  561844
  576516
  794135
  447116
  462757
  473222
  396334
  537960
  514024
  493172
  503271
  396699
  432732
  463810
  472399
  478833
  556445
  424646
  472692
  592614
  417841
  441519
  814944
  547865
  665923
  801259
  735195
  429715
  464811
  492495
  436437
  392517
  439135
  432647
  467910
  541732
  586897
  761583
  622932
  476975
  518451
  523541
  558490
  580418
  603725
  423464
  453598
  524319
  538266
]
3.39 ms
(2.05%)
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
  392517
  396334
  396699
  416138
  417841
  420853
  422074
  423464
  424646
  429715
  432647
  432690
  432732
  432777
  432778
  435177
  436437
  439135
  441519
  441848
  443333
  445340
  447116
  452636
  453598
  454145
  454534
  454926
  461306
  461968
  462757
  463810
  463922
  464578
  464811
  464837
  465267
  467910
  470425
  472399
  472692
  473222
  474670
  476975
  478833
  480714
  482769
  486204
  490171
  491802
  492495
  493172
  496616
  500884
  500938
  500955
  503271
  508560
  514024
  517854
  518451
  523541
  524319
  535431
  537960
  538266
  541629
  541732
  547865
  552395
  554552
  556445
  558490
  561844
  563082
  574643
  576516
  579469
  580418
  586897
  592614
  593787
  595549
  603725
  609878
  611348
  618364
  622932
  623968
  632096
  632114
  634600
  637802
  665923
  680422
  695900
  696081
  708276
  709781
  717820
  720132
  725119
  735195
  736470
  740871
  741656
  742320
  743068
  750668
  751432
  761048
  761481
  761583
  766996
  778593
  793472
  794135
  796168
  801259
  814944
]
2.01 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð▓ ð¥Ðçð║ð¥ Ðü ð▒ð¥ð╗ÐîÐÄ ð© ð║ÐÇð©ð║ð░ðÔǪ"
]
1.76 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал крича вперв крича вперв"
]
1.70 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.94%)
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.