Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.40 ms
(84.81%)
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
  159370
  195768
  392848
  397437
  408880
  408911
  413673
  414050
  414094
  414595
  416531
  416690
  421993
  428171
  432824
  432945
  432974
  434443
  443251
  443317
  445727
  448115
  454793
  457476
  467584
  467636
  471129
  471335
  474596
  475502
  475504
  475920
  476053
  477502
  480258
  486772
  499872
  500333
  505093
  511862
  511864
  512072
  514257
  516640
  516843
  522639
  526179
  529296
  529632
  531578
  531582
  531879
  531891
  534443
  534828
  535963
  543897
  545438
  548153
  548857
  564285
  564288
  567120
  576848
  586113
  587292
  594053
  598882
  600958
  602281
  607683
  607685
  619322
  626044
  631740
  641806
  642149
  653028
  662046
  669062
  671038
  672315
  672944
  687347
  709542
  713194
  738461
  738501
  738515
  739124
  739158
  744047
  745087
  749215
  749264
  752648
  752753
  753635
  760598
  766266
  770261
  770814
  782854
  784217
  793151
  795404
  795420
  796333
  796647
  796703
  798599
  799759
  804939
  806924
  808068
  810776
  811570
  813206
  818103
  827287
]
14.76 ms
(9.52%)
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
  526179
  531582
  474596
  713194
  576848
  619322
  626044
  432824
  432974
  421993
  434443
  159370
  392848
  413673
  408880
  414595
  457476
  467584
  475502
  480258
  511862
  522639
  467636
  475504
  476053
  669062
  672944
  672315
  671038
  586113
  795404
  796703
  798599
  782854
  793151
  795420
  796333
  796647
  770814
  752648
  414050
  428171
  499872
  397437
  416531
  408911
  416690
  448115
  516843
  543897
  600958
  744047
  770261
  445727
  195768
  827287
  818103
  534828
  529296
  529632
  535963
  531879
  564285
  564288
  653028
  548857
  642149
  784217
  799759
  806924
  810776
  738501
  749215
  760598
  804939
  813206
  739124
  766266
  738461
  738515
  739158
  745087
  753635
  602281
  811570
  709542
  443317
  414094
  432945
  443251
  477502
  454793
  512072
  511864
  500333
  516640
  531578
  505093
  662046
  567120
  471129
  594053
  641806
  587292
  598882
  548153
  471335
  514257
  545438
  749264
  752753
  631740
  607685
  808068
  486772
  475920
  531891
  534443
  687347
  607683
]
2.46 ms
(1.59%)
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
  159370
  195768
  392848
  397437
  408880
  408911
  413673
  414050
  414094
  414595
  416531
  416690
  421993
  428171
  432824
  432945
  432974
  434443
  443251
  443317
  445727
  448115
  454793
  457476
  467584
  467636
  471129
  471335
  474596
  475502
  475504
  475920
  476053
  477502
  480258
  486772
  499872
  500333
  505093
  511862
  511864
  512072
  514257
  516640
  516843
  522639
  526179
  529296
  529632
  531578
  531582
  531879
  531891
  534443
  534828
  535963
  543897
  545438
  548153
  548857
  564285
  564288
  567120
  576848
  586113
  587292
  594053
  598882
  600958
  602281
  607683
  607685
  619322
  626044
  631740
  641806
  642149
  653028
  662046
  669062
  671038
  672315
  672944
  687347
  709542
  713194
  738461
  738501
  738515
  739124
  739158
  744047
  745087
  749215
  749264
  752648
  752753
  753635
  760598
  766266
  770261
  770814
  782854
  784217
  793151
  795404
  795420
  796333
  796647
  796703
  798599
  799759
  804939
  806924
  808068
  810776
  811570
  813206
  818103
  827287
]
1.69 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur huge dildo"
]
1.66 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск огромные дилд"
]
1.59 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.89%)
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.