Query Metrics
7
Database Queries
7
Different statements
392.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.39 ms (54.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс писсинг"
]
|
||||||||||||||||||||||||||||||
|
149.92 ms (38.20%) |
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 520879 544232 545389 545403 545409 548389 552601 553692 553696 554841 555601 565276 579783 579866 581296 582277 585350 599987 601578 606071 613958 617852 618177 618867 618902 628332 630536 630552 630821 632579 632706 633244 634140 635781 639719 639741 639751 641953 642226 642774 646255 647822 647860 666850 666894 667354 670779 671773 676428 678095 678780 680176 684318 685511 685701 686265 690942 691821 692621 693985 704582 705351 707391 710935 714551 714599 719649 719829 720341 727534 728860 729063 729187 729236 729253 733119 734360 737598 739919 740846 741402 744832 751437 751453 753656 753707 755145 756461 757050 757217 758145 758259 759313 760939 765812 781358 783930 784246 788643 789438 791003 795924 795974 796803 800119 800949 801084 802194 804371 811658 817613 817864 820347 824896 826541 826849 827279 827490 827591 827592 ] |
||||||||||||||||||||||||||||||
|
17.10 ms (4.36%) |
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 606071 801084 678095 545409 632579 789438 758259 565276 676428 707391 666894 582277 634140 639719 545389 646255 641953 601578 630552 632706 680176 628332 581296 691821 635781 617852 729063 755145 757050 714551 685701 599987 684318 686265 802194 759313 741402 826541 827490 555601 800949 737598 781358 788643 727534 729236 734360 824896 670779 784246 733119 729253 705351 827279 553692 553696 579783 552601 714599 647822 693985 633244 618867 765812 756461 728860 783930 795974 545403 719649 719829 800119 817864 520879 554841 692621 791003 804371 751453 729187 710935 630536 704582 613958 744832 739919 639741 817613 827592 827591 544232 685511 642226 618902 630821 751437 760939 758145 647860 666850 642774 639751 618177 820347 826849 548389 579866 671773 667354 678780 690942 720341 585350 757217 795924 796803 811658 740846 753656 753707 ] |
||||||||||||||||||||||||||||||
|
4.17 ms (1.06%) |
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 520879 544232 545389 545403 545409 548389 552601 553692 553696 554841 555601 565276 579783 579866 581296 582277 585350 599987 601578 606071 613958 617852 618177 618867 618902 628332 630536 630552 630821 632579 632706 633244 634140 635781 639719 639741 639751 641953 642226 642774 646255 647822 647860 666850 666894 667354 670779 671773 676428 678095 678780 680176 684318 685511 685701 686265 690942 691821 692621 693985 704582 705351 707391 710935 714551 714599 719649 719829 720341 727534 728860 729063 729187 729236 729253 733119 734360 737598 739919 740846 741402 744832 751437 751453 753656 753707 755145 756461 757050 757217 758145 758259 759313 760939 765812 781358 783930 784246 788643 789438 791003 795924 795974 796803 800119 800949 801084 802194 804371 811658 817613 817864 820347 824896 826541 826849 827279 827490 827591 827592 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck piss"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.