Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.29 ms
(87.32%)
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
  540146
  544232
  545418
  546357
  551578
  554726
  562111
  575358
  581392
  581550
  585350
  585927
  596222
  599987
  607217
  607503
  608679
  610771
  611467
  613768
  614330
  618177
  618862
  618870
  629680
  630536
  632579
  632901
  633244
  633716
  635812
  638740
  639125
  639741
  640361
  642774
  646255
  647860
  650634
  651922
  655568
  655569
  660053
  665922
  666850
  666894
  667354
  668683
  670405
  671773
  672401
  674202
  678796
  684789
  688677
  690942
  692621
  699179
  704896
  705351
  709712
  712830
  715951
  716069
  719649
  723383
  724124
  726330
  726878
  728860
  734350
  734542
  738118
  738445
  738675
  738807
  739919
  740775
  740846
  741221
  741402
  741881
  744765
  746081
  746616
  748384
  748973
  749321
  751431
  751437
  751453
  754184
  756461
  757217
  759313
  760446
  760939
  771857
  773277
  774666
  782745
  783920
  783930
  784260
  785114
  787022
  790082
  790158
  798387
  804371
  809358
  809851
  811658
  814285
  814302
  820347
  826849
  827591
  827592
]
12.55 ms
(7.10%)
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
  723383
  575358
  633244
  585927
  607217
  614330
  785114
  798387
  787022
  756461
  744765
  728860
  739919
  759313
  771857
  741402
  705351
  783930
  716069
  688677
  618870
  790158
  666894
  646255
  599987
  632579
  651922
  820347
  827592
  827591
  826849
  546357
  562111
  544232
  581550
  671773
  672401
  684789
  692621
  719649
  660053
  667354
  670405
  690942
  581392
  607503
  596222
  610771
  613768
  585350
  611467
  638740
  809358
  809851
  738118
  740775
  751437
  757217
  783920
  804371
  811658
  740846
  773277
  738445
  741221
  751453
  760939
  734542
  738807
  608679
  633716
  635812
  545418
  639741
  642774
  827961
  712830
  748384
  814302
  540146
  554726
  665922
  674202
  704896
  650634
  655569
  715951
  655568
  668683
  678796
  699179
  551578
  639125
  640361
  629680
  790082
  782745
  754184
  760446
  748973
  726878
  738675
  734350
  741881
  746616
  749321
  751431
  632901
  709712
  774666
  784260
  618862
  726330
  724124
  746081
  647860
  666850
  618177
  630536
  814285
]
3.19 ms
(1.81%)
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
  540146
  544232
  545418
  546357
  551578
  554726
  562111
  575358
  581392
  581550
  585350
  585927
  596222
  599987
  607217
  607503
  608679
  610771
  611467
  613768
  614330
  618177
  618862
  618870
  629680
  630536
  632579
  632901
  633244
  633716
  635812
  638740
  639125
  639741
  640361
  642774
  646255
  647860
  650634
  651922
  655568
  655569
  660053
  665922
  666850
  666894
  667354
  668683
  670405
  671773
  672401
  674202
  678796
  684789
  688677
  690942
  692621
  699179
  704896
  705351
  709712
  712830
  715951
  716069
  719649
  723383
  724124
  726330
  726878
  728860
  734350
  734542
  738118
  738445
  738675
  738807
  739919
  740775
  740846
  741221
  741402
  741881
  744765
  746081
  746616
  748384
  748973
  749321
  751431
  751437
  751453
  754184
  756461
  757217
  759313
  760446
  760939
  771857
  773277
  774666
  782745
  783920
  783930
  784260
  785114
  787022
  790082
  790158
  798387
  804371
  809358
  809851
  811658
  814285
  814302
  820347
  826849
  827591
  827592
]
1.95 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "молодые писают"
]
1.83 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодые писсинг"
]
1.28 ms
(0.72%)
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.