Query Metrics
7
Database Queries
7
Different statements
391.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.67 ms (53.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большой большие член латинская"
]
|
||||||||||||||||||||||||||||||
|
160.52 ms (41.02%) |
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 21478 31604 192951 320786 370875 373905 382488 384811 387604 388224 392266 392928 394768 394772 394874 395273 395310 398230 403458 403476 403495 403543 404664 406080 406281 407322 408206 410452 411895 414209 415476 416092 419150 420131 426612 429278 445554 446697 450673 451827 452380 454642 454948 460011 462914 463726 464601 464926 465034 469105 473459 475993 476600 479874 485616 486698 487972 488324 492065 493278 505061 506352 509729 514381 516848 520256 525144 525896 528700 530059 530574 532487 533029 533475 536828 536861 536911 545269 547066 550062 555754 569124 592238 597757 629610 632936 635124 642634 665902 720206 724556 726826 729975 731694 740526 750691 752407 755759 762820 788248 799312 804968 810225 810227 810624 812821 812825 813112 813693 814651 814719 820950 821997 822246 822653 822885 823118 823200 825377 ] |
||||||||||||||||||||||||||||||
|
15.02 ms (3.84%) |
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 729975 762820 530574 476600 629610 810624 384811 394768 395310 392266 320786 21478 403476 403458 406080 416092 429278 823200 473459 487972 454948 460011 493278 505061 509729 530059 533475 506352 525896 532487 536828 463726 469105 547066 812825 750691 426612 415476 525144 812821 814651 822246 814719 813693 822885 820950 665902 642634 592238 597757 799312 632936 31604 465034 545269 810227 775033 752407 731694 395273 408206 446697 479874 488324 492065 462914 536911 724556 419150 420131 410452 804968 394874 569124 403543 822653 823118 821997 373905 394772 450673 514381 825377 398230 720206 536861 516848 635124 406281 392928 192951 370875 388224 387604 404664 411895 414209 445554 454642 486698 451827 464601 485616 475993 520256 528700 533029 755759 452380 464926 403495 555754 550062 726826 382488 813112 407322 810225 788248 740526 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (0.70%) |
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 21478 31604 192951 320786 370875 373905 382488 384811 387604 388224 392266 392928 394768 394772 394874 395273 395310 398230 403458 403476 403495 403543 404664 406080 406281 407322 408206 410452 411895 414209 415476 416092 419150 420131 426612 429278 445554 446697 450673 451827 452380 454642 454948 460011 462914 463726 464601 464926 465034 469105 473459 475993 476600 479874 485616 486698 487972 488324 492065 493278 505061 506352 509729 514381 516848 520256 525144 525896 528700 530059 530574 532487 533029 533475 536828 536861 536911 545269 547066 550062 555754 569124 592238 597757 629610 632936 635124 642634 665902 720206 724556 726826 729975 731694 740526 750691 752407 755759 762820 788248 799312 804968 810225 810227 810624 812821 812825 813112 813693 814651 814719 820950 821997 822246 822653 822885 823118 823200 825377 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dick latina"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.