Query Metrics
7
Database Queries
7
Different statements
170.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.30 ms (82.33%) |
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 238715 330409 385454 389766 392558 393042 404394 495884 529682 531391 531704 533269 534015 535349 536823 536973 536976 537765 538733 539528 540519 542878 543427 547092 547252 550486 550552 551024 553212 555164 567125 567953 570693 570893 584400 584864 585295 587457 595848 602271 616963 636926 637549 642640 642903 645259 645533 646040 647770 652563 663552 668556 668827 670069 670716 671875 685114 695594 696265 698213 698353 701018 701230 712621 713411 718400 726996 728906 730949 731347 732658 734596 737429 745567 746347 748088 748102 748627 753067 760969 761405 764086 768783 771145 771695 779147 780735 783732 787901 789644 790935 792244 796498 796785 799783 799823 810545 817764 818853 819316 820748 823933 824658 825108 825409 825456 825460 825615 825822 826183 826255 826445 826536 826551 826820 828148 828248 828495 ] |
||||||||||||||||||||||||||||||
|
18.01 ms (10.57%) |
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 540519 531391 536823 535349 542878 570893 652563 663552 695594 547252 595848 783732 787901 792244 799783 730949 748088 760969 771145 771695 731347 732658 790935 238715 796785 761405 385454 392558 330409 764086 389766 826228 825822 825108 826255 825409 826183 826551 828248 828148 828495 551024 780735 796498 728906 745567 393042 637549 671875 567953 534015 495884 531704 533269 536976 584864 547092 550552 646040 645259 647770 701018 712621 645533 668556 685114 696265 698213 713411 718400 567125 587457 636926 642903 585295 642640 602271 616963 748627 810545 698353 670069 537765 555164 553212 570693 668827 404394 824658 825456 825460 826536 817764 819316 826820 818853 820748 825386 825615 826445 823933 529682 536973 538733 539528 550486 543427 670716 701230 584400 789644 779147 746347 768783 799823 734596 748102 753067 726996 737429 ] |
||||||||||||||||||||||||||||||
|
4.01 ms (2.35%) |
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 238715 330409 385454 389766 392558 393042 404394 495884 529682 531391 531704 533269 534015 535349 536823 536973 536976 537765 538733 539528 540519 542878 543427 547092 547252 550486 550552 551024 553212 555164 567125 567953 570693 570893 584400 584864 585295 587457 595848 602271 616963 636926 637549 642640 642903 645259 645533 646040 647770 652563 663552 668556 668827 670069 670716 671875 685114 695594 696265 698213 698353 701018 701230 712621 713411 718400 726996 728906 730949 731347 732658 734596 737429 745567 746347 748088 748102 748627 753067 760969 761405 764086 768783 771145 771695 779147 780735 783732 787901 789644 790935 792244 796498 796785 799783 799823 810545 817764 818853 819316 820748 823933 824658 825108 825409 825456 825460 825615 825822 826183 826255 826445 826536 826551 826820 828148 828248 828495 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая любительск"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette amateur"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.