Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
251.50 ms
(88.03%)
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
  87974
  89199
  382670
  391563
  397986
  403896
  408911
  414050
  415303
  416531
  416561
  416669
  416690
  416725
  420295
  421993
  423995
  427128
  432824
  432945
  432974
  443317
  444490
  446022
  446446
  448115
  449970
  462840
  467560
  470412
  471129
  475920
  476674
  477502
  483738
  486772
  499872
  500333
  505093
  514257
  516640
  524215
  527922
  529296
  529632
  529696
  531352
  531578
  531582
  531879
  531891
  534443
  535963
  540680
  545404
  545438
  576848
  592574
  600958
  602281
  607683
  616454
  619286
  619322
  626044
  634750
  640262
  642149
  653028
  687347
  735703
  738461
  738501
  738515
  739119
  739124
  739158
  740523
  744047
  745874
  749090
  749215
  749264
  750992
  751609
  752648
  752679
  752753
  753635
  758163
  760598
  766266
  766941
  770261
  770814
  782854
  784066
  784217
  784310
  785816
  785979
  788863
  788899
  789436
  792706
  793151
  795404
  795420
  796333
  796647
  796703
  798599
  799759
  804939
  806924
  811570
  811723
  813487
  827287
  827395
]
24.39 ms
(8.54%)
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
  616454
  795404
  796703
  798599
  782854
  793151
  795420
  796333
  796647
  749090
  770814
  739119
  752679
  735703
  751609
  745874
  752648
  788863
  87974
  414050
  382670
  444490
  499872
  524215
  446446
  827287
  486772
  475920
  529296
  529696
  529632
  535963
  531582
  531879
  531891
  534443
  653028
  687347
  642149
  607683
  634750
  640262
  784217
  785816
  799759
  784310
  806924
  813487
  738501
  740523
  749215
  760598
  804939
  811723
  739124
  758163
  766941
  766266
  738461
  738515
  739158
  753635
  602281
  784066
  785979
  789436
  792706
  811570
  391563
  788899
  416531
  408911
  416690
  448115
  514257
  545438
  600958
  592574
  744047
  749264
  752753
  770261
  827395
  750992
  415303
  416561
  416725
  423995
  416669
  476674
  527922
  619286
  446022
  467560
  531352
  89199
  397986
  470412
  545404
  462840
  403896
  443317
  427128
  432945
  449970
  477502
  483738
  540680
  500333
  516640
  531578
  505093
  576848
  619322
  626044
  432824
  432974
  471129
  421993
  420295
]
3.39 ms
(1.19%)
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
  87974
  89199
  382670
  391563
  397986
  403896
  408911
  414050
  415303
  416531
  416561
  416669
  416690
  416725
  420295
  421993
  423995
  427128
  432824
  432945
  432974
  443317
  444490
  446022
  446446
  448115
  449970
  462840
  467560
  470412
  471129
  475920
  476674
  477502
  483738
  486772
  499872
  500333
  505093
  514257
  516640
  524215
  527922
  529296
  529632
  529696
  531352
  531578
  531582
  531879
  531891
  534443
  535963
  540680
  545404
  545438
  576848
  592574
  600958
  602281
  607683
  616454
  619286
  619322
  626044
  634750
  640262
  642149
  653028
  687347
  735703
  738461
  738501
  738515
  739119
  739124
  739158
  740523
  744047
  745874
  749090
  749215
  749264
  750992
  751609
  752648
  752679
  752753
  753635
  758163
  760598
  766266
  766941
  770261
  770814
  782854
  784066
  784217
  784310
  785816
  785979
  788863
  788899
  789436
  792706
  793151
  795404
  795420
  796333
  796647
  796703
  798599
  799759
  804939
  806924
  811570
  811723
  813487
  827287
  827395
]
1.79 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam huge dildo"
]
1.59 ms
(0.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер огромные дилд"
]
1.49 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.