Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.36 ms
(81.74%)
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
  387377
  395596
  395639
  395826
  396013
  400807
  400808
  400812
  400826
  400852
  401229
  401307
  411344
  411350
  415658
  420635
  421871
  421907
  422158
  422205
  424411
  424460
  433733
  438001
  439457
  439518
  439529
  439558
  439565
  439574
  439591
  439607
  439623
  439641
  439643
  439649
  439667
  439673
  439681
  439696
  439699
  440598
  440991
  440993
  440999
  441004
  444100
  449428
  456614
  464649
  465892
  466020
  466021
  466191
  466239
  466272
  466869
  469909
  470941
  472148
  474635
  476344
  476588
  477730
  479049
  480059
  482088
  484069
  484585
  484629
  484671
  484704
  484738
  485460
  486341
  487339
  488698
  489379
  491209
  494567
  495665
  496862
  506529
  515994
  518566
  518827
  519945
  522343
  523019
  526775
  534285
  549799
  564826
  565351
  566993
  567337
  573800
  586564
  588376
  589591
  647960
  672805
  677142
  699549
  699583
  707368
  720343
  735778
  739532
  742449
  743065
  758432
  761007
  766613
  807327
  807340
  807927
  817261
  825812
  826888
]
18.01 ms
(11.65%)
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
  400807
  472148
  479049
  400808
  401229
  439591
  440598
  489379
  761007
  491209
  439529
  439574
  439607
  449428
  465892
  422205
  440991
  484585
  484704
  486341
  439623
  482088
  766613
  464649
  534285
  807340
  807927
  743065
  400826
  400852
  439643
  400812
  466020
  474635
  444100
  466272
  411344
  677142
  565351
  494567
  817261
  826888
  438001
  469909
  433733
  440993
  396013
  485460
  707368
  742449
  395639
  395596
  699549
  720343
  564826
  420635
  441004
  699583
  758432
  387377
  488698
  421907
  487339
  480059
  439641
  415658
  439565
  466869
  439673
  439681
  456614
  515994
  549799
  589591
  424460
  466021
  440999
  477730
  484629
  496862
  522343
  421871
  672805
  476344
  495665
  825812
  466191
  807327
  739532
  439699
  422158
  439457
  411350
  424411
  470941
  484671
  484738
  518827
  439649
  395826
  567337
  518566
  506529
  588376
  401307
  519945
  526775
  586564
  647960
  573800
  439518
  439558
  735778
  523019
  484069
  566993
  439667
  476588
  439696
  466239
]
2.82 ms
(1.82%)
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
  387377
  395596
  395639
  395826
  396013
  400807
  400808
  400812
  400826
  400852
  401229
  401307
  411344
  411350
  415658
  420635
  421871
  421907
  422158
  422205
  424411
  424460
  433733
  438001
  439457
  439518
  439529
  439558
  439565
  439574
  439591
  439607
  439623
  439641
  439643
  439649
  439667
  439673
  439681
  439696
  439699
  440598
  440991
  440993
  440999
  441004
  444100
  449428
  456614
  464649
  465892
  466020
  466021
  466191
  466239
  466272
  466869
  469909
  470941
  472148
  474635
  476344
  476588
  477730
  479049
  480059
  482088
  484069
  484585
  484629
  484671
  484704
  484738
  485460
  486341
  487339
  488698
  489379
  491209
  494567
  495665
  496862
  506529
  515994
  518566
  518827
  519945
  522343
  523019
  526775
  534285
  549799
  564826
  565351
  566993
  567337
  573800
  586564
  588376
  589591
  647960
  672805
  677142
  699549
  699583
  707368
  720343
  735778
  739532
  742449
  743065
  758432
  761007
  766613
  807327
  807340
  807927
  817261
  825812
  826888
]
2.04 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old wife anal"
]
1.95 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old жен анал"
]
1.73 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old жен анал"
]

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.