Query Metrics
7
Database Queries
7
Different statements
169.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.93 ms (83.79%) |
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 400735 413488 416044 416153 419181 437494 446861 459573 460011 468326 476670 488594 490198 492719 496462 497878 498391 501958 504488 504725 504769 511552 512447 515200 516025 516884 520719 528641 531201 532834 537467 540269 547543 548162 556741 559372 560193 572838 573760 577019 577290 581949 592862 600312 606579 610680 620557 627225 639751 641978 642308 645012 647344 653757 661020 661568 666538 666596 666719 669410 672355 679713 681081 685509 686224 693755 693804 693808 703142 722545 728316 740904 744427 747313 747928 748154 748927 750732 751435 753774 756614 760612 761294 765156 765479 767325 769413 770376 770759 776548 780653 785603 786725 787002 787408 788855 789954 796957 797139 799636 800706 801625 801772 802832 803450 804498 805021 805201 807699 808102 811119 811992 816057 819036 820715 826715 826763 826972 827080 827404 ] |
||||||||||||||||||||||||||||||
|
15.75 ms (9.30%) |
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 647344 639751 641978 528641 501958 540269 820715 816057 722545 789954 740904 787408 808102 826972 496462 577019 653757 672355 693755 693808 805201 799636 747928 748927 753774 756614 627225 581949 765479 592862 504769 516025 826715 827080 606579 788855 770759 787002 459573 666719 679713 531201 490198 437494 515200 520719 460011 681081 769413 573760 669410 413488 661568 504488 400735 819036 476670 511552 537467 666596 685509 661020 642308 620557 780653 796957 750732 760612 797139 744427 804498 826763 827404 548162 703142 693804 610680 800706 785603 786725 811992 767325 801625 468326 416153 492719 751435 498391 600312 497878 488594 572838 776548 807699 811119 802832 803450 801772 805021 728316 748154 765156 761294 747313 770376 419181 504725 560193 512447 446861 645012 666538 516884 556741 532834 577290 416044 547543 559372 686224 ] |
||||||||||||||||||||||||||||||
|
4.72 ms (2.79%) |
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 400735 413488 416044 416153 419181 437494 446861 459573 460011 468326 476670 488594 490198 492719 496462 497878 498391 501958 504488 504725 504769 511552 512447 515200 516025 516884 520719 528641 531201 532834 537467 540269 547543 548162 556741 559372 560193 572838 573760 577019 577290 581949 592862 600312 606579 610680 620557 627225 639751 641978 642308 645012 647344 653757 661020 661568 666538 666596 666719 669410 672355 679713 681081 685509 686224 693755 693804 693808 703142 722545 728316 740904 744427 747313 747928 748154 748927 750732 751435 753774 756614 760612 761294 765156 765479 767325 769413 770376 770759 776548 780653 785603 786725 787002 787408 788855 789954 796957 797139 799636 800706 801625 801772 802832 803450 804498 805021 805201 807699 808102 811119 811992 816057 819036 820715 826715 826763 826972 827080 827404 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big pussy squirt"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие pussy сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие pussy сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.91%) |
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.