Query Metrics
7
Database Queries
7
Different statements
184.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.49 ms (86.86%) |
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 384400 395565 411052 416924 427634 479914 491004 495553 514483 529179 533599 544125 547940 550664 566561 568992 571095 574076 576490 579255 579376 579725 580129 581594 582010 582744 583232 585420 587215 589824 591530 591759 598950 599672 609644 614601 616099 628559 633535 648437 653987 660842 662147 662213 666473 685106 693796 694379 694751 695096 696115 706057 710571 711354 714565 715258 726805 729339 732787 733337 733437 734259 735502 736017 738001 741523 743355 745072 745301 745715 746135 746471 749430 749567 751805 753775 754321 755343 756289 759316 764122 765423 765640 772507 772609 773326 774674 777792 782404 783218 784794 785255 787526 789054 793494 796942 801364 804444 804696 804702 806109 807604 808183 808540 809002 809548 810092 810646 810808 813108 814188 814378 814676 817743 818117 818686 819058 823499 824532 827968 ] |
||||||||||||||||||||||||||||||
|
13.61 ms (7.37%) |
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 628559 732787 733437 745301 749430 814188 817743 818117 818686 819058 583232 568992 582744 582010 653987 693796 579725 616099 598950 585420 784794 787526 789054 804702 808540 810646 793494 746135 772609 734259 751805 745072 735502 755343 782404 808183 810092 411052 614601 529179 823499 544125 566561 694379 662147 706057 711354 571095 591759 599672 804444 783218 743355 796942 807604 813108 749567 745715 759316 764122 753775 765423 773326 633535 714565 774674 777792 495553 384400 416924 427634 814676 491004 533599 514483 579255 579376 694751 648437 666473 660842 662213 685106 587215 591530 801364 809002 809548 729339 785255 804696 754321 765640 772507 741523 609644 479914 395565 574076 715258 696115 738001 756289 710571 814378 824532 827968 576490 547940 550664 581594 695096 580129 589824 806109 810808 726805 736017 733337 746471 ] |
||||||||||||||||||||||||||||||
|
4.00 ms (2.17%) |
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 384400 395565 411052 416924 427634 479914 491004 495553 514483 529179 533599 544125 547940 550664 566561 568992 571095 574076 576490 579255 579376 579725 580129 581594 582010 582744 583232 585420 587215 589824 591530 591759 598950 599672 609644 614601 616099 628559 633535 648437 653987 660842 662147 662213 666473 685106 693796 694379 694751 695096 696115 706057 710571 711354 714565 715258 726805 729339 732787 733337 733437 734259 735502 736017 738001 741523 743355 745072 745301 745715 746135 746471 749430 749567 751805 753775 754321 755343 756289 759316 764122 765423 765640 772507 772609 773326 774674 777792 782404 783218 784794 785255 787526 789054 793494 796942 801364 804444 804696 804702 806109 807604 808183 808540 809002 809548 810092 810646 810808 813108 814188 814378 814676 817743 818117 818686 819058 823499 824532 827968 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big masturbating"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие masturbating"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие masturbating"
]
|
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.