Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
349.24 ms
(90.00%)
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
  191420
  285885
  390192
  396430
  414788
  422286
  424916
  427433
  428033
  443870
  446086
  449352
  459015
  459965
  460387
  463704
  466555
  468217
  470529
  470533
  474819
  475945
  483437
  498287
  500084
  502136
  505636
  508423
  509210
  509223
  510759
  510762
  512227
  516662
  516664
  519767
  520754
  522640
  523788
  524888
  530540
  533690
  539375
  543923
  545139
  546667
  546802
  547741
  550280
  557440
  557473
  558790
  559674
  564390
  565749
  566360
  575298
  577690
  579635
  585694
  591907
  593166
  593823
  593853
  594952
  595797
  595833
  600725
  603913
  605525
  606908
  608301
  612089
  614829
  620055
  625089
  625131
  625682
  627706
  627815
  632780
  635794
  635854
  637559
  642521
  644229
  644421
  649056
  650875
  651155
  653437
  660075
  660142
  668467
  669700
  678374
  682057
  683696
  698086
  707588
  712631
  715116
  715518
  718040
  718828
  730797
  731687
  745257
  749063
  763613
  766306
  773965
  784186
  787628
  790679
  793827
  797871
  798099
  804525
  810512
]
29.06 ms
(7.49%)
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
  428033
  443870
  718828
  644421
  533690
  660142
  427433
  516664
  483437
  558790
  566360
  650875
  653437
  637559
  593823
  635854
  798099
  793827
  745257
  632780
  459015
  449352
  498287
  530540
  557440
  547741
  649056
  718040
  668467
  608301
  627815
  594952
  804525
  730797
  766306
  731687
  763613
  612089
  625131
  509210
  509223
  463704
  539375
  470533
  546667
  698086
  715518
  790679
  396430
  635794
  787628
  505636
  468217
  474819
  508423
  500084
  519767
  575298
  559674
  678374
  651155
  707588
  683696
  593853
  595833
  595797
  593166
  600725
  605525
  784186
  749063
  773965
  614829
  466555
  424916
  390192
  550280
  591907
  625682
  285885
  516662
  502136
  543923
  545139
  797871
  522640
  191420
  810512
  603913
  475945
  579635
  669700
  715116
  606908
  627706
  470529
  510759
  682057
  414788
  644229
  422286
  459965
  446086
  460387
  520754
  512227
  524888
  510762
  523788
  564390
  565749
  660075
  712631
  546802
  557473
  577690
  620055
  642521
  585694
  625089
]
2.42 ms
(0.62%)
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
  191420
  285885
  390192
  396430
  414788
  422286
  424916
  427433
  428033
  443870
  446086
  449352
  459015
  459965
  460387
  463704
  466555
  468217
  470529
  470533
  474819
  475945
  483437
  498287
  500084
  502136
  505636
  508423
  509210
  509223
  510759
  510762
  512227
  516662
  516664
  519767
  520754
  522640
  523788
  524888
  530540
  533690
  539375
  543923
  545139
  546667
  546802
  547741
  550280
  557440
  557473
  558790
  559674
  564390
  565749
  566360
  575298
  577690
  579635
  585694
  591907
  593166
  593823
  593853
  594952
  595797
  595833
  600725
  603913
  605525
  606908
  608301
  612089
  614829
  620055
  625089
  625131
  625682
  627706
  627815
  632780
  635794
  635854
  637559
  642521
  644229
  644421
  649056
  650875
  651155
  653437
  660075
  660142
  668467
  669700
  678374
  682057
  683696
  698086
  707588
  712631
  715116
  715518
  718040
  718828
  730797
  731687
  745257
  749063
  763613
  766306
  773965
  784186
  787628
  790679
  793827
  797871
  798099
  804525
  810512
]
2.05 ms
(0.53%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен friends"
]
2.04 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife for friends"
]
2.02 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.20 ms
(0.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен friends"
]

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.