Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
228.14 ms
(59.70%)
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
  725638
  735821
  759553
  772532
  744698
  754141
  715083
  776396
  789182
  402238
  504184
  575094
  575115
  575795
  576416
  557983
  570064
  558072
  566081
  589015
  419674
  475613
  465805
  473955
  464320
  478361
  508835
  484038
  503951
  491212
  491488
  494367
  511878
  484851
  488735
  821976
  396554
  598465
  581965
  598683
  595520
  463766
  600069
  575802
  567429
  545517
  439844
  525873
  439652
  597215
  444121
  500415
  817482
  821860
  825500
  821870
  825694
  825781
  816764
  817317
  825661
  825693
  821829
  821834
  821864
  517552
  499458
  543725
  548401
  564416
  566886
  584666
  554068
  565044
  572197
  652892
  654775
  662436
  677015
  679124
  693341
  714455
  714477
  714491
  720985
  666020
  673092
  676473
  679380
  701501
  718708
  720786
  721400
  721408
  677383
  679385
  712907
  714442
  714469
  714498
  714948
  718705
  720803
  720821
  721447
  545959
  596166
  603003
  617603
  595470
  595869
  598679
  600894
  614110
  626330
  595451
  597072
  599011
  604350
  616000
]
143.33 ms
(37.51%)
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
  396554
  402238
  419674
  439652
  439844
  444121
  463766
  464320
  465805
  473955
  475613
  478361
  484038
  484851
  488735
  491212
  491488
  494367
  499458
  500415
  503951
  504184
  508835
  511878
  517552
  525873
  543725
  545517
  545959
  548401
  554068
  557983
  558072
  564416
  565044
  566081
  566886
  567429
  570064
  572197
  575094
  575115
  575795
  575802
  576416
  581965
  584666
  589015
  595451
  595470
  595520
  595869
  596166
  597072
  597215
  598465
  598679
  598683
  599011
  600069
  600894
  603003
  604350
  614110
  616000
  617603
  626330
  652892
  654775
  662436
  666020
  673092
  676473
  677015
  677383
  679124
  679380
  679385
  693341
  701501
  712907
  714442
  714455
  714469
  714477
  714491
  714498
  714948
  715083
  718705
  718708
  720786
  720803
  720821
  720985
  721400
  721408
  721447
  725638
  735821
  744698
  754141
  759553
  772532
  776396
  789182
  816764
  817317
  817482
  821829
  821834
  821860
  821864
  821870
  821976
  825500
  825661
  825693
  825694
  825781
]
2.81 ms
(0.74%)
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
  396554
  402238
  419674
  439652
  439844
  444121
  463766
  464320
  465805
  473955
  475613
  478361
  484038
  484851
  488735
  491212
  491488
  494367
  499458
  500415
  503951
  504184
  508835
  511878
  517552
  525873
  543725
  545517
  545959
  548401
  554068
  557983
  558072
  564416
  565044
  566081
  566886
  567429
  570064
  572197
  575094
  575115
  575795
  575802
  576416
  581965
  584666
  589015
  595451
  595470
  595520
  595869
  596166
  597072
  597215
  598465
  598679
  598683
  599011
  600069
  600894
  603003
  604350
  614110
  616000
  617603
  626330
  652892
  654775
  662436
  666020
  673092
  676473
  677015
  677383
  679124
  679380
  679385
  693341
  701501
  712907
  714442
  714455
  714469
  714477
  714491
  714498
  714948
  715083
  718705
  718708
  720786
  720803
  720821
  720985
  721400
  721408
  721447
  725638
  735821
  744698
  754141
  759553
  772532
  776396
  789182
  816764
  817317
  817482
  821829
  821834
  821860
  821864
  821870
  821976
  825500
  825661
  825693
  825694
  825781
]
2.32 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зрелый с молодой русской"
]
1.99 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелый мужчин молодой русск"
]
1.95 ms
(0.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.42%)
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.