Query Metrics
7
Database Queries
7
Different statements
147.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.61 ms (84.66%) |
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 370949 395889 400513 406882 407054 413175 414317 418069 418073 418079 421862 421872 422171 424118 424274 425462 426940 430228 433362 439713 439753 439798 439809 443348 445060 445065 446522 446967 448751 448996 449622 449623 451456 453660 457468 464337 468934 470980 474780 474783 478377 480246 481937 482556 485061 488749 490413 493156 496346 510296 513194 514273 514275 516140 516236 519825 520679 520792 524896 527779 529209 546116 546119 547834 549507 553972 556021 560021 561588 569408 569415 569972 573739 573760 578037 582591 589682 591010 591664 592938 599524 621492 626866 633529 673992 678734 687561 691626 703900 720120 726753 732482 773850 782593 784080 784776 786460 788289 788295 788881 790874 792531 792660 793886 797909 799262 799585 800936 801173 801363 803297 805331 807479 809482 810292 812585 812891 813917 815410 820330 ] |
||||||||||||||||||||||||||||||
|
13.24 ms (9.00%) |
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 449623 480246 446522 496346 516236 439798 439713 422171 395889 414317 813917 820330 474783 470980 446967 464337 553972 578037 546116 569972 573739 687561 678734 673992 691626 547834 556021 560021 626866 633529 591010 591664 592938 621492 589682 599524 782593 784776 786460 801363 805331 812585 788289 788881 790874 793886 797909 809482 773850 784080 788295 792531 792660 799262 799585 800936 801173 810292 812891 726753 732482 703900 720120 803297 807479 433362 448751 457468 481937 421862 424118 425462 439809 443348 449622 421872 424274 426940 448996 474780 400513 418069 418073 439753 478377 406882 430228 513194 493156 514273 516140 520792 529209 490413 514275 485061 569415 524896 370949 407054 413175 445065 418079 445060 815410 453660 488749 451456 468934 482556 510296 519825 520679 527779 546119 569408 549507 561588 573760 582591 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.89%) |
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 370949 395889 400513 406882 407054 413175 414317 418069 418073 418079 421862 421872 422171 424118 424274 425462 426940 430228 433362 439713 439753 439798 439809 443348 445060 445065 446522 446967 448751 448996 449622 449623 451456 453660 457468 464337 468934 470980 474780 474783 478377 480246 481937 482556 485061 488749 490413 493156 496346 510296 513194 514273 514275 516140 516236 519825 520679 520792 524896 527779 529209 546116 546119 547834 549507 553972 556021 560021 561588 569408 569415 569972 573739 573760 578037 582591 589682 591010 591664 592938 599524 621492 626866 633529 673992 678734 687561 691626 703900 720120 726753 732482 773850 782593 784080 784776 786460 788289 788295 788881 790874 792531 792660 793886 797909 799262 799585 800936 801173 801363 803297 805331 807479 809482 810292 812585 812891 813917 815410 820330 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom and stepson"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom stepson"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.25 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom stepson"
]
|
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.