Query Metrics
7
Database Queries
7
Different statements
142.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.42 ms (84.62%) |
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 417219 421116 423849 448796 453905 454654 456431 457199 458835 459569 461830 463442 466419 469172 473966 475196 475826 483902 485848 486820 496993 501411 509401 520790 522935 523495 529972 546273 547917 556869 568944 574020 588278 588893 590071 590328 592787 593613 595137 606253 606557 607622 609081 613440 614001 615137 615509 616839 617388 619350 623745 625492 625957 625992 626678 631057 636623 637998 639882 647604 648693 662076 663839 664698 668034 668100 677981 678216 678876 683698 687140 687835 689040 689994 691149 693420 693630 696374 698915 702623 707214 711802 714808 715435 719457 722253 723010 724887 728463 731580 734124 734185 734277 734624 735413 736933 739324 739459 739682 740181 741004 741983 742235 743005 758420 759608 761733 761765 762369 762771 765394 782297 794827 813836 817203 819872 819949 821468 822305 825581 ] |
||||||||||||||||||||||||||||||
|
11.83 ms (8.31%) |
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 592787 595137 606253 606557 616839 607622 631057 739682 724887 762369 639882 421116 819872 819949 822305 813836 825581 817203 821468 547917 568944 574020 648693 678876 687140 687835 689994 691149 693630 696374 707214 711802 714808 719457 723010 647604 663839 664698 668034 683698 689040 693420 702623 722253 662076 668100 677981 678216 715435 546273 590328 609081 615137 619350 625492 636623 588893 593613 614001 615509 617388 625992 588278 626678 590071 623745 794827 734124 734185 734624 736933 740181 761733 782297 731580 739324 759608 728463 739459 762771 734277 735413 741004 741983 743005 758420 761765 613440 625957 637998 698915 765394 556869 417219 457199 458835 459569 466419 475826 483902 453905 454654 469172 496993 520790 509401 522935 529972 501411 523495 485848 486820 742235 473966 475196 461830 423849 448796 456431 463442 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.99%) |
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 417219 421116 423849 448796 453905 454654 456431 457199 458835 459569 461830 463442 466419 469172 473966 475196 475826 483902 485848 486820 496993 501411 509401 520790 522935 523495 529972 546273 547917 556869 568944 574020 588278 588893 590071 590328 592787 593613 595137 606253 606557 607622 609081 613440 614001 615137 615509 616839 617388 619350 623745 625492 625957 625992 626678 631057 636623 637998 639882 647604 648693 662076 663839 664698 668034 668100 677981 678216 678876 683698 687140 687835 689040 689994 691149 693420 693630 696374 698915 702623 707214 711802 714808 715435 719457 722253 723010 724887 728463 731580 734124 734185 734277 734624 735413 736933 739324 739459 739682 740181 741004 741983 742235 743005 758420 759608 761733 761765 762369 762771 765394 782297 794827 813836 817203 819872 819949 821468 822305 825581 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real big dick"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.06%) |
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.