Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.05 ms
(85.58%)
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
  416252
  432310
  439910
  443779
  448074
  453511
  453689
  455507
  455771
  458022
  460361
  460958
  462155
  462330
  463061
  464528
  464699
  465356
  469876
  469919
  469920
  470343
  470944
  473608
  474495
  477354
  477363
  478557
  482120
  482674
  483037
  484392
  484568
  484609
  484655
  484659
  484719
  486339
  492040
  494161
  495051
  495740
  495744
  497240
  497936
  498194
  498269
  500596
  500901
  502477
  502484
  503304
  503314
  503965
  504158
  506050
  506821
  509842
  510427
  510750
  514455
  515361
  516635
  520132
  522999
  523301
  524408
  526568
  527031
  542539
  542745
  542748
  542765
  542791
  543960
  544040
  545377
  546724
  549799
  550484
  556001
  557942
  557943
  557945
  557949
  557983
  559575
  559771
  560454
  562815
  567382
  568193
  571775
  577120
  590693
  590860
  590885
  591908
  594487
  598207
  598786
  598918
  599197
  601364
  603636
  603863
  606567
  606794
  608772
  618017
  625556
  666530
  679821
  682389
  691409
  693338
  718698
  738440
  751589
  755176
]
17.78 ms
(9.16%)
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
  557942
  559771
  542539
  542748
  542765
  542791
  543960
  544040
  545377
  557949
  557983
  560454
  542745
  546724
  550484
  557943
  557945
  559575
  562815
  568193
  571775
  577120
  679821
  666530
  682389
  691409
  693338
  718698
  567382
  598786
  603863
  606794
  590693
  594487
  598207
  598918
  599197
  601364
  603636
  590860
  590885
  591908
  738440
  751589
  755176
  416252
  439910
  448074
  453511
  455771
  463061
  464699
  432310
  460361
  460958
  462155
  462330
  464528
  477363
  453689
  455507
  465356
  469876
  470343
  473608
  474495
  482120
  469919
  469920
  477354
  478557
  458022
  503304
  510427
  510750
  515361
  527031
  484719
  492040
  495051
  495740
  498269
  502477
  503965
  506050
  506821
  509842
  516635
  522999
  523301
  526568
  483037
  484609
  484655
  494161
  495744
  497240
  500596
  500901
  504158
  524408
  484392
  484568
  484659
  486339
  497936
  498194
  502484
  503314
  514455
  482674
  520132
  556001
  549799
  606567
  608772
  618017
  625556
  443779
  470944
]
2.71 ms
(1.40%)
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
  416252
  432310
  439910
  443779
  448074
  453511
  453689
  455507
  455771
  458022
  460361
  460958
  462155
  462330
  463061
  464528
  464699
  465356
  469876
  469919
  469920
  470343
  470944
  473608
  474495
  477354
  477363
  478557
  482120
  482674
  483037
  484392
  484568
  484609
  484655
  484659
  484719
  486339
  492040
  494161
  495051
  495740
  495744
  497240
  497936
  498194
  498269
  500596
  500901
  502477
  502484
  503304
  503314
  503965
  504158
  506050
  506821
  509842
  510427
  510750
  514455
  515361
  516635
  520132
  522999
  523301
  524408
  526568
  527031
  542539
  542745
  542748
  542765
  542791
  543960
  544040
  545377
  546724
  549799
  550484
  556001
  557942
  557943
  557945
  557949
  557983
  559575
  559771
  560454
  562815
  567382
  568193
  571775
  577120
  590693
  590860
  590885
  591908
  594487
  598207
  598786
  598918
  599197
  601364
  603636
  603863
  606567
  606794
  608772
  618017
  625556
  666530
  679821
  682389
  691409
  693338
  718698
  738440
  751589
  755176
]
2.05 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian swinger"
]
2.01 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск свингер"
]
1.88 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.