Query Metrics
7
Database Queries
7
Different statements
199.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.67 ms (87.04%) |
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 530607 530821 542431 543258 545255 548798 549218 554127 556538 556682 557805 559260 560890 561523 563764 569818 571364 571376 590414 592177 617679 624085 636561 639990 645842 653135 660490 664564 666659 675182 680619 692734 695695 697729 706407 706692 709346 710380 710947 715842 717927 718241 718872 719280 720845 723186 724798 724874 727442 728711 728832 730165 730269 731125 731218 731441 732010 733096 733447 733929 734129 735769 736145 736500 737589 737973 741184 743006 743821 743846 743885 746301 748451 748917 749913 752273 753641 755830 756296 758750 761282 763370 765117 765145 766092 767721 767784 768151 768863 769599 772307 777542 779511 779923 780324 780427 781549 781612 784382 785987 787473 787970 790763 791630 792364 793793 795004 795796 797073 797319 799758 799887 800918 800951 803386 805111 807279 808893 811129 ] |
||||||||||||||||||||||||||||||
|
14.61 ms (7.32%) |
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 530607 530821 545255 556538 542431 548798 554127 556682 557805 559260 563764 569818 571376 543258 560890 561523 571364 645842 695695 706407 718241 723186 653135 660490 666659 680619 715842 718872 719280 664564 675182 692734 706692 710380 710947 717927 720845 549218 590414 592177 639990 617679 624085 777542 780324 780427 781549 781612 785987 787473 787970 791630 792364 793793 797073 799758 807279 811129 779511 779923 780348 784382 799887 800951 803386 805111 808893 724874 727442 730165 733447 734129 737973 743006 748917 752273 755830 761282 768863 772307 790763 795004 795796 797319 800918 732010 737589 753641 765117 767784 733929 735769 736145 736500 743821 743846 743885 756296 758750 765145 728711 730269 769599 724798 728832 731125 731218 731441 733096 741184 746301 748451 749913 763370 766092 767721 768151 636561 697729 709346 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (1.71%) |
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 530607 530821 542431 543258 545255 548798 549218 554127 556538 556682 557805 559260 560890 561523 563764 569818 571364 571376 590414 592177 617679 624085 636561 639990 645842 653135 660490 664564 666659 675182 680619 692734 695695 697729 706407 706692 709346 710380 710947 715842 717927 718241 718872 719280 720845 723186 724798 724874 727442 728711 728832 730165 730269 731125 731218 731441 732010 733096 733447 733929 734129 735769 736145 736500 737589 737973 741184 743006 743821 743846 743885 746301 748451 748917 749913 752273 753641 755830 756296 758750 761282 763370 765117 765145 766092 767721 767784 768151 768863 769599 772307 777542 779511 779923 780324 780427 781549 781612 784382 785987 787473 787970 790763 791630 792364 793793 795004 795796 797073 797319 799758 799887 800918 800951 803386 805111 807279 808893 811129 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mouth"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck mouth"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mouth"
]
|
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.