Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.74 ms
(84.09%)
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
  187954
  310671
  365924
  379600
  382748
  388322
  388722
  390045
  390252
  392213
  392750
  398209
  398954
  403324
  403924
  406899
  407819
  408318
  409934
  411345
  411352
  411397
  411720
  411745
  414601
  422298
  439752
  440312
  441124
  444113
  444145
  450143
  450286
  451937
  452234
  452940
  453313
  454247
  457515
  458000
  460175
  460746
  460757
  460906
  464138
  465592
  465834
  466206
  466318
  466801
  467050
  467279
  467469
  467484
  469106
  469355
  469372
  469575
  470158
  470610
  471078
  471417
  471975
  474080
  474113
  475842
  476224
  476279
  476284
  477070
  477961
  478378
  479073
  479100
  479102
  479103
  479145
  480851
  481881
  482525
  483655
  484160
  484413
  484564
  484686
  485971
  487338
  488959
  490197
  491989
  495881
  502929
  505089
  508451
  514445
  515841
  515910
  516227
  516470
  516483
  516562
  525489
  525695
  526745
  526832
  533607
  546715
  555274
  563066
  563173
  569943
  580340
  590347
  591977
  620098
  665446
  726522
  751627
  815095
  827098
]
18.19 ms
(9.82%)
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
  477070
  485971
  525489
  476279
  555274
  390252
  392213
  411720
  480851
  467050
  471975
  411397
  471078
  310671
  382748
  388322
  440312
  444113
  466318
  470610
  525695
  484413
  505089
  827098
  726522
  187954
  390045
  398209
  403924
  406899
  411745
  407819
  409934
  451937
  452234
  467484
  476224
  464138
  471417
  465592
  466801
  475842
  533607
  460175
  469575
  474080
  563066
  563173
  569943
  546715
  591977
  411352
  457515
  479102
  411345
  439752
  452940
  454247
  460906
  467279
  476284
  403324
  460757
  467469
  469372
  474113
  477961
  479145
  379600
  388722
  444145
  458000
  465834
  466206
  479073
  479100
  479103
  450286
  470158
  478378
  516470
  516562
  483655
  526745
  526832
  484564
  487338
  488959
  490197
  491989
  502929
  516483
  484686
  514445
  515841
  515910
  392750
  441124
  422298
  815095
  450143
  495881
  484160
  665446
  590347
  751627
  469106
  398954
  365924
  408318
  414601
  460746
  482525
  580340
  620098
  453313
  469355
  481881
  508451
  516227
]
3.25 ms
(1.75%)
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
  187954
  310671
  365924
  379600
  382748
  388322
  388722
  390045
  390252
  392213
  392750
  398209
  398954
  403324
  403924
  406899
  407819
  408318
  409934
  411345
  411352
  411397
  411720
  411745
  414601
  422298
  439752
  440312
  441124
  444113
  444145
  450143
  450286
  451937
  452234
  452940
  453313
  454247
  457515
  458000
  460175
  460746
  460757
  460906
  464138
  465592
  465834
  466206
  466318
  466801
  467050
  467279
  467469
  467484
  469106
  469355
  469372
  469575
  470158
  470610
  471078
  471417
  471975
  474080
  474113
  475842
  476224
  476279
  476284
  477070
  477961
  478378
  479073
  479100
  479102
  479103
  479145
  480851
  481881
  482525
  483655
  484160
  484413
  484564
  484686
  485971
  487338
  488959
  490197
  491989
  495881
  502929
  505089
  508451
  514445
  515841
  515910
  516227
  516470
  516483
  516562
  525489
  525695
  526745
  526832
  533607
  546715
  555274
  563066
  563173
  569943
  580340
  590347
  591977
  620098
  665446
  726522
  751627
  815095
  827098
]
2.15 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature женскийрод"
]
2.07 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature bitch"
]
2.04 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature женскийрод"
]

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.