Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.41 ms
(82.19%)
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
  37350
  408263
  416252
  445035
  512244
  520708
  525756
  528627
  531229
  533258
  536785
  537657
  540286
  545514
  557284
  559087
  560186
  569681
  569923
  569927
  569928
  591587
  597257
  599565
  602642
  603980
  604995
  605399
  607152
  610600
  614142
  632148
  640798
  641055
  641377
  643935
  644967
  649921
  653528
  693422
  696202
  702234
  702286
  718660
  718698
  718701
  718745
  718766
  718772
  718774
  718782
  718784
  718785
  718788
  737438
  741247
  750699
  750718
  750723
  750725
  751576
  751577
  751582
  751583
  751587
  751589
  751609
  751611
  751615
  751616
  758325
  759563
  763720
  763737
  763739
  763744
  765817
  765845
  765848
  765853
  765860
  766335
  769819
  771789
  772884
  772908
  776940
  779567
  782317
  782629
  783392
  783402
  787121
  787131
  791501
  791505
  791516
  792128
  793955
  801296
  801972
  802119
  804927
  805120
  805129
  805141
  805143
  805149
  805151
  805387
  808793
  808863
  808892
  808909
  810132
  811296
  812909
  813155
  814918
]
17.30 ms
(10.58%)
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
  810132
  782317
  814918
  533258
  718784
  640798
  718660
  718774
  653528
  599565
  607152
  591587
  782629
  792128
  805141
  791516
  793955
  813155
  751587
  751616
  765845
  769819
  751583
  644967
  557284
  560186
  614142
  737438
  751576
  751611
  808909
  750723
  772884
  569681
  805129
  763744
  545514
  772908
  765853
  718772
  718701
  791501
  751609
  702234
  37350
  702286
  649921
  758325
  802119
  408263
  602642
  801296
  805387
  783392
  801972
  750718
  750699
  540286
  693422
  569923
  765860
  763720
  765817
  641055
  783402
  763737
  800178
  445035
  805151
  808892
  791505
  808793
  751582
  751615
  765848
  771789
  632148
  808863
  603980
  805149
  763739
  531229
  536785
  779567
  804927
  597257
  512244
  718788
  643935
  787121
  759563
  559087
  750725
  604995
  610600
  776940
  805143
  696202
  718766
  751577
  805120
  812909
  528627
  718785
  766335
  751589
  718698
  416252
  641377
  718782
  787131
  718745
  569928
  605399
  811296
  525756
  537657
  569927
  741247
  520708
]
4.41 ms
(2.70%)
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
  37350
  408263
  416252
  445035
  512244
  520708
  525756
  528627
  531229
  533258
  536785
  537657
  540286
  545514
  557284
  559087
  560186
  569681
  569923
  569927
  569928
  591587
  597257
  599565
  602642
  603980
  604995
  605399
  607152
  610600
  614142
  632148
  640798
  641055
  641377
  643935
  644967
  649921
  653528
  693422
  696202
  702234
  702286
  718660
  718698
  718701
  718745
  718766
  718772
  718774
  718782
  718784
  718785
  718788
  737438
  741247
  750699
  750718
  750723
  750725
  751576
  751577
  751582
  751583
  751587
  751589
  751609
  751611
  751615
  751616
  758325
  759563
  763720
  763737
  763739
  763744
  765817
  765845
  765848
  765853
  765860
  766335
  769819
  771789
  772884
  772908
  776940
  779567
  782317
  782629
  783392
  783402
  787121
  787131
  791501
  791505
  791516
  792128
  793955
  801296
  801972
  802119
  804927
  805120
  805129
  805141
  805143
  805149
  805151
  805387
  808793
  808863
  808892
  808909
  810132
  811296
  812909
  813155
  814918
]
2.00 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fox sex"
]
1.88 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fox секс"
]
1.67 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fox секс"
]

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.