Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.22 ms
(82.75%)
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
  241603
  392076
  410686
  418121
  418142
  424195
  426283
  430350
  434309
  434376
  439343
  440639
  441355
  444684
  450020
  465468
  476663
  486778
  494325
  497203
  500897
  505317
  514847
  514874
  523885
  551568
  556445
  559281
  559411
  559784
  561479
  570994
  574172
  576135
  579224
  580103
  582848
  587260
  588427
  590525
  597159
  598638
  599322
  599709
  607107
  609097
  619286
  628553
  630558
  636958
  638045
  656935
  657561
  658840
  660577
  662850
  681231
  702340
  704369
  713186
  713505
  715592
  716365
  724470
  726315
  729288
  733582
  734412
  737895
  739135
  739169
  740452
  740476
  744416
  748510
  748638
  750121
  752625
  752644
  752700
  758778
  758793
  761945
  770253
  770265
  778679
  781262
  782044
  782050
  782141
  782806
  783050
  783168
  783292
  783905
  786604
  786906
  788575
  790062
  790134
  790414
  791928
  792064
  794205
  794798
  795428
  796659
  796801
  802914
  803510
  804241
  804900
  808143
  813063
  819389
  826509
  826510
  826618
  826941
  827392
]
15.78 ms
(10.43%)
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
  579224
  430350
  441355
  418121
  494325
  559784
  559281
  582848
  598638
  619286
  636958
  750121
  434309
  418142
  826510
  826509
  551568
  559411
  681231
  638045
  782050
  790414
  782141
  737895
  748510
  702340
  783168
  803510
  716365
  794798
  392076
  514874
  576135
  599709
  781262
  450020
  597159
  500897
  808143
  241603
  439343
  440639
  444684
  476663
  465468
  570994
  656935
  662850
  713505
  556445
  580103
  587260
  599322
  628553
  630558
  782806
  786604
  786906
  796801
  733582
  770265
  739169
  724470
  758793
  770253
  752644
  758778
  794205
  802914
  813063
  424195
  505317
  514847
  734412
  410686
  609097
  752700
  434376
  426283
  523885
  826618
  826941
  827392
  819389
  486778
  561479
  574172
  657561
  658840
  660577
  713186
  704369
  588427
  590525
  607107
  778679
  783292
  783905
  788575
  791928
  795428
  752625
  783050
  790062
  790134
  796659
  804241
  729288
  740452
  740476
  744416
  748638
  739135
  761945
  715592
  782044
  792064
  804900
  497203
  726315
]
3.24 ms
(2.14%)
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
  241603
  392076
  410686
  418121
  418142
  424195
  426283
  430350
  434309
  434376
  439343
  440639
  441355
  444684
  450020
  465468
  476663
  486778
  494325
  497203
  500897
  505317
  514847
  514874
  523885
  551568
  556445
  559281
  559411
  559784
  561479
  570994
  574172
  576135
  579224
  580103
  582848
  587260
  588427
  590525
  597159
  598638
  599322
  599709
  607107
  609097
  619286
  628553
  630558
  636958
  638045
  656935
  657561
  658840
  660577
  662850
  681231
  702340
  704369
  713186
  713505
  715592
  716365
  724470
  726315
  729288
  733582
  734412
  737895
  739135
  739169
  740452
  740476
  744416
  748510
  748638
  750121
  752625
  752644
  752700
  758778
  758793
  761945
  770253
  770265
  778679
  781262
  782044
  782050
  782141
  782806
  783050
  783168
  783292
  783905
  786604
  786906
  788575
  790062
  790134
  790414
  791928
  792064
  794205
  794798
  795428
  796659
  796801
  802914
  803510
  804241
  804900
  808143
  813063
  819389
  826509
  826510
  826618
  826941
  827392
]
2.09 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo my wife"
]
1.79 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд my жен"
]
1.66 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд my жен"
]
1.55 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.