Query Metrics
7
Database Queries
7
Different statements
636.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
419.95 ms (65.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп cock"
]
|
||||||||||||||||||||||||||||||
|
195.44 ms (30.71%) |
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 74181 187590 357604 386701 395527 403076 403628 427751 457978 459193 488640 492280 500500 504862 510102 517872 521671 523843 525987 530298 530498 533303 535032 535350 543501 555954 556648 565142 574624 575659 578285 580525 583325 586970 587290 587329 588456 589464 589503 591745 592997 597754 605603 605692 615246 616233 619488 619504 624815 625980 627202 634331 634922 645038 647692 652641 661918 663275 665004 665658 669564 671342 674875 678368 679297 687078 687514 690952 697585 700158 701470 703481 709587 712935 713686 716893 721693 724590 725463 727545 728248 732229 734329 734661 734903 735897 736062 736279 737456 738206 738277 738458 740118 744434 745959 750248 750894 753521 758023 759732 764395 770658 773796 776317 782582 782659 792136 797856 807157 810945 818482 818494 818798 821506 822385 825890 825957 826549 828248 ] |
||||||||||||||||||||||||||||||
|
12.64 ms (1.99%) |
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 587329 797856 810945 773796 782659 403628 523843 724590 776317 807157 727545 818494 828248 687514 619488 736062 758023 634331 624815 661918 665658 716893 586970 770658 504862 535032 575659 671342 615246 627202 592997 605603 500500 488640 605692 792136 750248 703481 647692 734661 734903 543501 510102 357604 427751 818482 826549 535350 580525 583325 678368 709587 652641 587290 744434 737456 738458 764465 634922 700158 386701 459193 578285 679297 740118 521671 525987 457978 395527 530498 530298 555954 574624 690952 645038 701470 745959 738206 818798 492280 669564 712935 565142 782582 728248 750894 517872 619504 753521 732229 74181 187590 822385 821506 825890 825957 556648 687078 721693 663275 665004 588456 625980 736279 764395 697585 403076 533303 674875 713686 591745 589503 616233 589464 597754 725463 759732 738277 734329 735897 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (0.52%) |
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 74181 187590 357604 386701 395527 403076 403628 427751 457978 459193 488640 492280 500500 504862 510102 517872 521671 523843 525987 530298 530498 533303 535032 535350 543501 555954 556648 565142 574624 575659 578285 580525 583325 586970 587290 587329 588456 589464 589503 591745 592997 597754 605603 605692 615246 616233 619488 619504 624815 625980 627202 634331 634922 645038 647692 652641 661918 663275 665004 665658 669564 671342 674875 678368 679297 687078 687514 690952 697585 700158 701470 703481 709587 712935 713686 716893 721693 724590 725463 727545 728248 732229 734329 734661 734903 735897 736062 736279 737456 738206 738277 738458 740118 744434 745959 750248 750894 753521 758023 759732 764395 770658 773796 776317 782582 782659 792136 797856 807157 810945 818482 818494 818798 821506 822385 825890 825957 826549 828248 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп cock"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass cock"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.22%) |
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.