Query Metrics
7
Database Queries
7
Different statements
608.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.95 ms (35.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рот в рот"
]
|
||||||||||||||||||||||||||||||
|
209.49 ms (34.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"рот в рот"
]
|
||||||||||||||||||||||||||||||
|
163.52 ms (26.87%) |
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 16870 78536 96462 97191 156014 233677 249630 281380 350861 381742 383164 383553 387533 397106 398017 398989 402381 415537 426551 432312 461474 465234 495162 505795 507285 511564 515302 535808 537212 544258 545409 545763 549386 550442 562061 568796 570704 573800 577356 592127 601677 625519 628371 630026 630866 633649 659424 666895 675182 679774 695122 705786 712359 714360 716621 724874 725782 728633 729255 730717 731277 731429 733190 733272 734408 735534 735890 736500 736891 738343 739253 739981 740862 745357 746725 747825 749827 753641 755596 763002 763108 763573 765034 767801 768151 768974 769221 772307 775075 777817 777961 777993 779781 779783 779923 781034 781090 782691 783706 783724 783748 783831 784056 786754 787222 787253 787258 787392 787543 790254 790594 790705 791519 794146 794784 794988 795846 810161 810216 ] |
||||||||||||||||||||||||||||||
|
12.85 ms (2.11%) |
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 775075 777993 779781 779783 787392 794146 781034 781090 783831 787543 790254 728633 730717 733272 739253 740862 746725 762249 763573 782691 787253 787258 790705 794988 795846 810161 731277 745357 747825 755596 768974 769221 738343 739981 765034 733190 734408 735534 735890 763002 763108 767801 731429 736891 630026 633649 712359 714360 777961 784056 787222 790594 810216 233677 383164 383553 398017 415537 402381 535808 505795 511564 507285 562061 577356 568796 545763 570704 666895 695122 573800 630866 625519 537212 545409 679774 601677 628371 426551 550442 465234 78536 249630 281380 381742 96462 16870 387533 397106 398989 495162 544258 705786 716621 659424 675182 549386 592127 783724 791519 779923 783706 794784 724874 772307 753641 736500 729255 749827 725782 768151 777817 783748 786754 97191 350861 156014 432312 461474 515302 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рот в рот"
]
|
||||||||||||||||||||||||||||||
|
2.38 ms (0.39%) |
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 16870 78536 96462 97191 156014 233677 249630 281380 350861 381742 383164 383553 387533 397106 398017 398989 402381 415537 426551 432312 461474 465234 495162 505795 507285 511564 515302 535808 537212 544258 545409 545763 549386 550442 562061 568796 570704 573800 577356 592127 601677 625519 628371 630026 630866 633649 659424 666895 675182 679774 695122 705786 712359 714360 716621 724874 725782 728633 729255 730717 731277 731429 733190 733272 734408 735534 735890 736500 736891 738343 739253 739981 740862 745357 746725 747825 749827 753641 755596 763002 763108 763573 765034 767801 768151 768974 769221 772307 775075 777817 777961 777993 779781 779783 779923 781034 781090 782691 783706 783724 783748 783831 784056 786754 787222 787253 787258 787392 787543 790254 790594 790705 791519 794146 794784 794988 795846 810161 810216 ] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.