Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.61 ms
(87.10%)
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
  38068
  210281
  210609
  365872
  365898
  381906
  387007
  390215
  394610
  453659
  472865
  476388
  478183
  484070
  488833
  515198
  526978
  527567
  528675
  528903
  533430
  535219
  539339
  542322
  549781
  554668
  559015
  559292
  581004
  581981
  589739
  606408
  607025
  610023
  624329
  627894
  630064
  633903
  634249
  635063
  636057
  636390
  637173
  638517
  640826
  644706
  644905
  650510
  660605
  665038
  667120
  677920
  684393
  690446
  692413
  698802
  698899
  701443
  701623
  705726
  710989
  718151
  719109
  719303
  720428
  722972
  724141
  724323
  734895
  735353
  736284
  740697
  741583
  743647
  745081
  745998
  746091
  747546
  750438
  751620
  756094
  758036
  758949
  767994
  770483
  770917
  777599
  779722
  779733
  779979
  780702
  786653
  788128
  791311
  793050
  793865
  794924
  796531
  798630
  799699
  801696
  805290
  813294
  813599
  814372
  816038
  817863
  817876
  819092
  819271
  819469
  819543
  821165
  821627
  823719
  825890
  827104
  827302
  828310
]
15.34 ms
(8.12%)
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
  796531
  381906
  825890
  828310
  526978
  533430
  698802
  692413
  633903
  365872
  38068
  827302
  819469
  559292
  684393
  701443
  690446
  638517
  640826
  793865
  724323
  745081
  758036
  767994
  394610
  816038
  814372
  819092
  819271
  828276
  650510
  644706
  636390
  610023
  794924
  805290
  736284
  740697
  743647
  630064
  635063
  819543
  698899
  793050
  821627
  705726
  634249
  210609
  813599
  472865
  515198
  528903
  542322
  719303
  606408
  779979
  798630
  779733
  786653
  756094
  758949
  770917
  791311
  724141
  747546
  751620
  718151
  823719
  484070
  637173
  735353
  799699
  801696
  734895
  745998
  722972
  813294
  453659
  817876
  478183
  528675
  677920
  710989
  780702
  777599
  365898
  817863
  644905
  821165
  554668
  581004
  665038
  667120
  720428
  624329
  627894
  636057
  607025
  788128
  746091
  741583
  750438
  476388
  527567
  827104
  210281
  387007
  390215
  535219
  488833
  581981
  719109
  589739
  779722
  770483
  539339
  549781
  559015
  660605
  701623
]
2.51 ms
(1.33%)
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
  38068
  210281
  210609
  365872
  365898
  381906
  387007
  390215
  394610
  453659
  472865
  476388
  478183
  484070
  488833
  515198
  526978
  527567
  528675
  528903
  533430
  535219
  539339
  542322
  549781
  554668
  559015
  559292
  581004
  581981
  589739
  606408
  607025
  610023
  624329
  627894
  630064
  633903
  634249
  635063
  636057
  636390
  637173
  638517
  640826
  644706
  644905
  650510
  660605
  665038
  667120
  677920
  684393
  690446
  692413
  698802
  698899
  701443
  701623
  705726
  710989
  718151
  719109
  719303
  720428
  722972
  724141
  724323
  734895
  735353
  736284
  740697
  741583
  743647
  745081
  745998
  746091
  747546
  750438
  751620
  756094
  758036
  758949
  767994
  770483
  770917
  777599
  779722
  779733
  779979
  780702
  786653
  788128
  791311
  793050
  793865
  794924
  796531
  798630
  799699
  801696
  805290
  813294
  813599
  814372
  816038
  817863
  817876
  819092
  819271
  819469
  819543
  821165
  821627
  823719
  825890
  827104
  827302
  828310
]
1.88 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex in outdoor"
]
1.77 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс outdoor"
]
1.41 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс outdoor"
]

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.