Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.95 ms
(85.60%)
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
  208554
  263039
  388962
  398643
  403035
  403421
  403948
  406108
  408241
  415311
  429117
  429410
  434007
  434673
  444051
  448522
  449908
  450067
  461853
  462862
  463420
  467889
  493909
  497013
  499789
  499800
  506688
  515435
  521238
  525209
  525700
  528770
  537651
  541567
  541669
  544852
  546981
  555044
  555306
  556755
  556896
  557582
  565425
  578039
  579582
  581236
  587465
  593994
  596240
  596660
  600206
  600337
  602793
  608380
  618267
  622663
  626108
  629771
  629797
  648220
  661061
  665993
  669000
  673794
  678838
  680612
  696499
  700259
  705427
  708013
  713167
  714238
  735555
  739134
  739915
  740803
  744982
  747483
  762714
  766155
  767695
  772398
  772951
  772976
  773302
  776088
  777989
  778531
  780553
  781494
  783900
  783907
  783913
  783935
  784155
  784704
  784759
  785665
  785775
  786726
  787524
  792025
  792176
  793205
  793207
  793941
  794931
  796194
  797079
  800516
  801636
  801724
  803566
  807008
  808158
  808327
  810913
  813298
  814491
  823272
]
11.71 ms
(8.02%)
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
  467889
  648220
  600206
  388962
  784759
  783913
  785665
  208554
  444051
  678838
  557582
  626108
  777989
  780553
  449908
  493909
  450067
  792176
  778531
  796194
  747483
  823272
  497013
  680612
  794931
  767695
  772398
  618267
  403948
  263039
  398643
  403035
  403421
  537651
  581236
  661061
  673794
  714238
  556896
  565425
  629771
  587465
  596660
  629797
  781494
  807008
  739915
  783935
  801724
  803566
  808158
  762714
  705427
  772951
  415311
  408241
  434673
  448522
  528770
  499789
  541567
  544852
  555044
  784155
  801636
  602793
  462862
  406108
  461853
  525700
  521238
  596240
  696499
  600337
  499800
  429117
  434007
  429410
  665993
  700259
  783900
  793205
  739134
  608380
  622663
  784704
  813298
  525209
  735555
  669000
  578039
  506688
  593994
  541669
  708013
  713167
  783907
  785775
  792025
  787524
  793207
  800516
  810913
  772976
  766155
  740803
  744982
  773302
  776088
  797079
  515435
  579582
  556755
  808327
  814491
  463420
  546981
  555306
  786726
  793941
]
2.55 ms
(1.75%)
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
  208554
  263039
  388962
  398643
  403035
  403421
  403948
  406108
  408241
  415311
  429117
  429410
  434007
  434673
  444051
  448522
  449908
  450067
  461853
  462862
  463420
  467889
  493909
  497013
  499789
  499800
  506688
  515435
  521238
  525209
  525700
  528770
  537651
  541567
  541669
  544852
  546981
  555044
  555306
  556755
  556896
  557582
  565425
  578039
  579582
  581236
  587465
  593994
  596240
  596660
  600206
  600337
  602793
  608380
  618267
  622663
  626108
  629771
  629797
  648220
  661061
  665993
  669000
  673794
  678838
  680612
  696499
  700259
  705427
  708013
  713167
  714238
  735555
  739134
  739915
  740803
  744982
  747483
  762714
  766155
  767695
  772398
  772951
  772976
  773302
  776088
  777989
  778531
  780553
  781494
  783900
  783907
  783913
  783935
  784155
  784704
  784759
  785665
  785775
  786726
  787524
  792025
  792176
  793205
  793207
  793941
  794931
  796194
  797079
  800516
  801636
  801724
  803566
  807008
  808158
  808327
  810913
  813298
  814491
  823272
]
2.01 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "squirt girl"
]
1.68 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сквирт оргазм девушк"
]
1.51 ms
(1.04%)
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.