Query Metrics
7
Database Queries
7
Different statements
249.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
221.67 ms (88.99%) |
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 207775 249590 338116 370928 381994 382316 383464 384457 391221 391264 391419 395227 396843 397935 417123 422414 423605 431593 434430 435413 436530 437564 441159 441691 449854 459055 460362 474039 475607 477067 486981 487973 488299 501384 510907 518641 523331 529115 540248 540427 542700 552709 553094 555439 571785 573411 575010 577087 582944 583510 586135 586505 590087 591837 595224 595283 595300 595378 599645 604464 612068 630329 635351 637313 660346 666993 667751 670821 693680 696071 700506 702343 707127 721872 724120 725095 726081 728548 733070 733232 734293 735939 739749 742828 748051 748620 750873 756629 756898 757276 757994 758754 759179 760249 761531 761764 761936 764693 767604 767758 768197 776161 784808 787380 789402 793871 794185 794396 796374 797709 800523 800891 803371 803860 805189 809015 813156 813467 813562 826681 ] |
||||||||||||||||||||||||||||||
|
16.81 ms (6.75%) |
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 761764 726081 734293 742828 748620 758754 761936 735939 756629 756898 768197 635351 702343 721872 797709 370928 477067 391221 441159 249590 422414 487973 488299 338116 382316 391264 396843 417123 441691 437564 813562 826681 475607 449854 529115 540427 523331 518641 542700 553094 555439 583510 552709 575010 666993 667751 700506 696071 660346 693680 707127 586505 637313 586135 590087 604464 591837 595378 599645 595224 595283 595300 630329 776161 789402 794185 805189 800523 813467 725095 728548 757276 761531 796374 803860 813156 733232 759179 760249 764693 767758 724120 739749 748051 750873 757994 767604 733070 784808 787380 793871 794396 800891 803371 809015 207775 459055 431593 474039 436530 510907 540248 577087 571785 582944 670821 573411 612068 434430 460362 486981 501384 383464 384457 395227 381994 391419 397935 423605 435413 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (1.33%) |
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 207775 249590 338116 370928 381994 382316 383464 384457 391221 391264 391419 395227 396843 397935 417123 422414 423605 431593 434430 435413 436530 437564 441159 441691 449854 459055 460362 474039 475607 477067 486981 487973 488299 501384 510907 518641 523331 529115 540248 540427 542700 552709 553094 555439 571785 573411 575010 577087 582944 583510 586135 586505 590087 591837 595224 595283 595300 595378 599645 604464 612068 630329 635351 637313 660346 666993 667751 670821 693680 696071 700506 702343 707127 721872 724120 725095 726081 728548 733070 733232 734293 735939 739749 742828 748051 748620 750873 756629 756898 757276 757994 758754 759179 760249 761531 761764 761936 764693 767604 767758 768197 776161 784808 787380 789402 793871 794185 794396 796374 797709 800523 800891 803371 803860 805189 809015 813156 813467 813562 826681 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding creampie creampie"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding creampie creampie"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding creampie creampie"
]
|
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.