Query Metrics
7
Database Queries
7
Different statements
182.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.26 ms (87.42%) |
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 400928 414103 423802 538066 542987 544899 544915 546016 546493 546813 549040 553812 554846 555089 555486 556796 557522 559293 559311 559805 565500 565935 567588 569736 575360 579128 581281 581960 585260 588035 588748 600304 604589 605527 610484 618259 620037 625300 626163 631457 631459 632017 634745 635775 636284 638441 640442 641226 642429 650146 651984 667589 667914 668648 669331 669870 673214 690800 693848 694482 696584 697182 698841 698916 702960 708591 714012 714382 714953 717667 718498 726657 727039 728240 730104 730936 731007 735976 737496 740858 742056 744077 746562 748048 751427 753170 756949 757052 758322 759761 774663 776414 776842 781850 785466 787564 788322 793694 794394 794968 796273 796860 796992 798087 800319 800430 801804 803516 804260 804432 806700 810360 810684 811503 812332 813534 818502 818867 825879 826501 ] |
||||||||||||||||||||||||||||||
|
13.68 ms (7.51%) |
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 667914 669331 696584 693848 694482 697182 567588 642429 605527 638441 635775 641226 781850 811503 785466 800430 812332 737496 758322 798087 801804 804260 804432 813534 728240 730936 742056 726657 744077 751427 759761 727039 735976 756949 604589 776414 788322 796860 803516 714012 636284 400928 414103 542987 546016 555089 581281 557522 559293 579128 787564 730104 423802 818867 826501 825879 818502 538066 546493 546813 559311 575360 544899 549040 559805 565500 553812 554846 569736 581960 651984 673214 690800 698916 702960 714382 717667 650146 698841 718498 667589 668648 669870 708591 714953 544915 555486 556796 565935 585260 588035 610484 631457 632017 634745 640442 600304 620037 625300 626163 588748 618259 631459 794394 794968 800319 810684 774663 776842 793694 796273 796992 806700 810360 731007 740858 746562 748048 753170 757052 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.44%) |
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 400928 414103 423802 538066 542987 544899 544915 546016 546493 546813 549040 553812 554846 555089 555486 556796 557522 559293 559311 559805 565500 565935 567588 569736 575360 579128 581281 581960 585260 588035 588748 600304 604589 605527 610484 618259 620037 625300 626163 631457 631459 632017 634745 635775 636284 638441 640442 641226 642429 650146 651984 667589 667914 668648 669331 669870 673214 690800 693848 694482 696584 697182 698841 698916 702960 708591 714012 714382 714953 717667 718498 726657 727039 728240 730104 730936 731007 735976 737496 740858 742056 744077 746562 748048 751427 753170 756949 757052 758322 759761 774663 776414 776842 781850 785466 787564 788322 793694 794394 794968 796273 796860 796992 798087 800319 800430 801804 803516 804260 804432 806700 810360 810684 811503 812332 813534 818502 818867 825879 826501 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие pussy дырк"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие pussy дырк"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big pussy hole"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.83%) |
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.