Query Metrics
7
Database Queries
7
Different statements
172.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.27 ms (83.08%) |
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 81571 95788 103696 251147 382697 383667 386194 387919 388821 393673 396348 398325 398917 476838 521780 532344 532717 533646 533689 534133 538141 538814 538883 540122 542489 547980 554876 566394 566583 593893 606535 622116 623525 633965 639075 648996 649947 651313 651423 654094 654481 654574 655994 656677 659589 663902 666841 678576 679061 679078 679079 685220 685521 689310 691497 692336 694555 694557 695236 697761 699531 699779 702877 703070 706612 712887 714542 715534 716829 720215 721792 731774 733020 733179 733830 736263 741207 742876 745208 745740 748384 748436 752076 752183 756433 758298 766568 767327 767330 771723 773947 775899 778156 788669 788921 789708 790012 792487 797578 800007 801069 804188 805304 811947 815667 815952 817341 817458 819176 819311 820549 820989 821484 821857 822027 825690 826480 827873 827896 828865 ] |
||||||||||||||||||||||||||||||
|
19.47 ms (11.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 767327 800007 804188 805304 811947 745740 752183 756433 742876 752076 745208 773947 733830 748436 767330 702877 715534 720215 721792 788669 792487 382697 386194 398325 251147 393673 95788 387919 396348 817341 822027 815952 819311 532344 533689 538814 649947 654574 678576 679061 679078 679079 695236 714542 651313 685220 691497 694555 699531 699779 656677 666841 689310 692336 694557 706612 712887 716829 593893 639075 606535 622116 633965 778156 788921 789708 801069 775899 736263 758298 766568 797578 731774 733020 733179 741207 748384 771723 623525 697761 703070 790012 383667 476838 388821 103696 81571 398917 817458 820989 821484 815667 820549 819176 821857 825690 826480 828865 827873 827896 532717 540122 521780 534133 538883 533646 538141 542489 547980 566394 554876 566583 648996 651423 654094 654481 655994 659589 663902 685521 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.46%) |
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 81571 95788 103696 251147 382697 383667 386194 387919 388821 393673 396348 398325 398917 476838 521780 532344 532717 533646 533689 534133 538141 538814 538883 540122 542489 547980 554876 566394 566583 593893 606535 622116 623525 633965 639075 648996 649947 651313 651423 654094 654481 654574 655994 656677 659589 663902 666841 678576 679061 679078 679079 685220 685521 689310 691497 692336 694555 694557 695236 697761 699531 699779 702877 703070 706612 712887 714542 715534 716829 720215 721792 731774 733020 733179 733830 736263 741207 742876 745208 745740 748384 748436 752076 752183 756433 758298 766568 767327 767330 771723 773947 775899 778156 788669 788921 789708 790012 792487 797578 800007 801069 804188 805304 811947 815667 815952 817341 817458 819176 819311 820549 820989 821484 821857 822027 825690 826480 827873 827896 828865 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex threesome"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.92%) |
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.