Query Metrics
7
Database Queries
7
Different statements
353.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.79 ms (59.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс студентк русск"
]
|
||||||||||||||||||||||||||||||
|
124.10 ms (35.10%) |
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 338113 385113 385287 389158 389779 392814 396757 408425 408489 408796 413092 414194 421635 423676 431758 435785 436476 438912 444229 445808 448662 451756 453609 453642 455109 458322 466106 466187 472095 474228 475775 479564 479615 482078 486933 492674 495529 497575 500400 509701 512715 517548 518942 522655 525938 530956 542876 542959 547253 548713 552193 557326 561843 561895 567336 570186 571633 572129 575508 578387 578997 586666 588677 597584 597600 598007 598017 598797 599481 609643 609679 612578 618428 620845 624649 625639 657642 661255 661258 661289 663166 697885 700941 718719 722326 722830 724834 735848 736342 736962 743527 745075 746157 747113 747705 748368 753836 753854 753908 754182 760288 761655 761824 763977 764615 766472 773418 773805 778743 779894 780871 781041 782605 790272 798868 803639 808380 811153 812440 ] |
||||||||||||||||||||||||||||||
|
12.99 ms (3.67%) |
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 760288 763977 724834 761824 764615 722326 385113 700941 745075 497575 389779 575508 413092 455109 661289 753836 445808 661258 781041 385287 561843 697885 599481 803639 448662 408425 436476 598017 597600 753908 753854 754182 766472 479564 542876 552193 572129 548713 567336 588677 761655 389158 451756 479615 421635 500400 525938 517548 530956 542959 597584 808380 414194 466187 474228 396757 438912 518942 444229 661255 657642 547253 618428 586666 736342 746157 773805 736962 748368 771059 609679 612578 620845 624649 782605 392814 408796 453642 578387 509701 522655 570186 722830 557326 609643 625639 778743 779894 790272 811153 812440 798868 735848 743527 747113 747705 773418 718719 780871 472095 338113 598007 598797 492674 512715 495529 466106 475775 408489 458322 435785 571633 431758 453609 486933 561895 663166 578997 482078 423676 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (0.72%) |
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 338113 385113 385287 389158 389779 392814 396757 408425 408489 408796 413092 414194 421635 423676 431758 435785 436476 438912 444229 445808 448662 451756 453609 453642 455109 458322 466106 466187 472095 474228 475775 479564 479615 482078 486933 492674 495529 497575 500400 509701 512715 517548 518942 522655 525938 530956 542876 542959 547253 548713 552193 557326 561843 561895 567336 570186 571633 572129 575508 578387 578997 586666 588677 597584 597600 598007 598017 598797 599481 609643 609679 612578 618428 620845 624649 625639 657642 661255 661258 661289 663166 697885 700941 718719 722326 722830 724834 735848 736342 736962 743527 745075 746157 747113 747705 748368 753836 753854 753908 754182 760288 761655 761824 763977 764615 766472 773418 773805 778743 779894 780871 781041 782605 790272 798868 803639 808380 811153 812440 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ÐüðÁð║Ðü ÐüÐéÐâð┤ðÁð¢Ðéð║ð© ÐÇÐâÐüÐüð║ðÔÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.44%) |
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.