Query Metrics
7
Database Queries
7
Different statements
140.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.09 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 190876 358603 392439 395729 401303 411220 411721 425195 440694 443187 444911 445846 447806 455698 459922 462181 463394 464278 467216 469990 481390 481997 489924 504038 512223 525751 525988 531319 537577 538767 539342 539570 539773 542499 542876 549140 550779 559653 562021 574255 579945 584054 598368 599628 619261 619601 621634 622557 628507 629603 641322 645543 646712 652315 653117 666376 671251 675230 677738 681422 685041 691592 691723 698921 701817 702862 705238 707401 707419 708005 710143 710191 712791 714597 714605 718620 720543 721502 722162 724482 726764 729053 730190 730562 730628 730839 732202 734439 735783 737252 740664 740703 742277 742284 743019 746885 746934 747247 749475 755458 760265 770394 786639 788629 795059 815874 816621 816980 818464 820365 820472 820491 820591 821283 821744 825259 825959 826203 827102 827484 ] |
||||||||||||||||||||||||||||||
|
12.42 ms (8.82%) |
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 531319 549140 574255 579945 559653 562021 550779 685041 707401 707419 710143 718620 691592 701817 708005 671251 681422 705238 720543 599628 621634 619601 622557 726764 737252 740703 742277 746934 770394 729053 730562 742284 724482 392439 358603 411220 440694 444911 443187 827484 445846 447806 464278 489924 455698 459922 481390 525988 539342 538767 469990 542876 710191 411721 462181 463394 467216 481997 190876 395729 401303 425195 504038 525751 512223 816980 820472 827102 821283 815874 818464 539570 677738 702862 721502 675230 628507 641322 795059 735783 730628 730839 734439 788629 816621 820365 820591 825959 821744 826203 820491 825259 539773 537577 542499 584054 646712 698921 645543 652315 653117 666376 691723 714605 712791 714597 722162 598368 619261 629603 730190 732202 749475 786639 746885 743019 747247 760265 740664 755458 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.67%) |
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 190876 358603 392439 395729 401303 411220 411721 425195 440694 443187 444911 445846 447806 455698 459922 462181 463394 464278 467216 469990 481390 481997 489924 504038 512223 525751 525988 531319 537577 538767 539342 539570 539773 542499 542876 549140 550779 559653 562021 574255 579945 584054 598368 599628 619261 619601 621634 622557 628507 629603 641322 645543 646712 652315 653117 666376 671251 675230 677738 681422 685041 691592 691723 698921 701817 702862 705238 707401 707419 708005 710143 710191 712791 714597 714605 718620 720543 721502 722162 724482 726764 729053 730190 730562 730628 730839 732202 734439 735783 737252 740664 740703 742277 742284 743019 746885 746934 747247 749475 755458 760265 770394 786639 788629 795059 815874 816621 816980 818464 820365 820472 820491 820591 821283 821744 825259 825959 826203 827102 827484 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy cock"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая cock"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая cock"
]
|
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.