Query Metrics
7
Database Queries
7
Different statements
194.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.33 ms (85.47%) |
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 83037 381923 382840 384086 387323 398308 398701 399525 400619 405483 405814 406044 406340 416740 426124 445033 453284 523126 543187 558082 560698 580359 585633 590295 596074 596112 615781 619431 625796 628048 642314 646936 662125 687315 698386 698435 698459 700268 713289 719586 736812 738278 739374 740270 740506 740507 740949 741609 743238 743241 743265 744045 744114 744796 747296 749118 749568 751331 753004 753594 754431 754548 754714 754756 755002 755227 755347 755892 758968 759065 761268 761473 767096 770131 770931 771133 772904 773693 774085 774179 776412 776725 776774 777655 777997 779234 780262 780387 781304 782732 782780 783289 783398 783602 785762 786310 786336 788615 791113 793093 799835 800648 803018 803759 805440 805560 806605 806621 806694 807040 807218 809053 810927 810969 811069 812484 812487 812492 813942 ] |
||||||||||||||||||||||||||||||
|
17.28 ms (8.88%) |
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 786336 791113 793093 800648 805440 806605 807218 740506 740507 741609 744796 749118 755227 758968 774179 736812 738278 740270 743241 743265 753004 755002 755347 759065 767096 770931 772904 739374 744045 744114 754548 771133 740949 743238 747296 751331 753594 754431 754714 754756 761268 761473 773693 615781 628048 698459 713289 719586 776051 776412 776725 777655 777997 780387 783289 786310 788615 799835 803018 803759 807040 809053 810969 83037 387323 399525 384086 406340 580359 405814 416740 813942 453284 558082 560698 662125 700268 687315 698435 590295 596112 585633 596074 619431 642314 625796 783602 805560 780262 782732 785762 806694 810927 782780 783398 811069 770131 755892 749568 774085 698386 776774 779234 781304 812484 812487 812492 381923 382840 398308 405483 426124 398701 406044 445033 543187 806621 400619 523126 646936 ] |
||||||||||||||||||||||||||||||
|
4.34 ms (2.23%) |
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 83037 381923 382840 384086 387323 398308 398701 399525 400619 405483 405814 406044 406340 416740 426124 445033 453284 523126 543187 558082 560698 580359 585633 590295 596074 596112 615781 619431 625796 628048 642314 646936 662125 687315 698386 698435 698459 700268 713289 719586 736812 738278 739374 740270 740506 740507 740949 741609 743238 743241 743265 744045 744114 744796 747296 749118 749568 751331 753004 753594 754431 754548 754714 754756 755002 755227 755347 755892 758968 759065 761268 761473 767096 770131 770931 771133 772904 773693 774085 774179 776412 776725 776774 777655 777997 779234 780262 780387 781304 782732 782780 783289 783398 783602 785762 786310 786336 788615 791113 793093 799835 800648 803018 803759 805440 805560 806605 806621 806694 807040 807218 809053 810927 810969 811069 812484 812487 812492 813942 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty соло мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty solo masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty соло мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.79%) |
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.