Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.58 ms
(87.02%)
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
  7748
  263868
  392778
  392787
  395530
  405500
  407185
  407664
  409334
  410177
  411867
  413112
  414302
  415584
  417018
  424191
  424850
  424982
  425691
  429306
  430245
  432189
  447937
  450801
  450813
  454057
  469549
  473921
  477335
  482230
  489960
  493899
  502791
  511823
  532111
  552047
  556511
  556641
  556653
  556656
  561589
  562408
  564697
  581878
  586682
  587215
  589616
  591048
  591530
  608049
  609966
  610114
  624286
  624300
  625435
  631358
  639127
  662140
  665940
  670748
  673654
  687942
  692365
  694707
  695186
  710523
  710883
  711671
  717948
  721748
  721822
  724706
  725362
  726621
  726887
  726891
  727339
  730955
  742638
  742839
  746621
  753722
  755383
  757568
  758414
  758605
  764919
  771243
  777154
  777220
  777270
  778852
  779224
  782564
  786455
  786462
  787342
  789698
  790534
  793121
  793223
  793294
  793372
  801223
  801356
  802402
  805367
  806767
  807365
  807367
  807373
  807377
  807490
  807491
  808679
  813118
  817269
  818502
  819231
  825112
]
16.48 ms
(8.08%)
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
  392778
  778852
  793223
  782564
  807365
  757568
  807367
  7748
  424982
  489960
  665940
  730955
  493899
  710883
  807377
  727339
  742638
  564697
  808679
  721748
  407185
  415584
  473921
  482230
  432189
  561589
  581878
  670748
  692365
  695186
  721822
  694707
  631358
  805367
  786462
  711671
  405500
  392787
  409334
  477335
  417018
  410177
  825112
  532111
  687942
  710523
  562408
  587215
  591530
  777220
  777270
  813118
  726887
  755383
  764919
  787342
  263868
  395530
  425691
  430245
  817269
  447937
  552047
  673654
  793294
  806767
  609966
  414302
  511823
  818502
  819231
  802402
  758605
  413112
  556653
  556511
  556641
  662140
  717948
  624286
  624300
  591048
  625435
  589616
  586682
  789698
  801223
  801356
  807491
  742839
  726621
  753722
  608049
  779224
  807373
  469549
  411867
  454057
  407664
  429306
  424191
  502791
  450801
  450813
  786455
  610114
  807490
  771243
  793121
  724706
  725362
  726891
  639127
  790534
  424850
  556656
  777154
  793372
  758414
  746621
]
2.97 ms
(1.46%)
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
  7748
  263868
  392778
  392787
  395530
  405500
  407185
  407664
  409334
  410177
  411867
  413112
  414302
  415584
  417018
  424191
  424850
  424982
  425691
  429306
  430245
  432189
  447937
  450801
  450813
  454057
  469549
  473921
  477335
  482230
  489960
  493899
  502791
  511823
  532111
  552047
  556511
  556641
  556653
  556656
  561589
  562408
  564697
  581878
  586682
  587215
  589616
  591048
  591530
  608049
  609966
  610114
  624286
  624300
  625435
  631358
  639127
  662140
  665940
  670748
  673654
  687942
  692365
  694707
  695186
  710523
  710883
  711671
  717948
  721748
  721822
  724706
  725362
  726621
  726887
  726891
  727339
  730955
  742638
  742839
  746621
  753722
  755383
  757568
  758414
  758605
  764919
  771243
  777154
  777220
  777270
  778852
  779224
  782564
  786455
  786462
  787342
  789698
  790534
  793121
  793223
  793294
  793372
  801223
  801356
  802402
  805367
  806767
  807365
  807367
  807373
  807377
  807490
  807491
  808679
  813118
  817269
  818502
  819231
  825112
]
2.01 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big as mom"
]
1.73 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие mom"
]
1.56 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие mom"
]

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.