Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.99 ms
(85.60%)
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
  96452
  365995
  401916
  425491
  428391
  428418
  434658
  443132
  443704
  443771
  443844
  444123
  444127
  444141
  446105
  453625
  454126
  454129
  454147
  459518
  462042
  462329
  462525
  466002
  466262
  469890
  469917
  470322
  470512
  470518
  470941
  474923
  475143
  475894
  476935
  477398
  479109
  481099
  484133
  484681
  484706
  485516
  486385
  491210
  491381
  491396
  497568
  497589
  500617
  500625
  501756
  505920
  506042
  508016
  510656
  511708
  511739
  512328
  517616
  521925
  523300
  523947
  543587
  543677
  544177
  548668
  548727
  548905
  549778
  552123
  557963
  559026
  559716
  565416
  565450
  567388
  570505
  574812
  575472
  587191
  590375
  596604
  598532
  601958
  618236
  620640
  622661
  637662
  641756
  649135
  649266
  654734
  656023
  658273
  673533
  676448
  678539
  678588
  679102
  679365
  708134
  709295
  711643
  716406
  721203
  721332
  721395
  723074
  723540
  723609
  738812
  740584
  758404
  766274
  789823
  791361
  793915
  797908
  802018
  805166
]
17.21 ms
(9.15%)
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
  658273
  656023
  673533
  637662
  618236
  805166
  802018
  679102
  454129
  544177
  549778
  565450
  567388
  96452
  434658
  443132
  521925
  511708
  505920
  491210
  474923
  679365
  470941
  559716
  590375
  587191
  462329
  443844
  444127
  475143
  462042
  491381
  721203
  723074
  598532
  758404
  740584
  543677
  557963
  649266
  793915
  738812
  484706
  716406
  708134
  641756
  453625
  462525
  476935
  497568
  523300
  491396
  444123
  481099
  548668
  596604
  425491
  428391
  365995
  469917
  470322
  477398
  508016
  486385
  484133
  500625
  510656
  575472
  791361
  723609
  574812
  678588
  548727
  570505
  709295
  721395
  470518
  469890
  497589
  501756
  470512
  466262
  454147
  723540
  559026
  622661
  428418
  459518
  466002
  511739
  500617
  517616
  485516
  512328
  552123
  543587
  565416
  454126
  523947
  548905
  443771
  446105
  766274
  443704
  479109
  475894
  444141
  601958
  401916
  506042
  654734
  797908
  789823
  484681
  721332
  649135
  676448
  678539
  620640
  711643
]
2.96 ms
(1.57%)
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
  96452
  365995
  401916
  425491
  428391
  428418
  434658
  443132
  443704
  443771
  443844
  444123
  444127
  444141
  446105
  453625
  454126
  454129
  454147
  459518
  462042
  462329
  462525
  466002
  466262
  469890
  469917
  470322
  470512
  470518
  470941
  474923
  475143
  475894
  476935
  477398
  479109
  481099
  484133
  484681
  484706
  485516
  486385
  491210
  491381
  491396
  497568
  497589
  500617
  500625
  501756
  505920
  506042
  508016
  510656
  511708
  511739
  512328
  517616
  521925
  523300
  523947
  543587
  543677
  544177
  548668
  548727
  548905
  549778
  552123
  557963
  559026
  559716
  565416
  565450
  567388
  570505
  574812
  575472
  587191
  590375
  596604
  598532
  601958
  618236
  620640
  622661
  637662
  641756
  649135
  649266
  654734
  656023
  658273
  673533
  676448
  678539
  678588
  679102
  679365
  708134
  709295
  711643
  716406
  721203
  721332
  721395
  723074
  723540
  723609
  738812
  740584
  758404
  766274
  789823
  791361
  793915
  797908
  802018
  805166
]
2.02 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð╝ð¥ð╗ð¥ð┤ÐïðÁ ð▓ÐéÐÇð¥Ðæð╝ ÐÇÐâÐüÐüð║ð%ÔǪ"
]
1.71 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодые секс втро русск"
]
1.49 ms
(0.79%)
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.