Query Metrics
7
Database Queries
7
Different statements
181.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.21 ms (86.69%) |
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 458118 474849 474864 502034 502059 504354 504414 533609 538660 545769 547924 549766 557056 559348 569985 588084 589821 594879 601885 606783 620197 620757 620801 623831 645925 663431 663507 663927 663977 663992 664801 665273 665301 665346 665419 665440 665447 665479 667279 667578 667607 667655 667659 667898 667900 668176 668881 669417 683546 685687 714504 717683 721002 721427 721454 722672 724290 724509 725576 726484 726552 726958 727620 728219 731781 732120 740185 742860 744915 745793 746406 748389 754227 755684 759477 759807 771357 777167 781654 781693 781707 781755 785490 785940 785941 788431 788473 789111 790667 794667 794697 796101 798640 801223 801371 801822 803067 804202 804214 807903 808017 808624 811829 814319 815437 815855 817870 817900 818930 819311 819870 820185 820229 823349 823910 824005 824280 824806 824909 825092 ] |
||||||||||||||||||||||||||||||
|
14.02 ms (7.73%) |
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 745793 781654 789111 740185 725576 759477 815855 623831 798640 724509 667898 814319 825092 474849 549766 685687 721427 803067 808017 811829 728219 732120 726958 502059 474864 817870 817900 824806 824909 820185 818930 819870 820229 824005 823349 823910 824280 559348 665447 665479 667607 667655 717683 667279 721454 663431 665419 589821 601885 588084 781755 785941 788473 794697 796101 777167 781693 781707 785940 794667 746406 755684 744915 771357 724290 714504 721002 785490 804202 815437 557056 645925 664801 665273 667900 667659 683546 547924 620197 606783 801223 801371 790667 727620 754227 804214 731781 726484 726552 742860 807903 808624 668176 663992 594879 667578 620801 620757 748389 458118 819311 663977 665301 759807 502034 669417 668881 663927 665346 665440 788431 801822 545769 569985 533609 722672 504414 504354 538660 663507 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.51%) |
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 458118 474849 474864 502034 502059 504354 504414 533609 538660 545769 547924 549766 557056 559348 569985 588084 589821 594879 601885 606783 620197 620757 620801 623831 645925 663431 663507 663927 663977 663992 664801 665273 665301 665346 665419 665440 665447 665479 667279 667578 667607 667655 667659 667898 667900 668176 668881 669417 683546 685687 714504 717683 721002 721427 721454 722672 724290 724509 725576 726484 726552 726958 727620 728219 731781 732120 740185 742860 744915 745793 746406 748389 754227 755684 759477 759807 771357 777167 781654 781693 781707 781755 785490 785940 785941 788431 788473 789111 790667 794667 794697 796101 798640 801223 801371 801822 803067 804202 804214 807903 808017 808624 811829 814319 815437 815855 817870 817900 818930 819311 819870 820185 820229 823349 823910 824005 824280 824806 824909 825092 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old saggy blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old saggy минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old saggy минет оральн секс"
]
|
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.