Query Metrics
7
Database Queries
7
Different statements
168.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.29 ms (86.58%) |
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 422475 450103 453431 454699 475789 489459 493119 493297 496315 500958 514891 517050 517441 517536 517823 518785 526342 529115 531906 533679 537302 538103 544427 545030 558404 565686 577486 579131 590365 591420 591598 591944 592656 592937 593648 595051 595224 595283 596191 600902 602635 604307 604884 605440 614331 616832 621041 622319 626128 632144 636504 639801 641267 642176 646085 660403 661991 667328 667751 670254 675999 680740 680777 688181 695701 695707 703944 705101 710250 712634 714097 722369 724020 724318 725130 725484 725504 730819 732220 736887 739278 740094 740129 740847 746344 752454 756986 759882 759895 760100 760249 760538 761015 761036 761594 769517 776161 778018 784970 786718 793810 794176 795980 796194 796395 796422 796702 797499 797792 798429 799140 799848 800372 800767 801107 802746 803726 803854 807316 811679 ] |
||||||||||||||||||||||||||||||
|
13.27 ms (7.85%) |
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 422475 454699 475789 493119 453431 450103 489459 517050 517536 517823 526342 529115 533679 496315 500958 518785 514891 537302 538103 517441 531906 493297 545030 558404 544427 565686 579131 667751 680777 688181 695701 703944 710250 714097 722369 646085 667328 670254 680740 695707 705101 712634 660403 661991 675999 577486 591598 591944 595051 639801 641267 592656 593648 602635 622319 626128 632144 636504 590365 591420 592937 596191 600902 605440 642176 595224 595283 604307 604884 614331 616832 621041 776161 784970 793810 799140 801107 807316 778018 786718 796395 797499 797792 798429 800767 803854 725130 725484 730819 739278 740094 740847 746344 759895 760100 761594 794176 795980 796194 796422 796702 799848 800372 802746 803726 811679 732220 736887 740129 752454 756986 759882 760249 760538 761015 761036 769517 724020 724318 725504 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.53%) |
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 422475 450103 453431 454699 475789 489459 493119 493297 496315 500958 514891 517050 517441 517536 517823 518785 526342 529115 531906 533679 537302 538103 544427 545030 558404 565686 577486 579131 590365 591420 591598 591944 592656 592937 593648 595051 595224 595283 596191 600902 602635 604307 604884 605440 614331 616832 621041 622319 626128 632144 636504 639801 641267 642176 646085 660403 661991 667328 667751 670254 675999 680740 680777 688181 695701 695707 703944 705101 710250 712634 714097 722369 724020 724318 725130 725484 725504 730819 732220 736887 739278 740094 740129 740847 746344 752454 756986 759882 759895 760100 760249 760538 761015 761036 761594 769517 776161 778018 784970 786718 793810 794176 795980 796194 796395 796422 796702 797499 797792 798429 799140 799848 800372 800767 801107 802746 803726 803854 807316 811679 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с большой жопой"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.88%) |
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.