Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
186.97 ms
(86.01%)
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
  396190
  398932
  411309
  417403
  422236
  425562
  426869
  428647
  434230
  434248
  437295
  439682
  440683
  441519
  441559
  441579
  443178
  443761
  443926
  444135
  444145
  444291
  444919
  451498
  454231
  455004
  455727
  460543
  460704
  461480
  461693
  461787
  464072
  466248
  466368
  467845
  469128
  470513
  471672
  472582
  473908
  474056
  474236
  475174
  475185
  476490
  476930
  478377
  479059
  479115
  479755
  480906
  481597
  482952
  483184
  483867
  484686
  485377
  485618
  486879
  487381
  487702
  488432
  488433
  489105
  489942
  490088
  492373
  492687
  494933
  494964
  495226
  495990
  496249
  496828
  497206
  497828
  498188
  500386
  502748
  504001
  504200
  504799
  505779
  506209
  506440
  507265
  507542
  508047
  508393
  509628
  510121
  510763
  511722
  512231
  512593
  513676
  520057
  520796
  521083
  522327
  522517
  523843
  526865
  528142
  544163
  556482
  557939
  559063
  568164
  573037
  604217
  673006
  696985
  707518
  742777
  754237
  761840
  797461
  813532
]
18.10 ms
(8.33%)
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
  512231
  441519
  494933
  496249
  604217
  476490
  437295
  466248
  478377
  508047
  526865
  495990
  396190
  504200
  754237
  761840
  398932
  474056
  521083
  522517
  500386
  483184
  797461
  742777
  422236
  461480
  511722
  492373
  512593
  485618
  474236
  461693
  461787
  444291
  472582
  528142
  510763
  496828
  482952
  494964
  505779
  485377
  488433
  520796
  489942
  696985
  707518
  573037
  434248
  440683
  509628
  507542
  506209
  451498
  479115
  444145
  502748
  441559
  556482
  522327
  506440
  426869
  568164
  544163
  673006
  441579
  455004
  460704
  481597
  470513
  425562
  428647
  434230
  471672
  443178
  460543
  469128
  523843
  487381
  443926
  492687
  411309
  444135
  443761
  504799
  510121
  479755
  417403
  466368
  489105
  497828
  490088
  557939
  454231
  498188
  467845
  559063
  444919
  475185
  464072
  480906
  495226
  497206
  483867
  486879
  488432
  813532
  439682
  507265
  475174
  476930
  455727
  473908
  520057
  504001
  508393
  487702
  513676
  484686
  479059
]
3.05 ms
(1.40%)
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
  396190
  398932
  411309
  417403
  422236
  425562
  426869
  428647
  434230
  434248
  437295
  439682
  440683
  441519
  441559
  441579
  443178
  443761
  443926
  444135
  444145
  444291
  444919
  451498
  454231
  455004
  455727
  460543
  460704
  461480
  461693
  461787
  464072
  466248
  466368
  467845
  469128
  470513
  471672
  472582
  473908
  474056
  474236
  475174
  475185
  476490
  476930
  478377
  479059
  479115
  479755
  480906
  481597
  482952
  483184
  483867
  484686
  485377
  485618
  486879
  487381
  487702
  488432
  488433
  489105
  489942
  490088
  492373
  492687
  494933
  494964
  495226
  495990
  496249
  496828
  497206
  497828
  498188
  500386
  502748
  504001
  504200
  504799
  505779
  506209
  506440
  507265
  507542
  508047
  508393
  509628
  510121
  510763
  511722
  512231
  512593
  513676
  520057
  520796
  521083
  522327
  522517
  523843
  526865
  528142
  544163
  556482
  557939
  559063
  568164
  573037
  604217
  673006
  696985
  707518
  742777
  754237
  761840
  797461
  813532
]
2.57 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс русск пышн"
]
2.41 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс русск пышн"
]
2.18 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.12 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.