Query Metrics
7
Database Queries
7
Different statements
146.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.74 ms (82.26%) |
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 383046 385794 397138 400450 401958 404059 416870 444142 470839 472439 512041 515110 547869 559909 567215 595363 599548 613287 618870 623338 623473 624850 626742 627171 641077 654602 657097 657376 660515 660942 663477 667562 671340 671670 681482 683341 683567 685655 685687 696976 696978 702892 710001 710957 712929 715509 717699 718416 719203 720484 722664 722914 724431 725564 728008 729024 729743 729928 730859 741646 742192 744290 744303 744309 744324 744698 744984 748140 748145 748171 748392 748643 755252 755780 759439 759599 761171 762195 765140 766026 768120 770917 773071 775999 776488 781708 787922 788710 788816 790158 799788 803331 803342 805191 807333 808102 808173 808280 812084 812148 813388 814068 814122 814721 816258 816826 817900 818905 819617 819698 820699 821178 821456 822097 822178 822718 822828 824146 824999 826734 ] |
||||||||||||||||||||||||||||||
|
14.47 ms (9.86%) |
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 404059 472439 470839 814721 722914 599548 808173 748140 788816 808102 744290 623338 715509 385794 814068 822097 818905 820699 824146 824999 515110 654602 657097 660515 660942 683341 696978 720484 657376 663477 667562 671670 712929 547869 788710 799788 803331 787922 805191 762195 728008 744303 729928 768120 744309 744984 748643 696976 416870 641077 725564 744698 512041 817900 826734 819698 821178 821456 816258 819617 822178 822718 671340 685655 702892 710957 717699 618870 626742 803342 759439 770917 773071 790158 808280 812148 724431 761171 742192 755780 729743 730859 748145 722664 624850 744324 400450 816826 710001 719203 813388 759599 627171 776488 444142 623473 807333 781708 383046 822828 567215 681482 718416 729024 766026 765140 755252 748392 613287 401958 397138 814122 559909 683567 685687 595363 775999 812084 741646 748171 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (2.30%) |
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 383046 385794 397138 400450 401958 404059 416870 444142 470839 472439 512041 515110 547869 559909 567215 595363 599548 613287 618870 623338 623473 624850 626742 627171 641077 654602 657097 657376 660515 660942 663477 667562 671340 671670 681482 683341 683567 685655 685687 696976 696978 702892 710001 710957 712929 715509 717699 718416 719203 720484 722664 722914 724431 725564 728008 729024 729743 729928 730859 741646 742192 744290 744303 744309 744324 744698 744984 748140 748145 748171 748392 748643 755252 755780 759439 759599 761171 762195 765140 766026 768120 770917 773071 775999 776488 781708 787922 788710 788816 790158 799788 803331 803342 805191 807333 808102 808173 808280 812084 812148 813388 814068 814122 814721 816258 816826 817900 818905 819617 819698 820699 821178 821456 822097 822178 822718 822828 824146 824999 826734 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits young girls"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ young девушк"
]
|
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.