Query Metrics
7
Database Queries
7
Different statements
189.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.05 ms (85.85%) |
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 517539 520879 540577 541207 542442 542722 550124 550128 550196 550199 550205 553273 553692 554841 555055 555154 557411 566973 569379 570179 579866 580868 581929 583913 585143 591476 591503 597873 599865 599915 599961 600012 600268 600360 601584 608047 613958 617414 618309 630531 630553 633502 634218 635275 637116 637413 637741 639334 639345 639802 639818 640156 641644 642002 642705 647885 647948 647995 650817 664602 666409 666991 668555 675019 677674 678032 678780 699401 704248 704582 709913 710026 714551 716878 717147 718745 718766 722005 728616 729251 729253 732865 735799 735828 737598 745998 749340 751390 752840 755057 758259 758292 765812 768059 768681 771272 775815 775958 781488 791003 793510 793601 796577 799636 800726 801292 801326 801810 803960 804428 810467 812239 812242 813797 814166 817613 817881 824000 824438 826296 ] |
||||||||||||||||||||||||||||||
|
16.84 ms (8.87%) |
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 581929 729251 634218 732865 639818 647995 650817 678032 800726 810467 826296 817881 618309 793510 583913 813797 709913 550196 570179 600012 639345 699401 585143 555055 718766 749340 801292 647948 639334 600360 599865 666409 814166 758259 675019 555154 557411 633502 637413 664602 768059 677674 729253 553273 637741 550199 718745 668555 597873 617414 613958 771272 728616 722005 812242 781488 704582 630531 824000 517539 579866 591503 704248 599915 642002 637116 542442 553692 812239 735799 768681 804428 550124 550205 647885 639802 775958 554841 678780 799636 542722 737598 714551 752840 569379 758292 824438 591476 608047 793601 717147 642705 817613 520879 791003 745998 801810 640156 541207 599961 803960 801326 796577 710026 755057 775815 635275 566973 580868 666991 765812 735828 751390 540577 550128 716878 601584 600268 630553 641644 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.58%) |
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 517539 520879 540577 541207 542442 542722 550124 550128 550196 550199 550205 553273 553692 554841 555055 555154 557411 566973 569379 570179 579866 580868 581929 583913 585143 591476 591503 597873 599865 599915 599961 600012 600268 600360 601584 608047 613958 617414 618309 630531 630553 633502 634218 635275 637116 637413 637741 639334 639345 639802 639818 640156 641644 642002 642705 647885 647948 647995 650817 664602 666409 666991 668555 675019 677674 678032 678780 699401 704248 704582 709913 710026 714551 716878 717147 718745 718766 722005 728616 729251 729253 732865 735799 735828 737598 745998 749340 751390 752840 755057 758259 758292 765812 768059 768681 771272 775815 775958 781488 791003 793510 793601 796577 799636 800726 801292 801326 801810 803960 804428 810467 812239 812242 813797 814166 817613 817881 824000 824438 826296 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг сиськ milf"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss tits milf"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"писсинг сиськ milf"
]
|
||||||||||||||||||||||||||||||
|
1.58 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.