Query Metrics
7
Database Queries
7
Different statements
149.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.82 ms (83.49%) |
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 386765 396389 398440 406339 406621 417097 420101 421550 422922 426250 430969 433964 441961 442131 444546 445258 448219 448235 448616 452915 453618 456110 459796 461317 461520 461584 463132 466172 468577 472477 473546 476372 480933 487496 491487 494361 494698 495027 498093 500780 500782 502722 505038 506021 510838 511726 511738 511740 513281 513292 521068 523042 526122 527518 527529 527542 528609 528946 529048 538348 539540 541530 542680 543835 544050 546781 548778 557523 558042 560375 565042 565069 566029 566970 571710 573786 574880 575521 576027 577953 585995 588861 590683 594224 598399 598998 599418 603893 607328 607714 610714 614474 628362 631137 644186 647023 647815 652187 652358 653520 670336 671296 675815 684731 686845 687271 695898 709118 711006 722909 730098 733841 733845 776869 777081 789638 797610 806842 810524 813460 ] |
||||||||||||||||||||||||||||||
|
14.76 ms (9.87%) |
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 417097 421550 452915 456110 448219 466172 526122 529048 494698 498093 527529 538348 558042 560375 565069 571710 541530 557523 565042 573786 652187 670336 647815 684731 709118 722909 671296 675815 686845 695898 546781 566029 575521 598399 607328 631137 610714 789638 806842 810524 813460 733841 733845 711006 777081 797610 453618 461317 430969 433964 445258 459796 406339 461520 444546 461584 472477 513292 500782 511740 521068 527542 513281 528609 386765 396389 426250 441961 422922 442131 463132 448235 523042 510838 527518 539540 494361 506021 542680 543835 566970 574880 576027 544050 577953 647023 652358 653520 687271 548778 585995 614474 588861 590683 599418 607714 644186 594224 598998 603893 628362 776869 730098 476372 420101 480933 468577 473546 487496 511726 495027 500780 502722 505038 511738 398440 406621 491487 448616 528946 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.95%) |
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 386765 396389 398440 406339 406621 417097 420101 421550 422922 426250 430969 433964 441961 442131 444546 445258 448219 448235 448616 452915 453618 456110 459796 461317 461520 461584 463132 466172 468577 472477 473546 476372 480933 487496 491487 494361 494698 495027 498093 500780 500782 502722 505038 506021 510838 511726 511738 511740 513281 513292 521068 523042 526122 527518 527529 527542 528609 528946 529048 538348 539540 541530 542680 543835 544050 546781 548778 557523 558042 560375 565042 565069 566029 566970 571710 573786 574880 575521 576027 577953 585995 588861 590683 594224 598399 598998 599418 603893 607328 607714 610714 614474 628362 631137 644186 647023 647815 652187 652358 653520 670336 671296 675815 684731 686845 687271 695898 709118 711006 722909 730098 733841 733845 776869 777081 789638 797610 806842 810524 813460 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shy teens"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"shy teens"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"shy teens"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.08%) |
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.