Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.25 ms
(85.53%)
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
  69739
  405988
  413584
  416694
  418119
  418219
  418578
  421366
  424593
  430374
  431540
  432268
  432939
  434350
  434374
  434654
  435078
  440710
  441113
  444544
  449319
  452807
  454009
  460001
  464959
  466467
  467877
  467895
  469250
  470473
  475416
  475649
  478596
  478998
  490232
  495747
  500299
  502770
  508916
  515440
  520739
  531880
  534546
  534585
  537864
  541276
  541317
  544404
  544829
  547477
  550922
  566766
  573403
  580188
  581609
  589856
  590192
  590410
  599865
  599906
  599966
  602395
  606346
  609083
  613513
  628205
  630830
  636315
  639760
  639810
  641837
  658789
  695871
  697628
  698866
  710559
  713185
  718678
  722420
  728540
  730015
  740922
  741241
  745136
  747313
  750426
  751433
  751611
  752602
  752605
  752623
  752759
  760227
  765222
  765628
  766335
  785568
  785589
  785603
  786879
  787438
  787488
  787818
  791489
  792989
  795404
  796290
  796336
  796644
  801275
  801311
  804972
  805642
  806514
  806919
  810382
  811709
  815816
  825864
]
19.09 ms
(9.70%)
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
  541276
  698866
  713185
  695871
  589856
  606346
  630830
  806919
  751611
  765222
  752759
  747313
  730015
  697628
  464959
  613513
  766335
  466467
  792989
  508916
  416694
  434654
  825864
  475416
  475649
  718678
  791489
  467877
  413584
  418578
  430374
  500299
  69739
  418119
  636315
  440710
  432939
  490232
  544829
  550922
  547477
  581609
  806514
  740922
  811709
  728540
  752605
  467895
  796290
  454009
  444544
  424593
  534585
  541317
  628205
  785568
  801311
  785603
  796336
  796644
  804972
  751433
  752623
  710559
  805642
  421366
  590410
  801275
  537864
  599966
  639760
  449319
  573403
  599865
  639810
  520739
  760227
  495747
  609083
  807580
  432268
  434374
  418219
  515440
  434350
  441113
  469250
  531880
  460001
  566766
  544404
  658789
  599906
  765628
  745136
  752602
  405988
  470473
  431540
  435078
  478596
  815816
  452807
  478998
  534546
  502770
  580188
  722420
  602395
  641837
  590192
  785589
  786879
  787488
  795404
  787438
  810382
  741241
  787818
  750426
]
2.17 ms
(1.10%)
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
  69739
  405988
  413584
  416694
  418119
  418219
  418578
  421366
  424593
  430374
  431540
  432268
  432939
  434350
  434374
  434654
  435078
  440710
  441113
  444544
  449319
  452807
  454009
  460001
  464959
  466467
  467877
  467895
  469250
  470473
  475416
  475649
  478596
  478998
  490232
  495747
  500299
  502770
  508916
  515440
  520739
  531880
  534546
  534585
  537864
  541276
  541317
  544404
  544829
  547477
  550922
  566766
  573403
  580188
  581609
  589856
  590192
  590410
  599865
  599906
  599966
  602395
  606346
  609083
  613513
  628205
  630830
  636315
  639760
  639810
  641837
  658789
  695871
  697628
  698866
  710559
  713185
  718678
  722420
  728540
  730015
  740922
  741241
  745136
  747313
  750426
  751433
  751611
  752602
  752605
  752623
  752759
  760227
  765222
  765628
  766335
  785568
  785589
  785603
  786879
  787438
  787488
  787818
  791489
  792989
  795404
  796290
  796336
  796644
  801275
  801311
  804972
  805642
  806514
  806919
  810382
  811709
  815816
  825864
]
2.09 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "женский оргазм анальн…"
]
1.93 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женск оргазм анал"
]
1.47 ms
(0.75%)
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.