Query Metrics
7
Database Queries
7
Different statements
355.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
332.85 ms (93.65%) |
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 12792 29902 167822 185606 399152 401824 412539 412571 421121 427433 431488 434271 437842 446378 447491 447774 453486 459433 461971 465214 477392 478313 488008 501358 505462 508268 511172 512580 518323 521697 525787 529190 533256 539483 541374 542244 548239 550489 552580 553317 557824 559199 563019 564230 569077 569446 575219 579617 582398 588128 589067 590898 592522 595208 602836 610510 622632 628515 629665 644421 650983 659974 665945 672490 677055 687554 693374 693385 697474 697988 700269 702311 707605 710407 712271 719286 721188 723629 730507 736834 739060 750042 753257 754186 757466 763887 763955 767360 768280 768378 776548 780174 781001 784464 785142 787002 789175 795146 795148 795909 796442 798089 798677 798954 799091 801856 801889 803248 803877 804993 806878 806883 810886 811552 815269 816376 818057 821922 822825 826763 ] |
||||||||||||||||||||||||||||||
|
12.31 ms (3.46%) |
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 763887 702311 803877 804993 447774 446378 505462 511172 512580 521697 579617 628515 798677 447491 459433 501358 518323 167822 29902 421121 434271 818057 826763 815269 821922 477392 529190 461971 542244 700269 721188 697474 719286 693374 697988 563019 569446 644421 610510 589067 785142 795146 798954 801856 784464 789175 795148 798089 806878 730507 750042 768378 763955 736834 754186 757466 768280 712271 780174 787002 799091 399152 478313 412571 437842 488008 185606 12792 401824 431488 427433 412539 822825 723629 816376 453486 465214 533256 539483 525787 508268 541374 550489 559199 569077 575219 553317 582398 548239 552580 659974 665945 672490 707605 650983 677055 710407 687554 693385 557824 564230 590898 595208 622632 629665 588128 592522 602836 776548 781001 803248 811552 801889 806883 810886 739060 753257 767360 795909 796442 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (0.86%) |
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 12792 29902 167822 185606 399152 401824 412539 412571 421121 427433 431488 434271 437842 446378 447491 447774 453486 459433 461971 465214 477392 478313 488008 501358 505462 508268 511172 512580 518323 521697 525787 529190 533256 539483 541374 542244 548239 550489 552580 553317 557824 559199 563019 564230 569077 569446 575219 579617 582398 588128 589067 590898 592522 595208 602836 610510 622632 628515 629665 644421 650983 659974 665945 672490 677055 687554 693374 693385 697474 697988 700269 702311 707605 710407 712271 719286 721188 723629 730507 736834 739060 750042 753257 754186 757466 763887 763955 767360 768280 768378 776548 780174 781001 784464 785142 787002 789175 795146 795148 795909 796442 798089 798677 798954 799091 801856 801889 803248 803877 804993 806878 806883 810886 811552 815269 816376 818057 821922 822825 826763 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"best pussy"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"best pussy"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.26 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"best pussy"
]
|
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.