Query Metrics
7
Database Queries
7
Different statements
160.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.99 ms (85.36%) |
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 154442 396471 413196 495535 506414 510648 528256 534211 558254 560751 575152 576070 579124 583738 590196 596986 601090 613438 615769 617295 634649 635521 652551 660558 661957 664795 669328 676666 684965 685668 686326 687458 690415 690443 691227 691601 691621 701127 701872 702757 705647 706638 713429 715353 715468 716384 717824 718895 719373 720557 723867 723875 724705 725722 727627 729230 730967 731575 735674 736179 742204 743157 744327 744801 753788 755095 757872 758924 766285 769358 771352 771762 771785 772429 773126 773569 778247 779371 783864 783968 787428 788122 788222 789788 795381 800540 800780 800830 801597 801739 803201 803576 803874 807372 809980 812410 813195 813768 813937 816155 818287 818417 818682 819973 820342 821144 822259 823353 824361 824603 824761 825087 825719 826171 826737 828346 828352 828626 ] |
||||||||||||||||||||||||||||||
|
12.89 ms (8.03%) |
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 813195 413196 154442 813937 818417 819973 823353 825719 528256 495535 506414 560751 652551 687458 690415 717824 660558 661957 690443 718895 719373 617295 634649 590196 601090 788222 789788 795381 800830 803576 809980 727627 772429 783864 783968 771762 723867 744327 771785 771352 742204 701872 702757 779371 788122 801739 826737 828626 575152 558254 715353 684965 778247 800540 755095 766285 769358 757872 773126 743157 812410 510648 396471 816155 818287 824761 825087 818682 820342 813768 824361 824603 821144 822259 826171 828346 828093 828352 534211 669328 686326 701127 706638 713429 715468 685668 691621 664795 676666 691227 691601 705647 716384 720557 576070 579124 583738 635521 613438 596986 615769 787428 803201 800780 801597 731575 736179 744801 758924 803874 807372 724705 725722 753788 770353 773569 723875 735674 729230 730967 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.96%) |
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 154442 396471 413196 495535 506414 510648 528256 534211 558254 560751 575152 576070 579124 583738 590196 596986 601090 613438 615769 617295 634649 635521 652551 660558 661957 664795 669328 676666 684965 685668 686326 687458 690415 690443 691227 691601 691621 701127 701872 702757 705647 706638 713429 715353 715468 716384 717824 718895 719373 720557 723867 723875 724705 725722 727627 729230 730967 731575 735674 736179 742204 743157 744327 744801 753788 755095 757872 758924 766285 769358 771352 771762 771785 772429 773126 773569 778247 779371 783864 783968 787428 788122 788222 789788 795381 800540 800780 800830 801597 801739 803201 803576 803874 807372 809980 812410 813195 813768 813937 816155 818287 818417 818682 819973 820342 821144 822259 823353 824361 824603 824761 825087 825719 826171 826737 828346 828352 828626 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucks девушк"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucks girl"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucks девушк"
]
|
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.