Query Metrics
7
Database Queries
7
Different statements
145.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.69 ms (82.01%) |
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 400508 404693 406646 412966 415112 415836 418416 421884 428158 432081 436933 438001 439579 439616 439649 439668 439783 442968 447614 448083 448922 449904 450544 450847 451861 456706 458220 458986 459382 459406 465367 467162 469469 472904 477454 483144 484478 484499 488011 489548 490763 492322 495406 498038 499103 500480 508094 508485 508487 510112 511508 513189 513474 515800 518028 519169 521772 523125 523806 524688 524858 525046 526819 527270 527573 527808 528081 530025 530757 530768 532753 533471 533760 536214 536687 536766 536789 537174 538676 544862 547366 550099 556014 558614 562373 564825 565528 565983 568053 568580 573429 575716 577409 587257 589553 590542 591595 594370 596739 597028 598849 601114 601828 606508 622401 623618 628409 630540 633312 634510 637023 647847 680118 696204 710524 716030 717852 726487 732878 821370 ] |
||||||||||||||||||||||||||||||
|
16.99 ms (11.64%) |
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 508094 527573 489548 510112 511508 521772 524688 484499 515800 518028 527808 499103 523125 527270 404693 406646 438001 415836 428158 439783 436933 821370 459406 469469 484478 451861 447614 448922 519169 526819 537174 538676 530768 500480 524858 533760 530025 472904 544862 547366 565983 573429 647847 717852 589553 598849 601114 622401 637023 628409 634510 601828 623618 732878 633312 716030 412966 432081 449904 458986 400508 421884 439579 456706 439616 439668 442968 450544 458220 448083 465367 459382 477454 528081 488011 508485 483144 490763 495406 513474 523806 450847 492322 532753 498038 530757 513189 525046 533471 536214 536766 508487 536687 536789 550099 558614 568053 562373 564825 577409 568580 696204 680118 710524 556014 565528 575716 606508 630540 597028 590542 594370 587257 591595 596739 726487 415112 439649 467162 418416 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.63%) |
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 400508 404693 406646 412966 415112 415836 418416 421884 428158 432081 436933 438001 439579 439616 439649 439668 439783 442968 447614 448083 448922 449904 450544 450847 451861 456706 458220 458986 459382 459406 465367 467162 469469 472904 477454 483144 484478 484499 488011 489548 490763 492322 495406 498038 499103 500480 508094 508485 508487 510112 511508 513189 513474 515800 518028 519169 521772 523125 523806 524688 524858 525046 526819 527270 527573 527808 528081 530025 530757 530768 532753 533471 533760 536214 536687 536766 536789 537174 538676 544862 547366 550099 556014 558614 562373 564825 565528 565983 568053 568580 573429 575716 577409 587257 589553 590542 591595 594370 596739 597028 598849 601114 601828 606508 622401 623618 628409 630540 633312 634510 637023 647847 680118 696204 710524 716030 717852 726487 732878 821370 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old cum in"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old cum"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old cum"
]
|
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.