Query Metrics
7
Database Queries
7
Different statements
144.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.27 ms (85.52%) |
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 6056 14392 130022 383288 389987 393673 396368 396606 401252 405446 413786 416226 430467 443424 446752 449032 459668 459830 461757 465190 465710 476111 477472 488894 495407 501589 531530 533476 536227 536966 537497 537896 551552 557877 560223 562502 563278 583371 601756 604172 605590 607436 622682 629279 631086 634207 637103 642727 643050 644000 646001 648587 649092 665338 665361 665932 666779 668157 671409 673540 675007 675022 675425 676116 682220 682275 699425 707360 715251 716435 717076 719391 719915 722491 723357 723512 726633 731371 733586 739752 741682 742964 743851 746470 746794 747144 749043 759725 770120 773866 773870 776244 781773 781811 792803 795482 796282 798215 800870 801511 801515 802978 805554 809209 809458 813121 815812 816685 816832 817093 818490 823758 823983 825951 826173 826231 828115 828369 ] |
||||||||||||||||||||||||||||||
|
11.32 ms (7.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 488894 14392 396368 476111 6056 825951 828369 816832 823983 648587 716435 682220 666779 601756 781773 792803 743851 770120 396606 707360 604172 537497 130022 393673 401252 665932 815812 533476 676116 531530 537896 637103 634207 675007 501589 405446 816685 430467 461757 646001 643050 383288 823758 826173 551552 801515 801511 749043 773870 795482 667269 622682 560223 741682 746794 776244 668157 731371 465710 459830 446752 536227 563278 719391 605590 465190 665361 733586 746470 562502 607436 828115 800870 817093 536966 443424 673540 557877 449032 583371 826231 818490 649092 719915 665338 666827 671409 682275 717076 722491 723357 629279 644000 809458 813121 796282 798215 773866 809209 759725 739752 726633 675425 675022 742964 802978 477472 699425 631086 781811 642727 723512 805554 747144 389987 413786 416226 459668 495407 715251 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.92%) |
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 6056 14392 130022 383288 389987 393673 396368 396606 401252 405446 413786 416226 430467 443424 446752 449032 459668 459830 461757 465190 465710 476111 477472 488894 495407 501589 531530 533476 536227 536966 537497 537896 551552 557877 560223 562502 563278 583371 601756 604172 605590 607436 622682 629279 631086 634207 637103 642727 643050 644000 646001 648587 649092 665338 665361 665932 666779 668157 671409 673540 675007 675022 675425 676116 682220 682275 699425 707360 715251 716435 717076 719391 719915 722491 723357 723512 726633 731371 733586 739752 741682 742964 743851 746470 746794 747144 749043 759725 770120 773866 773870 776244 781773 781811 792803 795482 796282 798215 800870 801511 801515 802978 805554 809209 809458 813121 815812 816685 816832 817093 818490 823758 823983 825951 826173 826231 828115 828369 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits interracial"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.99%) |
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.