Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.00 ms
(80.61%)
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
  403108
  413444
  418215
  418252
  427248
  434933
  435008
  440156
  442356
  444322
  445443
  446181
  446709
  446861
  447608
  450071
  450334
  450410
  451386
  456857
  461898
  462377
  462850
  463482
  466601
  466772
  467888
  467993
  469830
  470458
  473500
  476887
  479544
  485527
  488295
  488483
  495421
  500335
  502826
  505418
  506989
  508209
  524064
  527928
  536471
  536647
  539857
  540032
  541776
  543013
  545155
  546042
  546048
  553888
  556044
  562384
  564856
  566846
  572241
  578497
  582489
  588014
  588175
  594201
  594359
  595078
  604370
  615774
  617395
  619885
  620614
  624909
  627137
  629819
  631714
  631981
  638576
  649991
  658837
  672904
  698878
  703927
  709128
  715022
  719982
  720239
  720262
  721872
  729974
  733589
  736548
  737665
  748741
  750592
  751435
  752636
  754127
  756979
  765256
  782450
  782894
  784842
  785114
  785237
  786066
  787480
  787485
  788118
  792341
  793926
  795471
  795777
  797127
  799711
  801610
  803827
  806967
  813221
  814523
  826253
]
21.91 ms
(13.18%)
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
  814523
  446709
  488295
  450334
  446861
  540032
  588014
  782450
  751435
  709128
  446181
  450410
  488483
  451386
  418215
  502826
  527928
  788118
  787480
  413444
  495421
  754127
  785114
  462377
  500335
  595078
  456857
  461898
  627137
  729974
  792341
  703927
  450071
  485527
  564856
  444322
  752636
  427248
  765256
  539857
  479544
  572241
  434933
  462850
  476887
  447608
  541776
  797127
  756979
  546048
  795777
  442356
  418252
  435008
  463482
  649991
  506989
  720239
  403108
  469830
  445443
  505418
  720262
  617395
  733589
  619885
  508209
  658837
  631714
  750592
  806967
  470458
  524064
  594201
  813221
  801610
  543013
  473500
  466772
  578497
  582489
  629819
  615774
  672904
  698878
  604370
  786066
  795471
  793926
  799711
  624909
  440156
  566846
  536471
  546042
  620614
  466601
  467993
  467888
  737665
  536647
  782894
  721872
  556044
  631981
  545155
  784842
  553888
  787485
  748741
  803827
  736548
  562384
  715022
  719982
  594359
  785237
  638576
  588175
  826253
]
2.74 ms
(1.65%)
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
  403108
  413444
  418215
  418252
  427248
  434933
  435008
  440156
  442356
  444322
  445443
  446181
  446709
  446861
  447608
  450071
  450334
  450410
  451386
  456857
  461898
  462377
  462850
  463482
  466601
  466772
  467888
  467993
  469830
  470458
  473500
  476887
  479544
  485527
  488295
  488483
  495421
  500335
  502826
  505418
  506989
  508209
  524064
  527928
  536471
  536647
  539857
  540032
  541776
  543013
  545155
  546042
  546048
  553888
  556044
  562384
  564856
  566846
  572241
  578497
  582489
  588014
  588175
  594201
  594359
  595078
  604370
  615774
  617395
  619885
  620614
  624909
  627137
  629819
  631714
  631981
  638576
  649991
  658837
  672904
  698878
  703927
  709128
  715022
  719982
  720239
  720262
  721872
  729974
  733589
  736548
  737665
  748741
  750592
  751435
  752636
  754127
  756979
  765256
  782450
  782894
  784842
  785114
  785237
  786066
  787480
  787485
  788118
  792341
  793926
  795471
  795777
  797127
  799711
  801610
  803827
  806967
  813221
  814523
  826253
]
2.10 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "молодая жена сквиртит…"
]
1.92 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "молодая девушк жен сквирт оргазм"
]
1.79 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодая девушк жен сквирт оргазм"
]
1.78 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.