Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
370.19 ms
(91.46%)
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
  97377
  191485
  282218
  382912
  398689
  414301
  416652
  416677
  416751
  420358
  422658
  423428
  428009
  428353
  428404
  433232
  433318
  434874
  440629
  444526
  448817
  448821
  448862
  451533
  454600
  465354
  465407
  466801
  471881
  477210
  478581
  488698
  490783
  491256
  495401
  495786
  497725
  500100
  500686
  502770
  507693
  510061
  510781
  513149
  514241
  514892
  517308
  521426
  523420
  529969
  532381
  532467
  536675
  540241
  542993
  545152
  545796
  545838
  547658
  548253
  549099
  551057
  567774
  569122
  572172
  576895
  576933
  592335
  603172
  605333
  605337
  613515
  619832
  622645
  629893
  632059
  633447
  641623
  644264
  651630
  651957
  656175
  682464
  688369
  691992
  692378
  693952
  694010
  694553
  696594
  699755
  700281
  700282
  703364
  710286
  710933
  710946
  719651
  720095
  735768
  740409
  751760
  752650
  761573
  761801
  766772
  772684
  777173
  778533
  780784
  784256
  786506
  786879
  788119
  799762
  805039
  805164
  806058
  806397
  821195
]
25.01 ms
(6.18%)
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
  488698
  451533
  97377
  434874
  433232
  423428
  448862
  510061
  548253
  592335
  478581
  495786
  613515
  440629
  549099
  633447
  398689
  382912
  477210
  572172
  428353
  465354
  540241
  551057
  651957
  700282
  692378
  694553
  719651
  699755
  545152
  805164
  778533
  806397
  766772
  735768
  761801
  777173
  784256
  422658
  466801
  641623
  282218
  513149
  523420
  751760
  536675
  500686
  632059
  703364
  629893
  576895
  688369
  420358
  433318
  521426
  191485
  444526
  454600
  465407
  507693
  514892
  497725
  500100
  529969
  576933
  619832
  622645
  605337
  806058
  761573
  788119
  780784
  786506
  428009
  448817
  448821
  414301
  547658
  416677
  416751
  428404
  471881
  567774
  495401
  491256
  514241
  542993
  517308
  490783
  691992
  805039
  710933
  416652
  821195
  510781
  532381
  502770
  532467
  545796
  545838
  569122
  656175
  682464
  693952
  651630
  694010
  696594
  700281
  720095
  710286
  710946
  644264
  603172
  786879
  772684
  799762
  740409
  752650
  605333
]
2.39 ms
(0.59%)
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
  97377
  191485
  282218
  382912
  398689
  414301
  416652
  416677
  416751
  420358
  422658
  423428
  428009
  428353
  428404
  433232
  433318
  434874
  440629
  444526
  448817
  448821
  448862
  451533
  454600
  465354
  465407
  466801
  471881
  477210
  478581
  488698
  490783
  491256
  495401
  495786
  497725
  500100
  500686
  502770
  507693
  510061
  510781
  513149
  514241
  514892
  517308
  521426
  523420
  529969
  532381
  532467
  536675
  540241
  542993
  545152
  545796
  545838
  547658
  548253
  549099
  551057
  567774
  569122
  572172
  576895
  576933
  592335
  603172
  605333
  605337
  613515
  619832
  622645
  629893
  632059
  633447
  641623
  644264
  651630
  651957
  656175
  682464
  688369
  691992
  692378
  693952
  694010
  694553
  696594
  699755
  700281
  700282
  703364
  710286
  710933
  710946
  719651
  720095
  735768
  740409
  751760
  752650
  761573
  761801
  766772
  772684
  777173
  778533
  780784
  784256
  786506
  786879
  788119
  799762
  805039
  805164
  806058
  806397
  821195
]
1.96 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"молодых в анал нарезкÐ…"
]
1.82 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодые анал подборк"
]
1.69 ms
(0.42%)
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.