Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.03 ms
(78.38%)
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
  391916
  391945
  391961
  391989
  392019
  422180
  427115
  429737
  429859
  430369
  434313
  434371
  439343
  440041
  444538
  444918
  445135
  447159
  449404
  450599
  450697
  452792
  452963
  453404
  460351
  465148
  466474
  467889
  467903
  477245
  480428
  493258
  496063
  497482
  505327
  505336
  510541
  513663
  517332
  519712
  520910
  521139
  522268
  523761
  526498
  528938
  540891
  544108
  545901
  548954
  557969
  558247
  562183
  568770
  581917
  593586
  596796
  599306
  601367
  602694
  605742
  605874
  625553
  662046
  663181
  667052
  679051
  679190
  683257
  703574
  703619
  714235
  718701
  731511
  735260
  735308
  739281
  739318
  740357
  740384
  740919
  741246
  741752
  742304
  742316
  742327
  742338
  742341
  742351
  750756
  751307
  751611
  751692
  752750
  765222
  765645
  766511
  766830
  766867
  769325
  770383
  770387
  770391
  770821
  774112
  776829
  782731
  782789
  782844
  783043
  784732
  785814
  796930
  800522
  804319
  805227
  806686
  806947
  811771
  824668
]
23.85 ms
(14.95%)
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
  782731
  740357
  741246
  742327
  769325
  740384
  765645
  735260
  735308
  783043
  392019
  439343
  557969
  741752
  427115
  453404
  467889
  445135
  450697
  517332
  519712
  522268
  526498
  605742
  422180
  505327
  505336
  544108
  548954
  562183
  568770
  581917
  663181
  718701
  605874
  601367
  596796
  796930
  804319
  782789
  806686
  806947
  742351
  751611
  765222
  805227
  770391
  742316
  742304
  750756
  751307
  751692
  752750
  766830
  739318
  740919
  800522
  477245
  391916
  510541
  452963
  770387
  391989
  558247
  703619
  742338
  742341
  770383
  391961
  452792
  449404
  593586
  444918
  467903
  391945
  429737
  434313
  466474
  434371
  450599
  493258
  496063
  520910
  497482
  429859
  540891
  824668
  521139
  513663
  679051
  703574
  714235
  545901
  599306
  776829
  782844
  785814
  811771
  731511
  766511
  774112
  739281
  766867
  602694
  784732
  430369
  447159
  662046
  667052
  625553
  770821
  480428
  460351
  523761
  444538
  465148
  440041
  528938
  679190
  683257
]
3.21 ms
(2.01%)
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
  391916
  391945
  391961
  391989
  392019
  422180
  427115
  429737
  429859
  430369
  434313
  434371
  439343
  440041
  444538
  444918
  445135
  447159
  449404
  450599
  450697
  452792
  452963
  453404
  460351
  465148
  466474
  467889
  467903
  477245
  480428
  493258
  496063
  497482
  505327
  505336
  510541
  513663
  517332
  519712
  520910
  521139
  522268
  523761
  526498
  528938
  540891
  544108
  545901
  548954
  557969
  558247
  562183
  568770
  581917
  593586
  596796
  599306
  601367
  602694
  605742
  605874
  625553
  662046
  663181
  667052
  679051
  679190
  683257
  703574
  703619
  714235
  718701
  731511
  735260
  735308
  739281
  739318
  740357
  740384
  740919
  741246
  741752
  742304
  742316
  742327
  742338
  742341
  742351
  750756
  751307
  751611
  751692
  752750
  765222
  765645
  766511
  766830
  766867
  769325
  770383
  770387
  770391
  770821
  774112
  776829
  782731
  782789
  782844
  783043
  784732
  785814
  796930
  800522
  804319
  805227
  806686
  806947
  811771
  824668
]
2.45 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal solo rus"
]
1.78 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал соло русск"
]
1.60 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.