Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.35 ms
(87.16%)
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
  382633
  390650
  397478
  404119
  415977
  429020
  438339
  438518
  438655
  439146
  441222
  442645
  442705
  442983
  445419
  446561
  449963
  450277
  452850
  452873
  455640
  457379
  459182
  460167
  467560
  471082
  476475
  478991
  491881
  509113
  517540
  524864
  527122
  528320
  528530
  529230
  534858
  536377
  538703
  541328
  541541
  541971
  542764
  544001
  545905
  546972
  546981
  547945
  554372
  555131
  559427
  561971
  568134
  568864
  570940
  571708
  577695
  577719
  587283
  588467
  589408
  590788
  592482
  597763
  598049
  601412
  605184
  614702
  619791
  620633
  627311
  636638
  640143
  644510
  649306
  650915
  652974
  669668
  686331
  706446
  710771
  737140
  738564
  742092
  744022
  744047
  745915
  749237
  754209
  754480
  759130
  783939
  786878
  789786
  791132
  794243
  796695
  797180
  801016
  801394
  801825
  803619
  804422
  804441
  804458
  806321
  806930
  806937
  807067
  808585
  808623
  810099
  810798
  812273
  812279
  814459
  814467
  814477
  823790
  824870
]
15.34 ms
(7.99%)
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
  598049
  614702
  636638
  640143
  587283
  589408
  592482
  597763
  601412
  619791
  588467
  605184
  620633
  789786
  794243
  797180
  801394
  803619
  807067
  808623
  810798
  812279
  796695
  801016
  801825
  804441
  806930
  808585
  812273
  744047
  783939
  786878
  806937
  744022
  738564
  759130
  737140
  742092
  745915
  749237
  754209
  754480
  627311
  644510
  791132
  804422
  804458
  806321
  810099
  397478
  404119
  476475
  509113
  517540
  478991
  538703
  590788
  467560
  382633
  390650
  429020
  438518
  442645
  438655
  438339
  439146
  441222
  442983
  415977
  442705
  445419
  814477
  824870
  814467
  814459
  823790
  446561
  449963
  455640
  457379
  491881
  452873
  459182
  471082
  450277
  452850
  528530
  534858
  524864
  527122
  528320
  536377
  529230
  460167
  542764
  561971
  570940
  571708
  577695
  541328
  541971
  545905
  546972
  547945
  568134
  577719
  541541
  544001
  546981
  554372
  555131
  559427
  568864
  669668
  686331
  649306
  650915
  652974
  706446
  710771
]
2.28 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam shower solo"
]
2.26 ms
(1.18%)
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
  382633
  390650
  397478
  404119
  415977
  429020
  438339
  438518
  438655
  439146
  441222
  442645
  442705
  442983
  445419
  446561
  449963
  450277
  452850
  452873
  455640
  457379
  459182
  460167
  467560
  471082
  476475
  478991
  491881
  509113
  517540
  524864
  527122
  528320
  528530
  529230
  534858
  536377
  538703
  541328
  541541
  541971
  542764
  544001
  545905
  546972
  546981
  547945
  554372
  555131
  559427
  561971
  568134
  568864
  570940
  571708
  577695
  577719
  587283
  588467
  589408
  590788
  592482
  597763
  598049
  601412
  605184
  614702
  619791
  620633
  627311
  636638
  640143
  644510
  649306
  650915
  652974
  669668
  686331
  706446
  710771
  737140
  738564
  742092
  744022
  744047
  745915
  749237
  754209
  754480
  759130
  783939
  786878
  789786
  791132
  794243
  796695
  797180
  801016
  801394
  801825
  803619
  804422
  804441
  804458
  806321
  806930
  806937
  807067
  808585
  808623
  810099
  810798
  812273
  812279
  814459
  814467
  814477
  823790
  824870
]
1.64 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер shower соло"
]
1.60 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер shower соло"
]

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.