Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
112.96 ms
(77.59%)
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
  95668
  305931
  384147
  390382
  395701
  397439
  400865
  403319
  411813
  417244
  419518
  419529
  419539
  420438
  421580
  421884
  424658
  426374
  428136
  432618
  433359
  435376
  439676
  439681
  439815
  440068
  440963
  441004
  441106
  441395
  441413
  441609
  441994
  442869
  444003
  444073
  444890
  446536
  448636
  448820
  451504
  452115
  452297
  453074
  457445
  457452
  459645
  459650
  459963
  460739
  460773
  461100
  462125
  463806
  465337
  465452
  465551
  465963
  466869
  467619
  467893
  467939
  468072
  468090
  469407
  469599
  470169
  470191
  470197
  470948
  472701
  473261
  475224
  475439
  478411
  480298
  483624
  484629
  484664
  489384
  489758
  490731
  491601
  493175
  494826
  495044
  495225
  497344
  502868
  512100
  512913
  513142
  517071
  517076
  518264
  519746
  521138
  521140
  521843
  523848
  534704
  535447
  538001
  538002
  549822
  550219
  555023
  555090
  555140
  558877
  558894
  563078
  563641
  565351
  568344
  604334
  604409
  607230
  731030
  775202
]
23.08 ms
(15.85%)
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
  446536
  453074
  457445
  470191
  403319
  465551
  513142
  538002
  489384
  490731
  502868
  512100
  517071
  523848
  493175
  495225
  519746
  475439
  607230
  480298
  521843
  452115
  461100
  460773
  420438
  469407
  469599
  465452
  512913
  465337
  555090
  563078
  550219
  568344
  549822
  555140
  563641
  400865
  419539
  428136
  462125
  467893
  472701
  475224
  468090
  470169
  419518
  424658
  433359
  444073
  457452
  470948
  452297
  518264
  497344
  521140
  484664
  521138
  535447
  483624
  534704
  538001
  731030
  441004
  565351
  604409
  421580
  390382
  470197
  439815
  442869
  468072
  484629
  439676
  466869
  439681
  444890
  460739
  517076
  494826
  432618
  435376
  305931
  441994
  478411
  459645
  417244
  95668
  397439
  411813
  441609
  426374
  440963
  441413
  459650
  459963
  491601
  495044
  489758
  463806
  451504
  467619
  465963
  444003
  384147
  441106
  440068
  448636
  604334
  775202
  473261
  441395
  395701
  448820
  467939
  558894
  555023
  558877
  419529
  421884
]
2.63 ms
(1.81%)
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
  95668
  305931
  384147
  390382
  395701
  397439
  400865
  403319
  411813
  417244
  419518
  419529
  419539
  420438
  421580
  421884
  424658
  426374
  428136
  432618
  433359
  435376
  439676
  439681
  439815
  440068
  440963
  441004
  441106
  441395
  441413
  441609
  441994
  442869
  444003
  444073
  444890
  446536
  448636
  448820
  451504
  452115
  452297
  453074
  457445
  457452
  459645
  459650
  459963
  460739
  460773
  461100
  462125
  463806
  465337
  465452
  465551
  465963
  466869
  467619
  467893
  467939
  468072
  468090
  469407
  469599
  470169
  470191
  470197
  470948
  472701
  473261
  475224
  475439
  478411
  480298
  483624
  484629
  484664
  489384
  489758
  490731
  491601
  493175
  494826
  495044
  495225
  497344
  502868
  512100
  512913
  513142
  517071
  517076
  518264
  519746
  521138
  521140
  521843
  523848
  534704
  535447
  538001
  538002
  549822
  550219
  555023
  555090
  555140
  558877
  558894
  563078
  563641
  565351
  568344
  604334
  604409
  607230
  731030
  775202
]
1.87 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature женскийрод анал"
]
1.77 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature bitch anal"
]
1.71 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature женскийрод анал"
]
1.56 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.