Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.13 ms
(85.79%)
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
  21323
  33727
  38263
  61369
  83163
  92038
  148793
  194652
  210052
  218742
  237293
  360205
  381972
  383621
  384494
  385053
  385737
  386782
  386936
  389760
  391241
  397209
  398128
  398576
  401167
  402060
  403142
  403293
  408701
  411944
  415911
  417900
  421783
  426169
  435737
  435968
  436047
  439450
  439628
  439677
  440776
  443947
  444426
  444582
  448090
  454785
  455826
  457067
  460307
  464096
  465475
  465534
  471455
  472575
  477759
  479613
  488475
  499252
  502885
  506487
  507513
  507897
  510584
  517575
  525011
  527919
  528600
  530438
  530451
  531844
  532107
  545434
  548834
  552078
  555728
  561013
  564255
  564293
  572204
  578432
  578436
  584795
  601285
  607438
  623300
  623749
  633611
  634229
  640935
  662047
  685509
  700305
  705119
  709917
  711957
  713503
  717182
  720200
  724836
  725236
  732715
  733542
  738296
  738435
  739888
  746183
  747356
  752617
  755821
  756683
  759748
  793727
  796715
  797631
  800543
  800593
  804552
  805536
  817492
  827848
]
15.12 ms
(8.52%)
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
  506487
  488475
  738296
  386782
  389760
  398128
  218742
  61369
  398576
  443947
  793727
  725236
  800543
  746183
  384494
  578432
  517575
  439628
  436047
  471455
  391241
  435737
  532107
  578436
  385737
  383621
  360205
  403293
  732715
  738435
  756683
  724836
  403142
  477759
  465475
  555728
  709917
  435968
  507513
  507897
  634229
  804552
  739888
  510584
  448090
  385053
  444426
  623300
  455826
  464096
  415911
  817492
  584795
  386936
  527919
  717182
  194652
  530438
  530451
  564255
  713503
  640935
  733542
  528600
  381972
  38263
  401167
  408701
  499252
  561013
  633611
  747356
  402060
  479613
  83163
  210052
  421783
  827848
  472575
  460307
  548834
  711957
  705119
  720200
  662047
  623749
  601285
  800593
  755821
  759748
  752617
  797631
  805536
  417900
  444582
  148793
  525011
  439450
  411944
  457067
  572204
  685509
  700305
  92038
  426169
  454785
  502885
  439677
  465534
  552078
  237293
  21323
  33727
  397209
  440776
  531844
  564293
  545434
  607438
  796715
]
3.12 ms
(1.76%)
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
  21323
  33727
  38263
  61369
  83163
  92038
  148793
  194652
  210052
  218742
  237293
  360205
  381972
  383621
  384494
  385053
  385737
  386782
  386936
  389760
  391241
  397209
  398128
  398576
  401167
  402060
  403142
  403293
  408701
  411944
  415911
  417900
  421783
  426169
  435737
  435968
  436047
  439450
  439628
  439677
  440776
  443947
  444426
  444582
  448090
  454785
  455826
  457067
  460307
  464096
  465475
  465534
  471455
  472575
  477759
  479613
  488475
  499252
  502885
  506487
  507513
  507897
  510584
  517575
  525011
  527919
  528600
  530438
  530451
  531844
  532107
  545434
  548834
  552078
  555728
  561013
  564255
  564293
  572204
  578432
  578436
  584795
  601285
  607438
  623300
  623749
  633611
  634229
  640935
  662047
  685509
  700305
  705119
  709917
  711957
  713503
  717182
  720200
  724836
  725236
  732715
  733542
  738296
  738435
  739888
  746183
  747356
  752617
  755821
  756683
  759748
  793727
  796715
  797631
  800543
  800593
  804552
  805536
  817492
  827848
]
1.91 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge tits doggy"
]
1.75 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные сиськ рак"
]
1.42 ms
(0.80%)
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.