Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.24 ms
(86.93%)
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
  2658
  38908
  40835
  162000
  187709
  187775
  188240
  188447
  272725
  310671
  318315
  357595
  381752
  382094
  386532
  386544
  386576
  389997
  390653
  391588
  391656
  391875
  392604
  393072
  393087
  395142
  395537
  395719
  395887
  395943
  395998
  397942
  398353
  405417
  406592
  406648
  406820
  407871
  409234
  411933
  416258
  433351
  439658
  440868
  443194
  444003
  448996
  452189
  452237
  453695
  453832
  454184
  458714
  460190
  460673
  461296
  463851
  464975
  466816
  467545
  467546
  467712
  469351
  472595
  473204
  474100
  474850
  476676
  480294
  482527
  484626
  484681
  487929
  490235
  493189
  495808
  502885
  513671
  518735
  530767
  535529
  542781
  546962
  555129
  561042
  569149
  569410
  570722
  571806
  582404
  600972
  620233
  659366
  665240
  681295
  709240
  712564
  715549
  718500
  718836
  719898
  720622
  720713
  723984
  742341
  743834
  744317
  748245
  750159
  760976
  780613
  782657
  788543
  790974
  794830
  797218
  800384
  803655
  819235
  820039
]
15.25 ms
(7.61%)
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
  502885
  473204
  484681
  395537
  395887
  382094
  569410
  665240
  659366
  620233
  794830
  748245
  407871
  386544
  318315
  38908
  272725
  439658
  555129
  718836
  381752
  458714
  469351
  472595
  788543
  391588
  433351
  453832
  406648
  463851
  467546
  490235
  513671
  493189
  484626
  461296
  571806
  718500
  390653
  452237
  453695
  480294
  535529
  530767
  570722
  582404
  569149
  719898
  712564
  600972
  464975
  357595
  392604
  467545
  411933
  448996
  440868
  443194
  487929
  495808
  386532
  397942
  803655
  760976
  391656
  476676
  444003
  386576
  162000
  188240
  395142
  395998
  395943
  389997
  398353
  406820
  416258
  454184
  474100
  466816
  474850
  546962
  800384
  743834
  750159
  709240
  780613
  391875
  518735
  820039
  797218
  744317
  715549
  393087
  405417
  542781
  188447
  393072
  310671
  187709
  819235
  681295
  720622
  782657
  790974
  723984
  742341
  720713
  409234
  561042
  460673
  482527
  40835
  2658
  460190
  395719
  406592
  187775
  467712
  452189
]
3.58 ms
(1.79%)
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
  2658
  38908
  40835
  162000
  187709
  187775
  188240
  188447
  272725
  310671
  318315
  357595
  381752
  382094
  386532
  386544
  386576
  389997
  390653
  391588
  391656
  391875
  392604
  393072
  393087
  395142
  395537
  395719
  395887
  395943
  395998
  397942
  398353
  405417
  406592
  406648
  406820
  407871
  409234
  411933
  416258
  433351
  439658
  440868
  443194
  444003
  448996
  452189
  452237
  453695
  453832
  454184
  458714
  460190
  460673
  461296
  463851
  464975
  466816
  467545
  467546
  467712
  469351
  472595
  473204
  474100
  474850
  476676
  480294
  482527
  484626
  484681
  487929
  490235
  493189
  495808
  502885
  513671
  518735
  530767
  535529
  542781
  546962
  555129
  561042
  569149
  569410
  570722
  571806
  582404
  600972
  620233
  659366
  665240
  681295
  709240
  712564
  715549
  718500
  718836
  719898
  720622
  720713
  723984
  742341
  743834
  744317
  748245
  750159
  760976
  780613
  782657
  788543
  790974
  794830
  797218
  800384
  803655
  819235
  820039
]
2.09 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "тещи секс"
]
1.85 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин секс"
]
1.80 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.81%)
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.