Query Metrics
7
Database Queries
7
Different statements
136.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.34 ms (84.57%) |
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 33689 61635 185458 391002 395141 395547 395620 401968 407396 409117 411937 413299 414160 417429 443963 444834 449097 485691 486314 504354 515171 531494 541882 544688 548533 577350 578103 581393 601172 606956 609780 611250 612207 615796 623338 623473 624854 625866 628331 630015 631550 635228 637589 651621 664274 665027 665108 665116 668176 678947 683382 683460 684217 685840 686792 688322 694129 694188 694436 695804 714156 715509 717760 718190 718236 718889 721120 722914 727698 727804 730369 732425 734611 736400 736598 737151 737381 737390 737395 737401 741616 742031 742610 744290 752168 753134 759582 760034 761592 763349 765904 765996 766026 770114 773897 776915 781708 788816 796123 799016 800959 802836 803267 804201 804689 806246 807459 807998 808102 808173 813047 814721 814803 815740 816485 818512 819043 820945 822813 ] |
||||||||||||||||||||||||||||||
|
12.62 ms (9.25%) |
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 718889 651621 678947 684217 688322 694436 714156 717760 664274 686792 694188 721120 609780 623473 631550 635228 630015 606956 806246 736598 737381 737395 752168 759582 763349 765996 766026 781708 802836 734611 741616 770114 730369 736400 737390 628331 804201 804689 807998 401968 411937 444834 504354 486314 665116 668176 665108 624854 443963 515171 485691 185458 395141 33689 391002 814721 822813 820945 814803 815740 819043 816485 818512 827902 531494 581393 548533 541882 544688 665027 685840 694129 695804 683382 683460 718236 722914 718190 578103 601172 637589 611250 612207 615796 803267 807459 808173 813047 727698 760034 761592 788816 808102 727804 732425 742031 765904 742610 737151 737401 744290 773897 753134 623338 625866 715509 776915 796123 799016 800959 413299 449097 61635 407396 417429 409117 577350 395547 395620 414160 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.80%) |
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 33689 61635 185458 391002 395141 395547 395620 401968 407396 409117 411937 413299 414160 417429 443963 444834 449097 485691 486314 504354 515171 531494 541882 544688 548533 577350 578103 581393 601172 606956 609780 611250 612207 615796 623338 623473 624854 625866 628331 630015 631550 635228 637589 651621 664274 665027 665108 665116 668176 678947 683382 683460 684217 685840 686792 688322 694129 694188 694436 695804 714156 715509 717760 718190 718236 718889 721120 722914 727698 727804 730369 732425 734611 736400 736598 737151 737381 737390 737395 737401 741616 742031 742610 744290 752168 753134 759582 760034 761592 763349 765904 765996 766026 770114 773897 776915 781708 788816 796123 799016 800959 802836 803267 804201 804689 806246 807459 807998 808102 808173 813047 814721 814803 815740 816485 818512 819043 820945 822813 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs old man"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs old мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs old мужчин"
]
|
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.