Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.71 ms
(78.97%)
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
  31492
  159305
  382959
  383856
  389060
  407759
  409352
  415780
  418080
  422144
  422347
  424448
  433240
  440838
  443697
  443827
  443918
  446515
  450108
  453112
  453491
  454194
  454280
  457605
  457782
  458730
  461688
  462290
  465962
  466063
  466279
  466341
  467075
  467240
  468096
  470041
  470613
  471340
  472703
  473246
  473334
  474433
  474710
  475874
  476630
  479145
  479148
  479668
  483382
  485689
  488363
  490644
  494204
  495518
  496871
  502199
  503580
  505640
  509590
  511570
  513341
  515078
  516466
  516478
  517397
  517535
  518579
  519073
  522961
  523824
  525878
  528596
  529346
  531070
  535439
  545972
  547987
  549728
  549772
  554463
  558295
  563220
  566356
  568100
  568603
  569426
  582321
  585035
  641652
  664846
  681168
  683284
  683288
  693208
  709528
  710510
  718861
  720621
  727863
  733078
  746598
  753667
  763914
  776320
  778524
  780634
  780673
  781746
  781929
  786371
  787557
  794226
  794704
  796459
  796920
  797245
  799357
  800337
  805923
  814369
]
21.66 ms
(13.29%)
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
  422144
  529346
  683288
  805923
  794704
  753667
  443918
  453491
  465962
  566356
  450108
  476630
  495518
  511570
  474710
  31492
  389060
  409352
  681168
  797245
  475874
  466063
  523824
  531070
  509590
  585035
  461688
  473334
  485689
  505640
  517535
  473246
  545972
  568603
  558295
  582321
  547987
  568100
  569426
  549772
  467240
  479148
  466341
  471340
  407759
  454280
  470613
  502199
  522961
  513341
  518579
  528596
  494204
  517397
  515078
  718861
  641652
  780673
  796459
  733078
  746598
  778524
  781929
  794226
  383856
  418080
  814369
  683284
  709528
  664846
  693208
  781746
  786371
  727863
  763914
  787557
  796920
  800337
  446515
  453112
  458730
  503580
  467075
  549728
  563220
  443827
  462290
  474433
  433240
  443697
  470041
  479145
  422347
  457782
  466279
  454194
  516466
  516478
  483382
  519073
  496871
  490644
  535439
  415780
  440838
  479668
  488363
  159305
  424448
  525878
  382959
  468096
  472703
  457605
  554463
  710510
  720621
  776320
  780634
  799357
]
3.41 ms
(2.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "обвисшая зрелая женщин порн"
]
2.77 ms
(1.70%)
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
  31492
  159305
  382959
  383856
  389060
  407759
  409352
  415780
  418080
  422144
  422347
  424448
  433240
  440838
  443697
  443827
  443918
  446515
  450108
  453112
  453491
  454194
  454280
  457605
  457782
  458730
  461688
  462290
  465962
  466063
  466279
  466341
  467075
  467240
  468096
  470041
  470613
  471340
  472703
  473246
  473334
  474433
  474710
  475874
  476630
  479145
  479148
  479668
  483382
  485689
  488363
  490644
  494204
  495518
  496871
  502199
  503580
  505640
  509590
  511570
  513341
  515078
  516466
  516478
  517397
  517535
  518579
  519073
  522961
  523824
  525878
  528596
  529346
  531070
  535439
  545972
  547987
  549728
  549772
  554463
  558295
  563220
  566356
  568100
  568603
  569426
  582321
  585035
  641652
  664846
  681168
  683284
  683288
  693208
  709528
  710510
  718861
  720621
  727863
  733078
  746598
  753667
  763914
  776320
  778524
  780634
  780673
  781746
  781929
  786371
  787557
  794226
  794704
  796459
  796920
  797245
  799357
  800337
  805923
  814369
]
2.36 ms
(1.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "обвисшая зрелая женщин порн"
]
2.05 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð▓ð©ÐüÐÅÐçð©ðÁ Ðâ ðÀÐÇðÁð╗ÐïÐà ð┐ð¥ÐÇð¢ðÔǪ"
]
2.01 ms
(1.23%)
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.