Query Metrics
7
Database Queries
7
Different statements
203.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.70 ms (88.86%) |
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 549502 554948 555573 561150 563412 568086 569871 570641 570851 571159 571390 572746 572796 578979 580050 583652 585804 585845 586422 587243 587723 588147 589276 589330 589702 590463 591955 593263 595679 595743 595800 596182 596587 596995 598587 598611 598728 599445 600319 600516 600874 603727 605145 605316 605625 607084 607092 610693 614019 614183 616745 618375 620305 621652 621811 622996 640522 650760 653245 654419 654810 654819 654844 655068 655718 655752 656728 656786 657309 657426 657642 657931 658008 658094 658323 658409 658682 659150 659567 659569 659587 659622 660140 660289 660496 660934 661255 661693 661698 662519 662533 663176 664976 665221 665931 667242 667789 668996 669708 670033 670495 671120 673218 674903 676529 679060 679062 682929 686035 695551 698101 702432 713840 714438 716000 716006 716502 720848 722888 723428 ] |
||||||||||||||||||||||||||||||
|
11.89 ms (5.85%) |
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 657931 658094 659150 659587 659622 660496 661255 662533 663176 667789 670033 674903 686035 695551 713840 714438 720848 650760 653245 654819 655068 656786 657426 658409 658682 659567 659569 660289 662519 664976 665221 667242 668996 671120 673218 676529 679060 679062 682929 702432 722888 654419 654810 654844 655718 655752 656728 657309 657642 658008 658323 660140 660934 661693 661698 665931 669708 670495 698101 716000 716006 716502 723428 549502 554948 555573 561150 563412 568086 569871 570641 570851 571159 571390 572746 572796 578979 580050 583652 586422 587243 589702 590463 596182 599445 600319 600874 607092 610693 614019 616745 620305 622996 640522 585845 587723 588147 589276 589330 591955 595679 595743 595800 596587 598728 600516 603727 605145 605316 605625 607084 614183 618375 621652 621811 585804 593263 596995 598587 598611 ] |
||||||||||||||||||||||||||||||
|
3.76 ms (1.85%) |
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 549502 554948 555573 561150 563412 568086 569871 570641 570851 571159 571390 572746 572796 578979 580050 583652 585804 585845 586422 587243 587723 588147 589276 589330 589702 590463 591955 593263 595679 595743 595800 596182 596587 596995 598587 598611 598728 599445 600319 600516 600874 603727 605145 605316 605625 607084 607092 610693 614019 614183 616745 618375 620305 621652 621811 622996 640522 650760 653245 654419 654810 654819 654844 655068 655718 655752 656728 656786 657309 657426 657642 657931 658008 658094 658323 658409 658682 659150 659567 659569 659587 659622 660140 660289 660496 660934 661255 661693 661698 662519 662533 663176 664976 665221 665931 667242 667789 668996 669708 670033 670495 671120 673218 674903 676529 679060 679062 682929 686035 695551 698101 702432 713840 714438 716000 716006 716502 720848 722888 723428 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hair ass"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hair жоп"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hair жоп"
]
|
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.